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.1
PR05.5 PR06.9 PR07.3 PR11.1 PR11.2 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 UK47.1 UK560 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGP-COMPANY Numeric 4 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-COUNTRY-CODE Alpha 2 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-RECORD-TYPE Alpha 1 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-PAYROLL-YEAR Numeric 4 AC541 AC542
Element: Current PayrolContains 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-REPORT-ENTITY Alpha 5 AC541 AC542
Element: Process Level 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-TAX-ID-CODE Alpha 10 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-EMPLOYEE Numeric 9 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-TOPIC Alpha 2 AC541 AC542
Element: 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-SEQ-NBR Numeric 4 AC541 AC542
Element: Sequence NumbeAn 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.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
...
RGP-A-VALUE Alpha 30 (Lower Case) HR11.1 HR11.2
Element: A Value HR18.3 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR05.1
PR05.5 PR06.9
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR13.1
PR13.5 PR13.6
PR13.8 PR197
PR27.1 PR67.3
PR67.5
RGP-S-VALUE Signed 17.4 AC541 AC542
Element: 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.1 PR05.5
PR06.9 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
...
RGP-D-VALUE Numeric 8 (yyyymmdd) PR05.1 PR05.5
Element: D Value PR11.1 PR127
PR197 PR27.1
RGP-DESCRIPTION Alpha 30 (Lower Case) PR05.1 PR05.5
Element: Description This field displays the description. PR127 PR197
PR227 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 PR06.9 PR07.3
REPORT-ENTITY PR127 PR139
TAX-ID-CODE PR140 PR189
EMPLOYEE PR195 PR292
PAYROLL-YEAR PR298 PR67.3
TOPIC PR67.5 PR80.1
FLD-NBR PR89.1
SEQ-NBR
RGPSET3 COMPANY Subset PR11.1 PR11.2
COUNTRY-CODE Where RECORD-TYPE = "E" PR127 PR243
RECORD-TYPE PR297 PR299
EMPLOYEE
REPORT-ENTITY
PAYROLL-YEAR*
TOPIC
FLD-NBR
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-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
|
