Course Mass Addition Information

Course Mass Addition Template

Position HeaderName Can Import Empty Suggested Values Notes
0 InsertOrUpdate No Insert or Update Use Insert to create a new record. Use Update to update an existing record. Header Row must begin with an asterisk (*).
1 OrganizationName Yes   Name of Organization. Currently Not Used by Loader. Added for future use.
2 OrganizationCode No   Validated against the Organization Code in Organization Table. Used to determine the organization ID for the course. Must be 40 Characters or less.
3 CampName Yes   Name of Camp. Currently Not Used By Loader. Added for future use.
4 CampCode No   Validated against the Camp Code from the Camp Table. Used to determine the camp ID for the course. Must be 40 Characters or less.
5 DepartmentName No   Validated against the Department Name in the Department Table. It is used to determine the department ID for the course. Must be 256 Characters or less.
6 CourseNo No   Validated against courses for a given camp and organization. Course Number must be unique for a given organization and camp. Must be 40 characters or less.
7 CourseName No   Name of the course. Must be 256 Characters or less.
8 StartTime No   Validates against Lookup Value XX_COURSEBEGINTIME. The begin time value must be a value store in this lookup.
9 EndTime No   Validates against Lookup Value XX_COURSEENDTIME. The end time value must be a value store in this lookup.
10 Mon Yes Yes or No Empty value is assumed to be No.
11 Tues Yes Yes or No Empty value is assumed to be No.
12 Wed Yes Yes or No Empty value is assumed to be No.
13 Thur Yes Yes or No Empty value is assumed to be No.
14 Fri Yes Yes or No Empty value is assumed to be No.
15 Sat Yes Yes or No Empty value is assumed to be No.
16 Sun Yes Yes or No Empty value is assumed to be No.
17 MaxSize Conditional   This field is required if the EnforceMaxSize field is set to Yes. It validates against Lookup Value XX_COURSEMAXSIZE.
18 EnforceMaxSize Yes   Empty value is assumed to be No.
19 InstructorFullName Yes   Full name of the instructor. Currently not used by loader. Added for future use.
20 InstructorPersonID Yes   Empty value is assumed to be No. If a value is provided, it must be an active person.
21 Grade Low No   Validates against lookup value XX_COURSEGRADELOW. Typically 0 is used when the course isn't restricted.
22 Grade High No   Validates against lookup value XX_COURSEGRADEHIGH. Typically 99 is used when the course isn't restricted.
23 Age Low No   Validates against lookup value XX_COURSEAGELOW. Typically 0 is used when the course isn't restricted.
24 Age High No   Validates against lookup value XX_COURSEAGEHIGH. Typically 99 is used when the course isn't restricted.
25 YearAtCamp No   Validates against lookup value XX_COURSEYEARATCAMP. Typically 1 is used when course isn't restricted.
26 Gender No Male, Female, N/A Validates against lookup value XX_PERSONGENDER. Must be 128 Characters or less.
27 AllowDuplicateRegistration Yes Yes or No If field provided empty, the loader assumes No. Validates against the ZZ_YESNO_NOFIRST lookup value. Must be 128 characters or less.
28 ValidateStoredProcedure Yes Yes or No If field provided empty, the loader assumes No. Validates against the ZZ_YESNO_NOFIRST lookup value. Must be 128 characters or less.
29 Attribute1 Yes   Must be 128 characters or less.
30 Attribute2 Yes   Must be 128 characters or less.
31 Attribute3 Yes   Must be 128 characters or less.
32 Attribute4 Yes   Must be 128 characters or less.
33 Attribute5 Yes   Must be 128 characters or less.
34 Attribute6 Yes   Must be 128 characters or less.
35 Attribute7 Yes   Must be 128 characters or less.
36 Attribute8 Yes   Must be 128 characters or less.
37 Attribute9 Yes   Must be 128 characters or less.
38 Attribute10 Yes   Must be 128 characters or less.
39 ActiveFlag No Yes or No If field provided empty, the loader assumes No. Validates against the ZZ_YESNO lookup value. Must be 128 characters or less.
40 CourseDesc Yes   Must be 256 characters or less.
41 Rank Yes   Validated against the XX_COURSERANK lookup values. Must be 128 Characters or less. If value is left empty, it is assumed to be N/A.
42 LocationName Yes   Must be 256 Characters or less. Validated against active locations.
43 AreaName Yes   Must be 256 Characters or less. Validated against active areas.
44 TransferIn Yes   Must be 128 characters or less.
If value is empty, it is assumed to be N/A.
Related Topics
Maintain Courses