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 / column | Type | Description & values | Updated by |
|---|---|---|---|
RGP-COMPANY PKCOMPANY | Numeric 4 | — | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-COUNTRY-CODE PKCOUNTRY_CODE | Alpha 2 | The 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 PKRECORD_TYPE | Alpha 1 | This field identifies the type of record defined. Valid values are:
| BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-PAYROLL-YEAR PKPAYROLL_YEAR | Numeric 4 | Contains 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 PKREPORT_ENTITY | Alpha 5 | — | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-TAX-ID-CODE PKTAX_ID_CODE | Alpha 10 | — | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains 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 PKTOPIC | Alpha 2 | — | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-FLD-NBR PKFLD_NBR | Numeric 4 | This field contains the PO dictionary field number. | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-A-VALUEA_VALUE | Alpha 30 (Lower Case) | — | BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR18.3, HR18.5 +52 more |
RGP-S-VALUES_VALUE | Signed 17.4 | — | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source) |
RGP-D-VALUED_VALUE | Numeric 8 (yyyymmdd) | — | PR05.1, PR05.5, PR11.1, PR11.3, PR11.4, PR127, PR197, PR20.2 +5 more |
RGP-DESCRIPTIONDESCRIPTION | 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-GRPBUS_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RGPSET1 | COMPANY, COUNTRY-CODE, PAYROLL-YEAR, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, TOPIC, FLD-NBR, SEQ-NBR | Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source) | |
RGPSET2 | COMPANY, COUNTRY-CODE, RECORD-TYPE, REPORT-ENTITY, TAX-ID-CODE, EMPLOYEE, PAYROLL-YEAR, TOPIC, FLD-NBR, 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 | COMPANY, COUNTRY-CODE, RECORD-TYPE, EMPLOYEE, REPORT-ENTITY, PAYROLL-YEAR*, TOPIC, FLD-NBR, SEQ-NBR | Subset | Where 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
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | RGP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | When RGP-RECORD-TYPE = "E" | RGP-COMPANY → EMP-COMPANY, RGP-EMPLOYEE → EMP-EMPLOYEE |
| Prtaxauth | PRTAXAUTH | Required | When RGP-TAX-ID-CODE != Spaces | RGP-TAX-ID-CODE → PRX-TAX-ID-CODE |
Programs
Updated by (170)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN104 Frequency Table Update
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN150 Life Insurance Reportable Income
- BN245 Benefit Election Form
- BN305 Highly Compensated Employees
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BN65.1 Election Simulation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR00.1 Company
- HR01.1 Process Level
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR18.3 State Reporting Information - Wyoming
- HR18.5 State Reporting Information - Puerto Rico
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LP130 Absence Plan Payout
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR05.1 Deduction
- PR05.5 Employment Health Tax Exemptions
- PR06.8 State Reporting Information
- PR06.9 State Reporting Information
- PR07.1 State Reporting Information
- PR07.2 State Reporting Information
- PR07.6 State Reporting Information
- PR07.9 State Reporting Information
- PR11.1 Employee Year-End Parameters
- PR11.2 USERRA Year-End Parameters
- PR11.3 Employee HIRE Act Tax Reporting Info
- PR11.4 Canadian Employee Year-End Parameters
- PR11.5 Employee Year-End PA TCD Override
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR127 Year-End Parameters Copy/Delete
- PR128 Offset Time Record Creation
- PR129 Roth Plan Start Dates
- PR13.1 Employee United States Taxes
- PR13.2 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR14.1 Employee Deduction
- PR14.2 Tax Withholding Lock-In
- PR15.1 Deduction Speed Entry
- PR15.2 Employee Deduction Speed Entry
- PR189 Gross Up Calculation
- PR197 Payroll Close
- PR20.2 Pay Summary Group
- PR205 Deduction Listing
- PR227 Year-End Parameter Report
- PR240 T4-T4A Slips
- PR241 T4-T4A XML
- PR242 T4-T4A Reports
- PR243 Releve Slips
- PR244 Releve Magnetic Media
- PR245 Releve Reports
- PR249 PIER Audit Report
- PR250 1099-R Form Reporting
- PR251 1099-R File Creation
- PR252 United States Territory W-2 Form Printing
- PR253 1099-R Reporting
- PR26.1 United States Employee Garnishment
- PR27.1 Year-End Parameters
- PR27.2 Tax Authority Year-End Parameters
- PR29.1 Pension Payment Maintenance
- PR29.2 Roth Initial Contribution Year
- PR297 W-2 Forms
- PR299 EFW2 File Creation
- PR30.2 Employee Automatic Time Record
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR39.1 One Time Deduction
- PR39.2 One Time Deduction Speed
- PR45.1 Error Processing
- PR47.1 Canada Employee Garnishment
- PR512 Employee ACH Distribution Interface
- PR514 Employee Deduction Master Load
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR539 One Time Deduction Load
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR597 Employee Year-End PA TCD Override Upload
- PR67.1 State Reporting Information
- PR67.2 State Reporting Information
- PR67.3 State Reporting Information
- PR67.4 State Reporting Information
- PR67.5 State Reporting Information
- PR67.9 State Reporting Information
- PR68.1 New Mexico State Report
- PR68.3 Florida
- PR68.4 Missouri
- PR68.5 Tennessee
- PR68.8 Vermont
- PR68.9 Michigan
- PR69.1 Additional Information
- PR69.2 Additional Information
- PR80.1 Manual Check
- PR80.3 Manual Payment One Time Deduction
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR87.1 941 Information
- PR927 PR27 Conversion for 2000
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add
- ZH510 Update PCP from ZPENDPCP
Referenced by (56)
- BN66.1 Estimated Pay Calculation
- EXI3.1 Invoke for PRTRDPD
- HAP3.1 Applicant Option 4 Selection Invoke
- HCRE.1 Action Reason Code Selects
- HEP4.1 Employee Option 4 Selection Invoke
- HPOS.1 Position Selection Invoke
- HPQC.1 Prqcentgrp Select Invoke
- HPRS.1 Process Level Select Invoke
- HR15.1 User Fields
- HR155 Employee Group Update
- HR156 Employee Group Company Update
- HR170 Human Resource Writer Report Request
- HR200 Company Listing
- HR211 Employee Listing
- HR515 User Field Conversion
- HR54.1 Employee History Correction
- HR55.2 Employee Groups By Employees
- HR70.1 Human Resource Writer Inquiry
- HRGP.1 Deduction Class Selection Invoke
- HRS1.1 Select Control
- HRSC.1 Select Control
- LP100 Employee Absence Plan Update
- LP101 Mass Absence Plan Add
- LT11.5 HRM User Field Interface
- LT13.5 HRM User Field Interface History
- PA113 Retroactive History Update
- PA16.1 Company Property
- PA20.1 Education
- PA21.1 Competencies
- PA22.1 Certifications
- PA24.1 Relocation
- PA27.1 Contracts
- PA272 Budget and Assigned Resource Listing
- PA34.1 Applicant Education
- PA35.1 Applicant Competencies
- PA36.1 Applicant Certification
- PA38.1 Applicant Relocation
- PA520 Employee and Applicant Code Conversion
- PA53.1 Personnel Action Workflow Override
- PA54.1 Personnel Action History Correction
- PA66.3 Employee Action Detail
- PR139 Arrears Automation
- PR140 Earnings and Deductions Calculation
- PR160 Payment Print
- PR180 Manual Payment Print
- PR195 Accrual Program
- PR220 Pay Code Listing
- PR287 Quarterly Federal Tax Return
- PR292 Quarterly Unemployment Ins
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- TR21.1 Employee Training History
- TR22.1 Session Completion
- TR26.1 Employee Training Competency Maintenance
- TR500 Training Conversion
- ZH156 Employee Group Company Update