Skip to main content
Skip table of contents

S_CA_STU_OralHealth_C (ver 17.8.0)

This table is a child table of STUDENTS.

Column Name

Version

Data Type

Description

Unique_ID

17.8.0

Number(11,0)

Record ID. Migrated from [OralHealth.unique_ID].

SchoolID

17.8.0

Number(11,0)

School ID. Migrated from [OralHealth.schoolID].

ForeignKey

17.8.0

Number(11,0)

Reserved for future use. Migrated from [OralHealth.foreignKey].

ForeignKey_Alpha

17.8.0

Varchar2(31)

Reserved for future use. Migrated from [OralHealth.foreignKey_alpha].

AssessmentDate

17.8.0

Date

Assessment Date. Migrated from [OralHealth.user_defined_date].

GradeLevel 

17.8.0

Number(11,0)

Grade Level. Migrated from [OralHealth.user_defined_integer].

ReportYear

17.8.0

Number(25,10)

Report Year. Migrated from [OralHealth.user_defined_numeric].

TreatmentUrgency

17.8.0

Varchar2(3)

Treatment Urgency. Migrated from [OralHealth.user_defined_text2].

FillingsPresent

17.8.0

Varchar2(1)

Fillings Present. Migrated from [OralHealth.fillingsPresent].

DecayPresent

17.8.0

Varchar2(1)

Decay Present. Migrated from [OralHealth.decayPresent].

WaiverCantFind

17.8.0

Varchar2(1)

Waiver: Can't Find flag. Migrated from [OralHealth.waiverCantFind].

WaiverCantAfford

17.8.0

Varchar2(1)

Waiver: Can't Afford flag. Migrated from [OralHealth.waiverCantAfford].

WaiverDontWish

17.8.0

Varchar2(1)

Waiver: Don't Wish flag. Migrated from [OralHealth.waiverDontWish].

WaiverOtherDesc

17.8.0

Varchar2(1)

Waiver: Other Desc flag. Migrated from [OralHealth.waiverOtherDesc].

WaiverNoForm

17.8.0

Varchar2(1)

Waiver: No Form flag. Migrated from [OralHealth.waiverNoForm].

InsMedical

17.8.0

Varchar2(1)

Insurance: Medical flag. Migrated from [OralHealth.insMedical].

InsHealthyFam

17.8.0

Varchar2(1)

Insurance: Healthy Families flag. Migrated from [OralHealth.insHealthyFam].

InsHealthyKids

17.8.0

Varchar2(1)

Insurance: Healthy Kids flag. Migrated from [OralHealth.insHealthyKids].

InsOther

17.8.0

Varchar2(1)

Insurance: Other flag. Migrated from [OralHealth.insOther].

InsOtherDesc

17.8.0

Varchar2(80)

Insurance: Other Description. Migrated from [OralHealth.insOtherDesc].

InsNone

17.8.0

Varchar2(1)

Insurance: None flag. Migrated from [OralHealth.insNone].

JavaScript errors detected

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

If this problem persists, please contact our support.