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
BN145 BN229 BN230 BN231 BN232 BN238
BN240 BN246 BN297 BN299 BN321 BN325
BN33.1 BN33.2 BN33.3 BN340 BN345 BN350
BN45.1 BN533 BN65.1 BN71.1 BN72.1 BN991
BS09.1 BS10.1 BS11.1 BS12.1 BS13.1 BS14.1
BS15.1 BS531 HR211 HR213 LP138 LP231
LP264 LP331 LP80.1 PA125 PA182 PA210
PA212 PA214 PA215 PA216 PA217 PA220
PA221 PA222 PA223 PA224 PA225 PA227
PA249 PA258 PA290 PA310 PA311 PA315
PA320 PA325 PA330 PA335 PA345 PA350
PA355 PA360 PA370 PA495 PA66.2 TR121
TR20.1 TR20.2 TR20.3 TR20.4 HS20.1 HS21.1
HS34.1 HS35.1 PR129 PR130 PR136 PR139
PR195 PR212 PR214 PR226 PR247 PR250
PR251 PR252 PR253 PR261 PR262 PR292
PR293 PR323 PR582 UK330 TA125 TA145
TA147 TA180 TM250 TM255 TM260 TM265
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 HR15.1 HR155 HR156
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 PR13.9 BN100 BN101
BN102 BN103 BN105 BN106 BN149 BN150
BN234 BN242 BN245 BN249 BN254 BN255
BN285 BN290 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN331 BN531 BN729 BN954
BN990 BN996 BS32.1 HC01.2 HCDL.1 HCEM.1
HLTM.1 HR125 HR170 HR217 HR220 HR255
HR70.1 HS208 HS703 HS705 HS706 LP102
LP103 LP130 LP131 LP140 LP180 LP188
LP251 LP260 LP262 LP353 HS704 PA103
PA113 PA149 PA213 PA218 PA219 PA296
PA313 PA340 PA496 PA534 TR113 TR120
TR222 HS535 HS536 PR11.3 PR128 PR131
PR134 PR188 PR189 PR240 PR241 PR242
PR243 PR244 PR245 PR248 PR249 PR260
PR270 PR271 PR274 PR276 PR277 PR279
PR282 PR284 PR287 PR297 PR299 PR300
PR33.2 PR33.3 UK102 UK110 UK145 UK201
UK210 UK277 SN80.2 SN80.3 SNEM.1 SNHC.1
TA148 TA181 TM240 TM245 TM470

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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
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 HR15.1
HR155 HR156
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 PR13.9
TR21.1 TR22.1
TR26.1 TR500
PGE-FULL-NAME
Element: Full Name
Derived


PGEMPLOYEE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGESET1 COMPANY
GROUP-NAME
EMPLOYEE
...
BN100 BN101
BN102 BN103
BN105 BN106
BN145 BN149
BN150 BN229
BN230 BN231
BN232 BN234
BN238 BN240
BN242 BN245
BN246 BN249
BN254 BN255
BN285 BN290
BN297 BN299
BN305 BN31.1
BN31.2 BN32.1
PGESET2 COMPANY
EMPLOYEE
GROUP-NAME
...
BN100 BN101
BN102 BN103
BN105 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN729 BS32.1
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
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: Wed Jun 08 20:49:16 2016

Home
Contact Us



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