Section_Meeting, 140 (ver3.6.1)
This table contains the individual separation of periods and days of the full Expression, such as 1-2(M) would have 2 rows one for 1(M) and one for 2(M).
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Cycle_Day_Letter | 3.6.1 | Varchar(2) | The letter corresponding to the Day part of the Expression: 1(M) = M. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Meeting | 3.6.1 | Varchar(7) | The individual day-period combination of an Expression, such as 1(M). Indexed. |
Period_Number | 3.6.1 | Number(10,0) | The period number corresponding to the Period part of the Expression: 1(M) = 1. Indexed. |
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. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
Year_ID | 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. |