Chat now with support
Chat with Support

Stat 6.2 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: REST Web Services API Appendix: SOAP-Based Web Services API Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Department View Example

CREATE OR REPLACE FORCE VIEW ps_stat_dept_vw (deptid, descr)
AS
SELECT a.deptid, a.descr
FROM ps_dept_tbl a
WHERE a.setid = 'CDN';

Exclusions

You can exclude certain companies, departments, or pay groups from the search results.

To define an employee search exclusion:
1
In the PeopleSoft Employee Search Configurations window, select the environment you want and click Exclusions.
Stat opens the Employee Search Exclusions window.
2
Click New.
3
In the Exclusion Type field, select the type of entity you want to exclude.
Options include Company, Dept ID, and Pay Group.
4
In the Value field, enter a 1-10 character code which identifies a valid department, company, or pay group in the PeopleSoft environment.
5
Click OK to save your work.

Stat Report Definition Maintenance

The Stat Report Definition Maintenance table defines the security levels of all the reports available in the Stat Report Library. It also defines how they are presented and described in the Stat Report Wizard.

The Stat Report Library includes all predefined reports, and any custom reports defined by users. With a predefined report type, you can change the security level and its description in the Stat Report Library, but you cannot directly modify the report format itself.

Stat report security is controlled by the user class right, Stat Report Definition - Edit. There is no add right.

The Stat Report Definition Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | Stat Reports.

Value
Description

Available

Indicates if this report type is available in Stat

Custom

Indicates if the report type is user-defined

Description
(Required Value)

A brief description of the report. This description is displayed in the report list of the Report Library.

Long
Description (Required Value)

A longer description of the report. This is displayed just below the layout preview in the Report Library when a report is selected from the list.

Category
(Required Value)

The order in which the Report is grouped on the report list in the Stat Report Library window.

Presentation
(Required Value)

Presentation style of the report; Option include:

Bar Graph

Cross Tab

Excel

List

Pie Chart

Standard

NOTE: This value only affects how the presentation style of the report is described in the Stat Report Library window. It does not affect the actual presentation style of the report.

Security Level
(Required Value)

The security level of the report. In order for a user to open a report, their report security level (defined on the Stat users table) must be greater than or equal to this value. Valid values are 0 - 99, with 0 equaling minimum security and 99 equaling maximum security.

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

Editing Reports

If at any time you want to modify the definition of a report or upload an updated .jrxml file, select it in the maintenance window and click Edit. This opens the Edit Report window where you can modify the report as needed. Only the fields that can be modified are enabled. For predefined reports, you can edit the short and long description and security level.

If desired, you can also select the Inactive option if you do not wish the report to display on the Report Wizard list.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating