PowerSchool SIS Illinois

S_IL_STU_HealthHistory_X ver 20.9.3

This table is an extension of the SectionTeacher table. It is created to add New Teacher Tracking functionality to support Co-teacher.

Column Name

Version

Data Type

Description

STUDENTSDCID

20.9.3

NUMBER(19,0)

Primary Key

ALCOHOL

20.9.3

NUMBER(1)

Alcohol/Drug use.? Y/N

ASTHMA

20.9.3

NUMBER(1)

Diagnosis of Asthma.? Y/N

BIRTH_DEFECTS

20.9.3

NUMBER(1)

Any Birth defects? Y/N

BLOOD_DISORDERS

20.9.3

NUMBER(1)

Any BLOOD DISORDERS ? Y/N

BRACES

20.9.3

NUMBER(1)

Has BRACES? Y/N

BRIDGE 

20.9.3

NUMBER(1)

Has BRIDGE  ? Y/N

COMMENTS_ALCOHOL

20.9.3

VARCHAR2(1000)

Alcohol use describe

COMMENTS_ASTHMA

20.9.3

VARCHAR2(1000)

ASTHMA describe

COMMENTS_BIRTH_DEFECTS

20.9.3

VARCHAR2(1000)

Any BIRTH DEFECTS  describe

COMMENTS_BLOOD_DISORDERS

20.9.3

VARCHAR2(1000)

Any BLOOD_DISORDERS describe

COMMENTS_COUGH

20.9.3

VARCHAR2(1000)

Has COUGH? describe

COMMENTS_DEATH_HISTORY

20.9.3

VARCHAR2(1000)

Has any sudden DEATH HISTORY? describe

COMMENTS_DENTAL_OTHER

20.9.3

VARCHAR2(1000)

Any dental issues? describe

COMMENTS_DEVELOP_DELAY

20.9.3

VARCHAR2(1000)

Any Development delay? describe.

COMMENTS_DIABETES

20.9.3

VARCHAR2(1000)

Has DIABETES? describe

COMMENTS_DIZZINESS

20.9.3

VARCHAR2(1000)

Has DIZZINESS? decribe

COMMENTS_EYE_EXAMINATION

20.9.3

VARCHAR2(1000)

Had EYE_EXAMINATION? describe

COMMENTS_EYECONCERNS_OTHER

20.9.3

VARCHAR2(1000)

Any other eye concerns? describe

COMMENTS_HEAD_INJURY

20.9.3

VARCHAR2(1000)

Any head injury? describe

COMMENTS_HEARING_PROBLEMS

20.9.3

VARCHAR2(1000)

Any hearing problem? describe

COMMENTS_HEART_MURMUR_BP

20.9.3

VARCHAR2(1000)

Blood Pressure? describe

COMMENTS_HEART_PROBLEM 

20.9.3

VARCHAR2(1000)

Heart problem ? describe

COMMENTS_HOSPITALIZATIONS

20.9.3

VARCHAR2(1000)

Hospitalization? describe

COMMENTS_JOINT_PROBLEMS 

20.9.3

VARCHAR2(1000)

Joint Problems? describe

COMMENTS_LOSS_OF_FUNCTION

20.9.3

VARCHAR2(1000)

Loss of function? describe

COMMENTS_SEIZURES     

20.9.3

VARCHAR2(1000)

Seizures ? describe

COMMENTS_SERIOUS_ILLNESS  

20.9.3

VARCHAR2(1000)

Any serious illness? describe

COMMENTS_SURGERY

20.9.3

VARCHAR2(1000)

Any Surgery? describe

COMMENTS_TB_DISEASE

20.9.3

VARCHAR2(1000)

Has TB? describe

COMMENTS_TB_SKIN

20.9.3

VARCHAR2(1000)

TB Skin? describe

COMMENTS_TOBACCO

20.9.3

VARCHAR2(1000)

Tobacco? describe

COMMENTS_VISION_PROBLEMS

20.9.3

VARCHAR2(1000)

Vision Problems ? describe

CONTACTS

20.9.3

NUMBER(1)

Using contact lens? Y/N

COUGH 

20.9.3

NUMBER(1)

Has Cough? Y/N

DEATH_HISTORY 

20.9.3

NUMBER(1)

Sudden Death? Y?N

DENTAL_OTHER  

20.9.3

NUMBER(1)

Dental other issue? Y?N

DEVELOP_DELAY   

20.9.3

NUMBER(1)

Development Delay? Y/N

DIABETES   

20.9.3

NUMBER(1)

Diabetes? Y/N

DIZZINESS          

20.9.3

NUMBER(1)

Diziness? Y/N

EYECONCERNS_OTHER          

20.9.3

NUMBER(1)

Eye concerns other? Y/N

GLASSES              

20.9.3

NUMBER(1)

Glasses ? Y/N

HEAD_INJURY    

20.9.3

NUMBER(1)

Head injury? Y/N

HEARING_PROBLEMS       

20.9.3

NUMBER(1)

Hearing issues? Y/N

HEART_MURMUR_BP          

20.9.3

NUMBER(1)

Heart Murmur/BP? Y/N

HEART_PROBLEM      

20.9.3

NUMBER(1)

Heart Problem? Y/N

HOSPITALIZATIONS      

20.9.3

NUMBER(1)

Hospitalization? Y/N

JOINT_PROBLEMS       

20.9.3

NUMBER(1)

Join Problems? Y/N

LOSS_OF_FUNCTION       

20.9.3

NUMBER(1)

Loss of function? Y/N

PLATE

20.9.3

NUMBER(1)

Plate? Y/N

SEIZURES  

20.9.3

NUMBER(1)

Seizures? Y/N

SERIOUS_ILLNESS         

20.9.3

NUMBER(1)

Serious illness? Y/N

SURGERY  

20.9.3

NUMBER(1)

Surgery? Y/N

TB_DISEASE      

20.9.3

NUMBER(1)

TB? Y/N

TB_SKIN     

20.9.3

NUMBER(1)

TB Skin? Y/N

TOBACCO      

20.9.3

NUMBER(1)

Tobacco usage? Y/N