Table Views

Table views display information stored in the PT application's SQL Server database. Users can edit some of this data depending on their permissions. Table views will be implemented in BDG Scenario 4, and that scenario will discuss how SQL Server enforces this feature for each table.

Note  Because administrators do not use table views, these views are not available through the PT Admin application. An administrator will be able to view a table through the PT User application by logging on as an auditor or evaluator.

Because the PT User application is not implemented in this scenario, this section presents only high-level information about table views. The following list summarizes the content of each table view, which is drawn from tables in the PT application database:

• Group Performance Summary. Rows display individuals and columns display activities. This view answers the question, "How are the members of this group doing in their activities?"
• Individual Performance Record. Rows display activities and columns display activity attributes. This view answers the question, "How is this person doing in his or her activities in this group?"
• Group Performance Record. Rows display individuals and columns display activity attributes. This view answers the question, "How are the members of this group doing in this activity?"
• Activity Planner. Rows display activities and columns display activity attributes. This view shows the details about all the activities assigned to one group, but contains no data on individuals' accomplishments.