Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REQCODE


                              REQCODE FILE

                     Required Deduction Code Header

The Required Deduction Code Header file contains the header information for
deduction required codes. The system links the required codes to deductions by
storing the required code in the Deduction file. When you add employees, the
system uses the deduction required codes to automatically create Employee
Deduction file records. PR03.1 (Deduction Required Code) is the primary
program that updates this file. If the required code is not to be created for
all employees, the system stores the detail selection criteria in the Required
Code Select Criteria file.

REFERENCED BY

HR11.1    HR511     HRQC.1    PA100     PA52.1    PA52.4
PA52.5    PR05.1    PR13.1    PR13.5    PR14.1    PR15.2
PR205

UPDATED BY

PR03.1    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQC-COMPANY            Numeric 4                                 PR03.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RQC-REQ-CODE           Alpha 3                                   PR03.1
Element: Required Code Contains the user-defined required code
                       defined for the deduction.

RQC-DESCRIPTION        Alpha 30  (Lower Case)                    PR03.1
Element: Description   Contains the required code description.

RQC-ALL-EMPLOYEES      Alpha 1                                   PR03.1
Element: All Employees Contains the value that determines if
                       the required code is created for all
                       employees or based on selection criteria
                       stored in the Required Code Select
                       Criteria file.
                       N = No - Define selection criteria
                       Y = Select Criteria

RQC-NEXT-NBR           Numeric 4                                 PR03.1
Element: Next Sequence Contains the sequence number. This
                       field is used to set the value of the
                       sequence number when Required Code
                       Select Criteria file records are
                       created.

                         REQCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQCSET1   COMPANY                                                HR00.1  HR01.1
          REQ-CODE                                               HR11.1  HR511
                                                                 HRQC.1  PA100
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PBIP.1
                                                                 PR03.1  PR05.1
                                                                 PR13.1  PR13.5
                                                                 PR14.1  PR15.2
                                                                 PR197   PR205

                         REQCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            RQC-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

                         REQCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Deduction Code DEDCODE      Delete Restricted

                            RQC-COMPANY     -> DDC-COMPANY
                            RQC-REQ-CODE    -> DDC-REQ-CODE
                                               DDC-DED-CODE

Prqualify      PRQUALIFY    Delete Cascades

                            RQC-COMPANY     -> PRQ-COMPANY
                            RQC-REQ-CODE    -> PRQ-RECORD-KEY
                                               PRQ-SEQ-NBR