Oracle Fusion · Data dictionary
HWM_TM_RPT_ENTRY_V
SharedUsed in 0 subject areas79 reporting columnsBICC incremental-ready
denormalized view.
Primary key: not yet catalogued for HWM_TM_RPT_ENTRY_V, reference Oracle Tables & Views guide. · Incremental key: DAY_LAST_UPDATE_DATE, TC_LAST_UPDATE_DATE, TE_LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ANC_DELETE_FLAG | ● | Indicator (Y/N) for the anc delete. | |
| ANC_GRP_TYPE_ID | ● | Identifier for the anc grp type. | |
| ANC_LATEST_VERSION | ● | Anc latest version. | |
| ANC_TM_REC_GRP_ID | ● | Identifier for the anc tm rec grp. | |
| ANC_TM_REC_GRP_VERSION | ● | Anc tm rec grp version. | |
| DAY_COMMENT_TEXT | ● | Day comment text. | |
| DAY_CREATED_BY | ● | Day created by. | |
| DAY_CREATION_DATE | ● | Day creation date. | |
| DAY_DATE_FROM | ● | Day date from. | |
| DAY_DATE_TO | ● | Day date to. | |
| DAY_DELETE_FLAG | ● | Indicator (Y/N) for the day delete. | |
| DAY_GRP_TYPE_ID | ● | Identifier for the day grp type. | |
| DAY_LAST_UPDATED_BY | ● | Day last updated by. | |
| DAY_LAST_UPDATE_DATE | INCR | ● | Day last update date. |
| DAY_LAST_UPDATE_LOGIN | ● | Day last update login. | |
| DAY_LATEST_VERSION | ● | Day latest version. | |
| DAY_LAYER_CODE | ● | Code identifying the day layer. | |
| DAY_START_GMT_OFFSET | ● | Day start gmt offset. | |
| DAY_START_TIME | ● | Day start time. | |
| DAY_START_TIMEZONE_CODE | ● | Code identifying the day start timezone. | |
| DAY_STOP_GMT_OFFSET | ● | Day stop gmt offset. | |
| DAY_STOP_TIME | ● | Day stop time. | |
| DAY_STOP_TIMEZONE_CODE | ● | Code identifying the day stop timezone. | |
| DAY_TM_REC_GRP_ID | ● | Identifier for the day tm rec grp. | |
| DAY_TM_REC_GRP_VERSION | ● | Day tm rec grp version. | |
| RESOURCE_ID | ● | Identifier for the resource. | |
| TC_COMMENT_TEXT | ● | Tc comment text. | |
| TC_COMMIT_TIMESTAMP | ● | Tc commit timestamp. | |
| TC_CREATED_BY | ● | Tc created by. | |
| TC_CREATION_DATE | ● | Tc creation date. | |
| TC_DATE_FROM | ● | Tc date from. | |
| TC_DATE_TO | ● | Tc date to. | |
| TC_DELETE_FLAG | ● | Indicator (Y/N) for the tc delete. | |
| TC_GRP_TYPE_ID | ● | Identifier for the tc grp type. | |
| TC_LAST_UPDATED_BY | ● | Tc last updated by. | |
| TC_LAST_UPDATE_DATE | INCR | ● | Tc last update date. |
| TC_LAST_UPDATE_LOGIN | ● | Tc last update login. | |
| TC_LATEST_VERSION | ● | Tc latest version. | |
| TC_LAYER_CODE | ● | Code identifying the tc layer. | |
| TC_START_DATE | ● | Tc start date. | |
| TC_START_GMT_OFFSET | ● | Tc start gmt offset. | |
| TC_START_TIME | ● | Tc start time. | |
| TC_START_TIMEZONE_CODE | ● | Code identifying the tc start timezone. | |
| TC_STOP_DATE | ● | Tc stop date. | |
| TC_STOP_GMT_OFFSET | ● | Tc stop gmt offset. | |
| TC_STOP_TIME | ● | Tc stop time. | |
| TC_STOP_TIMEZONE_CODE | ● | Code identifying the tc stop timezone. | |
| TC_TM_REC_GRP_ID | ● | Identifier for the tc tm rec grp. | |
| TC_TM_REC_GRP_VERSION | ● | Tc tm rec grp version. | |
| TE_ACTIVITY_IN_ID | ● | Identifier for the te activity in. | |
| TE_ACTIVITY_OUT_ID | ● | Identifier for the te activity out. | |
| TE_COMMENT_TEXT | ● | Te comment text. | |
| TE_CREATED_BY | ● | Te created by. | |
| TE_CREATION_DATE | ● | Te creation date. | |
| TE_DATE_FROM | ● | Te date from. | |
| TE_DATE_TO | ● | Te date to. | |
| TE_DELETE_FLAG | ● | Indicator (Y/N) for the te delete. | |
| TE_LAST_UPDATED_BY | ● | Te last updated by. | |
| TE_LAST_UPDATE_DATE | INCR | ● | Te last update date. |
| TE_LAST_UPDATE_LOGIN | ● | Te last update login. | |
| TE_LATEST_VERSION | ● | Te latest version. | |
| TE_LAYER_CODE | ● | Code identifying the te layer. | |
| TE_MEASURE | ● | Te measure. | |
| TE_MEASURE_ABSENCE | ● | Te measure absence. | |
| TE_MEASURE_LABOR | ● | Te measure labor. | |
| TE_START_GMT_OFFSET | ● | Te start gmt offset. | |
| TE_START_TIME | ● | Te start time. | |
| TE_START_TIMEZONE_CODE | ● | Code identifying the te start timezone. | |
| TE_STOP_GMT_OFFSET | ● | Te stop gmt offset. | |
| TE_STOP_TIME | ● | Te stop time. | |
| TE_STOP_TIMEZONE_CODE | ● | Code identifying the te stop timezone. | |
| TE_SUBRESOURCE_ID | ● | Identifier for the te subresource. | |
| TE_TCSMR_CONFIG_SET_ID | ● | Identifier for the te tcsmr config set. | |
| TE_TCSMR_SET_ID | ● | Identifier for the te tcsmr set. | |
| TE_TIME_REPORTER_ID | ● | Identifier for the te time reporter. | |
| TE_TM_REC_ID | ● | Identifier for the te tm rec. | |
| TE_TM_REC_TYPE | ● | Type of te tm rec. | |
| TE_TM_REC_VERSION | ● | Te tm rec version. | |
| TE_UNIT_OF_MEASURE | ● | Te unit of measure. |
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 HWM_TM_RPT_ENTRY_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table