Used to store GUI preference information. The Web MV GUI client application allows the user to select which columns of information to display, the overall size of the message display window, and many other configuration options. These preferences are stored on a per-user, per-session basis. For example, user "A" may only wish to see a selected subset of information for messages captured from session "B". Since this table is only used to store GUI preference information, it has no relation to either of the other tables contained within the Web MV database.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| session_nm | varchar(16) | not null | This field contains the name of the Automation Point session which, in combination with the login user name, is used to determine which GUI configuration set should be used for the GUI client. |
| ap_host | varchar(16) | not null | This field will hold the computer name of the Automation Point workstation from which the message originated. |
| usr_nm | varchar(49) | not null | This field contains the Web MV login name of the user for whom the current GUI configuration options apply. |
| session_commands | varchar(8288) | not null | This attribute will hold a two-dimensional array of a history of session commands entered to this session. There is a maximum of 32 commands each with a maximum of 258 characters. These commands will be tab deliminted as they are saved so they can be properly parsed when displayed. |
| frame_height | integer2 | not null | This defines the height of the Web Message Viewer application window for this session.. |
| frame_width | integer2 | not null | This defines the width of the Web Message Viewer application window for this session. |
| dt_format | varchar(32) | not null | This defines the date format. |
| tm_format | varchar(32) | not null | This defines the time format. |
| action_back_color | integer | not null | The background color of the action message area. |
| action_selected_fore_color | integer | not null | This defines the foreground color of a selected action message. |
| action_selected_back_color | integer | not null | This defines the background color of a selected action message. |
| normal_back_color | integer | not null | The background color of the normal message area. |
| normal_selected_fore_color | integer | not null | This defines the foreground color of a selected normal message. |
| normal_selected_back_color | integer | not null | This defines the background color of a selected normal message. |
| color_map | varchar(160) | not null | This maps the colors of the messages as they come from AP to Webmv colors. This attribute will be converted into a 16 element array of long integers. |
| action_font_nm | varchar(32) | not null | This defines the font of the messages in the action message area. |
| action_font_style | integer2 | not null | This defines the style for the font of the messages in the action message area. |
| action_font_size | integer2 | not null | This defines the size for the font of the messages in the action message area. |
| normal_font_nm | varchar(32) | not null | This defines the font of the messages in the normal message area. |
| normal_font_style | integer2 | not null | This defines the style for the font of the messages in the normal message area. |
| normal_font_size | integer2 | not null | This defines the size for the font of the messages in the normal message area. |
| column_names | varchar(660) | not null | This attribute will hold a two-dimensional array of column names to be displayed. There is a maximum of 20 columns each able to hold a new with a maximum of 32 characters. |
| column_widths | varchar(200) | not null | This will hold an array of values that contain the widths of each column to be displayed. This attribute will be converted into a 20 element array of integers when retrieved from database. |
| divider_location | integer | not null | This defines where the divider line is placed in the window. It divides the action message area with the normal message area. |
| messages_per_bundle | integer2 | not null | This defines how many messages are to be sent from the database when the user requests a scroll forward/back. Currently this is set to 100 and is not user configurable. |
Product Name: Unicenter Automation Point
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| session_nm ap_host |