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