Slide Menu
Search Help Show/Hide Menu

Item Identification

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

This entity Combines the question text to a set and subset for presentation to the debriefer.

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 Combines the question text to a set and subset for presentation to the debriefer.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key QUESTION_SEQ NUMBER Sequence generated unique identifier for a debriefing evaluation question.
100
QUESTION_NUMBER NUMBER Presentation order of the questions
100
QUESTION_TEXT_SEQ NUMBER Sequence generated unique identifier of an evaluation question
100
QUESTION_SUBSET_SEQ NUMBER Sequence generated unique identifier of a question subset record.
100
QUESTION_SET_SEQ NUMBER Sequence generated unique identifier of a question set record
100
ACTIVE_FLAG VARCHAR2 Binary identifier of whether the question is available to the evaluation or not

Attribute Details

QUESTION_SEQ

CC ID: 65184
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 for a debriefing evaluation question.

General Data Type: NUMBER

QUESTION_NUMBER

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

Presentation order of the questions

General Data Type: NUMBER

QUESTION_TEXT_SEQ

CC ID: 65186
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 of an evaluation question

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_QUESTION_TEXT

QUESTION_SUBSET_SEQ

CC ID: 65187
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 a question subset record.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_QUESTION_SUBSET

QUESTION_SET_SEQ

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

Sequence generated unique identifier of a question set record

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_LOV_QUESTION_SET

ACTIVE_FLAG

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

Binary identifier of whether the question is available to the evaluation or not

General Data Type: VARCHAR2

Catalog Details

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