Student Contact File Layout
The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Student Contact file.
* = Required for all contacts
+ = Required only for specified contacts
Field # | FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name | Positions | NYS or Local Purpose | eSchoolPlus Table.Column | Where in eSchoolPlus? |
|---|---|---|---|---|---|
1 | *DISTRICT CODE (DISTRICT OF RESPONSIBILITY CODE) | 1-8 | NYS Reporting | reg_district.state_code_equiv If length is Not 8 or first character is Not "8", then "NY" + first 6 characters | Administration > General Setup > District > District: State Equivalency Code |
2 | *PRIMARY CONTACT ID | 9 – 17 | NYS Reporting | reg_stu_contact.contact_id | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Contact ID |
3 | *SCHOOL YEAR DATE | 18 – 27 | NYS Reporting | School Year Prompt-06-30 | Regulatory > Downloads > Downloads > NY Contact Download: School Year followed by -06-30 |
4 | *STATE CONTACT ID | 28 – 37 | NYS Reporting | reg_stu_contact.contact_id if Contact Download has Use Local ID as State Contact ID checked ny_contact.state_contact_id if Contact Download has Use Local ID as State Contact ID unchecked | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Contact ID Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > State Contact ID |
5 | LOCAL CONTACT ID | 38 – 97 |
|
|
|
6 | STATE PHOTO CARD ID | 98 – 157 |
|
|
|
7 | ALTERNATE CONTACT ID | 158 – 217 |
|
|
|
8 | CONTACT NAME PREFIX | 218 – 237 | NYS Reporting | reg_contact.title | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Title |
9 | *CONTACT FIRST NAME | 238 – 312 | NYS Reporting | reg_contact.first_name | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: First Name |
10 | CONTACT MIDDLE NAME | 313 – 387 | NYS Reporting | reg_contact.middle_name | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Middle Name |
11 | *CONTACT LAST NAME | 388 – 462 | NYS Reporting | reg_contact.last_name | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Last Name |
12 | CONTACT NAME SUFFIX | 463 – 472 | NYS Reporting | reg_contact.generation | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact: Generation |
13 | CONTACT GENDER CODE | 473 – 478 | NYS Reporting | Not Reported Currently |
|
14 | CONTACT ORAL LANGUAGE CODE | 479 – 494 | NYS Reporting | regtb_language.state_code_equiv converted from reg_contact.home_language | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > General panel: Home Language |
15 | CONTACT WRITTEN LANGUAGE CODE | 495 – 510 | NYS Reporting | regtb_language.state_code_equiv converted from reg_contact.language | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > General panel: Language of Correspondence |
16 | CONTACT HOME ADDRESS 1 | 511 – 550 | NYS Reporting | reg_contact.street_number + ' ' + reg_contact.street_prefix + ' ' + reg_contact.street_name + ' ' + reg_contact.street_suffix + ' ' + reg_contact.street_type | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: House Number + ' ' + Street Prefix + ' ' + Street Suffix + ' ' + Street Type |
17 | CONTACT HOME ADDRESS 2 | 551 – 590 | NYS Reporting | reg_contact.apartment + ' ' + reg_contact.complex | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: Apartment + ' ' Complex |
18 | CONTACT HOME ADDRESS 3 | 591 – 630 | NYS Reporting | Not Reported Currently |
|
19 | CONTACT HOME CITY | 631 – 660 | NYS Reporting | reg_contact.city | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: City |
20 | CONTACT HOME STATE CODE | 661 – 663 | NYS Reporting | reg_contact.state | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: State |
21 | CONTACT HOME POSTAL CODE | 664 – 690 | NYS Reporting | reg_contact.zip | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: Zip Code |
22 | CONTACT HOME STATE COUNTY NAME | 691 – 720 | NYS Reporting | Not Reported Currently |
|
23 | CONTACT HOME COUNTRY CODE | 721 – 724 | NYS Reporting | Not Reported Currently |
|
24 | CONTACT MAILING ADDRESS 1 | 725 – 764 | NYS Reporting | reg_contact.street_number + ' ' + reg_contact.street_prefix + ' ' + reg_contact.street_name + ' ' + reg_contact.street_suffix + ' ' + reg_contact.street_type | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: House Number + ' ' + Street Prefix + ' ' + Street Suffix + ' ' + Street Type |
25 | CONTACT MAILING ADDRESS 2 | 765 – 804 | NYS Reporting | reg_contact.apartment + ' ' + reg_contact.complex | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: Apartment + ' ' Complex |
26 | CONTACT MAILING ADDRESS 3 | 805 – 844 | NYS Reporting | Not Reported Currently |
|
27 | CONTACT MAILING CITY | 845 – 874 | NYS Reporting | reg_contact.city | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: City |
28 | CONTACT MAILING STATE CODE | 875 – 877 | NYS Reporting | reg_contact.state | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Address tab: State |
29 | CONTACT MAILING POSTAL CODE | 878 – 894 | NYS Reporting | reg_contact.zip | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Addresses panel: Zip Code |
30 | CONTACT MAILING STATE COUNTY NAME | 895 – 924 | NYS Reporting | Not Reported Currently |
|
31 | CONTACT MAILING COUNTRY CODE | 925 – 928 | NYS Reporting | Not Reported Currently |
|
32 | CONTACT HOME PHONE NUMBER | 929 – 952 | NYS Reporting | reg_contact_phone.phone where phone_type = H | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Phone panel: Phone Number for Phone Type H – Home |
33 | CONTACT WORK PHONE NUMBER | 953 – 976 | NYS Reporting | reg_contact_phone.phone where phone_type = W | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Phone panel: Phone Number for Phone Type W – Work |
34 | CONTACT MOBILE PHONE NUMBER | 977 – 1000 | NYS Reporting | reg_contact_phone.phone where phone_type = M | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Phone panel: Phone Number for Phone Type M - Mobile |
35 | CONTACT WORK EMAIL ADDRESS | 1001 – 1250 | NYS Reporting | reg_contact.email | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Email and Login panel: Email Address |
36 | CONTACT PERSONAL EMAIL ADDRESS | 1251 – 1500 | NYS Reporting | reg_contact.email | Registration > Entry & Reports > Student Demographic > Contacts > click Name link for contact > Email and Login panel: Email Address |