Table: OLS_DEBRIEFING_EVALUATION
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12285 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |