Submit a Request File

The StudentTracker® Request File allows you to create custom cohort reports as well as confirm postsecondary enrollment and graduation of your non-graduate students. You can better track the postsecondary accomplishments of transfers, students who earned GEDs, and others by providing the last date the student was physically enrolled at your institution as the search date. Additionally, you’ll be able to track non-graduates since they are not included in your Graduate File submissions.

For example, you can determine where your 2008 and 2009 female students attended school after graduating through StudentTracker. You would create a Request File for this cohort and submit it to the Clearinghouse for processing.  Next, you’ll receive Processed Request File reports that confirm the subset of students’ postsecondary enrollment and graduation. Remember that Request Files can be submitted at any time, independent of the Graduate Files you submit, and are not stored in our database.



 

> Request File Formatting Requirements

Use the specified formatting requirements below for all StudentTracker® Request files, so that you can reduce errors and additional work while you prepare the files for submission.

Text Format

To ensure accurate processing, please format all non-date fields as text in order to retain leading zeroes. Also, you will need to keep the leading zeroes in the high school ACT code(s) in addition to any other numeric fields. You should follow these steps before you start.

1. Open a new Excel spreadsheet.

2. Highlight columns A through Y, then right-click your mouse and select “Format Cells.

3. In the popup box, make sure the Number tab is selected. Under the Category menu, select “Text.Click OK.

Excel_formatting.jpg

You must select text in order to retain leading zeroes in your ACT code, Requestor Return, Student ID, and Number of Semesters of Math Completed fields.

(The “Number of Semesters of Math Completed” field has a two-character limit and would not have an impact on the number of math semesters completed if the leading 0 is dropped. For example, the entry 00 would correct as 0, or 07 would correct as 7. This does not change the value.)

Date Format

Format your date fields as YYYYMMDD. If your dates are already in this format, you do not need to do anything. If they are not, you will need to create a custom format in Excel as follows.

1. Highlight cell E1 and columns G & H (hold down the CTRL or Control key to make multiple selections), right-click your mouse, and select “Format Cells.

2. In the Category menu of the Number tab, select “Custom.”

3. In the field under “Type,” enter “YYYYMMDD.”

4. Click OK.

image13.jpg



 

> Request File Step-By-Step Instructions

Once you have set up the correct formatting in Excel as shown above, there are five important steps in order to input, finalize, and submit your file to the National Student Clearinghouse.


Step 1: Enter Header Row (Row 1)

Columns marked with an asterisk (*) are required.

RF_-_header_row_graphic1.jpg

Column A = enter H3* (exactly 2 characters)

Column B = Your Account Code* — can be found on your account reference sheet (max. 10 characters)

Column C = Leave this field blank

Column D = Your Account Name* — can be found on your account reference sheet (max. 80 characters)

Column E = File Transmission Date* (date you are sending us the file – YYYYMMDD format) (exactly 8 characters)

Column F = enter SE* (max. 2 characters)

Column G = enter D* (max. 1 character)

Step 2: Enter Student Detail Rows (Beginning on Row 2)

You will enter each student’s information in its own row called a Detail Row. The first Detail Row should be placed in Row 2, directly under the Header Row.  The spacing requirements for the Header and Detail Rows are different; do not be concerned that the Header and Detail rows don’t line up.

Be sure to follow the help instructions for inputting the Detail Rows, including the specified column names and required data.

> Enter Columns A-I

Columns marked with an asterisk (*) are required. Otherwise, if information is unavailable, leave the field blank.  

image2.gif

Column A = enter D3* (exactly 2 characters)

Column B = Leave this field blank

Column C = Student’s First Name* (max. 40 characters)

Column D = Student’s Middle Name or Initial (no periods) (max. 40 characters)

Column E = Student’s Last Name* (max. 40 characters)

Column F = Student’s Name Suffix (use letters not numbers, e.g., Jr, I, II, III, IV, V) — do not include punctuation e.g. (.) periods. (max. 3 characters)

Column G = Student’s Date of Birth* (YYYYMMDD format) — please see “Date Format” under the formatting requirements above, if needed. (exactly 8 characters)

Column H = Student’s Last Date of Attendance* (YYYYMMDD format) — please see “Date Format” under the formatting requirements above, if needed. (exactly 8 characters)

Column I = 6-digit ACT Code* for the high school from which the student graduated or last attended — this can be found on your account reference sheet. (exactly 6 characters)

> Enter Columns J-S

Columns marked with an asterisk (*) are required. Otherwise, if information is unavailable, leave the field blank.

image5.gif

Column J = leave this field blank

Column K = Requestor Return Field (This is a Requestor Return field that allows for internal tracking. Any additional ID or tag associated with the student can be input here.) (max. 50 characters)

Column L = Student ID Number (ID number associated with this student by your school/district.) (max. 15 characters)

Column M = Gender (exactly 1 character)

  • M = Male
  • F = Female

Column N = Ethnicity: The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. (exactly 2 characters)

  • AM = American Indian or Native Alaskan
  • AS = Asian
  • BL = Black or African American
  • HI = Hispanic/Latino
  • PI = Native Hawaiian or Pacific Islander
  • WH = White
  • MU = Two or more races

Column O = Economically Disadvantaged Indicator: The student is identified as economically disadvantaged as dictated by the district/state. (exactly 1 character)

  • Y = Economically Disadvantaged
  • N = Not Economically Disadvantaged

Column P = 8th Grade State Assessment Result, Math: A standardized exam utilized by the state across all subordinate districts for assessment of student math skills at the eighth grade level. (exactly 1 character)

  • 1 = Does Not Meet Standards
  • 2 = Proficient/Meets Standards
  • 3 = Advanced/Exceeds Standards

Column Q = 8th Grade State Assessment Result, ELA/Reading: A standardized exam utilized by the state across all subordinate districts for assessment of student reading/language arts skills at the eighth grade level. (exactly 1 character)

  • 1 = Does Not Meet Standards
  • 2 = Proficient/Meets Standards
  • 3 = Advanced/Exceeds Standards

Column R = High School Assessment Result, Math: A standardized exam utilized by the state across all subordinate districts for assessment of student math skills at the terminal high school level. (exactly 1 character)

  • 1 = Does Not Meet Standards
  • 2 = Proficient/Meets Standards
  • 3 = Advanced/Exceeds Standards

Column S = High School Assessment Result, ELA/Reading: A standardized exam utilized by the state across all subordinate districts for assessment of student reading/language arts skills at the terminal high school level. (exactly 1 character)

  • 1 = Does Not Meet Standards
  • 2 = Proficient/Meets Standards
  • 3 = Advanced/Exceeds Standards
> Enter Columns T-Y

Columns marked with an asterisk (*) are required. Otherwise, if information is unavailable, leave the field blank.

image6.gif

Column T = English Learner or English as a Second Language Indicator: The student is identified as an English Learner or is learning English as a Second Language as defined by the district/state. (exactly 1 character)

  • Y = English Learner or English as a Second Language Indicator
  • N = Not English Learner or English as a Second Language Indicator

Column U = Number of Semesters of Math Completed: The total number of semesters of math instruction the student has completed, regardless of the designated level of the mathematics courses being counted. Non-traditional terms (summer school, after school programs, etc.) count towards this as long as the classes completed awarded credit to the student. (max. 2 characters)

Column V = Dual Enrollment Indicator: An indicator of whether the student is currently enrolled in postsecondary as well as secondary school coursework. (exactly 1 character)

  • Y = Dual Enrollment Indicator
  • N = Not Dual Enrollment Indicator

Column W = Disability Code: The individual is identified as being disabled (either physically or mentally) by the district/state. (exactly 1 character)

  • Y = Student is considered disabled as defined by the state education authority
  • N = Student is not considered disabled

Column X = Program Code: enter the program code; this is a Requester Return field that allows for internal tracking of specific high school, district, or state programs. (max. 50 characters)

Column Y = enter ED*: This is the end of student detail records; please enter ED for all student records in column Y. (exactly 2 characters)

Step 3: Enter Trailer Row

Columns marked with an asterisk (*) are required.

image3.gif

Enter the following characters in the Trailer Row, which follows the last line of student data and is the last row of the file. This line indicates that there are no additional student records included in the file.

Column A = enter T3* (exactly 2 characters)

Column B = enter the Excel row number for the Trailer Row* (max. 8 characters)

Step 4: Save the Excel File

1. In the File menu on the main toolbar, select “Save As.

2. On the “Save As” window, select the drive and/or directory where you would like to save the file.

3. Enter a file name (You can use underscores in your file name, but you should NOT use spaces or the following characters in your file name: ! @ # $ % ^ & * ( ) +)

4. Select “Text (Tab delimited).“

5. Click Save.

image5.jpg

You may find a popup window in Excel, stating that “the selected file type does not support workbooks that contain multiple sheets.” If so, click OK to save the active sheet.

IMPORTANT: Do not use these characters in your file name: ! @ # $ % ^ & * ( ) +

image6.jpg

You may also see a popup window that your file “may contain features that are not compatible with Text (Tab delimited)”. Click Yes to keep this format. Your file is now saved as a text, tab-delimited file (*.txt) in the location you selected.

image7.jpg

Step 5: Submit the File

Go to https://ftps.nslc.org/ to transmit your file to the Clearinghouse via your secure FTP account.

Do not email your files to the Clearinghouse. This is not a secure method of transferring data.

If you have questions or need further assistance, please see our secure FTP help or contact studenttracker@studentclearinghouse.org.

Save

Save

Save

Save

Was this article helpful?

Related Articles