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 13 changed one line
!Interface for inserting new and/or updating existing records with new amounts
!Interface for Inserting New and/or Updating Existing Records with New Amounts
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 84 added one line
!Interface for Updating Existing Records with Zero Amounts
At line 86 added one line
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 88 added one line
The other three interfaces would be similarly defined but with different PC Codes and with different Beg and End positions defined for the time entered and amount fields.
At line 90 added 20 lines
||Rec\\#||Field\\#||Name||Beg\\Pos||End\\Pos||Field\\Type||Constant\\Value||Derivation\\Expression||Notes
|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.
At line 111 added 4 lines
;:* 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
At line 116 added 4 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