| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Tripcode | varchar | 3 | Yes | |||
| Reason | varchar | 2 | Yes | |||
| FProcedure | varchar | 5 | Yes | |||
| Rate0 | money | Yes | ||||
| EscortRate | money | Yes | ||||
| Category | varchar | 4 | Yes | |||
| Description | varchar | 25 | Yes | |||
| MileRate | money | Yes | ||||
| RateType | varchar | 1 | Yes | |||
| Mprocedure | varchar | 5 | Yes | |||
| Gprocedure | varchar | 5 | Yes | |||
| Gtripcode | varchar | 3 | Yes | |||
| Mtripcode | varchar | 3 | Yes | |||
| DisplayTC | bit | Yes | ||||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_NYParates | clustered, unique, primary key located on PRIMARY | ID |
| U_Tripcode | nonclustered, unique located on PRIMARY | Tripcode |