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


UPDATED BY
HR11.1 HR11.2 HR55.1 HR55.2 HR55.3 PA115
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR15.1 HR155 HR156 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 PR13.9 BN100
HR06.1 HR506 HR710

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGS-COMPANY
Element: Company		Numeric 4
Contains the company number.
HR156 HR55.2
HR55.3
PGS-GROUP-NAME
Element: Group Name		Alpha 10
Contains the user-defined employee group name.
HR156 HR55.1
HR55.2 HR55.3
PGS-EMPLOYEE
Element: Employee		Numeric 9
Contains employees to be included in the group regardless of criteria.
HR156 HR55.2
PGS-SEQ-NBR
Element: Item		Numeric 4
Contains the sequence number that keeps each record unique.
HR156 HR55.2
HR55.3
PGS-FLD-NBR
Element: Fld Nbr		Numeric 4
Contains the HR data dictionary field number.
HR156 HR55.3
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
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
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
PGS-ITEM-GRP
Element: Item Group		Alpha 2
Contains an item group identifier.
HR156 HR55.3
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 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
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
HR506 HR511
HR515 HR54.1
HR55.1 HR55.2
HR55.3 HR710
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
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
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
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
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


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: Wed Jun 08 20:49:16 2016

Home
Contact Us



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