Skip to main content
Skip table of contents

S_ID_SCH_X (ver 14.3.0)

This is an extension of the Schools table.

Column Name

Version

Data Type

Description

SchoolsDCID14.3.0Number(10,0)Primary Key
AlternativeSchedule15.7.0Number(1,0)Alternative Schedule (1/null). Migrated from [Schools.ID_AlternativeSchedule].
AltSchMaxHours15.7.0Number(25,10)Alternative School Max Hours Per Day (1-12, 3 dec places max). Migrated from [Schools.ID_AltSchMaxHours].
calIDTrackA16.1.0Number(11,0)Calendar ID for Track A.
calIDTrackB16.1.0Number(11,0)Calendar ID for Track B.
calIDTrackC16.1.0Number(11,0)Calendar ID for Track C.
calIDTrackD16.1.0Number(11,0)Calendar ID for Track D.
calIDTrackE16.1.0Number(11,0)Calendar ID for Track E.
calIDTrackF16.1.0Number(11,0)Calendar ID for Track F.
CEPSchool14.8.2Number(10,0)CEPSchool (flag to identify the Lunch Status).
CharterSchool15.7.0Number(1,0)Charter School Type (1/null). Migrated from [Schools.ID_CharterSchool].
ClosedDate15.7.0DateClosed Date. Migrated from [Schools.ID_ClosedDate].
DefaultCalendar15.7.0Number(11,0)Default School or District Calendar. Migrated from [Schools.ID_DefaultCalendar].
Default_ExitReason14.3.0Varchar2(2)Default (Override) Exit Reason when one not recorded in cc for Elem/MS enrollments.
DUNS15.7.0Varchar2(18)Dun and Bradstreet Number. Migrated from [Schools.ID_DUNS].
ElementaryHours15.7.0Number(11,0)Elementary Hours. Migrated from [Schools.ID_ElementaryHours].
HalfdayKHours15.7.0Number(11,0)Half Day Kindergarten Hours. Migrated from [Schools.ID_HalfdayKHours].
HighSchoolHours15.7.0Number(11,0)Senior High Hours. Migrated from [Schools.ID_HighSchoolHours].
ImprovementStatus15.7.0Varchar2(5)Improvement Status (2 char code). Migrated from [Schools.ID_ImprovementStatus].
IsMagnet15.7.0Number(1,0)Is Magnet School (1/null). Migrated from [Schools.ID_IsMagnet].
IsPersistentlyDangerous15.7.0Number(1,0)Is Persistently Dangerous (1/null). Migrated from [Schools.ID_IsPersistentlyDangerous].
IsPersistentlyLowAchieving15.7.0Number(1,0)Is Persistently Low Achieving (1/null). Migrated from [Schools.ID_IsPersistentlyLowAchieving].
IsReconstituted15.7.0Number(1,0)Is Reconstituted (1/null). Migrated from [Schools.ID_IsReconstituted].
IsSIGSchool15.7.0Number(1,0)Is SIG School (1/null). Migrated from [Schools.ID_IsSIGSchool].
JuniorHighHours15.7.0Number(11,0)Middle/Junior High Hours. Migrated from [Schools.ID_JuniorHighHours].
LocationCounty15.7.0Varchar2(5)Location County (2 digit code). Migrated from [Schools.ID_LocationCounty].
MailingAddressLine115.7.0Varchar2(70)Mailing Address Line 1 (35 char). Migrated from [Schools.ID_MailingAddressLine1].
MailingAddressLine215.7.0Varchar2(70)Mailing Address Line 2 (35 char). Migrated from [Schools.ID_MailingAddressLine2].
MailingCity15.7.0Varchar2(40)Mailing City (20 char). Migrated from [Schools.ID_MailingCity].
MailingStateCode15.7.0Varchar2(5)Mailing State Code (2 char). Migrated from [Schools.ID_MailingStateCode].
MailingZipCode15.7.0Varchar2(18)Mailing Zip Code (9 char). Migrated from [Schools.ID_MailingZipCode].
MaxCredits115.7.0Number(25,10)School Max Allowable Credits Grade 1. Migrated from [Schools.ID_MaxCredits1].
MaxCredits1015.7.0Number(25,10)School Max Allowable Credits Grade 10. Migrated from [Schools.ID_MaxCredits10].
MaxCredits1115.7.0Number(25,10)School Max Allowable Credits Grade 11. Migrated from [Schools.ID_MaxCredits11].
MaxCredits1215.7.0Number(25,10)School Max Allowable Credits Grade 12. Migrated from [Schools.ID_MaxCredits12].
MaxCredits215.7.0Number(25,10)School Max Allowable Credits Grade 2. Migrated from [Schools.ID_MaxCredits2].
MaxCredits315.7.0Number(25,10)School Max Allowable Credits Grade 3. Migrated from [Schools.ID_MaxCredits3].
MaxCredits415.7.0Number(25,10)School Max Allowable Credits Grade 4. Migrated from [Schools.ID_MaxCredits4].
MaxCredits515.7.0Number(25,10)School Max Allowable Credits Grade 5. Migrated from [Schools.ID_MaxCredits5].
MaxCredits615.7.0Number(25,10)School Max Allowable Credits Grade 6. Migrated from [Schools.ID_MaxCredits6].
MaxCredits715.7.0Number(25,10)School Max Allowable Credits Grade 7. Migrated from [Schools.ID_MaxCredits7].
MaxCredits815.7.0Number(25,10)School Max Allowable Credits Grade 8. Migrated from [Schools.ID_MaxCredits8].
MaxCredits915.7.0Number(25,10)School Max Allowable Credits Grade 9. Migrated from [Schools.ID_MaxCredits9].
MaxCreditsK15.7.0Number(25,10)School Max Allowable Credits Grade K. Migrated from [Schools.ID_MaxCreditsK].
MaxCreditsPK215.7.0Number(25,10)School Max Allowable Credits Grade PreK2. Migrated from [Schools.ID_MaxCreditsPK2].
MaxCreditsPK315.7.0Number(25,10)School Max Allowable Credits Grade PreK3. Migrated from [Schools.ID_MaxCreditsPK3].
MaxCreditsPK415.7.0Number(25,10)School Max Allowable Credits Grade PreK4. Migrated from [Schools.ID_MaxCreditsPK4].
MaxPeriod115.7.0Number(11,0)School Max Allowable Periods Grade 1. Migrated from [Schools.ID_MaxPeriod1].
MaxPeriod1015.7.0Number(11,0)School Max Allowable Periods Grade 10. Migrated from [Schools.ID_MaxPeriod10].
MaxPeriod1115.7.0Number(11,0)School Max Allowable Periods Grade 11. Migrated from [Schools.ID_MaxPeriod11].
MaxPeriod1215.7.0Number(11,0)School Max Allowable Periods Grade 12. Migrated from [Schools.ID_MaxPeriod12].
MaxPeriod215.7.0Number(11,0)School Max Allowable Periods Grade 2. Migrated from [Schools.ID_MaxPeriod2].
MaxPeriod315.7.0Number(11,0)School Max Allowable Periods Grade 3. Migrated from [Schools.ID_MaxPeriod3].
MaxPeriod415.7.0Number(11,0)School Max Allowable Periods Grade 4. Migrated from [Schools.ID_MaxPeriod4].
MaxPeriod515.7.0Number(11,0)School Max Allowable Periods Grade 5. Migrated from [Schools.ID_MaxPeriod5].
MaxPeriod615.7.0Number(11,0)School Max Allowable Periods Grade 6. Migrated from [Schools.ID_MaxPeriod6].
MaxPeriod715.7.0Number(11,0)School Max Allowable Periods Grade 7. Migrated from [Schools.ID_MaxPeriod7].
MaxPeriod815.7.0Number(11,0)School Max Allowable Periods Grade 8. Migrated from [Schools.ID_MaxPeriod8].
MaxPeriod915.7.0Number(11,0)School Max Allowable Periods Grade 9. Migrated from [Schools.ID_MaxPeriod9].
MaxPeriodK15.7.0Number(11,0)School Max Allowable Periods Grade K. Migrated from [Schools.ID_MaxPeriodK].
MaxPeriodPK215.7.0Number(11,0)School Max Allowable Periods Grade PreK2. Migrated from [Schools.ID_MaxPeriodPK2].
MaxPeriodPK315.7.0Number(11,0)School Max Allowable Periods Grade PreK3. Migrated from [Schools.ID_MaxPeriodPK3].
MaxPeriodPK415.7.0Number(11,0)School Max Allowable Periods Grade PreK4. Migrated from [Schools.ID_MaxPeriodPK4].
MEProgram15.7.0Varchar2(5)Migrant Program Status (1 char code). Migrated from [Schools.ID_MEProgram].
minsWeek14.12.0Number(10,0)ID Minutes Per Week School Override.
NCESLEAId15.7.0Varchar2(18)NCES LEA Identifier. Migrated from [Schools.ID_NCESLEAId].
NCESSchoolId15.7.0Varchar2(14)NCES School Identifier. Migrated from [Schools.ID_NCESSchoolId].
Notes15.7.0Varchar2(500)Notes. Migrated from [Schools.ID_Notes].
OpenDate15.7.0DateOpen Date. Migrated from [Schools.ID_OpenDate].
OpenEnrollAccPY15.7.0Number(11,0)Prior Year Open Enrollment Accepted. Migrated from [Schools.ID_OpenEnrollAccPY].
OpenEnrollAppPY15.7.0Number(11,0)Prior Year Open Enrollment Applications. Migrated from [Schools.ID_OpenEnrollAppPY].
OpenEnrollPY15.7.0Varchar2(5)Prior Year Open Enrollment (X/Y/N). Migrated from [Schools.ID_OpenEnrollPY].
OpenEnrollRejPY15.7.0Number(11,0)Prior Year Open Enrollment Rejected. Migrated from [Schools.ID_OpenEnrollRejPY].
OperatingStatus15.7.0Varchar2(5)Operating Status (1 char code). Migrated from [Schools.ID_OperatingStatus].
PovertyQuartile15.7.0Number(11,0)Poverty Quartile (1 digit code). Migrated from [Schools.ID_PovertyQuartile].
PrimaryBuilding15.7.0Number(1,0)Primary Building (1/null). Migrated from [Schools.ID_PrimaryBuilding].
PrivateSchool15.7.0Number(1,0)Private School Type (1/null). Migrated from [Schools.ID_PrivateSchool].
Prov2_315.7.0Number(1,0)Provision 2/3 School Type (1/null). Migrated from [Schools.ID_Prov2_3].
PublicSchool15.7.0Number(1,0)Public School Type (1/null). Migrated from [Schools.ID_PublicSchool].
Publish15.7.0Number(1,0)Publish in Directory. Migrated from [Schools.ID_Publish].
Region15.7.0Varchar2(5)Idaho Region (1 digit code). Migrated from [Schools.ID_Region].
RejCapacityCount15.7.0Number(11,0)Rejected Capacity Overload Count. Migrated from [Schools.ID_RejCapacityCount].
RejDisciplineCount15.7.0Number(11,0)Rejected Discipline Count. Migrated from [Schools.ID_RejDisciplineCount].
RejOtherCount15.7.0Number(11,0)Rejected Other Count. Migrated from [Schools.ID_RejOtherCount].
RejOtherReason15.7.0Varchar2(100)Rejected Other Reason. Migrated from [Schools.ID_RejOtherReason].
SchoolCalendarNumber15.7.0Number(11,0)Default School Calendar Number (9 digit integer). Migrated from [Schools.ID_SchoolCalendarNumber].
SchoolType15.7.0Varchar2(5)School Type (2 char code). Migrated from [Schools.ID_SchoolType].
SchoolTypeCode15.7.0Varchar2(5)School Type Code (2 char code). Migrated from [Schools.ID_SchoolTypeCode].
ServesAE15.7.0Number(1,0)Serves Adult Education (1/null). Migrated from [Schools.ID_ServesAE].
ServesEC15.7.0Number(1,0)Serves Early Childhood (1/null). Migrated from [Schools.ID_ServesEC].
ServesFK15.7.0Number(1,0)Serves Full-day Kindergarten (1/null). Migrated from [Schools.ID_ServesFK].
ServesHK15.7.0Number(1,0)Serves Half-day Kindergarten (1/null). Migrated from [Schools.ID_ServesHK].
SharedSchoolCal15.7.0Number(11,0)School to use for shared calendar number (Def schl cal). Migrated from [Schools.ID_SharedSchoolCal].
TeacherDaysOverride15.7.0Number(11,0)Teacher Days Override. Migrated from [Schools.ID_TeacherDaysOverride].
TitleIEligibility15.7.0Varchar2(5)Title I Eligibility (1 char code). Migrated from [Schools.ID_TitleIEligibility].
TitleIProgram15.7.0Varchar2(5)Title I Program (1 char code). Migrated from [Schools.ID_TitleIProgram].
uGPA16.8.0Varchar2(50)Name of unweighted GPA Calculation method.
wGPA16.8.0Varchar2(50)Name of weighted GPA Calculation method.

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.