Oracle Fusion · Data dictionary
HXT_TCLAY_REGION_V
SharedUsed in 0 subject areas39 reporting columnsBICC incremental-ready
denormalized view.
Primary key: not yet catalogued for HXT_TCLAY_REGION_V, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDTL_LABEL | ● | Addtl label. | |
| COMMENT_DATE_FORMAT | ● | Comment date format. | |
| COMMENT_DISPLAY_OPTION | ● | Comment display option. | |
| COMMENT_LABEL | ● | Comment label. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DAILY_DATE_FORMAT | ● | Daily date format. | |
| DAILY_LABEL | ● | Daily label. | |
| HOURS_DATE_FORMAT | ● | Hours date format. | |
| HOURS_DECIMAL_PLACE | ● | Hours decimal place. | |
| INSTANCE_FLAG | ● | Indicator (Y/N) for the instance. | |
| 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. | |
| LAYOUT_REGION_CODE | ● | Code identifying the layout region. | |
| MATRIX_BLANK_ROWS_DEFAULT | ● | Matrix blank rows default. | |
| MATRIX_DATE_FORMAT | ● | Matrix date format. | |
| MATRIX_DECIMAL_PLACE | ● | Matrix decimal place. | |
| MATRIX_DISPLAY_HOUR_SLIDER | ● | Matrix display hour slider. | |
| MATRIX_DISPLAY_TIME_SLIDER | ● | Matrix display time slider. | |
| MATRIX_DISPLAY_UOM | ● | Matrix display unit of measure. | |
| MATRIX_ENABLE_BUTTON_RULE | ● | Matrix enable button rule. | |
| MATRIX_ENABLE_MIDNIGHT | ● | Matrix enable midnight. | |
| MATRIX_ENABLE_NEGATIVE | ● | Matrix enable negative. | |
| MATRIX_HIDE_SECONDS | ● | Matrix hide seconds. | |
| MATRIX_HIGHLIGHT_OT | ● | Matrix highlight ot. | |
| MATRIX_TE_FORMAT | ● | Matrix te format. | |
| MATRIX_VIEW_DAILY_TEVT | ● | Matrix view daily tevt. | |
| TASK_NAME | ● | Name of the task. | |
| TASK_SHORT_NAME | ● | Name of the task short. | |
| TCLAYST_ID | ● | Identifier for the tclayst. | |
| TCLAY_CD | ● | Tclay code. | |
| TCLAY_ID | ● | Identifier for the tclay. | |
| TCLAY_TASK_SHORT_NAME | ● | Name of the tclay task short. | |
| TCLAY_TYPE | ● | Type of tclay. | |
| TIMETOTALS_DECIMAL_PLACE | ● | Timetotals decimal place. | |
| TL_TASK_FEATURES_ID | ● | Identifier for the tl task features. | |
| TL_TASK_RESULTS_ID | ● | Identifier for the tl task results. | |
| UNITS_DATE_FORMAT | ● | Units date format. |
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_TCLAY_REGION_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table