Stored Procedures for Icon-Type Web Pages

The icon-type Web page appears after the user logs on to the PT User application's Web site. This page is the person's home page in the PT application and it contains icons that represent information the person has permission to access. The stored procedures that support the icon-type Web pages do not retrieve a great deal of information. The SQL statements return the count of how many groups the user belongs to and the names of the groups. An icon for each group appears on the Web page and the ToolTip text on the icon contains the name of the group. The following table lists the Eval database tables that contribute information to the icon-type Web page and the input parameters.