The Comp Accum Import by Wage Code (By Pay Source) allows users to import line items into the compensation accumulator by wage code as opposed to only by account number. This can be useful when wanting to take information from a non-primary/secondary payroll source and have that information reported to the primary payroll system through the compensation accumulator. A comma delimited (.csv) file with the first line/row of the file identifying the database elements and the remaining rows containing the detail of the data to be imported is utilized.
The data fields available for import are limited to fields that can be seen on the sample file for import. These are:
TABLE
FIELD NAME
IDENTIFIER WAGE_CODE
SUBMITTED_AMOUNT
DESCRIPTION
WHERE_PAID
PAYMENT_DATE
If you want to use Payment Date, it should always be the last column in this import. You do not need the column Payment Date, but when it is used it must be the last column in the import. Please make sure we add a note about Payment Date being the last optional column if you have this column in the import.