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

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

Page References

Incoming links Outgoing links
CONVERTING PAY HISTORY
CONVERTING PAY HISTORY

Version management

Difference between version and

At line 5 changed one line
PAY HEADERS are loaded into the [INF_CV_PAYHEADERS] table. The following chart defines the layout of this tables and the typical values for the fields found within it:
PAY HEADERS are loaded into the INF_CV_PAYHEADERS table. The following chart defines the layout of this tables and the typical values for the fields found within it:
At line 53 changed one line
The PAY HEADER records require a valid PAY RUN entry to be generated in order for the application to treat them correctly. Since a PAY RUN record can only contain PAY HEADER records for a single [payroll|PAYROLL_CODE] and [pay calendar code|PAY_CALENDAR_CODE], this information can be created. A custom SQL script called INSERT_PAYRUNS.SQL can be run after the PAY HEADER records have been loaded into the interface table and before attempting to convert them. This script will insert records into the [INF_CV_PAYRUNS] table and update the data in [INF_CV_PAYHEADERS] to point to these new records.
The PAY HEADER records require a valid PAY RUN entry to be generated in order for the application to treat them correctly. Since a PAY RUN record can only contain PAY HEADER records for a single [payroll|PAYROLL_CODE] and [pay calendar code|PAY_CALENDAR_CODE], this information can be created. A custom SQL script called INSERT_PAYRUNS.SQL can be run after the PAY HEADER records have been loaded into the interface table and before attempting to convert them. This script will insert records into the INF_CV_PAYRUNS table and update the data in INF_CV_PAYHEADERS to point to these new records.
At line 61 changed one line
The file layout of the [INF_CV_PAYPCAMOUNTS] is shown below:
The file layout of the INF_CV_PAYPCAMOUNTS is shown below:
At line 71 removed 5 lines
----
![Notes|Edit:Internal.CONVERTING+PAY+HISTORY]
[{InsertPage page='Internal.CONVERTING+PAY+HISTORY' default='Click to create a new notes page'}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JEscottTop