HWM_TM_ABS_ENTRY

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
TIME_CARD_TM_REC_GRP_ID TIME_CARD_TM_REC_GRP_VERSION TIME_CARD_ENTERPRISE_ID TIME_CARD_GRP_TYPE_ID TIME_CARD_COMMIT_TIMESTAMP TIME_CARD_START_TIME TIME_CARD_STOP_TIME TIME_CARD_USER_STATUS TIME_CARD_DELETE_FLAG TIME_CARD_LAYER_CODE TIME_CARD_COMMENT_TEXT TIME_CARD_RESOURCE_ID TIME_CARD_RESOURCE_TYPE TIME_CARD_SUBRESOURCE_ID TIME_CARD_TIME_REPORTER_ID TIME_CARD_DATE_FROM TIME_CARD_DATE_TO TIME_CARD_ORDER_ENTERED TIME_CARD_TCSMR_CONFIG_SET_ID TIME_CARD_DATA_SET_ID TIME_CARD_LATEST_VERSION TIME_CARD_TCSMR_SET_ID TIME_CARD_CREATED_BY TIME_CARD_CREATION_DATE TIME_CARD_LAST_UPDATED_BY TIME_CARD_LAST_UPDATE_DATE TIME_CARD_LAST_UPDATE_LOGIN DAY_TM_REC_GRP_ID DAY_TM_REC_GRP_VERSION DAY_ENTERPRISE_ID DAY_GRP_TYPE_ID DAY_COMMIT_TIMESTAMP DAY_START_TIME DAY_STOP_TIME DAY_USER_STATUS DAY_DELETE_FLAG DAY_LAYER_CODE DAY_COMMENT_TEXT DAY_RESOURCE_ID DAY_RESOURCE_TYPE DAY_SUBRESOURCE_ID DAY_TIME_REPORTER_ID DAY_DATE_FROM DAY_DATE_TO DAY_ORDER_ENTERED DAY_TCSMR_CONFIG_SET_ID DAY_DATA_SET_ID DAY_LATEST_VERSION DAY_TCSMR_SET_ID DAY_CREATED_BY DAY_CREATION_DATE DAY_LAST_UPDATED_BY DAY_LAST_UPDATE_DATE DAY_LAST_UPDATE_LOGIN TIME_ENTRY_TM_REC_ID TIME_ENTRY_TM_REC_VERSION TIME_ENTRY_ENTERPRISE_ID TIME_ENTRY_TM_REC_TYPE TIME_ENTRY_ACTIVITY_TYPE TIME_ENTRY_ACTIVITY_EVENT_TIME TIME_ENTRY_UNIT_OF_MEASURE TIME_ENTRY_START_TIME TIME_ENTRY_STOP_TIME TIME_ENTRY_USER_STATUS TIME_ENTRY_DELETE_FLAG TIME_ENTRY_LAYER_CODE TIME_ENTRY_COMMENT_TEXT RESOURCE_ID TIME_ENTRY_RESOURCE_TYPE TIME_ENTRY_SUBRESOURCE_ID TIME_ENTRY_TIME_REPORTER_ID TIME_ENTRY_DATE_FROM TIME_ENTRY_DATE_TO TIME_ENTRY_ORDER_ENTERED TIME_ENTRY_TCSMR_CONFIG_SET_ID TIME_ENTRY_DATA_SET_ID TIME_ENTRY_LATEST_VERSION TIME_ENTRY_MEASURE TIME_ENTRY_TCSMR_SET_ID TIME_ENTRY_CREATED_BY TIME_ENTRY_CREATION_DATE TIME_ENTRY_LAST_UPDATED_BY TIME_ENTRY_LAST_UPDATE_DATE TIME_ENTRY_LAST_UPDATE_LOGIN

Name

TIME_CARD_TM_REC_GRP_ID

TIME_CARD_TM_REC_GRP_VERSION

TIME_CARD_ENTERPRISE_ID

TIME_CARD_GRP_TYPE_ID

TIME_CARD_COMMIT_TIMESTAMP

TIME_CARD_START_TIME

TIME_CARD_STOP_TIME

TIME_CARD_USER_STATUS

TIME_CARD_DELETE_FLAG

TIME_CARD_LAYER_CODE

TIME_CARD_COMMENT_TEXT

TIME_CARD_RESOURCE_ID

TIME_CARD_RESOURCE_TYPE

TIME_CARD_SUBRESOURCE_ID

TIME_CARD_TIME_REPORTER_ID

TIME_CARD_DATE_FROM

TIME_CARD_DATE_TO

TIME_CARD_ORDER_ENTERED

TIME_CARD_TCSMR_CONFIG_SET_ID

TIME_CARD_DATA_SET_ID

TIME_CARD_LATEST_VERSION

TIME_CARD_TCSMR_SET_ID

TIME_CARD_CREATED_BY

TIME_CARD_CREATION_DATE

TIME_CARD_LAST_UPDATED_BY

TIME_CARD_LAST_UPDATE_DATE

TIME_CARD_LAST_UPDATE_LOGIN

DAY_TM_REC_GRP_ID

DAY_TM_REC_GRP_VERSION

DAY_ENTERPRISE_ID

DAY_GRP_TYPE_ID

DAY_COMMIT_TIMESTAMP

DAY_START_TIME

DAY_STOP_TIME

DAY_USER_STATUS

DAY_DELETE_FLAG

DAY_LAYER_CODE

DAY_COMMENT_TEXT

DAY_RESOURCE_ID

DAY_RESOURCE_TYPE

DAY_SUBRESOURCE_ID

DAY_TIME_REPORTER_ID

DAY_DATE_FROM

DAY_DATE_TO

DAY_ORDER_ENTERED

DAY_TCSMR_CONFIG_SET_ID

DAY_DATA_SET_ID

DAY_LATEST_VERSION

DAY_TCSMR_SET_ID

DAY_CREATED_BY

DAY_CREATION_DATE

DAY_LAST_UPDATED_BY

DAY_LAST_UPDATE_DATE

DAY_LAST_UPDATE_LOGIN

TIME_ENTRY_TM_REC_ID

TIME_ENTRY_TM_REC_VERSION

TIME_ENTRY_ENTERPRISE_ID

TIME_ENTRY_TM_REC_TYPE

TIME_ENTRY_ACTIVITY_TYPE

TIME_ENTRY_ACTIVITY_EVENT_TIME

TIME_ENTRY_UNIT_OF_MEASURE

TIME_ENTRY_START_TIME

TIME_ENTRY_STOP_TIME

TIME_ENTRY_USER_STATUS

TIME_ENTRY_DELETE_FLAG

TIME_ENTRY_LAYER_CODE

TIME_ENTRY_COMMENT_TEXT

RESOURCE_ID

TIME_ENTRY_RESOURCE_TYPE

TIME_ENTRY_SUBRESOURCE_ID

TIME_ENTRY_TIME_REPORTER_ID

TIME_ENTRY_DATE_FROM

TIME_ENTRY_DATE_TO

TIME_ENTRY_ORDER_ENTERED

TIME_ENTRY_TCSMR_CONFIG_SET_ID

TIME_ENTRY_DATA_SET_ID

TIME_ENTRY_LATEST_VERSION

TIME_ENTRY_MEASURE

TIME_ENTRY_TCSMR_SET_ID

TIME_ENTRY_CREATED_BY

TIME_ENTRY_CREATION_DATE

TIME_ENTRY_LAST_UPDATED_BY

TIME_ENTRY_LAST_UPDATE_DATE

TIME_ENTRY_LAST_UPDATE_LOGIN

Query

SQL_Statement
select TimeCard.TM_REC_GRP_ID TIME_CARD_TM_REC_GRP_ID, TimeCard.TM_REC_GRP_VERSION TIME_CARD_TM_REC_GRP_VERSION, TimeCard.ENTERPRISE_ID TIME_CARD_ENTERPRISE_ID, TimeCard.GRP_TYPE_ID TIME_CARD_GRP_TYPE_ID, TimeCard.COMMIT_TIMESTAMP TIME_CARD_COMMIT_TIMESTAMP, TimeCard.START_TIME TIME_CARD_START_TIME, TimeCard.STOP_TIME TIME_CARD_STOP_TIME, TimeCard.USER_STATUS TIME_CARD_USER_STATUS, TimeCard.DELETE_FLAG TIME_CARD_DELETE_FLAG, TimeCard.LAYER_CODE TIME_CARD_LAYER_CODE, TimeCard.COMMENT_TEXT TIME_CARD_COMMENT_TEXT, TimeCard.RESOURCE_ID TIME_CARD_RESOURCE_ID, TimeCard.RESOURCE_TYPE TIME_CARD_RESOURCE_TYPE, TimeCard.SUBRESOURCE_ID TIME_CARD_SUBRESOURCE_ID, TimeCard.TIME_REPORTER_ID TIME_CARD_TIME_REPORTER_ID, TimeCard.DATE_FROM TIME_CARD_DATE_FROM, TimeCard.DATE_TO TIME_CARD_DATE_TO, TimeCard.ORDER_ENTERED TIME_CARD_ORDER_ENTERED, TimeCard.TCSMR_CONFIG_SET_ID TIME_CARD_TCSMR_CONFIG_SET_ID, TimeCard.DATA_SET_ID TIME_CARD_DATA_SET_ID, TimeCard.LATEST_VERSION TIME_CARD_LATEST_VERSION, TimeCard.TCSMR_SET_ID TIME_CARD_TCSMR_SET_ID, TimeCard.CREATED_BY TIME_CARD_CREATED_BY, TimeCard.CREATION_DATE TIME_CARD_CREATION_DATE, TimeCard.LAST_UPDATED_BY TIME_CARD_LAST_UPDATED_BY, TimeCard.LAST_UPDATE_DATE TIME_CARD_LAST_UPDATE_DATE, TimeCard.LAST_UPDATE_LOGIN TIME_CARD_LAST_UPDATE_LOGIN, TimeCardDay.TM_REC_GRP_ID DAY_TM_REC_GRP_ID, TimeCardDay.TM_REC_GRP_VERSION DAY_TM_REC_GRP_VERSION, TimeCardDay.ENTERPRISE_ID DAY_ENTERPRISE_ID, TimeCardDay.GRP_TYPE_ID DAY_GRP_TYPE_ID, TimeCardDay.COMMIT_TIMESTAMP DAY_COMMIT_TIMESTAMP, TimeCardDay.START_TIME DAY_START_TIME, TimeCardDay.STOP_TIME DAY_STOP_TIME, TimeCardDay.USER_STATUS DAY_USER_STATUS, TimeCardDay.DELETE_FLAG DAY_DELETE_FLAG, TimeCardDay.LAYER_CODE DAY_LAYER_CODE, TimeCardDay.COMMENT_TEXT DAY_COMMENT_TEXT, TimeCardDay.RESOURCE_ID DAY_RESOURCE_ID, TimeCardDay.RESOURCE_TYPE DAY_RESOURCE_TYPE, TimeCardDay.SUBRESOURCE_ID DAY_SUBRESOURCE_ID, TimeCardDay.TIME_REPORTER_ID DAY_TIME_REPORTER_ID, TimeCardDay.DATE_FROM DAY_DATE_FROM, TimeCardDay.DATE_TO DAY_DATE_TO, TimeCardDay.ORDER_ENTERED DAY_ORDER_ENTERED, TimeCardDay.TCSMR_CONFIG_SET_ID DAY_TCSMR_CONFIG_SET_ID, TimeCardDay.DATA_SET_ID DAY_DATA_SET_ID, TimeCardDay.LATEST_VERSION DAY_LATEST_VERSION, TimeCardDay.TCSMR_SET_ID DAY_TCSMR_SET_ID, TimeCardDay.CREATED_BY DAY_CREATED_BY, TimeCardDay.CREATION_DATE DAY_CREATION_DATE, TimeCardDay.LAST_UPDATED_BY DAY_LAST_UPDATED_BY, TimeCardDay.LAST_UPDATE_DATE DAY_LAST_UPDATE_DATE, TimeCardDay.LAST_UPDATE_LOGIN DAY_LAST_UPDATE_LOGIN, TimeEntry.TM_REC_ID TIME_ENTRY_TM_REC_ID, TimeEntry.TM_REC_VERSION TIME_ENTRY_TM_REC_VERSION, TimeEntry.ENTERPRISE_ID TIME_ENTRY_ENTERPRISE_ID, TimeEntry.TM_REC_TYPE TIME_ENTRY_TM_REC_TYPE, TimeEntry.ACTIVITY_TYPE TIME_ENTRY_ACTIVITY_TYPE, TimeEntry.ACTIVITY_EVENT_TIME TIME_ENTRY_ACTIVITY_EVENT_TIME, TimeEntry.UNIT_OF_MEASURE TIME_ENTRY_UNIT_OF_MEASURE, TimeEntry.START_TIME TIME_ENTRY_START_TIME, TimeEntry.STOP_TIME TIME_ENTRY_STOP_TIME, TimeEntry.USER_STATUS TIME_ENTRY_USER_STATUS, TimeEntry.DELETE_FLAG TIME_ENTRY_DELETE_FLAG, TimeEntry.LAYER_CODE TIME_ENTRY_LAYER_CODE, TimeEntry.COMMENT_TEXT TIME_ENTRY_COMMENT_TEXT, TimeEntry.RESOURCE_ID RESOURCE_ID, TimeEntry.RESOURCE_TYPE TIME_ENTRY_RESOURCE_TYPE, TimeEntry.SUBRESOURCE_ID TIME_ENTRY_SUBRESOURCE_ID, TimeEntry.TIME_REPORTER_ID TIME_ENTRY_TIME_REPORTER_ID, TimeEntry.DATE_FROM TIME_ENTRY_DATE_FROM, TimeEntry.DATE_TO TIME_ENTRY_DATE_TO, TimeEntry.ORDER_ENTERED TIME_ENTRY_ORDER_ENTERED, TimeEntry.TCSMR_CONFIG_SET_ID TIME_ENTRY_TCSMR_CONFIG_SET_ID, TimeEntry.DATA_SET_ID TIME_ENTRY_DATA_SET_ID, TimeEntry.LATEST_VERSION TIME_ENTRY_LATEST_VERSION, TimeEntry.MEASURE TIME_ENTRY_MEASURE, TimeEntry.TCSMR_SET_ID TIME_ENTRY_TCSMR_SET_ID, TimeEntry.CREATED_BY TIME_ENTRY_CREATED_BY, TimeEntry.CREATION_DATE TIME_ENTRY_CREATION_DATE, TimeEntry.LAST_UPDATED_BY TIME_ENTRY_LAST_UPDATED_BY, TimeEntry.LAST_UPDATE_DATE TIME_ENTRY_LAST_UPDATE_DATE, TimeEntry.LAST_UPDATE_LOGIN TIME_ENTRY_LAST_UPDATE_LOGIN from HWM_TM_REC TimeEntry, HWM_TM_REC_GRP TimeCard, HWM_TM_REC_GRP TimeCardDay where TimeCard.TM_REC_GRP_ID = TimeCardDay.PARENT_TM_REC_GRP_ID and TimeCard.TM_REC_GRP_VERSION = TimeCardDay.PARENT_TM_REC_GRP_VERSION and TimeEntry.START_TIME between TimeCardDay.START_TIME and TimeCardDay.STOP_TIME and TimeEntry.RESOURCE_ID = TimeCardDay.RESOURCE_ID and upper(TimeEntry.LAYER_CODE) = 'ABSENCES' and TimeCard.GRP_TYPE_ID = 100

SQL_Statement

select TimeCard.TM_REC_GRP_ID TIME_CARD_TM_REC_GRP_ID,

TimeCard.TM_REC_GRP_VERSION TIME_CARD_TM_REC_GRP_VERSION,

TimeCard.ENTERPRISE_ID TIME_CARD_ENTERPRISE_ID,

TimeCard.GRP_TYPE_ID TIME_CARD_GRP_TYPE_ID,

TimeCard.COMMIT_TIMESTAMP TIME_CARD_COMMIT_TIMESTAMP,

TimeCard.START_TIME TIME_CARD_START_TIME,

TimeCard.STOP_TIME TIME_CARD_STOP_TIME,

TimeCard.USER_STATUS TIME_CARD_USER_STATUS,

TimeCard.DELETE_FLAG TIME_CARD_DELETE_FLAG,

TimeCard.LAYER_CODE TIME_CARD_LAYER_CODE,

TimeCard.COMMENT_TEXT TIME_CARD_COMMENT_TEXT,

TimeCard.RESOURCE_ID TIME_CARD_RESOURCE_ID,

TimeCard.RESOURCE_TYPE TIME_CARD_RESOURCE_TYPE,

TimeCard.SUBRESOURCE_ID TIME_CARD_SUBRESOURCE_ID,

TimeCard.TIME_REPORTER_ID TIME_CARD_TIME_REPORTER_ID,

TimeCard.DATE_FROM TIME_CARD_DATE_FROM,

TimeCard.DATE_TO TIME_CARD_DATE_TO,

TimeCard.ORDER_ENTERED TIME_CARD_ORDER_ENTERED,

TimeCard.TCSMR_CONFIG_SET_ID TIME_CARD_TCSMR_CONFIG_SET_ID,

TimeCard.DATA_SET_ID TIME_CARD_DATA_SET_ID,

TimeCard.LATEST_VERSION TIME_CARD_LATEST_VERSION,

TimeCard.TCSMR_SET_ID TIME_CARD_TCSMR_SET_ID,

TimeCard.CREATED_BY TIME_CARD_CREATED_BY,

TimeCard.CREATION_DATE TIME_CARD_CREATION_DATE,

TimeCard.LAST_UPDATED_BY TIME_CARD_LAST_UPDATED_BY,

TimeCard.LAST_UPDATE_DATE TIME_CARD_LAST_UPDATE_DATE,

TimeCard.LAST_UPDATE_LOGIN TIME_CARD_LAST_UPDATE_LOGIN,

TimeCardDay.TM_REC_GRP_ID DAY_TM_REC_GRP_ID,

TimeCardDay.TM_REC_GRP_VERSION DAY_TM_REC_GRP_VERSION,

TimeCardDay.ENTERPRISE_ID DAY_ENTERPRISE_ID,

TimeCardDay.GRP_TYPE_ID DAY_GRP_TYPE_ID,

TimeCardDay.COMMIT_TIMESTAMP DAY_COMMIT_TIMESTAMP,

TimeCardDay.START_TIME DAY_START_TIME,

TimeCardDay.STOP_TIME DAY_STOP_TIME,

TimeCardDay.USER_STATUS DAY_USER_STATUS,

TimeCardDay.DELETE_FLAG DAY_DELETE_FLAG,

TimeCardDay.LAYER_CODE DAY_LAYER_CODE,

TimeCardDay.COMMENT_TEXT DAY_COMMENT_TEXT,

TimeCardDay.RESOURCE_ID DAY_RESOURCE_ID,

TimeCardDay.RESOURCE_TYPE DAY_RESOURCE_TYPE,

TimeCardDay.SUBRESOURCE_ID DAY_SUBRESOURCE_ID,

TimeCardDay.TIME_REPORTER_ID DAY_TIME_REPORTER_ID,

TimeCardDay.DATE_FROM DAY_DATE_FROM,

TimeCardDay.DATE_TO DAY_DATE_TO,

TimeCardDay.ORDER_ENTERED DAY_ORDER_ENTERED,

TimeCardDay.TCSMR_CONFIG_SET_ID DAY_TCSMR_CONFIG_SET_ID,

TimeCardDay.DATA_SET_ID DAY_DATA_SET_ID,

TimeCardDay.LATEST_VERSION DAY_LATEST_VERSION,

TimeCardDay.TCSMR_SET_ID DAY_TCSMR_SET_ID,

TimeCardDay.CREATED_BY DAY_CREATED_BY,

TimeCardDay.CREATION_DATE DAY_CREATION_DATE,

TimeCardDay.LAST_UPDATED_BY DAY_LAST_UPDATED_BY,

TimeCardDay.LAST_UPDATE_DATE DAY_LAST_UPDATE_DATE,

TimeCardDay.LAST_UPDATE_LOGIN DAY_LAST_UPDATE_LOGIN,

TimeEntry.TM_REC_ID TIME_ENTRY_TM_REC_ID,

TimeEntry.TM_REC_VERSION TIME_ENTRY_TM_REC_VERSION,

TimeEntry.ENTERPRISE_ID TIME_ENTRY_ENTERPRISE_ID,

TimeEntry.TM_REC_TYPE TIME_ENTRY_TM_REC_TYPE,

TimeEntry.ACTIVITY_TYPE TIME_ENTRY_ACTIVITY_TYPE,

TimeEntry.ACTIVITY_EVENT_TIME TIME_ENTRY_ACTIVITY_EVENT_TIME,

TimeEntry.UNIT_OF_MEASURE TIME_ENTRY_UNIT_OF_MEASURE,

TimeEntry.START_TIME TIME_ENTRY_START_TIME,

TimeEntry.STOP_TIME TIME_ENTRY_STOP_TIME,

TimeEntry.USER_STATUS TIME_ENTRY_USER_STATUS,

TimeEntry.DELETE_FLAG TIME_ENTRY_DELETE_FLAG,

TimeEntry.LAYER_CODE TIME_ENTRY_LAYER_CODE,

TimeEntry.COMMENT_TEXT TIME_ENTRY_COMMENT_TEXT,

TimeEntry.RESOURCE_ID RESOURCE_ID,

TimeEntry.RESOURCE_TYPE TIME_ENTRY_RESOURCE_TYPE,

TimeEntry.SUBRESOURCE_ID TIME_ENTRY_SUBRESOURCE_ID,

TimeEntry.TIME_REPORTER_ID TIME_ENTRY_TIME_REPORTER_ID,

TimeEntry.DATE_FROM TIME_ENTRY_DATE_FROM,

TimeEntry.DATE_TO TIME_ENTRY_DATE_TO,

TimeEntry.ORDER_ENTERED TIME_ENTRY_ORDER_ENTERED,

TimeEntry.TCSMR_CONFIG_SET_ID TIME_ENTRY_TCSMR_CONFIG_SET_ID,

TimeEntry.DATA_SET_ID TIME_ENTRY_DATA_SET_ID,

TimeEntry.LATEST_VERSION TIME_ENTRY_LATEST_VERSION,

TimeEntry.MEASURE TIME_ENTRY_MEASURE,

TimeEntry.TCSMR_SET_ID TIME_ENTRY_TCSMR_SET_ID,

TimeEntry.CREATED_BY TIME_ENTRY_CREATED_BY,

TimeEntry.CREATION_DATE TIME_ENTRY_CREATION_DATE,

TimeEntry.LAST_UPDATED_BY TIME_ENTRY_LAST_UPDATED_BY,

TimeEntry.LAST_UPDATE_DATE TIME_ENTRY_LAST_UPDATE_DATE,

TimeEntry.LAST_UPDATE_LOGIN TIME_ENTRY_LAST_UPDATE_LOGIN

from HWM_TM_REC TimeEntry,

HWM_TM_REC_GRP TimeCard,

HWM_TM_REC_GRP TimeCardDay

where TimeCard.TM_REC_GRP_ID = TimeCardDay.PARENT_TM_REC_GRP_ID

and TimeCard.TM_REC_GRP_VERSION = TimeCardDay.PARENT_TM_REC_GRP_VERSION

and TimeEntry.START_TIME between TimeCardDay.START_TIME and TimeCardDay.STOP_TIME

and TimeEntry.RESOURCE_ID = TimeCardDay.RESOURCE_ID

and upper(TimeEntry.LAYER_CODE) = 'ABSENCES'

and TimeCard.GRP_TYPE_ID = 100