 |
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 PA149 PA16.1 PA502 PA513 PA54.1
TR22.1 TR500 PR13.1 PR13.5 PR13.6 PR13.8
TM250 TM255 BN100 BN101 BN102 BN103
BN105 BN145 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 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
UPDATED BY
HR55.1 HR55.2 HR55.3
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 HR15.1 HR155
GROUP-NAME HR511 HR54.1
EMPLOYEE HR55.1 HR55.2
SEQ-NBR HR55.3 HR650
HRS1.1 HRSC.1
PA149 PA16.1
PA502 PA513
PA54.1 TR22.1
TR500 PR13.1
PR13.5 PR13.6
PR13.8 TM250
TM255
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
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
HR15.1 HR155
HR511 HR54.1
...
PGSSET5 COMPANY KeyChange HR15.1 HR155
FLD-NBR HR511 HR54.1
BEGIN-VALUE HR55.1 HR55.2
GROUP-NAME HR55.3 HR650
SEQ-NBR HRS1.1 HRSC.1
PA16.1 PA502
PA513 PA54.1
TR22.1 TR500
PR13.1 PR13.5
PR13.6 PR13.8
PGSSET6 COMPANY KeyChange HR55.1 HR55.2
GROUP-NAME HR55.3
FLD-NBR
SEQ-NBR
PGSSET7 COMPANY KeyChange HR15.1 HR155
GROUP-NAME HR511 HR54.1
ITEM-GRP HR55.2 HR55.3
FLD-NBR HR650 HRS1.1
SEQ-NBR HRSC.1 PA16.1
PA502 PA513
PA54.1 TR22.1
TR500 PR13.1
PR13.5 PR13.6
PR13.8
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
|