Oracle Fusion · Data dictionary
POQ_QUESTIONS_VL
SharedUsed in 2 subject areas32 reporting columns
view layer — joins the base table with translations for the current language.
Likely primary key: QUESTION_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVATION_DATE | ● | Activation date. | |
| ALLOW_RESP_COMMENT_FLAG | ● | Indicator (Y/N) for the allow resp comment. | |
| ATTACHMENT_ALLOWED_CODE | ● | Code identifying the attachment allowed. | |
| CREATION_SOURCE | ● | Creation source. | |
| CRITICAL_QUESTION_FLAG | ● | Indicator (Y/N) for the critical question. | |
| DISPLAY_PREFERRED_RESP_FLAG | ● | Indicator (Y/N) for the display preferred resp. | |
| LATEST_REVISION_FLAG | ● | Indicator (Y/N) for the latest revision. | |
| MAXIMUM_SCORE | ● | Maximum score. | |
| ORIGINAL_QUESTION_ID | ● | Identifier for the original question. | |
| PREFERRED_RESPONSE_DATE | ● | Preferred response date. | |
| PREFERRED_RESPONSE_DATETIME | ● | Preferred response datetime. | |
| PREFERRED_RESPONSE_NUMBER | ● | Preferred response number. | |
| PREFERRED_RESPONSE_TEXT | ● | Preferred response text. | |
| QUESTION_HINT | ● | Question hint. | |
| QUESTION_ID | PK? | ● | Identifier for the question. |
| QUESTION_LEVEL | ● | Question level. | |
| QUESTION_NAME | ● | Name of the question. | |
| QUESTION_STATUS | ● | Status of the question. | |
| QUESTION_SURVEY_FLAG | ● | Indicator (Y/N) for the question survey. | |
| QUESTION_TEXT | ● | Question text. | |
| QUESTION_TYPE | ● | Type of question. | |
| RESPONDER_TYPE | ● | Type of responder. | |
| RESPONSE_REQUIRED_FLAG | ● | Indicator (Y/N) for the response required. | |
| RESPONSE_TYPE | ● | Type of response. | |
| REVISION_NUMBER | ● | Revision number. | |
| SCORE_FOR_NO_RESPONSE | ● | Score for number response. | |
| SCORING_APPROACH | ● | Scoring approach. | |
| SCORING_METHOD | ● | Scoring method. | |
| STDS_ORG_CODE | ● | Code identifying the stds organization. | |
| SUBJECT_CODE | ● | Code identifying the subject. | |
| SUPPLIER_ATTRIBUTE_CODE | ● | Code identifying the supplier attribute. | |
| SUPPLIER_ATTRIBUTE_FLAG | ● | Indicator (Y/N) for the supplier attribute. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Supplier Qualification - Qualifications and Assessments Real Time
- Supplier Qualification - Question Responses Real Time
Need the extract + dbt staging for POQ_QUESTIONS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.