Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: ODDS_LOV_TRIP_OBS_STATUS
Short Name: ODDS_LOV_TRIP_OBS_STATUS
Status: Completed
Notes:

Loaded by batch 4561, 04-30-2013 18:33

Entity Information

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

List of values for a trip's observer status

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_OBSERVER_SEQ NUMBER unique key for status of the observer coverage to a logged trip.
100
TRIP_OBS_CODE VARCHAR2 Code describing observer coverage for a logged trip
100
DESCRIPTION VARCHAR2 Describes the observer status for a logged trip

Attribute Details

TRIP_OBSERVER_SEQ

CC ID: 108031
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

unique key for status of the observer coverage to a logged trip.

General Data Type: NUMBER

TRIP_OBS_CODE

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

Code describing observer coverage for a logged trip

General Data Type: VARCHAR2

DESCRIPTION

CC ID: 108033
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Describes the observer status for a logged trip

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 18858
GUID: gov.noaa.nmfs.inport:18858
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-04-30 18:33+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-20
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-20
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-20