Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: ODDS_TRIP_WAIVER
Short Name: ODDS_TRIP_WAIVER
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:

Information on the request for an observed trip waiver by the observer provider and if it was approved

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_WAIVER_SEQ NUMBER unique sequence for a trip log waiver
100
TRIP_PLAN_LOG_SEQ NUMBER parent trip log seq number
100
WAIVER_STATUS_SEQ NUMBER FK link to odds_lov_waiver_status
100
WAIVER_REQUEST_DATE_TIME DATE Date - time user requested a waiver for an observed trip
100
WAIVER_REQUEST_BY NUMBER User making the waiver request
100
REQUEST_COMMENT CLOB Waiver request comment
100
ACCEPT_DENY_DATE DATE Date - time waiver was accepted or denied.
100
ACCEPT_DENY_BY NUMBER user accepting or denying the waiver
100
WAIVER_RESPONSE_COMMENT CLOB Comments concerning the response to waiver request.

Attribute Details

TRIP_WAIVER_SEQ

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

unique sequence for a trip log waiver

General Data Type: NUMBER

TRIP_PLAN_LOG_SEQ

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

parent trip log seq number

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_TRIP_PLAN_LOG

WAIVER_STATUS_SEQ

CC ID: 108125
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

FK link to odds_lov_waiver_status

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_WAIVER_STATUS

WAIVER_REQUEST_DATE_TIME

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

Date - time user requested a waiver for an observed trip

General Data Type: DATE

WAIVER_REQUEST_BY

CC ID: 108129
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

User making the waiver request

General Data Type: NUMBER

REQUEST_COMMENT

CC ID: 108130
Seq. Order: 6
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Waiver request comment

General Data Type: CLOB

ACCEPT_DENY_DATE

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

Date - time waiver was accepted or denied.

General Data Type: DATE

ACCEPT_DENY_BY

CC ID: 108132
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

user accepting or denying the waiver

General Data Type: NUMBER

WAIVER_RESPONSE_COMMENT

CC ID: 108133
Seq. Order: 9
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comments concerning the response to waiver request.

General Data Type: CLOB

Catalog Details

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