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_Code | 16.6.0 | Number(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_AED | 16.6.0 | Number(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_Grade10 | 18.8.0 | Varchar2(1) | Indicates whether 10th grade students were made aware of Dual Enrollment opportunities |
DualEnrollAware_Grade11 | 18.8.0 | Varchar2(1) | Indicates whether 11th grade students were made aware of Dual Enrollment opportunities |
DualEnrollAware_Grade8 | 18.8.0 | Varchar2(1) | Indicates whether 8th grade students were made aware of Dual Enrollment opportunities |
DualEnrollAware_Grade9 | 18.8.0 | Varchar2(1) | Indicates whether 9th grade students were made aware of Dual Enrollment opportunities |
FRPME_SAS | 16.6.0 | Varchar2(1) | Indicates school-wide Special Assistance Status (SAS) for Free and Reduced Priced Meal Eligibility (FRPME). Migrated from Schools.GA_FRPME_SAS. |
MiddleSchoolInd | 16.6.0 | Varchar2(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_AB | 16.6.0 | Number(11,0) | The number of incidents of aggravated battery. Migrated from Schools.GA_NCLB_AB. |
NCLB_ACM | 16.6.0 | Number(11,0) | The number of incidents of aggravated child molestation. Migrated from Schools.GA_NCLB_ACM. |
NCLB_AR | 16.6.0 | Number(11,0) | The number of incidents of armed robbery. Migrated from Schools.GA_NCLB_AR. |
NCLB_AS | 16.6.0 | Number(11,0) | The number of incidents of aggravated sodomy. Migrated from Schools.GA_NCLB_AS. |
NCLB_ASB | 16.6.0 | Number(11,0) | The number of incidents of aggravated sexual battery. Migrated from Schools.GA_NCLB_ASB. |
NCLB_FD | 16.6.0 | Number(11,0) | The number of incidents of felony drugs. Migrated from Schools.GA_NCLB_FD. |
NCLB_FDA | 16.6.0 | Number(11,0) | The number of incidents of first degree arson. Migrated from Schools.GA_NCLB_FDA. |
NCLB_FW | 16.6.0 | Number(11,0) | The number of incidents of felony weapons. Migrated from Schools.GA_NCLB_FW. |
NCLB_K | 16.6.0 | Number(11,0) | The number of incidents of kidnapping. Migrated from Schools.GA_NCLB_K. |
NCLB_M | 16.6.0 | Number(11,0) | The number of incidents of murder. Migrated from Schools.GA_NCLB_M. |
NCLB_NFD | 16.6.0 | Number(11,0) | The number of incidents of non-felony drugs. Migrated from Schools.GA_NCLB_NFD. |
NCLB_R | 16.6.0 | Number(11,0) | The number of incidents of rape. Migrated from Schools.GA_NCLB_R. |
NCLB_TT | 16.6.0 | Number(11,0) | The number of incidents of terroristic threats. Migrated from Schools.GA_NCLB_TT. |
NCLB_VM | 16.6.0 | Number(11,0) | The number of incidents of voluntary manslaughter. Migrated from Schools.GA_NCLB_VM. |
OnlineSchool | 16.6.0 | Number(1,0) | Indicates that the school is online only; all courses at the school will be considered online. Migrated from Schools.GA_OnlineSchool. |
PANDASiteID | 20.9.3 | Varchar2(5) | The PANDA ID associated with the school. |
SWCC_Homeless | 16.12.1 | Number(11,0) | The number of cases involving homeless students and families handled by social workers this school year. |
SWCC_SpecProg | 16.12.1 | Number(11,0) | The number of assemblies, lunch and learn, parent night presentations, etc. |
SWCC_SuicRef | 16.12.1 | Number(11,0) | The number of referrals received for children exhibiting signs of suicidal ideation. |
SWC_ADS | 16.6.0 | Number(11,0) | The number of academic support instances. Migrated from Schools.GA_SWC_ADS. |
SWC_AS | 16.6.0 | Number(11,0) | The number of child abuse and neglect services instances. Migrated from Schools.GA_SWC_AS. |
SWC_ASID | 16.6.0 | Number(11,0) | The number of attendance/dropout prevention services instances. Migrated from Schools.GA_SWC_ASID. |
SWC_DS | 16.6.0 | Number(11,0) | The number of school safety services instances. Migrated from Schools.GA_SWC_DS. |
SWC_FHPSS | 16.6.0 | Number(11,0) | The number of family/health/social services/homeless services instances. Migrated from Schools.GA_SWC_FHPSS. |
SWC_SE | 16.6.0 | Number(11,0) | The number of special education instances. Migrated from Schools.GA_SWC_SE. |
SWR_DFCS | 16.6.0 | Number(11,0) | The number of Department of Family and Children Services (DFCS) instances. Migrated from Schools.GA_SWR_DFCS. |
SWR_JC | 16.6.0 | Number(11,0) | The number of juvenile and other court instances. Migrated from Schools.GA_SWR_JC. |
SWR_MH | 16.6.0 | Number(11,0) | The number of mental health services instances. Migrated from Schools.GA_SWR_MH. |
SWR_Other | 16.6.0 | Number(11,0) | The number of community agencies instances. Migrated from Schools.GA_SWR_Other. |
SWR_PH | 16.6.0 | Number(11,0) | The number of health services instances. Migrated from Schools.GA_SWR_PH. |
SWS_AgencyVisits | 16.12.1 | Number(11,0) | The number of trips made by social workers this school year to agencies to impact, or gather information. |
SWS_CACR | 16.6.0 | Number(11,0) | The number of community agency consultations/referrals/crisis interventions instances. Migrated from Schools.GA_SWS_CACR. |
SWS_CrisisInterv | 16.12.1 | Number(11,0) | The number of single contacts in person, by phone, or mail involving life-threatening issues |
SWS_CWO | 16.6.0 | Number(11,0) | The number of conferences with school staff instances. Migrated from Schools.GA_SWS_CWO. |
SWS_CWPF | 16.6.0 | Number(11,0) | The number of conferences with parents/family instances. Migrated from Schools.GA_SWS_CWPF. |
SWS_CWS | 16.6.0 | Number(11,0) | The number of student interventions - Individual and Group instances. Migrated from Schools.GA_SWS_CWS. |
SWS_EAS | 16.6.0 | Number(11,0) | The number of Economic Aid Sessions instances. Migrated from Schools.GA_SWS_EAS. |
SWS_GrpInterv | 16.12.1 | Number(11,0) | The number of groups led or co led by social workers this year. |
SWS_HAV | 16.6.0 | Number(11,0) | The number of home/agency visits instances. Migrated from Schools.GA_SWS_EAS. |
SWS_MS | 16.6.0 | Number(11,0) | The number of mediation sessions instances. Migrated from Schools.GA_SWS_MS. |
T1SC | 16.6.0 | Varchar2(1) | Indicates school-wide Title I Assistance or use of a Targeted Assistance Title I program. Migrated from Schools.GA_T1SC. |