| Course_Id |
No |
Key Id Field |
"123" |
|
| Short_Course_Name |
No |
Text |
"MATH101" |
|
| Course_Name |
Yes |
Text |
"Algebra I" |
|
| Report_Card_Type |
No |
Datasource Data |
"3" |
Must be integer from 0 to 6. See Notes for additional information |
| Number_of_Semesters |
No |
Integer |
"2" |
1, 2, or 3 |
| Credits_Per_Semester |
No |
Decimal |
"0.5" |
|
| Include_in_GPA |
Yes |
Boolean |
"1" |
(1 = Yes, 0 = No) |
| GPA_Weight |
No |
Decimal |
"1.5" |
|
| Department_Id |
No |
Identifier |
"456" |
Must match an existing Department Id in the database |
| Include_on_Transcript |
Yes |
Boolean |
"1" |
(1 = Yes, 0 = No) |
| School_Id |
Yes |
Identifier |
"789" |
Must match an existing School Id. See School Division for more info. |
| Scheduling_Priority |
No |
Integer |
"3" |
In the master schedule builder, you can prioritize which courses to schedule first. |
| Default_Section_Capacity |
No |
Integer |
"30" |
|
| Transcript_Course_Name |
No |
Text |
"Algebra I" |
This is applicable if you want to show a different course name on the transcript. |
| grade_scale_max_points |
No |
Integer |
"10" |
|
| class_rank_type |
No |
Datasource Data |
"AP Only" |
Must match an existing class rank in the system |
| allow_parent_teacher_conf |
Yes |
Datasource Data |
"No" |
Must be either "Yes" or "No" |
| allow_self_comments_yes_no |
Yes |
Datasource Data |
"Yes" |
Must be either "Yes" or "No" |
| publish_in_online_directory |
No |
Boolean |
"0" |
0 or 1 |
| is_advisory_course |
No |
Boolean |
"0" |
0 or 1 |
| is_homeroom_course |
No |
Boolean |
"1" |
0 or 1 |
| department_name |
No |
Lookup |
"Mathematics" |
Must match an existing Department Name in the system |
| product_id |
No |
Identifier |
"123" |
Must match an existing Product Id in the system |
| product_name |
No |
Lookup |
"Advanced Math Package" |
Must match an existing Product Name in the system |
| permissible_gender |
No |
Datasource Data |
"Any" |
Used to limit online registration courses based on gender |
| min_birthdate |
No |
Date |
"2010/09/01" |
Used to limit online registration courses based on birthdate |
| max_birthdate |
No |
Date |
"2015/06/30" |
Used to limit online registration courses based on birthdate |
| min_grade_level_id |
No |
Identifier |
"456" |
Must match an existing Grade Level Id in the system. Used to limit online registration courses based on grade level. |
| min_grade_level_code |
No |
Lookup |
"06" |
Must match an existing Grade Level Code in the system. Used to limit online registration courses based on grade level. |
| max_grade_level_id |
No |
Identifier |
"789" |
Must match an existing Grade Level Id in the system. |
| max_grade_level_code |
No |
Lookup |
"08" |
Must match an existing Grade Level Code in the system. |
| bc_trax_grad_req |
No |
Boolean |
"0" |
|
| bc_trax_examinable_course |
No |
Boolean |
"1" |
|
| bc_trax_electronic_exam |
No |
Boolean |
"0" |
|
| bc_trax_course_code |
No |
Text |
"MATH10" |
|
| bc_trax_course_level |
No |
Text |
"10" |
|
| bc_trax_course_type |
No |
Text |
"Academic" |
|
| bc_trax_month |
No |
Text |
"June" |
|
| bc_trax_proc_spec_case |
No |
Text |
"None" |
|
| bc_trax_related_code |
No |
Text |
"MATH20" |
|
| bc_trax_related_level |
No |
Text |
"20" |
|
| bc_trax_to_write |
No |
Boolean |
"1" |
|
| bc_1701_course_type |
No |
Text |
"Core" |
|
| course_type_level_id |
No |
Identifier |
"123" |
Must match an existing Course Type Level Id in the system |
| lookup_course_type_level_id |
No |
Lookup |
"456" |
Must match an existing Course Type Level in the system |
| lookup_course_type |
No |
Lookup |
"Mathematics" |
Must match an existing Course Type in the system |
| lookup_course_level |
No |
Lookup |
"100" |
Must match an existing Course Level in the system |
| grade_book_template_id |
No |
Identifier |
"789" |
Must match an existing Grade Book Template Id in the system |
| lookup_grade_book_template_name |
No |
Lookup |
"Standard Grading" |
Must match an existing Grade Book Template Name in the system |