Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email supportadmin@quest.com for assistance

Stat 6.3 - 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

Identifiers

Tables

Where Clauses

The Provider Croup tables, along with their Where Clauses, include:

PS_RF_PROVIDER_GRP (Parent Table)

SETID = %A% AND PROVIDER_GRP_ID = %B%

PS_RF_GRP_MEMBER

SETID = %A% AND PROVIDER_GRP_ID = %B%

PS_RF_PROVGRP_RGN

SETID = %A% AND PROVIDER_GRP_ID = %B%

PS_RF_COST_CAT_GRP

SETID = %A% AND PROVIDER_GRP_ID = %B%

PS_RF_COST_CAT

SETID = %A% AND COST_CAT_CD = (SELECT COST_CAT_CD FROM PS_RF_COST_CAT_GRP WHERE SETID = %A% AND PROVIDER_GRP_ID = %B%)

PS_RF_COST_CAT_MEM

SETID = %A% AND PROVIDER_GRP_ID = %B%

All the tables, where clauses, table keys, columns, and blobs in the Data Model must be entered in the Tables Definition section of the Edit Data Objects window.

The PS_RF_PROVIDER_GRP and PS_RF_GRP_MEMBER tables contain Blob fields. This information need to be defined in the Blob Column fields.

The next step is to create the Stat Archive table, which contains the object archives.

At this point, Provider Group data objects are fully defined in Stat and now can be added to a CSR, archived, and migrated.

PeopleSoft Search Configurations

The PeopleSoft Search Configuration table specifies the PeopleSoft environments from which customer, department or country information can be retrieved and inserted into the Stat Repository. Information can be retrieved from PeopleSoft employee, department or country views.

PeopleSoft security is controlled by the following user class rights:

The PeopleSoft Search Configurations table is displayed in a standard maintenance window. To open this window, select Maintenance | General | PeopleSoft Srch Configs.

Active

Indicates if this record is available for selection

PeopleSoft
Database
(Required Value)

The PeopleSoft environment that contains the customer information

Description
(Required Value)

Description of the configuration or environment

Search View Name
(Required Value)

An 18-character field that contains the name of a table or view in PeopleSoft against which the search is conducted. See the next section, Creating Tables and Views .

Type
(Required Value)

Indicates the type of PeopleSoft view that is the basis for the search. Options included Employee, Department or Country.

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating