CSE_ASSETS_HIST

SharedUsed in 2 subject areas26 reporting columns

history / audit log.

Primary key: not yet catalogued for CSE_ASSETS_HIST — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
ACTIVE_END_DATE	●	Active end date.
ASSET_ID	●	Identifier for the asset.
ASSET_NUMBER	●	Asset number.
COMPETITOR_ASSET_FLAG	●	Indicator (Y/N) for the competitor asset.
CURRENT_LOCATION_CONTEXT	●	Current location context.
CURRENT_LOCATION_ID	●	Identifier for the current location.
CUSTOMER_ASSET_END_DATE	●	Customer asset end date.
CUSTOMER_ASSET_START_DATE	●	Customer asset start date.
CUSTOMER_ID	●	Identifier for the customer.
DFLT_WO_SUB_TYPE	●	Type of dflt wo sub.
DFLT_WO_TYPE	●	Type of dflt wo.
INVENTORY_LOCATOR_ID	●	Identifier for the inventory locator.
IOT_ENABLED_FLAG	●	Indicator (Y/N) for the iot enabled.
LOCATION_ORGANIZATION_ID	●	Identifier for the location organization.
LOT_NUMBER	●	Lot number.
MAINTAINABLE_FLAG	●	Indicator (Y/N) for the maintainable.
NEW_WO_ALLOWED_FLAG	●	Indicator (Y/N) for the new wo allowed.
QUANTITY	●	Quantity.
SALES_ORDER_NUMBER	●	Sales order number.
SECONDARY_QUANTITY	●	Secondary quantity.
SECONDARY_UOM_CODE	●	Code identifying the secondary unit of measure.
SERIAL_NUMBER	●	Serial number.
SHIPMENT_DATE	●	Shipment date.
SUBINVENTORY_CODE	●	Code identifying the subinventory.
TRANSACTED_ASSET_ID	●	Identifier for the transacted asset.
UOM_CODE	●	Code identifying the unit of measure.

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 CSE_ASSETS_HIST?

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