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
HR170 HR710 HR70.1


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

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 02:17:01 2016

Home
Contact Us



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