Stored Procedures for Form-Type Web Pages

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