Student Ticket Order Database

Overview

Basics

The student ticket order databases stores information about student ticket purchases, primarily athletic tickets. It requires a logon using student ID number and pin number before access is granted. Payment for tickets ordered is done through a batch process, forwarding ticket cost information to the Billing/Receivables System (BRS). There are two components of the database, specifically:

Ticket Control Table
Ticket Order Table

Maintenance

All maintenance of the various tables is done in the web environment. Maintenance (non-ticket ordering) requires logon verification.

Ticket Control Table Contents

The Ticket Control Table has information associated with each ticket entity, i.e., information about what the ticket provides, activity dates (where relevant) and cost. Table information includes:

Ticket Code
The first character of the ticket code indicates the general category. For example, a first character of F indicates this is a football-related activity. A first character of B would indicate basketball.
Ticket Decsription
Ticket Cost
# of Tickets Available
Points Required to Purchase Tickets (e.g., # of AU hours taken)

Ticket Order Table Contents

The Ticket Order Table has information associated ticket purchases for a student and/or the student's spouse. Table information includes:

Ticket Year (Calendar Year)
Student ID Number
Ticket Code
Ticket Status
Ticket Order Date
Priority Hours
Spouse Purchase Indicator
Last Date Updated
Billing Feed Indicator
Billing Feed Date

OIT--Applications Support

Last Modified: Thursday, 05-Oct-2000 08:01:30 CDT