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

Version management

Difference between version and

At line 5 changed one line
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.\\
An IDIF interface will need to be established. The interface must use the [Interface type|INTERFACE_TYPE] of 'EFFECTIVE SPLIT'. If the interface uses any other type the values will not load correctly.\\
At line 10 added one line
All samples show the required fields only to insert a new record. Additional fields to be updated may be added to these interfaces provided they are found on the subject table being updated.\\
At line 10 changed one line
All samples show the required fields only to insert a new record. Additional fields to be updated may be added to these interfaces provided they are found on the subject table being updated.
!!DISABLE TRIGGERS
If doing a __mass upload__ of data to a table containing workflow triggers, it is highly recommended to disable those triggers prior to performing the load. \\
At line 15 added 3 lines
1) Prior to load - __ALTER TRIGGER P2K_XXXX_BIUD DISABLE;__\\
2) Complete the load\\
3) After the load - __ALTER TRIGGER P2K_XXXX_BIUD ENABLE;__\\
At line 16 removed one line
\\
At line 23 changed one line
\\
At line 32 added one line
\\
At line 40 added 2 lines
\\
||Rec\\ #||Field\\ #||Name||Beg\\ Pos|| End\\ Pos||Field\\ Type||Record\\ Type||Add to\\UK Set||Constant\\ Value||Derivation\\ Expression||Notes
At line 41 removed one line
At line 43 removed one line
At line 53 changed one line
\\
At line 55 changed 2 lines
!!Insert a wage rate change to the P2K_CM_POSITION_DETAILS table with an effective date.
!Insert a wage rate change to the P2K_CM_POSITION_DETAILS table with an effective date.
\\
At line 65 added 2 lines
The inbound file will only contain the [position code|IDPS], wage rate and a [rate basis|X_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].
At line 60 changed 3 lines
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.
;:Note the the start and end position in the IDIF are set to 0 where columns are not found on the file.
\\
At line 68 changed one line
\\
At line 86 changed one line
!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].
;:NOTE: this process will allow the update of [User Defined Columns|USER DEFINED COLUMN|USER DEFINED COLUMN (UDC)], but will not be able to update [User Defined Fields|USER DEFINED FIELD].
At line 89 changed one line
||Subject Table||Alias||Sample Screen||Required||
||Subject Table||Alias||Sample Screen||Required**||
At line 98 added one line
|P2K_HR_PERSONALS|EPS|IEPI|EPS.EID_ID.PERSON_CODE,\\EPS.EFFECTIVE
At line 92 changed 2 lines
|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_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
At line 95 changed one line
|P2K_CM_GROUP_DETAILS|DGRD|IDGR|DGD.DGR_ID.GROUP_CODE,\\DGD.DGR_ID.DEN_ID.ENTITY_CODE,\\DGRD.EFFECTIVE
|P2K_CM_GROUP_DETAILS|DGD|IDGR|DGD.DGR_ID.GROUP_CODE,\\DGD.DGR_ID.DUN_ID.UNIT_CODE,\\DGD.EFFECTIVE
At line 105 added 3 lines
|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
;:**The ADD TO UK SET toggle must be enabled for all of these fields. This toggle must be disabled for any other field added to the interface not listed in the chart.