System Administration Overview

This section provides an overview of the most common StreamV System Administration Tasks.  Topics that are described in this section include.

•      Parent Table Data Creation and Maintenance.   Parent Data is required data that is used by many areas in the system. Examples data include items such as divisions, departments, operators, payment terms, shipping methods, zip codes and tax codes.

•      Generic Code Table Creation and Maintenance.  Generic Code or “Gencode” tables allow you to add validation options to specific fields in the system.  Some Gencode tables are required.  Other Gencode tables are optional and are set up by the customer for site specific purposes.

•      Maintaining System Policies and Parameters.  Setting System or Program Configuration options, using System Administration programs or System Administrator options in standard programs.

•      System Security.  Controlling Access to Menus, Programs, Program Options and specific data files and or fields  in the StreamV application.

•      Field Defaults – Setting up the default information to be used for new database records.   Defaults allow you to speed up data entry, by loading specific fields in new records.  The default information and security can be combined to both default and restrict the ability to change sensitive information (such as payment terms or credit limits) during new record creation.

•      Field Labels.  Setting up site specific labels for specific fields in the database.  The field labels allow you rename spare or other fields based on your specific use for them

•      Field Masking.  Field Masking allows you to control the formatting of specific data, such as phone numbers, and to restrict the amount of data that can be entered into fields.  Phone number formats can be set up in a country specific format, numeric field precision can be controlled, and the amount of data that can be entered into a specific field can be adjusted using field masking options.

•      TextData file Maintenance.  The TextData file contains System Control records that are used to control system behavior or store configuration information..  The file also contains standard SQL Query reports, forms formatting information, and other data.

•      CoveText File:  The CoveText file is a Cove file that is overwritten during system updates.  It is used to deliver new TextData, and field help information to the customer sites when updates are performed.

•      LongCode File.  The LongCode file stores configuration information and other data used by the system.  MyCove, MyGroup, and some other menu and program security information.

•      .


Parent Table Data Creation and Maintenance

Generic Code Table Creation and Maintenance

System Policies and Parameters

StreamV Security Options

New Record Field Default Information

Software Testing, Release, and Installation Procedures

Data Archiving and Data Retention

SQL Database Administration