|
|
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 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 Number 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
Selection Criteria Indicates the type of selection
Type criteria, detail or population.
D = Detail Data
P = Population
PWS-SEQ-NBR Numeric 4 HR65.6 HR65.8
Element: Sequence NumbeContains the sequence number that keeps
each record unique in the file.
PWS-FLD-NBR Numeric 4 HR65.6 HR65.8
Dictionary Field Contains the data dictionary field
Number number.
PWS-INC-EXC-FLAG Alpha 1 HR65.6 HR65.8
Element: Include ExcludDetermines if the system includes or
excludes the records that meet the
defined criteria.
E = Exclude
I = Include
PWS-BEG-VALUE Alpha 25 HR170 HR65.6
Element: Beginning ValuContains 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
End Value Negative Indicates whether the ending value is a
Flag 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
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
|
