This page (revision-21) was last changed on 18-Aug-2023 12:06 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by Kevin Higgs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
21 18-Aug-2023 12:06 7 KB Kevin Higgs to previous

Page References

Incoming links Outgoing links
LMTD LOADING DATE EFFECTIVE SPLITS
LMTD LOADING DATE EFFECTIVE SPLITS

Version management

Difference between version and

At line 48 added 2 lines
!!Sample #2
!!Insert a wage rate change to the P2K_CM_POSITION_DETAILS table with an effective date.
At line 49 changed 3 lines
!!Insert a wage rate change to the P2K_HR_ASSIGNMENT_DETAILS table with an effective date.
In this sample, the IEAS will be updated with a new wage rate as of a specific date.
In this sample, the IDPS will be updated with a new wage rate, rate basis and a change reason as of a specific date.
At line 54 changed one line
There will be no change made to any other field other than the CHANGE_CODE,EFFECTIVE and WAGE_RATE on P2K_HR_ASSIGNMENT_DETAILS.
In this sample, the inbound file will only contain the POSITION_CODE, WAGE_RATE and RATE_BASIS. All the other fields to be updated will come as constants in the interface.
At line 56 changed one line
!IDIF Set Up
!Sample #2 - File format
ABC01,53.10,07
ABC02,26.50,07
ABC03,35.67,07
MGRABC, 90000,01
!Sample #2 - IDIF Set Up
At line 75 added 13 lines
IEAS - EASD.EAS_ID.EEM_ID.EID_ID.PERSON_CODE,
EASD.EAS_ID.ASSIGNMENT_CODE,
EASD.EFFECTIVE
IDPS - DPD.DPS_ID_CHILD_OF.POSITION_CODE
DPD.DPS_ID_CHILD_OF.DEN_ID.ENTITY_CODE
DPD.EFFECTIVE,
IDJB - DJD.DJB_ID.JOB_CODE
DJD.DJB_ID.DUN_ID.UNIT_CODE
DJD.EFFECTIVE
IDDP -
IDUN -
IDGR -
IDWR -
This page (revision-21) was last changed on 18-Aug-2023 12:06 by Kevin HiggsTop