Rec # | Field # | Name | Beg Pos | End Pos | Field Type | Record Type | Add to UK Set | Constant Value | Derivation Expression | Notes |
---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | HEADER RECORD* | -1 | -1 | Char | Header | off | Must have Record Type of Header Record |
0 | 1 | HEADER RECORD* | -1 | -1 | Char | Header | Must have Record Type of Header Record | |||
1 | 1 | EASD.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Char | Y | Person Code using in the IEID to identify the employee | |||
1 | 2 | EASD.EAS_ID.ASSIGNMENT_CODE | -1 | -1 | Char | Y | Assignment must match the code for the employee on IEAS | |||
1 | 3 | EASD.EFFECTIVE | -1 | -1 | Char | Y | TO_CHAR(TO_DATE(RTRIM((~)), 'MM/DD/YYYY'),'DD-Mon-YYYY') | Formats date to match Personality standards. This deriviation is only required if the inbound date format does not match DD-MON-YYYY | ||
1 | 4 | EASD.DCR_ID.CHANGE_CODE | -1 | -1 | Char | Optional Field - Change code as seen on IDCR | ||||
1 | 5 | EASD.DPS_ID | -1 | -1 | Char | Must be in the form of the ID of the P2K_CM_POSITIONS code (Positions may have more than 1 matching POSITION_CODE. So ID must be used). |
Rec # | Field # | Name | Beg Pos | End Pos | Field Type | Record Type | Add to UK Set | Constant Value | Derivation Expression | Notes |
---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | HEADER RECORD* | -1 | -1 | Char | Header | Must have Record Type of Header Record | |||
1 | 1 | EASD.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Char | Y | Person Code using in the IEID to identify the employee | |||
1 | 2 | EASD.EAS_ID.ASSIGNMENT_CODE | -1 | -1 | Char | Y | Assignment must match the code for the employee on IEAS | |||
1 | 3 | EASD.EFFECTIVE | -1 | -1 | Char | Y | TO_CHAR(TO_DATE(RTRIM((~)), 'MM/DD/YYYY'),'DD-Mon-YYYY') | Formats date to match Personality standards. This deriviation is only required if the inbound date format does not match DD-MON-YYYY | ||
1 | 4 | EASD.DCR_ID.CHANGE_CODE | -1 | -1 | Char | Optional Field - Change code as seen on IDCR | ||||
1 | 5 | EASD.DPS_ID | -1 | -1 | Char | Must be in the form of the ID of the P2K_CM_POSITIONS code (Positions may have more than 1 matching POSITION_CODE. So ID must be used). |
Rec # | Field # | Name | Beg Pos | End Pos | Field Type | Record Type | Add to UK Set | Constant Value | Derivation Expression | Notes |
---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | HEADER RECORD* | -1 | -1 | Char | Header | Must have Record Type of Header Record | |||
1 | 1 | DPD.DPS_ID_CHILD_OF.POSITION_CODE | -1 | -1 | Char | Y | Position code as seen on IDPS | |||
1 | 2 | DPD.WAGE_RATE | -1 | -1 | Char | Wage Rate to be updated | ||||
1 | 3 | DPD.RATE_BASIS | -1 | -1 | Char | DECODE(~,'HR','07','01') | Changes the value in the file into the saved value of the lexicon HR = 07, YR = 01 | |||
1 | 4 | DPD.DCR_ID.CHANGE_CODE | 0 | 0 | Char | COLA INCREASE | Optional Field - Change code as seen on IDCR | |||
1 | 5 | DPD.EFFECTIVE | 0 | 0 | Char | Y | 01-MAR-2021 | Must be in the form DD-MON-YYYY | ||
1 | 6 | DPD.DPS_ID_CHILD_OF.DEN_ID.ENTITY_CODE | 0 | 0 | Char | Y | ABC123 | Entity Code as seen on IDEN |
Subject Table | Alias | Sample Screen | Required** | |
---|---|---|---|---|
P2K_HR_ASSIGNMENT_DETAILS | EASD | IEAS | EASD.EAS_ID.EEM_ID.EID_ID.PERSON_CODE, EASD.EAS_ID.ASSIGNMENT_CODE, EASD.EFFECTIVE | |
P2K_HR_PERSONALS | EPS | IEPI | EPS.EID_ID.PERSON_CODE, EPS.EFFECTIVE | |
P2K_CM_POSITION_DETAILS | DPD | IDPS | DPD.DPS_ID_CHILD_OF.POSITION_CODE, DPD.DPS_ID_CHILD_OF.DEN_ID.ENTITY_CODE, DPD.EFFECTIVE | |
P2K_CM_JOB_DETAILS | DJD | IDJB | DJD.DJB_ID.JOB_CODE, DJD.DJB_ID.DUN_ID.UNIT_CODE, DJD.DJB_ID.DUN_ID.DEN_ID.ENTITY_CODE, DJD.EFFECTIVE | |
P2K_CM_DEPARTMENT_DETAILS | DPD | IDDP | DDD.DDP_ID.DEPARTMENT_CODE, DDD.DDP_ID.DEN_ID_LEGAL.DEN_ID.ENTITY_CODE, DDD.EFFECTIVE | |
P2K_CM_UNIT_DETAILS | DUD | IDUN | DUD.DUN_ID.UNIT_CODE, DUD.DUN_ID.DEN_ID.ENTITY_CODE, DUD.EFFECTIVE | |
P2K_CM_GROUP_DETAILS | DGD | IDGR | DGD.DGR_ID.GROUP_CODE, DGD.DGR_ID.DEN_ID.ENTITY_CODE, DGD.DGR_ID.DUN_ID.UNIT_CODE, DGD.EFFECTIVE | |
P2K_CM_WORK_RULES | DRWD | IDWR | DWRD.DWR_ID.WORK_RULE_CODE, DWRD.DWR_ID.DEN_ID.ENTITY_CODE, DWRD.EFFECTIVE | |
P2K_SA_SALARY_RANGE_DETAILS | SSRD | ISSR | SSRD.SSR_ID.RANGE_CODE, SSRD.SSR_ID.DEN_ID.ENTITY_CODE, SSRD.EFFECTIVE | |
P2K_SA_WAGE_STEP_DETAILS | SWSD | ISWS | SWSD.SWSS_ID.SWS_ID.SCALE_CODE, SWSD.SWSS_ID.SWS_ID.DUN_ID.UNIT_CODE, SWSD.SWSS_ID.SWS_ID.DUN_ID.DEN_ID.ENTITY_CODE, SWSD.SWSS_ID.STEP_CODE, SWSD.SWSS_ID.STEP_SEQUENCE, SWSD.EFFECTIVE |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation