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.  | 
                                                
| 
                                                         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: 
  | 
                                                
| 
                                                         ENTRYTYPE  | 
                                                    
                                                         Variable string (10)  | 
                                                    
                                                         Type of data entered into the form: 
  | 
                                                
| 
                                                         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
