PGSELECT

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
HR255 TM250 TM255 HR710


UPDATED BY
BN100 BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR06.1 HR11.1 HR11.2 HR15.1
HR155 HR156 HR28.1 HR506 HR511 HR515
HR54.1 HR55.1 HR55.2 HR55.3 HRS1.1 HRSC.1
LT101 ZH156 ZH510 LP100 LP101 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 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA520 PA54.1
TR21.1 TR22.1 TR26.1 TR500 ZE521 ZE531
ZE540 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGS-COMPANY
Element: Company		Numeric 4
Contains the company number.
HR156 HR55.2
HR55.3 ZH156
PGS-GROUP-NAME
Element: Group Name		Alpha 10
Contains the user-defined employee group name.
HR156 HR55.1
HR55.2 HR55.3
ZH156
PGS-EMPLOYEE
Element: Employee		Numeric 9
Contains employees to be included in the group regardless of criteria.
HR156 HR55.2
ZH156
PGS-SEQ-NBR
Element: Item		Numeric 4
Contains the sequence number that keeps each record unique.
HR156 HR55.2
HR55.3 ZH156
PGS-FLD-NBR
Element: Fld Nbr		Numeric 4
Contains the HR data dictionary field number.
HR156 HR55.3
ZH156
PGS-INC-EXC-FLAG
Element: Include/Exclude		Alpha 1
Indicates whether to include or exclude the range of values contained in this record.
E = Exclude
I = Include
HR156 HR55.2
HR55.3 ZH156
PGS-BEGIN-VALUE
Element: Beginning Value		Alpha 30
Contains the value (or beginning value if a range is used) for the data item in this record.
HR156 HR55.3
ZH156
PGS-ENDING-VALUE
Element: Ending Value		Alpha 30
Contains the ending value if a range of values is defined. If a range is not defined, this field is blank.
HR156 HR55.3
ZH156
PGS-ITEM-GRP
Element: Item Group		Alpha 2
Contains an item group identifier.
HR156 HR55.3
ZH156
PGS-INC-EXC-VAL
Element: Inc Exc Val		Derived
PGS-SHORT-BEG-VAL
Element: Short Beg Val		Derived
PGS-SHORT-END-VAL
Element: Short End Val		Derived


PGSELECT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGSSET1 COMPANY
GROUP-NAME
EMPLOYEE
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR255 HR28.1
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HRS1.1 HRSC.1
LT101 ZH156
ZH510 LP100
LP101 PA02.1
PA100 PA102
PGSSET4 COMPANY
FLD-NBR
GROUP-NAME
SEQ-NBR
KeyChange
...
BN100 BN305
HAP3.1 HCRE.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR06.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR506
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HR710 HRS1.1
HRSC.1 LT101
ZH156 ZH510
LP100 LP101
PGSSET5 COMPANY
FLD-NBR
BEGIN-VALUE
GROUP-NAME
SEQ-NBR
KeyChange
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.1 HR55.2
HR55.3 HRS1.1
HRSC.1 LT101
ZH156 ZH510
LP100 LP101
PA02.1 PA100
PA102 PA115
PGSSET6 COMPANY
GROUP-NAME
FLD-NBR
SEQ-NBR
KeyChange
HR55.1 HR55.2
HR55.3
PGSSET7 COMPANY
GROUP-NAME
ITEM-GRP
FLD-NBR
SEQ-NBR
KeyChange
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HR55.3
HRS1.1 HRSC.1
LT101 ZH156
ZH510 LP100
LP101 PA02.1
PA100 PA102
PA115 PA13.1


PGSELECT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:15:29 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.