School_Course, 153 (ver4.0.0)
Stores course information specific to a school and school year. New in 4.0 but it will coexist with the current method of storing School Course Catalog in Schools.ActvCrsList.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alt_Course_Number | 4.0.0 | Varchar(40) | Alternative course number used by a school - migrated from custom field. |
Att_Mode_Code | 4.0.0 | Varchar(20) | Indexed. |
CourseID | 4.0.0 | Number(10,0) | The internal number for the Course with which this record is associated. Indexed. Required. |
CreatedBy | 4.0.0 | Varchar(40) | The user who created this record. |
CreatedDT | 4.0.0 | Date | The date when this record was created. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Exclude_State_Rpt_YN | 4.0.0 | Number(10,0) | Indicates whether or not to include this school course record in a state report - migrated from custom fields. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ModifiedBy | 4.0.0 | Varchar(40) | The user who has modified this record. |
ModifiedDT | 4.0.0 | Date | The date when this record was modified. |
SchoolCrseInfo_Guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
Status | 7.8.0 | Number(3) | 1 indicates the course is active. Required. Indexed. |
YearID | 4.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Required. Indexed. |