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
AC731 BN100 BN101 BN102 BN103 BN105
BN145 BN150 BN231 BN232 BN238 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
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
HR255 HR70.1 PA125 PA149 PA212 PA213
PA214 PA215 PA216 PA217 PA218 PA219
PA220 PA221 PA222 PA224 PA225 PA249
PA290 PA300 PA305 PA310 PA311 PA313
PA315 PA320 PA325 PA330 PA335 PA340
PA345 PA350 PA355 PA360 PA370 PA490
PA66.2 TR02.1 TR113 TR120 TR121 TR20.1
TR20.2 TR20.3 HS20.1 HS21.1 HS34.1 HS35.1
HS535 PR120 PR128 PR131 PR134 PR136
PR139 PR195 PR212 PR214 PR226 PR260
PR276 PR277 PR293 PR297 PR298 PR300
PR33.2 PR33.3 UK102 UK110 UK210 UK330
TA125 TA180 TM240 TM245 TM250 TM255
TM470 UK120 UK270 UK300 PA49.1 PA49.3
PA549 HS22.1
UPDATED BY
HR11.1 HR15.1 HR155 HR511 HR54.1 HR55.2
HR55.1 HR55.3 HR700 HRS1.1 HRSC.1 PA02.1
PA100 PA102 PA13.1 PA13.2 PA16.1 PA20.1
PA21.1 PA22.1 PA24.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 TR500
PR13.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGE-COMPANY Numeric 4 HR11.1 HR15.1
Company Contains the company number for which HR155 HR511
the employee group is defined. HR54.1 HR55.2
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-GROUP-NAME Alpha 10 HR11.1 HR15.1
Group Name Contains the name of the employee HR155 HR511
group. HR54.1 HR55.2
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-EMPLOYEE Numeric 9 HR11.1 HR15.1
Employee Contains the employee number of HR155 HR511
employees who meet the selection HR54.1 HR55.2
criteria for the group. HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-LAST-NAME Alpha 30 (Lower Case) HR11.1 HR15.1
Last Name Contains the employee's last name. HR155 HR511
HR54.1 HR55.2
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-FIRST-NAME Alpha 15 (Lower Case) HR11.1 HR15.1
First Name Contains the employee's first name. HR155 HR511
HR54.1 HR55.2
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-MIDDLE-INIT Alpha 1 HR11.1 HR15.1
Middle Initial Contains the employee's middle initial. HR155 HR511
HR54.1 HR55.2
HR700 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PR13.1
TR21.1 TR22.1
TR500
PGE-FULL-NAME Derived
Full Name
PGEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGESET1 COMPANY AC731 BN100
GROUP-NAME BN101 BN102
EMPLOYEE BN103 BN105
BN145 BN150
BN231 BN232
BN238 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
...
PGESET2 COMPANY HR11.1 HR511
EMPLOYEE PA02.1 PA100
GROUP-NAME PA102 PA115
PA149 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA249 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 TR22.1
TR500 HS22.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
|