|
Objects |
New |
Description |
|
SQL Tables |
|
|
|
Announcement_types |
No |
Control list of announcement types (e.g. public, private) |
|
Announcements |
No |
List of announcements. |
|
Attendance |
Yes |
List of attendance by member, date, shift |
|
Attendance_ActionLog |
Yes |
Log of proposed revisions (Deletes, Inserts, Updates) to Attendance table. Cleared/Produced by ActionLog_review page. Processed by ActionLog_post page/spActionLog_Post/spActionLog_Clear. |
|
Calendar |
No |
List of calendar events |
|
Images |
No |
List of images (titles, file name/locations) |
|
Member_types |
No |
Control list of member types (e.g. User, Admin) |
|
MemberCategories |
Yes |
Control list of member categories (NSP reg category, ASP shift function) |
|
MemberNspCertsCourses |
Yes |
List, by member, of NSP Certifications and/or Courses taken. |
|
MemberOrganizationAwards |
Yes |
List, by member, of organization awards received |
|
MemberOrganizationAwards_ActionLog |
Yes |
Log of proposed revisions (Deletes, Inserts, Updates) to MemberOrganizationAwards table. Cleared/Produced by ActionLog_review page. Processed by ActionLog_post page/spActionLog_Post/spActionLog_Clear. |
|
MemberOrganizationPositions |
Yes |
List, by member, of organization positions held |
|
MemberOrganizationPostions_ActionLog |
Yes |
Log of proposed revisions (Deletes, Inserts, Updates) to MemberOrganizationPositions table. Cleared/Produced by ActionLog_review page. Processed by ActionLog_post page/spActionLog_Post/spActionLog_Clear. |
|
MemberOrganizations |
Yes |
List, by member, of organization membership |
|
MemberRefresherProcess |
Yes |
List of refresher process information by member |
|
MemberRefresherProcess_ActionLog |
Yes |
Log of proposed revisions (Deletes, Inserts, Updates) to MemberRefresherProcess table. Cleared/Produced by ActionLog_review page. Processed by ActionLog_post page/spActionLog_Post/spActionLog_Clear. |
|
MemberRegistrationProcess |
Yes |
List of registration process information by member |
|
MemberRegistrationProcess_ActionLog |
Yes |
Log of proposed revisions (Deletes, Inserts, Updates) to MemberRegistrationProcess table |
|
Members |
No |
List of members with demographics |
|
MemberStati |
Yes |
Control list of member stati (e.g. Active, Inactive) |
|
NSP_Download |
Yes |
Import of patrol member information download from NSP |
|
NspCertsCourses |
Yes |
Control list of NSP Certifications and Courses (dictionary of NSP_Download field names) |
|
OrganizationAwards |
Yes |
Control list of organization awards (e.g. NSP Yellow Merit Sta) |
|
OrganizationPositions |
Yes |
Control list of organization positions (e.g. ASP Patrol Director) |
|
Organizations |
Yes |
Control list of organizations (e.g. ASP-Alpental Ski Patrol) |
|
Schedule |
No |
|
|
Seasons |
Yes |
List of seasons (e.g. 2009-2010) with associated control information |
|
Shift_exchange |
No |
List of shift exchanged information (documents shift exchange process) |
|
Shifts |
No |
List of shifts (e.g. Fri Night, Sat, etc.) |
|
Team_colors |
No |
List of team color id’s and names (e.g. Blue, Green, etc.) |
|
SQL Views |
|
|
|
vAttendance_CurrentSeason |
Yes |
Returns member attendance detail for a selected season |
|
vAttendanceShifts_NoMembers |
Yes |
Returns totals by member function (e.g. Patroller, Auxiliary) for a selected date/shift |
|
vMember_IsAwardsCoordinator |
Yes |
Return Count>0 for member id if member is currently an Awards Coordinator |
|
vMember_IsPatrolAdmin |
Yes |
Returns Count>0 for member id if member is currently in a Patrol Admin position (e.g. PD, APD, DPL, etc.) |
|
vMemberFcts |
Yes |
Returns list of ASP shift functions from MemberCategories |
|
vMemberProfiles |
Yes |
Returns Member Profile information by member |
|
vMemberRefresherProcess |
Yes |
Returns Refresher Process information by member |
|
vMemberRegistrationProcess |
Yes |
Returns Registration Process information by member |
|
vMembers_ExportSelection |
Yes |
Returns names of columns, from vMemberProfiles, available for export. |
|
vMembers_ExportSelection |
Yes |
Returns names of columns, from vMemberProfiles, available for export. |
|
SQL Stored Procedures |
|
|
|
spActionLog_Clear |
Yes |
“Clears” entries in a specified action log |
|
spActionLog_Post |
Yes |
"Posts" entries from a specified action log into the associated data table, then “clears” the action log. |
|
spAttendance_SeasonHistory |
Yes |
Returns a three(3) season summary of attendance for selected members. |
|
spMemberCertsCourses_NspDownload |
Yes |
Load NSP Certifications and Courses from NSP_Download into MemberNspCertsCourses |
|
spMemberRegistrationRefresherProcess_Initialization |
Yes |
Initializes the MemberRegistrationProcess and MemberRefresherProcess tables for a new season. MemberRegistrationProcess.MemberId=0 record contains NextSeason in Notes. If NextSeason does not exist or is not equal to CurrentSeason in Seasons, then a full initialization occurs. Otherwise an initialization addressing only candiates will occur. |
|
spSeason_CalcTotalShifts |
Yes |
Calculates total regular shifts in a season based upon min and max attendance shifts for season, after optionally determining the max shift, and/or min shift for the season. -Note shift_id > 0 for a regular shift. |
|
spSeasons_SetAttendanceToDate |
Yes |
Sets the maximum shift for the current season, i.e. establishes Attendance To(through) Date, and calculates the total shifts to date for the current season for regular shifts (i.e. 1-4) |
|
|
|
|