Slide Menu
Search Help Show/Hide Menu

Item Identification

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

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.

Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

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

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SCHEDULE_SEQ NUMBER Sequence generated unique identifie for a debriefing schedule event.
100
CRUISE NUMBER Sequence generated cruise number.
100
LOCATION_CODE VARCHAR2 Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.
100
SCHEDULER_STAFF_ID NUMBER Sequence generated unique identifier of an employee that scheduled debriefing, here invoked as a foreign key to the OLS_LOV_STAFF table.
100
DEBRIEFER_STAFF_ID NUMBER staff member conducting the debriefing
100
CHECK_IN_STAFF_ID NUMBER staff id who checked in observer for debriefing
100
CHECK_IN_DATE DATE date observer was checked in for debriefing
100
SCHEDULED_DEBRIEF_DATE DATE Date that the observer registers to begin the vessel and observer surveys
100
DEBRIEF_START_DATE DATE Date recorded by the assigned debriefer as Date debriefing started
100
DEBRIEF_END_DATE DATE date the debriefing evaluation was completed
100
DEBRIEFING_COMPLETION_DATE DATE Date that this debriefing process was completed.
100
OBSERVER_RELEASE_DATE DATE Date that the observer was released regardless of debriefing status.

Attribute Details

SCHEDULE_SEQ

CC ID: 65143
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 identifie for a debriefing schedule event.

General Data Type: NUMBER

CRUISE

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

Sequence generated cruise number.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER_CRUISE

LOCATION_CODE

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

Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.

General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.OLS_LOV_LOCATION

SCHEDULER_STAFF_ID

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

Sequence generated unique identifier of an employee that scheduled debriefing, here invoked as a foreign key to the OLS_LOV_STAFF table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF

DEBRIEFER_STAFF_ID

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

staff member conducting the debriefing

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF

CHECK_IN_STAFF_ID

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

staff id who checked in observer for debriefing

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_STAFF

CHECK_IN_DATE

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

date observer was checked in for debriefing

General Data Type: DATE

SCHEDULED_DEBRIEF_DATE

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

Date that the observer registers to begin the vessel and observer surveys

General Data Type: DATE

DEBRIEF_START_DATE

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

Date recorded by the assigned debriefer as Date debriefing started

General Data Type: DATE

DEBRIEF_END_DATE

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

date the debriefing evaluation was completed

General Data Type: DATE

DEBRIEFING_COMPLETION_DATE

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

Date that this debriefing process was completed.

General Data Type: DATE

OBSERVER_RELEASE_DATE

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

Date that the observer was released regardless of debriefing status.

General Data Type: DATE

Catalog Details

Catalog Item ID: 12286
GUID: gov.noaa.nmfs.inport:12286
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26