Slide Menu
Search Help Show/Hide Menu

Item Identification

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

If an observer provider is unable to supply an observer for a fishing trip which has been declared observed. A waiver to the observed trip may be requested. Acceptance or rejection of the waiver request is executed by NMFS staff. This entity represents the list of valid values for the status of the requested waiver.

Notes:

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

Entity Information

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

If an observer provider is unable to supply an observer for a fishing trip which has been declared observed. A waiver to the observed trip may be requested. Acceptance or rejection of the waiver request is executed by NMFS staff. This entity represents the list of valid values for the status of the requested waiver.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key WAIVER_STATUS_SEQ NUMBER Sequence generated unique identifier for a waiver status record.
100
WAIVER_STATUS_CODE VARCHAR2 Unique Alpha code representing the status of an observer waiver request.
100
DESCRIPTION VARCHAR2 Descriptive text of the meaning of an observer waiver status code.

Attribute Details

WAIVER_STATUS_SEQ

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

Sequence generated unique identifier for a waiver status record.

General Data Type: NUMBER

WAIVER_STATUS_CODE

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

Unique Alpha code representing the status of an observer waiver request.

General Data Type: VARCHAR2

DESCRIPTION

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

Descriptive text of the meaning of an observer waiver status code.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 18861
GUID: gov.noaa.nmfs.inport:18861
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: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18