Table: PriorAuthorizations
| Field | Size |
| PriorAuthorizationRef | INT (IDENTITY) |
| PatientRef | INT |
| PayerRef | INT |
| PayerRepresentativeRef | INT |
| RequestType | TINYINT |
| BeginDate | DATETIME |
| EndDate | DATETIME |
| BasisOfRequest | VARCHAR(2) |
| PriorAuthorizationNumber | VARCHAR(11) |
| AuthorizationNumber | VARCHAR(20) |
| Notes | TEXT |
| QuantityAuthorized | INT |
| RefillsAuthorized | SMALLINT |
| EnteredByRef | INT |