Student Address
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
---|---|---|---|---|---|---|---|
1 | Address Status | Download populates with value of A | M | 1 | N/A | ||
2 | Address Type | Download populates with value of 01 | M | 2 | N/A | ||
3 | Student ID | reg_personal.state_report_id | M | 9 | Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field | ||
4 | SAP ID | reg.student_id | O | 50 | Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID field | ||
5 | Legal Last Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | M | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field | ||
6 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | M | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field | ||
7 | Birth Date | reg.birthdate | M | 10 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field | ||
8 | RCDTS for Home School | reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS Or, reg_building.state_code_equiv for reg.alt_building Or, reg_building.state_code_equiv for reg_entry_with.building | M | 15 | The download goes through these steps:
| ||
9 | RCDTS for Serving School | reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = S_RCDTS Or, reg_building.state_code_equiv for reg_entry_with.building | M | 15 | The download goes through these steps: It checks to see if the student has an active program vector as of the Reporting Date for Serving School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides). If there is no active vector for this program, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building). | ||
10 | Street Address 1 | Concatenation of the following reg_contact fields: street_number + street_prefix + street_name + street_suffix + street_type Use the first 50 characters. | M | 50 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: House Number + Street Prefix + Street Name + Street Suffix + Street Type Address fields are available based on Administration > Registration Setup > Setup > Registration District Configuration > Historical Address Tracking panel | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. | |
11 | Street Address 2 | reg_contact.complex | O | 50 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: Complex field | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. | |
12 | Suite/Apt | reg_contact.apartment | O | 30 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: Apt field | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. | |
13 | City | reg_contact.city | M | 30 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: City field (unlabeled) | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. | |
14 | State | reg_contact.state | M | 2 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: State field (unlabeled) | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. | |
15 | Zip | reg_contact.zip | M | 9 | Registration > Entry & Reports > Student Demographic > Addresses > Addresses panel > Mailing Address section: Zip Code field (unlabeled) | To get the reg_contact record, use reg_stu_contact.contact_id where contact_type = M for the appropriate Student ID and District. |