PSRW_HealthStudHearing (ver6.2.0)
This view returns student health screening hearing records.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Comment | 6.2.0 | String50 | [From HealthStudHearing] Comments on the hearing screening. |
Grade_Level | 6.2.0 | String6 | [From HealthStudHearing] Grade level at screening. |
Hearing_Aid | 6.2.0 | String256 | [From HealthStudHearing] Hearing aid of the student. |
ID | 6.2.0 | Number | [From HealthStudHearing] HealthStudHearingID. |
Impaired_Test_Indicator | 6.2.0 | Number | [From HealthStudHearing] if impaired hearing test was conducted then 1 else 0. |
Late_Test_Indicator | 6.2.0 | Number | [From HealthStudHearing] if hearing test was conducted late then 1 else 0. |
Left_Ear_Result | 6.2.0 | String50 | Left ear screening result for the student derived from screening lookup table. |
Outcome | 6.2.0 | String50 | Screening Outcome of the student from screening lookup table. |
Provider_Name | 6.2.0 | String30 | [From HealthStudHearing] Screening provider name. |
Provider_Type | 6.2.0 | String50 | Provider type from HealthScreenLookup based on HearingScreenerTypeLUID. |
Referral_Date | 6.2.0 | Date | [From HealthStudHearing] Date when student was referred. |
Right_Ear_Result | 6.2.0 | String50 | Left ear screening result for the student derived from screening lookup table. |
Screening_Date | 6.2.0 | Date | [From HealthStudHearing] Date at the time of screening. |
ScreeningTypeID | 6.2.0 | Number | Unique ID given to each screening type Returns 3 for Hearing. |
StudentID | 6.2.0 | Number | [From HealthMainStudRec] StudentID. |
Test_Type | 6.2.0 | String50 | Hearing test type performed for the student derived from screening lookup table. |