S_GA_STU_X (ver 14.7.0)
This table is an extension of the [Students] table. These fields are considered general data elements.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.7.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
| BiLitLanguage1 | 16.12.0 | Varchar2(3) | Indicates the first language learned for the Graduation Program of Study Bi-Literacy Language Seal. |
| BiLitLanguage2 | 16.12.0 | Varchar2(3) | Indicates the second language learned for the Graduation Program of Study Bi-Literacy Language Seal. |
| BiLitLanguage3 | 16.12.0 | Varchar2(3) | Indicates the third language learned for the Graduation Program of Study Bi-Literacy Language Seal. |
CityofBirth | 16.10.1 | Varchar2(60) | Migrated from Students.GA_CityofBirth |
| DiplomaSeal | 17.7.0 | Varchar2(1) | Indicates the Diploma Seal chosen by the student. |
DiplomaType | 16.10.1 | Varchar2(1) | Migrated from Students.GA_DiplomaType |
EntryDate_9th | 16.10.1 | Date | Migrated from Students.GA_9th_EntryDate |
FGRAM_ExePrintBodyComp | 16.10.1 | Number(1,0) | Migrated from Students.GA_FGRAM_ExePrintBodyComp |
FGRAM_PermExeCd | 16.10.1 | Varchar2(50) | Migrated from Students.GA_FGRAM_PermExeCd |
FGRAM_PrintRepInSpanish | 16.10.1 | Number(1,0) | Migrated from Students.GA_FGRAM_PrintRepInSpanish |
GraduationProgram | 15.12.0 | Varchar2(1) | Indicates type of diploma toward which a high school student is working. |
| GuardianIsGrandParent | 17.6.0 | Number(1,0) | Indicates whether the guardian is a grandparent. |
HomelessPrimaryShelter | 16.10.1 | Varchar2(1) | Migrated from Students.GA_HomelessPrimaryShelter |
Immigrant | 16.10.1 | Varchar2(1) | Migrated from Students.GA_Immigrant |
LT_3_YearsUSSch | 16.10.1 | Varchar2(1) | Migrated from Students.GA_LT_3_YearsUSSch |
MiddleNameVerified | 14.7.0 | Varchar2(2) | Indicates the student's middle name has been verified for GUIDE. |
Migrant | 16.10.1 | Varchar2(1) | Migrated from Students.GA_Migrant |
MilitaryParent | 16.10.1 | Number(1,0) | Migrated from Students.GA_Military_Parent |
OnlineEOGTest | 15.1.1 | Number(1,0) | Indicates if the student will take the End of Grade (EOG) test online. Only used for grades 3 through 8. |
OriginCountry | 16.10.1 | Varchar2(30) | Migrated from Students.NY_OriginCountry |
PlaceOfBirth | 16.10.1 | Varchar2(4) | Migrated from Students.GA_PlaceOfBirth |
| ParentCommunicationLang | 18.8.0 | Varchar2(3) | Indicates the parent's language preference for written communication. |
RESC | 16.10.1 | Varchar2(2) | Migrated from Students.GA_RESC |
ResidenceCounty | 16.10.1 | Varchar2(3) | Migrated from Students.county_residence |
ResidenceDistrict | 16.10.1 | Varchar2(3) | Migrated from Students.residence_district |
Residential_Environ | 16.10.1 | Varchar2(1) | Migrated from Students.GA_Residential_Environ |
ResStatusCode | 16.10.1 | Varchar2(1) | Migrated from Students.GA_ResStatusCode |
| SchoolNumberOverride | 17.4.0 | Varchar2(10) | Indicates the campus to be used in reporting, if set up, instead of the enrollment school. |
SpecNeedsCode | 16.10.1 | Varchar2(2) | Migrated from Students.GA_SpecNeeds_Code |
SST | 16.10.1 | Number(1,0) | Migrated from Students.GA_SST |
State_ExcludeEnrollment | 16.10.1 | Number(1,0) | Migrated from Students.State_ExcludeEnrollment |
StateofBirth | 16.10.1 | Varchar2(2) | Migrated from Students.GA_StateofBirth |
StudentStatus | 16.10.1 | Varchar2(1) | Migrated from Students.GA_StudentStatus |
| DateofELPScreener | 18.8.0 | Date | Date of ELP Screener |
| CareerAptitudeInv8thGrade | 18.8.0 | Varchar2(1) | Career Aptitude Inventory 8th Grade |
| CareerAptitudeInv10thGrade | 18.8.0 | Varchar2(1) | Career Aptitude Inventory 10th Grade |
| BiLiteracyDiplomaSeal | 19.8.2.0 | Varchar2(1) | BiLiteracy Diploma Seal |
| CivicEngagementDiplomaSeal | 19.8.2.0 | Varchar2(1) | Civic Engagement Diploma Seal |
| FineArtsDiplomaSeal | 19.8.2.0 | Varchar2(1) | Fine Arts Diploma Seal |
| InternationalSkillsDiploma | 19.8.2.0 | Varchar2(1) | International Skills Diploma Seal |
| CTAEEmployabilitySoftSkills | 19.8.2.0 | Varchar2(1) | CTAE Employability Soft Skills |
| CTAEPathwaySkillsSeal | 19.8.2.0 | Varchar2(1) | CTAE Pathway Skills Seal |
| CTAELeadershipSkillsSeal | 19.8.2.0 | Varchar2(1) | CTAE Leadership Skills Seal |
| ELPScreenerScore | 20.3.2.0 | Number(11,0) | ELP Screener Score |