User / Program / Menu SecurityEvery user is given a security level in their user profile as a numeric entry from 1 to 99, a default entity and a security group definition. When executing programs or menus the user’s security level is matched against the security level, the security group and the entity. This is compared to the menu or program that the user is attempting to run.

For example, if the security level on the program or menu is higher than the user’s security level, the operation of the program or menu will be refused.

A system administrator in the user’s account will typically have control over the program in which the program and menu security levels are established – and will probably also control the editing of the user profiles.

Controlled Edit Access To All DataTypically under the highest available level of security, a universal data edit routine (QuickEdit) is available that enables a user to add, revise or delete any unit of data in the user’s INFO.NET database. This tool can be used to change any data in the system.

Control of Screen Text The text used in screens can be revised by the user, using three different methods:
A specific text entry can be revised in a specific program by selecting the entry from the system messages and editing the entry with new text.

A phrase such as ‘Employee Name’ or ‘Customer Code’, which is used in many places can be revised by entering a replacement phrase in text edit routine. The only stipulation is that the new phase may not be longer than the old phrase. The new phrase will now replace the old phrase in all occurrences.

This procedure can also be limited to revising a message, phrase or word for a specific user, for all users assigned a specific primary language, or for a specific department. If no requirement is placed on the new entry, it will be universally replaced.

Control of Program Message Text The text presented to the user as warning messages, error messages and button text in the screens can be revised by the user by entering a revised message with the same identifying name into the user’s message table.

This enables the user to disable program functions by removing a specific function name from the list of program buttons if required, or revising program error or warning messages. This level of system message editing can be directed to specific organizations or to specific employees, if required.

Control of Report Labels, Titles and Format All of the titles and headers used in reports and queries can be revised by the user, using three different methods:

A specific entry can be revised in a specific program by selecting the entry form the system messages and reentering the title or header with new text.

A phrase such as ‘Employee Name’ or ‘Customer Code’, which are used in many places in the system can be revised to entering a replacement phrase in the system text edit routine. The only stipulation is that the new phase may not be longer than the old phrase. The new phrase will now replace the old phrase in all occurrences in which the old phrase is used.

This procedure can also be limited to revising a message, phrase or word for a specific user, for all users assigned a specific primary language, or for a specific department. If no limitation is placed on the new entry, it will be universally replaced.

User Menu Definitions Although the INFO.NET system will be delivered with a complete set of menus, this menu structure should not be used. It is more than anyone user will ever need to work with. It is also unlikely that the default structure and options will completely satisfy the users.

To correct this situation, INFO.NET provides the ability for the user to create their own menus using their own names, if desired. These menus can be created for individual employees, or for members of a specific department, or as a universal menu for everyone’s use.

Report Definitions There are three types of Info.Net reports:

- Reports formats ending in ‘.q’. The data in this type of report is built in a SQL statement. This makes the data and the format fully modifiable.

- Report formats ending in ‘.r’. The data in this report is compiled in the driving program. The report format can be modified by using an editor to alter the '.r' file in any way that the user desires. These reports constitute the majority of the system reports.

Reports ending in ‘.fmt’. These reports do not have the data or format accessible by the user. Only about 5% of the INFO.NET reports are in the '.fmt' format.

Program Jump Definition The JUMP/DRILL button function permits a user to jump out of a program into a second program, starting a new session in the new program. Each of these jumps can carry the data from the previous program. These jumps can be repeated down ten levels before the system refuses additional jumps.

Although the system will be delivered with a full complement of jump / drill assignments, the user has the ability to override the system definition by new entries, additions or deletions in the user jump / drill edit routine.

The jump drill system also permits individual users to have their own unique version of the jump / drill pathways by the assignment of a jump / drill master code in the user profile.

Link Keywords to Documents, Programs and Menus In order for the user to easily access system programs, menus or documents, the system will provide the following:
· For programs – Any number of aliases can be defined that will point to a specific program.
· For menu – The same options are available as for programs.
For documents – Up to three keywords are available to assist in accessing individual documents.

By entering your own predefined alias or keyword into the SEARCH window, you will be given a list of items that match your entry.

External Unlimited Communications DefinitionsWhen communications entries are required (telephone, email, facebook or twitter), the system provides the ability to define any number of these entries for whichever customer, vendor, employee definitions, etc.

The user can also define any number of communication classes that will permit the categorization of these communications entries.

Link Custom SQL Queries to Programs There is no limit on the number of SQL queries that the user can create, and access, from any program in the INFO.NET system. The SQL statement edit routines will lead the user through the creation of the SQL statement and a menu edit routine is available to permit the user to assign the SQL query to one or more programs.

When running a program with assigned SQL statements, the available queries will be available from a drop down menu in the upper left of the program screen.

Secure SQL Access to All Data INFO.NET contains a routine (named SQL Peek) that permits the user to access all data. The user can also create a SQL statement within the routine to filter and then extract the data using more complex SQL statements. These statements can then be copied into program shells so that they can be put into the users menu.

Data Loader This is a Sys Admin level tool for loading pre-tested and formatted data into a database table. It can also be used to add data to an existing table or to delete all data from a table.

The format of the data to be loaded has to be in comma delimited (.csv). It is loaded in the same order, as it exists in the data table.

Data UnLoader This is a Sys Admin level tool for unloading all of the data from a database table. The format of the data unloaded is comma delimited (.csv). It is unloaded in the same order as exists in the data table.

Data Base Copy Routine This is a Sys Admin level tool that can be used to archive your database or just copy your live database into an alternate account where your staff can practice.

The procedure is simple. Select the Source Database from the drop down list and then select the Destination Database and push the Copy button.

Data Base ToolsThese 13 well documented systems software tools would normally only be accessible by your Sys Admin personnel. These tools will enable a Sys Admin to manipulate, manage and reconstruct the Cscribe database.
Untrained use of these tools could result in disastrous consquences if misused.

Define Job Schedule for Programs to Run This is a systems level definition done within the “Config” tab at the top of the Info.Net menu. By defining a Job to run, the user can automatically initiate program level processes whenever they want. As an example, this could be setup to run MRP every morning at 5:00am so that everyone sees the latest data when they come to work