The form-type Web pages appear one record at a time and the PT application has six Web pages of this type. Form Views describes these pages in detail and includes an illustration of each page. The stored procedures that return these records are straightforward SELECT statements with input parameters. Stored Procedures for the PT Application describes the stored procedures the PT application implements. The following table lists the names of the Web pages, the Eval database tables that contribute information to the pages, and the input parameters. The input parameters indicate how records are selected in the tables.
Web page | Eval table | Input parameter |
---|---|---|
Activity | Activity, Location, Group | GroupId, ActivityId |
Activity Type | ActivityType | ActivityTypeId |
Grade Scale | GradeScale, Grade | GradeScaleId |
Group | Group, Location | GroupId |
Group Membership | Group, PersonGroup, Person | PersonId |
Location | Location | LocationId |
User Information | Person | PersonId |