S_NC_Medical (ver 13.6.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ACCIDENT_INSURANCE | 13.6.0 | VARCHAR2(1) | |
| DOCTOR_PHONE | 13.6.0 | VARCHAR2(10) | |
| HEALTH_CARD_NO | 13.6.0 | VARCHAR2(15) | |
| INS_CARRIER_NAME | 13.6.0 | VARCHAR2(50) | |
| MEDICAL_CARD_ON_FILE | 13.6.0 | VARCHAR2(1) | |
| MEDICAL_REFUSAL_REASON_DESC | 13.6.0 | VARCHAR2(50) | |
| PERMISSION_TO_TRANSPORT | 13.6.0 | VARCHAR2(1) | |
| PHYSICAL_EXAM_DATE | 13.6.0 | DATE | |
| PHYSICAL_EXAM_PASS_FAIL | 13.6.0 | VARCHAR2(1) | |
| PREFERRED_HOSPITAL | 13.6.0 | VARCHAR2(40) | |
| REFUSED_MEDICAL_CARD | 13.6.0 | VARCHAR2(1) | |
| STUDENTSDCID | 13.6.0 | NUMBER(19,0) | Foreign key that links to the students table. |