Pre-ID ACT Extract

On this page:

The Pre-ID ACT Extract generates a fixed-width text file, which can be used to upload pre-id information for the ACT test. Users should enter the ACT High School Organization Code on the Ohio State Information page (Start Page > District Setup > Schools/School Info > Ohio link) prior to running this extract.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Pre-ID ACT Labels Extract, student records are selected.

Student Selection

Active students who meet these criteria will be included:

state_grade_level is equal to 11
district_relationship is equal to 1
If a user selects to run based on a selection of students - use selection (regardless of grade_level)

Students who are marked to exclude from state reports, (State/Province – OH) Home tab > Exclude this student from all state reports) will be excluded.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report .

Field		Description
Schools for which to run?*		If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Students*		Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only – Run the report for students in the current selection All Students – (Default) Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Delivery Format		Select Online or Paper.
Test Code		Select one option: The ACT (mc) The ACT with writing (mw) The ACT writing only (w) WorkKeys (wk)
Scheduling
Run Now	Select this option to execute the report in the order it is received in the report queue.
Schedule	Enter the start date and start time for the report. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

ACT Field Name	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin/ End Position
Student Code		Blank: Generated at time of initial file load to ACT site		Filler	10	1–10
Organization code	High School ACT Code	Code entered on District>Schools/School Info> Ohio link. Note: Use the ACT high school code where the student is enrolled in to take the test.	[S_OH_SCH_X]ACT_Org_Code	Numeric	6	11-16
Filler		Blank		Filler	4	17-20
Last Name	Last Name	The student's last name - Valid characters are: A–Z a–z dash (-) apostrophe (‘) space The extract will remove any invalid characters, and the field is limited to 16 spaces.	[Students]Last_Name	Alpha-Numeric	16	21-36
First Name	First Name	The student's first name - Valid characters are: A–Z a–z dash (-) apostrophe (‘) space The extract will remove any invalid characters, and the field is limited to 10 spaces.	[Students]First_Name	Alpha-Numeric	10	37-48
Middle Initial	Middle Name	The student's middle name – Valid characters are: A–Z a–z Extract returns the first letter.	[Students]Middle_Name	Alpha	1	49-49
Grade	Grade Level	The student's grade level.	[Students]Grade_Level	Numeric	2	50-51
Date of Birth	Date of Birth	The student's date of birth -MM/DD/CCYY format	[Students]DOB	Date	10	52-61
State Student ID	SSID	The student's state-assigned student ID.	[Students]State_StudentNumber	Alpha-numeric	12	62-74
Filler		Blank		Filler	6	75-81
Local Student ID	Student Number	The student's number – lead zeroes if required to fill 9 spaces	[Students]Student_Number	Alpha-numeric	9	82-91
Filler		Blank		Filler	10	92-101
Gender	Gender	The student's gender	[Students]Gender	Alpha	1	102
Address	Student Address	The student's street address valid characters are: A-Z a-z 0-9 / space The extract will remove any invalid characters and will return only the first 25 spaces.	[Students]Street	Alpha-numeric	25	103-127
City	City	The student's city. The extract will return only the first 15 spaces.	[Students]City	Alpha	15	128-142
State	State	The student's state	[Students]State	Alpha	2	143-144
Zip Code	Zip Code	The student's zip code	[Students]Zip	Numeric	5	145-149
Test Code	ACT Test Code	Select on Report page in Parameters Required; Values are mc = The ACT, mw = The ACT with writing, w = The ACT writing only, wk = WorkKeys.		Alpha	2	150-151
Delivery Format	Paper or Online	Select on Report page in Paramenters Required: o = online and p = paper		Alpha	1	152
Optional State Use Questions		No data is returned		Filler		153-172
Reporting High School	School	School where student is currently enrolled.	[Students]SchoolID	Numeric	6	173-178
Student Test Code Key (UUID		Blank; For export only.		Filler	36	179-214
Contract Code		Blank: For export only.
Non-reportable college		Blank: For export only.