Lawson Insight Technical Documentation |
|
PGSELECT
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
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR15.1 HR155
HR511 HR515 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 BN340 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
Element: Company Contains the company number.
PGS-GROUP-NAME Alpha 10 HR55.1 HR55.2
Element: Group Name Contains the user-defined employee HR55.3
group name.
PGS-EMPLOYEE Numeric 9 HR55.2
Element: Employee Contains employees to be included in
the group regardless of criteria.
PGS-SEQ-NBR Numeric 4 HR55.2 HR55.3
Element: 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
Element: Include/ExcludIndicates whether to include or exclude
the range of values contained in this
record.
E = Exclude
I = Include
PGS-BEGIN-VALUE Alpha 30 HR55.3
Element: Beginning ValuContains the value (or beginning value
if a range is used) for the data item in
this record.
PGS-ENDING-VALUE Alpha 30 HR55.3
Element: 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
Element: Item Group Contains an item group identifier.
PGS-INC-EXC-VAL Derived
Element: Inc Exc Val
PGS-SHORT-BEG-VAL Derived
Element: Short Beg Val
PGS-SHORT-END-VAL Derived
Element: Short End Val
PGSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGSSET1 COMPANY HGLM.1 HPOS.1
GROUP-NAME HPQC.1 HPRS.1
EMPLOYEE HR11.1 HR11.2
SEQ-NBR HR15.1 HR155
HR511 HR515
HR54.1 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
...
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
BN340 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
HGLM.1 HPOS.1
...
PGSSET5 COMPANY KeyChange HGLM.1 HPOS.1
FLD-NBR HPQC.1 HPRS.1
BEGIN-VALUE HR11.1 HR11.2
GROUP-NAME HR15.1 HR155
SEQ-NBR HR511 HR515
HR54.1 HR55.1
HR55.2 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
...
PGSSET6 COMPANY KeyChange HR55.1 HR55.2
GROUP-NAME HR55.3
FLD-NBR
SEQ-NBR
PGSSET7 COMPANY KeyChange HGLM.1 HPOS.1
GROUP-NAME HPQC.1 HPRS.1
ITEM-GRP HR11.1 HR11.2
FLD-NBR HR15.1 HR155
SEQ-NBR HR511 HR515
HR54.1 HR55.2
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
...
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
|