Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRQUALIFY


                             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