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.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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.

Need the extract + dbt staging for POQ_ASSESSMENTS?

We ship parameterized SQL, BICC config, and dbt models you own.