Skip to main content
Skip table of contents

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.

JavaScript errors detected

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

If this problem persists, please contact our support.