Course Requirements Mass Additions

Course Requirement Mass Addition Template

Position Header Name 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 SequenceNo No   Must Be a Numeric Value.
9 RequirementType No   Validated against the XX_COURSEREQTYPE lookup value.
10 RequirementCode No   Required for Each Requirement. Must be 40 Characters or Less.
11 RequirementName No   Required for Each Requirement. Must be 1024 Characters or Less.
12 RequirementDesc Yes   Must be 256 Characters or less.
13 Attribute1 Yes   Must be 128 Characters or less.
14 Attribute2 Yes   Must be 128 Characters or less.
15 Attribute3 Yes   Must be 128 Characters or less.
16 Attribute4 Yes   Must be 128 Characters or less.
17 Attribute5 Yes   Must be 128 Characters or less.
18 Attribute6 Yes   Must be 128 Characters or less.
19 Attribute7 Yes   Must be 128 Characters or less.
20 Attribute8 Yes   Must be 128 Characters or less.
21 Attribute9 Yes   Must be 128 Characters or less.
22 Attribute10 Yes   Must be 128 Characters or less.
23 ActiveFlag No Yes or No Validated against the ZZ_YESNO lookup value. Must be 128 Characters or less.
24 DefaultCompletionStatus Yes Complete or Incomplete If this value is passed empty, it will pull the default attribute1 value from the XX_DEFCRSREQCOMPLETIONSTATUS system parameter.
Validated against the XX_COMPLETIONSTATUS lookup values.
25 CourseCompletionTransfer Yes Yes or No If this value is passed empty, it will be defaulted to No.
Must be 128 Characters or Less.
Validated agains the ZZ_YESNO lookup values.
26 PreserveCourseCompletion Yes Yes or No If this value is passed empty, it will be defaulted to No.
Must be 128 Characters or Less.
Validated agains the ZZ_YESNO lookup values.
Related Topics
Course Requirement Definition
Maintaining Course Requirements