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
PA149 TM250 TM255 BN100 HR06.1 HR506
HR710


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

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
PGS-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR55.1 HR55.2
HR55.3
PGS-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
HR55.1 HR55.2
HR55.3
PGS-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
HR55.1 HR55.2
HR55.3
PGS-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR55.1 HR55.2
HR55.3
PGS-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
HR55.1 HR55.2
HR55.3
PGS-USER-ID
Element: User Id		Alpha 10 (Lower Case)
HR55.1 HR55.2
HR55.3


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 HR11.4
HR15.1 HR155
HR156 HR255
HR28.1 HR511
HR515 HR54.1
HR55.1 HR55.2
HR55.3 HRS1.1
HRSC.1 LT101
LT111 ZH156
ZH510 LP100
LP101 PA02.1
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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR506 HR511
HR515 HR54.1
HR55.1 HR55.2
HR55.3 HR710
HRS1.1 HRSC.1
LT101 LT111
ZH156 ZH510
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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HRS1.1 HRSC.1
LT101 LT111
ZH156 ZH510
LP100 LP101
PA02.1 PA100
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 HR11.4
HR15.1 HR155
HR156 HR28.1
HR511 HR515
HR54.1 HR55.2
HR55.3 HRS1.1
HRSC.1 LT101
LT111 ZH156
ZH510 LP100
LP101 PA02.1
PA100 PA102


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 02:16:53 2016

Home
Contact Us



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