Courses

A course is an activity that people participate in at camp. Courses are held at different times throughout the day. They can also be restricted by age, gender, grade, and year-at-camp. These restrictions allow a camp administrator to remove certain courses from the unit users registration window. For example, Girls Soccer would have a gender restriction of female only.

Validations | Definitions | Prerequisites | Add Courses | Edit Courses
Navigation
  • Camp Admin > Courses
Validations
  • The camp selected on the course record must be associated to the organization.
  • The department select on the course must be associated to the camp and organization.
  • End Time must be greater than Begin Time
  • Grade Low must be less than or equal to Grade High
  • Age Low must be less than or equal to Age High
  • The Course Number must be unique within a given camp and organization.

Back To Top
Course Definition
Course Attribute Definition
CourseID Unique Identifier of the course record.
CourseNo Unique number for course registration within a camp and organization.
CourseName Name of the course. For example, Swimming, Tennis, Cycling
CourseDesc Course Description
OrganizationID Organization ID that the course is associated with.
CampID Camp ID that the course is associated with.
DepartmentID Department ID that the course is associated with.
StartTime The start time of the course.
EndTime The end time of the course.
Sun If this checkbox is checked, the course will be held on that day.
Mon If this checkbox is checked, the course will be held on that day.
Tues If this checkbox is checked, the course will be held on that day.
Wed If this checkbox is checked, the course will be held on that day.
Thur If this checkbox is checked, the course will be held on that day.
Fri If this checkbox is checked, the course will be held on that day.
Sat If this checkbox is checked, the course will be held on that day.
Sun If this checkbox is checked, the course will be held on that day.
MaxSize If the Enforce Max Size checkbox is check, the course registration will be capped at this number.  Validated against the XX_COURSEMAXSIZE lookup value.
EnforceMaxSize If this checkbox is checked, the max size field will be evaluated by the registration engine.
InstructorFullName Instructor's full name.  It is used to default the instructor to the event course relationship record.
InstructorPersonID Instructor's Person ID.  It is used to default the instructor to the event course relationship record.
GradeLow This is used to restrict the course by grade.  For example, a person must have completed the 5th grade.  Default value is zero.  The registration engine will not evaluate this attribute when it's zero.  Validated against the XX_COURSEGRADELOW lookup value.
GradeHigh This is used to restrict the course by grade.  For example, a person must be below the 10th grade.  Default value is ninety-nine.  The registration engine will not evaluate this attribute when it's ninety-nine.  Validated against the XX_COURSEGRADEHIGH lookup value.
AgeLow This is used to restrict the course by age.  For example, a person must be atleast 10.  Default value is zero.  The registration engine will not evaluate this attribute when it's zero.  Validated against the XX_COURSEAGELOW lookup value.
AgeHigh This is used to restrict the course by age.  For example, a person must be 17 or less.  Default value is ninety-nine.  The registration engine will not evaluate this attribute when it's ninety-nine. Validated against the XX_COURSEAGEHIGH lookup value.
YearAtCamp This is used to restrict the course by years attending camp.  For example, a person must be a thrid year camp in order to register for this course.  Default value is one because everyone is atleast a first year camper. Validated against the XX_COURSEYEARATCAMP lookup value.
Gender This is used to restrict the course by gender.  For example, girls soccer or boys swimming.  Validated against the XX_COURSEGENDER lookup value.
AllowDuplicateRegistration When set to Yes, the registration engine will allow duplicate registration based on course name.  For example, if you have a course called "Free Swim" and you offer this course in the morning and afternoon as two unique courses.  When this attribute is set to Yes, a person wll be allowed to register for both periods.  Validated against the ZZ_YESNO lookup value.
ValidateStoredProcedure Currently Not Used  Validated against the ZZ_YESNO lookup value.
Attribute1 User Defined Attribute
Attribute2 User Defined Attribute
Attribute3 User Defined Attribute
Attribute4 User Defined Attribute
Attribute5 User Defined Attribute
Attribute6 User Defined Attribute
Attribute7 User Defined Attribute
Attribute8 User Defined Attribute
Attribute9 User Defined Attribute
Attribute10 User Defined Attribute
ActiveFlag Activates or inactivates the course record. List validates against the ZZ_YESNO lookups values.
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.
Rank This is used to restrict registration by a rank structure.  It uses a hierarchy from the XX_COUSERANK lookup to restrict courses by rank.
DefaultLocationID LocationID for a location.  It is used to default the location to the event course relationship record.
DefaultAreaID AreaID for a location.  It is used to default the area to the event course relationship record.
TransferIn The item is used for course completion.  It identifies if the specific course will be transferred to course completion in summary or detail.  Summary identiifies that only the course information will be used for completion.  Detail means individual course requirements will be used for completion.  N/A means this course will not transfer to completion.

Back To Top
Prerequisites

Back To Top
Adding a Course - Webpages
  • Courses can be added by using the web pages. However, it is recommended for small volumes. The Mass Addition templates save a lot of time when entering multiple courses.
  • Navigation: Camp Admin - Courses
  • Select an organization, camp, and department.
  • Enter a unique course number and a course name.
  • Optionally, enter a course descripton.
  • Select begin and end times from the drop down lists.
  • Check the days of week that the course is being offered.
  • Optionally, set course restrictions such as max size or age.
Adding Courses - Mass Addition
  • A mass addition is a bulk import from a comma delimited file. Please review the Mass Addition notes before working with these files.
  • Download a course template from the Templates section.
  • Fill out appropriate data. Ensure Insert or Update column is set to INSERT.
  • Navigation: Camp Admin Menu Item - Mass Additions
  • Choose an Import Type of Course
  • Click the Choose File Button. Navigate to your CSV file.
  • Click Upload File.

Back To Top
Edit a course - Webpages
  • Courses can be edited using the webpages. However, it is recommended for small volumes. The Mass Addition templates save a lot of time when editing multiple records.
  • Navigation: Camp Admin - Courses
  • Select an organization, camp, and department.
  • Select the course that needs editing.
  • Make the necessary changes and save the record.
  • You should see a message that the file uploaded successfully.
  • It is recommended that you select Validate file first! This will run through the file without loading it and provide any errors, which should be resolved before the file is actually loaded.
  • Click the Process File Button
  • Each record will either be successfully processed or will display an error.
  • Resolve any errors, upload the file again, and validate again. Repeat until all errors are resolved.
  • Once all errors have been resolved, upload the file again, choose Load File, and click the Process File Button.
  • You should receive a success message for each record as it is inserted.
  • If any errors are found, address the errors and be sure to load the errors only in your next upload.
Editing a Course - Mass Additions
  • A mass addition is a bulk import from a comma delimited file. Please review the Mass Addition notes before working with these files.
  • Download a course template from the Templates section.
  • Fill out appropriate data. Ensure Insert or Update column is set to UPDATE.
  • Navigation: Camp Admin Menu Item - Mass Additions
  • Choose an Import Type of Course
  • Click the Choose File Button. Navigate to your CSV file.
  • Click Upload File.
  • You should see a message that the file uploaded successfully.
  • It is recommended that you select Validate file first! This will run through the file without loading it and provide any errors, which should be resolved before the file is actually loaded.
  • Click the Process File Button
  • Each record will either be successfully processed or will display an error.
  • Resolve any errors, upload the file again, and validate again. Repeat until all errors are resolved.
  • Once all errors have been resolved, upload the file again, choose Load File, and click the Process File Button.
  • You should receive a success message for each record as it is updated.
  • If any errors are found, address the errors and be sure to load the errors only in your next upload.

Back To Top
Related Topics
Course Mass Addition Information
Templates