Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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_COMMENT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12284  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.

Description

Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
COMMENT_SEQ
NUMBER 		Sequence generated unique identifier of debriefer comments during an observer debriefing
SCHEDULE_SEQ
NUMBER 		Sequence generated unique identifie for a debriefing schedule event.
CRUISE
NUMBER 		Cruise number debriefing comment applies to.
CREATED_BY
VARCHAR2 		Oracle User
COMMENTS
CLOB 		Freeform text of a debriefers remarks.

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

Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.
Notes:

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

Entity Information

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

Comments may be recorded by the debriefer about any or all segments included in an observer debriefing. These comments are not constrained except to 4000 characters.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key COMMENT_SEQ NUMBER Sequence generated unique identifier of debriefer comments during an observer debriefing
100
 SCHEDULE_SEQ NUMBER Sequence generated unique identifie for a debriefing schedule event.
100
 CRUISE NUMBER Cruise number debriefing comment applies to.
100
 CREATED_BY VARCHAR2 Oracle User
100
 COMMENTS CLOB Freeform text of a debriefers remarks.

Attribute Details

COMMENT_SEQ

CC ID: 65133
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 identifier of debriefer comments during an observer debriefing
General Data Type: NUMBER

SCHEDULE_SEQ

CC ID: 65134
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
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

CRUISE

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

Cruise number debriefing comment applies to.
General Data Type: NUMBER

CREATED_BY

CC ID: 65136
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle User
General Data Type: VARCHAR2

COMMENTS

CC ID: 65137
Seq. Order: 5
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Freeform text of a debriefers remarks.
General Data Type: CLOB

Catalog Details

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