PSSIS_Student_Demographics (ver5.0.0)
This view provides demographics information related to Students.
| 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_Level | 5.0.0 | Longint | [From Students] The Student's current grade level. Indexed. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Gender | 5.0.0 | String2 | [From Students] Gender indicator. Indexed. |
Ethnicity_Name | 5.0.0 | String50 | [From GEN] Ethnicity from the Gen table where category = 'Ethnicity'. |
Ethnicity_Code | 5.0.0 | String20 | [From Students custom field] The student's Primary Language as decoded in the CustomVarchars table. |
Special_Ed_Student | 5.0.0 | String3 | [From Students custom field] The student's Secondary Language as decoded in the CustomVarchars table. |
Current_Enroll_Status | 5.0.0 | String15 | [From Students] Enrollment status as a sting value, such as Inactive, Pre-registered, Active, etc. Indexed. |
Number_years_In_District | 5.0.0 | Longint | [From Demographic] Single Parent Household flag from Demographics. |
Middle_Name | 5.0.0 | String20 | [From Students] The students' middle name. |
Last_Name | 5.0.0 | String20 | [From Students] The students' last name. |
First_Name | 5.0.0 | String15 | [From Students] The students' first name. |
Date_Of_Birth | 5.0.0 | Date | [From Students] The students' date of birth. |
ClassOf | 5.0.0 | Longint | [From Students] The students' graduation class year. |
DistrictEntryDate | 5.0.0 | Date | [From Students] The date of entry into the district. |
DistrictEntryGradeLevel | 5.0.0 | Longint | [From Students] The students' grade level of entry into the district. |
DistrictofResidence | 5.0.0 | String20 | [From Students] The district in which the student resides. |
Exclude_From_Rank | 5.0.0 | String3 | [From Students] Exclude from ranking. |
Family_Ident | 5.0.0 | String30 | [From Students] Family identifier. |
Fee_Exemption_Status | 5.0.0 | String33 | [From Students] Fee exempt status indicator. |
Graduation_Req_Set | 5.0.0 | String40 | [From GradReqSets] The name of the graduation requirement set. |
Home_Phone | 5.0.0 | String30 | [From Students] The students' home phone number. Indexed. |
Locker_Combination | 5.0.0 | String20 | [From Students] The students' encrypted locker combination. |
Locker_Number | 5.0.0 | String15 | [From Students] The students' locker number. |
PhotoFlag | 5.0.0 | Longint | [From Students] The students' photo flag. |
SSN | 5.0.0 | String12 | [From Students] The students' social security number. |
Exclude_From_Reporting | 5.0.0 | String3 | [From Students] Exclude from state reporting flag. |
State_Enrolled | 5.0.0 | String3 | [From Students] The state enrolled flag. |
State_Student_Number | 5.0.0 | String20 | [From Students] The students' state-provided number. |
Allow_Web_Access | 5.0.0 | String3 | [From Students] Whether or not to allow web access. |
Web_ID | 5.0.0 | String20 | [From Students] The students' web ID. Indexed. |
Web_Password | 5.0.0 | Text | [From Students] The students' web password. Indexed. |
MembershipShare | 5.0.0 | Real | [From Students] The students' membership share as a fractional value. |