The Student Ticket Order Table (STU_TICKET_ORDER) contains the following information:
| Description | SQL Name | Length | Notes |
|---|---|---|---|
| Ticket Year | TCK_YEAR | 2 | primary key |
| Ticket Code | TCK_CODE | 2 | primary key |
| Student ID Number | STU_ID | 9 | primary key |
| Ticket Status | STATUS | 1 | P = Purchased C = Cancelled |
| Order Date | ORD_DATE | 10 | MM/DD/CCYY Format |
| Priority Hours | PRIORITY_HRS | 3 | numeric, packed |
| Spouse Purchase Indicator | SPOUSE_PCH | 1 | blank or same as Status |
| Spouse ID Number | SPOUSE_ID | 9 | |
| Billing Feed Flag | BRS_FEED | 1 | blank = No Status
Y = Purchase Fed to BRS C = Cancellation Fed to BRS |
| Billing Feed Date | BRS_DATE | 10 | MM/DD/CCYY Format |
| Option 1 | OPTION1 | 2 | for optional use |
| Option 2 | OPTION2 | 4 | for optional use |
| Option 3 | OPTION3 | 1 | for optional use |
| Last Date Updated | LAST_UPDT | 10 | MM/DD/CCYY Format |