S_IN_SCH_X (ver 15.6.4)
This is an extension of the [Schools] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 15.6.4 | Number(10,0) | Primary key that relates the extended table to the [Schools] table. |
| CEEB_ACT_Code | 15.6.4 | VarChar2(6) | The unique identifier assigned by the College Entrance Examining Board and ACT for each K-12 data exchange partner. |
| Include_In_Transcript | 15.6.4 | Number(1,0) | Flag to include the transcript in the XML file. |
| SchoolNumberPrefix | 17.4.0 | VarChar2(4) | Migrated from [Schools]IN_SchoolNumberPrefix. |
| High_School_Credits_Earned | 17.4.0 | VarChar2(1) | Migrated from [Schools]IN_High_School_Credit. |
| CHIRP_School_Code | 18.3.0 | Varchar2(4) | School Code for schools that have CHIRP School ID different than their School ID |
| ScheduleType | 20.7.2.0 | Varchar2(50) | Schedule Type |
| BeginTime | 20.7.2.0 | Varchar2(5) | Begin Time |
| EndTime | 20.7.2.0 | Varchar2(5) | End Time |
| NonInstructionalMinutes | 20.7.2.0 | Number(11,0) | Non-instructional Minutes |
| InstructTimeInMinutes | 20.7.2.0 | Number(1,0) | Instructional Minutes |
| InstructionalMinutes | 20.7.2.0 | Number(11,0) | Instructional Time in Minutes (Performance Qualified) |
| TotalWaiverDays | 20.7.2.0 | Number(11,0) | Total Waiver Days |
| ExcludeFromInstCalendar | 20.7.2.0 | Number(1,0) | Exclude from Inst Calendar |
| CalendarType | 20.7.2.0 | Varchar2(50) | Calendar Type |
| EDFI_ATT_Mode | 21.2.2.0 | Varchar2(30) | Validating Ed-Fi attendance by specifying the attendance record type to be processed (ATT_ModeMeeting, ATT_ModeDaily) to indicate which option is needed for each school. |
| Title_I_Program | 22.2.2.0 | Number(11,0) | Title I Program |
| IsTitleISchool | 22.2.2.0 | Number(1,0) | Title I School Indicator |