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

HXT_TCLAYFLD_DEFNS_B

SharedUsed in 0 subject areas83 reporting columnsBICC incremental-ready

base table, language-neutral data (paired with _TL labels and the _VL view).

Likely primary key: TCLAYFLD_DEFNS_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): TCLAYFLD_DEFNS_ID → HXT_TCLAYFLD_DEFNS_VL · TCLAY_ID → HXT_TCLAY_V

Columns

ColumnKeyIn reportsDescription (inferred)
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DISPLAY_SEQUENCE●Display sequence.
ENTERPRISE_ID●Identifier for the enterprise.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
MODULE_ID●Identifier for the module.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
P_TCLAYFLD_DEFNS_ID●Identifier for the p tclayfld defns.
SEED_DATA_SOURCE●Seed data source.
SGUID●Sguid.
TCLAYFLD_ATTRIBUTE_CATEGORY●Tclayfld attribute category.
TCLAYFLD_ATTRIBUTE_CHAR1●Tclayfld attribute char1.
TCLAYFLD_ATTRIBUTE_CHAR10●Tclayfld attribute char10.
TCLAYFLD_ATTRIBUTE_CHAR11●Tclayfld attribute char11.
TCLAYFLD_ATTRIBUTE_CHAR12●Tclayfld attribute char12.
TCLAYFLD_ATTRIBUTE_CHAR13●Tclayfld attribute char13.
TCLAYFLD_ATTRIBUTE_CHAR14●Tclayfld attribute char14.
TCLAYFLD_ATTRIBUTE_CHAR15●Tclayfld attribute char15.
TCLAYFLD_ATTRIBUTE_CHAR16●Tclayfld attribute char16.
TCLAYFLD_ATTRIBUTE_CHAR17●Tclayfld attribute char17.
TCLAYFLD_ATTRIBUTE_CHAR18●Tclayfld attribute char18.
TCLAYFLD_ATTRIBUTE_CHAR19●Tclayfld attribute char19.
TCLAYFLD_ATTRIBUTE_CHAR2●Tclayfld attribute char2.
TCLAYFLD_ATTRIBUTE_CHAR20●Tclayfld attribute char20.
TCLAYFLD_ATTRIBUTE_CHAR21●Tclayfld attribute char21.
TCLAYFLD_ATTRIBUTE_CHAR22●Tclayfld attribute char22.
TCLAYFLD_ATTRIBUTE_CHAR23●Tclayfld attribute char23.
TCLAYFLD_ATTRIBUTE_CHAR24●Tclayfld attribute char24.
TCLAYFLD_ATTRIBUTE_CHAR25●Tclayfld attribute char25.
TCLAYFLD_ATTRIBUTE_CHAR26●Tclayfld attribute char26.
TCLAYFLD_ATTRIBUTE_CHAR27●Tclayfld attribute char27.
TCLAYFLD_ATTRIBUTE_CHAR28●Tclayfld attribute char28.
TCLAYFLD_ATTRIBUTE_CHAR29●Tclayfld attribute char29.
TCLAYFLD_ATTRIBUTE_CHAR3●Tclayfld attribute char3.
TCLAYFLD_ATTRIBUTE_CHAR30●Tclayfld attribute char30.
TCLAYFLD_ATTRIBUTE_CHAR4●Tclayfld attribute char4.
TCLAYFLD_ATTRIBUTE_CHAR5●Tclayfld attribute char5.
TCLAYFLD_ATTRIBUTE_CHAR6●Tclayfld attribute char6.
TCLAYFLD_ATTRIBUTE_CHAR7●Tclayfld attribute char7.
TCLAYFLD_ATTRIBUTE_CHAR8●Tclayfld attribute char8.
TCLAYFLD_ATTRIBUTE_CHAR9●Tclayfld attribute char9.
TCLAYFLD_ATTRIBUTE_DATE1●Tclayfld attribute date1.
TCLAYFLD_ATTRIBUTE_DATE10●Tclayfld attribute date10.
TCLAYFLD_ATTRIBUTE_DATE11●Tclayfld attribute date11.
TCLAYFLD_ATTRIBUTE_DATE12●Tclayfld attribute date12.
TCLAYFLD_ATTRIBUTE_DATE13●Tclayfld attribute date13.
TCLAYFLD_ATTRIBUTE_DATE14●Tclayfld attribute date14.
TCLAYFLD_ATTRIBUTE_DATE15●Tclayfld attribute date15.
TCLAYFLD_ATTRIBUTE_DATE2●Tclayfld attribute date2.
TCLAYFLD_ATTRIBUTE_DATE3●Tclayfld attribute date3.
TCLAYFLD_ATTRIBUTE_DATE4●Tclayfld attribute date4.
TCLAYFLD_ATTRIBUTE_DATE5●Tclayfld attribute date5.
TCLAYFLD_ATTRIBUTE_DATE6●Tclayfld attribute date6.
TCLAYFLD_ATTRIBUTE_DATE7●Tclayfld attribute date7.
TCLAYFLD_ATTRIBUTE_DATE8●Tclayfld attribute date8.
TCLAYFLD_ATTRIBUTE_DATE9●Tclayfld attribute date9.
TCLAYFLD_ATTRIBUTE_NUMBER1●Tclayfld attribute number1.
TCLAYFLD_ATTRIBUTE_NUMBER10●Tclayfld attribute number10.
TCLAYFLD_ATTRIBUTE_NUMBER11●Tclayfld attribute number11.
TCLAYFLD_ATTRIBUTE_NUMBER12●Tclayfld attribute number12.
TCLAYFLD_ATTRIBUTE_NUMBER13●Tclayfld attribute number13.
TCLAYFLD_ATTRIBUTE_NUMBER14●Tclayfld attribute number14.
TCLAYFLD_ATTRIBUTE_NUMBER15●Tclayfld attribute number15.
TCLAYFLD_ATTRIBUTE_NUMBER16●Tclayfld attribute number16.
TCLAYFLD_ATTRIBUTE_NUMBER17●Tclayfld attribute number17.
TCLAYFLD_ATTRIBUTE_NUMBER18●Tclayfld attribute number18.
TCLAYFLD_ATTRIBUTE_NUMBER19●Tclayfld attribute number19.
TCLAYFLD_ATTRIBUTE_NUMBER2●Tclayfld attribute number2.
TCLAYFLD_ATTRIBUTE_NUMBER20●Tclayfld attribute number20.
TCLAYFLD_ATTRIBUTE_NUMBER3●Tclayfld attribute number3.
TCLAYFLD_ATTRIBUTE_NUMBER4●Tclayfld attribute number4.
TCLAYFLD_ATTRIBUTE_NUMBER5●Tclayfld attribute number5.
TCLAYFLD_ATTRIBUTE_NUMBER6●Tclayfld attribute number6.
TCLAYFLD_ATTRIBUTE_NUMBER7●Tclayfld attribute number7.
TCLAYFLD_ATTRIBUTE_NUMBER8●Tclayfld attribute number8.
TCLAYFLD_ATTRIBUTE_NUMBER9●Tclayfld attribute number9.
TCLAYFLD_DEFNS_CD●Tclayfld defns code.
TCLAYFLD_DEFNS_IDPK?●Identifier for the tclayfld defns.
TCLAYFLD_DEFNS_INSTANCE_FLAG●Indicator (Y/N) for the tclayfld defns instance.
TCLAYFLD_TMPL_ID●Identifier for the tclayfld tmpl.
TCLAY_ID●Identifier for the tclay.

Used by reports

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

Subject areas

Need the extract + dbt staging for HXT_TCLAYFLD_DEFNS_B?
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