| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| LastName | varchar | 20 | Yes | |||
| FirstName | varchar | 10 | Yes | |||
| MI | varchar | 1 | Yes | |||
| ClientID | varchar | 10 | Yes | |||
| SSN | varchar | 11 | Yes | |||
| MedicaidID | varchar | 16 | Yes | |||
| HomePhone | varchar | 13 | Yes | |||
| LastUpdate | datetime | Yes | ||||
| DATE | varchar | 8 | Yes | |||
| Vehicle | varchar | 4 | Yes | |||
| AGENCY | varchar | 3 | Yes | |||
| FUNDING | varchar | 3 | Yes | |||
| PURPOSE | varchar | 3 | Yes | |||
| TakeDestination | varchar | 50 | Yes | |||
| TakeDropTime | varchar | 5 | Yes | |||
| TakePickupLocation | varchar | 50 | Yes | |||
| TakePickupTime | varchar | 5 | Yes | |||
| tpzoncode | varchar | 6 | Yes | |||
| TakeRun | varchar | 1 | Yes | |||
| tpzonname | varchar | 25 | Yes | |||
| ReturnDestination | varchar | 50 | Yes | |||
| ReturnDropTime | varchar | 5 | Yes | |||
| ReturnPickupLocation | varchar | 50 | Yes | |||
| ReturnPickupTime | varchar | 5 | Yes | |||
| rpzoncode | varchar | 6 | Yes | |||
| ReturnRun | varchar | 1 | Yes | |||
| rpzonname | varchar | 25 | Yes | |||
| DriverInstructions | varchar | 100 | Yes | |||
| Special | varchar | 3 | Yes | |||
| TakeMonday | varchar | 1 | Yes | |||
| TakeTuesday | varchar | 1 | Yes | |||
| TakeWednesday | varchar | 1 | Yes | |||
| TakeThursday | varchar | 1 | Yes | |||
| TakeFriday | varchar | 1 | Yes | |||
| TakeSaturday | varchar | 1 | Yes | |||
| TakeSunday | varchar | 1 | Yes | |||
| TakeTripcode | varchar | 3 | Yes | |||
| TakeFare | money | Yes | ||||
| ReturnMonday | varchar | 1 | Yes | |||
| ReturnTuesday | varchar | 1 | Yes | |||
| ReturnWednesday | varchar | 1 | Yes | |||
| ReturnThursday | varchar | 1 | Yes | |||
| ReturnFriday | varchar | 1 | Yes | |||
| ReturnSaturday | varchar | 1 | Yes | |||
| ReturnSunday | varchar | 1 | Yes | |||
| ReturnTripcode | varchar | 3 | Yes | |||
| ReturnFare | money | Yes | ||||
| TravelTime | numeric | Yes | ||||
| Miles | numeric | Yes | ||||
| uptran | varchar | 1 | Yes | |||
| password | varchar | 8 | Yes | |||
| StartDate | datetime | Yes | ||||
| ServiceRequestRecordNumber | numeric | Yes | ||||
| Provider | varchar | 4 | Yes | |||
| vehcode1 | varchar | 3 | Yes | |||
| disp | varchar | 1 | Yes | |||
| disptime | numeric | Yes | ||||
| dispdate | numeric | Yes | ||||
| TakeRate | money | Yes | ||||
| ReturnRate | money | Yes | ||||
| ReferenceNumber | varchar | 20 | Yes | |||
| timeoutbrk | varchar | 4 | Yes | |||
| riders | numeric | Yes | ||||
| riders1 | numeric | Yes | ||||
| drvinstr1 | varchar | 40 | Yes | |||
| Escort | varchar | 1 | Yes | |||
| Attendant | varchar | 1 | Yes | |||
| authdate | datetime | Yes | ||||
| epassword | varchar | 8 | Yes | |||
| Weeks | numeric | Yes | ||||
| EndDate | datetime | Yes | ||||
| WeeksBetweenTrips | numeric | Yes | ||||
| ServiceMode | varchar | 3 | Yes | |||
| ProcedureModifier | varchar | 2 | Yes | |||
| Renew | bit | Yes | ||||
| Timestamp | datetime | Yes | ||||
| TakePickupLocationID | numeric | Yes | ||||
| TakePickupLocationSource | varchar | 1 | Yes | |||
| TakeDestinationID | numeric | Yes | ||||
| TakeDestinationSource | varchar | 1 | Yes | |||
| ReturnPickupLocationID | numeric | Yes | ||||
| ReturnPickupLocationSource | varchar | 1 | Yes | |||
| ReturnDestinationID | numeric | Yes | ||||
| ReturnDestinationSource | varchar | 1 | Yes | |||
| LastUpTime | varchar | 5 | Yes | |||
| LastUpUser | varchar | 30 | Yes |
| Index Name | Index Description | Index Keys |
| PK_ServiceRequests | clustered, unique, primary key located on PRIMARY | ID |