PWSELECT

HR Writer Selection Criteria

Contains the detail and population selection criteria used by HR170 (HR Writer Report Request) and HR70 (HR Writer Inquiry).

REFERENCED BY
HR710


UPDATED BY
HR170 HR64.1 HR65.1 HR65.2 HR65.5 HR65.6
HR65.7 HR65.8 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWS-AUTHOR-NAME
Element: Author
Alpha 10
Contains the author name under which the selection criteria for the report is defined. This field is validated in the HR Report Writer Author file.
HR65.6 HR65.8
PWS-TITLE-NBR
Element: Title Nbr
Numeric 4
Contains the sequentially assigned title number, by author, for the selection criteria. The title number is stored in the HR Report Writer Title file.
HR64.1 HR65.6
HR65.8
PWS-SELECT-TYPE
Element: Select Type
Alpha 1
Indicates the type of selection criteria, detail or population.
D = Detail Data
P = Population
HR65.6 HR65.8
PWS-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the sequence number that keeps each record unique in the file.
HR65.6 HR65.8
PWS-FLD-NBR
Element: Fld Nbr
Numeric 4
Contains the data dictionary field number.
HR65.6 HR65.8
PWS-INC-EXC-FLAG
Element: Inc Exc Flag
Alpha 1
Determines if the application includes or excludes the records that meet the defined criteria.
E = Exclude
I = Include
HR65.6 HR65.8
PWS-BEG-VALUE
Element: Beg Value
Alpha 25
Contains the beginning value of the selection range.
HR170 HR65.6
HR65.8 HR70.1
PWS-THRU-VALUE
Element: Thru Value
Alpha 25
Contains the ending value of the selection range.
HR170 HR65.6
HR65.8 HR70.1
PWS-ITEM-GRP
Element: Item Grp Hr
Alpha 2
Contains the item group. All selection lines that have a common item group are treated as an "and" condition. That is, the employee or applicant must meet the criteria of all the selection lines that have a common item group identifier in order to appear on the report. Different item groups are treated as an "or" condition. That is, an employee or applicant needs to meet all of the criteria in only one of the item groups to appear on the report.
HR65.6 HR65.8
PWS-BEG-NEG
Element: Beg Neg
Alpha 1
Indicates whether the beginning value is a negative number.
PWS-END-NEG
Element: End Neg
Alpha 1
Indicates whether the ending value is a negative number.


PWSELECT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWSSET1 AUTHOR-NAME
TITLE-NBR
SELECT-TYPE
SEQ-NBR
HR170 HR64.1
HR65.1 HR65.2
HR65.6 HR65.8
HR710
PWSSET2 AUTHOR-NAME
TITLE-NBR
SELECT-TYPE
FLD-NBR
SEQ-NBR
KeyChange
HR65.5 HR65.6
HR65.7 HR65.8
HR70.1
PWSSET3 AUTHOR-NAME
TITLE-NBR
SELECT-TYPE
ITEM-GRP
FLD-NBR
SEQ-NBR
KeyChange
HR170 HR65.6
HR65.8 HR70.1


PWSELECT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Author PWAUTHOR Required
PWS-AUTHOR-NAME->PWA-AUTHOR-NAME
Fld Nbr PADICT Required
When PWS-FLD-NBR !=Zeroes
PWS-FLD-NBR->PAD-FLD-NBR


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

Home
Contact Us



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