HealthStudVision (ver6.1.0)
Used to store data related to a Vision screening.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| AssessmentTypeLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of AssessmentTypeCode. |
| AssessmentTypeOther | 22.11.0 | Varchar2(256) | Other assessment type for vision screening. |
| BothEyeNearTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of BothEyeNearTestCode. |
| BothEyeFarTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of BothEyeFarTestCode. |
| BothEyeTestLUID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of bothEyeTestCode. |
| BothEyeTestWithCorrectionLUID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of bothEyeTestWithCorrectionCode. |
ColorBlindTestLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of ColorBlindTestCode. |
GradeLevelAtScreen | 6.1.0 | Varchar2(6) | The grade level at the time of the screening. |
HealthMainStudRecID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the HealthMainStudRec table. Required. |
HealthStudVisionID | 6.1.0 | Number(19) | Unique identifier for this table. Required. |
IsTestConductedLate | 6.1.0 | Number(1) | Is True (1) when this test was conducted late. Defaults to 0. |
| LeftEyeFarTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeftEyeFarTestCode. |
LeftEyeTestLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeftEyeTestCode. |
| LeftEyeNearTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeftEyeNearTestCode. |
| LeftEyeTestWithCorrectionLUID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of leftEyeTestWithCorrectionCode. |
| MuscleBalanceLUID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of muscleBalanceCode. |
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. |
ReferralDate | 6.1.0 | Date | Date a referral was made. |
| RightEyeFarTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of RightEyeFarTestCode. |
RightEyeTestLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of RightEyeTestCode. |
| RightEyeNearTestLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of RightEyeNearTestCode. |
| RightEyeTestWithCorrectionLUID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of rightEyeTestWithCorrectionCode. |
ScreenComment | 6.1.0 | Varchar2(512) | A written comment regarding the screening. |
ScreenDate | 6.1.0 | Date | The date that the screening took place. Required. |
ScreenerName | 6.1.0 | Varchar2(305) | Name of the person who is performing the screening. |
VisionAid | 6.1.0 | Varchar2(256) | Description of a vision aid, if one is used. |
VisionScreenerTypeLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of VisionScreenerTypeCode. |
VisionScreenOutcomeLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of VisionScreenOutcomeCode. |
WhenCreated | 6.1.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 6.1.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 6.1.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 6.1.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
| WithWithOutCorrectiveLensLUID | 22.11.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of WithWithOutCorrectiveLensCode. |