Attendance_Code, 156 (ver4.0.0)
The attendance codes that a school set up are maintained in this table. These could be codes for when student is tardy, present, absent or whatever they prefer to relate to attendance.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alternate_Code | 4.0.0 | Varchar(7) | If there is an alternate code that can be used. Shows up on PowerTeacher and PowerGrade. |
Assignment_Filter_YN | 4.0.0 | Number(10,0) | Flag used to filter code options in PowerTeacher and PowerGrade. |
Att_Code | 4.0.0 | Varchar(7) | Attendance identifier set by school. Examples Tardy, Absent, etc. |
AttendanceCodeInfo_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
Calculate_ADA_YN | 4.0.0 | Number(10,0) | Attendance based on this code will be counted in ADA calculation. |
Calculate_ADM_YN | 4.0.0 | Number(10,0) | Certain codes can be set up to exclude membership, assumes all periods that days are marked with the same code. Examples are some religious holidays or etc. |
Course_Credit_Points | 4.0.0 | Float | Used in stored grade process to withhold course credit, not used in ADA or ADM. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 4.0.0 | CLOB | A description supplied for this attendance code. For example, TR could be for Tardy. |
ID | 4.0.0 | Number(10,0) | Sequential Number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
| Lock_Teacher_YN | 23.6.0 | Number(1) | Indicates whether the attendance code can be changed by a teacher. 0 = No, 1= Y. Default 1. |
Presence_Status_CD | 4.0.0 | Varchar(10) | Indicates whether this code translates to an Absent or Present. |
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 | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
SortOrder | 4.0.0 | Number(10,0) | Order codes are displayed in UI. |
Unused1 | 4.0.0 | Varchar(2) | Currently no used. |
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. Indexed. |