 |
Lawson Insight Technical Documentation |
|
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 AC741 GR741 BN100 BN101
BN102 BN103 BN105 BN145 BN150 BN231
BN232 BN238 BN242 BN245 BN246 BN285
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN321
BN325 BN331 BN340 BN345 BN350 BN45.1
BN531 BN65.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 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 PA249 PA290
PA296 PA300 PA305 PA310 PA311 PA313
PA315 PA320 PA325 PA330 PA335 PA340
PA345 PA350 PA355 PA360 PA370 PA490
PA66.2 TR113 TR120 TR121 TR20.1 TR20.2
TR20.3 HS20.1 HS21.1 HS34.1 HS35.1 HS535
PR128 PR131 PR134 PR136 PR139 PR195
PR197 PR212 PR214 PR226 PR247 PR260
PR276 PR277 PR293 PR297 PR298 PR300
PR33.2 PR33.3 PR85.1 UK102 UK110 UK210
UK330 TA125 TA180 TM240 TM245 TM250
TM255 TM470 UK120 UK270 PA49.1 PA49.3
PA549 HS22.1 HS36.1
UPDATED BY
AC721 HR15.1 HR155 HR511 HR54.1 HR55.2
HR55.1 HR55.3 HR650 HRS1.1 HRSC.1 PA16.1
PA502 PA513 PA54.1 TR22.1 TR500 PR13.1
PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGE-COMPANY Numeric 4 AC190 AC541
Company Contains the company number for which AC721 AC741
the employee group is defined. GR741 HR15.1
HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-GROUP-NAME Alpha 10 AC190 AC541
Group Name Contains the name of the employee AC721 AC741
group. GR741 HR15.1
HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-EMPLOYEE Numeric 9 AC190 AC541
Employee Contains the employee number of AC721 AC741
employees who meet the selection GR741 HR15.1
criteria for the group. HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-LAST-NAME Alpha 30 (Lower Case) AC721 HR15.1
Last Name Contains the employee's last name. HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-FIRST-NAME Alpha 15 (Lower Case) AC721 HR15.1
First Name Contains the employee's first name. HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-MIDDLE-INIT Alpha 1 AC721 HR15.1
Middle Initial Contains the employee's middle initial. HR155 HR511
HR54.1 HR55.2
HR650 HRS1.1
HRSC.1 PA16.1
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8 TR22.1
TR500
PGE-FULL-NAME Derived
Full Name
PGEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGESET1 COMPANY AC190 AC541
GROUP-NAME AC721 AC741
EMPLOYEE GR741 BN100
BN101 BN102
BN103 BN105
BN145 BN150
BN231 BN232
BN238 BN242
BN245 BN246
BN285 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN321 BN325
BN331 BN340
BN345 BN350
...
PGESET2 COMPANY HR511 HR650
EMPLOYEE PA149 PA16.1
GROUP-NAME PA249 PA49.1
PA49.3 PA502
PA549 TR22.1
TR500 HS22.1
HS36.1 PR128
PR13.1 PR13.5
PR13.6 PR13.8
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
|