PSSIS_Student_Addresses (ver5.0.0)
This view provides information related to the various forms of Student Addresses for currently enrolled students. Specifically, the union of the Physical and Mailing addresses.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Current_Grade | 5.0.0 | Longint | [From Students] The Student's current grade level. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Current_Enroll_Status | 5.0.0 | String15 | [From Students] Enrollment status as a String value, such as Inactive, Pre-registered, Active, etc.). Indexed. |
Address_Type | 5.0.0 | String8 | [Derived] from the Physical and Mailing addresses. |
Street | 5.0.0 | String60 | [From Students] The Student's Street name. |
City | 5.0.0 | String50 | [From Students] The Student's City name. |
State | 5.0.0 | String2 | [From Students] The Student's State name. |
Zip | 5.0.0 | String10 | [From Students] The Student's Zip Code value. |