The Activity Center interface has four main components to deliver the data to the end user: the Silverlight application running in the browser, the web services hosted on the SMP Server, the data access components that are part of SMP, and the SMP Database. Requests for data from the Silverlight application (browser) are sent to the Activity Center web services. The Activity Center web services connect to the SMP data components which interface with the database to execute either direct SQL or stored procedures. Once the data is compiled at the database, the result set is sent back through the SMP data component to the web services and finally back to the display on the Silverlight Application.
All data obtained and displayed for the Activity Center UI is stored in the SMP database. Although there are a number of SQL tables specific just to Activity Center, the data displayed to the end user comes through the SMP and/or ITMS solutions. Retrieving the data via SQL from the database can happen in one of three ways: First, there are a number for SQL stored procedures created specifically for Activity Center and those are referenced by procedures starting with "spAC_". Second, Activity Center does use a number of stored procedures from other ITMS solutions. Third, to narrow the result set based on user input, dynamic SQL is composed and sent directly to be executed.
Activity Center has implemented security-based roles related to Asset Management that provide control of activity in the management of Assets. This role-based security utilizes the standard SMP role-based setup and configuration. As with other SMP configurations, each solution defines the appropriate privileges and the SMP Core evaluates those privileges with the defined and assigned permissions to access data and resources. Another security implementation with Activity Center is the use of data scoping. This concept is also native to SMP and helps ensure that users only access the data intended for their job function or area. This data scoping is implemented within the SQL request methods that are mentioned above.