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
| Column | Key | In reports | Description (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_DATE | INCR | ● | 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_ID | PK? | ● | 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.