StandardCourseAssoc (ver9.0.0)
This table is used to associate a standard to a course in a specific year. When the End of Year (EOY) process is run, a new set of standard course associations are created to retain the history of standards course associations for previous years. This association record also contains several grade calculation settings pertinent to a particular standard, course, year association such as calculation weight for final course grades, and whether the standard is calculated automatically by lower level standards.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 9.0.0 | Number(10,0) | Foreign Key. An internal identifier, DCID, of the associated course record. Indexed. Required. |
IsActive | 9.0.0 | Number(1,0) | 1 indicates the standard is available for teachers to enter in standards grades. |
IsCalcByLowerStandard | 9.0.0 | Number(1,0) | Indicates whether the higher level standard is calculated by the lower level standards. Valid values: 0 = No, 1 = Yes. Defaults to 1. Required. |
IsPrimary | 9.0.0 | Number(1,0) | Indicates whether this standard is a primary standard for a course. In PowerSchool 9.x, all standards assigned to courses are considered primary. Valid values: 0 = No, 1 = Yes. Defaults to 1. Required. |
StandardCourseAssocID | 9.0.0 | Number(16,0) | Primary Key. Unique sequential number generated by the application. Indexed. Required. |
StandardID | 9.0.0 | Number(10,0) | Foreign Key. An internal identifier, of the associated Standard record. Indexed. Required. |
Weight | 9.0.0 | Number(6,0) | Defines the numerical weight associated with the standard. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |