Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_PROGRAMS

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34244  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table lists all past and current programs used for electronic data collection; END_DATE=(null) signifies an active program

Description

Table lists all past and current programs used for electronic data collection; END_DATE=(null) signifies an active program

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PROGRAM_CODE
VARCHAR2 		Program code
PROGRAM_DESCR
VARCHAR2 		Program code description
PROGRAM_METADATA
VARCHAR2 		Additional information relevant to the program
BEGIN_DATE
DATE 		Begin date (local) of the program configuration for data collection
END_DATE
DATE 		End date (local) of the program configuration for data collection
FRE_REPORT_SOURCE
VARCHAR2 		Resolution of the data reported using the program code (subtrip or haul-by-haul)
VPT_PROGRAM_TYPE
VARCHAR2 		Program type code (see VERS_PROGRAM_TYPES)

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: VERS_PROGRAMS
Short Name: VERS_PROGRAMS
Status: Completed
Abstract:

Table lists all past and current programs used for electronic data collection; END_DATE=(null) signifies an active program
Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

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

Table lists all past and current programs used for electronic data collection; END_DATE=(null) signifies an active program

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PROGRAM_CODE VARCHAR2 Program code
100
 PROGRAM_DESCR VARCHAR2 Program code description
100
 PROGRAM_METADATA VARCHAR2 Additional information relevant to the program
100
 BEGIN_DATE DATE Begin date (local) of the program configuration for data collection
100
 END_DATE DATE End date (local) of the program configuration for data collection
100
 FRE_REPORT_SOURCE VARCHAR2 Resolution of the data reported using the program code (subtrip or haul-by-haul)
100
 VPT_PROGRAM_TYPE VARCHAR2 Program type code (see VERS_PROGRAM_TYPES)

Attribute Details

PROGRAM_CODE

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

Program code
General Data Type: VARCHAR2

PROGRAM_DESCR

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

Program code description
General Data Type: VARCHAR2

PROGRAM_METADATA

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

Additional information relevant to the program
General Data Type: VARCHAR2

BEGIN_DATE

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

Begin date (local) of the program configuration for data collection
General Data Type: DATE

END_DATE

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

End date (local) of the program configuration for data collection
General Data Type: DATE

FRE_REPORT_SOURCE

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

Resolution of the data reported using the program code (subtrip or haul-by-haul)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_REPORT_SOURCES

VPT_PROGRAM_TYPE

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

Program type code (see VERS_PROGRAM_TYPES)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_PROGRAM_TYPES

Catalog Details

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