S_ID_SCH_X (ver 14.3.0)
This is an extension of the Schools table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 14.3.0 | Number(10,0) | Primary Key |
| AlternativeSchedule | 15.7.0 | Number(1,0) | Alternative Schedule (1/null). Migrated from [Schools.ID_AlternativeSchedule]. |
| AltSchMaxHours | 15.7.0 | Number(25,10) | Alternative School Max Hours Per Day (1-12, 3 dec places max). Migrated from [Schools.ID_AltSchMaxHours]. |
| calIDTrackA | 16.1.0 | Number(11,0) | Calendar ID for Track A. |
| calIDTrackB | 16.1.0 | Number(11,0) | Calendar ID for Track B. |
| calIDTrackC | 16.1.0 | Number(11,0) | Calendar ID for Track C. |
| calIDTrackD | 16.1.0 | Number(11,0) | Calendar ID for Track D. |
| calIDTrackE | 16.1.0 | Number(11,0) | Calendar ID for Track E. |
| calIDTrackF | 16.1.0 | Number(11,0) | Calendar ID for Track F. |
| CEPSchool | 14.8.2 | Number(10,0) | CEPSchool (flag to identify the Lunch Status). |
| CharterSchool | 15.7.0 | Number(1,0) | Charter School Type (1/null). Migrated from [Schools.ID_CharterSchool]. |
| ClosedDate | 15.7.0 | Date | Closed Date. Migrated from [Schools.ID_ClosedDate]. |
| DefaultCalendar | 15.7.0 | Number(11,0) | Default School or District Calendar. Migrated from [Schools.ID_DefaultCalendar]. |
| Default_ExitReason | 14.3.0 | Varchar2(2) | Default (Override) Exit Reason when one not recorded in cc for Elem/MS enrollments. |
| DUNS | 15.7.0 | Varchar2(18) | Dun and Bradstreet Number. Migrated from [Schools.ID_DUNS]. |
| ElementaryHours | 15.7.0 | Number(11,0) | Elementary Hours. Migrated from [Schools.ID_ElementaryHours]. |
| HalfdayKHours | 15.7.0 | Number(11,0) | Half Day Kindergarten Hours. Migrated from [Schools.ID_HalfdayKHours]. |
| HighSchoolHours | 15.7.0 | Number(11,0) | Senior High Hours. Migrated from [Schools.ID_HighSchoolHours]. |
| ImprovementStatus | 15.7.0 | Varchar2(5) | Improvement Status (2 char code). Migrated from [Schools.ID_ImprovementStatus]. |
| IsMagnet | 15.7.0 | Number(1,0) | Is Magnet School (1/null). Migrated from [Schools.ID_IsMagnet]. |
| IsPersistentlyDangerous | 15.7.0 | Number(1,0) | Is Persistently Dangerous (1/null). Migrated from [Schools.ID_IsPersistentlyDangerous]. |
| IsPersistentlyLowAchieving | 15.7.0 | Number(1,0) | Is Persistently Low Achieving (1/null). Migrated from [Schools.ID_IsPersistentlyLowAchieving]. |
| IsReconstituted | 15.7.0 | Number(1,0) | Is Reconstituted (1/null). Migrated from [Schools.ID_IsReconstituted]. |
| IsSIGSchool | 15.7.0 | Number(1,0) | Is SIG School (1/null). Migrated from [Schools.ID_IsSIGSchool]. |
| JuniorHighHours | 15.7.0 | Number(11,0) | Middle/Junior High Hours. Migrated from [Schools.ID_JuniorHighHours]. |
| LocationCounty | 15.7.0 | Varchar2(5) | Location County (2 digit code). Migrated from [Schools.ID_LocationCounty]. |
| MailingAddressLine1 | 15.7.0 | Varchar2(70) | Mailing Address Line 1 (35 char). Migrated from [Schools.ID_MailingAddressLine1]. |
| MailingAddressLine2 | 15.7.0 | Varchar2(70) | Mailing Address Line 2 (35 char). Migrated from [Schools.ID_MailingAddressLine2]. |
| MailingCity | 15.7.0 | Varchar2(40) | Mailing City (20 char). Migrated from [Schools.ID_MailingCity]. |
| MailingStateCode | 15.7.0 | Varchar2(5) | Mailing State Code (2 char). Migrated from [Schools.ID_MailingStateCode]. |
| MailingZipCode | 15.7.0 | Varchar2(18) | Mailing Zip Code (9 char). Migrated from [Schools.ID_MailingZipCode]. |
| MaxCredits1 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 1. Migrated from [Schools.ID_MaxCredits1]. |
| MaxCredits10 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 10. Migrated from [Schools.ID_MaxCredits10]. |
| MaxCredits11 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 11. Migrated from [Schools.ID_MaxCredits11]. |
| MaxCredits12 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 12. Migrated from [Schools.ID_MaxCredits12]. |
| MaxCredits2 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 2. Migrated from [Schools.ID_MaxCredits2]. |
| MaxCredits3 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 3. Migrated from [Schools.ID_MaxCredits3]. |
| MaxCredits4 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 4. Migrated from [Schools.ID_MaxCredits4]. |
| MaxCredits5 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 5. Migrated from [Schools.ID_MaxCredits5]. |
| MaxCredits6 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 6. Migrated from [Schools.ID_MaxCredits6]. |
| MaxCredits7 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 7. Migrated from [Schools.ID_MaxCredits7]. |
| MaxCredits8 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 8. Migrated from [Schools.ID_MaxCredits8]. |
| MaxCredits9 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade 9. Migrated from [Schools.ID_MaxCredits9]. |
| MaxCreditsK | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade K. Migrated from [Schools.ID_MaxCreditsK]. |
| MaxCreditsPK2 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade PreK2. Migrated from [Schools.ID_MaxCreditsPK2]. |
| MaxCreditsPK3 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade PreK3. Migrated from [Schools.ID_MaxCreditsPK3]. |
| MaxCreditsPK4 | 15.7.0 | Number(25,10) | School Max Allowable Credits Grade PreK4. Migrated from [Schools.ID_MaxCreditsPK4]. |
| MaxPeriod1 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 1. Migrated from [Schools.ID_MaxPeriod1]. |
| MaxPeriod10 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 10. Migrated from [Schools.ID_MaxPeriod10]. |
| MaxPeriod11 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 11. Migrated from [Schools.ID_MaxPeriod11]. |
| MaxPeriod12 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 12. Migrated from [Schools.ID_MaxPeriod12]. |
| MaxPeriod2 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 2. Migrated from [Schools.ID_MaxPeriod2]. |
| MaxPeriod3 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 3. Migrated from [Schools.ID_MaxPeriod3]. |
| MaxPeriod4 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 4. Migrated from [Schools.ID_MaxPeriod4]. |
| MaxPeriod5 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 5. Migrated from [Schools.ID_MaxPeriod5]. |
| MaxPeriod6 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 6. Migrated from [Schools.ID_MaxPeriod6]. |
| MaxPeriod7 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 7. Migrated from [Schools.ID_MaxPeriod7]. |
| MaxPeriod8 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 8. Migrated from [Schools.ID_MaxPeriod8]. |
| MaxPeriod9 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade 9. Migrated from [Schools.ID_MaxPeriod9]. |
| MaxPeriodK | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade K. Migrated from [Schools.ID_MaxPeriodK]. |
| MaxPeriodPK2 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade PreK2. Migrated from [Schools.ID_MaxPeriodPK2]. |
| MaxPeriodPK3 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade PreK3. Migrated from [Schools.ID_MaxPeriodPK3]. |
| MaxPeriodPK4 | 15.7.0 | Number(11,0) | School Max Allowable Periods Grade PreK4. Migrated from [Schools.ID_MaxPeriodPK4]. |
| MEProgram | 15.7.0 | Varchar2(5) | Migrant Program Status (1 char code). Migrated from [Schools.ID_MEProgram]. |
| minsWeek | 14.12.0 | Number(10,0) | ID Minutes Per Week School Override. |
| NCESLEAId | 15.7.0 | Varchar2(18) | NCES LEA Identifier. Migrated from [Schools.ID_NCESLEAId]. |
| NCESSchoolId | 15.7.0 | Varchar2(14) | NCES School Identifier. Migrated from [Schools.ID_NCESSchoolId]. |
| Notes | 15.7.0 | Varchar2(500) | Notes. Migrated from [Schools.ID_Notes]. |
| OpenDate | 15.7.0 | Date | Open Date. Migrated from [Schools.ID_OpenDate]. |
| OpenEnrollAccPY | 15.7.0 | Number(11,0) | Prior Year Open Enrollment Accepted. Migrated from [Schools.ID_OpenEnrollAccPY]. |
| OpenEnrollAppPY | 15.7.0 | Number(11,0) | Prior Year Open Enrollment Applications. Migrated from [Schools.ID_OpenEnrollAppPY]. |
| OpenEnrollPY | 15.7.0 | Varchar2(5) | Prior Year Open Enrollment (X/Y/N). Migrated from [Schools.ID_OpenEnrollPY]. |
| OpenEnrollRejPY | 15.7.0 | Number(11,0) | Prior Year Open Enrollment Rejected. Migrated from [Schools.ID_OpenEnrollRejPY]. |
| OperatingStatus | 15.7.0 | Varchar2(5) | Operating Status (1 char code). Migrated from [Schools.ID_OperatingStatus]. |
| PovertyQuartile | 15.7.0 | Number(11,0) | Poverty Quartile (1 digit code). Migrated from [Schools.ID_PovertyQuartile]. |
| PrimaryBuilding | 15.7.0 | Number(1,0) | Primary Building (1/null). Migrated from [Schools.ID_PrimaryBuilding]. |
| PrivateSchool | 15.7.0 | Number(1,0) | Private School Type (1/null). Migrated from [Schools.ID_PrivateSchool]. |
| Prov2_3 | 15.7.0 | Number(1,0) | Provision 2/3 School Type (1/null). Migrated from [Schools.ID_Prov2_3]. |
| PublicSchool | 15.7.0 | Number(1,0) | Public School Type (1/null). Migrated from [Schools.ID_PublicSchool]. |
| Publish | 15.7.0 | Number(1,0) | Publish in Directory. Migrated from [Schools.ID_Publish]. |
| Region | 15.7.0 | Varchar2(5) | Idaho Region (1 digit code). Migrated from [Schools.ID_Region]. |
| RejCapacityCount | 15.7.0 | Number(11,0) | Rejected Capacity Overload Count. Migrated from [Schools.ID_RejCapacityCount]. |
| RejDisciplineCount | 15.7.0 | Number(11,0) | Rejected Discipline Count. Migrated from [Schools.ID_RejDisciplineCount]. |
| RejOtherCount | 15.7.0 | Number(11,0) | Rejected Other Count. Migrated from [Schools.ID_RejOtherCount]. |
| RejOtherReason | 15.7.0 | Varchar2(100) | Rejected Other Reason. Migrated from [Schools.ID_RejOtherReason]. |
| SchoolCalendarNumber | 15.7.0 | Number(11,0) | Default School Calendar Number (9 digit integer). Migrated from [Schools.ID_SchoolCalendarNumber]. |
| SchoolType | 15.7.0 | Varchar2(5) | School Type (2 char code). Migrated from [Schools.ID_SchoolType]. |
| SchoolTypeCode | 15.7.0 | Varchar2(5) | School Type Code (2 char code). Migrated from [Schools.ID_SchoolTypeCode]. |
| ServesAE | 15.7.0 | Number(1,0) | Serves Adult Education (1/null). Migrated from [Schools.ID_ServesAE]. |
| ServesEC | 15.7.0 | Number(1,0) | Serves Early Childhood (1/null). Migrated from [Schools.ID_ServesEC]. |
| ServesFK | 15.7.0 | Number(1,0) | Serves Full-day Kindergarten (1/null). Migrated from [Schools.ID_ServesFK]. |
| ServesHK | 15.7.0 | Number(1,0) | Serves Half-day Kindergarten (1/null). Migrated from [Schools.ID_ServesHK]. |
| SharedSchoolCal | 15.7.0 | Number(11,0) | School to use for shared calendar number (Def schl cal). Migrated from [Schools.ID_SharedSchoolCal]. |
| TeacherDaysOverride | 15.7.0 | Number(11,0) | Teacher Days Override. Migrated from [Schools.ID_TeacherDaysOverride]. |
| TitleIEligibility | 15.7.0 | Varchar2(5) | Title I Eligibility (1 char code). Migrated from [Schools.ID_TitleIEligibility]. |
| TitleIProgram | 15.7.0 | Varchar2(5) | Title I Program (1 char code). Migrated from [Schools.ID_TitleIProgram]. |
| uGPA | 16.8.0 | Varchar2(50) | Name of unweighted GPA Calculation method. |
| wGPA | 16.8.0 | Varchar2(50) | Name of weighted GPA Calculation method. |