Spreadsheet: 0006a957-54c7-4b74-9b8e-b1aaa8cd4760
Sheet: Sheet1

USOE Out of School Youth Graduation Report #3 for School year 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
SAMPLE REPORT TEMPLATE - Edited 5/3/2011
For period 9/15/2011 - 9/30/2011
Query was run on 10/3/2011
Source: USOE Adult Education Database and NRSPro GED Database
Published to ftp site 10/3/2011
Notes
● IT district personnel who are Clearing House liaisons - Please pass this file to the person(s) in your district who are responsible for changing exit codes to completer codes.
● School personnel responsible for changing and submitting Exit Status Change Records in the Clearinghouse File will need to change exit codes to completer codes.  GG is to be used as the completer code for GED achievement and GC is to be used for an Adult Education Carnegie unit [NAME].
● The LEA only has until October 15 to make changes to the completer codes via ES records in the Clearinhouse file.
● Important -This information/list contains confidential student information. It should be guarded and reviewed as confidential.
● This file will only be on line until 10/6/2011 @ 5:00 pm
Business Rules
Ages of youth are 16, 17, 18, or 19 on July 1, 2009.
Graduation means they either obtained a “Utah High School Completion Diploma” (GED) or an “Adult Education Secondary Diploma” (Carnegie-Unit diploma in Utah’s Adult Education program) in the State of Utah during this time period.
This report contains new and changed records. If a record has already been reported to you this year but has changed, the changed record will be listed here with the flag "Record has changed since earlier report this year" set.
TAB 1 of Report "Graduates"
One row per student
 |  | [NAME] |  |  |  |  |  |  |  | Date | Date | GED | Adult Education Collected/Matched Information |  |  |  | Record has
School | Report | Record |  |  |  |  |  |  |  | GED | Diploma | Record | Probable | Probable | Probable | Probable | changed since
Year | Number | Number | LastName | FirstName | MiddleName | SSN | DOB | Gender | Age | Achieved | Achieved | Number | SSID | LastLEA# | LastSchool# | LastLEAStudent# | earlier report
2010 | 3 | 1234 | Doe | [NAME] | [NAME] | 5674 | 1990-01-01 00:00:00 | F | 19 |  | 2010-06-09 10:25:02.163000 |  | 8888888 |  |  |  | 1
TAB 2 of Report - "Graduates K-12 Enrollment History"
Multiple rows per student
Cactus         Cactus | LEA |  |  |  |  |  |  |  |  | Date GED | Date Diploma | [NAME]
LEA#            School# | Student#           SSID# | AdultEdRecordNum | LastName | FirstName | MiddleName | SSN | DOB | Gender | Age | Achieved | Achieved | Number
1                    234 | 12345               8888888 | 1234 | Doe | [NAME] | [NAME] | 567 | 1990-01-01 00:00:00 | F | 19 |  | 2010-06-09 10:25:02.163000
1                    235 | 12345               8888888 | 1234 | Doe | [NAME] | [NAME] | 567 | 1990-01-01 00:00:00 | F | 19 |  | 2010-06-09 10:25:02.163000
2                    236 | 5678                 7777777 | 1234 | Doe | [NAME] | [NAME] | 567 | 1990-01-01 00:00:00 | F | 19 |  | 2010-06-09 10:25:02.163000