|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
Sport Code Object
- The Sport Code object contains information about student involvement in intercollegiate athletics. This object contains one record per student per term per sport. This object is not available to most Student Data Warehouse users.
- Warehouse ID
- Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.
- Data Type: Number
- Example: 123456
- Source: derived
- Term
- Term of participation in a given sport.
- Data Type: 6 Characters
- Example: 199601
- Source: sfbetrm_term_code
- Sport Code
- Code for the sport program.
- Data Type: 8 Characters
- Example: MFB
- Source: sgrsprt_actc_code
- Val Table: Sport
- Sport Code Desc
- Description of the Sport Code.
- Data Type: 30 Characters
- Example: Football
- Source: stvactc_desc
- Val Table: Sport
- Sport Status Code
- Code indicating special status in the sports program. 'DS' = dropped from squad list, 'RS' = reinstated to squad list. For most student athletes this field will be null.
- Data Type: 2 Characters
- Example: RS
- Source: sgrsprt_spst_code
- Sport Eligibility Code
- Eligibility of the student athlete for the given sport. 'EC' = elligible to compete, 'EP' = can practice but may not compete, 'MD' = medical, 'NE' = not eligible to compete.
- Data Type: 2 Characters
- Example: EC
- Source: sgrsprt_elig_code
- Sport Atheletic Aid Ind
- Flag indicating whether the athlete is receiving athletic aid. This field is not currently being used.
- Data Type: 1 Character
- Source: sgrsprt_athl_aid_ind
This page was last updated on February 15, 2000.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
