Oracle Fusion · Data dictionary
HWM_TM_ABS_ENTRY_V
SharedUsed in 0 subject areas84 reporting columnsBICC incremental-ready
denormalized view.
Primary key: not yet catalogued for HWM_TM_ABS_ENTRY_V, reference Oracle Tables & Views guide. · Incremental key: DAY_LAST_UPDATE_DATE, TIME_CARD_LAST_UPDATE_DATE, TIME_ENTRY_LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DAY_COMMENT_TEXT | ● | Day comment text. | |
| DAY_COMMIT_TIMESTAMP | ● | Day commit timestamp. | |
| DAY_CREATED_BY | ● | Day created by. | |
| DAY_CREATION_DATE | ● | Day creation date. | |
| DAY_DATA_SET_ID | ● | Identifier for the day data set. | |
| DAY_DATE_FROM | ● | Day date from. | |
| DAY_DATE_TO | ● | Day date to. | |
| DAY_DELETE_FLAG | ● | Indicator (Y/N) for the day delete. | |
| DAY_ENTERPRISE_ID | ● | Identifier for the day enterprise. | |
| 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_ORDER_ENTERED | ● | Day order entered. | |
| DAY_RESOURCE_ID | ● | Identifier for the day resource. | |
| DAY_RESOURCE_TYPE | ● | Type of day resource. | |
| DAY_START_TIME | ● | Day start time. | |
| DAY_STOP_TIME | ● | Day stop time. | |
| DAY_SUBRESOURCE_ID | ● | Identifier for the day subresource. | |
| DAY_TCSMR_CONFIG_SET_ID | ● | Identifier for the day tcsmr config set. | |
| DAY_TCSMR_SET_ID | ● | Identifier for the day tcsmr set. | |
| DAY_TIME_REPORTER_ID | ● | Identifier for the day time reporter. | |
| DAY_TM_REC_GRP_ID | ● | Identifier for the day tm rec grp. | |
| DAY_TM_REC_GRP_VERSION | ● | Day tm rec grp version. | |
| DAY_USER_STATUS | ● | Status of the day user. | |
| RESOURCE_ID | ● | Identifier for the resource. | |
| TIME_CARD_COMMENT_TEXT | ● | Time card comment text. | |
| TIME_CARD_COMMIT_TIMESTAMP | ● | Time card commit timestamp. | |
| TIME_CARD_CREATED_BY | ● | Time card created by. | |
| TIME_CARD_CREATION_DATE | ● | Time card creation date. | |
| TIME_CARD_DATA_SET_ID | ● | Identifier for the time card data set. | |
| TIME_CARD_DATE_FROM | ● | Time card date from. | |
| TIME_CARD_DATE_TO | ● | Time card date to. | |
| TIME_CARD_DELETE_FLAG | ● | Indicator (Y/N) for the time card delete. | |
| TIME_CARD_ENTERPRISE_ID | ● | Identifier for the time card enterprise. | |
| TIME_CARD_GRP_TYPE_ID | ● | Identifier for the time card grp type. | |
| TIME_CARD_LAST_UPDATED_BY | ● | Time card last updated by. | |
| TIME_CARD_LAST_UPDATE_DATE | INCR | ● | Time card last update date. |
| TIME_CARD_LAST_UPDATE_LOGIN | ● | Time card last update login. | |
| TIME_CARD_LATEST_VERSION | ● | Time card latest version. | |
| TIME_CARD_LAYER_CODE | ● | Code identifying the time card layer. | |
| TIME_CARD_ORDER_ENTERED | ● | Time card order entered. | |
| TIME_CARD_RESOURCE_ID | ● | Identifier for the time card resource. | |
| TIME_CARD_RESOURCE_TYPE | ● | Type of time card resource. | |
| TIME_CARD_START_TIME | ● | Time card start time. | |
| TIME_CARD_STOP_TIME | ● | Time card stop time. | |
| TIME_CARD_SUBRESOURCE_ID | ● | Identifier for the time card subresource. | |
| TIME_CARD_TCSMR_CONFIG_SET_ID | ● | Identifier for the time card tcsmr config set. | |
| TIME_CARD_TCSMR_SET_ID | ● | Identifier for the time card tcsmr set. | |
| TIME_CARD_TIME_REPORTER_ID | ● | Identifier for the time card time reporter. | |
| TIME_CARD_TM_REC_GRP_ID | ● | Identifier for the time card tm rec grp. | |
| TIME_CARD_TM_REC_GRP_VERSION | ● | Time card tm rec grp version. | |
| TIME_CARD_USER_STATUS | ● | Status of the time card user. | |
| TIME_ENTRY_ACTIVITY_EVENT_TIME | ● | Time entry activity event time. | |
| TIME_ENTRY_ACTIVITY_TYPE | ● | Type of time entry activity. | |
| TIME_ENTRY_COMMENT_TEXT | ● | Time entry comment text. | |
| TIME_ENTRY_CREATED_BY | ● | Time entry created by. | |
| TIME_ENTRY_CREATION_DATE | ● | Time entry creation date. | |
| TIME_ENTRY_DATA_SET_ID | ● | Identifier for the time entry data set. | |
| TIME_ENTRY_DATE_FROM | ● | Time entry date from. | |
| TIME_ENTRY_DATE_TO | ● | Time entry date to. | |
| TIME_ENTRY_DELETE_FLAG | ● | Indicator (Y/N) for the time entry delete. | |
| TIME_ENTRY_ENTERPRISE_ID | ● | Identifier for the time entry enterprise. | |
| TIME_ENTRY_LAST_UPDATED_BY | ● | Time entry last updated by. | |
| TIME_ENTRY_LAST_UPDATE_DATE | INCR | ● | Time entry last update date. |
| TIME_ENTRY_LAST_UPDATE_LOGIN | ● | Time entry last update login. | |
| TIME_ENTRY_LATEST_VERSION | ● | Time entry latest version. | |
| TIME_ENTRY_LAYER_CODE | ● | Code identifying the time entry layer. | |
| TIME_ENTRY_MEASURE | ● | Time entry measure. | |
| TIME_ENTRY_ORDER_ENTERED | ● | Time entry order entered. | |
| TIME_ENTRY_RESOURCE_TYPE | ● | Type of time entry resource. | |
| TIME_ENTRY_START_TIME | ● | Time entry start time. | |
| TIME_ENTRY_STOP_TIME | ● | Time entry stop time. | |
| TIME_ENTRY_SUBRESOURCE_ID | ● | Identifier for the time entry subresource. | |
| TIME_ENTRY_TCSMR_CONFIG_SET_ID | ● | Identifier for the time entry tcsmr config set. | |
| TIME_ENTRY_TCSMR_SET_ID | ● | Identifier for the time entry tcsmr set. | |
| TIME_ENTRY_TIME_REPORTER_ID | ● | Identifier for the time entry time reporter. | |
| TIME_ENTRY_TM_REC_ID | ● | Identifier for the time entry tm rec. | |
| TIME_ENTRY_TM_REC_TYPE | ● | Type of time entry tm rec. | |
| TIME_ENTRY_TM_REC_VERSION | ● | Time entry tm rec version. | |
| TIME_ENTRY_UNIT_OF_MEASURE | ● | Time entry unit of measure. | |
| TIME_ENTRY_USER_STATUS | ● | Status of the time entry user. |
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_ABS_ENTRY_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table