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

HXT_TM_HEADER

SharedUsed in 0 subject areas147 reporting columnsBICC incremental-ready

Source object in the Oracle Fusion data model.

Likely primary key: TM_HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
ATTRIBUTE_CATEGORYDescriptive flexfield context (structure definition).
ATTRIBUTE_CHAR1Attribute char1.
ATTRIBUTE_CHAR10Attribute char10.
ATTRIBUTE_CHAR11Attribute char11.
ATTRIBUTE_CHAR12Attribute char12.
ATTRIBUTE_CHAR13Attribute char13.
ATTRIBUTE_CHAR14Attribute char14.
ATTRIBUTE_CHAR15Attribute char15.
ATTRIBUTE_CHAR16Attribute char16.
ATTRIBUTE_CHAR17Attribute char17.
ATTRIBUTE_CHAR18Attribute char18.
ATTRIBUTE_CHAR19Attribute char19.
ATTRIBUTE_CHAR2Attribute char2.
ATTRIBUTE_CHAR20Attribute char20.
ATTRIBUTE_CHAR21Attribute char21.
ATTRIBUTE_CHAR22Attribute char22.
ATTRIBUTE_CHAR23Attribute char23.
ATTRIBUTE_CHAR24Attribute char24.
ATTRIBUTE_CHAR25Attribute char25.
ATTRIBUTE_CHAR26Attribute char26.
ATTRIBUTE_CHAR27Attribute char27.
ATTRIBUTE_CHAR28Attribute char28.
ATTRIBUTE_CHAR29Attribute char29.
ATTRIBUTE_CHAR3Attribute char3.
ATTRIBUTE_CHAR30Attribute char30.
ATTRIBUTE_CHAR4Attribute char4.
ATTRIBUTE_CHAR5Attribute char5.
ATTRIBUTE_CHAR6Attribute char6.
ATTRIBUTE_CHAR7Attribute char7.
ATTRIBUTE_CHAR8Attribute char8.
ATTRIBUTE_CHAR9Attribute char9.
ATTRIBUTE_DATE1Descriptive flexfield segment.
ATTRIBUTE_DATE10Descriptive flexfield segment.
ATTRIBUTE_DATE11Descriptive flexfield segment.
ATTRIBUTE_DATE12Descriptive flexfield segment.
ATTRIBUTE_DATE13Descriptive flexfield segment.
ATTRIBUTE_DATE14Descriptive flexfield segment.
ATTRIBUTE_DATE15Descriptive flexfield segment.
ATTRIBUTE_DATE2Descriptive flexfield segment.
ATTRIBUTE_DATE3Descriptive flexfield segment.
ATTRIBUTE_DATE4Descriptive flexfield segment.
ATTRIBUTE_DATE5Descriptive flexfield segment.
ATTRIBUTE_DATE6Descriptive flexfield segment.
ATTRIBUTE_DATE7Descriptive flexfield segment.
ATTRIBUTE_DATE8Descriptive flexfield segment.
ATTRIBUTE_DATE9Descriptive flexfield segment.
ATTRIBUTE_NUMBER1Descriptive flexfield segment.
ATTRIBUTE_NUMBER10Descriptive flexfield segment.
ATTRIBUTE_NUMBER11Descriptive flexfield segment.
ATTRIBUTE_NUMBER12Descriptive flexfield segment.
ATTRIBUTE_NUMBER13Descriptive flexfield segment.
ATTRIBUTE_NUMBER14Descriptive flexfield segment.
ATTRIBUTE_NUMBER15Descriptive flexfield segment.
ATTRIBUTE_NUMBER16Descriptive flexfield segment.
ATTRIBUTE_NUMBER17Descriptive flexfield segment.
ATTRIBUTE_NUMBER18Descriptive flexfield segment.
ATTRIBUTE_NUMBER19Descriptive flexfield segment.
ATTRIBUTE_NUMBER2Descriptive flexfield segment.
ATTRIBUTE_NUMBER20Descriptive flexfield segment.
ATTRIBUTE_NUMBER3Descriptive flexfield segment.
ATTRIBUTE_NUMBER4Descriptive flexfield segment.
ATTRIBUTE_NUMBER5Descriptive flexfield segment.
ATTRIBUTE_NUMBER6Descriptive flexfield segment.
ATTRIBUTE_NUMBER7Descriptive flexfield segment.
ATTRIBUTE_NUMBER8Descriptive flexfield segment.
ATTRIBUTE_NUMBER9Descriptive flexfield segment.
CALCULATED_TIME_HEADER_IDIdentifier for the calculated time header.
COMMENTSComments.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
DATA_SET_IDIdentifier for the data set.
END_DATEEnd date.
ENTERPRISE_IDIdentifier for the enterprise.
LAST_COMMIT_TIMELast commit time.
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.
OBJECT_TYPEType of object.
OBJECT_VERSION_NUMBEROptimistic-locking version number, incremented on each update.
RESOURCE_IDIdentifier for the resource.
RESOURCE_TYPEType of resource.
START_DATEStart date.
TCLAYST_IDIdentifier for the tclayst.
TIME_BLDG_BLK_IDIdentifier for the time bldg blk.
TIME_BLDG_BLK_VERSIONTime bldg blk version.
TIME_REPORTER_IDIdentifier for the time reporter.
TM_BLDG_BLK_DAY_ID1Tm bldg blk day id1.
TM_BLDG_BLK_DAY_ID10Tm bldg blk day id10.
TM_BLDG_BLK_DAY_ID11Tm bldg blk day id11.
TM_BLDG_BLK_DAY_ID12Tm bldg blk day id12.
TM_BLDG_BLK_DAY_ID13Tm bldg blk day id13.
TM_BLDG_BLK_DAY_ID14Tm bldg blk day id14.
TM_BLDG_BLK_DAY_ID15Tm bldg blk day id15.
TM_BLDG_BLK_DAY_ID16Tm bldg blk day id16.
TM_BLDG_BLK_DAY_ID17Tm bldg blk day id17.
TM_BLDG_BLK_DAY_ID18Tm bldg blk day id18.
TM_BLDG_BLK_DAY_ID19Tm bldg blk day id19.
TM_BLDG_BLK_DAY_ID2Tm bldg blk day id2.
TM_BLDG_BLK_DAY_ID20Tm bldg blk day id20.
TM_BLDG_BLK_DAY_ID21Tm bldg blk day id21.
TM_BLDG_BLK_DAY_ID22Tm bldg blk day id22.
TM_BLDG_BLK_DAY_ID23Tm bldg blk day id23.
TM_BLDG_BLK_DAY_ID24Tm bldg blk day id24.
TM_BLDG_BLK_DAY_ID25Tm bldg blk day id25.
TM_BLDG_BLK_DAY_ID26Tm bldg blk day id26.
TM_BLDG_BLK_DAY_ID27Tm bldg blk day id27.
TM_BLDG_BLK_DAY_ID28Tm bldg blk day id28.
TM_BLDG_BLK_DAY_ID29Tm bldg blk day id29.
TM_BLDG_BLK_DAY_ID3Tm bldg blk day id3.
TM_BLDG_BLK_DAY_ID30Tm bldg blk day id30.
TM_BLDG_BLK_DAY_ID4Tm bldg blk day id4.
TM_BLDG_BLK_DAY_ID5Tm bldg blk day id5.
TM_BLDG_BLK_DAY_ID6Tm bldg blk day id6.
TM_BLDG_BLK_DAY_ID7Tm bldg blk day id7.
TM_BLDG_BLK_DAY_ID8Tm bldg blk day id8.
TM_BLDG_BLK_DAY_ID9Tm bldg blk day id9.
TM_BLDG_BLK_DAY_VERSION1Tm bldg blk day version1.
TM_BLDG_BLK_DAY_VERSION10Tm bldg blk day version10.
TM_BLDG_BLK_DAY_VERSION11Tm bldg blk day version11.
TM_BLDG_BLK_DAY_VERSION12Tm bldg blk day version12.
TM_BLDG_BLK_DAY_VERSION13Tm bldg blk day version13.
TM_BLDG_BLK_DAY_VERSION14Tm bldg blk day version14.
TM_BLDG_BLK_DAY_VERSION15Tm bldg blk day version15.
TM_BLDG_BLK_DAY_VERSION16Tm bldg blk day version16.
TM_BLDG_BLK_DAY_VERSION17Tm bldg blk day version17.
TM_BLDG_BLK_DAY_VERSION18Tm bldg blk day version18.
TM_BLDG_BLK_DAY_VERSION19Tm bldg blk day version19.
TM_BLDG_BLK_DAY_VERSION2Tm bldg blk day version2.
TM_BLDG_BLK_DAY_VERSION20Tm bldg blk day version20.
TM_BLDG_BLK_DAY_VERSION21Tm bldg blk day version21.
TM_BLDG_BLK_DAY_VERSION22Tm bldg blk day version22.
TM_BLDG_BLK_DAY_VERSION23Tm bldg blk day version23.
TM_BLDG_BLK_DAY_VERSION24Tm bldg blk day version24.
TM_BLDG_BLK_DAY_VERSION25Tm bldg blk day version25.
TM_BLDG_BLK_DAY_VERSION26Tm bldg blk day version26.
TM_BLDG_BLK_DAY_VERSION27Tm bldg blk day version27.
TM_BLDG_BLK_DAY_VERSION28Tm bldg blk day version28.
TM_BLDG_BLK_DAY_VERSION29Tm bldg blk day version29.
TM_BLDG_BLK_DAY_VERSION3Tm bldg blk day version3.
TM_BLDG_BLK_DAY_VERSION30Tm bldg blk day version30.
TM_BLDG_BLK_DAY_VERSION4Tm bldg blk day version4.
TM_BLDG_BLK_DAY_VERSION5Tm bldg blk day version5.
TM_BLDG_BLK_DAY_VERSION6Tm bldg blk day version6.
TM_BLDG_BLK_DAY_VERSION7Tm bldg blk day version7.
TM_BLDG_BLK_DAY_VERSION8Tm bldg blk day version8.
TM_BLDG_BLK_DAY_VERSION9Tm bldg blk day version9.
TM_HEADER_IDPK?Identifier for the tm header.

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_TM_HEADER?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us