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 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 93 added 24 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.EAS_ID.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 eP 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
This page (revision-10) was last changed on 26-Nov-2021 10:22 by ihowieTop