Table: OLS_EVAL_QUEST_ANS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12287 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
ANSWER_SEQ | NUMBER | Sequence generated unique identifier for a debriefing evaluation answer, applied here as a FK to ols_lov_answer. |
|
100
|
|
QUESTION_SEQ | NUMBER | Sequence generated unique identifier for a debriefing evaluation question, applied here as a FK to ols_lov_question. |
|
100
|
ACTIVE_FLAG | VARCHAR2 | Binary identifier of whether the question is available to the evaluation or not. When set to N, this supresses all instances of this question and its set of answers that exist in ols_eval_quest_ans object from the GUI presentation layer. |
Attribute Details
ANSWER_SEQ
CC ID: 65155
| 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 answer, applied here as a FK to ols_lov_answer. |
| General Data Type: | NUMBER |
| Foreign Key Relations: |
NORPAC.OLS_LOV_ANSWER |
QUESTION_SEQ
CC ID: 65156
| 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 identifier for a debriefing evaluation question, applied here as a FK to ols_lov_question. |
| General Data Type: | NUMBER |
| Foreign Key Relations: |
NORPAC.OLS_LOV_QUESTION |
ACTIVE_FLAG
CC ID: 65157
| Seq. Order: | 3 |
|---|---|
| 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. When set to N, this supresses all instances of this question and its set of answers that exist in ols_eval_quest_ans object from the GUI presentation layer. |
| General Data Type: | VARCHAR2 |