Slide Menu
Search Help Show/Hide Menu

Item Identification

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

This entity records the question answer pairs that are selected during a debriefing evaluation.

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 records the question answer pairs that are selected during a debriefing evaluation.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key EVALUATION_SEQ NUMBER Sequence generated evaluation linking a cruise to a set of question answer pairs.
100
QUESTION_SEQ NUMBER Sequence generated unique identifier for a debriefing evaluation answer, applied here as a FK to ols_eval_quest_ans.
100
ANSWER_SEQ NUMBER Sequence generated unique identifier for a debriefing evaluation, applied here as a FK to ols_eval_quest_ans
100
CRUISE NUMBER Sequence generated cruise number.
100
EVALUATION_COMMENT VARCHAR2 Free form comments

Attribute Details

EVALUATION_SEQ

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

Sequence generated evaluation linking a cruise to a set of question answer pairs.

General Data Type: NUMBER

QUESTION_SEQ

CC ID: 65139
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 identifier for a debriefing evaluation answer, applied here as a FK to ols_eval_quest_ans.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_EVAL_QUEST_ANS

ANSWER_SEQ

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

Sequence generated unique identifier for a debriefing evaluation, applied here as a FK to ols_eval_quest_ans

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_EVAL_QUEST_ANS

CRUISE

CC ID: 65141
Seq. Order: 4
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

EVALUATION_COMMENT

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

Free form comments

General Data Type: VARCHAR2

Catalog Details

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