S_NC_AE_TEAMINFO (ver 14.12.0)
This table is a child table of the S_NC_AE_TeamInfo table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| COACH | 14.12.0 | VARCHAR2(60) | Faculty name designated as coach. |
| COACH_USER_ID | 14.12.0 | NUMBER(11,0) | Faculty UsersDCID designated as coach. |
| FACULTY | 14.12.0 | VARCHAR2(60) | Secondary faculty assigned to the team. |
| FACULTY_USER_ID | 14.12.0 | NUMBER(11,0) | Faculty UsersDCOD for secondary faculty assigned to the team. |
| GENDER | 14.12.0 | VARCHAR2(1) | Gender the team identifies as. |
| ID | 14.12.0 | NUMBER(19,0) | Primary Key. |
| SCHOOL_NUMBER | 14.12.0 | NUMBER(11,0) | School the team belong to. |
| SCHOOL_YEAR | 14.12.0 | NUMBER(11,0) | School year the team was active. |
| SEASON | 14.12.0 | NUMBER(11,0) | Season in which the team plays. |
| SPORT | 14.12.0 | NUMBER(11,0) | Sport team participates in. |
| SPORT_LEVEL | 14.12.0 | NUMBER(11,0) | Level team competes at. |