| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Agency | varchar | 3 | Yes | |||
| Funding | varchar | 3 | Yes | |||
| Purpose | varchar | 3 | Yes | |||
| Tripcode | varchar | 3 | Yes | |||
| MileRate | money | Yes | ||||
| FlatRate | money | Yes | ||||
| PasgHourRate | money | Yes | ||||
| Formula | varchar | 1 | Yes | |||
| Formdesc | varchar | 25 | Yes | |||
| Threshold | numeric | Yes | ||||
| Surcharge | money | Yes | ||||
| Deductfare | bit | Yes | ||||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_AgencyRateMappings | clustered, unique, primary key located on PRIMARY | ID |
| U_AgencyFundingPurposeTripcode | nonclustered, unique located on PRIMARY | Agency, Funding, Purpose, Tripcode |