PSRW_HealthOfficeVisits (ver6.2.0)
This view returns data for student health office visits.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Actions | 6.2.0 | String512 | [From HealthOfficeVisits] Actions to be taken as a text field. |
Assessment | 6.2.0 | String512 | [From HealthOfficeVisits] office visit Assessment text. |
ID | 6.2.0 | Number | [From HealthOfficeVisits] HealthOfficeVisitID. |
Outcome | 6.2.0 | String50 | Office visit outcome Stringfrom HealthScreenLookup table based on OfficeVisitOutcomeLUID. |
Outcome_ID | 6.2.0 | Number | [From HealthOfficeVisits] OfficeVisitOutcomeLUID. |
ParentGuardian_Contact_Ind | 6.2.0 | Number | [From HealthOfficeVisits] IsGuardianContacted field indicates if parent or guardian can be contacted. |
Provider_Name | 6.2.0 | String30 | [From HealthOfficeVisits] Name of the screening provider. |
Provider_Type | 6.2.0 | String50 | Provider type derived from HealthScreenLookup table based on OfficeVisitScreenTypeLUID. |
StudentID | 6.2.0 | Number | [From HealthOfficeVisits] StudentID. |
Time_In | 6.2.0 | String8 | [From HealthOfficeVisits] Time In the office (format HH:MM AM/PM). |
Time_Out | 6.2.0 | String8 | [From HealthOfficeVisits] Time Out of the office (format HH:MM AM/ PM). |
Visit_Date | 6.2.0 | Date | [From HealthOfficeVisits] VisitDate field that stores date of office visit. |
Visit_Reason | 6.2.0 | String512 | [From HealthOfficeVisits] VisitReasonDesc indicates the reason of the visit text. |
Visit_Type | 6.2.0 | String30 | [From HealthOfficeVisits] Visit type derived from HealthScreenLookup based on VisitTypeLUID. |
Visit_Type_ID | 6.2.0 | Number | [From HealthOfficeVisits] derived from screening lookup table based on VisitTypeLUID. |