Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Program Code Support Table

Description

Observer Program Code Support Table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PROGRAM
VARCHAR2
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
PROGNAME
VARCHAR2
Name that describes program identified in program.
PROGDESC
VARCHAR2
Description of program code.
STUDYSPECIES
VARCHAR2
Target species for study if any in program identified by program code.
STUDYGEAR
VARCHAR2
Gear used in the study identified by program code.
BIOSAMPPROTCOL
VARCHAR2
Description of biosample protocol used for this program code.
ACCESSROLES
VARCHAR2
ORACLE roles with access to the program data.
STUDYDATES
VARCHAR2
Dates that the study identified by the program code covers.
CONTRACTOR
VARCHAR2
Contractor used on the program indicated.
PARTNER
VARCHAR2
Partner organization if any; may be university or state department.
NECCONTACT
VARCHAR2
Either the COTR for the contract or NEFSC person responsible for data.
PROGCOMMENTS
VARCHAR2
Additional information for program code or description
DOE
DATE
Date of Entry of the associated record.
UOE
VARCHAR2
Oracle user ID of the person who entered the data.
DOC
DATE
Date associated record was updated.
UOC
VARCHAR2
Oracle ID of user who made the (most recent ) change on the record.
PROGNAMEABB
VARCHAR2
Program name abbreviation

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: OBPROGRAM
Short Name: OBPROGRAM
Status: Completed
Abstract:

Observer Program Code Support Table

Notes:

Loaded by batch 8950, 07-06-2016 08:24

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer Program Code Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
PROGNAME VARCHAR2 Name that describes program identified in program.
100
PROGDESC VARCHAR2 Description of program code.
100
STUDYSPECIES VARCHAR2 Target species for study if any in program identified by program code.
100
STUDYGEAR VARCHAR2 Gear used in the study identified by program code.
100
BIOSAMPPROTCOL VARCHAR2 Description of biosample protocol used for this program code.
100
ACCESSROLES VARCHAR2 ORACLE roles with access to the program data.
100
STUDYDATES VARCHAR2 Dates that the study identified by the program code covers.
100
CONTRACTOR VARCHAR2 Contractor used on the program indicated.
100
PARTNER VARCHAR2 Partner organization if any; may be university or state department.
100
NECCONTACT VARCHAR2 Either the COTR for the contract or NEFSC person responsible for data.
100
PROGCOMMENTS VARCHAR2 Additional information for program code or description
100
DOE DATE Date of Entry of the associated record.
100
UOE VARCHAR2 Oracle user ID of the person who entered the data.
100
DOC DATE Date associated record was updated.
100
UOC VARCHAR2 Oracle ID of user who made the (most recent ) change on the record.
100
PROGNAMEABB VARCHAR2 Program name abbreviation

Attribute Details

PROGRAM

CC ID: 331143
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

General Data Type: VARCHAR2

PROGNAME

CC ID: 331152
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Name that describes program identified in program.

General Data Type: VARCHAR2

PROGDESC

CC ID: 331153
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

Description of program code.

General Data Type: VARCHAR2

STUDYSPECIES

CC ID: 331154
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Target species for study if any in program identified by program code.

General Data Type: VARCHAR2

STUDYGEAR

CC ID: 331155
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Gear used in the study identified by program code.

General Data Type: VARCHAR2

BIOSAMPPROTCOL

CC ID: 331156
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Description of biosample protocol used for this program code.

General Data Type: VARCHAR2

ACCESSROLES

CC ID: 331157
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

ORACLE roles with access to the program data.

General Data Type: VARCHAR2

STUDYDATES

CC ID: 331158
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Dates that the study identified by the program code covers.

General Data Type: VARCHAR2

CONTRACTOR

CC ID: 331159
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Contractor used on the program indicated.

General Data Type: VARCHAR2

PARTNER

CC ID: 331144
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Partner organization if any; may be university or state department.

General Data Type: VARCHAR2

NECCONTACT

CC ID: 331145
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Either the COTR for the contract or NEFSC person responsible for data.

General Data Type: VARCHAR2

PROGCOMMENTS

CC ID: 331146
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Additional information for program code or description

General Data Type: VARCHAR2

DOE

CC ID: 331147
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of Entry of the associated record.

General Data Type: DATE

UOE

CC ID: 331148
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Oracle user ID of the person who entered the data.

General Data Type: VARCHAR2

DOC

CC ID: 331149
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date associated record was updated.

General Data Type: DATE

UOC

CC ID: 331150
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Oracle ID of user who made the (most recent ) change on the record.

General Data Type: VARCHAR2

PROGNAMEABB

CC ID: 331151
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Program name abbreviation

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33348
GUID: gov.noaa.nmfs.inport:33348
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28