PGEMPLOYEE FILE
Employee Group Employees
Contains the user-defined employee group name and the employee's who meet the
selection criteria defined for the group.
REFERENCED BY
AC190 AC541 BN100 BN101 BN102 BN103
BN105 BN145 BN150 BN230 BN231 BN232
BN238 BN240 BN242 BN245 BN246 BN285
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN321 BN325 BN331 BN340 BN345 BN350
BN45.1 BN531 BN65.1 BN66.1 BN71.1 BN72.1
BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1
BS15.1 BS32.1 HC01.1 HC02.1 HCEM.1 HCOP.1
HR125 HR170 HR211 HR213 HR217 HR220
HR255 HR70.1 PA113 PA125 PA149 PA212
PA213 PA214 PA215 PA216 PA217 PA218
PA219 PA220 PA221 PA222 PA224 PA225
PA227 PA249 PA290 PA296 PA300 PA305
PA310 PA311 PA313 PA315 PA320 PA325
PA330 PA335 PA340 PA345 PA350 PA355
PA360 PA370 PA496 PA66.2 TR113 TR120
TR121 TR20.1 TR20.2 TR20.3 HS20.1 HS21.1
HS34.1 HS35.1 HS535 PR128 PR130 PR131
PR134 PR136 PR139 PR140 PR188 PR189
PR195 PR197 PR212 PR214 PR226 PR240
PR241 PR242 PR243 PR244 PR245 PR247
PR250 PR251 PR252 PR253 PR260 PR276
PR277 PR282 PR284 PR293 PR297 PR298
PR299 PR300 PR33.2 PR33.3 PR80.1 PR85.1
PR89.1 UK102 UK110 UK210 UK330 TA125
TA145 TA147 TA148 TA180 TA181 TM240
TM245 TM250 TM255 TM470 UK120 UK270
UK300 PA49.1 PA49.3 PA549 HS22.1 HS36.1
UPDATED BY
HR11.1 HR11.2 HR15.1 HR155 HR511 HR54.1
HR55.2 HR55.1 HR55.3 HR650 HRS1.1 HRSC.1
PA02.1 PA100 PA102 PA13.1 PA13.2 PA16.1
PA20.1 PA21.1 PA22.1 PA24.1 PA27.1 PA34.1
PA35.1 PA36.1 PA38.1 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA520 PA54.1 TR21.1
TR22.1 TR26.1 TR500 PR110 PR113 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PRSC.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGE-COMPANY Numeric 4 HR11.1 HR11.2
Company Contains the company number for which HR15.1 HR155
the employee group is defined. HR511 HR54.1
HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-GROUP-NAME Alpha 10 HR11.1 HR11.2
Group Name Contains the name of the employee HR15.1 HR155
group. HR511 HR54.1
HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-EMPLOYEE Numeric 9 HR11.1 HR11.2
Employee Contains the employee number of HR15.1 HR155
employees who meet the selection HR511 HR54.1
criteria for the group. HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-LAST-NAME Alpha 30 (Lower Case) HR11.1 HR11.2
Last Name Contains the employee's last name. HR15.1 HR155
HR511 HR54.1
HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-FIRST-NAME Alpha 15 (Lower Case) HR11.1 HR11.2
First Name Contains the employee's first name. HR15.1 HR155
HR511 HR54.1
HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-MIDDLE-INIT Alpha 1 HR11.1 HR11.2
Middle Initial Contains the employee's middle initial. HR15.1 HR155
HR511 HR54.1
HR55.2 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1 TR21.1
TR22.1 TR26.1
TR500
PGE-FULL-NAME Derived
Full Name
PGEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGESET1 COMPANY AC190 AC541
GROUP-NAME BN100 BN101
EMPLOYEE BN102 BN103
BN105 BN145
BN150 BN230
BN231 BN232
BN238 BN240
BN242 BN245
BN246 BN285
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN325
BN331 BN340
BN345 BN350
...
PGESET2 COMPANY HR11.1 HR11.2
EMPLOYEE HR511 HR650
GROUP-NAME PA02.1 PA100
PA102 PA115
PA149 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA249 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA49.1 PA49.3
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA549 TR21.1
...
PGESET3 COMPANY KeyChange HR255 PR33.3
GROUP-NAME
LAST-NAME
FIRST-NAME
MIDDLE-INIT
EMPLOYEE
PGEMPLOYEE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PGE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Not Required
PGE-COMPANY -> EMP-COMPANY
PGE-EMPLOYEE -> EMP-EMPLOYEE
Pa Employee PAEMPLOYEE Required
PGE-COMPANY -> PEM-COMPANY
PGE-EMPLOYEE -> PEM-EMPLOYEE
Pers Group PERSGROUP Required
PGE-COMPANY -> PRG-COMPANY
PGE-GROUP-NAME -> PRG-GROUP-NAME
|
