Additional Tools

For additional information, please contact Kris Munze at (800) 862-7759 or kris@nrccua.org

2013-14 NRCCUA Student Record File Layout

The 2014 NRCCUA Student Record File Layout integrates all NRCCUA student data services into one uniform file layout.

Click here to review what's been changed in the 2013-14 layout.

* Please note that this documentation represents changes to the layout and answer codes effective August 5, 2013.

Service

Program specific fields will be displayed in a bold-face maroon font.

 Field  Length  Position  Description  
DataSource 10 1-10 Data Source Indicator Talent Identification Program®
ResponseType 10 11-20 Response Type Indicator
ResponseDate 10 21-30 Student Response Date
OrderNumber 6 31-36 Order Number
GroupId 2 37-38 Order Group ID
Sequence 8 39-46 Unique Student ID
StudentPin 7 47-53 Unique PIN for Text Message and Online responses
FirstName 40 54-93 Student First Name
MiddleInitial 1 94 Student Middle Initial
LastName 40 95-134 Student Last Name
Suffix 8 135-142 Student Suffix
Address 64 143-206 Primary Address
Address2 24 207-230 Secondary Address Components
City 30 231-260 City
State 2 261-262 State
Zipcode 5 263-267 5-digit ZIP code
Zip4 4 268-271 ZIP + 4 code
CarrierRoute 4 272-275 Carrier Route Code
DeliveryPoint 2 276-277 Delivery Point for Bar Code
CheckDigit 1 278 Check Digit for Bar Code
County 3 279-281 County Code ANSI County Code
Email 75 282-356 Student Email
Phone 10 357-366 Student Phone Number
CellPhone 10 367-376 Student Cell Phone Number
HighSchoolName 60 377-436 High School Name
HighSchoolType 1 437 High School Type
Ceeb 6 438-443 ACT Number/CEEB High School Code
Mdrpid 8 444-451 MDR High School Code
BirthDate 10 452-461 Birth Date MM/DD/YYYY
Gender 1 462 Gender Code M=Male F=Female
GraduationYear 4 463-466 Graduation Year (4-Digit)
GPA 2 467-468 Grade Point Average
Ctype01 10 469-478 College Type Preference
Ctype02 10 479-488
Ctype03 10 489-498
Ctype04 10 499-508
Special01 10 509-518 Specialized College Preference
Special02 10 519-528
Special03 10 529-538
Hsprep01 10 539-548 High School Prep Courses
Hsprep02 10 549-558
Hsprep03 10 559-568
Hsprep04 10 569-578
Hsprep05 10 579-588
Hsprep06 10 589-598
Hsprep07 10 599-608
Hsprep08 10 609-618
Major01 10 619-628 Career Interest/Intended Majors
Major02 10 629-638
Activity01 10 639-648 College Activity Participation
Activity02 10 649-658
Activity03 10 659-668
Activity04 10 669-678
Activity05 10 679-688
Activity06 10 689-698
Activity07 10 699-708
Activity08 10 709-718
Activity09 10 719-728
Activity10 10 729-738
Activity11 10 739-748
Activity12 10 749-758
Activity13 10 759-768
Activity14 10 769-778
Sport01 10 779-788 College Varsity Sports Participation
Sport02 10 789-798
Sport03 10 799-808
Sport04 10 809-818
Sport05 10 819-828
Sport06 10 829-838
Sport07 10 839-848
Sport08 10 849-858
Sport09 10 859-868
Sport10 10 869-878
Denom01 10 879-888 Denominational College Preference
Denom02 10 889-898
Envir 10 899-908 Campus Environment Preference
Race01 10 909-918 Racial or Ethnic Background
Race02 10 919-928
Race03 10 929-938
Race04 10 939-948
Race05 10 949-958
Race06 10 959-968
Race07 10 969-978
Race08 10 979-988
Mplans01 10 989-998 Military Plans
Mplans02 10 999-1008
Mplans03 10 1009-1018
Mplans04 10 1019-1028
Mplans05 10 1029-1038
Mplans06 10 1039-1048
Mplans07 10 1049-1058
Mbranch01 10 1059-1068 Military Branch Preference
Mbranch02 10 1069-1078
Mbranch03 10 1079-1088
Mbranch04 10 1089-1098
Mbranch05 10 1099-1108
HouseholdReligion 10 1109-1118 Household Religion Indicator
HbcInterest 1 1119 Indicated interest in attending historically black college
DidParentAttend 1 1120 Parent attended college
Keycode 10 1121-1130 Key Code
ModelScore 4 1131-1134 Model Score SMART Approach®
SmartIncome 6 1135-1140 Estimated Average Household Income
Cluster 2 1141-1142 Dominant Personicx Cluster
ACTEnglish 2 1143-1144 ACT English Score My College Options® Outreach Program
ACTMath 2 1145-1146 ACT Math Score
ACTReading 2 1147-1148 ACT Reading Score
ACTScience 2 1149-1150 ACT Science Score
ACTComposite 2 1151-1152 ACT Composite Score
SATMath 3 1153-1155 SAT Math Score
SATReading 3 1156-1158 SAT Reading Score
SATWriting 3 1159-1161 SAT Writing Score
SATComposite 4 1162-1165 SAT Composite Score
ClassRank 5 1166-1170 Class Rank
ClassSize 5 1171-1175 Class Size
Parent1FirstName 20 1176-1195 Parent 1 First Name My College Options® Declared Student Connection
Parent1LastName 20 1196-1215 Parent 1 Last Name
Parent1Email 50 1216-1265 Parent 1 Email Address
Parent2FirstName 20 1266-1285 Parent 2 First Name
Parent2LastName 20 1286-1305 Parent 2 Last Name
Parent2Email 50 1306-1355 Parent 2 Email Address
ClickInquiry 1 1356 Clicked an Inquiry Link My College Options® Automated Online Search
ClickApply 1 1357 Clicked Apply to College Link
ClickScheduleVisit 1 1358 Clicked Schedule a Visit Link
VisitedCampus 1 1359 Student has visited campus
IsUpdated 1 1360 Updated record information since last delivery
AlumniId 15 1361-1375 Alumni Unique ID Legacy Student Locator®
AlumniLastName 20 1376-1395 Alumni Last Name
AlumniAddress 64 1396-1459 Alumni Primary Address
AlumniZipcode 5 1460-1464 Alumni 5-digit ZIP code
IsNoCharge 1 1465 No Charge Indicator
BRCScanDate 10 1466-1475 Scanned Reply Card Entry Date MM/DD/YYYY
UserDef01 250 1476-1725 User Defined Data My College Options® Outreach Program
UserDef02 100 1726-1825 User Defined Data
UserDef03 50 1826-1875 User Defined Data
UserDef04 50 1876-1925 User Defined Data
UserDef05 10 1926-1935 User Defined Data
UserDef06 10 1936-1945 User Defined Data
Note:

The field length is most useful for comma delimited format, and the field position is most useful for fixed format.

Connect with NRCCUA on Twitter Facebook
Site Map | About | Contact Us | Careers At NRCCUA
Home | College Professionals | High School Educators | My College Options | Privacy Statement
This site is protected by copyright and trademark laws under U.S. and International law. All rights reserved. ©2014 NRCCUA®