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 1 added 6 lines
!!!LMTD LOADING DATE EFFECTIVE SPLITS
\\
The LMTD process can be used to insert date effective records onto date sensitive child tables.\\
\\
An IDIF will be required that uses the [Interface type|INTERFACE_TYPE] of 'EFFECTIVE SPLIT'. If the interdface uses any other type the values will not load correctly.\\
\\
At line 54 changed one line
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.
In this sample, the inbound file will only contain the POSITION_CODE, WAGE_RATE and a rate basis. All the other fields to be updated will come as constants in the interface.
The rate basis will need to be translated to match the values found on the [X_RATE_BASIS] lexicon on [IMLN]. Note the the start and end position in the IDIF are set to 0 where columns are not found on the file.
At line 57 changed 4 lines
ABC01,53.10,07
ABC02,26.50,07
ABC03,35.67,07
MGRABC, 90000,01
ABC01,53.10,HR\\
ABC02,26.50,HR\\
ABC03,35.67,HR\\
MGRABC,90000,YR
At line 65 changed 6 lines
|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).
|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
At line 72 removed 17 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 -
At line 81 added 17 lines
!!Minimum set up requirements for effective date split screens
\\
The following chart shows the minimum set up required in an IDIF record to insert a new date effective record.\\
Once the fields found in the "Required" column have been defined, any value found in on the "Subject Table" can be updated. Please use the [Maintain Column Details|IMCD] form in the application for a listing of columns available to update based on you subject table.\\
\\
!NOTE: this process will allow the update of [User Defined Columns|USER DEFINED COLUMN], but will not be able to update [User Defined Fields|USER DEFINED FIELD].
\\
\\
||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_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.EFFECTIVE|
|P2K_CM_DEPARTMENT_DETAILS|DPD|IDDP|DDD.DDP_ID.DEPARTMENT_CODE,\\DDD.DDP_ID.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|DGRD|IDGR|DGD.DGR_ID.GROUP_CODE,\\DGD.DGR_ID.DEN_ID.ENTITY_CODE,\\DGRD.EFFECTIVE
|P2K_CM_WORK_RULES|DRWD|IDWR|DWRD.DWR_ID.WORK_RULE_CODE,\\DWRD.DWR_ID.DEN_ID.ENTITY_CODE,\\DWRD.EFFECTIVE
This page (revision-21) was last changed on 18-Aug-2023 12:06 by Kevin HiggsTop