Chat now with support
Chat with Support

Stat 6.1 - 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: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Setting Up Migration Approval Lists

If an environment requires the approval of certain users before an archive set can be migrated into it, you can specify who these users are in the Migration Approval List tab. To open this window, select the environment and click App Options in the Generic Application Connection Maintenance table. Stat activates this tab only if the Req. Migr. Approval option has been selected for the environment.

When setting up a migration approval list, you can include different approver groups, including individual users and entire user classes or a combination of the two. The approval of any user or user class that you add to a list can be either required or optional.

Approval requirements that involve multiple approver groups or that can be satisfied in more than one way are defined using AND and OR operators. As you add approver groups using AND and OR operators, Stat displays the list as a tree structure and in the form of a SQL statement at the bottom of the window.

For example, let’s say a migration to a particular environment in the Financial Services service domain can be approved in one of two ways:

In this case, your approval list would look like this:

To further illustrate, let’s say that the migration must be approved by:

In this case, the approval list would look like this:

It is recommended that before setting up a migration approval list, you have a basic idea of what approver groups (users and user classes) you want involved in the approval process as well as the relationships between these groups, which you define using AND and OR operators. For example, if the approval of one or more approver groups are required, you would begin the approval list with the AND operator. If, however, the approval of only one of two or more approver groups are required, you would begin the list with the OR operator.

Click AND if the approval of one or more approver groups are required
Click OR if the approval of one of two or more approver groups are required
In the Service Domain field, select the service domain that you plan to associate the environment with in the Generic Application Migration Path Maintenance table.
In the Approver Type field, select the approver group you want to add to the list.
Options include User and User Class.
In the Approver Name field, select the name of the user or user class you want to add.
In the Required field, select Required if the approval is required or Optional if it is not required.
The Required option means that the individual user and every member of the user class must approve the migration. Optional means that the individual user’s approval is not required, whereas for user classes, it means that the approval of only a specified minimum number of users within that class is required.
If you selected User Class in the Approver Type field and Optional in the Required field, specify the minimum number of users in that class who must approve the migration in the Number field.
Click Add.
Click AND or OR.
Click OK or Apply.

Copying Generic Application Environments

If you need to define a generic application environment that closely resembles an existing generic application environment, you can save time by copying the definition of the existing environment and editing the copy as needed. When you copy a generic application environment, all the information gets copied over, including file locations and migration approval lists.

Schema Object Parameters Maintenance

Oracle and SQL Server database schema objects include a set of predefined true/false parameters that are executed before the definition of the object is captured in Stat. You can change the true/false values of these parameters in the Schema Object Parameters Maintenance table.

The ability to change default schema object parameter values is controlled by the following user class right:

The Schema Object Parameters Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | Schema Object Parameters.

The Schema Object Parameters Maintenance table lists each parameter by DDL type and name. The Default Value column indicates whether a particular parameter is true or false by default. To change the value of a parameter, select its corresponding check box in the Param Value column to make it true, or de-select it to make it false. Then click OK or Apply.

Data Object Maintenance

Data objects are user-defined or third party data sets developed for specific application environments. You can configure Stat to support data objects by defining in the Data Object Maintenance table the tables and table keys that make up the definition of these objects within their native environment. Data objects can be locked, archived, and migrated just like the proprietary objects already supported by Stat.

Data objects are specific to the change management module that they are defined for. This means that data object types supported in one change management module are not supported in the other modules. To avoid confusion, data object types for PeopleSoft, Oracle Applications, and generic applications are defined and maintained in separate tabs on the Data Objects Maintenance window. The maintenance procedures for all three are the same.

The Data Object Maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | Data Objects.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating