S_NC_SchoolInfo (ver 13.6.0)
This table is an extension of the Schools table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Accreditation_Desc | 13.6.0 | Varchar2(50) | |
Allow_After_School_Programs | 13.6.0 | Varchar2(1) | |
Allow_Community_Programs | 13.6.0 | Varchar2(1) | |
Associated_Ext_Day_School | 13.6.0 | Number(11,0) | |
Associated_Night_School | 13.6.0 | Number(11,0) | |
Attendance_Phone_Number | 13.6.0 | Varchar2(10) | |
College_Board_ID | 13.6.0 | Varchar2(12) | |
| Daily_Instr_Minutes | 13.6.0 | Number(11,0) | |
Does_Home_Visits | 13.6.0 | Varchar2(1) | |
Expired_Date | 13.6.0 | Date | |
Federal_ID | 13.6.0 | Varchar2(12) | |
Granted_Date | 13.6.0 | Date | |
Parental_Conferences_Required | 13.6.0 | Varchar2(1) | |
Phone_2 | 13.6.0 | Varchar2(10) | |
Print_Intervention_Letters | 3.6.0 | Varchar2(1) | |
School_Sub_Type_Desc | 13.6.0 | Varchar2(30) | |
School_Type_EDDIE | 13.6.0 | Varchar2(1) | |
Student_Uniforms_Required | 13.6.0 | Varchar2(1) | |
VP_Name_2 | 13.6.0 | Varchar2(30) | |
VP_Name_3 | 13.6.0 | Varchar2(30) | |
Year_Round_School | 13.6.0 | Varchar2(1) | |
Fiscal_Year | 13.6.0 | Number(11,0) | |
SCH_Operational_Status | 13.6.0 | Varchar2(1) | |
Courier_Number | 13.6.0 | Varchar2(6) | |
Mailing_Address_Line1 | 13.6.0 | Varchar2(35) | |
Mailing_Address_Line2 | 13.6.0 | Varchar2(35) | |
Mailing_City | 13.6.0 | Varchar2(20) | |
Mailing_Zip_Code_5 | 13.6.0 | Varchar2(5) | |
Mailing_Zip_Code_4 | 13.6.0 | Varchar2(4) | |
Opening_Effective_Date | 13.6.0 | Date | |
Closing_Date | 13.6.0 | Date | |
Grade_Level_Approved | 13.6.0 | Varchar2(100) | |
Grade_Level_First_Year | 13.6.0 | Varchar2(100) | |
School_Type | 13.6.0 | Varchar2(1) | |
School_Program_Type | 13.6.0 | Varchar2(1) | |
School_Membership | 13.6.0 | Number(11,0) | |
School_Teacher_Count | 13.6.0 | Number(11,0) | |
Accreditation_Status | 13.6.0 | Varchar2(2) | |
Locale_Type | 13.6.0 | Varchar2(2) | |
New_Schools_Project | 13.6.0 | Varchar2(1) | |
CoHort_Number | 13.6.0 | Varchar2(3) | |
Cooperative_Innovative_HS | 13.6.0 | Varchar2(1) | |
Cooperative_MMYYYY_SBEApproved | 13.6.0 | Varchar2(6) | |
First_YR_EST_ADM | 13.6.0 | Number(11,0) | |
First_YR_EST_Paid_Teacher_FTE | 13.6.0 | Number(11,0) | |
Newly_Constructed_Facility | 13.6.0 | Varchar2(1) | |
Occupancy_Date | 13.6.0 | Date | |
What_Facility_Will_SCH_Occupy | 13.6.0 | Varchar2(100) | |
Share_Space | 13.6.0 | Varchar2(1) | |
Share_Space_Describe | 13.6.0 | Varchar2(150) | |
New_SCH_Population_From | 13.6.0 | Varchar2(4000) | |
School_Closing_Due_To_Opening | 13.6.0 | Varchar2(1) | |
List_Of_Closing_School | 13.6.0 | Varchar2(1) | |
Title_I | 13.6.0 | Varchar2(1) | |
School_Calendar_Type | 13.6.0 | Varchar2(1) | |
School_Schedule_Type | 13.6.0 | Varchar2(1) | |
SBE_Region | 13.6.0 | Varchar2(1) | |
URL_School_Address | 13.6.0 | Varchar2(150) | |
Record_Created_TimeStamp | 13.6.0 | Date | |
Record_Created_By | 13.6.0 | Varchar2(40) | |
Last_Changed_TimeStamp | 13.6.0 | Date | |
Last_Changed_By | 13.6.0 | Varchar2(40) | |
Extended_Hours | 13.6.0 | Varchar2(1) | |
School_Designated_Type | 13.6.0 | Varchar2(1) | |
Fiscal_Year_For_Teachers | 13.6.0 | Number(11,0) | |
Fiscal_Year_For_SCH_Membership | 13.6.0 | Number(11,0) | |
County_Code | 13.6.0 | Varchar2(3) | |
Official_School_Name | 13.6.0 | Varchar2(60) | |
Opening_In_School_Year | 13.6.0 | Number(11,0) | |
Grade_Level_Current | 13.6.0 | Varchar2(100) | |
Mailing_State | 13.6.0 | Varchar2(2) | |
School_SyStartStatus | 13.6.0 | Varchar2(1) | |
| Sch_Operational_Status | 13.6.0 | Varchar2(1) | |
| SchoolsDCID | 13.6.0 | Number(10,0) |