Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/Observer Logistics System (OLS) >

Table: OLS_DEBRIEFING_SCHEDULE

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12286 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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.

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.

Entity Type
Data Table

Data Attribute / Type	Description
SCHEDULE_SEQ NUMBER	Sequence generated unique identifie for a debriefing schedule event.
CRUISE NUMBER	Sequence generated cruise number.
LOCATION_CODE VARCHAR2	Three Letter Alpha code identifying the location at which an observer debriefing is scheduled.
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.
DEBRIEFER_STAFF_ID NUMBER	staff member conducting the debriefing
CHECK_IN_STAFF_ID NUMBER	staff id who checked in observer for debriefing
CHECK_IN_DATE DATE	date observer was checked in for debriefing
SCHEDULED_DEBRIEF_DATE DATE	Date that the observer registers to begin the vessel and observer surveys
DEBRIEF_START_DATE DATE	Date recorded by the assigned debriefer as Date debriefing started
DEBRIEF_END_DATE DATE	date the debriefing evaluation was completed
DEBRIEFING_COMPLETION_DATE DATE	Date that this debriefing process was completed.
OBSERVER_RELEASE_DATE DATE	Date that the observer was released regardless of debriefing status.

Data Attribute / Type

Description

SCHEDULE_SEQ
NUMBER

Sequence generated unique identifie for a debriefing schedule event.

CRUISE
NUMBER

Sequence generated cruise number.

LOCATION_CODE
VARCHAR2

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

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.

DEBRIEFER_STAFF_ID
NUMBER

staff member conducting the debriefing

CHECK_IN_STAFF_ID
NUMBER

staff id who checked in observer for debriefing

CHECK_IN_DATE
DATE

date observer was checked in for debriefing

SCHEDULED_DEBRIEF_DATE
DATE

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

DEBRIEF_START_DATE
DATE

Date recorded by the assigned debriefer as Date debriefing started

DEBRIEF_END_DATE
DATE

date the debriefing evaluation was completed

DEBRIEFING_COMPLETION_DATE
DATE

Date that this debriefing process was completed.

OBSERVER_RELEASE_DATE
DATE

Date that the observer was released regardless of debriefing status.

No Child Items for this record.

No contact information is available for this record.

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

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 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.

Attribute Summary

	Name	Type	Description
100	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.

Name

Type

Description

100

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 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

Table: OLS_DEBRIEFING_SCHEDULE

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SCHEDULE_SEQ

CRUISE

LOCATION_CODE

SCHEDULER_STAFF_ID

DEBRIEFER_STAFF_ID

CHECK_IN_STAFF_ID

CHECK_IN_DATE

SCHEDULED_DEBRIEF_DATE

DEBRIEF_START_DATE

DEBRIEF_END_DATE

DEBRIEFING_COMPLETION_DATE

OBSERVER_RELEASE_DATE

Catalog Details