Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_PROGRAM_ASSOCIATES

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34245  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table contains program and associate relationships

Description

Table contains program and associate relationships

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VP_PROGRAM_CODE
VARCHAR2 		Program code (see VERS_PROGRAMS)
VWA_USERNAME
VARCHAR2 		Username or associate ID
VPA_BEGIN_DATE
DATE 		Begin date (local) of the program/associate relationship
VPA_END_DATE
DATE 		End date (local) of the program/associate relationship
VAST_ASSOCIATE_TYPE
VARCHAR2 		Associate type code (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_PROGRAM_ASSOCIATES
Short Name: VERS_PROGRAM_ASSOCIATES
Status: Completed
Abstract:

Table contains program and associate 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 program and associate relationships

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key VP_PROGRAM_CODE VARCHAR2 Program code (see VERS_PROGRAMS)
100
 Primary Key VWA_USERNAME VARCHAR2 Username or associate ID
100
 Primary Key VPA_BEGIN_DATE DATE Begin date (local) of the program/associate relationship
100
 VPA_END_DATE DATE End date (local) of the program/associate relationship
100
 VAST_ASSOCIATE_TYPE VARCHAR2 Associate type code (see VERS_ASSOCIATE_TYPES)

Attribute Details

VP_PROGRAM_CODE

CC ID: 344054
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

Program code (see VERS_PROGRAMS)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_PROGRAMS

VWA_USERNAME

CC ID: 344055
Seq. Order: 2
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

VPA_BEGIN_DATE

CC ID: 344056
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Begin date (local) of the program/associate relationship
General Data Type: DATE

VPA_END_DATE

CC ID: 344057
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End date (local) of the program/associate relationship
General Data Type: DATE

VAST_ASSOCIATE_TYPE

CC ID: 344053
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Associate type code (see VERS_ASSOCIATE_TYPES)
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.VERS_ASSOCIATE_TYPES

Catalog Details

Catalog Item ID: 34245
GUID: gov.noaa.nmfs.inport:34245
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