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 |
Last Modified: Thursday, 05-Oct-2000 08:02:23 CDT
©2000 All Rights Reserved