Abstract: A data structure embodied on a computer-readable medium having a database schema for accessing and managing pharmacy transactions data in a structured query language (SQL) database. The database schema includes a session data schema representing a relational data table for capturing a plurality of sessions for accessing and managing the SQL database and a pharmacy prescription drug transaction results schema representing parameters for relating prescription drug transaction results with requesters, prescribers and the prescription drug. The session data schema and the pharmacy prescription drug transaction results schema used by a pharmacy business logic application to access and manage the pharmacy drug transaction results in the SQL database.