Skip to main content
Skip table of contents

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(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.

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.