Skip to main content
Skip table of contents

HealthStudLead (ver 20.4.0)

Used to store data related to a Lead screening.

Column Name

Initial Version

Data Type

Description

GradeLevelAtScreen

20.4.0

Varchar2(6)

The grade level at the time of the screening.

HealthMainStudRecID

20.4.0

Number(19)

Internal ID supported by a foreign key to the HealthMainStudRec table. Required.

HealthStudLeadID

20.4.0

Number(19)

Unique identifier for this table. Required.

LeadScreenerTypeLuID

20.4.0

Number(19)

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

LeadScreenOutcomeLuID

20.4.0

Number(19)

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

ScreenComment

20.4.0

Varchar2(512)

A written comment regarding the screening.

ScreenDate

20.4.0

Date

The date that the screening took place. Required.

ScreenerName

20.4.0

Varchar2(305)

Name of the person who is performing the screening.

WhenCreated

20.4.0

Timestamp(6)

The date and time the record was created. Defaults to system date.

WhenModified

20.4.0

Timestamp(6)

The date and time the record was modified. Defaults to system date.

WhoCreated

20.4.0

Varchar2(100)

The name of the person who create the record. Defaults to user.

WhoModified

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