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
FC202 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 PR248 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 UK145
UK201 UK210 UK277 UK330 TA125 TA145
TA147 TA148 TA180 TA181 TM240 TM245
TM250 TM255 TM260 TM265 TM470 UK120
UK270 UK300 PA49.1 PA49.3 PA549 HS22.1
HS36.1
UPDATED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2
HR15.1 HR155 HR511 HR515 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 HGLM.1 HPOS.1
Element: Company Contains the company number for which HPQC.1 HPRS.1
the employee group is defined. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
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 HGLM.1 HPOS.1
Element: Group Name Contains the name of the employee HPQC.1 HPRS.1
group. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
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 HGLM.1 HPOS.1
Element: Employee Contains the employee number of HPQC.1 HPRS.1
employees who meet the selection HR11.1 HR11.2
criteria for the group. HR15.1 HR155
HR511 HR515
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-LAST-NAME Alpha 30 (Lower Case) HGLM.1 HPOS.1
Element: Name Contains the employee's last name. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
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) HGLM.1 HPOS.1
Element: First Name Contains the employee's first name. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
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 HGLM.1 HPOS.1
Element: Middle InitialContains the employee's middle initial. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
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
Element: 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
|
