|
|
PRQUALIFY FILE
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.
REFERENCED BY
HR11.1 HR511 PA100 PA52.1 PA52.4 PA52.5
PR13.1 PR13.5 PR14.1 PR15.2 PR205
UPDATED BY
PR03.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRQ-COMPANY Numeric 4 PR03.1
Element: Company Hr
PRQ-RECORD-KEY Alpha 3 PR03.1
Element: Record Key Contains the deduction required code.
PRQ-SEQ-NBR Numeric 4 PR03.1
Element: Seq Nbr 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 Alpha 5 PR03.1
Element: Process Lev HrContains the employee's process level.
The value in this field must be valid in
the HR Company and Process Levels file.
PRQ-DEPARTMENT Alpha 5 PR03.1
Element: Department Contains the employee's department. The
value in this field must be valid in the
Department Parameters file.
PRQ-DATE-HIRED Numeric 8 (yyyymmdd) PR03.1
Element: Date Hired Contains the employee's hire date
PRQ-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) PR03.1
Element: Adjusted Hire Contains the employee's adjusted hire
date
PRQ-SALARY-CLASS Alpha 1 PR03.1
Element: Salary Class Contains the employee's salary class.
H = Hourly
S = Salaried
PRQ-EMP-STATUS Alpha 2 PR03.1
Element: Status Contains the employee's status. The
value in this field must be valid in the
Employee/Applicant Status file.
PRQ-PAY-FREQUENCY Numeric 1 PR03.1
Element: Pay Frequency Contains the employee's pay frequency.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = UK Four-Weekly
PRQ-EXEMPT-EMP Alpha 1 PR03.1
Element: Exempt Contains the employee's overtime exempt
indicator.
N = Non-exempt
Y = Exempt
PRQ-JOB-CODE Alpha 9 PR03.1
Element: Job Code Contains the employee's job code. The
value in this field must be valid in the
Job Code Parameters file.
PRQ-UNION-CODE Alpha 10 PR03.1
Element: Union Code 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 Alpha 2 PR03.1
Element: Province
PRQ-WC-STATE Alpha 2 PR03.1
Element: Wc State Contains the employee's workers
compensation state.
PRQ-LOCAT-CODE Alpha 10 PR03.1
Element: Locat Code Contains the location code.
PRQ-WORK-COUNTRY Alpha 2 PR03.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PRQ-WC-PROVINCE Alpha 2 PR03.1
Element: Wc Province
PRQ-WORK-STATE Alpha 2 PR03.1
Element: Work State Contains the employee's work state.
PRQ-TAX-STATE Alpha 2 PR03.1
Element: Tax State Contains the employee's state taxing
authority.
PRQ-TAX-COUNTY Alpha 10 PR03.1
Element: Tax County Contains the employee's county taxing
authority.
PRQ-WORK-COUNTY Alpha 10 PR03.1
Element: Work County Contains the employee's work state.
PRQ-TAX-CITY Alpha 10 PR03.1
Element: Tax City Contains the employee's city taxing
authority.
PRQ-WORK-CITY Alpha 10 PR03.1
Element: Work City Contains the employee's work city.
PRQ-TAX-SCHOOL Alpha 10 PR03.1
Element: Tax School Contains the employee's school tax
authority code.
PRQ-WORK-SCHOOL Alpha 10 PR03.1
Element: Work School Contains the employee's work school.
PRQUALIFY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRQSET1 COMPANY HR00.1 HR01.1
RECORD-KEY HR11.1 HR511
SEQ-NBR PA100 PA52.1
PA52.4 PA52.5
PR03.1 PR13.1
PR13.5 PR14.1
PR15.2 PR205
PRQUALIFY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PRQ-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When PRQ-DEPARTMENT != Spaces
PRQ-COMPANY -> DPT-COMPANY
PRQ-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PRQ-DEPARTMENT -> DPT-DEPARTMENT
Emp Status EMSTATUS Required
When PRQ-EMP-STATUS != Spaces
PRQ-COMPANY -> EMS-COMPANY
PRQ-EMP-STATUS -> EMS-EMP-STATUS
Job Code JOBCODE Required
When PRQ-JOB-CODE != Spaces
PRQ-COMPANY -> JBC-COMPANY
PRQ-JOB-CODE -> JBC-JOB-CODE
Process Level PRSYSTEM Required
When PRQ-PROCESS-LEVEL != Spaces
PRQ-COMPANY -> PRS-COMPANY
PRQ-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Required Code REQCODE Required
PRQ-COMPANY -> RQC-COMPANY
PRQ-RECORD-KEY -> RQC-REQ-CODE
Union PCODES Required
When PRQ-UNION-CODE != Spaces
"UN" -> PCO-TYPE
PRQ-UNION-CODE -> PCO-CODE
Wc State PRSTATE Required
When PRQ-WC-STATE != Spaces
PRQ-WC-STATE -> PSA-STATE
|
