REQCODE

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 LT101 LT111 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQC-COMPANY
Element: Company Hr
Numeric 4
PR03.1
RQC-REQ-CODE
Element: Req Code
Alpha 3
Contains the user-defined required code defined for the deduction.
PR03.1
RQC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the required code description.
PR03.1
RQC-ALL-EMPLOYEES
Element: All Employees
Alpha 1
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
PR03.1
RQC-NEXT-NBR
Element: Next Nbr
Numeric 4
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.
PR03.1


REQCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQCSET1 COMPANY
REQ-CODE
HR00.1 HR01.1
HR11.1 HR511
HRQC.1 LT101
LT111 PA100
PA52.1 PA52.4
PA52.5 PR03.1
PR05.1 PR13.1
PR13.5 PR14.1
PR15.2 PR205


REQCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
RQC-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


REQCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:30:47 2016

Home
Contact Us



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