PSRW_HealthStudOral (ver6.2.0)
This view returns student health screening oral records.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Comment | 6.2.0 | String512 | [From HealthStudOral] Comments on the oral screening. |
Grade_Level | 6.2.0 | String6 | [From HealthStudOral] Grade level at the time of screening. |
HistoryOfCaries | 6.2.0 | Number | [From HealthStudOral] Is history of caries present? |
ID | 6.2.0 | Number | [From HealthStudOral] HealthStudOralID. |
Malocclusion | 6.2.0 | Number | [From HealthStudOral] Is malocclusion present? |
Outcome | 6.2.0 | String50 | Screening Outcome of the student from screening lookup table. |
Provider_Name | 6.2.0 | String30 | [From HealthStudOral] Name of the screening provider. |
Provider_Type | 6.2.0 | String50 | Provider type derived from HealthScreenLookup based on OralScreenerTypeLUID. |
Screening_Date | 6.2.0 | Date | [From HealthStudOral] ScreenDate indicates the date screening was performed. |
ScreeningTypeID | 6.2.0 | Number | Unique ID given to each screening type Returns 2 for Oral. |
Sealants | 6.2.0 | Number | [From HealthStudOral] Is dental sealant present? |
StudentID | 6.2.0 | Number | [From HealthMainStudRec] StudentID. |
TreatmentUrgency | 6.2.0 | String50 | Treatment Urgency text from the screening lookup table. |
UntreatedCaries | 6.2.0 | Number | [From HealthStudOral] Is untreated caries present? |