PGEMPLOYEE

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 BN106 BN145 BN150 BN230 BN231
BN232 BN234 BN238 BN240 BN242 BN245
BN246 BN247 BN260 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 ZB01.1 ZB10.1
ZB10.2 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
ZS531 HC01.2 HCDL.1 HCEM.1 HLTM.1 HR105
HR125 HR170 HR211 HR213 HR217 HR220
HR228 HR255 HR70.1 HS208 HS703 HS705
LT213 ZH230 ZH500 HS706 LP102 LP103
LP130 LP131 LP138 LP140 LP151 LP180
LP188 LP199 LP231 LP251 LP260 LP262
LP264 LP331 LP353 LP80.1 HS704 PA103
PA105 PA113 PA125 PA130 PA149 PA182
PA210 PA212 PA213 PA214 PA215 PA216
PA217 PA218 PA219 PA220 PA221 PA222
PA223 PA224 PA225 PA227 PA249 PA258
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 TR20.4 TR222 HS18.2 HS20.1
HS21.1 HS34.1 HS35.1 HS535 HS536 PR11.3
PR128 PR129 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 PR270 PR271
PR274 PR276 PR277 PR279 PR280 PR282
PR284 PR292 PR293 PR295 PR297 PR299
PR300 PR323 PR33.2 PR33.3 PR582 UK102
UK110 UK210 SN80.2 SN80.3 SNEM.1 SNHC.1
TA147 TA148 TM240 TM245 TM250 TM255
TM260 TM265 TM470 HS10.1 HS10.2 PA49.1
PA49.3 PA549 HS22.1 HS36.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR15.1 HR155
HR156 HR28.1 HR511 HR515 HR54.1 HR55.2
HR55.1 HR55.3 HRS1.1 HRSC.1 LT101 LT111
ZH156 ZH510 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 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2
PR512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGE-COMPANY
Element: Company Hr
Numeric 4
Contains the company number for which the employee group is defined.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-GROUP-NAME
Element: Group Name
Alpha 10
Contains the name of the employee group.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number of employees who meet the selection criteria for the group.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the employee's last name.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the employee's first name.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-MIDDLE-INIT
Element: Middle Init
Alpha 1
Contains the employee's middle initial.
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
LT101 LT111
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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 TR21.1
PGE-FULL-NAME
Element: Full Name
Derived


PGEMPLOYEE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGESET1 COMPANY
GROUP-NAME
EMPLOYEE
...
AC190 AC197
BN100 BN101
BN102 BN103
BN105 BN106
BN145 BN150
BN230 BN231
BN232 BN234
BN238 BN240
BN242 BN245
BN246 BN247
BN260 BN285
BN305 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN321
PGESET2 COMPANY
EMPLOYEE
GROUP-NAME
...
BN100 BN101
BN102 BN103
BN105 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
ZB32.3 HR11.1
HR11.2 HR11.4
HR255 HR28.1
HR511 HS10.1
HS10.2 LT101
LT111 ZH230
PGESET3 COMPANY
GROUP-NAME
LAST-NAME
FIRST-NAME
MIDDLE-INIT
EMPLOYEE
KeyChange
HR255 PR33.3


PGEMPLOYEE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Active Pep PAEMPPOS
PGE-COMPANY->PEP-COMPANY
PGE-EMPLOYEE->PEP-EMPLOYEE
  PEP-POS-LEVEL
  PEP-EFFECT-DATE


File created: Thu Jun 09 02:16:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.