|
|
PWSELECT FILE
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 Alpha 10 HR65.6 HR65.8
Element: Author 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.
PWS-TITLE-NBR Numeric 4 HR64.1 HR65.6
Element: Title Nbr Contains the sequentially assigned HR65.8
title number, by author, for the
selection criteria. The title number is
stored in the HR Report Writer Title
file.
PWS-SELECT-TYPE Alpha 1 HR65.6 HR65.8
Element: Select Type Indicates the type of selection
criteria, detail or population.
D = Detail Data
P = Population
PWS-SEQ-NBR Numeric 4 HR65.6 HR65.8
Element: Seq Nbr Contains the sequence number that keeps
each record unique in the file.
PWS-FLD-NBR Numeric 4 HR65.6 HR65.8
Element: Fld Nbr Contains the data dictionary field
number.
PWS-INC-EXC-FLAG Alpha 1 HR65.6 HR65.8
Element: Inc Exc Flag Determines if the application includes
or excludes the records that meet the
defined criteria.
E = Exclude
I = Include
PWS-BEG-VALUE Alpha 25 HR170 HR65.6
Element: Beg Value Contains the beginning value of the HR65.8 HR70.1
selection range.
PWS-THRU-VALUE Alpha 25 HR170 HR65.6
Element: Thru Value Contains the ending value of the HR65.8 HR70.1
selection range.
PWS-ITEM-GRP Alpha 2 HR65.6 HR65.8
Element: Item Grp Hr 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.
PWS-BEG-NEG Alpha 1
Element: Beg Neg Indicates whether the beginning value
is a negative number.
PWS-END-NEG Alpha 1
Element: End Neg Indicates whether the ending value is a
negative number.
PWSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWSSET1 AUTHOR-NAME HR170 HR64.1
TITLE-NBR HR65.1 HR65.2
SELECT-TYPE HR65.6 HR65.8
SEQ-NBR HR710
PWSSET2 AUTHOR-NAME KeyChange HR65.5 HR65.6
TITLE-NBR HR65.7 HR65.8
SELECT-TYPE HR70.1
FLD-NBR
SEQ-NBR
PWSSET3 AUTHOR-NAME KeyChange HR170 HR65.6
TITLE-NBR HR65.8 HR70.1
SELECT-TYPE
ITEM-GRP
FLD-NBR
SEQ-NBR
PWSELECT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
