PRREGPARM – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
RGP
Primary key
COMPANY, COUNTRY-CODE, PAYROLL-YEAR, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, TOPIC, FLD-NBR, SEQ-NBR
Fields
15
Updated by
170 programs
Referenced by
56 programs

PRREGPARM is a Lawson Payroll table (prefix RGP); no description in the lawson data dictionary. It is indexed by COMPANY, COUNTRY-CODE, PAYROLL-YEAR, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, TOPIC, FLD-NBR, SEQ-NBR (RGPSET1); alternate indexes: RGPSET2 and RGPSET3. It is related 1:1 to PRSYSTEM, EMPLOYEE and PRTAXAUTH. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 162 more and referenced by BN66.1, EXI3.1, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 and 48 more. The table has 15 fields, 3 indexes and 3 documented relations.

About PRREGPARM

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the RGP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RGP-COMPANY PK
COMPANY		Numeric 4—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year in which the allocation was taken.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-REPORT-ENTITY PK
REPORT_ENTITY		Alpha 5—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-TAX-ID-CODE PK
TAX_ID_CODE		Alpha 10—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-TOPIC PK
TOPIC		Alpha 2—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-FLD-NBR PK
FLD_NBR		Numeric 4This field contains the PO dictionary field number.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-A-VALUE
A_VALUE		Alpha 30 (Lower Case)—BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR18.3, HR18.5 +52 more
#RGP-S-VALUE
S_VALUE		Signed 17.4—BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
#RGP-D-VALUE
D_VALUE		Numeric 8 (yyyymmdd)—PR05.1, PR05.5, PR11.1, PR11.3, PR11.4, PR127, PR197, PR20.2 +5 more
#RGP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PR05.1, PR05.5, PR127, PR13.9, PR197, PR20.2, PR227, PR27.1 +1 more
#RGP-BUS-NBR-GRP
BUS_NBR_GRP		Alpha 4——

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RGPSET1
  1. COMPANY
  2. COUNTRY-CODE
  3. PAYROLL-YEAR
  4. RECORD-TYPE
  5. REPORT-ENTITY
  6. TAX-ID-CODE
  7. EMPLOYEE
  8. TOPIC
  9. FLD-NBR
  10. SEQ-NBR
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
RGPSET2
  1. COMPANY
  2. COUNTRY-CODE
  3. RECORD-TYPE
  4. REPORT-ENTITY
  5. TAX-ID-CODE
  6. EMPLOYEE
  7. PAYROLL-YEAR
  8. TOPIC
  9. FLD-NBR
  10. SEQ-NBR
BN66.1, HR18.3, HR18.5, HRGP.1, PR05.1, PR05.5, PR06.8, PR06.9 +22 more (list truncated in source)
RGPSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. RECORD-TYPE
  4. EMPLOYEE
  5. REPORT-ENTITY
  6. PAYROLL-YEAR ↓
  7. TOPIC
  8. FLD-NBR
  9. SEQ-NBR
SubsetWhere RECORD-TYPE = "E"HR11.1, PA115, PR11.1, PR11.2, PR11.4, PR11.5, PR127, PR129 +19 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPRTAXAUTHPRREGPARM

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
RGP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen RGP-RECORD-TYPE = "E"
RGP-COMPANY→EMP-COMPANY
RGP-EMPLOYEE→EMP-EMPLOYEE
PrtaxauthPRTAXAUTHRequiredWhen RGP-TAX-ID-CODE != Spaces
RGP-TAX-ID-CODE→PRX-TAX-ID-CODE

Programs

Updated by (170)

Referenced by (56)