S_CA_DistrictAttByResidence_S (ver 17.9.0)
This table is a standalone table and stores District Attendance by Residence information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [DistrictAttendanceByResidence.unique_ID]. |
| SubDistrictID | 20.8.2.0 | Number(11,0) | Foreign key to the ID value of a CST_SubDistricts record. Will be null for users not enabling sub-districts. |
ClassExYrSpEd_4_6 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed 4th to 6th. Migrated from [DistrictAttendanceByResidence.A17]. |
ClassExYrSpEd_7_8 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed 7th to 8th. Migrated from [DistrictAttendanceByResidence.A18]. |
ClassExYrSpEd_9_12 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed 9th to 12th. Migrated from [DistrictAttendanceByResidence.A19]. |
ClassExYrSpEd_TK_3 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A16]. |
ClassExYrSpEd_Total | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed Total. Migrated from [DistrictAttendanceByResidence.A20]. |
ClassExYrSpEdNPS_4_6 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed NPS 4th to 6th. Migrated from [DistrictAttendanceByResidence.A37]. |
ClassExYrSpEdNPS_7_8 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed NPS 7th to 8th. Migrated from [DistrictAttendanceByResidence.A38]. |
ClassExYrSpEdNPS_9_12 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed NPS 9th to 12th. Migrated from [DistrictAttendanceByResidence.A39]. |
ClassExYrSpEdNPS_TK_3 | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed NPS TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A36]. |
ClassExYrSpEdNPS_Total | 17.9.0 | Number(25,10) | Class Ex Yr Special Ed NPS Total. Migrated from [DistrictAttendanceByResidence.A40]. |
ClassSpEdNPS_4_6 | 17.9.0 | Number(25,10) | Class Special Ed NPS 4th to 6th. Migrated from [DistrictAttendanceByResidence.A27]. |
ClassSpEdNPS_7_8 | 17.9.0 | Number(25,10) | Class Special Ed NPS 7th to 8th. Migrated from [DistrictAttendanceByResidence.A28]. |
ClassSpEdNPS_9_12 | 17.9.0 | Number(25,10) | Class Special Ed NPS 9th to 12th. Migrated from [DistrictAttendanceByResidence.A29]. |
ClassSpEdNPS_TK_3 | 17.9.0 | Number(25,10) | Class Special Ed NPS TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A26]. |
ClassSpEdNPS_Total | 17.9.0 | Number(25,10) | Class Special Ed NPS Total. Migrated from [DistrictAttendanceByResidence.A30]. |
DistrictOfResidence | 17.9.0 | Varchar2(40) | District Of Residence. Migrated from [DistrictAttendanceByResidence.user_defined_text]. |
ExYrSpEd_4_6 | 17.9.0 | Number(25,10) | Ex Yr Special Ed 4th to 6th. Migrated from [DistrictAttendanceByResidence.A12]. |
ExYrSpEd_7_8 | 17.9.0 | Number(25,10) | Ex Yr Special Ed 7th to 8th. Migrated from [DistrictAttendanceByResidence.A13]. |
ExYrSpEd_9_12 | 17.9.0 | Number(25,10) | Ex Yr Special Ed 9th to 12th. Migrated from [DistrictAttendanceByResidence.A14]. |
ExYrSpEd_TK_3 | 17.9.0 | Number(25,10) | Ex Yr Special Ed TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A11]. |
ExYrSpEd_Total | 17.9.0 | Number(25,10) | Ex Yr Special Ed Total. Migrated from [DistrictAttendanceByResidence.A15]. |
ExYrSpEdNPS_4_6 | 17.9.0 | Number(25,10) | Ex Yr Special Ed NPS 4th to 6th. Migrated from [DistrictAttendanceByResidence.A32]. |
ExYrSpEdNPS_7_8 | 17.9.0 | Number(25,10) | Ex Yr Special Ed NPS 7th to 8th. Migrated from [DistrictAttendanceByResidence.A33]. |
ExYrSpEdNPS_9_12 | 17.9.0 | Number(25,10) | Ex Yr Special Ed NPS 9th to 12th. Migrated from [DistrictAttendanceByResidence.A34]. |
ExYrSpEdNPS_TK_3 | 17.9.0 | Number(25,10) | Ex Yr Special Ed NPS TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A31]. |
ExYrSpEdNPS_Total | 17.9.0 | Number(25,10) | Ex Yr Special Ed NPS Total. Migrated from [DistrictAttendanceByResidence.A35]. |
ForeignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [DistrictAttendanceByResidence.foreignKey]. |
ForeignKey_Alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [DistrictAttendanceByResidence.foreignKey_alpha]. |
Period | 17.9.0 | Varchar2(6) | Period. Migrated from [DistrictAttendanceByResidence.Period]. |
SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [DistrictAttendanceByResidence.schoolID]. |
SpEdNPS_4_6 | 17.9.0 | Number(25,10) | Special Ed NPS 4th to 6th. Migrated from [DistrictAttendanceByResidence.A22]. |
SpEdNPS_7_8 | 17.9.0 | Number(25,10) | Special Ed NPS 7th to 8th. Migrated from [DistrictAttendanceByResidence.A23]. |
SpEdNPS_9_12 | 17.9.0 | Number(25,10) | Special Ed NPS 9th to 12th. Migrated from [DistrictAttendanceByResidence.A24]. |
SpEdNPS_TK_3 | 17.9.0 | Number(25,10) | Special Ed NPS TEDDE, Kindergarten, 1st to 3rd. Migrated from [DistrictAttendanceByResidence.A21]. |
SpEdNPS_Total | 17.9.0 | Number(25,10) | Special Ed NPS. Total Migrated from [DistrictAttendanceByResidence.A25]. |