| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Type | varchar | 1 | Yes | |||
| Agency | varchar | 3 | Yes | |||
| Funding | varchar | 3 | Yes | |||
| Purpose | varchar | 3 | Yes | |||
| BillingType | varchar | 1 | Yes | |||
| Rate | money | Yes | ||||
| Tripcode | varchar | 3 | Yes | |||
| BoardingFarePercentage | numeric | Yes | ||||
| MinimumBoardingFare | numeric | Yes | ||||
| StateReportColumn | varchar | 1 | Yes | |||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_PaSharedRideCodes | clustered, unique, primary key located on PRIMARY | ID |
| U_AgencyFundingPurposeTripcode | nonclustered, unique located on PRIMARY | Agency, Funding, Purpose, Tripcode |