PSRW_HealthStudVision (ver6.2.0)
This view returns student health screening vision records.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Color_Blind_Test_Result | 6.2.0 | String50 | Colorblind test result derived from screening lookup table based on ColorBlindTestLUID. |
Comment | 6.2.0 | String512 | [From HealthStudVision] Comments on the Vision screening. |
Grade_Level | 6.2.0 | String6 | [From HealthStudVision] Grade level at screening. |
ID | 6.2.0 | Number | [From HealthStudVision] HealthStudVisionID. |
Late_Test_Indicator | 6.2.0 | Number | [From HealthStudVision] if vision test was conducted late then 1 else 0. |
Left_Eye_Result | 6.2.0 | String50 | Left eye test result derived from screening lookup table based on LeftEyeTestLUID. |
Outcome | 6.2.0 | String50 | Screening Outcome of the student from screening lookup table. |
Provider_Name | 6.2.0 | String30 | [From HealthStudVision] Name of the screening provider. |
Provider_Type | 6.2.0 | String50 | Provider type from HealthScreenLookup based on VisionScreenerTypeLUID. |
Referral_Date | 6.2.0 | Date | [From HealthStudVision] Date when student was referred. |
Right_Eye_Result | 6.2.0 | String50 | Right eye test result derived from screening lookup table based on RightEyeTestLUID. |
Screening_Date | 6.2.0 | Date | [From HealthStudVision] Date when screening was performed. |
ScreeningTypeID | 6.2.0 | Number | Unique ID given to each screening type Returns 4 for Vision. |
StudentID | 6.2.0 | Number | [From HealthMainStudRec] StudentID. |
Vision_Aid | 6.2.0 | String256 | [From HealthStudVision] Vision aid of the student. |