Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table lists all past and current VERS associates (vessel owners, operators, sector managers, fleet managers, field technicians, system administrators)

Description

Table 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

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