 |
Lawson Insight Technical Documentation |
|
PGSELECT FILE
Emp Group Selection Criteria
Contains the selection criteria for defining an employee group. Each
selection criteria has its own record in this file.
REFERENCED BY
HR15.1 HR155 HR511 HR54.1 HR650 HRS1.1
HRSC.1 PA02.1 PA100 PA102 PA13.1 PA13.2
PA149 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 TM250 TM255 BN100 BN101 BN102
BN103 BN105 BN145 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN331 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
HR06.1 HR506
UPDATED BY
HR11.1 HR55.1 HR55.2 HR55.3 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGS-COMPANY Numeric 4 HR55.2 HR55.3
Company Contains the company number.
PGS-GROUP-NAME Alpha 10 HR55.1 HR55.2
Group Name Contains the user-defined employee HR55.3
group name.
PGS-EMPLOYEE Numeric 9 HR55.2
Employee Contains employees to be included in
the group regardless of criteria.
PGS-SEQ-NBR Numeric 4 HR55.2 HR55.3
Item Contains the sequence number that keeps
each record unique.
PGS-FLD-NBR Numeric 4 HR55.3
Dictionary Field Contains the HR data dictionary field
Number number.
PGS-INC-EXC-FLAG Alpha 1 HR55.3
Include/Exclude Indicates whether to include or exclude
the range of values contained in this
record.
E = Exclude
I = Include
PGS-BEGIN-VALUE Alpha 30 HR55.3
Beginning Value Contains the value (or beginning value
if a range is used) for the data item in
this record.
PGS-ENDING-VALUE Alpha 30 HR55.3
Ending Value Contains the ending value if a range of
values is defined. If a range is not
defined, this field is blank.
PGS-ITEM-GRP Alpha 2 HR55.3
Item Group Contains an item group identifier.
PGS-INC-EXC-VAL Derived
Inc Exc Val
PGS-SHORT-BEG-VAL Derived
Short Beg Val
PGS-SHORT-END-VAL Derived
Short End Val
PGSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGSSET1 COMPANY HR11.1 HR11.2
GROUP-NAME HR15.1 HR155
EMPLOYEE HR511 HR54.1
SEQ-NBR HR55.1 HR55.2
HR55.3 HR650
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA149 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
...
PGSSET4 COMPANY KeyChange BN100 BN101
FLD-NBR BN102 BN103
GROUP-NAME BN105 BN145
SEQ-NBR BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
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 HR06.1
HR11.1 HR11.2
...
PGSSET5 COMPANY KeyChange HR11.1 HR11.2
FLD-NBR HR15.1 HR155
BEGIN-VALUE HR511 HR54.1
GROUP-NAME HR55.1 HR55.2
SEQ-NBR HR55.3 HR650
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
...
PGSSET6 COMPANY KeyChange HR55.1 HR55.2
GROUP-NAME HR55.3
FLD-NBR
SEQ-NBR
PGSSET7 COMPANY KeyChange HR11.1 HR11.2
GROUP-NAME HR15.1 HR155
ITEM-GRP HR511 HR54.1
FLD-NBR HR55.2 HR55.3
SEQ-NBR HR650 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
...
PGSELECT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PGS-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Emp Group PERSGROUP Required
PGS-COMPANY -> PRG-COMPANY
PGS-GROUP-NAME -> PRG-GROUP-NAME
Employee EMPLOYEE Required
When PGS-EMPLOYEE != Zeroes
PGS-COMPANY -> EMP-COMPANY
PGS-EMPLOYEE -> EMP-EMPLOYEE
Field Nbr PADICT Required
When PGS-FLD-NBR != Zeroes
PGS-FLD-NBR -> PAD-FLD-NBR
Fld Nbr PADICT Required
When PGS-FLD-NBR != Zeroes
PGS-FLD-NBR -> PAD-FLD-NBR
|