12286
Table: OLS_DEBRIEFING_SCHEDULE
OLS_DEBRIEFING_SCHEDULE
Entity
Published / External
12269
AFSC/FMA/Observer Logistics System (OLS)
Data Set
Completed
This entity represents the scheduling details of an observer debriefing. Debriefings are for an entire cruise, but have specific references to each plant or vessel of deployment.
Loaded by batch 3083, 04-19-2012 13:25
Data Table
Yes
NORPAC
This entity represents the scheduling details of an observer debriefing. Debriefings are for an entire cruise, but have specific references to each plant or vessel of deployment.
1
SCHEDULE_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifie for a debriefing schedule event.
NUMBER
2
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated cruise number.
NUMBER
NORPAC.OLS_OBSERVER_CRUISE
3
LOCATION_CODE
VARCHAR2
3
Yes
No
Active
Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.
VARCHAR2
NORPAC.OLS_LOV_LOCATION
4
SCHEDULER_STAFF_ID
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier of an employee that scheduled debriefing, here invoked as a foreign key to the OLS_LOV_STAFF table.
NUMBER
NORPAC.OLS_LOV_STAFF
5
DEBRIEFER_STAFF_ID
NUMBER
22
No
No
9
0
Active
staff member conducting the debriefing
NUMBER
NORPAC.OLS_LOV_STAFF
6
CHECK_IN_STAFF_ID
NUMBER
22
No
No
9
0
Active
staff id who checked in observer for debriefing
NUMBER
NORPAC.OLS_LOV_STAFF
7
CHECK_IN_DATE
DATE
7
No
No
Active
date observer was checked in for debriefing
DATE
8
SCHEDULED_DEBRIEF_DATE
DATE
7
Yes
No
Active
Date that the observer registers to begin the vessel and observer surveys
DATE
9
DEBRIEF_START_DATE
DATE
7
No
No
Active
Date recorded by the assigned debriefer as Date debriefing started
DATE
10
DEBRIEF_END_DATE
DATE
7
No
No
Active
date the debriefing evaluation was completed
DATE
11
DEBRIEFING_COMPLETION_DATE
DATE
7
No
No
Active
Date that this debriefing process was completed.
DATE
12
OBSERVER_RELEASE_DATE
DATE
7
No
No
Active
Date that the observer was released regardless of debriefing status.
DATE
gov.noaa.nmfs.inport:12286
Doug Turnbull
2012-04-19T13:25:58
SysAdmin InPortAdmin
2022-08-09T17:11:05
2018-09-26
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
2018-09-26
1 Year
2019-09-26