PSRW_HealthStudTuberculosis (ver6.2.0)
This view returns student health screening TB records.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Comment | 6.2.0 | String512 | [From HealthStudTB] Comments on the TB screening. |
Grade_Level | 6.2.0 | String6 | [From HealthStudTB] Grade level at screening. |
ID | 6.2.0 | Number | [From HealthStudTB] HealthStudTBID. |
Induration_Size | 6.2.0 | Number | [From HealthStudTB] Screening test induration. |
Outcome | 6.2.0 | String50 | Screening Outcome of the student from screening lookup table. |
Provider_Name | 6.2.0 | String30 | [From HealthStudTB] ScreenerName. |
Provider_Type | 6.2.0 | String50 | Provider type from HealthScreenLookup based on TBScreenerTypeLUID. |
Screening_Date | 6.2.0 | Date | [From HealthStudTB] ScreenDate. |
ScreeningTypeID | 6.2.0 | Number | Unique ID given to each screening type Returns 5 for Scoliosis. |
Skin_Test_Given_Date | 6.2.0 | Date | [From HealthStudTB] Date when student skin test was given. |
Skin_Test_Read_Date | 6.2.0 | Date | [From HealthStudTB] Date when student skin test was read. |
Skin_Test_Result | 6.2.0 | String50 | Provider type from HealthScreenLookup based on ImpressionResultLUID. |
Skin_Test_Type | 6.2.0 | String50 | Provider type from HealthScreenLookup based on SkinTestTypeLUID. |
StudentID | 6.2.0 | Number | [From HealthMainStudRec] StudentID. |
Xray_Film_Date | 6.2.0 | Date | [From HealthStudTB] Date chest x-ray was performed. |
Xray_Film_Impression | 6.2.0 | String50 | Chest x-ray impression from HealthScreenLookup based on ChestXrayImpresLUID. |