HDL - Absence Entry - ValueSets

GET_ASG_DETAILS
Get assignment details for HDL mapping
Data Loader
Table
Character
-----------------------------------------------------------------------------------

PER_ALL_ASSIGNMENTS_M PAAM, PER_ALL_ASSIGNMENTS_M PAAM2, PER_ALL_PEOPLE_F PAPF, PER_PERIODS_OF_SERVICE PPOS, HR_ALL_ORGANIZATION_UNITS_F HAOUF, XLE_ENTITY_PROFILES XLE

PAPF.PERSON_ID || '*' || XLE.NAME || '*' || PAAM2.ASSIGNMENT_NUMBER

PAPF.PERSON_NUMBER = :{PARAMETER.P_PER_NUM}
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND PAAM.PERSON_ID = PAPF.PERSON_ID
AND TO_DATE(:{PARAMETER.P_DUR}, 'YYYY/MM/DD') BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE
AND PAAM.ASSIGNMENT_TYPE = 'E'
AND PAAM2.ASSIGNMENT_ID = PAAM.WORK_TERMS_ASSIGNMENT_ID
AND PAAM.EFFECTIVE_START_DATE BETWEEN PAAM2.EFFECTIVE_START_DATE AND PAAM2.EFFECTIVE_END_DATE
AND PPOS.PERIOD_OF_SERVICE_ID = PAAM.PERIOD_OF_SERVICE_ID
AND HAOUF.ORGANIZATION_ID = PAAM.LEGAL_ENTITY_ID
AND PAAM.EFFECTIVE_START_DATE BETWEEN HAOUF.EFFECTIVE_START_DATE AND HAOUF.EFFECTIVE_END_DATE
AND XLE.LEGAL_ENTITY_ID = HAOUF.LEGAL_ENTITY_ID

PPOS.DATE_START DESC
=========================================================================================================================================================================


GET_ABSENCE_TYPE
Get Absence Type
Data Loader
Table
Character
-----------------------------------------------------------------------------
FF_USER_TABLES FUT, PER_LEGISLATIVE_DATA_GROUPS PLDG, FF_USER_COLUMN_INSTANCES_F FUCIF, FF_USER_COLUMNS FUC, FF_USER_COLUMNS_TL FUCT, FF_USER_ROWS_F FURF, FF_USER_ROWS_TL FURT

FUCIF.VALUE

FUT.BASE_USER_TABLE_NAME = 'LB_TRC_ABS_TYPE'
AND FUT.LEGISLATIVE_DATA_GROUP_ID = PLDG.LEGISLATIVE_DATA_GROUP_ID
AND FUT.USER_TABLE_ID = FUC.USER_TABLE_ID
AND FUC.USER_COLUMN_ID = FUCT.USER_COLUMN_ID
AND FUT.USER_TABLE_ID = FURF.USER_TABLE_ID
AND FURF.USER_ROW_ID = FURT.USER_ROW_ID
AND FUCIF.USER_ROW_ID = FURT.USER_ROW_ID
AND FUCIF.USER_COLUMN_ID = FUCT.USER_COLUMN_ID
AND FURT.LANGUAGE = 'US'
AND FUCT.LANGUAGE = 'US'
AND SYSDATE BETWEEN FURF.EFFECTIVE_START_DATE
AND FURF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN FUCIF.EFFECTIVE_START_DATE
AND FUCIF.EFFECTIVE_END_DATE
AND FUCT.USER_COLUMN_NAME = 'TRC_ABS_TYPE'
AND FURT.ROW_NAME = :{PARAMETER.P_TRC}
=========================================================================================================================================================================


GET_ABSENCE_DETAILS
Get current absence entry details
Data Loader
Table
Character
-----------------------------------------------------------------------
ANC_PER_ABS_ENTRIES ABS, ANC_PER_ABS_ENTRY_DTLS ABS_DTL, ANC_ABSENCE_TYPES_VL ABS_VL

ABS.PER_ABSENCE_ENTRY_ID || '*' || ABS_DTL.PER_ABS_ENTRY_DTL_ID || '*' || ABS_DTL.DURATION || '*' || ABS_VL.NAME

ABS_DTL.PER_ABSENCE_ENTRY_ID = ABS.PER_ABSENCE_ENTRY_ID
AND ABS_VL.ABSENCE_TYPE_ID = ABS.ABSENCE_TYPE_ID
AND TO_CHAR(ABS_DTL.ABSENCE_DATE, 'YYYY/MM/DD') = :{PARAMETER.P_DUR}
AND ABS_VL.NAME = :{PARAMETER.P_ABS_TYPE}
AND ABS.PERSON_ID = :{PARAMETER.P_PERSONID}
=========================================================================================================================================================================