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 added one line
Two of the four insert/update interfaces are displayed below.
At line 14 removed 2 lines
Two of the four insert/update interfaces are displayed below.
At line 19 changed one line
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| | {{{ LTRIM(~,'0')}}}|This will trim any leading zeros
|1| 2| PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| | {{{ LTRIM(~,'0')}}}|This will trim any leading zeros
At line 21 changed one line
'MM/DD/YYYY'),'DDMon-YYYY')}}} |This will format the incoming date to the Personality standard.
'MM/DD/YYYY'),'DDMon-YYYY')}}} |This will format the incoming date to the eP standard.
At line 27 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 33 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 54 changed one line
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
|1| 2| PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
At line 56 changed one line
'MM/DD/YYYY'),'DDMon-YYYY') }}}|This will format the incoming date to the Personality standard.
'MM/DD/YYYY'),'DDMon-YYYY') }}}|This will format the incoming date to the eP standard.
At line 68 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 added 3 lines
At line 93 changed one line
|1| 2| PSL.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
|1| 2| PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE| 1| 9| Char| |{{{ LTRIM(~,'0')}}}| This will trim any leading zeros
At line 95 changed one line
'MM/DD/YYYY'),'DDMon-YYYY')}}}|This will format the incoming date to the Personality standard.
'MM/DD/YYYY'),'DDMon-YYYY')}}}|This will format the incoming date to the eP standard.
At line 106 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 115 removed 5 lines
----
![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