PWTITLE

HR Report Writer Title

Contains the title definition for each HR Writer report.

REFERENCED BY
HRS1.1 HRSC.1 HR60.1 HR67.1 HR710


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWT-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.1
PWT-TITLE
Element: Title
Alpha 30 (Lower Case)
Contains the user-defined report title.
HR64.1 HR65.1
PWT-TITLE-NBR
Element: Title Nbr
Numeric 4
Contains the automatically assigned title number for authors.
HR64.1 HR65.1
PWT-TYPE
Element: Type
Alpha 2
Indicates the type of report defined:
A = Applicant
E = Employee
H = Employee History
HR65.1
PWT-NBR-COPIES
Element: Nbr Flds
Numeric 2
Contains the number of report copies. Appears on the first page of the report.
HR65.1
PWT-FREQUENCY
Element: Frequency
Alpha 1
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
HR65.1
PWT-FMT-FLD-NBR
Element: Fmt Fld Nbr
Numeric 4 Occurs 15 Times
Contains the field number from the data dictionary. The field number represents the field that prints in this position on the report format.
HR65.2 HR65.3
PWT-FLD-SIZE
Element: Fld Size
Numeric 2 Occurs 15 Times
Contains the size of the field.
HR65.2 HR65.3
PWT-RPT-FLD-NBR
Element: Rpt Fld Nbr
Numeric 4 Occurs 15 Times
Contains the data dictionary number that represents the field used in selecting an employee or applicant population for the report.
HR65.5
PWT-REC-FLD-NBR
Element: Rec Fld Nbr
Numeric 4 Occurs 15 Times
Contains the data dictionary number that represents the field used for selecting detail data for the report.
HR65.7
PWT-SRT-FLD-NBR
Element: Srt Fld Nbr
Numeric 4 Occurs 9 Times
Contains the data dictionary field number used in the report sort order.
HR65.4
PWT-TOTAL-FLAG
Element: Total Flag
Alpha 1 Occurs 9 Times
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
HR170 HR65.4
PWT-PG-BREAK
Element: Pg Break
Numeric 1
Contains the sort level at which a new page is started.
HR65.4
PWT-LAST-ITEM-SEQ
Element: Seq Nbr
Numeric 4
Contains the sequence number used to store the last item.
HR65.6 HR65.8
PWT-BEG-DATE
Date Range -
Beginning Date
Numeric 8 (yyyymmdd)
Contains the beginning date used for selection of date sensitive detail data.
HR170 HR65.8
HR70.1
PWT-END-DATE
Date Range - Ending
Date
Numeric 8 (yyyymmdd)
Contains the ending date used for selection of date sensitive detail data.
HR170 HR65.8
HR70.1
PWT-DTL-TOPIC
Element: Detail Topic
Alpha 2
Contains the topic that provides detail data items for selection, sorting, and printing on the report.
HR65.1
PWT-SUMMARY-FLAG
Element: Detail Line
Alpha 1
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
HR65.1
PWT-COMPUTE-NBR
Element: Compute Nbr
Numeric 4 Occurs 15 Times
Contains the sequence number of the compute statement. A compute number is automatically assigned in sequential order by author.
HR65.2 HR65.3
PWT-PRINT-TOTAL
Element: Print Total
Alpha 1 Occurs 15 Times
Contains the total option for each sort 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
HR65.2 HR65.3
PWT-SKIP-FLAG
Element: Suppress Individual
Alpha 1
Indicates if an employee or applicant should be skipped completely on the report if the application 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
HR170 HR65.8
HR70.1
PWT-AS-OF-DATE
Element: As Of Date
Numeric 8 (yyyymmdd)
Contains the "as of" date. Determines 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.
HR170 HR65.3
HR70.1
PWT-PRINT-NAME
Element: Print File Name
Alpha 10
Contains the name of the print file.
HR65.1
PWT-DIST-GROUP
Element: Distribution Group
Alpha 10
Contains 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.
HR65.1
PWT-PRINTER
Element: Printer
Alpha 10
Identifies the printer that prints the report.
HR65.1
PWT-SAVE-REPORT
Element: Save Report
Alpha 1
Indicates whether the application saves the report in print manager.
HR65.1
PWT-SPREAD-NAME
Element: Spreadsheet Name
Alpha 10
Contains the name of the spreadsheet to which the report is downloaded and imported.
HR65.1
PWT-FMT-TOPIC
Element: Fmt Topic
Alpha 2 Occurs 15 Times
Contains the topic that displays associated data items for report format selection.
HR65.2 HR65.3
PWT-RPT-TOPIC
Element: Rpt Topic
Alpha 2 Occurs 15 Times
Contains the topic that displays associated data items used for population selection on the report.
HR65.5
PWT-REC-TOPIC
Element: Rec Topic
Alpha 2 Occurs 15 Times
Contains the topic that displays associated data items used for detail data selection on the report.
HR65.7
PWT-SRT-TOPIC
Element: Srt Topic
Alpha 2 Occurs 9 Times
Contains the topic that displays associated data items used for determining the sort order for the report.
HR65.4


PWTITLE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWTSET1 AUTHOR-NAME
TITLE
HR04.4 HR04.5
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
HR710 HRS1.1
HRSC.1
PWTSET2 AUTHOR-NAME
FREQUENCY
TITLE-NBR
KeyChange
HR170 HR70.1


PWTITLE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
AndPWT-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
NAME
RELATED 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


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

Home
Contact Us



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