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

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

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 Alex Del Signore to previous
9 26-Nov-2021 10:22 9 KB Alex Del Signore to previous | to last
8 26-Nov-2021 10:22 9 KB Alex Del Signore to previous | to last
7 26-Nov-2021 10:22 9 KB Alex Del Signore to previous | to last
6 26-Nov-2021 10:22 9 KB kparrott to previous | to last
5 26-Nov-2021 10:22 8 KB kparrott to previous | to last
4 26-Nov-2021 10:22 8 KB kparrott to previous | to last
3 26-Nov-2021 10:22 8 KB kparrott to previous | to last
2 26-Nov-2021 10:22 8 KB kparrott to previous | to last
1 26-Nov-2021 10:22 8 KB kparrott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 115 removed 11 lines
1. Load transactions to the IPTL (via LMTD) with a destination of IPTR. The following information must be provided:
a. Employee Information (i.e. Person Code)
b. Date of Leave
c. Amount of leave time (i.e. hours)
d. Time code will be FMLA WOP only as we don’t need the additional information for FMLA SICK or FMLA VAC etc.
2. The loaded entries may be verified in IPTL
3. Use UPTL to process the entries to the IPTR. NOTE: This creates IPTR batches for each pay period with the transactions in the loaded file as well as creating the leave lines (IAAL)
4. Verify leave line entries in IAAL on the ‘In Payroll’ tab. (Note: You will not see the results in VALB)
5. Break the link between IPTR transactions and the IAAL leave lines that were created above using SQL:
i. Update p2k_pr_pay_trans_time_codes set aal_id = NULL
ii. Where ptr_id in (select id from p2k_pr_pay_transactions where mex_id_generated = <the UPTL MEX_ID>);
At line 116 added 5 lines
1. Load transactions to the IPTL (via LMTD) with a destination of IPTR. The following information must be provided:
* Employee Information (i.e. Person Code)
* Date of Leave
* Amount of leave time (i.e. hours)
* Time code will be FMLA WOP only as we don’t need the additional information for FMLA SICK or FMLA VAC etc.
At line 122 added 12 lines
2. The loaded entries may be verified in IPTL
3. Use UPTL to process the entries to the IPTR. NOTE: This creates IPTR batches for each pay period with the transactions in the loaded file as well as creating the leave lines (IAAL)
4. Verify leave line entries in IAAL on the ‘In Payroll’ tab. (Note: You will not see the results in VALB)
5. Break the link between IPTR transactions and the IAAL leave lines that were created above using SQL:
* Update p2k_pr_pay_trans_time_codes set aal_id = NULL
* Where ptr_id in (select id from p2k_pr_pay_transactions where mex_id_generated = <the UPTL MEX_ID>);