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 AC197 BN100 BN101 BN102 BN103
BN105 BN145 BN150 BN230 BN231 BN232
BN234 BN238 BN240 BN242 BN245 BN246
BN285 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN321 BN325 BN33.1 BN33.2 BN33.3
BN331 BN340 BN345 BN350 BN45.1 BN531
BN533 BN65.1 BN71.1 BN72.1 BS09.1 BS10.1
BS11.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1
BS531 HC01.2 HCDL.1 HCEM.1 HR125 HR170
HR211 HR213 HR217 HR220 HR255 HR70.1
HS208 LP103 LP130 LP138 LP180 LP188
LP231 LP251 LP260 LP262 LP264 LP353
LP80.1 PA103 PA113 PA125 PA149 PA182
PA210 PA212 PA213 PA214 PA215 PA216
PA217 PA218 PA219 PA220 PA221 PA222
PA223 PA224 PA225 PA227 PA249 PA290
PA296 PA310 PA311 PA313 PA315 PA320
PA325 PA330 PA335 PA340 PA345 PA350
PA355 PA360 PA370 PA495 PA496 PA534
PA66.2 TR113 TR120 TR121 TR20.1 TR20.2
TR20.3 TR222 HS20.1 HS21.1 HS34.1 HS35.1
HS535 PR128 PR130 PR131 PR134 PR136
PR139 PR188 PR189 PR195 PR212 PR214
PR226 PR240 PR241 PR242 PR243 PR244
PR245 PR247 PR248 PR249 PR250 PR251
PR252 PR253 PR260 PR261 PR262 PR274
PR276 PR277 PR279 PR282 PR284 PR293
PR297 PR299 PR300 PR33.2 PR33.3 UK102
UK110 UK145 UK201 UK210 UK277 UK330
SN80.2 SN80.3 SNEM.1 SNHC.1 TA125 TA145
TA147 TA148 TA180 TA181 TM240 TM245
TM250 TM255 TM260 TM265 TM470 ET700
PA49.1 PA49.3 PA549 HS22.1 HS36.1
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR155 HR511 HR515
HR54.1 HR55.2 HR55.1 HR55.3 HRS1.1 HRSC.1
LP100 LP101 PA02.1 PA100 PA102 PA115
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGE-COMPANY Numeric 4 BN305 HAP3.1
Element: Company Hr Contains the company number for which HEP4.1 HPOS.1
the employee group is defined. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 TR21.1
TR22.1 TR26.1
TR500
PGE-GROUP-NAME Alpha 10 BN305 HAP3.1
Element: Group Name Contains the name of the employee HEP4.1 HPOS.1
group. HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 TR21.1
TR22.1 TR26.1
TR500
PGE-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number of HEP4.1 HPOS.1
employees who meet the selection HPQC.1 HPRS.1
criteria for the group. HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 TR21.1
TR22.1 TR26.1
TR500
PGE-LAST-NAME Alpha 30 (Lower Case) BN305 HAP3.1
Element: Last Name Contains the employee's last name. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 TR21.1
TR22.1 TR26.1
TR500
PGE-FIRST-NAME Alpha 15 (Lower Case) BN305 HAP3.1
Element: First Name Contains the employee's first name. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 TR21.1
TR22.1 TR26.1
TR500
PGE-MIDDLE-INIT Alpha 1 BN305 HAP3.1
Element: Middle Init Contains the employee's middle initial. HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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 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 AC197
GROUP-NAME BN100 BN101
EMPLOYEE BN102 BN103
BN105 BN145
BN150 BN230
BN231 BN232
BN234 BN238
BN240 BN242
BN245 BN246
BN285 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN325
BN33.1 BN33.2
...
PGESET2 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
GROUP-NAME BN105 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 ET700
HR11.1 HR11.2
HR255 HR511
LP100 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA149
PA249 PA49.1
PA49.3 PA502
...
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 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
PGEMPLOYEE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Active Pep PAEMPPOS
PGE-COMPANY -> PEP-COMPANY
PGE-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
|
