Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FVTR_TRIP_STATUS_CODES
Short Name: FVTR_TRIP_STATUS_CODES
Status: Completed
Abstract:

Table lists the options used to codify the status of electronically reported trip data after loading and processing

Notes:

Loaded by batch 9190, 08-11-2016 16:37

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FVTR
Description:

Table lists the options used to codify the status of electronically reported trip data after loading and processing

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_STATUS VARCHAR2 Trip status code
100
TRIP_STATUS_DESCR VARCHAR2 Trip status code description
100
STATUS_RANK NUMBER Hierarchical ranking of TRIP_STATUS codes used to identify the current status of a specific trip

Attribute Details

TRIP_STATUS

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

Trip status code

General Data Type: VARCHAR2

TRIP_STATUS_DESCR

CC ID: 344231
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

Trip status code description

General Data Type: VARCHAR2

STATUS_RANK

CC ID: 344232
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Hierarchical ranking of TRIP_STATUS codes used to identify the current status of a specific trip

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34271
GUID: gov.noaa.nmfs.inport:34271
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 16:37+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