Table: VERS_ASSOCIATES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34231 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table lists all past and current VERS associates (vessel owners, operators, sector managers, fleet managers, field technicians, system administrators)
DescriptionTable lists all past and current VERS associates (vessel owners, operators, sector managers, fleet managers, field technicians, system administrators)
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
LAST_NAME
VARCHAR2 |
Last name of vessel associate |
FIRST_NAME
VARCHAR2 |
First name of vessel associate |
MIDDLE_NAME
VARCHAR2 |
Middle name or middle initial of vessel associate |
FNE_NAME_EXT
VARCHAR2 |
Surname extension of the vessel associate |
ASSOCIATE_ID
VARCHAR2 |
Unique identifier of the associate |
O_OPERATOR_PERMIT_NUM
NUMBER |
Federal permit number of the operator (null where associate has no operator permit) |
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_ASSOCIATES |
---|---|
Short Name: | VERS_ASSOCIATES |
Status: | Completed |
Abstract: |
Table lists all past and current VERS associates (vessel owners, operators, sector managers, fleet managers, field technicians, system administrators) |
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 VERS associates (vessel owners, operators, sector managers, fleet managers, field technicians, system administrators) |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
LAST_NAME | VARCHAR2 | Last name of vessel associate | |
100
|
FIRST_NAME | VARCHAR2 | First name of vessel associate | |
100
|
MIDDLE_NAME | VARCHAR2 | Middle name or middle initial of vessel associate | |
100
|
FNE_NAME_EXT | VARCHAR2 | Surname extension of the vessel associate | |
100
|
ASSOCIATE_ID | VARCHAR2 | Unique identifier of the associate | |
100
|
O_OPERATOR_PERMIT_NUM | NUMBER | Federal permit number of the operator (null where associate has no operator permit) |
Attribute Details
LAST_NAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last name of vessel associate |
General Data Type: | VARCHAR2 |
FIRST_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
First name of vessel associate |
General Data Type: | VARCHAR2 |
MIDDLE_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Middle name or middle initial of vessel associate |
General Data Type: | VARCHAR2 |
FNE_NAME_EXT
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Surname extension of the vessel associate |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FVTR.FVTR_NAME_EXT |
ASSOCIATE_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unique identifier of the associate |
General Data Type: | VARCHAR2 |
O_OPERATOR_PERMIT_NUM
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Federal permit number of the operator (null where associate has no operator permit) |
General Data Type: | NUMBER |
Foreign Key Relations: |
FVTR.FVTR_OPERATORS |
Catalog Details
Catalog Item ID: | 34231 |
---|---|
GUID: | gov.noaa.nmfs.inport:34231 |
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 |