- DATA VIEW NAME
- STDNT_SPORT_TEAM_CODES
- OVERVIEW
- This view contains descriptions for each Athletic Sport and each Sport Team. Information is included only for those sports for which there are active participants in the current term. This view can be used in conjunction with the student UW.Student_Demographic data view by joining on Sport_Code and Team_Code. The combination key must be used when a Team _Code description is needed as each sport can have multiple teams.
- LOAD FREQUENCY
- This data is refreshed the first day of each semester.
- DATA CUSTODIAN
- Data Custodian: Registrar’s Office – Phil Hull
- AUTHORIZATION
- No approval signature is required by the Data Custodian to receive
authorization to access this data view. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page - SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 9/99 Data view created.
10/01 View create to use varchar2 data types and conformed data element names.
2/2012 Custodian Change c4j . - DATA FORMAT
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| SPORT_CODE | VARCHAR2 (3) | A code indicating the type of sport that a student is active in. Example: HO for Hockey |
| TEAM_CODE | VARCHAR2 (5) | A subset of the SPORT_CODE indicating the sport team. Example: The sport code may be HO, Hockey and the team code could be MIH, Men’s Ice Hockey or WIH, Women’s Ice Hockey. |
| SPORT_SHORT_DESCR | VARCHAR2 (30) | Long description of the team. Example: MIH long description is Men’s Ice Hockey. |
| SPORT_TEAM_EFF_DATE | VARCHAR2 (8) | Date the sport and team codes became effective for use, format (YYYYMMDD).. |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |