Table: OLS_EVAL_QUEST_ANS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12287 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: OLS_EVAL_QUEST_ANS |
|---|---|
| Short Name: | OLS_EVAL_QUEST_ANS |
| Status: | Completed |
| Notes: |
Loaded by batch 3083, 04-19-2012 13:25 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NORPAC |
| Description: |
Ties a question to possible set of answers for a debriefing question |
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 |
Catalog Details
| Catalog Item ID: | 12287 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:12287 |
| 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 |