Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.

Description

An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_PLANT_SEQ
NUMBER
Sequence generated value for an observer deployment record.
SCHEDULE_SEQ
NUMBER
Sequence generated unique identifie for a debriefing schedule event.
SCORE
NUMBER
Each segment of an observer cruise is scored for effectiveness and quality. This attibute represents the intersetion of a debrifing at the cruise level and the vessel or plant on which the observer was deployed.

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: OLS_DEBRIEFED_VESSPLANT
Short Name: OLS_DEBRIEFED_VESSPLANT
Status: Completed
Abstract:

An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.

Notes:

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

Entity Information

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

An observer debriefing may include more than one deployment to a vessel or plant. This entity represents the intersection of the debriefing schedule (which encompasses an entire cruise) with the individual vessels or plants that are being debriefed.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VESSEL_PLANT_SEQ NUMBER Sequence generated value for an observer deployment record.
100
Primary Key SCHEDULE_SEQ NUMBER Sequence generated unique identifie for a debriefing schedule event.
100
SCORE NUMBER Each segment of an observer cruise is scored for effectiveness and quality. This attibute represents the intersetion of a debrifing at the cruise level and the vessel or plant on which the observer was deployed.

Attribute Details

VESSEL_PLANT_SEQ

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

Sequence generated value for an observer deployment record.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_VESSEL_PLANT

SCHEDULE_SEQ

CC ID: 65131
Seq. Order: 2
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
Foreign Key Relations:

NORPAC.OLS_DEBRIEFING_SCHEDULE

SCORE

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

Each segment of an observer cruise is scored for effectiveness and quality. This attibute represents the intersetion of a debrifing at the cruise level and the vessel or plant on which the observer was deployed.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 12283
GUID: gov.noaa.nmfs.inport:12283
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