Required Code Select Criteria
Contains the detail selection criteria for required deductions that have not
been defined as applying to "all" employees. Use PR03.1 (Deduction Required
Code) to define parameters that determine if the system automatically creates
an employee deduction (Employee Deduction file record) when you add an
employee. The system compares the detail selection criteria you define, with
the employee fields to determine if it should create the employee deduction.
The Required Deduction Header file stores the required code header
information.
UPDATED BY
HR00.1 | HR01.1 | HR11.1 | HR511 | LT101 | PA100 |
PA52.1 | PA52.4 | PA52.5 | PR03.1 | PR13.1 | PR13.5 |
PR14.1 | PR15.2 | PR205 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
PRQ-COMPANY Element: Company Hr | Numeric 4 |
|
||
PRQ-RECORD-KEY Element: Record Key | Alpha 3 Contains the deduction required code. |
|
||
PRQ-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains the deduction sequence number. The value of this field is automatically sequenced based on the Next Nbr field in the Required Deduction Code Header file. |
|
||
PRQ-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 Contains the employee's process level. The value in this field must be valid in the HR Company and Process Levels file. |
|
||
PRQ-DEPARTMENT Element: Department | Alpha 5 Contains the employee's department. The value in this field must be valid in the Department Parameters file. |
|
||
PRQ-DATE-HIRED Element: Date Hired | Numeric 8 (yyyymmdd) Contains the employee's hire date |
|
||
PRQ-ADJ-HIRE-DATE Element: Adjusted Hire Date | Numeric 8 (yyyymmdd) Contains the employee's adjusted hire date |
|
||
PRQ-SALARY-CLASS Element: Salary Class | Alpha 1 Contains the employee's salary class. H = Hourly S = Salaried |
|
||
PRQ-EMP-STATUS Element: Status | Alpha 2 Contains the employee's status. The value in this field must be valid in the Employee/Applicant Status file. |
|
||
PRQ-PAY-FREQUENCY Element: Pay Frequency | Numeric 1 Contains the employee's pay frequency. 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = UK Four-Weekly |
|
||
PRQ-EXEMPT-EMP Element: Exempt | Alpha 1 Contains the employee's overtime exempt indicator. N = Non-exempt Y = Exempt |
|
||
PRQ-JOB-CODE Element: Job Code | Alpha 9 Contains the employee's job code. The value in this field must be valid in the Job Code Parameters file. |
|
||
PRQ-UNION-CODE Element: Union Code | Alpha 10 Contains the union code with which the employee is associated. The value in this field must be valid in the Human Resource Code file under type UN (Union). |
|
||
PRQ-TAX-PROVINCE Element: Province | Alpha 2 |
|
||
PRQ-WC-STATE Element: Wc State | Alpha 2 Contains the employee's workers compensation state. |
|
||
PRQ-LOCAT-CODE Element: Locat Code | Alpha 10 Contains the location code. |
|
||
PRQ-WORK-COUNTRY Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||
PRQ-WC-PROVINCE Element: Wc Province | Alpha 2 |
|
||
PRQ-WORK-STATE Element: Work State | Alpha 2 Contains the employee's work state. |
|
||
PRQ-TAX-STATE Element: Tax State | Alpha 2 Contains the employee's state taxing authority. |
|
||
PRQ-TAX-COUNTY Element: Tax County | Alpha 10 Contains the employee's county taxing authority. |
|
||
PRQ-WORK-COUNTY Element: Work County | Alpha 10 Contains the employee's work state. |
|
||
PRQ-TAX-CITY Element: Tax City | Alpha 10 Contains the employee's city taxing authority. |
|
||
PRQ-WORK-CITY Element: Work City | Alpha 10 Contains the employee's work city. |
|
||
PRQ-TAX-SCHOOL Element: Tax School | Alpha 10 Contains the employee's school tax authority code. |
|
||
PRQ-WORK-SCHOOL Element: Work School | Alpha 10 Contains the employee's work school. |
|
||
PRQ-PSRETIRE-PLAN Element: Plan Option | Numeric 2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRQSET1 |
COMPANY RECORD-KEY SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||||||||
Department | DEPTCODE |
Required
| |||||||||||||||
Emp Status | EMSTATUS |
Required
| |||||||||||||||
Job Code | JOBCODE |
Required
| |||||||||||||||
Process Level | PRSYSTEM |
Required
| |||||||||||||||
Required Code | REQCODE |
Required
| |||||||||||||||
Union | PCODES |
Required
| |||||||||||||||
Wc State | PRSTATE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.