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
Joins (inferred from key columns): TCLAYST_ID → HXT_TCLAYST_B

Columns

ColumnKeyIn reportsDescription (inferred)
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_CHAR1●Attribute char1.
ATTRIBUTE_CHAR10●Attribute char10.
ATTRIBUTE_CHAR11●Attribute char11.
ATTRIBUTE_CHAR12●Attribute char12.
ATTRIBUTE_CHAR13●Attribute char13.
ATTRIBUTE_CHAR14●Attribute char14.
ATTRIBUTE_CHAR15●Attribute char15.
ATTRIBUTE_CHAR16●Attribute char16.
ATTRIBUTE_CHAR17●Attribute char17.
ATTRIBUTE_CHAR18●Attribute char18.
ATTRIBUTE_CHAR19●Attribute char19.
ATTRIBUTE_CHAR2●Attribute char2.
ATTRIBUTE_CHAR20●Attribute char20.
ATTRIBUTE_CHAR21●Attribute char21.
ATTRIBUTE_CHAR22●Attribute char22.
ATTRIBUTE_CHAR23●Attribute char23.
ATTRIBUTE_CHAR24●Attribute char24.
ATTRIBUTE_CHAR25●Attribute char25.
ATTRIBUTE_CHAR26●Attribute char26.
ATTRIBUTE_CHAR27●Attribute char27.
ATTRIBUTE_CHAR28●Attribute char28.
ATTRIBUTE_CHAR29●Attribute char29.
ATTRIBUTE_CHAR3●Attribute char3.
ATTRIBUTE_CHAR30●Attribute char30.
ATTRIBUTE_CHAR4●Attribute char4.
ATTRIBUTE_CHAR5●Attribute char5.
ATTRIBUTE_CHAR6●Attribute char6.
ATTRIBUTE_CHAR7●Attribute char7.
ATTRIBUTE_CHAR8●Attribute char8.
ATTRIBUTE_CHAR9●Attribute char9.
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
CALCULATED_TIME_HEADER_ID●Identifier for the calculated time header.
COMMENTS●Comments.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DATA_SET_ID●Identifier for the data set.
END_DATE●End date.
ENTERPRISE_ID●Identifier for the enterprise.
LAST_COMMIT_TIME●Last commit time.
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.
OBJECT_TYPE●Type of object.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
RESOURCE_ID●Identifier for the resource.
RESOURCE_TYPE●Type of resource.
START_DATE●Start date.
TCLAYST_ID●Identifier for the tclayst.
TIME_BLDG_BLK_ID●Identifier for the time bldg blk.
TIME_BLDG_BLK_VERSION●Time bldg blk version.
TIME_REPORTER_ID●Identifier for the time reporter.
TM_BLDG_BLK_DAY_ID1●Tm bldg blk day id1.
TM_BLDG_BLK_DAY_ID10●Tm bldg blk day id10.
TM_BLDG_BLK_DAY_ID11●Tm bldg blk day id11.
TM_BLDG_BLK_DAY_ID12●Tm bldg blk day id12.
TM_BLDG_BLK_DAY_ID13●Tm bldg blk day id13.
TM_BLDG_BLK_DAY_ID14●Tm bldg blk day id14.
TM_BLDG_BLK_DAY_ID15●Tm bldg blk day id15.
TM_BLDG_BLK_DAY_ID16●Tm bldg blk day id16.
TM_BLDG_BLK_DAY_ID17●Tm bldg blk day id17.
TM_BLDG_BLK_DAY_ID18●Tm bldg blk day id18.
TM_BLDG_BLK_DAY_ID19●Tm bldg blk day id19.
TM_BLDG_BLK_DAY_ID2●Tm bldg blk day id2.
TM_BLDG_BLK_DAY_ID20●Tm bldg blk day id20.
TM_BLDG_BLK_DAY_ID21●Tm bldg blk day id21.
TM_BLDG_BLK_DAY_ID22●Tm bldg blk day id22.
TM_BLDG_BLK_DAY_ID23●Tm bldg blk day id23.
TM_BLDG_BLK_DAY_ID24●Tm bldg blk day id24.
TM_BLDG_BLK_DAY_ID25●Tm bldg blk day id25.
TM_BLDG_BLK_DAY_ID26●Tm bldg blk day id26.
TM_BLDG_BLK_DAY_ID27●Tm bldg blk day id27.
TM_BLDG_BLK_DAY_ID28●Tm bldg blk day id28.
TM_BLDG_BLK_DAY_ID29●Tm bldg blk day id29.
TM_BLDG_BLK_DAY_ID3●Tm bldg blk day id3.
TM_BLDG_BLK_DAY_ID30●Tm bldg blk day id30.
TM_BLDG_BLK_DAY_ID4●Tm bldg blk day id4.
TM_BLDG_BLK_DAY_ID5●Tm bldg blk day id5.
TM_BLDG_BLK_DAY_ID6●Tm bldg blk day id6.
TM_BLDG_BLK_DAY_ID7●Tm bldg blk day id7.
TM_BLDG_BLK_DAY_ID8●Tm bldg blk day id8.
TM_BLDG_BLK_DAY_ID9●Tm bldg blk day id9.
TM_BLDG_BLK_DAY_VERSION1●Tm bldg blk day version1.
TM_BLDG_BLK_DAY_VERSION10●Tm bldg blk day version10.
TM_BLDG_BLK_DAY_VERSION11●Tm bldg blk day version11.
TM_BLDG_BLK_DAY_VERSION12●Tm bldg blk day version12.
TM_BLDG_BLK_DAY_VERSION13●Tm bldg blk day version13.
TM_BLDG_BLK_DAY_VERSION14●Tm bldg blk day version14.
TM_BLDG_BLK_DAY_VERSION15●Tm bldg blk day version15.
TM_BLDG_BLK_DAY_VERSION16●Tm bldg blk day version16.
TM_BLDG_BLK_DAY_VERSION17●Tm bldg blk day version17.
TM_BLDG_BLK_DAY_VERSION18●Tm bldg blk day version18.
TM_BLDG_BLK_DAY_VERSION19●Tm bldg blk day version19.
TM_BLDG_BLK_DAY_VERSION2●Tm bldg blk day version2.
TM_BLDG_BLK_DAY_VERSION20●Tm bldg blk day version20.
TM_BLDG_BLK_DAY_VERSION21●Tm bldg blk day version21.
TM_BLDG_BLK_DAY_VERSION22●Tm bldg blk day version22.
TM_BLDG_BLK_DAY_VERSION23●Tm bldg blk day version23.
TM_BLDG_BLK_DAY_VERSION24●Tm bldg blk day version24.
TM_BLDG_BLK_DAY_VERSION25●Tm bldg blk day version25.
TM_BLDG_BLK_DAY_VERSION26●Tm bldg blk day version26.
TM_BLDG_BLK_DAY_VERSION27●Tm bldg blk day version27.
TM_BLDG_BLK_DAY_VERSION28●Tm bldg blk day version28.
TM_BLDG_BLK_DAY_VERSION29●Tm bldg blk day version29.
TM_BLDG_BLK_DAY_VERSION3●Tm bldg blk day version3.
TM_BLDG_BLK_DAY_VERSION30●Tm bldg blk day version30.
TM_BLDG_BLK_DAY_VERSION4●Tm bldg blk day version4.
TM_BLDG_BLK_DAY_VERSION5●Tm bldg blk day version5.
TM_BLDG_BLK_DAY_VERSION6●Tm bldg blk day version6.
TM_BLDG_BLK_DAY_VERSION7●Tm bldg blk day version7.
TM_BLDG_BLK_DAY_VERSION8●Tm bldg blk day version8.
TM_BLDG_BLK_DAY_VERSION9●Tm 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
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern