HealthOfficeVisit (ver6.1.0.1)
Used to track the purpose of a visit to the health office.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| AccidentComments | 20.4.0 | Varchar2(4000) | If used, contains the nurse's notes on an accident being treated. |
| AccidentSetting | 20.4.0 | Number(16) | Optional field containing a codesetid of type AccidentSetting. |
Actions | 23.7.0 | Varchar2(2048) | A description of the action taken. |
Assessment | 23.7.0 | Varchar2(2048) | An assessment that was made regarding the visit. |
| AssessmentCode | 20.4.0 | Number(16,0) | Optional field containing a codesetid of type Assessment. |
| BloodPressureDiastolic | 20.11.0 | Number(3,0) | Optional field containing the diastolic blood pressure of the student. |
| BloodPressureSystolic | 20.11.0 | Number(3,0) | Optional field containing the systolic blood pressure of the student. |
| BloodSugar | 20.11.0 | Number(4,1) | Optional field containing the blood sugar level of the student. |
| BodyPartInjured | 20.4.0 | Number(16) | Optional field containing the identifier for the code to track the body part being treated for injury. |
HealthMainStudRecID | 6.1.0.1 | Number(19) | Foreign key's internal id relating this record to a record in the HealthMainStudRec table. Required. Indexed. |
HealthOfficeVisitID | 6.1.0.1 | Number(19) | Primary key and internal id of the record. Required. |
| InjuryType | 20.4.0 | Number(16) | Optional field containing a codesetid of type InjuryType. |
IsGuardianContacted | 6.1.0.1 | Number(1) | Indicates whether a guardian was contacted or not. (1=Yes, 0=No) |
Procedure | 20.4.0 | Number(16,0) | Optional field containing a codesetid of type Procedure. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
ScreenerName | 21.11.0.0 | Varchar2(305) | The name of the person in the office performing the evaluation, such as a school nurse. |
ScreenerType | 20.4.0.0 | Number(16) | Optional field containing a codesetid of type ScreenerType. Historic data was migrated from deprecated and removed column OfficeVisitScreenerTypeLuID. |
| Temperature | 20.11.0 | Number(4,1) | Optional field containing the body temperature of the student. |
| Treatment | 20.4.0 | Number(16,0) | Optional field containing a codesetid of type Treatment |
VisitDate | 6.1.0.1 | Date | The date of the visit to the Health Office. Required. |
VisitOutcome | 20.4.0.0 | Number(16) | Optional field containing a codesetid of type VisitOutcome. |
| VisitReason | 20.4.0 | Number(16) | Optional field containing a codesetid of type VisitReason. |
VisitReasonDesc | 23.7.0 | Varchar2(2048) | The reason for the visit. |
VisitTimeIn | 6.1.0.1 | Timestamp(6) | Start time of the visit. Required. |
VisitTimeOut | 6.1.0.1 | Timestamp(6) | Stop time of the visit. |
VisitType | 20.4.0.0 | Number(16) | CodeSetID of the type of visit or purpose of the visit. |
WhenCreated | 6.1.0.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 6.1.0.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 6.1.0.1 | Varchar2(305) | The name of the person who created the record. Defaults to user. |
WhoModified | 6.1.0.1 | Varchar2(305) | The name of the person who modified the record. Defaults to user. |