July 10, 2018 In 2006-07, the OSRHE Financial Aid Database Project - - PowerPoint PPT Presentation
July 10, 2018 In 2006-07, the OSRHE Financial Aid Database Project began with the collection of financial aid information for individual students at Oklahoma public colleges and universities. The report replaced the OCR and Tuition
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA
Properly coding your awards allows us to know what type of aid each code represents.
Description OSRHE Code Institution Code Type See the award (fund) code table for standard coding scheme. Your individual college award (fund) code See standard coding scheme explanation below Freshman Academic Scholarship RTW-S FRA (your code) IMUG Marching Band Scholarship RTW-T 120 ITUG Foundation Scholarship-Myers 555 DMFG Senior Scholarship RTW-S 346 IMUG FSEOG Tuition Waiver RTW-FNEED 591 INUG Federal Direct Student Loan-Subsidized FDSL SUB DSL FNFL Federal Direct Student Loan-PLUS FDSL PLUS DPL EXCF Citibank LOANS-PVT CITI EXCA
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA Position 1–Source Position 2–Basis **Position 3–Fund Type Position 4–Award Type I = Institutional N = Need-based F = Federal M = Academic merit- C = Campus-based based S = State of Oklahoma T = Talent-based T = Tribal O = Other, including D = Institution’s awards of Foundaton circumstance and O = Other outside unknown basis agencies (other states, community foundations, private scholarships, etc.) F = Cash awards and Tuition Waivers Not Subject to 3.5% limit U = Tuition waivers subject to 3.5% limit R = Room/board source G = Gift L = Loan W = Work *EXCF – Unsub, PLUS *EXCA – Private Loans
**Please code Position 3 above: F= All cash awards and tuition waivers not subject to the 3.5% limitation. U=All tuition waivers subject to the 3.5% limitation. R=All room and/or board waivers (meaning no cash is involved-funds are simply not collected).
Description OSRHE Code Inst Code Type State Regents Academic Scholars Program Regional University Baccalaureate Scholarship ASP RUBS SMFG SMFG
Description OSRHE Code Inst Code Type Financial Need - Subject to 3.5% Limit RTW-FNEED INUG Scholarship Merit - Subject to 3.5% Limit RTW-S IMUG Scholarship Talent - Subject to 3.5% Limit RTW-T ITUG Benefits Eligible Employees - Subject to 3.5% Limit RTW-BEE IOUG Other Resident Tuition Waivers - Subject to 3.5% Limit RTW-OTHER IOUG Auditing of Classes by Senior Citizens - Age 65 and over RTW-ACSC IOFG Prisoners of War/Persons Missing in Action and dependents RTW-POWMIA IOFG Children of Oklahoma Peace Officers, Firefighters, Emergency Medical Technicians & Members of the Oklahoma Law Enforcement Retirement System RTW-OPOF IOFG Graduate Teaching and Research Assistants RTW-GTRA IMFG State Regents Academic Scholars Program RTW-ASP IMFG National Guard Scholarship RTW-NG IOFG Regional University Baccalaureate Scholarships RTW-RUBS IMFG Students Called to Active Duty RTW-SCAD IOFG Students in Custody of DHS - Independent Living Act RTW-ILA IOFG Concurrently Enrolled High School Seniors - 6 hrs/semester RTW-CEHSS IOFG
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA
Description Inst Code Type Miscellaneous Scholarship MISC OOFG Miscellaneous Loan MISC ONFL William P. Willis WPW RSCH SMFG Academic Scholars Program ASP RSCH SMFG
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA
Description OSRHE Code Inst Code Type
Academic Scholarship ?
Your code
? John T. Simon Award ?
Your code
? Legacy Tuition Waiver-Res. ?
Your code
? Non-Resident Academic TW ?
Your code
? Newman Civic Fellow ?
Your code
? OTAG ?
Your code
?
?
Your code
? Comanche Nation Scholarship ?
Your code
? Pell Grant ?
Your code
? FSEOG TW ?
Your code
?
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA ISIR Fields provided by OSRHE Calculated data UDS Institutions Institutional Data File Layout Reference Line Columns Variable Name Data Variable Description Type Size Student Bio Information and Status 1 1-3 INST_CODE C 3 UDS Reporting Institution's Code 2 4-12 SITE_CD C 9 Campus site if the institution is a multi-site facility and has different COA budgets for each site. 3 13-27 STUDENTID C 15 The institution's unique key for each student record 4 28 ASSIGNED SSN FLAG C 1 0='Real' SSN. 9=School-Assigned SSN 5 29-37 SS_NUMBER C 9 Student's Social Security Number. If unavailable, use the UDS defined procedure to turn a student ID into an SSN format. This is required. 6 38-41 YEAR C 4 Calendar year (e.g. “2018” indicates a semester during the 2018 calendar year) 7 42 TERM C 1 Academic term (F=Fall, S=Spring U=Summer)
zyxwvutsrqponmlkjihgfedcbaZYXWVUTSRQPONMLKJIHGFEDCBA ISIR Fields provided by OSRHE Calculated data UDS Institutions Packaging Information 15 125-134 AWD_CD1 C 10 Institutional code for student's 1st award received 16 135-140 AWD_AMT1 N 6 Corresponding award amount for 1st award (no cents) 17 141-150 AWD_CD2 C 10 Institutional code for student's 2nd award received 18 151-156 AWD_AMT2 N 6 Corresponding award amount for 2nd award 19 157-166 AWD_CD3 C 10 Institutional code for student's 3rd award received 20 167-172 AWD_AMT3 N 6 Corresponding award amount for 3rd award 21 173-182 AWD_CD4 C 10 Institutional code for student's 4th award received 22 183-188 AWD_AMT4 N 6 Corresponding award amount for 4th award 23 189-198 AWD_CD5 C 10 Institutional code for student's 5th award received 24 199-204 AWD_AMT5 N 6 Corresponding award amount for 5th award 25 205-214 AWD_CD6 C 10 Institutional code for student's 6th award received 26 215-220 AWD_AMT6 N 6 Corresponding award amount for 6th award 27 221-230 AWD_CD7 C 10 Institutional code for student's 7th award received 28 231-236 AWD_AMT7 N 6 Corresponding award amount for 7th award
In early October, I will send out last year’s final code list for your school together with a blank worksheet for contact information and a blank worksheet for basic budget (COA) information for the year. The code list, contact and budget information are due in mid-November. Generally, data is due around the end of November. Please submit this data in a secure way. You can use SFTP (the same method used to submit your UDS enrollment, course, staff, etc. data). You can also use O-SAFE if you have a username and password for that site. Quality Control (QC) reports will be sent to you for your evaluation. Since some time may pass, keep in mind that some of the amounts may vary
Irala or Gayle to see what might be the issue and to determine if a re-submit is
the state program reports indicate was paid to your school. The e-mail sent with the QC may indicate possible issues.
Submitting Data:
Summer 2018).
convention:
udsi sins nstcode de.fin. n.semester.ycal alenda ndaryear ar.da data a
For example:
uds123.fin.F.y2017.data is Northwestern Oklahoma State University fall 2017 data
uds140.fin.S.y2018.data is Connors State College spring 2018 data
uds130.fin.U.y2018.data is Cameron University summer 2018 data