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