PRREGPARM FILE
REFERENCED BY
BN66.1 HR211 PR139 PR140 PR160 PR180
PR195 PR220 PR227 PR240 PR241 PR242
PR243 PR244 PR245 PR249 PR250 PR251
PR253 PR292 PR297 PR299 PR89.1 UK201
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 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
ET530 ETI1.1 ETI2.1 HR11.1 HR11.2 HR18.3
HR511 LP130 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR05.1 PR05.5 PR06.9 PR07.1
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 PR14.2 PR15.1 PR15.2 PR189 PR197
PR20.2 PR205 PR252 PR26.1 PR27.1 PR27.2
PR29.1 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR39.1 PR39.2 PR45.1 PR47.1 PR514
PR529 PR530 PR539 PR560 PR67.3 PR67.4
PR67.5 PR67.9 PR68.1 PR80.1 PR80.3 PR82.1
PR927 UK102 UK47.1 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGP-COMPANY Numeric 4 BN100 BN101
Element: Company Hr BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-COUNTRY-CODE Alpha 2 BN100 BN101
Element: Country Code The country code. Required for VAT and BN102 BN103
intrastat reporting. Must be defined in BN104 BN105
IN01.1 (Country Maintenance). BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-RECORD-TYPE Alpha 1 BN100 BN101
Element: Record Type This field identifies the type of BN102 BN103
record defined. BN104 BN105
BN145 BN150
Valid values are: BN245 BN305
S = Summary BN31.1 BN31.2
D = Detail BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-PAYROLL-YEAR Numeric 4 BN100 BN101
Element: Payroll Year Contains the payroll year in which the BN102 BN103
allocation was taken. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-REPORT-ENTITY Alpha 5 BN100 BN101
Element: Report Entity BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-TAX-ID-CODE Alpha 10 BN100 BN101
Element: Tax Id Code BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. Each BN102 BN103
person employed by the company is BN104 BN105
assigned a unique number. The system BN145 BN150
uses the employee number to correlate BN245 BN305
all of the information related to that BN31.1 BN31.2
person. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-TOPIC Alpha 2 BN100 BN101
Element: Topic BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-FLD-NBR Numeric 4 BN100 BN101
Element: Fld Nbr This field contains the PO dictionary BN102 BN103
field number. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-SEQ-NBR Numeric 4 BN100 BN101
Element: Seq Nbr An automatically assigned sequence BN102 BN103
number. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR18.3
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR07.3 PR11.1
PR11.2 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
...
RGP-A-VALUE Alpha 30 (Lower Case) BN305 HR11.1
Element: A Value HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA115 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 PR13.1
PR13.5 PR13.6
PR13.8 PR197
PR20.2 PR27.1
PR27.2 PR67.3
PR67.5 PR68.1
RGP-S-VALUE Signed 17.4 BN100 BN101
Element: S Value BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR211
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.1 PR05.5
PR06.9 PR07.1
PR11.1 PR11.2
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
...
RGP-D-VALUE Numeric 8 (yyyymmdd) PR05.1 PR05.5
Element: D Value PR11.1 PR127
PR197 PR20.2
PR27.1 PR27.2
PR67.9
RGP-DESCRIPTION Alpha 30 (Lower Case) PR05.1 PR05.5
Element: Description This field displays the description. PR127 PR197
PR20.2 PR227
PR27.1
RGP-BUS-NBR-GRP Alpha 4
Element: Bus Nbr Grp
PRREGPARM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGPSET1 COMPANY BN100 BN101
COUNTRY-CODE BN102 BN103
PAYROLL-YEAR BN104 BN105
RECORD-TYPE BN145 BN150
REPORT-ENTITY BN245 BN305
TAX-ID-CODE BN31.1 BN31.2
EMPLOYEE BN32.1 BN32.2
TOPIC BN32.3 BN45.1
FLD-NBR BN531 BN65.1
SEQ-NBR BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ET530
ETI1.1 ETI2.1
HR11.1 HR11.2
...
RGPSET2 COMPANY BN66.1 HR18.3
COUNTRY-CODE PR05.1 PR05.5
RECORD-TYPE PR06.9 PR07.1
REPORT-ENTITY PR07.3 PR127
TAX-ID-CODE PR139 PR140
EMPLOYEE PR189 PR195
PAYROLL-YEAR PR292 PR67.3
TOPIC PR67.4 PR67.5
FLD-NBR PR67.9 PR68.1
SEQ-NBR PR80.1 PR89.1
RGPSET3 COMPANY Subset PR11.1 PR11.2
COUNTRY-CODE Where RECORD-TYPE = "E" PR127 PR243
RECORD-TYPE PR244 PR245
EMPLOYEE PR252 PR297
REPORT-ENTITY PR299
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
|
