Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > AFSC/FMA/Observer Declare and Deploy (Resturctu... >

Table: ODDS_TRIP_WAIVER

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

Summary

Description

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

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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