GUIDE Extract

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Report Start Date

Enrollment EntryDate >= Report Start Date

Report End Date

Enrollment EntryDate <= Report End Date

Student Type

Choose the appropriate value from the radio button list:

• All Students.
• Selected Students: Report will limit results to those within the current selection of students.
• Students without GTID: Report will limit results to students who have no GTID on file.
• Students without GTID or who have changed schools: Report will limit results to students who have no GTID on file or students with an enrollment record for a different school prior to an enrollment in the selected date range.

Add students based on Entry/Exit codes below

Select “Yes” to select additional students to the report based on the entry and exit code selections below. The students selected based on “Student Type” above are not affected.

Include students with current entry code

Select entry codes to add. Students who have a current enrollment with one of the selected entry codes are added to the extract. Available values are all entry codes defined in the district setup.

Include students where the previous enrollment has exit code

Select exit codes to add. Students whose previous enrollment has one of the selected exit codes are added to the extract. Available values are all exit codes defined in the district setup.

Record Type

Identifies record layout. Always

‘GID’

N/A

N/A

3

Fiscal Year

Fiscal year of record.

[Terms]LastDay

Yes

4

System Code

School System Code.

[Prefs]Value

[Prefs]Name=districtnumber

[CST_SUBDISTRICTS]SUBDISTRICT_NUMBER

Yes

3

School Code

The school code.

Note: The alternate school number is reported, if populated. Otherwise, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

Yes

4

GTID

The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.

Note: This field is null for students who have not yet been assigned a GTID.

[Students]State_StudentNumber

Yes

10

Student Last Name

The student last name.

Note: The legal last name field is extracted, if populated.

[Students]Last_Name

Yes

30

Student First Name

The student’s first name.

Note: The legal first name field is extracted, if populated.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]Last_Name

Yes

30

Student Middle Name

The Student’s middle name.

Note: The legal middle name is extracted, if populated.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

Yes

30

Student Name Suffix

The student’s legal name suffix.

Note: The legal name suffix is extracted, if populated.

Not Required

[StudentCoreFields]PSCore_Legal_Suffix 

Yes

3

Social Security Number/Student ID

Student’s SOCIAL SECURITY NUMBER or a state‐approved pseudo‐Social Security‐like number.

Note: Should be plain text format without any "-"s or "/"s. The report will remove these special characters if found.

[Students]SSN

Yes

9

Gender

The student's gender.

Note: The legal gender field is extracted, if populated.

[StudentCoreFields]PSCore_Legal_Gender 

[Students]Gender

Yes

1

Date of Birth

Date of student’s birth.

[Students]DOB

Yes

8

Ethnic Hispanic

Hispanic or Latino

Not part of race indicators. Identifies Hispanic ethnicity.

For definition, refer to the Data Element Detail document.

[Students]FedEthnicity

Yes

1

Race Indian

Indicates whether the student is American Indian or Alaska Native.

[StudentRace]Racecd=I

[StudentRace]StudentId

Yes

1

Race Asian

Indicates whether the student is Asian.

[StudentRace]Racecd=S

[StudentRace]StudentId

Yes

1

Race Black

Indicates whether the student is African American.

[StudentRace]Racecd=B

[StudentRace]StudentId

Yes

1

Race Pacific

Indicates whether the student is New Hawaiian or Other Pacific Islander.

[StudentRace]Racecd=P

[StudentRace]StudentId

Yes

1

Race White

Indicates whether the student is White.

[StudentRace]Racecd=W

[StudentRace]StudentId

Yes

1

Parent/Guardian Name

Indicates the first name and last name of a parent or guardian. Name format should be First Name space Last Name.

The report removes leading or trailing spaces from the mother or father names, while leaving the spaces between names as entered on the Demographics page.

Not Required

[Students]Mother

[Students]Father

[Students]Guardian_Ln

[Students]Guardian_Fn

No – Reference only and will be displayed to help the user make a decision during Near Match Resolution

60

School Entry Date

Date of the student’s entry into the school this school year.

[Students]EntryDate

Yes

8

Local ID

ID used in the local Student Information System to uniquely identify the student.

[Students]Student_Number

No

12

Middle Name Verification

Indicates the registrar has verified that the student has no middle name or has only a middle initial as verified against the student’s birth certificate.

If this data element is left blank, it will default to ‘0’ for ‘unverified’ in GUIDE.

[S_GA_STU_X]MiddleNameVerified

No

1

Filler

Filler

N/A

No

59