HWM_TCD_EXP_DATA_SCH_SHFT_A

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
SCHEDULE_SHIFT_ID OBJECT_VERSION_NUMBER SCHEDULE_SHIFT_NAME START_EARLY_GRACE START_LATE_GRACE END_EARLY_GRACE END_LATE_GRACE TOLERANCE START_EARLY_VIOLATION START_LATE_VIOLATION END_EARLY_VIOLATION END_LATE_VIOLATION DELETE_FLAG ENTERPRISE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SCHEDULE_SHIFT_VERSION STATUS REC_TYPE DURATION TIME_NOT_WORKED LATEST_VERSION TCD_EXP_DATA_ESS_PROCESS_ID TXN_CREATED_BY TXN_CREATION_DATE TXN_DELETE_FLAG TXN_ENTERPRISE_ID TXN_LAST_UPDATE_DATE TXN_LAST_UPDATE_LOGIN TXN_LAST_UPDATED_BY TXN_OBJECT_VERSION_NUMBER TXN_SCHEDULE_SHIFT_ID TXN_SCHEDULE_SHIFT_VERSION TXN_STATUS TCD_EXP_DATA_SCH_SHFT_TXN_ID TCD_EXP_DATA_TXN_BATCH_ID TCD_EXP_DATA_TXN_ID SHIFT_ID

Name

SCHEDULE_SHIFT_ID

OBJECT_VERSION_NUMBER

SCHEDULE_SHIFT_NAME

START_EARLY_GRACE

START_LATE_GRACE

END_EARLY_GRACE

END_LATE_GRACE

TOLERANCE

START_EARLY_VIOLATION

START_LATE_VIOLATION

END_EARLY_VIOLATION

END_LATE_VIOLATION

DELETE_FLAG

ENTERPRISE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SCHEDULE_SHIFT_VERSION

STATUS

REC_TYPE

DURATION

TIME_NOT_WORKED

LATEST_VERSION

TCD_EXP_DATA_ESS_PROCESS_ID

TXN_CREATED_BY

TXN_CREATION_DATE

TXN_DELETE_FLAG

TXN_ENTERPRISE_ID

TXN_LAST_UPDATE_DATE

TXN_LAST_UPDATE_LOGIN

TXN_LAST_UPDATED_BY

TXN_OBJECT_VERSION_NUMBER

TXN_SCHEDULE_SHIFT_ID

TXN_SCHEDULE_SHIFT_VERSION

TXN_STATUS

TCD_EXP_DATA_SCH_SHFT_TXN_ID

TCD_EXP_DATA_TXN_BATCH_ID

TCD_EXP_DATA_TXN_ID

SHIFT_ID

Query

SQL_Statement
SELECT SCH_SHFT.SCHEDULE_SHIFT_ID, SCH_SHFT.OBJECT_VERSION_NUMBER, SCH_SHFT.SCHEDULE_SHIFT_NAME, SCH_SHFT.START_EARLY_GRACE, SCH_SHFT.START_LATE_GRACE, SCH_SHFT.END_EARLY_GRACE, SCH_SHFT.END_LATE_GRACE, SCH_SHFT.TOLERANCE, SCH_SHFT.START_EARLY_VIOLATION, SCH_SHFT.START_LATE_VIOLATION, SCH_SHFT.END_EARLY_VIOLATION, SCH_SHFT.END_LATE_VIOLATION, SCH_SHFT.DELETE_FLAG, SCH_SHFT.ENTERPRISE_ID, SCH_SHFT.CREATED_BY, SCH_SHFT.CREATION_DATE, SCH_SHFT.LAST_UPDATED_BY, SCH_SHFT.LAST_UPDATE_DATE, SCH_SHFT.LAST_UPDATE_LOGIN, SCH_SHFT.SCHEDULE_SHIFT_VERSION, SCH_SHFT.STATUS, SCH_SHFT.REC_TYPE, SCH_SHFT.DURATION, SCH_SHFT.TIME_NOT_WORKED, SCH_SHFT.LATEST_VERSION, SCH_SHFT.TCD_EXP_DATA_ESS_PROCESS_ID, SCH_SHFT_TXN.CREATED_BY TXN_CREATED_BY, SCH_SHFT_TXN.CREATION_DATE TXN_CREATION_DATE, SCH_SHFT_TXN.DELETE_FLAG TXN_DELETE_FLAG, SCH_SHFT_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID, SCH_SHFT_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE, SCH_SHFT_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN, SCH_SHFT_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY, SCH_SHFT_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER, SCH_SHFT_TXN.SCHEDULE_SHIFT_ID TXN_SCHEDULE_SHIFT_ID, SCH_SHFT_TXN.SCHEDULE_SHIFT_VERSION TXN_SCHEDULE_SHIFT_VERSION, SCH_SHFT_TXN.STATUS TXN_STATUS, SCH_SHFT_TXN.TCD_EXP_DATA_SCH_SHFT_TXN_ID, SCH_SHFT_TXN.TCD_EXP_DATA_TXN_BATCH_ID, SCH_SHFT_TXN.TCD_EXP_DATA_TXN_ID, SCH_SHFT.SHIFT_ID SHIFT_ID FROM HWM_TCD_EXP_DATA_SCH_SHFT SCH_SHFT, HWM_TCD_EXP_DATA_SCH_SHFT_TXN SCH_SHFT_TXN WHERE SCH_SHFT.SCHEDULE_SHIFT_ID = SCH_SHFT_TXN.SCHEDULE_SHIFT_ID AND SCH_SHFT.SCHEDULE_SHIFT_VERSION = SCH_SHFT_TXN.SCHEDULE_SHIFT_VERSION AND SCH_SHFT.LATEST_VERSION = 'Y'

SQL_Statement

SELECT

SCH_SHFT.SCHEDULE_SHIFT_ID,

SCH_SHFT.OBJECT_VERSION_NUMBER,

SCH_SHFT.SCHEDULE_SHIFT_NAME,

SCH_SHFT.START_EARLY_GRACE,

SCH_SHFT.START_LATE_GRACE,

SCH_SHFT.END_EARLY_GRACE,

SCH_SHFT.END_LATE_GRACE,

SCH_SHFT.TOLERANCE,

SCH_SHFT.START_EARLY_VIOLATION,

SCH_SHFT.START_LATE_VIOLATION,

SCH_SHFT.END_EARLY_VIOLATION,

SCH_SHFT.END_LATE_VIOLATION,

SCH_SHFT.DELETE_FLAG,

SCH_SHFT.ENTERPRISE_ID,

SCH_SHFT.CREATED_BY,

SCH_SHFT.CREATION_DATE,

SCH_SHFT.LAST_UPDATED_BY,

SCH_SHFT.LAST_UPDATE_DATE,

SCH_SHFT.LAST_UPDATE_LOGIN,

SCH_SHFT.SCHEDULE_SHIFT_VERSION,

SCH_SHFT.STATUS,

SCH_SHFT.REC_TYPE,

SCH_SHFT.DURATION,

SCH_SHFT.TIME_NOT_WORKED,

SCH_SHFT.LATEST_VERSION,

SCH_SHFT.TCD_EXP_DATA_ESS_PROCESS_ID,

SCH_SHFT_TXN.CREATED_BY TXN_CREATED_BY,

SCH_SHFT_TXN.CREATION_DATE TXN_CREATION_DATE,

SCH_SHFT_TXN.DELETE_FLAG TXN_DELETE_FLAG,

SCH_SHFT_TXN.ENTERPRISE_ID TXN_ENTERPRISE_ID,

SCH_SHFT_TXN.LAST_UPDATE_DATE TXN_LAST_UPDATE_DATE,

SCH_SHFT_TXN.LAST_UPDATE_LOGIN TXN_LAST_UPDATE_LOGIN,

SCH_SHFT_TXN.LAST_UPDATED_BY TXN_LAST_UPDATED_BY,

SCH_SHFT_TXN.OBJECT_VERSION_NUMBER TXN_OBJECT_VERSION_NUMBER,

SCH_SHFT_TXN.SCHEDULE_SHIFT_ID TXN_SCHEDULE_SHIFT_ID,

SCH_SHFT_TXN.SCHEDULE_SHIFT_VERSION TXN_SCHEDULE_SHIFT_VERSION,

SCH_SHFT_TXN.STATUS TXN_STATUS,

SCH_SHFT_TXN.TCD_EXP_DATA_SCH_SHFT_TXN_ID,

SCH_SHFT_TXN.TCD_EXP_DATA_TXN_BATCH_ID,

SCH_SHFT_TXN.TCD_EXP_DATA_TXN_ID,

SCH_SHFT.SHIFT_ID SHIFT_ID

FROM

HWM_TCD_EXP_DATA_SCH_SHFT SCH_SHFT,

HWM_TCD_EXP_DATA_SCH_SHFT_TXN SCH_SHFT_TXN

WHERE

SCH_SHFT.SCHEDULE_SHIFT_ID = SCH_SHFT_TXN.SCHEDULE_SHIFT_ID AND SCH_SHFT.SCHEDULE_SHIFT_VERSION = SCH_SHFT_TXN.SCHEDULE_SHIFT_VERSION AND SCH_SHFT.LATEST_VERSION = 'Y'