Oracle Fusion · Data dictionary
POQ_ASSESSMENTS
SharedUsed in 3 subject areas27 reporting columns
Source object in the Oracle Fusion data model.
Likely primary key: ASSESSMENT_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSESSMENT_COMMENTS | ● | Assessment comments. | |
| ASSESSMENT_ID | PK? | ● | Identifier for the assessment. |
| ASSESSMENT_NAME | ● | Name of the assessment. | |
| ASSESSMENT_NUMBER | ● | Assessment number. | |
| ASSESSMENT_OUTCOME | ● | Assessment outcome. | |
| ASSESSMENT_SCORE | ● | Assessment score. | |
| AUTO_EVALUATED_FLAG | ● | Indicator (Y/N) for the auto evaluated. | |
| CANCELED_DATE | ● | Canceled date. | |
| CANCELED_REASON_CODE | ● | Code identifying the canceled reason. | |
| COMPLETED_DATE | ● | Completed date. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| EVALUATION_DATE | ● | Evaluation date. | |
| EVALUATION_DUE_DATE | ● | Evaluation due date. | |
| EVAL_READY_DATE | ● | Eval ready date. | |
| EXPIRATION_REMINDER_PERIOD | ● | Expiration reminder period. | |
| EXPIRATION_REMINDER_TYPE | ● | Type of expiration reminder. | |
| LATEST_FLAG | ● | Indicator (Y/N) for the latest. | |
| NOTE_TO_SUPPLIER | ● | Note to supplier. | |
| ORIG_ASSESSMENT_OUTCOME | ● | Orig assessment outcome. | |
| ORIG_ASSESSMENT_SCORE | ● | Orig assessment score. | |
| OVERRIDE_DATE | ● | Override date. | |
| OVERRIDE_REASON | ● | Override reason. | |
| SHOW_ASSESSMENT_QUAL_FLAG | ● | Indicator (Y/N) for the show assessment qual. | |
| SHOW_ASSESSMT_TO_SUPP_FLAG | ● | Indicator (Y/N) for the show assessmt to supplier. | |
| SOURCING_ELIGIBILITY_CODE | ● | Code identifying the sourcing eligibility. |
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 - Supplier Eligibility History Real Time
- Supplier Qualification - Supplier Eligibility Real Time
Need the extract + dbt staging for POQ_ASSESSMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table