18867
Table: ODDS_TRIP_WAIVER
ODDS_TRIP_WAIVER
Entity
Published / External
18871
AFSC/FMA/Observer Declare and Deploy (Resturcture)
Data Set
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
Information on the request for an observed trip waiver by the observer provider and if it was approved
1
TRIP_WAIVER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique sequence for a trip log waiver
NUMBER
2
TRIP_PLAN_LOG_SEQ
NUMBER
22
Yes
No
9
0
Active
parent trip log seq number
NUMBER
NORPAC.ODDS_TRIP_PLAN_LOG
3
WAIVER_STATUS_SEQ
NUMBER
22
No
No
9
0
Active
FK link to odds_lov_waiver_status
NUMBER
NORPAC.ODDS_LOV_WAIVER_STATUS
4
WAIVER_REQUEST_DATE_TIME
DATE
7
Yes
No
Active
Date - time user requested a waiver for an observed trip
DATE
5
WAIVER_REQUEST_BY
NUMBER
22
Yes
No
38
0
Active
User making the waiver request
NUMBER
6
REQUEST_COMMENT
CLOB
4000
No
No
Active
Waiver request comment
CLOB
7
ACCEPT_DENY_DATE
DATE
7
No
No
Active
Date - time waiver was accepted or denied.
DATE
8
ACCEPT_DENY_BY
NUMBER
22
No
No
9
0
Active
user accepting or denying the waiver
NUMBER
9
WAIVER_RESPONSE_COMMENT
CLOB
4000
No
No
Active
Comments concerning the response to waiver request.
CLOB
gov.noaa.nmfs.inport:18867
Doug Turnbull
2013-04-30T18:33:22
SysAdmin InPortAdmin
2022-08-09T17:11:08
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18