Table ptms..VehicleServiceSummary

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

Vehicle varchar 4 Yes

Driver varchar 3 Yes

Provider varchar 4 Yes

Vendor varchar 30 Yes

Tripdate datetime Yes

Jdate numeric Yes

Trips numeric Yes

StartTime varchar 5 Yes

StopTime varchar 5 Yes

TotalHours numeric Yes

StartMile numeric Yes

StopMIle numeric Yes

TotalMiles numeric Yes

DeadHeadHours numeric Yes

DeadHeadMiles numeric Yes

Gallons numeric Yes

PricePerGallon money Yes

OilCost money Yes

Breakdowns numeric Yes

DownTime numeric Yes

ActualVehicle varchar 3 Yes

WC varchar 1 Yes

Fares numeric Yes

Tickets numeric Yes

RecordNumber numeric Yes

Comment varchar 50 Yes

UnPaidBreakHours numeric Yes

Skipvss varchar 1 Yes

ServiceHours numeric Yes

ServiceMiles numeric Yes

AmbulatoryTrips numeric Yes

WheelChairTrips numeric Yes

Timestamp datetime Yes

Indexes on this table

Index Name Index Description Index Keys

PK_VehicleServiceSummary clustered, unique, primary key located on PRIMARY ID

Index Name	Index Description	Index Keys
PK_VehicleServiceSummary	clustered, unique, primary key located on PRIMARY	ID