This page (revision-10) was last changed on 26-Nov-2021 10:22 by ihowie

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

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
10 26-Nov-2021 10:22 9 KB ihowie to previous
9 26-Nov-2021 10:22 9 KB ihowie to previous | to last
8 26-Nov-2021 10:22 9 KB JMyers to previous | to last
7 26-Nov-2021 10:22 9 KB JEscott to previous | to last
6 26-Nov-2021 10:22 8 KB JEscott to previous | to last
5 26-Nov-2021 10:22 8 KB JEscott to previous | to last
4 26-Nov-2021 10:22 8 KB JEscott to previous | to last
3 26-Nov-2021 10:22 8 KB JEscott to previous | to last
2 26-Nov-2021 10:22 7 KB JEscott to previous | to last
1 26-Nov-2021 10:22 6 KB JEscott to last

Page References

Incoming links Outgoing links
LMTD LOADING COMPLEX SUNDRY FILE
LMTD LOADING COMPLEX SUNDRY FILE

Version management

Difference between version and

At line 5 changed one line
When the employee opts out of the sundry deduction, the record in the file is filled with zeros. As a result of file format, the same file will need to be loaded using eight different interfaces. The LMTD would be run twice, once for four of the interfaces to insert new sundries and update existing ones with new amounts. The same file would be run a second time using LMTD with four different interfaces, required in case an employee opted out of a sundry.
When the employee opts out of the sundry deduction, the record in the file is filled with zeros. As a result of file format, the same file will need to be loaded using eight different interfaces. The [LMTD] would be run twice, once for four of the interfaces to insert new sundries and update existing ones with new amounts. The same file would be run a second time using [LMTD] with four different interfaces, required in case an employee opted out of a sundry.
At line 11 removed one line
Two of the four insert/update interfaces are displayed below.
At line 14 added 2 lines
Two of the four insert/update interfaces are displayed below.
At line 18 changed one line
|1| 2| PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| | {{{ LTRIM(~,'0')}}}|This will trim any leading zeros
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| | {{{ LTRIM(~,'0')}}}|This will trim any leading zeros
At line 20 changed one line
'MM/DD/YYYY'),'DDMon-YYYY')}}} |This will format the incoming date to the eP standard.
'MM/DD/YYYY'),'DDMon-YYYY')}}} |This will format the incoming date to the Personality standard.
At line 26 changed one line
|1| 9| PSL.PFQ_ID.FREQUENCY_CODE| -1| -1| Char| ALL-PAYS-1ST| |This will hard code the Frequency field with ALLPAYS-1st. If the Frequency ever changes, the IDIF Constant field must be updated with the new Frequency.
|1| 9| PSL.PFQ_ID.FREQUENCY_CODE| -1| -1| Char| ALL-PAYS-1ST| |This will hard code the Frequency field with ALLPAYS-1st. If the Frequency ever changes, the [IDIF] Constant field must be updated with the new Frequency.
At line 32 changed one line
end}}}|This is used as a qualifier to ensure the LMTD only inserts/updates IPSN for PC 5490. This will ensure the other amounts are ignored for this particular interface.
end}}}|This is used as a qualifier to ensure the [LMTD] only inserts/updates [IPSN] for PC 5490. This will ensure the other amounts are ignored for this particular interface.
At line 53 changed one line
|1| 2| PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
At line 55 changed one line
'MM/DD/YYYY'),'DDMon-YYYY') }}}|This will format the incoming date to the eP standard.
'MM/DD/YYYY'),'DDMon-YYYY') }}}|This will format the incoming date to the Personality standard.
At line 67 changed one line
end}}}|This is used as a qualifier to ensure the LMTD only inserts/ updates IPSN for PC 5491. This will ensure the other amounts are ignored for this particular interface.
end}}}|This is used as a qualifier to ensure the [LMTD] only inserts/ updates [IPSN] for PC 5491. This will ensure the other amounts are ignored for this particular interface.
At line 83 removed 3 lines
At line 88 changed one line
Below is a sample interface for the scenario described in the previous page which would be used to update the existing deductions in IPSN to a 0.00 amount when an employee opted out of the deduction. This interface has fewer records since it is only updating the current record.
Below is a sample interface for the scenario described in the previous section which would be used to update the existing deductions in [IPSN] to a 0.00 amount when an employee opted out of the deduction. This interface has fewer records since it is only updating the current record.
At line 91 added 29 lines
|0| 0| HEADER RECORD* |-1| -1| Char| | | Record Type must be Header Record.
|1| 1| PSL.EAS_ID.ASSIGNMENT_CODE| -1| -1| Char| PRIMARY| | This will hard code the Assignment Code with PRIMARY
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
|1| 3| PSL.START_DATE**| 57| 66| Char| |{{{ TO_CHAR(TO_DATE(RTRIM(~),
'MM/DD/YYYY'),'DDMon-YYYY')}}}|This will format the incoming date to the Personality standard.
|1| 4| PSL.END_DATE| -1| -1| Char| 31-Dec-3999| | This will hard code the End Date with 31-Dec-3999
|1| 5| PSL.PPC_ID.PC_CODE**| -1| -1| Char| 5490| | This will hard code the PC Code field with 5490
|1| 6| PSL.TIME_ENTERED| 67| 74| Char| 0.00| | This will take the provided value and divide it by 100 since the amt provided does not include any decimal places.
|1 |7| PSLD.PPC_ID.PC_CODE**| -1| -1| Char| 5490| |
|1| 8| PSLD.AMOUNT| -1| -1| Char| 0.00| |
|1| 9| PSL.F_QUALIFIER*** |-1| -1| Char| TRUE| {{{ CASE when
(:PSL.F_SUNDRY_END) =
'00000000000000000000000000000000'
then 'TRUE'
else 'FALSE'
end }}} |This is used as a qualifier to ensure the [LMTD] only inserts/ updates [IPSN] for PC 5490. This will ensure the other amounts are ignored for this particular interface.
|1| 10| PSL.EEM_ID.EID_ID.PERSON_CODE**| 1| 9| Char| |{{{LTRIM(~,'0')}}}|
|1| 11| PSL.F_SUNDRY_END| 67| 98| Char| | |
|2 |0| TRAILER RECORD****| -1| -1| Char| | | Record Type is Trailer Record.
;:* Record 1, Field 0 must have a Record Type of HEADER RECORD
;:** Fields 3, 5, 7 and 10 must have the Add to UK toggle checked ON
;:*** Field 9 must have a Record Type of QUALIFY RECORD
;:**** Record 2, Field must have a Record Type of TRAILER RECORD
----
![Notes|Edit:Internal.LMTD+LOADING+COMPLEX+SUNDRY+FILE]
[{InsertPage page='Internal.LMTD+LOADING+COMPLEX+SUNDRY+FILE' default='Click to create a new notes page'}]
This page (revision-10) was last changed on 26-Nov-2021 10:22 by ihowieTop