Integration Guide

Decemb
e
Appendix B Database Tables / Physical Properties
B.1 Table Name: PSS_Admin_Action
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Action_ID int NOT NULL Yes No
Description varchar(60) NULL No No
Privilege_Level int NULL No No
Disabled char(1) NULL No No
PSS Admin Action Table holds privilege information for various actions available through the
service terminal
Action_ID unique ID associated with this Administrative Action
Description description of this Administrative Action
Privilege_Level privilege level associated with this Administrative Action
Disabled indicates whether this Administrative Action is disabled or not
B.2 Table Name: PSS_Admin_Menu
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Menu_ID int NOT NULL Yes No
Menu_Title varchar(30) NULL No No
Show_System_Status char(1) NULL No No
Show_Title char(1) NULL No No
Show_Image char(1) NULL No No
Show_Status_Line char(1) NULL No No
Authenticated char(1) NULL No No
Disabled char(1) NULL No No
Parent_Menu_ID int NULL No No
Target_Page_Name varchar(40) NULL No No
Button_Columns int NULL No No
Special_Type int NULL No No
Refresh_Seconds int NULL No No
PSS Admin Menu Table holds configuration information for the service terminal menu system
Menu_ID unique ID associated with this Administrative Menu entry
Menu_Title title of this Administrative Menu entry
Show_System_Status indicates whether the system status displays on this Administrative Menu
page or not
Show_Title indicates whether the menu title displays on this Administrative Menu page or not
Show_Image indicates whether the PSS menu image displays on this Administrative Menu
page or not
Show_Status_Line indicates whether the status line (showing copyright and current time)
displays on this Administrative Menu page or not