Search Help Show/Hide Menu
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