Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department 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

Field Name Coding Convention

Column headings are coded as follows:

Diamond

The values displayed in these columns are key values and are required. Key values must be unique. For tables with one key value, each definition must have a unique key. For tables with multiple key values, the combination of the key values must be unique.

Asterisk

Required column. A value must be entered in this column.

All other columns are either optional (meaning data may be entered in this column or the column may be left blank) or read-only.

Scroll Bar

Along the bottom of the list is a horizontal scroll bar that scrolls the list to the left or right.

Splitter Bar

The splitter bar is a special tool that lets you keep the columns to the left visible regardless of how far right you scroll. This tool is particularly helpful when working on a table with many columns.

When scrolled completely to the right, not all of the data on the left is visible.

Note that when activating the splitter, a gray vertical line is displayed. A complete display of the list is available on either side of the line. You can move the line to the left or right to resize either list. You can also scroll left or right within each list.

When you scroll up or down, both lists remain synchronized.

To activate the splitter, click and drag the small black line to the left of the horizontal scroll bar.

To deactivate the splitter, simply drag the bar back to its original position.

Field Types

The record list values are displayed in different types of fields.

Check boxes indicate a yes/no or on/off value. When a check box is deselected, the value is off or no. When selected, the value is on or yes.

These fields are used to manually enter text.

These fields are used when the possible values are limited to a specific set. Often times, these lists link back to another table. For example, when specifying a customer value, you must select a department from a list previously defined in the Department Maintenance table.

Spin controls are used exclusively for numeric values and have small up and down arrow buttons to the right of the control. To increase the value, click the up arrow; to decrease the value, click the down arrow. Spin controls are provided strictly as a convenience. You can also manually enter a value in these fields.

Related Documents