HealthStudTB (ver6.1.0)
Used to store data related to a TB screening.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ChestXRayFilmDate | 6.1.0 | Date | Date a Chest X-Ray film was made. |
ChestXRayImpresLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of ChestXRayImpresCode. |
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. |
HealthStudTBID | 6.1.0 | Number(19) | Unique identifier for this table. Required. |
ImpressionResultLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of ImpressionResultCode. |
IndurationSize | 6.1.0 | Number(12,2) | The size of the induration area. |
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. |
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. |
SkinTestGivenDate | 6.1.0 | Date | Date skin test took place. |
SkinTestReadDate | 6.1.0 | Date | Date skin test result was read. |
SkinTestTypeLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of SkinTestTypeCode. |
TBScreenerTypeLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of TBScreenerTypeCode. |
TBScreenOutcomeLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of TBScreenOutcomeCode. |
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(305) | The name of the person who create the record. Defaults to user. |
WhoModified | 6.1.0 | Varchar2(305) | The name of person who modified the record. Defaults to user. |
BloodTestGivenDate | 20.4.0 | Date | Date blood test took place. |
BloodTestReadDate | 20.4.0 | Date | Date blood test result was read. |
BloodTestTypeLuID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of BloodTestTypeCode. |
BloodTestResultLuID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of BloodTestResultCode. |