RTIm Direct Export

Modified on Thu, Jun 29, 2023 at 10:03 AM

Export Files

All 3 files are created as TAB delimited ASCII text files.

The first row contains headers.

These files are created for all students in the with an enrollment status code of ACTIVE.

Students are selected from schools that have the following flags set:

Column	Sample Data	Notes
GuardianID	123LRHOME	Student ID plus the word LRHOME
StudentID	123	Student ID
Prefix		Always blank
FirstName		Always blank
LastName	Mike Smith	Full Name of Guardian 1 contact
MiddleName		Always blank
HomePhone	732-555-1212	Guardian 1 Home Phone
WorkPhone	732-555-1212	Guardian 1 Work Phone
WorkPhoneExtension		Always Blank
MobilePhone	732-555-1212	Guardian 1 Home Cell Phone
EmailAddress	[email protected]	Guardian 1 E-Mail Address
Relationship	Father	Guardian 1 Relation ship description
NativeLanguage	English	Student Home Language
Translator	N	Always N
Primary	1	Always 1 (Student lives with Guardian)

Column	Sample Data	Notes
StudentID	123	Student ID
Statewide Student ID	1234567	State ID Number (SID)
FirstName	Caitlin	Student First Name
LastName	Zinn	Student Last Name
MiddleName	Rosa	Student Middle Name
SSN	123-45-6789	Student SSN
Gender	0	0=Male / 1=Female
Birthdate	1/1/2004	m/d/yyyy
Ethnicity	White	Student Primary Ethnicity Description
NativeLanguage	English	Student Native Language Description
Translator	N	Always N
DesignatedLEP	0	0=Not LEP. 1=LEP (If LEP code exists on student and does not contain the letter F)
SpecialAlerts		Always blank
CurrentGrade	02	-1 if Grade is 3F,4F,3H,4H. 0 is Grade contains the letter K. Otherwise the gradeLevel with a leading 0.
StudentType	0	0 = Maintstream. 2 = Special Ed (Student Special Ed Flag is set to YES)

Column	Sample Data	Notes
GuardianID	123LRHOME	Student ID plus the word LRHOME
StudentID	123	Student ID
AddressType	1	Always 1
Address1	1313 Mockingbird Lane.	Mailing Line 1 of Guardian 1 Address
Address2	Suite 7	Mailing Line 2 of Guardian 1 Address
City	Simple Town	City of Guardian 1 Address
State	NJ	State of Guardian 1 Address
Zip	08836	ZIP of Guardian 1 Address
County	Warren	Description from COUNTY_CODES in Codes.Setup.County Codes. The word "unkown" if it cannot be found in that table
Country	United States	Always United States