Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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
Primary Key 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

CC ID: 343948
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

CC ID: 343949
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

CC ID: 343950
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

CC ID: 343946
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

CC ID: 343951
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

CC ID: 343947
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