PRREGPARM FILE
REFERENCED BY
BN66.1 PR139 PR140 PR160 PR180 PR195
PR227 PR240 PR241 PR242 PR243 PR244
PR245 PR250 PR251 PR252 PR253 PR292
PR297 PR298 PR299 PR89.1
UPDATED BY
AC541 AC542 BN100 BN101 BN102 BN103
BN104 BN105 BN145 BN150 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN45.1 BN531
BN65.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 HR11.1 HR11.2 HR18.3 HR511 HR650
PA02.1 PA100 PA102 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR05.5
PR11.1 PR110 PR113 PR120 PR127 PR128
PR13.1 PR13.2 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR136 PR14.1 PR15.1
PR15.2 PR189 PR197 PR205 PR26.1 PR27.1
PR29.1 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR39.1 PR39.2 PR45.1 PR47.1 PR514 PR529
PR530 PR560 PR67.3 PR67.4 PR67.5 PR80.1
PR80.3 PR82.1 PR927 UK102 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGP-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN100 BN101
established company and is entered on BN102 BN103
all function codes. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-COUNTRY-CODE Alpha 2 AC541 AC542
Country Code The country code. Required for VAT and BN100 BN101
intrastat reporting. Must be defined in BN102 BN103
IN01.1 (Country Maintenance). BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-RECORD-TYPE Alpha 1 AC541 AC542
Record Type This field identifies the type of BN100 BN101
record defined. BN102 BN103
BN104 BN105
Valid values are: BN145 BN150
S = Summary BN245 BN31.1
D = Detail BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-PAYROLL-YEAR Numeric 4 AC541 AC542
Current Payroll Year Contains the payroll year in which the BN100 BN101
allocation was taken. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-REPORT-ENTITY Alpha 5 AC541 AC542
Report Entity BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-TAX-ID-CODE Alpha 10 AC541 AC542
Tax Id Code BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. Each BN100 BN101
person employed by the company is BN102 BN103
assigned a unique number. The system BN104 BN105
uses the employee number to correlate BN145 BN150
all of the information related to that BN245 BN31.1
person. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-TOPIC Alpha 2 AC541 AC542
Topic BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-FLD-NBR Numeric 4 AC541 AC542
Dictionary Field This field contains the PO dictionary BN100 BN101
Number field number. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-SEQ-NBR Numeric 4 AC541 AC542
Sequence Number An automatically assigned sequence BN100 BN101
number. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
...
RGP-A-VALUE Alpha 30 (Lower Case) HR11.1 HR11.2
A Value HR18.3 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8 PR197
PR27.1 PR67.5
RGP-S-VALUE Signed 17.4 AC541 AC542
S Value BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
RGP-D-VALUE Numeric 8 (yyyymmdd) PR05.5 PR127
D Value PR197 PR27.1
RGP-DESCRIPTION Alpha 30 (Lower Case) PR05.5 PR127
Description This field displays the description. PR197 PR27.1
PRREGPARM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGPSET1 COMPANY AC541 AC542
COUNTRY-CODE BN100 BN101
PAYROLL-YEAR BN102 BN103
RECORD-TYPE BN104 BN105
REPORT-ENTITY BN145 BN150
TAX-ID-CODE BN245 BN31.1
EMPLOYEE BN31.2 BN32.1
TOPIC BN32.2 BN32.3
FLD-NBR BN45.1 BN531
SEQ-NBR BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR18.3 HR511
...
RGPSET2 COMPANY BN66.1 HR18.3
COUNTRY-CODE PR05.1 PR05.5
RECORD-TYPE PR127 PR139
REPORT-ENTITY PR140 PR189
TAX-ID-CODE PR195 PR292
EMPLOYEE PR297 PR298
PAYROLL-YEAR PR299 PR67.3
TOPIC PR67.5 PR80.1
FLD-NBR PR89.1
SEQ-NBR
PRREGPARM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
RGP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When RGP-EMPLOYEE != Zeroes
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
|
