DailyAttendance, 84 (ver3.6.1)
These are days of the week that can be set to see which periods meet for a calendar day.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbreviation | 3.6.1 | Varchar(3) | A short 1 or 2 character version of the Name, such as A. |
Day_Name | 3.6.1 | Varchar(30) | Name given for this day, such as A Day. |
Day_Number | 3.6.1 | Number(10,0) | Number assigned to this Day, such as 1. |
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. |
Letter | 3.6.1 | Varchar(2) | Similar to the abbreviation but just limited to a character. It is used in place of a missing abbreviation. |
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. |
SortOrder | 4.0.0 | Number(10,0) | Table sort order. Indexed. |
Year_ID | 3.6.1 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004, if not cumulative. See StoreCode. The number is equal to the ID of the year term divided by 100. |