Oracle Fusion · Data dictionary
HXT_SETUP_OPTION_VALS
SharedUsed in 0 subject areas95 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Likely primary key: SETUP_OPTION_VAL_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. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| 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. | |
| SEED_DATA_SOURCE | ● | Seed data source. | |
| SETUP_OPTION_VAL_CD | ● | Setup option val code. | |
| SETUP_OPTION_VAL_ID | PK? | ● | Identifier for the setup option val. |
| SETUP_PROFILE_ID | ● | Identifier for the setup profile. | |
| SGUID | ● | Sguid. | |
| TYPE | ● | Type. | |
| VALUE1 | ● | Value1. | |
| VALUE10 | ● | Value10. | |
| VALUE11 | ● | Value11. | |
| VALUE12 | ● | Value12. | |
| VALUE13 | ● | Value13. | |
| VALUE14 | ● | Value14. | |
| VALUE15 | ● | Value15. | |
| VALUE16 | ● | Value16. | |
| VALUE17 | ● | Value17. | |
| VALUE18 | ● | Value18. | |
| VALUE19 | ● | Value19. | |
| VALUE2 | ● | Value2. | |
| VALUE20 | ● | Value20. | |
| VALUE21 | ● | Value21. | |
| VALUE22 | ● | Value22. | |
| VALUE23 | ● | Value23. | |
| VALUE24 | ● | Value24. | |
| VALUE25 | ● | Value25. | |
| VALUE26 | ● | Value26. | |
| VALUE27 | ● | Value27. | |
| VALUE28 | ● | Value28. | |
| VALUE29 | ● | Value29. | |
| VALUE3 | ● | Value3. | |
| VALUE30 | ● | Value30. | |
| VALUE31 | ● | Value31. | |
| VALUE32 | ● | Value32. | |
| VALUE33 | ● | Value33. | |
| VALUE34 | ● | Value34. | |
| VALUE35 | ● | Value35. | |
| VALUE36 | ● | Value36. | |
| VALUE37 | ● | Value37. | |
| VALUE38 | ● | Value38. | |
| VALUE39 | ● | Value39. | |
| VALUE4 | ● | Value4. | |
| VALUE40 | ● | Value40. | |
| VALUE41 | ● | Value41. | |
| VALUE42 | ● | Value42. | |
| VALUE43 | ● | Value43. | |
| VALUE44 | ● | Value44. | |
| VALUE45 | ● | Value45. | |
| VALUE46 | ● | Value46. | |
| VALUE47 | ● | Value47. | |
| VALUE48 | ● | Value48. | |
| VALUE49 | ● | Value49. | |
| VALUE5 | ● | Value5. | |
| VALUE50 | ● | Value50. | |
| VALUE51 | ● | Value51. | |
| VALUE52 | ● | Value52. | |
| VALUE53 | ● | Value53. | |
| VALUE54 | ● | Value54. | |
| VALUE55 | ● | Value55. | |
| VALUE56 | ● | Value56. | |
| VALUE57 | ● | Value57. | |
| VALUE58 | ● | Value58. | |
| VALUE59 | ● | Value59. | |
| VALUE6 | ● | Value6. | |
| VALUE60 | ● | Value60. | |
| VALUE61 | ● | Value61. | |
| VALUE62 | ● | Value62. | |
| VALUE63 | ● | Value63. | |
| VALUE64 | ● | Value64. | |
| VALUE65 | ● | Value65. | |
| VALUE66 | ● | Value66. | |
| VALUE67 | ● | Value67. | |
| VALUE68 | ● | Value68. | |
| VALUE69 | ● | Value69. | |
| VALUE7 | ● | Value7. | |
| VALUE70 | ● | Value70. | |
| VALUE71 | ● | Value71. | |
| VALUE72 | ● | Value72. | |
| VALUE73 | ● | Value73. | |
| VALUE74 | ● | Value74. | |
| VALUE75 | ● | Value75. | |
| VALUE76 | ● | Value76. | |
| VALUE77 | ● | Value77. | |
| VALUE78 | ● | Value78. | |
| VALUE79 | ● | Value79. | |
| VALUE8 | ● | Value8. | |
| VALUE9 | ● | Value9. |
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_SETUP_OPTION_VALS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table