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
HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1
HR155 HR511 HR515 HR54.1 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 BN232 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
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 HAP3.1 HEP4.1
GROUP-NAME HPOS.1 HPQC.1
EMPLOYEE HPRS.1 HR11.1
SEQ-NBR HR11.2 HR15.1
HR155 HR511
HR515 HR54.1
HR55.1 HR55.2
HR55.3 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 BN232 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
HAP3.1 HEP4.1
...
PGSSET5 COMPANY KeyChange HAP3.1 HEP4.1
FLD-NBR HPOS.1 HPQC.1
BEGIN-VALUE HPRS.1 HR11.1
GROUP-NAME HR11.2 HR15.1
SEQ-NBR HR155 HR511
HR515 HR54.1
HR55.1 HR55.2
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
...
PGSSET6 COMPANY KeyChange HR55.1 HR55.2
GROUP-NAME HR55.3
FLD-NBR
SEQ-NBR
PGSSET7 COMPANY KeyChange HAP3.1 HEP4.1
GROUP-NAME HPOS.1 HPQC.1
ITEM-GRP HPRS.1 HR11.1
FLD-NBR HR11.2 HR15.1
SEQ-NBR HR155 HR511
HR515 HR54.1
HR55.2 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
...
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
|