PRQUALIFY

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
PR03.1 HR00.1 HR01.1 HR11.1 HR511 PA100
PA52.1 PA52.4 PA52.5 PR13.1 PR13.5 PR14.1
PR15.2 PR205

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRQ-COMPANY
Element: Company Hr
Numeric 4
PR03.1
PRQ-RECORD-KEY
Element: Record Key
Alpha 3
Contains the deduction required code.
PR03.1
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.
PR03.1
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.
PR03.1
PRQ-DEPARTMENT
Element: Department
Alpha 5
Contains the employee's department. The value in this field must be valid in the Department Parameters file.
PR03.1
PRQ-DATE-HIRED
Element: Date Hired
Numeric 8 (yyyymmdd)
Contains the employee's hire date
PR03.1
PRQ-ADJ-HIRE-DATE
Element: Adjusted Hire Date
Numeric 8 (yyyymmdd)
Contains the employee's adjusted hire date
PR03.1
PRQ-SALARY-CLASS
Element: Salary Class
Alpha 1
Contains the employee's salary class.
H = Hourly
S = Salaried
PR03.1
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.
PR03.1
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
PR03.1
PRQ-EXEMPT-EMP
Element: Exempt
Alpha 1
Contains the employee's overtime exempt indicator.
N = Non-exempt
Y = Exempt
PR03.1
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.
PR03.1
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).
PR03.1
PRQ-TAX-PROVINCE
Element: Province
Alpha 2
PR03.1
PRQ-WC-STATE
Element: Wc State
Alpha 2
Contains the employee's workers compensation state.
PR03.1
PRQ-LOCAT-CODE
Element: Locat Code
Alpha 10
Contains the location code.
PR03.1
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).
PR03.1
PRQ-WC-PROVINCE
Element: Wc Province
Alpha 2
PR03.1
PRQ-WORK-STATE
Element: Work State
Alpha 2
Contains the employee's work state.
PR03.1
PRQ-TAX-STATE
Element: Tax State
Alpha 2
Contains the employee's state taxing authority.
PR03.1
PRQ-TAX-COUNTY
Element: Tax County
Alpha 10
Contains the employee's county taxing authority.
PR03.1
PRQ-WORK-COUNTY
Element: Work County
Alpha 10
Contains the employee's work state.
PR03.1
PRQ-TAX-CITY
Element: Tax City
Alpha 10
Contains the employee's city taxing authority.
PR03.1
PRQ-WORK-CITY
Element: Work City
Alpha 10
Contains the employee's work city.
PR03.1
PRQ-TAX-SCHOOL
Element: Tax School
Alpha 10
Contains the employee's school tax authority code.
PR03.1
PRQ-WORK-SCHOOL
Element: Work School
Alpha 10
Contains the employee's work school.
PR03.1
PRQ-PSRETIRE-PLAN
Element: Plan Option
Numeric 2


PRQUALIFY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRQSET1 COMPANY
RECORD-KEY
SEQ-NBR
HR00.1 HR01.1
HR11.1 HR511
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
NAME
RELATED 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


File created: Wed Jun 08 20:51:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.