Oracle Fusion · Data dictionary
HRQ_QSTN_RESPONSES
SharedUsed in 0 subject areas18 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Likely primary key: QSTN_RESPONSE_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): QSTNR_QUESTION_ID → HRQ_QSTNR_QUESTIONS · QSTNR_RESPONSE_ID → HRQ_QSTNR_RESPONSES · QSTN_ANSWER_ID → HRQ_QSTN_ANSWERS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ANSWER_CLOB | ● | Answer clob. | |
| ANSWER_COMMENTS | ● | Answer comments. | |
| ANSWER_LIST | ● | Answer list. | |
| ANSWER_TEXT | ● | Answer text. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CHOICE_LIST | ● | Choice list. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| QSTNR_QUESTION_ID | ● | Identifier for the qstnr question. | |
| QSTNR_RESPONSE_ID | ● | Identifier for the qstnr response. | |
| QSTN_ANSWER_ID | ● | Identifier for the qstn answer. | |
| QSTN_RESPONSE_ID | PK? | ● | Identifier for the qstn response. |
| SCORE | ● | Score. | |
| SUB_QUESTION_ID | ● | Identifier for the sub question. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for HRQ_QSTN_RESPONSES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table