The parameters user report is used to specify the values for the input parameters.
When creating the parameters user report the following must be observed:
1. Add SQL data fields with specific column caption names that match the list of required input parameters for the specified import. A question mark icon is available on screen and it contains the list of required input parameters for the specified import.
Import |
Column Caption Names (* denotes the field is required, do not include the * in your User Report)
|
Comp Accum Import by Wage Code (by Pay Source) |
PAYROLL_SYSTEM_ID*
PAYROLL_SYSTEM_CALENDAR_ID*
PAYROLL_SYSTEM_CALENDAR_DATE
|
Comp Accumulator Simple Format Import by PaySource |
PAYROLL_SYSTEM_ID*
EXCHANGE_RATE_DATE_PREF*
EXCHANGE_RATE_DATE
|
Compensation Accumulator Simple Format Import |
DATA_SOURCE*
EXCHANGE_RATE_DATE_PREF*
EXCHANGE_RATE_DATE
|
Pay Register |
PAYROLL_SYSTEM_ID*
PAYROLL_SYSTEM_CALENDAR_ID*
PR_DEFAULT_STATUS*
|
Below is an example of a Parameters Report for Compensation Accumulator Simple Format Import. If you require the SQL value for any input parameter fields e.g. EXCHANGE_RATE_DATE_PREF, please contact an Equus technical member.
2. In the Filters section, include Company:Id as the report parameter filter. The user report will only use values from the first row.