Skip to main content
Skip table of contents

S_GA_SCH_X (ver 16.6.0)

This table is an extension of the [Schools] table.


Column Name

Version

Data Type

Description

SchoolsDCID

16.5.0

Number(10,0)

Primary key that relates the extended table back to the Schools table.

CEEB_Code16.6.0Number(11,0)Indicates the high school's 6-digit identification number for the College Board. This field is required for the GaFutures/HOPE System. Migrated from Schools.GA_CEEB_Code.
CPR_AED16.6.0Number(1,0)Indicates a high school that provides instruction in CPR and the use of AED in physical education courses. Migrated from Schools.GA_CPR_AED.
DualEnrollAware_Grade1018.8.0Varchar2(1)Indicates whether 10th grade students were made aware of Dual Enrollment opportunities
DualEnrollAware_Grade1118.8.0Varchar2(1)Indicates whether 11th grade students were made aware of Dual Enrollment opportunities
DualEnrollAware_Grade818.8.0Varchar2(1)Indicates whether 8th grade students were made aware of Dual Enrollment opportunities
DualEnrollAware_Grade918.8.0Varchar2(1)Indicates whether 9th grade students were made aware of Dual Enrollment opportunities
FRPME_SAS16.6.0Varchar2(1)Indicates school-wide Special Assistance Status (SAS) for Free and Reduced Priced Meal Eligibility (FRPME). Migrated from Schools.GA_FRPME_SAS.
MiddleSchoolInd16.6.0Varchar2(1)Indicates if the school provides a Middle School Program (FTE program code H), versus a Middle Grades Program (FTE program code 9). Migrated from Schools.GA_MiddleSchoolInd.
NCLB_AB16.6.0Number(11,0)The number of incidents of aggravated battery. Migrated from Schools.GA_NCLB_AB.
NCLB_ACM16.6.0Number(11,0)The number of incidents of aggravated child molestation. Migrated from Schools.GA_NCLB_ACM.
NCLB_AR16.6.0Number(11,0)The number of incidents of armed robbery. Migrated from Schools.GA_NCLB_AR.
NCLB_AS16.6.0Number(11,0)The number of incidents of aggravated sodomy. Migrated from Schools.GA_NCLB_AS.
NCLB_ASB16.6.0Number(11,0)The number of incidents of aggravated sexual battery. Migrated from Schools.GA_NCLB_ASB.
NCLB_FD16.6.0Number(11,0)The number of incidents of felony drugs. Migrated from Schools.GA_NCLB_FD.
NCLB_FDA16.6.0Number(11,0)The number of incidents of first degree arson. Migrated from Schools.GA_NCLB_FDA.
NCLB_FW16.6.0Number(11,0)The number of incidents of felony weapons. Migrated from Schools.GA_NCLB_FW.
NCLB_K16.6.0Number(11,0)The number of incidents of kidnapping. Migrated from Schools.GA_NCLB_K.
NCLB_M16.6.0Number(11,0)The number of incidents of murder. Migrated from Schools.GA_NCLB_M.
NCLB_NFD16.6.0Number(11,0)The number of incidents of non-felony drugs. Migrated from Schools.GA_NCLB_NFD.
NCLB_R16.6.0Number(11,0)The number of incidents of rape. Migrated from Schools.GA_NCLB_R.
NCLB_TT16.6.0Number(11,0)The number of incidents of terroristic threats. Migrated from Schools.GA_NCLB_TT.
NCLB_VM16.6.0Number(11,0)The number of incidents of voluntary manslaughter. Migrated from Schools.GA_NCLB_VM.
OnlineSchool16.6.0Number(1,0)Indicates that the school is online only; all courses at the school will be considered online. Migrated from Schools.GA_OnlineSchool.
PANDASiteID20.9.3Varchar2(5)The PANDA ID associated with the school.
SWCC_Homeless16.12.1Number(11,0)The number of cases involving homeless students and families handled by social workers this school year.
SWCC_SpecProg16.12.1Number(11,0)The number of assemblies, lunch and learn, parent night presentations, etc.
SWCC_SuicRef16.12.1Number(11,0)The number of referrals received for children exhibiting signs of suicidal ideation.
SWC_ADS16.6.0Number(11,0)The number of academic support instances. Migrated from Schools.GA_SWC_ADS.
SWC_AS16.6.0Number(11,0)The number of child abuse and neglect services instances. Migrated from Schools.GA_SWC_AS.
SWC_ASID16.6.0Number(11,0)The number of attendance/dropout prevention services instances. Migrated from Schools.GA_SWC_ASID.
SWC_DS16.6.0Number(11,0)The number of school safety services instances. Migrated from Schools.GA_SWC_DS.
SWC_FHPSS16.6.0Number(11,0)The number of family/health/social services/homeless services instances. Migrated from Schools.GA_SWC_FHPSS.
SWC_SE16.6.0Number(11,0)The number of special education instances. Migrated from Schools.GA_SWC_SE.
SWR_DFCS16.6.0Number(11,0)The number of Department of Family and Children Services (DFCS) instances. Migrated from Schools.GA_SWR_DFCS.
SWR_JC16.6.0Number(11,0)The number of juvenile and other court instances. Migrated from Schools.GA_SWR_JC.
SWR_MH16.6.0Number(11,0)The number of mental health services instances. Migrated from Schools.GA_SWR_MH.
SWR_Other16.6.0Number(11,0)The number of community agencies instances. Migrated from Schools.GA_SWR_Other.
SWR_PH16.6.0Number(11,0)The number of health services instances. Migrated from Schools.GA_SWR_PH.
SWS_AgencyVisits16.12.1Number(11,0)The number of trips made by social workers this school year to agencies to impact, or gather information.
SWS_CACR16.6.0Number(11,0)The number of community agency consultations/referrals/crisis interventions instances. Migrated from Schools.GA_SWS_CACR.
SWS_CrisisInterv16.12.1Number(11,0)The number of single contacts in person, by phone, or mail involving life-threatening issues
SWS_CWO16.6.0Number(11,0)The number of conferences with school staff instances. Migrated from Schools.GA_SWS_CWO.
SWS_CWPF16.6.0Number(11,0)The number of conferences with parents/family instances. Migrated from Schools.GA_SWS_CWPF.
SWS_CWS16.6.0Number(11,0)The number of student interventions - Individual and Group instances. Migrated from Schools.GA_SWS_CWS.
SWS_EAS16.6.0Number(11,0)The number of Economic Aid Sessions instances. Migrated from Schools.GA_SWS_EAS.
SWS_GrpInterv16.12.1Number(11,0)The number of groups led or co led by social workers this year.
SWS_HAV16.6.0Number(11,0)The number of home/agency visits instances. Migrated from Schools.GA_SWS_EAS.
SWS_MS16.6.0Number(11,0)The number of mediation sessions instances. Migrated from Schools.GA_SWS_MS.
T1SC16.6.0Varchar2(1)Indicates school-wide Title I Assistance or use of a Targeted Assistance Title I program. Migrated from Schools.GA_T1SC.



JavaScript errors detected

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

If this problem persists, please contact our support.