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.

Field / columnTypeDescription & valuesUpdated by
RGP-COMPANY PK
COMPANY
Numeric 4BN100, 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 5BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
RGP-TAX-ID-CODE PK
TAX_ID_CODE
Alpha 10BN100, 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 2BN100, 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.4BN100, 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RGPSET1COMPANY, COUNTRY-CODE, PAYROLL-YEAR, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, TOPIC, FLD-NBR, SEQ-NBRPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
RGPSET2COMPANY, COUNTRY-CODE, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, PAYROLL-YEAR, TOPIC, FLD-NBR, SEQ-NBRBN66.1, HR18.3, HR18.5, HRGP.1, PR05.1, PR05.5, PR06.8, PR06.9 +22 more (list truncated in source)
RGPSET3COMPANY, COUNTRY-CODE, RECORD-TYPE, EMPLOYEE, REPORT-ENTITY, PAYROLL-YEAR*, TOPIC, FLD-NBR, SEQ-NBRSubsetWhere RECORD-TYPE = "E"HR11.1, PA115, PR11.1, PR11.2, PR11.4, PR11.5, PR127, PR129 +19 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredRGP-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen RGP-RECORD-TYPE = "E"RGP-COMPANYEMP-COMPANY, RGP-EMPLOYEEEMP-EMPLOYEE
PrtaxauthPRTAXAUTHRequiredWhen RGP-TAX-ID-CODE != SpacesRGP-TAX-ID-CODEPRX-TAX-ID-CODE

Programs

Updated by (170)

Referenced by (56)