Student Contact Fact 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 records
+ = Required only for specified records
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 "NY" + first 6 characters of state_code_equiv | Administration > General Setup > District > District: State Equivalency Code |
2 | *SCHOOL YEAR DATE | 9 – 18 | NYS Reporting | School Year Prompt-06-30 | Regulatory > Downloads > Downloads > NY Contact Download: School Year followed by -06-30 |
3 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 19 – 30 | NYS Reporting | reg_stu_contact.student_id | Registration > Entry & Reports > Student Demographic > Contacts > click appropriate Name link: ID |
4 | *CONTACT ID | 31 – 39 | NYS Reporting | reg_stu_contact.contact_id | Not visible in eSchoolPlus |
5 | *REPORTING DATE | 40 – 59 | NYS Reporting | School Year Prompt-06-30 | Regulatory > Downloads > Downloads > NY Contact Download: School Year followed by -06-30 |
6 | *CONTACT RELATIONSHIP CODE | 60 – 79 | NYS Reporting | regtb_relation.state_code_equiv where reg_stu_contact.relation_code = regtb_relation.code | Registration > Entry & Reports > Student Demographic > Contacts > click appropriate Name link > Student/Contact Relationship panel: Relationship |
7 | *CONTACT AUTHORIZATION CODE | 80 – 99 | NYS Reporting | Download populates with '01' |
|
8 | CONTACT SEQUENCE NUMBER | 100 – 102 | Local use only | reg_stu_contact.contact_priority | Registration > Entry & Reports > Student Demographic > Contacts: Priority |
9 | *ACTIVE INDICATOR | 103 – 105 | NYS Reporting | Download populates with 'Y' |
|
10 | PRIMARY CONTACT INDICATOR | 106 – 108 |
| Leave blank | N/A |
11 | STUDENT LIVES WITH CONTACT INDICATOR | 109 – 111 |
| Leave blank | N/A |
12 | EMERGENCY CONTACT INDICATOR | 112 – 114 |
| Leave blank | N/A |
13 | CONTACT RESTRICTIONS DESCRIPTION | 115 – 364 |
| Leave blank | N/A |