Terms, 13 (ver3.6.1)
Term related information used for the school such as Semester, Full Year, etc.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Abbreviation | 3.6.1 | Varchar(6) | The shorter name for the term. This will be the most familiar. Like S1. |
Attendance_Calculation_Code | 3.6.1 | Number(10,0) | Indicates whether positive or negative attendance is used in this term. Valid values: 1=Negative, 2=Positive. Defaults to 1. |
AutoBuildBin | 3.6.1 | Number(10,0) | Used when copying the master schedule. |
Days_Per_Cycle | 3.6.1 | Number(10,0) | Number of days for a Cycle for this term. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
FirstDay | 3.6.1 | Date | The first day of the term. Indexed. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ImportMap | 3.6.1 | Varchar(20) | If importing what code will relate to this term. |
IsYearRec | 3.6.1 | Number(10,0) | A flag indicating if this record is the yearlong term. 1=yes 0=no |
LastDay | 3.6.1 | Date | The last day of the term. |
Name | 3.6.1 | Varchar(30) | The common name for this term. Like Semester 1 |
NoOfDays | 3.6.1 | Number(10,0) | Calculated number of days between the dates that have school in session. |
Periods_Per_Day | 3.6.1 | Number(10,0) | Number of periods in a school day for this term. |
Portion | 3.6.1 | Number(10,0) | The fraction of a year the term takes. A Semester is 1/2 a quarter 1/4. Internally only the denominator, the bottom part of the fraction, is stored. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
STerms | 3.6.1 | Number(10,0) | Number of scheduling terms in a school year. |
SuppressPublicView | 12.0.1.0 | Number(10,0) | A flag indicating if sections that meet for this term should be shown in the Public Portal and Mobile App. 1 = suppressed, 0 = not suppressed |
TermInfo_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
TermsInYear | 3.6.1 | Number(10,0) | The number of terms this particular term takes up when looking at the LCM. For example a school with quarters, trimesters, and semesters would have an LCM of 12 so one semester would take up 6 terms while a trimester would take up 4 and the quarter would take up 3 even though the shortest term is a quarter. This field is used in the scheduling engine. |
YearID | 3.6.1 | 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. Indexed. |
YearlyCreditHrs | 3.6.1 | Float | No longer used by the application.This field may still be referenced on reports and/or custom pages. |