Table: VERS_VESSEL_PROGRAMS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34251 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table contains vessel and program relationships
DescriptionTable contains vessel and program relationships
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
VP_PROGRAM_CODE
VARCHAR2 |
Program identfication code (see VERS_PROGRAMS) |
FV_AP_NUM
NUMBER |
Vessel's federal permit application number |
VVP_BEGIN_DATE
DATE |
Begin date (local) when the vessel was associated with the program |
VVP_END_DATE
DATE |
End date (local) of the vessel/program association; null=currently active |
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_VESSEL_PROGRAMS |
---|---|
Short Name: | VERS_VESSEL_PROGRAMS |
Status: | Completed |
Abstract: |
Table contains vessel and program relationships |
Notes: |
Loaded by batch 9189, 08-11-2016 10:02 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FVTR |
Description: |
Table contains vessel and program relationships |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
VP_PROGRAM_CODE | VARCHAR2 | Program identfication code (see VERS_PROGRAMS) | |
100
|
FV_AP_NUM | NUMBER | Vessel's federal permit application number | |
100
|
VVP_BEGIN_DATE | DATE | Begin date (local) when the vessel was associated with the program | |
100
|
VVP_END_DATE | DATE | End date (local) of the vessel/program association; null=currently active |
Attribute Details
VP_PROGRAM_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Program identfication code (see VERS_PROGRAMS) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.VERS_PROGRAMS |
FV_AP_NUM
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 7 |
Scale: | 0 |
Status: | Active |
Description: |
Vessel's federal permit application number |
General Data Type: | NUMBER |
Foreign Key Relations: |
FVTR.FVTR_VESSELS |
VVP_BEGIN_DATE
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Begin date (local) when the vessel was associated with the program |
General Data Type: | DATE |
VVP_END_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End date (local) of the vessel/program association; null=currently active |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 34251 |
---|---|
GUID: | gov.noaa.nmfs.inport:34251 |
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 |