DTAE Data Center; 03/09/2006Page 1 of 2
DRAFT: In progress as part of ongoing research project; not final specifications
Reports with Georgia Unemployment Insurance (UI) Records
______
1.) Graduates by Placement (DC192)
Criteria:Drilldown on a Placement Category to view those Graduates and their most recent UI data that is available through the summer quarter following the graduation fiscal year. Report contains duplicated graduates for those students who received more than one award, and also for students with multiple employers that UI quarter.
Fields in
Drilldown Report:Banner:Placement entered in Banner
Campus
Major Code
Major Description
Student ID
Student Name
Student's Graduation Term
UI:Quarter of UI data (most recent term available through summer following FY)
Industry of Employer (based on Standard Industrial Classification - SIC - codes)
Employer
Employer Address
______
2.) Graduates by Student (DC188)
Same criteria and fields as Report #1 (above), but there is no drilldown - all data is displayed in one report, sorted by student last name.
______
3.) Student Employment History (DC189)
Criteria:Enter a Fiscal Year and Student ID.
The student's name and major are provided for the fiscal year the report is run, along with all UI data available for 3 years:
- one year prior to FY for which report is run
- FY the report is run
- one year after FY the report is run
Fields:Banner:Student ID
Student Name
Latest Term student was enrolled for selected Fiscal Year
Primary Major Code - based on the latest term
Primary Major Description
Second Major Code - based on the latest term (if applicable)
Second Major Description (if applicable)
UI:Quarter of UI data (all quarters with a UI data match within the 3 year period)
Industry of Employer (based on Standard Industrial Classification - SIC - codes)
Employer
Employer Address
Quarterly Earnings (for that quarter and employer)
Annualized Earnings (quarterly earnings x 4; for that quarter and employer)
DTAE Data Center; 03/09/2006Page 2 of 2
DRAFT: In progress as part of ongoing research project; not final specifications
Reports with Georgia Unemployment Insurance (UI) Records(continued)
______
4.) Graduate Earnings by PAS Group (DC183)
Criteria:All Graduates and all UI data quarters available for the 4 quarters following each student's graduation term. Report contains duplicate records for graduates who received more than one award, and also for students with multiple employers in a quarter.
Fields in
Main Report:Banner:Campus
PAS Group Description
Total Unduplicated Graduates
For each PAS group:
UI:(A)Total Undup. Graduates with at least 1 Quarter Earnings >= $2,060
... $2,060/quarter is based on minimum wage $5.15/hr x 32 hour work week x 50 weeks and divided by 4
(B)Total Quarters Matched
... the number of quarters where the total of what each graduate earned was at least $2,060
(C)Sum of Quarterly Earnings of Matching Graduates
... the sum of wages for Quarters Matched in Column B
(D)Average Quarterly Earnings of Matching Graduates
... the "Sum of Quarter Earnings" from Column C divided by the "Total Quarters Matched" in Column B
(E)Average Annualized Earnings of Matching Graduates
... 4 x "Average Quarterly Earnings" in Column D
Fields in
Drilldown Report:For Campus and PAS group selected:
Banner:Major Code
Major Description
Student ID
Student Name
Student's Graduation Term
UI:Term of UI data (all quarters with a UI data match for 4 terms after grad term)
Industry of Employer (based on Standard Industrial Classification - SIC - codes)
Employer
Employer Address
Quarterly Earnings for that student, employer, and quarter