The Ticket Control Table (STU_TICKET_CONTROL) contains the following information:
| Description | SQL Name | Length | Notes |
|---|---|---|---|
| Ticket Code | TCK_CODE | 2 | primary key |
| Ticket Description | TCK_DESC | 20 | |
| Ticket Cost | TCK_COST | 5 | numeric, 2 decimals, packed |
| Ticket Quantity Available | TCK_QTY | 5 | numeric, packed |
| Required Priority Points | TCK_POINTS | 3 | numeric, packed |
| Option 1 | TCK_OPT1 | 1 | |
| Option 2 | TCK_OPT2 | 1 | |
| Option 3 | TCK_OPT3 | 1 |
The Required Priority Points may have a different meaning depending on ticket code. For Football, it indicates the nmber of AU hours which must have been taken before the ticket can be purchased. This may vary over time to permit different groups of students to purchase tickets at different points in time.