HR Report Writer Title
Contains the title definition for each HR Writer report.
REFERENCED BY
HRS1.1 | HRSC.1 | HR60.1 | HR67.1 | HR710 |
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. |
|
||||
PWT-TITLE Element: Title | Alpha 30 (Lower Case) Contains the user-defined report title. |
|
||||
PWT-TITLE-NBR Element: Title Nbr | Numeric 4 Contains the automatically assigned title number for authors. |
|
||||
PWT-TYPE Element: Type | Alpha 2 Indicates the type of report defined: A = Applicant E = Employee H = Employee History |
|
||||
PWT-NBR-COPIES Element: Nbr Flds | Numeric 2 Contains the number of report copies. Appears on the first page of the report. |
|
||||
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 |
|
||||
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. |
|
||||
PWT-FLD-SIZE Element: Fld Size | Numeric 2 Occurs 15 Times Contains the size of the field. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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 |
|
||||
PWT-PG-BREAK Element: Pg Break | Numeric 1 Contains the sort level at which a new page is started. |
|
||||
PWT-LAST-ITEM-SEQ Element: Seq Nbr | Numeric 4 Contains the sequence number used to store the last item. |
|
||||
PWT-BEG-DATE Date Range - Beginning Date | Numeric 8 (yyyymmdd) Contains the beginning date used for selection of date sensitive detail data. |
|
||||
PWT-END-DATE Date Range - Ending Date | Numeric 8 (yyyymmdd) Contains the ending date used for selection of date sensitive detail data. |
|
||||
PWT-DTL-TOPIC Element: Detail Topic | Alpha 2 Contains the topic that provides detail data items for selection, sorting, and printing on the report. |
|
||||
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 |
|
||||
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. |
|
||||
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 |
|
||||
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 |
|
||||
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. |
|
||||
PWT-PRINT-NAME Element: Print File Name | Alpha 10 Contains the name of the print file. |
|
||||
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. |
|
||||
PWT-PRINTER Element: Printer | Alpha 10 Identifies the printer that prints the report. |
|
||||
PWT-SAVE-REPORT Element: Save Report | Alpha 1 Indicates whether the application saves the report in print manager. |
|
||||
PWT-SPREAD-NAME Element: Spreadsheet Name | Alpha 10 Contains the name of the spreadsheet to which the report is downloaded and imported. |
|
||||
PWT-FMT-TOPIC Element: Fmt Topic | Alpha 2 Occurs 15 Times Contains the topic that displays associated data items for report format selection. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PWTSET1 |
AUTHOR-NAME TITLE |
|
| ||||||||||||||||||||||||||||
PWTSET2 |
AUTHOR-NAME FREQUENCY TITLE-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Author | PWAUTHOR |
Required
| |||||||||||||||
Compute Field | PWCOMPUTE |
Required
| |||||||||||||||
Format Field | PADICT |
Required
| |||||||||||||||
Report Field | PADICT |
Required
| |||||||||||||||
Sort Field | PADICT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Pop Select | PWSELECT |
Delete Cascades
| ||||||||||||
Rec Select | PWSELECT |
Delete Cascades
| ||||||||||||
Topics | PWTITLETOP |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.