Maintaining Staff Accounts

Overview

Staff accounts are used in CCLAS EL applications to identify the account manager for a client, the staff member registering a job or for whom quality control history is requested, audit actions carried out by staff members, and for auditing a job.

When CCLAS EL is first installed, the default staff account supplied is CCLASMGR. The username and password is CCLASMGR, CCLASMGR. Use this to log in for the first time, and then change the password to maintain security. The CCLASMGR staff code has an access level of 3 for all CCLAS database tables, which means that this staff member has the ability to view, create and delete staff members from the STAFF table. This staff account cannot be deleted.

Passwords are applied to staff accounts to secure the system. Where a staff account is configured with a required password, then the staff member must log into CCLAS EL with a valid password. Various expiry and password policy rules are applied to control password use.

Program settings configure the environment and the way in which applications run.

This process is pertinent to LIMS configuration personnel and laboratory managers who configure user accounts for CCLAS EL.

Process

Staff accounts for CCLASMGR and general users are maintained under the Staff codes node of the Staff application.

The AccessLevel STAFFAPP program setting controls user access to the Staff application, and the AccessLevel STAFF program setting controls user access to the Staff codes node.

Staff accounts are maintained using simple SCRUD (search, create, review, update, delete) functionality. Extra staff details are entered using the StaffUser.SCR script. This option is not available if this file does not exist in the folder defined by the ConfigDirectory GLOBAL setting. The default script that is installed with CCLAS contains controls that are used to select various colour themes for CCLAS screens or change the individual colours defined by the FormBackColour, InputBackColour, InputForeColour, LabelBackColour and LabelForeColour CCLAS program settings.

Maintain staff accounts

Defining a staff account involves the optional configuration of a password and linking the staff account to a role.

  • Flags indicates whether a password is required to log into CCLAS, whether a password must be changed periodically (and the number of days defined), whether the account is disabled, and whether the account is disabled upon password expiry.
  • Where a password is expired, then the staff member is forced to enter a new and valid password upon log into CCLAS. Where a staff account is configured with automatic lock upon password expiry, then a staff member cannot log into CCLAS until the staff account is enabled again by the staff account administrator.
  • The staff account administrator can clear a staff account password, forcing the staff member to assign a new and valid password upon log into CCLAS. Refer to Password requirements.
  • A staff account is associated with a staff role so that, upon staff member login, then any program setting that is not defined at the individual staff account level is inherited from the staff role.
  • If the staff role does not have the program setting defined, it is inherited from the CCLASMGR staff account. If a staff account is not linked to a staff role, then any setting that is absent is directly inherited from the CCLASMGR staff account (that is, staff role definitions are optional).
  • Access levels for individual staff members are also inherited from the staff role. If the individual staff account has an access level of -1, then this implies that the access level for that particular application or function is inherited from their staff role.
    The CCLASMGR staff account is automatically treated as a staff role.

The StaffScreenn STAFF program settings define the custom forms that are launched from the Run main menu option, which is only available where the user has access to the Staff codes node.

Access a custom form from the Staff Codes node

Staff program settings

Staff program settings exist under each staff account (including accounts flagged as a role), and are grouped by program setting node for each CCLAS application and table (sub-application, or node within the application).

All program settings are initially stored against the GLOBAL laboratory code for the CCLASMGR staff account. After a CCLAS EL update or upgrade, new global settings supplied with the new version of software should be updated for the CCLASMGR staff account under other laboratory codes. The list of program settings for CCLASMGR are considered the complete set used by CCLAS.

Program settings either apply globally across CCLAS, or apply to individual CCLAS applications or tables. Global and program settings are NOT case-sensitive.

  • Global settings - Settings that apply across all CCLAS EL applications. These settings are stored under the CCLASMGR staff account. All staff accounts use these settings. They cannot be overridden by individual staff accounts. A site can have user global settings defined. Custom global settings can be defined and are called user global settings.
    Changes to global settings do not have an impact until user next logs into CCLAS EL. Changes to program settings are available when the specific application is next started.
  • Program settings - Settings that apply to individual CCLAS EL applications, or for nodes within a program. These settings are stored under the CCLASMGR staff account. Where a program setting is defined for a staff account, this setting overrides that set on the CCLASMGR staff account. Where a program setting is defined for a staff role, for a user that does not have the staff setting defined for their account, but the user has the staff role, then this setting overrides that set on the CCLASMGR staff account. Custom program settings can be defined and are called user settings.

Program settings are essentially stored as string values, however, to assist with their maintenance, the STAFFPROGRAMEDIT table does two things: 1) links a program setting to a LOOKUPTABLE or FORMLIST allowing for selection of the value, where applicable, and 2) links a program settings to a specific FORMTYPE and ENTRYTYPE so that a data-type-aware form is presented for value entry. Note that there is no user interface to maintain the STAFFPROGRAMEDIT table; it is supplied at installation as is, to support core program settings.

FORMTYPE ENTRYTYPE Presented entry

Example

NULL or blank NULL or blank String field LIBMANSCHEME>QueryEvent=cmdQuery_Click
BOOLEAN NULL or blank Check box

CCLAS>AllowToggle=DISABLED

BROWSER NULL or blank

Column name, from the defined LOOKUPTABLE, column width, column heading, and format (where applicable). For a data type of:

  • String—The '<' character forces display of the data in lower case, and the '>' characters forces display of the data in upper case.
  • Numeric—A valid Visual Basic format picture forces entry of data in that format, for example, 0.000, $0.000.
  • Date (Day, Month, Year, Era)—An exclamation mark (!) followed by a valid Visual Basic format picture forces entry of data in that format, for example, !dd/mm/yy.
  • Boolean—Data is displayed as Yes or No instead of 1 or 0, or True or False.
PROFILE>SampleGridSchCodeDisplayColumn=S.SCHEMENAME,10,Scheme name
COLOUR NULL or blank Colour picker  
DIR NULL or blank Common dialog to locate a folder. GLOBALSETTINGS>ExeDirectory=C:\CCLASEL\EXE\
DIR ENVIRONVAR Common dialog to locate a folder, allowing for the use of CCLAS environment variables in the URL.  
DUALLIST NULL or blank Two lists: available items, selected items

LAB>LabClientLookupColumns=LABCODE,CLI_CODE,CLI_NAME,STATE,COUNTRY

FILE NULL or blank Common dialog to locate a file. MDE>AutoRunAfterLoad=AutoRunAfterLoad.VBS
FILE ENVIRONVAR Common dialog to locate a file, allowing for the use of CCLAS environment variables in the URL. TASKMAN>EventLogfile=%CCLASRootDirectory%BIN\TASKMAN.LOG
FILEDESC NULL or blank Text description of a file.  
LIST NULL or blank Item selected from a list, from the lookup list, where defined BATCH>DateField=REGISTERED
MULTILINE NULL or blank Multi-line text REPORT>EmailNotesText=Dear Sir/Madam Attached is the report for our Job ~PRO_JOB~,your order ~ORDERNO~ Regards
MULTILIST NULL or blank Multi-line list, one item per row GLOBALSETTINGS>AuditInitialAnalyteStatus=QFH,QFL,QFT,CHK
NUMERIC NULL or blank Real number STATPC>HistogramIntervalWidth=-1
NUMERIC LONG Integer number TASKMAN>CompletionSleepInterval=50
TEXTUC NULL or blank   GLOBALSETTINGS>BaseCurrency=AUD