Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

Table: OBPROGRAM

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33348  |  Updated: August 9, 2022  |  Published / External 
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