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