Table: VERS_VESSEL_ASSOCIATES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34250 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table contains associate and vessel relationships
DescriptionTable contains associate and vessel relationships
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
VWA_USERNAME
VARCHAR2 |
Username or associate ID |
FV_AP_NUM
NUMBER |
Vessel's federal permit application number |
VVA_BEGIN_DATE
DATE |
Begin date (local) of the vessel/associate relationship |
VVA_END_DATE
DATE |
End date (local) of the vessel/associate relationship |
VAST_ASSOCIATE_TYPE
VARCHAR2 |
Associate relationship to the vessel (see VERS_ASSOCIATE_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_VESSEL_ASSOCIATES |
---|---|
Short Name: | VERS_VESSEL_ASSOCIATES |
Status: | Completed |
Abstract: |
Table contains associate and vessel 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 associate and vessel relationships |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
VWA_USERNAME | VARCHAR2 | Username or associate ID | |
100
|
FV_AP_NUM | NUMBER | Vessel's federal permit application number | |
100
|
VVA_BEGIN_DATE | DATE | Begin date (local) of the vessel/associate relationship | |
100
|
VVA_END_DATE | DATE | End date (local) of the vessel/associate relationship | |
100
|
VAST_ASSOCIATE_TYPE | VARCHAR2 | Associate relationship to the vessel (see VERS_ASSOCIATE_TYPES) |
Attribute Details
VWA_USERNAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Username or associate ID |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.VERS_WEB_ACCOUNTS |
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 |
VVA_BEGIN_DATE
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Begin date (local) of the vessel/associate relationship |
General Data Type: | DATE |
VVA_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/associate relationship |
General Data Type: | DATE |
VAST_ASSOCIATE_TYPE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Associate relationship to the vessel (see VERS_ASSOCIATE_TYPES) |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.VERS_ASSOCIATE_TYPES |
Catalog Details
Catalog Item ID: | 34250 |
---|---|
GUID: | gov.noaa.nmfs.inport:34250 |
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 |