OHIO BOARD OF REGENTS

SGS/HEI Data Submissions

Workforce Development Grant Adjustment (WA) File
June 21, 2000

File Description

The Workforce Development Grant Adjustment (WA) file contains a record for a student account at SGS that is to receive an adjustment to increase or decrease a term amount, whether it has been disbursed or scheduled to for an upcoming disbursement. The record identifies the student and the details of the Workforce Development Grant Adjustment (WA). The school must have already submitted a WD file for the student for the academic year.

Submission Schedule

Files may be submitted as often as necessary, although we recommend submitting no more than once per academic term.

Capture Date

The capture date for the Workforce Development Grant Adjustment (WA) file is no later than the end of the academic year.

Relationship to Other File Submissions

The file is independent of all other files. However, the data in this file represent transactions for records that must have been submitted in a previous Workforce Development Certification (WD) file.

Data Fields (in all records except the file header record)

Field Names	Field Attributes and Procedures	Data Format
Student Identifier	Enter the federally assigned Social Security Number (SSN) whenever possible. If the SSN is unavailable, enter another identifier that uniquely relates to this student. For a given student, the same identifier must be used in all student related files.	Alphanumeric 9 characters Columns 1-9
Institution Assigned Identifier Switch	Enter Y if the student identifier was assigned by the institution and is not a federally assigned SSN. Enter N if the student identifier is the SSN assigned by the federal government.	Alphabetic 1 character Column 10 Uppercase
Adjustment Amount	Enter to the nearest dollar (no decimals) the amount of the adjustment to the amount previously certified for the term indicated in the Adjustment Term below.	Numeric 4 characters Columns 11-14
Adjustment Type	Enter the type of adjustment that the Adjustment Amount represents. R = reduction in amount previously certified. (The Adjustment Amount is to be subtracted from the Award Amount from the WD certification file.) I = increase in amount previously certified. (The Adjustment Amount is to be added to the Award Amount from the WD certification file.)	Alphabetic 1 character Column 15
Adjustment Term	Enter a code from Term Codes indicating the term to which the Adjustment Amount is applied.	Alphabetic 2 characters Columns 16-17

Additional Explanations

Adjustment Amount: Enter to the nearest dollar (no decimals) the amount by which the previously-certified amount is to be increased or decreased for the Adjustment Term. Do not include cents. For example, an adjustment of $64 must be reported as 0064.

Adjustment Type: An "R" will result in a refund to a previous disbursement or a decrease to an upcoming disbursement, by the amount of the adjustment. For example, the $64 adjustment with Adjustment Type = R, when applied to a $100 certification, will result in a net disbursement of $36 for the term. An "I" will result in an increase by the amount of the adjustment. For example, the $64 adjustment with Adjustment Type = I, when applied to a $100 certification, will result in a net disbursement of $164 for the term.

File Header Record

The first record of each file is a header record formatted as described in http://regents.ohio.gov/hei/datasubdoc/general/fileheader.html

The File Identifier to be used for this file is WA.

Return to SGS/HEI Files

http://regents.ohio.gov/hei/datasubdoc/finaid/wafile.html
Last updated August 17, 2000