Overview of Stat Administration
Stat Architecture and Components
Administrative Utilities
Windows Client / Web Browser
Stat Central Agent / App Web Server
Database Tier
Application Environments
Stat Administrator Responsibilities
Manage Stat Maintenance Tables
Administer Security
Manage the Stat Central Agent
Provide End-User Support
Perform Application Upgrades
Perform Database Maintenance
The Stat SYSTEM User Account
Standard Maintenance Windows
Buttons and Controls
The Record List
Field Types
Adding and Deleting Records
Using the Color Selection Dialog Box
Importing and Exporting Maintenance Tables
Stat INI Editor
Stat Security
The Database Tab
Encryption Key Update
Data Replicator
Table Dump Utility
PeopleSoft Object Mover Instruction Update Utility
Configuration Guide for New Installations
General Setting Information
Changing the STATLOGIN Password
Testing Connections
Editing Records
Deleting Records
Duplicating Records
Copying Record Values
Order of Appearance
Printing the Stat INI file
The Options Tab
Stat Security Layers
Defining User Classes
Editing User Class Rights
Defining Stat Users
General Maintenance Tables
Copying User Definitions
Resetting Passwords
The User Access Information Window
LDAP Connection Maintenance
Connection Manager
Service Domain Access Tab
PS Options Tab (PeopleSoft only)
User File Directories Tab
Queue Assignment Tab
Application Access Tab
Object Type Access Tab
Environment Access Tab
Pre/Post Migration User Parameters Tab
Synchronizing User Access Information
User Password Security Settings
System Maintenance
Service Domain-Specific Maintenance
General Tab
License Tab
Users Tab
Other Options Tab
Parameters Tab
DB Scripts Tab
CSR History Tab
Approvals Tab
Service Domain Maintenance
Department Maintenance
Issue Tracking Maintenance
Country Maintenance
Customer Maintenance
Object Type Maintenance
File Types
PeopleSoft Environment Connection Maintenance
File Types for Oracle Applications
Source File Locations
File Type User Directories
VCM Locations
File Templates
Setup Object Types for Oracle Applications
File Servers
File Path Syntax
Case Sensitivity and File Name Conversion
Server-Specific Pre/Post Migration Step Parameters
SFTP Public Key-Based Authentication
User Default Directories
Oracle Apps Base Directories
Testing File Locations, Servers, and Default Directory Locations
Oracle
Testing Environment Connections
Inactivating PeopleSoft Environments
Managing File Locations by Environment
PeopleSoft Options
Pre/Post Migration Steps Parameters
Oracle Applications Configuration
Oracle Applications Connection Maintenance
Setting Up User Connections
Setting Up Physical Object Lock Exclusions
Setting Up Migration Approval Lists
Copying PeopleSoft Environments
Testing Environment Connections
Defining Oracle Applications Servers
Start/Stop Oracle Applications Agents
Inactivating Oracle Applications Environments
Setting Up Migration and Patch Approval Lists
Updating Products per Environment
Copying Oracle Applications Environments
Generic Application Connection Maintenance
Testing Environment Connections
Inactivating Generic Application Environments
Managing Source File Locations by Environment
Setting Up Migration Approval Lists
Copying Generic Application Environments
Schema Object Parameters Maintenance
Data Object Maintenance
PeopleSoft Search Configurations
Creating Tables and Views
Stat Report Definition Maintenance
Version Control Management Connection Maintenance
Employee View Example (Pre PeopleTools Version 8.48)
Employee View Example (PeopleTools Version 8.48 and Higher)
Country View Example
Department View Example
Exclusions
Working With Service Domains
Activity Code Maintenance
Application Maintenance
Application Environment Maintenance
Auto Task Maintenance
Business Rule Maintenance
Configuring the Stat Central Agent
Defining Business Rules
CSR Log Topics Maintenance
CSR Priority Maintenance
CSR Type and Status Maintenance
Customer Priority Maintenance
Generic Application Migration Path Maintenance
Selecting a Trigger Event
Defining Rule Criteria
Defining Message Content
Defining a Distribution List
Defining a Command to Run
Resetting a Rule
Saving Rules
Disabling Rules
Copying Rules
Viewing Rule History
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
PeopleSoft Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Oracle Application Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Pre and Post Migration Steps
Release Management Maintenance
Template Maintenance
Queue Maintenance
Workflow Maintenance
Starting and Stopping the Stat Central Agent
Defining Agent Jobs
Email Configuration
Error Notification
Job Maintenance
Job Classes
Stat Central Agent Printers
Monitoring the Stat Central Agent
Check for Past Due Items
Email Reports and Print Reports
Log Off and Wait
PS Object Lock Sync
Purge Agent Event Tables
Purge Audit Tables
Purge Deleted Archive Sets
Purge Error Log Tables
Purge Migration Event Tables
Stat Central Agent Purge System-Generated Logs
Run Operating System Command
Unlock Locked CSRs
The Schedule Tab
The Error Notification Tab
Accessing the Job Monitor
Schedule Tab
Jobs Tab
Logs Tab
Filtering and Sorting
Showing Job and Log Details
Customizing the What's New Tab in Stat Web
Customizing Field Labels for the Stat Web Client
Configuring the Stat Central Agent for Email
Outbound Mail Configuration
Inbound Mail Configuration
Object Security
Default Values Tab
Special Processing Tab
Skip Processing
Undeliverable Processing
Info Request Processing
Adding a Parameter
Order of Processing
Removing or Editing a Parameter
Advanced Customer Identification and Tracking # Tabs
Regular Expressions
Regular Expression Examples
Adding a Regular Expression
Order of Processing
Removing or Editing a Regular Expression
Field-Specific Tabs
Reply Tabs
PeopleSoft Proprietary Object Security
PeopleSoft Object Security Setup Instructions
Frequently Asked Questions
File Object Security
Appendix: Sample Service Domain Configuration
Appendix: User Class Rights
Notes on User Class Rights
CSR Edit Rights
CSR Tabs Rights
CSR Tasks Rights
Generic Application Migration Management Rights
Generic Application Object Management Rights
Maintenance - File Object Rights
Maintenance - General Rights
Maintenance - Service Domain Rights
Oracle Apps Migration Rights
Oracle Apps Object Management Rights
Oracle Apps Patch Management Rights
PeopleSoft Migration Management Rights
PeopleSoft Object Management Rights
Project Rights
Security Rights
Stat Central Agent Rights
Tool Rights
Wizard 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
Services and Exposed Methods
Appendix: Troubleshooting Chart
Login Service
Class Definitions
long connect( String userId, String password ) throws WSLoginFault;
void disconnect( long connectId );
CSR Service
Approval Service
Stat Database
Stat Central Agent
Stat Oracle Agent
Login/Connection
Administrative Utilities
CSRs
Stat Web
Archiving and Migrating
Printing
Miscellaneous
Appendix: stat.conf Configuration
Appendix: Custom Report Files
Activating Record Changes
Using the Color Selection Dialog Box
Several of the maintenance tables have a special function button that lets you edit the display color. To edit the display color, select the record you want, then click Color.... Stat opens the Color Selection dialog box.
Using a Predefined Color
To use a predefined color, click on the color you want in the Predefined field.
Using a Custom Color
To create a custom color, slide the red, green and blue scroll bars left or right until the Sample Text field displays the color you want.