STAFFPROGRAMEDIT Table

Contains form types and expected data format for staff member program settings.

Field Data Type Description

PROGRAMCODE

Variable string (40)

Code of the CCLAS program, for example, CLIENT.
Setting this to * indicates generic use across all programs.
The system determines the type of form to edit the program setting locating a record in this table by matching PROGRAMCODE and INIVARIABLE, and if not found, then uses a generic form.

INIVARIABLE

Variable string (40)

Valid name of an program setting, or a matching pattern. For example, match any program setting beginning with MainListViewColumn, EditnListViewColumn or SubnListViewColumn; match any program setting ending with Colour, Directory, FontBold, FontItalic and Width.

LOOKUPTABLE

Variable string (200)

CCLAS database table to look up. Only applicable where FORMTYPE is LIST.

FORMTYPE

Variable string (10)

Type of screen used when the program setting is updated:

  • BOOLEAN
  • BROWSER
  • COLOUR
  • DIR
  • FILE
  • FILEDESC
  • LIST
  • MULTILINE
  • NUMERIC
  • TEXTUC.

ENTRYTYPE

Variable string (10)

Type of data entered into the form:

  • ENVIRONVAR - Used where the FORMTYPE is DIR, FILE or FILEDESC. The system translates the current path back into <IMSDCC> directory path variables.
  • LONG - Used where the FORMTYPE is NUMERIC, to validate integer entry, otherwise, a real numeris is expected.

FORMLIST

Variable string (255)

Comma-separated list. Only applicable where FORMTYPE is LIST. Each item in the list is comprised of DisplayItem;ActualSavedItem.
Primary key

PROGRAMCODE + INIVARIABLE