Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review

Chapter XI - Code Table and User Maintenance

 

 

A: Introduction
B: Code Table Maintenance
C: User Maintenance
D: Levels of Security

 

A. Introduction

 

The Code Table Maintenance option is only available to those with the highest security level access. Most users will not see this option on the Main System menu. Instead, they will see the User Maintenance option (see Section C).

Code tables are a very important component of a table driven system, such as MINFILE/pc. Code tables allow the flexibility to accommodate the changing needs of system users. System administration involves updating the code tables. The code tables contain information that controls various system functions, such as:

 

  • suggesting possible values for data entry fields
  • controlling input to the data entry screens
  • allowing different users to access the system.

IMPORTANT: Modifications and deletions to the code tables can result in system inconsistencies. Since persons with limited MINFILE/pc system knowledge can inadvertently corrupt the database, please contact the Victoria MINFILE office before changing the Code tables.

 

To activate the Code Table Maintenance option, go to the System Configuration menu in MINFILE Utilities. Under "Code Maintenance", change the setting to "On". When you reopen MINFILE, you will see "Code Tables" under System in the main menu.  The Code Tables can then be accessed from the Main System menu and the following screen will result:

 

Code Table Maintenance screen.

 

B. Code Table Maintenance

 

The first two choices on this screen are defined in the following text.

1. Dynamic Code Tables

This screen contains tables that are changed more frequently than static tables. The tables are listed on the screen below:

 

Dynamic Code Tables screen.

 

To change a table, select it from the list. For example, select Commodities and the following screen will appear:

 

Edit code tables.

 

The edit options appear in the top left corner of the screen, and the number of codes is shown in the bottom right corner. To add a new code to the table, choose Append and press the enter key twice, or click on the code field to see this screen:

 

Edit commodity table.

 

Type the code that you would like to add, and press enter. To quit press the escape key.

 

NOTE: The code itself cannot be changed, only the description of the code can be changed. If you wish to change a code, you must create a new code and revise the old code so that the description = "obsolete". Codes should never be deleted because this could corrupt the database for other users.

To change a mistake, or simply to change one of the descriptions of a code, you may need to use the Revise option from the selection list. Choose Revise from the list (you may need to press 'Esc' to get the edit options to appear), and press 'Enter' twice. A list of the codes in the table will appear on the screen, with the top code highlighted. Use your down arrow (or up arrow) and 'PgDn' (or 'PgUp') keys to highlight the code that you wish to revise. Once you have highlighted the code you wish to revise, press 'Enter'. The following screen shows the revision of "Aluminum":

 

Edit commodity table.

 

HINT: If you make a mistake and don't want your changes to corrupt the system, choose UNDO from the edit options list when you leave the code maintenance screen.

 

Submit will commit all of the changes that you have made to the database. Once you have chosen to Submit your changes there is no way to change your mind. Undo will cancel all of the changes that you have made.

There are two things that have not been described from the selection list: Browse and Select. They can be described best by looking at the Stratigraphic Names code table. When the Stratigraphic code table is chosen the following screen appears:

 

Edit Stratigraphic Name table.

 

The list on the screen does not show the codes in the table. It is a list of ranges of codes that you may access in the code table maintenance screen. By choosing one of the lines on this screen you will limit the range to only the codes described by the line chosen. In this example, the range from "Jubilee" to "Mahto" will be used.

Choosing Browse from the edit options will display all of the codes in the range that you can access. The following screen shows the codes from "Verde Creek Pluton" to "Westkettle Batholith" (with the ability to scroll to "Ymir").

Stratigraphic name table edits.

 

If you press the 'Esc' key you will be presented with the same screen that you started with when entering the Stratigraphic Code table. This will allow you to change the range of codes to something other than "Jubilee" to "Kaslo".

There is another type of screen that is used for maintaining code tables. It is used for the Ore Zones code table and some of the static code tables. When you choose the Ore Zone code table, you will be presented with the following screen:

 

Ore zone code table edit.

 

First, pick the code that you would like to change, or delete.

To change the code that you selected, simply overtype the description field and press the control and end keys simultaneously.

To delete your selection overtype the Ore Zone Code field with blanks and press the control and end keys simultaneously.

To insert a new code press the page down key and you will be presented with a blank screen. Fill the screen in with the code and description that you wish to add and press the control and end keys simultaneously.

 

HINT: Make sure that the Ore Zone code does not already exist.

 

2. Static Code Tables

This screen contains tables that do not change very often. The tables are listed on the screen below:

 

Static Code Tables.

 

For maintaining the static code tables refer to the sections on maintaining the dynamic tables. The following tables behave like the Ore Zone table: Status Types, NTS Mapsheets, BC Mapsheets, Mining Divisions, Deposit Types and Project Types. The rest of the static tables behave like the Commodities table.

 

C. User Maintenance

 

This choice appears under Code Table Maintenance for users with the highest security (level 1) and under the Main System menu for users with complete access (level 2 security). Levels 3 and 4 do not have access to User Maintenance.

This function is for updating the list of users that can access the system, and what level of authority each user is to have. The only entry that exists in the User Maintenance table when you first install the system is: User = NEW, Password = NEW. This ID has Level 2 access to the system (security levels are described below). The User Definition table is shown on the following screen in the initial log-on state:

 

User Maintenance.

 

You will need to add ID's for your system users, then delete the "NEW" user ID. To do this, choose the "NEW" user and press the enter key. The following screen will appear:

To insert a new user, press the page down button. You will be presented with a blank screen to fill in with the information you wish. To save the new information press the 'Ctrl' and 'End' keys simultaneously.

Once you have set up another ID with User Maint. = 'T', delete the "NEW" ID by deleting the first field and then press the 'Ctrl' and 'End' keys simultaneously. To leave User Maintenance press 'Esc'.

 

IMPORTANT: First create an ID with User Maint = 'T' or you will not be able to sign on and access this table.

 

D. Levels of Security

 

1. Level 1 - Central Database Manager

USER ID, USER PASSWORD, USER MAINTENANCE=T, CODE TABLE MAINTENANCE =ON

Has full access to:

 

  • MINFILE and Exploration Searches
  • MINFILE and Exploration Reports
  • MINFILE and Exploration Utilities
  • MINFILE and Exploration Data Entry
  • Code Table Maintenance which includes User Maintenance.

2. Level 2 - Site Database Manager

USER ID, USER PASSWORD, USER MAINTENANCE=T, CODE TABLE MAINTENANCE=OFF

Has full access to:

 

  • MINFILE and Exploration Searches
  • MINFILE and Exploration Reports
  • MINFILE and Exploration Utilities
  • MINFILE and Exploration Data Entry
  • User Maintenance.

3. Level 3 - Update Privileges

USER ID, USER PASSWORD, USER MAINTENANCE=F, CODE TABLE MAINTENANCE =OFF

Has full access to:

 

  • MINFILE and Exploration Searches
  • MINFILE and Exploration Reports
  • MINFILE and Exploration Utilities
  • MINFILE and Exploration Data Entry.

4. Level 4 - MINFILE Access, No Update Privileges

NO ID, NO PASSWORD

Has full access to:

 

MINFILE Searches

Has partial access to:

 

  • MINFILE Reports
  • MINFILE Utilities
  • MINFILE Data Entry, Browse Mode only.

No access to:

 

  • Exploration Reports or Confidential Notes
  • Utilities that can modify the MINFILE data
  • Exploration Utilities
  • Exploration Data Entry.