Registration Information

The registration process is one of the key components of Summer Camp Systems. It provides flexibility for camp administrators to restrict registration to certain courses based on a given set of parameters. Registration occurs within the Unit User My Registrations menu. Camp users have the ability to register people for courses under the Camp User menu. Camp Users are allowed to bypass many of the course restrictions.

Navigation
  • Unit User - My Registrations
  • Camp User - Registration
Validations For Unit Users
  • Selects available courses based on active courses, active events,  and active event course relationships.  The event registration begin and end dates must be active based on current system time.
  • Validates person age low against the courses age low.  If the person's age is less than the course's age, the course will be ommitted from the registration list.  If the course age low is zero (0), the validation is skipped.
  • Validates person age high against the courses age high.  If the person's age is greater than the course's age, the course will be ommitted from the registratin list.  If the course age high is 99, the validation is skipped.
  • Validates person year-at-camp against the course year-at-camp. Seeded value for the person and course is one.  If the course's year at camp is greater than the person's year at camp, the course is ommitted from the registration list.
  • Validates person grade low against the course grade low.  If the person's grade is less than the course's grade, the course will be ommitted from the registration list.  If the course grade low is zero (0), the validation is skipped.
  • Validates person grade high against the course grade high.  If the person's grade is greater than the course's grade, the course will be ommitted from the registratin list.  If the course grade high is 99, the validation is skipped.
  • Validates person gender against the course gender.  If the course gender is set to N/A, the validation is skipped.
  • Selects active person registrations for a given organization, camp, and event.  The registration and course must be active.
  • If the available course number is equal to the registered course number, remove the record from the available course list.
  • If the avaialble course name is equal to the registered course name, and the course allow duplicate flag is no, remove the record from the available course list.
  • If the available course begin time is equal to the registered course begin time, the available course day of week flag is checked, and the registered course day of week flag is checked, remove the record from the available course list.
  • If the registered course end time is greater than the available course begin time and the registered course begin time is less than the available course begin time, and registered course day of week is checked, and avaialble course day of week is checked, remove the record from the available course list.
  • If the registered course begin time is greater than the available course begin time, and the registered course begin time is less than the available course end time, and the registered course day of week is checked, and the available course day of week is checked, remove the record from the available course list.
  • If the available course max size flag is checked and a count of active registration is greater than or equal to the available courses max size, remove the record from the available course list. 
  • Validates person rank against course rank.  If attribute3 of the XX_PERSONRANK is greater than or equal to the course rank's attribute3, the person will be able to register. 
  • An unit user can no longer delete courses once the registration period ends.
Validations for Camp Users
  • Camp users have ultimate control over the registration process. We know there are exceptions to most rules, so a camp user has the ability to register people in a course. The below validations mainly deal with time restrictions. The premise is that a person can't be two places at once. Otherwise, the camp user has control to put a person in a class.
  • If the available course number is equal to the registered course number, remove the record from the available course list.
  • If the available course begin time is equal to the registered course begin time, the available course day of week flag is checked, and the registered course day of week flag is checked, remove the record from the available course list.
  • If the registered course end time is greater than the available course begin time and the registered course begin time is less than the available course begin time, and registered course day of week is checked, and avaialble course day of week is checked, remove the record from the available course list.
  • If the registered course begin time is greater than the available course begin time, and the registered course begin time is less than the available course end time, and the registered course day of week is checked, and the available course day of week is checked, remove the record from the available course list.
  • If the available course max size flag is checked and a count of active registration is greater than or equal to the available courses max size, remove the record from the available course list.
  • An organization, camp, event, and course must be chosen from the drop down lists.
  • An active person must be selected.  The person must be assigned to both the organization and unit.
  • An active unit must be selected.  The unit must also have a valid unit event assignment.
Registration Definition
Registration Attribute Definition
RegistrationID Unique identifier for the record.
OrganizationID Organization of the transaction.
RegionID Region ID of the transaction.
RegionCode Region code of the transaction.
UnitID Unit ID of the transaction.
UnitCode Unit code of the transaction.
PersonID Person ID of the person registering.
PersonFullName Person Full Name
CampID Camp of the transaction.
DepartmentID Department of the transaction.
CourseID Course that the person is registering.
EventID Event of the transaction.
CourseRegisterNumber Sequential number of the registration transaction for a given organization, camp, event, and course.
ActiveFlag Active flag of the transaction.  When a registration is deleted from the applicaiton, it is not deleted from the database.  Only the active flag is set to No.
CreationDate The date the record was created.
CreatedBy The user that created the record.
LastUpdateDate The date the record was last updated.
LastUpdatedBy The user that last updated the record.
GroupID Future Use.
CompletionStatus The column indicates the status of the registration record for course completion transfer.
FulfillementStatus The column indicates the status of the registration record for fulfillment transfer.