Oracle Fusion · Data dictionary
HRQ_QSTNR_QUESTIONS
SharedUsed in 0 subject areas22 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Likely primary key: QSTNR_QUESTION_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): QSTNR_SECTION_ID → HRQ_QSTNR_SECTIONS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADHOC_QSTN | ● | Adhoc qstn. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| KEEP_WITH_PREV | ● | Keep with prev. | |
| 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. | |
| LOCK_QUESTION_FLAG | ● | Indicator (Y/N) for the lock question. | |
| MANDATORY | ● | Mandatory. | |
| MAX_POSSIBLE_SCORE | ● | Max possible score. | |
| MAX_THRESHOLD_SCORE | ● | Max threshold score. | |
| MIN_THRESHOLD_SCORE | ● | Min threshold score. | |
| MODULE_ID | ● | Identifier for the module. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| QSTNR_QUESTION_ID | PK? | ● | Identifier for the qstnr question. |
| QSTNR_SECTION_ID | ● | Identifier for the qstnr section. | |
| QSTN_VERSION_NUM | ● | Qstn version number. | |
| QUESTION_ID | ● | Identifier for the question. | |
| RESPONSE_TYPE_ID | ● | Identifier for the response type. | |
| SEED_DATA_SOURCE | ● | Seed data source. | |
| SEQ_NUM | ● | Seq number. |
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_QSTNR_QUESTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table