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