|
|
PWTITLE FILE
HR Report Writer Title
Contains the title definition for each HR Writer report.
REFERENCED BY
HR04.4 HR04.5 HR04.6 HR170 HR60.1 HR67.1
HR70.1 HR70.2 HR70.3 HRS1.1 HRSC.1
UPDATED BY
HR64.1 HR65.1 HR65.2 HR65.3 HR65.4 HR65.5
HR65.6 HR65.7 HR65.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWT-AUTHOR-NAME Alpha 10 HR65.1
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.
PWT-TITLE Alpha 30 (Lower Case) HR64.1 HR65.1
Element: Title Contains the user-defined report title.
PWT-TITLE-NBR Numeric 4 HR64.1 HR65.1
Element: Title Number Contains the automatically assigned
title number for authors.
PWT-TYPE Alpha 2 HR65.1
Element: Type Indicates the type of report defined:
A = Applicant
E = Employee
H = Employee History
PWT-NBR-COPIES Numeric 2 HR65.1
Element: Number Fields Contains the number of report copies.
Appears on the first page of the report.
PWT-FREQUENCY Alpha 1 HR65.1
Element: Frequency Contains the report frequency. Used to
identify a group of titles to be
generated by HR170 (HR Writer Report
Request).
A = Annually
M = Monthly
O = On Demand
Q = Quarterly
W = Weekly
PWT-FMT-FLD-NBR Numeric 4 Occurs 15 Times HR65.2 HR65.3
HR Writer Format Contains the field number from the data
Field Number dictionary. The field number represents
the field that prints in this position
on the report format.
PWT-FLD-SIZE Numeric 2 Occurs 15 Times HR65.2 HR65.3
Element: Field Size Contains the size of the field.
PWT-RPT-FLD-NBR Numeric 4 Occurs 15 Times HR65.5
Population Select Contains the data dictionary number
Field Number that represents the field used in
selecting an employee or applicant
population for the report.
PWT-REC-FLD-NBR Numeric 4 Occurs 15 Times HR65.7
Detail Data Select Contains the data dictionary number
Field Numbe that represents the field used for
selecting detail data for the report.
PWT-SRT-FLD-NBR Numeric 4 Occurs 9 Times HR65.4
Report Sort Order Contains the data dictionary field
Field Number number used in the report sort order.
PWT-TOTAL-FLAG Alpha 1 Occurs 9 Times HR170 HR65.4
Element: Total Flag Contains the total indicator for the
sort level.
A = Print averages and totals
N = Do not print totals
R = Print record count only
S = Print totals - Suppress detail
Y = Print totals
PWT-PG-BREAK Numeric 1 HR65.4
Element: Page Break Contains the sort level at which a new
page is started.
PWT-LAST-ITEM-SEQ Numeric 4 HR65.6 HR65.8
Element: Sequence NumbeContains the sequence number used to
store the last item.
PWT-BEG-DATE Numeric 8 (yyyymmdd) HR170 HR65.8
Date Range - Contains the beginning date used for HR70.1
Beginning Date selection of date sensitive detail data.
PWT-END-DATE Numeric 8 (yyyymmdd) HR170 HR65.8
Date Range - Ending Contains the ending date used for HR70.1
Date selection of date sensitive detail data.
PWT-DTL-TOPIC Alpha 2 HR65.1
Element: Detail Topic Contains the topic that provides detail
data items for selection, sorting, and
printing on the report.
PWT-SUMMARY-FLAG Alpha 1 HR65.1
Element: Detail Line Indicates whether the report prints
multiple detail lines for each employee
or applicant, or just a summary line of
numeric information.
M = Print multiple detail lines
S = Print one summarized detail
PWT-COMPUTE-NBR Numeric 4 Occurs 15 Times HR65.2 HR65.3
Compute Statement Contains the sequence number of the
Number compute statement. A compute number is
automatically assigned in sequential
order by author.
PWT-PRINT-TOTAL Alpha 1 Occurs 15 Times HR65.2 HR65.3
Print Total Contains the total option for each sort
Indicator level defined.
Y = Print Column Totals
N = Do Not Print Column Totals
R = Repeat Last Item in Clm/Total
C = Emp/App Count on Total Line
PWT-SKIP-FLAG Alpha 1 HR170 HR65.8
Element: Suppress IndivIndicates if an employee or applicant HR70.1
should be skipped completely on the
report if the system finds no data for
the selected detail topic for the
employee or applicant.
N = Print Emp/App Even If/No Detl
Y = Skip Emp/App If/No Qualif. Dtl
X = Skip Emp/App If No Detail
PWT-AS-OF-DATE Numeric 8 (yyyymmdd) HR170 HR65.3
Element: As of Date Contains the "as of" date. Determines HR70.1
if historical employee information is
extracted as of a specific date rather
than what is currently on the Employee
record (if different). If an employee's
hire date is after the "as of" date, the
employee does not appear on the report.
PWT-PRINT-NAME Alpha 10 HR65.1
Element: Print File NamContains the name of the print file.
PWT-DIST-GROUP Alpha 10 HR65.1
Element: Distribution GContains the distribution group. If you
define a distribution group for a
report, it is transmitted to all
individuals in the distribution group
when you run the report.
PWT-PRINTER Alpha 10 HR65.1
Element: Printer Identifies the printer that prints the
report.
PWT-SAVE-REPORT Alpha 1 HR65.1
Element: Save Report Indicates whether the system saves the
report in print manager.
PWT-SPREAD-NAME Alpha 10 HR65.1
Element: Spreadsheet NaContains the name of the spreadsheet to
which the report is downloaded and
imported.
PWT-FMT-TOPIC Alpha 2 Occurs 15 Times HR65.2 HR65.3
Element: Fmt Topic Contains the topic that displays
associated data items for report format
selection.
PWT-RPT-TOPIC Alpha 2 Occurs 15 Times HR65.5
Element: Rpt Topic Contains the topic that displays
associated data items used for
population selection on the report.
PWT-REC-TOPIC Alpha 2 Occurs 15 Times HR65.7
Element: Rec Topic Contains the topic that displays
associated data items used for detail
data selection on the report.
PWT-SRT-TOPIC Alpha 2 Occurs 9 Times HR65.4
Element: Srt Topic Contains the topic that displays
associated data items used for
determining the sort order for the
report.
PWTITLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWTSET1 AUTHOR-NAME HR04.4 HR04.5
TITLE HR04.6 HR170
HR60.1 HR64.1
HR65.1 HR65.2
HR65.3 HR65.4
HR65.5 HR65.6
HR65.7 HR65.8
HR67.1 HR70.1
HR70.2 HR70.3
HRS1.1 HRSC.1
PWTSET2 AUTHOR-NAME KeyChange HR170 HR70.1
FREQUENCY
TITLE-NBR
PWTITLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Author PWAUTHOR Required
PWT-AUTHOR-NAME -> PWA-AUTHOR-NAME
Compute Field PWCOMPUTE Required
When PWT-COMPUTE-NBR != Zeroes
PWT-AUTHOR-NAME -> PWC-AUTHOR-NAME
PWT-COMPUTE-NBR -> PWC-COMPUTE-NBR
Format Field PADICT Required
When PWT-FMT-FLD-NBR != Zeroes
And PWT-FMT-FLD-NBR != 9999
PWT-FMT-FLD-NBR -> PAD-FLD-NBR
Report Field PADICT Required
When PWT-RPT-FLD-NBR != Zeroes
PWT-RPT-FLD-NBR -> PAD-FLD-NBR
Sort Field PADICT Required
When PWT-SRT-FLD-NBR != Zeroes
PWT-SRT-FLD-NBR -> PAD-FLD-NBR
PWTITLE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pop Select PWSELECT Delete Cascades
PWT-AUTHOR-NAME -> PWS-AUTHOR-NAME
PWT-TITLE-NBR -> PWS-TITLE-NBR
"P" -> PWS-SELECT-TYPE
PWS-SEQ-NBR
Rec Select PWSELECT Delete Cascades
PWT-AUTHOR-NAME -> PWS-AUTHOR-NAME
PWT-TITLE-NBR -> PWS-TITLE-NBR
"R" -> PWS-SELECT-TYPE
PWS-SEQ-NBR
Topics PWTITLETOP Delete Cascades
PWT-AUTHOR-NAME -> PTT-AUTHOR-NAME
PWT-TITLE -> PTT-TITLE
PTT-TOPIC
|
