Skip to main content
Skip table of contents

HealthStudHearing (ver6.1.0)

Used to store data related to a hearing screening.

Column Name

Initial Version

Data Type

Description

ExamTypeLuID

6.1.0

Number(19)

Internal ID supported by a foreign key to the Lookup table referencing a CodeType of ExamTypeCode.

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.

HealthStudHearingID

6.1.0

Number(19)

Unique identifier for this table. Required.

HearingAid

6.1.0

Varchar2(256)

Description of a hearing aid, if one is used.

HearingScreenerTypeLuID

6.1.0

Number(19)

Internal ID supported by a foreign key to the Lookup table referencing a CodeType of HearingScreenerTypeCode.

HearingScreenOutcomeLuID

6.1.0

Number(19)

Internal ID supported by a foreign key to the Lookup table referencing a CodeType of HearingScreenOutcomeCode.

IsImpairedTestConducted

6.1.0

Number(1)

Is True (1) when an impair test was performed. Defaults to 0.

IsTestConductedLate

6.1.0

Number(1)

Is True (1) when this test was conducted late. Defaults to 0.

LeftEarTestLuID

6.1.0

Number(19)

Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeftEarTestCode.

ReferralDate

6.1.0

Date

Date a referral was made.

RightEarTestLuID

6.1.0

Number(19)

Internal ID supported by a foreign key to the Lookup table referencing a CodeType of RightEarTestCode.

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.

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.

JavaScript errors detected

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

If this problem persists, please contact our support.