Analytics Catalog/Data dictionary/CSE_ASSET_QUALIFICATIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

CSE_ASSET_QUALIFICATIONS

SharedUsed in 1 subject areas12 reporting columns

Source object in the Oracle Fusion data model.

Likely primary key: ASSET_QUALIFICATION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): EQP_QUAL_REQ_IDFUSION.MNT_EQP_QUAL_REQS_B · IP_EVENT_IDQA_IP_EVENTS · WORK_ORDER_IDWIE_WORK_ORDERS_B · WO_OPERATION_IDWIE_WO_OPERATIONS_B

Columns

ColumnKeyIn reportsDescription (inferred)
ASSET_IDIdentifier for the asset.
ASSET_QUALIFICATION_IDPK?Identifier for the asset qualification.
EQP_QUAL_REQ_IDIdentifier for the eqp qual req.
IP_EVENT_IDIdentifier for the ip event.
MP_PROGRAM_IDIdentifier for the mp program.
MP_REQUIREMENT_IDIdentifier for the mp requirement.
NEXT_QUALIFICATION_DATENext qualification date.
QUALIFIED_BYQualified by.
QUALIFIED_DATEQualified date.
QUALIFIED_FLAGIndicator (Y/N) for the qualified.
WORK_ORDER_IDIdentifier for the work order.
WO_OPERATION_IDIdentifier for the wo operation.

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.

Need the extract + dbt staging for CSE_ASSET_QUALIFICATIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern