HealthStudSystem(ver21.4.4)
This table contains the results of a general health screening on a student.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| CardiovascularOrHTNComment | 21.4.4 | Varchar2(2000) | Screener's comments about the student's heart and cardio. |
| DiagnosisOfAsthmaComment | 21.4.4 | Varchar2(2000) | Screener's comments about the student's diagnosis of asthma. |
| EarsComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the student's ears. |
| EndocrineComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the endocrine level. |
| EyesComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the student's eyes. |
| GastrointestinalComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the student's gastrointestinal function. |
| GenitoUrinaryComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the student's urinary tract function or genitals. |
| GradeLevelAtScreen | 21.4.4 | varchar2(6) | Student's grade level when screening performed. |
| HealthMainStudRecID | 21.4.4 | Number(19) | Foreign Key to student's main health record. Required. |
| HealthStudSystemID | 21.4.4 | Number(19) | Unique Key for this record. System assigned. |
| IsCardiovascularOrHTNNormal | 21.4.4 | Number(1) | Indicates whether the student's heart appears within normal limits. 1 = Yes, 0 = No. |
| IsDiagnosisOfAsthmaNormal | 21.4.4 | Number(1) | Indicates whether the student has been diagnosed with Asthma. 1 = Yes, 0 = No. |
| IsEarsNormal | 21.4.4 | Number(1) | Indicates whether the student's ears are within normal limits. 1 = Yes, 0 = No. |
| IsEndocrineNormal | 21.4.4 | Number(1) | Indicates whether the student's endocrine levels are within normal limits. 1 = Yes, 0 = No. |
| IsEyesNormal | 21.4.4 | Number(1) | Indicates whether the student's eyes are within normal limits. 1 = Yes, 0 = No. |
| IsGastrointestinalComment | 21.4.4 | Number(1) | Indicates whether the student's gastrointestinal tract appears to be within normal limits. 1 = Yes, 0 = No. |
| IsGenitoUrinaryNormal | 21.4.4 | Number(1) | Indicates whether the student's urinary function/genitals are within normal limits. 1 = Yes, 0 = No. |
| IsLMPNormal | 21.4.4 | Number(1) | Indicates whether the student's LMP was within normal limits. 1 = Yes, 0 = No. |
| IsMentalHealthNormal | 21.4.4 | Number(1) | Indicates no mental health concerns. 1 = No concerns, 0 = Concerns found. |
| IsMouthOrDentalNormal | 21.4.4 | Number(1) | Indicates whether the student's mouth or teeth are within normal limits. 1 = Yes, 0 = No. |
| IsMusculoskeletalNormal | 21.4.4 | Number(1) | Indicates whether the student's musculoskeletal results are within normal limits. 1 = Yes, 0 = No. |
| IsNeurologicalNormal | 21.4.4 | Number(1) | Indicates whether the student's Neurological results are within normal limits. 1 = Yes, 0 = No. |
| IsNoseNormal | 21.4.4 | Number(1) | Indicates whether the student's nose is within normal limits. 1 = Yes, 0 = No. |
| IsNutritionalStatusNormal | 21.4.4 | Number(1) | Indicates whether the student's nutritional status is within normal limits. 1 = Yes, 0 = No. |
| IsRespiratoryNormal | 21.4.4 | Number(1) | Indicates whether the student's respiratory system is within normal limits. 1 = Yes, 0 = No. |
| IsSkinNormal | 21.4.4 | Number(1) | Indicates whether the student's skin is unremarkable. 1 = Yes, 0 = No. |
| IsSpinalExamNormal | 21.4.4 | Number(1) | Indicates whether the student's spinal exam results are within normal limits. 1 = Yes, 0 = No. |
| IsThroatNormal | 21.4.4 | Number(1) | Indicates whether the student's throat is within normal limits. 1 = Yes, 0 = No. |
| LMPComment | 21.4.4 | Varchar2(2000) | Screener's comments about LMP results. |
| MentalHealthComment | 21.4.4 | Varchar2(2000) | Screener's comment's about the student's mental health. |
| MouthOrDentalComment | 21.4.4 | Varchar2(2000) | Screener's comments about the normalcy of the student's mouth or teeth. |
| MusculoskeletalComment | 21.4.4 | Varchar2(2000) | Screener's comments about the normalcy of the student's musculoskeletal system. |
| NeurologicalComment | 21.4.4 | Varchar2(2000) | Screener's comments about the student's neurological response. |
| NoseComment | 21.4.4 | Varchar2(2000) | Screener's comments about the normalcy of the student's nose. |
| NutritionalStatusComment | 21.4.4 | Varchar2(2000) | Screener's comments about the student's nutritional status. |
| RespiratoryComment | 21.4.4 | Varchar2(2000) | Screener's comments about the normalcy of the student's respiration. |
| ScreenComment | 21.4.4 | Varchar2(512) | Screener's general comments about the screening. |
| ScreenDate | 21.4.4 | Date | Date the screening took place. Required. |
| ScreenerName | 21.4.4 | Varchar2(30) | Name of the person performing the health screening. |
| SkinComment | 21.4.4 | Varchar2(2000) | Screener's comments related to skin condition. |
| SpinalExamComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the student's spinal exam. |
| SystemScreenOutcomeLUID | 21.4.4 | Number(19) | Foreign Key to the outcome code for the screening. |
| SystemScreenerTypeLUID | 21.4.4 | Number(19) | Foreign Key to the type of screener. |
| ThroatComment | 21.4.4 | Varchar2(2000) | Screener's comments related to the throat. |
WhenCreated | 21.4.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 21.4.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 21.4.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
WhoModified | 21.4.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |