S_NC_AE_STUDENTINFO (ver 14.12.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
AMATEUR_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of waiver of amateur policy. |
AMATEUR_MET | 14.12.0 | VARCHAR2(6) | Student complies with amateur policy. |
ATHLETIC_9TH_GRADE_ENTRY | 14.12.0 | DATE | 9th grade entry date used in case of override. |
FOUR_SEASON_TEAM | 14.12.0 | VARCHAR2(100) | IDS of the sports this student participated in for 4 seasons. |
GRADE_9_ENTRY_OVERRIDE | 14.12.0 | NUMBER(11,0) | Overrides the calculated 9th grade entry date. |
LAST_PHYSICAL_DATE | 14.12.0 | DATE | Date of last physical exam. |
LOCAL_REQ_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of waiver of local requirements policy. |
LOCAL_REQ_MET | 14.12.0 | VARCHAR2(6) | Student complies with the local requirements policy. |
MEMBERSHIP_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of waiver of membership policy. |
MEMBERSHIP_MET | 14.12.0 | VARCHAR2(6) | Student complies with membership policy. |
NON_FELON | 14.12.0 | NUMBER(11,0) | Student has not been convicted of a felony. |
OVERALL_OVERRIDE | 14.12.0 | NUMBER(11,0) | Override of all participation requirements. |
OVERALL_OVERRIDE_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of overall override. |
PARENT_FORM_SIGN_DATE | 14.12.0 | DATE | Date parent signed GFeller Waller Form. |
PHYSICAL_RENEW_BY_DATE | 14.12.0 | DATE | Date physical exam to be renewed. |
PHYSICAL_RESULT | 14.12.0 | NUMBER(11,0) | Result of last physical exam. |
RESIDENCY_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of waiver of residency policy. |
RESIDENCY_MET | 14.12.0 | VARCHAR2(6) | Student complies with residency policy. |
STUDENTSDCID | 14.12.0 | NUMBER(19,0) | A foreign key that relates the extended table to the [Students] table. |
TRANSFER_POLICY_MEMO | 14.12.0 | VARCHAR2(250) | Explanation of waiver of transfer policy. |
TRANSFER_POLICY_MET | 14.12.0 | VARCHAR2(6) | Student complies with transfer policy. |