S_GA_STU_FTE_X (ver 14.7.2)
This table is an extension of the [Students] table. These fields are specific to Georgia FTE reporting. The field values are populated, or updated, by running the Refresh FTE Segments report. The field values are output when running the FTE October/March report.
Column Name | Version | Data Type | Description |
---|---|---|---|
STUDENTSDCID | 14.7.2 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
BLOCKSCHEDULE | 14.7.2 | Number(1,0) | How was the "Block Schedule" parameter set when the FTE Refresh was run. |
COURSESECTIONNUMBER1 | 14.7.2 | Varchar2(100) | Course which generated segment 1 (Course-Section). |
COURSESECTIONNUMBER2 | 14.7.2 | Varchar2(100) | Course which generated segment 2 (Course-Section). |
COURSESECTIONNUMBER3 | 14.7.2 | Varchar2(100) | Course which generated segment 3 (Course-Section). |
COURSESECTIONNUMBER4 | 14.7.2 | Varchar2(100) | Course which generated segment 4 (Course-Section). |
COURSESECTIONNUMBER5 | 14.7.2 | Varchar2(100) | Course which generated segment 5 (Course-Section). |
COURSESECTIONNUMBER6 | 14.7.2 | Varchar2(100) | Course which generated segment 6 (Course-Section). |
DUALENROLLTYPE1 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 1. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll1. |
DUALENROLLTYPE2 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 2. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll2. |
DUALENROLLTYPE3 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 3. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll3. |
DUALENROLLTYPE4 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 4. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll4. |
DUALENROLLTYPE5 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 5. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll5. |
DUALENROLLTYPE6 | 14.7.2 | Varchar2(2) | Student's Dual Enrollment Type for segment 6. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenroll6. |
DUALENROLLTYPEM1 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 1. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollm1. |
DUALENROLLTYPEM2 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 2. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollM2. |
DUALENROLLTYPEM3 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 3. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollM3. |
DUALENROLLTYPEM4 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 4. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollM4. |
DUALENROLLTYPEM5 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 5. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollM5. |
DUALENROLLTYPEM6 | 14.7.2 | Varchar2(2) | Manual Override for student's Dual Enrollment Type for segment 6. (Obsolete as of 2015-2016) Migrated from Students.GA_dualenrollM6. |
EXPANDMULTPERIODEXP | 14.7.2 | Number(1,0) | How was the "Expand Multiple Period Expressions" parameter set when the FTE Refresh was run. |
FISCALAGENT1 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 1. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt1. |
FISCALAGENT2 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 2. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt2. |
FISCALAGENT3 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 3. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt3. |
FISCALAGENT4 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 4.(Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt4. |
FISCALAGENT5 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 5.(Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt5. |
FISCALAGENT6 | 14.7.2 | Varchar2(1) | Student's Fiscal Agent for segment 6. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagnt6. |
FISCALAGENTM1 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 1. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM1. |
FISCALAGENTM2 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 2. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM2. |
FISCALAGENTM3 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 3. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM3. |
FISCALAGENTM4 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 4. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM4. |
FISCALAGENTM5 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 5. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM5. |
FISCALAGENTM6 | 14.7.2 | Varchar2(1) | Manual Override for student's Fiscal Agent for segment 6. (Obsolete as of 2015-2016) Migrated from Students.GA_fiscagntM6. |
FTECYCLE | 14.7.2 | Varchar2(10) | FTE Cycle entered when the FTE Refresh was run. Expected values: 1, 3. |
FTEDATE | 14.7.2 | Date | FTE Date entered when the FTE Refresh was run. |
GIFTEDDELIVERYMODEL1 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 1. Migrated from Students.GA_gifteddel1. |
GIFTEDDELIVERYMODEL2 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 2. Migrated from Students.GA_gifteddel2. |
GIFTEDDELIVERYMODEL3 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 3. Migrated from Students.GA_gifteddel3. |
GIFTEDDELIVERYMODEL4 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 4. Migrated from Students.GA_gifteddel4. |
GIFTEDDELIVERYMODEL5 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 5. Migrated from Students.GA_gifteddel5. |
GIFTEDDELIVERYMODEL6 | 14.7.2 | Varchar2(1) | Student's Gifted Delivery Model for segment 6. Migrated from Students.GA_gifteddel6. |
GIFTEDDELIVERYMODELM1 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 1. Migrated from Students.GA_GiftedDelModel1. |
GIFTEDDELIVERYMODELM2 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 2. Migrated from Students.GA_GiftedDelModel2. |
GIFTEDDELIVERYMODELM3 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 3. Migrated from Students.GA_GiftedDelModel3. |
GIFTEDDELIVERYMODELM4 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 4. Migrated from Students.GA_GiftedDelModel4. |
GIFTEDDELIVERYMODELM5 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 5. Migrated from Students.GA_GiftedDelModel5. |
GIFTEDDELIVERYMODELM6 | 14.7.2 | Varchar2(1) | Manual Override for student's Gifted Delivery Model for segment 6. Migrated from Students.GA_GiftedDelModel6. |
INCLUSIONCODE1 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 1. Migrated from Students.GA_Trans_Seg1. |
INCLUSIONCODE2 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 2. Migrated from Students.GA_Trans_Seg2. |
INCLUSIONCODE3 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 3. Migrated from Students.GA_Trans_Seg3. |
INCLUSIONCODE4 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 4. Migrated from Students.GA_Trans_Seg4. |
INCLUSIONCODE5 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 5. Migrated from Students.GA_Trans_Seg5. |
INCLUSIONCODE6 | 14.7.2 | Varchar2(1) | Student's Inclusion Code for segment 6. Migrated from Students.GA_Trans_Seg6. |
INCLUSIONCODEM1 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 1. Migrated from Students.GA_Trans_SegM1. |
INCLUSIONCODEM2 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 2. Migrated from Students.GA_Trans_SegM2. |
INCLUSIONCODEM3 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 3. Migrated from Students.GA_Trans_SegM3. |
INCLUSIONCODEM4 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 4. Migrated from Students.GA_Trans_SegM4. |
INCLUSIONCODEM5 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 5. Migrated from Students.GA_Trans_SegM5. |
INCLUSIONCODEM6 | 14.7.2 | Varchar2(1) | Manual Override for student's Inclusion Code for segment 6. Migrated from Students.GA_Trans_SegM6. |
ITINERANTTCHFLAG1 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 1. Migrated from Students.GA_Itinerant_Seg1. |
ITINERANTTCHFLAG2 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 2. Migrated from Students.GA_Itinerant_Seg2. |
ITINERANTTCHFLAG3 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 3. Migrated from Students.GA_Itinerant_Seg3. |
ITINERANTTCHFLAG4 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 4. Migrated from Students.GA_Itinerant_Seg4. |
ITINERANTTCHFLAG5 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 5. Migrated from Students.GA_Itinerant_Seg5. |
ITINERANTTCHFLAG6 | 14.7.2 | Number(1,0) | Student's Itinerant Teacher flag for segment 6. Migrated from Students.GA_Itinerant_Seg6. |
ITINERANTTCHFLAGM1 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 1. Migrated from Students.GA_Itinerant_SegM1. |
ITINERANTTCHFLAGM2 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 2. Migrated from Students.GA_Itinerant_SegM2. |
ITINERANTTCHFLAGM3 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 3. Migrated from Students.GA_Itinerant_SegM3. |
ITINERANTTCHFLAGM4 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 4. Migrated from Students.GA_Itinerant_SegM4. |
ITINERANTTCHFLAGM5 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 5. Migrated from Students.GA_Itinerant_SegM5. |
ITINERANTTCHFLAGM6 | 14.7.2 | Number(1,0) | Manual Override for student's Itinerant Teacher flag for segment 6. Migrated from Students.GA_Itinerant_SegM6. |
LASTFTEREFRESHDATE | 14.7.2 | Date | Date the FTE Refresh was last run. |
LOCATIONENROLLMENT1 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 1. Migrated from Students.GA_locenr1. |
LOCATIONENROLLMENT2 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 2. Migrated from Students.GA_locenr2. |
LOCATIONENROLLMENT3 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 3. Migrated from Students.GA_locenr3. |
LOCATIONENROLLMENT4 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 4. Migrated from Students.GA_locenr4. |
LOCATIONENROLLMENT5 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 5. Migrated from Students.GA_locenr5. |
LOCATIONENROLLMENT6 | 14.7.2 | Varchar2(1) | Student's Location Of Enrollment code for segment 6. Migrated from Students.GA_locenr6. |
LOCATIONENROLLMENTM1 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 1. Migrated from Students.GA_locenrM1. |
LOCATIONENROLLMENTM2 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 2. Migrated from Students.GA_locenrM2. |
LOCATIONENROLLMENTM3 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 3. Migrated from Students.GA_locenrM3. |
LOCATIONENROLLMENTM4 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 4. Migrated from Students.GA_locenrM4. |
LOCATIONENROLLMENTM5 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 5. Migrated from Students.GA_locenrM5. |
LOCATIONENROLLMENTM6 | 14.7.2 | Varchar2(1) | Manual Override for student's Location Of Enrollment code for segment 6. Migrated from Students.GA_locenrM6. |
PARTTIMESTUDENT | 14.7.2 | Number(1,0) | Flag to show the student has fewer than six segments. Other segments will be filled with a Non-funded code ("O"). Migrated from Students.GA_PartTimeCourse. |
PROGRAMCODE1 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 1. Migrated from Students.GA_prgcd1. |
PROGRAMCODE2 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 2. Migrated from Students.GA_prgcd2. |
PROGRAMCODE3 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 3. Migrated from Students.GA_prgcd3. |
PROGRAMCODE4 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 4. Migrated from Students.GA_prgcd4. |
PROGRAMCODE5 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 5. Migrated from Students.GA_prgcd5. |
PROGRAMCODE6 | 14.7.2 | Varchar2(1) | Student's FTE Program Code for segment 6. Migrated from Students.GA_prgcd6. |
PROGRAMCODEM1 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 1. Migrated from Students.GA_prgcdM1. |
PROGRAMCODEM2 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 2. Migrated from Students.GA_prgcdM2. |
PROGRAMCODEM3 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 3. Migrated from Students.GA_prgcdM3. |
PROGRAMCODEM4 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 4. Migrated from Students.GA_prgcdM4. |
PROGRAMCODEM5 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 5. Migrated from Students.GA_prgcdM5. |
PROGRAMCODEM6 | 14.7.2 | Varchar2(1) | Manual Override for student's FTE Program Code for segment 6. Migrated from Students.GA_prgcdM6. |
SUPPLSPEECHFLAG1 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 1. Migrated from Students.GA_supplspch_Seg1. |
SUPPLSPEECHFLAG2 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 2. Migrated from Students.GA_supplspch_Seg2. |
SUPPLSPEECHFLAG3 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 3. Migrated from Students.GA_supplspch_Seg3. |
SUPPLSPEECHFLAG4 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 4. Migrated from Students.GA_supplspch_Seg4. |
SUPPLSPEECHFLAG5 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 5. Migrated from Students.GA_supplspch_Seg5. |
SUPPLSPEECHFLAG6 | 14.7.2 | Number(1,0) | Student's Supplemental Speech flag for segment 6. Migrated from Students.GA_supplspch_Seg6. |
SUPPLSPEECHFLAGM1 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 1. Migrated from Students.GA_supplspch_SegM1. |
SUPPLSPEECHFLAGM2 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 2. Migrated from Students.GA_supplspch_SegM2. |
SUPPLSPEECHFLAGM3 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 3. Migrated from Students.GA_supplspch_SegM3. |
SUPPLSPEECHFLAGM4 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 4. Migrated from Students.GA_supplspch_SegM4. |
SUPPLSPEECHFLAGM5 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 5. Migrated from Students.GA_supplspch_SegM5. |
SUPPLSPEECHFLAGM6 | 14.7.2 | Number(1,0) | Manual Override for student's Supplemental Speech flag for segment 6. Migrated from Students.GA_supplspch_SegM6. |
TRANSPORTEDFLAG1 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 1. Migrated from Students.GA_stutransport_Seg1. |
TRANSPORTEDFLAG2 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 2. Migrated from Students.GA_stutransport_Seg2. |
TRANSPORTEDFLAG3 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 3. Migrated from Students.GA_stutransport_Seg3. |
TRANSPORTEDFLAG4 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 4. Migrated from Students.GA_stutransport_Seg4. |
TRANSPORTEDFLAG5 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 5. Migrated from Students.GA_stutransport_Seg5. |
TRANSPORTEDFLAG6 | 14.7.2 | Number(1,0) | Student's Transported flag for segment 6. Migrated from Students.GA_stutransport_Seg6. |
TRANSPORTEDFLAGM1 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 1. Migrated from Students.GA_stutransport_SegM1. |
TRANSPORTEDFLAGM2 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 2. Migrated from Students.GA_stutransport_SegM2. |
TRANSPORTEDFLAGM3 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 3. Migrated from Students.GA_stutransport_SegM3. |
TRANSPORTEDFLAGM4 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 4. Migrated from Students.GA_stutransport_SegM4. |
TRANSPORTEDFLAGM5 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 5. Migrated from Students.GA_stutransport_SegM5. |
TRANSPORTEDFLAGM6 | 14.7.2 | Number(1,0) | Manual Override for student's Transported flag for segment 6. Migrated from Students.GA_stutransport_SegM6. |
USEMANUAL | 14.7.2 | Number(1,0) | Flag to set student to use manual override values. Migrated from Students.GA_UserManualCheck. |