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
HR511 PR13.1 PR13.5 PR14.1 PR15.2 PR205
UPDATED BY
PR03.1 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRQ-COMPANY Numeric 4 PR03.1
Company The company number represents an
established company and is entered on
all function codes.
PRQ-RECORD-KEY Alpha 3 PR03.1
Record Key Contains the deduction required code.
PRQ-SEQ-NBR Numeric 4 PR03.1
Sequence Number 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
Process Level Contains 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
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
Hire Date Contains the employee's hire date
PRQ-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) PR03.1
Adjusted Hire Date Contains the employee's adjusted hire
date
PRQ-SALARY-CLASS Alpha 1 PR03.1
Salary Class Contains the employee's salary class.
H = Hourly
S = Salaried
PRQ-EMP-STATUS Alpha 2 PR03.1
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
Pay Frequency Contains the employee's pay frequency.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
PRQ-EXEMPT-EMP Alpha 1 PR03.1
Exempt Contains the employee's overtime exempt
indicator.
N = Non-exempt
Y = Exempt
PRQ-JOB-CODE Alpha 9 PR03.1
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
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
Tax Province
PRQ-WC-STATE Alpha 2 PR03.1
Wc State Contains the employee's workers
compensation state.
PRQ-LOCAT-CODE Alpha 10 PR03.1
Location Contains the location code.
PRQ-WORK-COUNTRY Alpha 2 PR03.1
Work Country
PRQ-WC-PROVINCE Alpha 2 PR03.1
Wc Province
PRQUALIFY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRQSET1 COMPANY HR00.1 HR01.1
RECORD-KEY HR511 PR03.1
SEQ-NBR PR13.1 PR13.5
PR14.1 PR15.2
PR197 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
|
