Skip to main content
Skip table of contents

HealthStudOral (ver6.1.0)

Used to store data related to an oral screening.

Column Name

Initial Version

Data Type

Description

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.

HealthStudOralID

6.1.0

Number(19)

Unique identifier for this table. Required.

IsDentalSealantPresent

6.1.0

Number(1)

Is True (1) when recorded dental sealant is present. Defaults to 0.

IsHistoryCariesPresent

6.1.0

Number(1)

Is True (1) when recorded a history of caries is present. Defaults to 0.

IsMalocclusionPresent

6.1.0

Number(1)

Is True (1) when recorded a Malocclusion is present. Defaults to 0.

IsUntreatedCariesPresent

6.1.0

Number(1)

Is True (1) when recorded an untreated caries is present. Defaults to 0.

OralScreenerTypeLuID

6.1.0

Number(19)

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

OralScreenOutcomeLuID

6.1.0

Number(19)

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

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.

TreatUrgencyLuID

6.1.0

Number(19)

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

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.