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
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR15.1 HR155 HR511 HR515 HR54.1 HRS1.1
HRSC.1 LP100 LP101 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 TM250 TM255 BN100 BN101
BN102 BN103 BN105 BN145 BN232 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 HR710
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
Element: Fld Nbr Contains the HR data dictionary field
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 BN305 HAP3.1
GROUP-NAME HEP4.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
SEQ-NBR HR11.1 HR11.2
HR15.1 HR155
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA149 PA16.1
PA20.1 PA21.1
...
PGSSET4 COMPANY KeyChange BN100 BN101
FLD-NBR BN102 BN103
GROUP-NAME BN105 BN145
SEQ-NBR BN232 BN245
BN305 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
...
PGSSET5 COMPANY KeyChange BN305 HAP3.1
FLD-NBR HEP4.1 HPOS.1
BEGIN-VALUE HPQC.1 HPRS.1
GROUP-NAME HR11.1 HR11.2
SEQ-NBR HR15.1 HR155
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
...
PGSSET6 COMPANY KeyChange HR55.1 HR55.2
GROUP-NAME HR55.3
FLD-NBR
SEQ-NBR
PGSSET7 COMPANY KeyChange BN305 HAP3.1
GROUP-NAME HEP4.1 HPOS.1
ITEM-GRP HPQC.1 HPRS.1
FLD-NBR HR11.1 HR11.2
SEQ-NBR HR15.1 HR155
HR511 HR515
HR54.1 HR55.2
HR55.3 HRS1.1
HRSC.1 LP100
LP101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.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
|