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

Columns

ColumnKeyIn reportsDescription (inferred)
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
DISPLAY_SEQUENCEDisplay sequence.
ENTERPRISE_IDIdentifier for the enterprise.
LAST_UPDATED_BYUser who last updated the row.
LAST_UPDATE_DATEINCRDate and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGINSession login of the user who last updated the row.
MODULE_IDIdentifier for the module.
OBJECT_VERSION_NUMBEROptimistic-locking version number, incremented on each update.
P_TCLAYFLD_DEFNS_IDIdentifier for the p tclayfld defns.
SEED_DATA_SOURCESeed data source.
SGUIDSguid.
TCLAYFLD_ATTRIBUTE_CATEGORYTclayfld attribute category.
TCLAYFLD_ATTRIBUTE_CHAR1Tclayfld attribute char1.
TCLAYFLD_ATTRIBUTE_CHAR10Tclayfld attribute char10.
TCLAYFLD_ATTRIBUTE_CHAR11Tclayfld attribute char11.
TCLAYFLD_ATTRIBUTE_CHAR12Tclayfld attribute char12.
TCLAYFLD_ATTRIBUTE_CHAR13Tclayfld attribute char13.
TCLAYFLD_ATTRIBUTE_CHAR14Tclayfld attribute char14.
TCLAYFLD_ATTRIBUTE_CHAR15Tclayfld attribute char15.
TCLAYFLD_ATTRIBUTE_CHAR16Tclayfld attribute char16.
TCLAYFLD_ATTRIBUTE_CHAR17Tclayfld attribute char17.
TCLAYFLD_ATTRIBUTE_CHAR18Tclayfld attribute char18.
TCLAYFLD_ATTRIBUTE_CHAR19Tclayfld attribute char19.
TCLAYFLD_ATTRIBUTE_CHAR2Tclayfld attribute char2.
TCLAYFLD_ATTRIBUTE_CHAR20Tclayfld attribute char20.
TCLAYFLD_ATTRIBUTE_CHAR21Tclayfld attribute char21.
TCLAYFLD_ATTRIBUTE_CHAR22Tclayfld attribute char22.
TCLAYFLD_ATTRIBUTE_CHAR23Tclayfld attribute char23.
TCLAYFLD_ATTRIBUTE_CHAR24Tclayfld attribute char24.
TCLAYFLD_ATTRIBUTE_CHAR25Tclayfld attribute char25.
TCLAYFLD_ATTRIBUTE_CHAR26Tclayfld attribute char26.
TCLAYFLD_ATTRIBUTE_CHAR27Tclayfld attribute char27.
TCLAYFLD_ATTRIBUTE_CHAR28Tclayfld attribute char28.
TCLAYFLD_ATTRIBUTE_CHAR29Tclayfld attribute char29.
TCLAYFLD_ATTRIBUTE_CHAR3Tclayfld attribute char3.
TCLAYFLD_ATTRIBUTE_CHAR30Tclayfld attribute char30.
TCLAYFLD_ATTRIBUTE_CHAR4Tclayfld attribute char4.
TCLAYFLD_ATTRIBUTE_CHAR5Tclayfld attribute char5.
TCLAYFLD_ATTRIBUTE_CHAR6Tclayfld attribute char6.
TCLAYFLD_ATTRIBUTE_CHAR7Tclayfld attribute char7.
TCLAYFLD_ATTRIBUTE_CHAR8Tclayfld attribute char8.
TCLAYFLD_ATTRIBUTE_CHAR9Tclayfld attribute char9.
TCLAYFLD_ATTRIBUTE_DATE1Tclayfld attribute date1.
TCLAYFLD_ATTRIBUTE_DATE10Tclayfld attribute date10.
TCLAYFLD_ATTRIBUTE_DATE11Tclayfld attribute date11.
TCLAYFLD_ATTRIBUTE_DATE12Tclayfld attribute date12.
TCLAYFLD_ATTRIBUTE_DATE13Tclayfld attribute date13.
TCLAYFLD_ATTRIBUTE_DATE14Tclayfld attribute date14.
TCLAYFLD_ATTRIBUTE_DATE15Tclayfld attribute date15.
TCLAYFLD_ATTRIBUTE_DATE2Tclayfld attribute date2.
TCLAYFLD_ATTRIBUTE_DATE3Tclayfld attribute date3.
TCLAYFLD_ATTRIBUTE_DATE4Tclayfld attribute date4.
TCLAYFLD_ATTRIBUTE_DATE5Tclayfld attribute date5.
TCLAYFLD_ATTRIBUTE_DATE6Tclayfld attribute date6.
TCLAYFLD_ATTRIBUTE_DATE7Tclayfld attribute date7.
TCLAYFLD_ATTRIBUTE_DATE8Tclayfld attribute date8.
TCLAYFLD_ATTRIBUTE_DATE9Tclayfld attribute date9.
TCLAYFLD_ATTRIBUTE_NUMBER1Tclayfld attribute number1.
TCLAYFLD_ATTRIBUTE_NUMBER10Tclayfld attribute number10.
TCLAYFLD_ATTRIBUTE_NUMBER11Tclayfld attribute number11.
TCLAYFLD_ATTRIBUTE_NUMBER12Tclayfld attribute number12.
TCLAYFLD_ATTRIBUTE_NUMBER13Tclayfld attribute number13.
TCLAYFLD_ATTRIBUTE_NUMBER14Tclayfld attribute number14.
TCLAYFLD_ATTRIBUTE_NUMBER15Tclayfld attribute number15.
TCLAYFLD_ATTRIBUTE_NUMBER16Tclayfld attribute number16.
TCLAYFLD_ATTRIBUTE_NUMBER17Tclayfld attribute number17.
TCLAYFLD_ATTRIBUTE_NUMBER18Tclayfld attribute number18.
TCLAYFLD_ATTRIBUTE_NUMBER19Tclayfld attribute number19.
TCLAYFLD_ATTRIBUTE_NUMBER2Tclayfld attribute number2.
TCLAYFLD_ATTRIBUTE_NUMBER20Tclayfld attribute number20.
TCLAYFLD_ATTRIBUTE_NUMBER3Tclayfld attribute number3.
TCLAYFLD_ATTRIBUTE_NUMBER4Tclayfld attribute number4.
TCLAYFLD_ATTRIBUTE_NUMBER5Tclayfld attribute number5.
TCLAYFLD_ATTRIBUTE_NUMBER6Tclayfld attribute number6.
TCLAYFLD_ATTRIBUTE_NUMBER7Tclayfld attribute number7.
TCLAYFLD_ATTRIBUTE_NUMBER8Tclayfld attribute number8.
TCLAYFLD_ATTRIBUTE_NUMBER9Tclayfld attribute number9.
TCLAYFLD_DEFNS_CDTclayfld defns code.
TCLAYFLD_DEFNS_IDPK?Identifier for the tclayfld defns.
TCLAYFLD_DEFNS_INSTANCE_FLAGIndicator (Y/N) for the tclayfld defns instance.
TCLAYFLD_TMPL_IDIdentifier for the tclayfld tmpl.
TCLAY_IDIdentifier 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