Lawson Insight Technical Documentation |
|
PGEMPLOYEE
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
HC01.2 HCDL.1 HCEM.1 HR125 HR170 HR211
HR213 HR217 HR220 HR255 HR70.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 PR188 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 PR85.1 UK102 UK110
UK145 UK201 UK210 UK277 UK330 TA125
TA145 TA147 TA148 TA180 TA181 TM240
TM245 TM250 TM255 TM260 TM265 TM470
PA49.1 PA49.3 PA549 HS22.1 HS36.1 TP140
UPDATED BY
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 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 HAP3.1 HEP4.1
Element: Company Hr Contains the company number for which HPOS.1 HPQC.1
the employee group is defined. HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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 HAP3.1 HEP4.1
Element: Group Name Contains the name of the employee HPOS.1 HPQC.1
group. HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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 HAP3.1 HEP4.1
Element: Employee Contains the employee number of HPOS.1 HPQC.1
employees who meet the selection HPRS.1 HR11.1
criteria for the group. HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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) HAP3.1 HEP4.1
Element: Last Name Contains the employee's last name. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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) HAP3.1 HEP4.1
Element: First Name Contains the employee's first name. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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 HAP3.1 HEP4.1
Element: Middle InitialContains the employee's middle initial. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.2 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 AC197
GROUP-NAME BN100 BN101
EMPLOYEE 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
...
PGESET2 COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
GROUP-NAME PA100 PA102
PA115 PA149
PA249 PA49.1
PA49.3 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PA549 HS22.1
HS36.1 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 TP140
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
|