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. |