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
HR511 HRQC.1 PR05.1 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
RQC-COMPANY Numeric 4 PR03.1
Company The company number represents an
established company and is entered on
all function codes.
RQC-REQ-CODE Alpha 3 PR03.1
Required Code Contains the user-defined required code
defined for the deduction.
RQC-DESCRIPTION Alpha 30 (Lower Case) PR03.1
Description Contains the required code description.
RQC-ALL-EMPLOYEES Alpha 1 PR03.1
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
Next Sequence Number 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 HR511 HRQC.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
|
