Column Name | Type | Length | Nullable | Description | Relationships | |
Identity | ID | int identity | No | |||
Vehicle | varchar | 4 | Yes | |||
DefaultVehicle | varchar | 3 | Yes | |||
DATE | varchar | 8 | Yes | |||
JDATE | numeric | Yes | ||||
Day | varchar | 3 | Yes | |||
DayNumber | numeric | Yes | ||||
LastName | varchar | 20 | Yes | |||
FirstName | varchar | 10 | Yes | |||
ClientID | varchar | 10 | Yes | |||
Tripcode | varchar | 3 | Yes | |||
TakeOrReturn | varchar | 1 | Yes | |||
PickupLocation | varchar | 50 | Yes | |||
PickupTime | varchar | 5 | Yes | |||
DefaultPickupTime | varchar | 5 | Yes | |||
Destination | varchar | 50 | Yes | |||
DropTime | varchar | 5 | Yes | |||
DefaultDropTime | varchar | 5 | Yes | |||
ResetDate | datetime | Yes | ||||
seqnum | numeric | Yes | ||||
Agency | varchar | 3 | Yes | |||
Funding | varchar | 3 | Yes | |||
Purpose | varchar | 3 | Yes | |||
Special | varchar | 3 | Yes | |||
Fare | money | Yes | ||||
DriverInstructions | varchar | 100 | Yes | |||
rpzoncode | varchar | 6 | Yes | |||
tpzoncode | varchar | 6 | Yes | |||
StartDate | datetime | Yes | ||||
StopDate | datetime | Yes | ||||
startjdate | numeric | Yes | ||||
stopjdate | numeric | Yes | ||||
Status | varchar | 1 | Yes | |||
Keydate | numeric | Yes | ||||
Keytime | varchar | 5 | Yes | |||
Verified | varchar | 1 | Yes | |||
Miles | numeric | Yes | ||||
Run | varchar | 1 | Yes | |||
uptran | varchar | 1 | Yes | |||
ScheduleRecordNumber | numeric | Yes | ||||
TravelMinutes | numeric | Yes | ||||
password | varchar | 8 | Yes | |||
Attendant | numeric | Yes | ||||
Escort | varchar | 1 | Yes | |||
fine | money | Yes | ||||
efare | money | Yes | ||||
efine | money | Yes | ||||
paddress1 | varchar | 50 | Yes | |||
paddress2 | varchar | 50 | Yes | |||
daddress1 | varchar | 50 | Yes | |||
daddress2 | varchar | 50 | Yes | |||
ReferenceNumber | varchar | 20 | Yes | |||
Provider | varchar | 4 | Yes | |||
SuspendCancellationFlag | varchar | 1 | Yes | |||
refsdate | datetime | Yes | ||||
refedate | datetime | Yes | ||||
quanapp | numeric | Yes | ||||
pastarjd | numeric | Yes | ||||
pastopjd | numeric | Yes | ||||
Note | varchar | 100 | Yes | |||
ProcedureModifier | varchar | 2 | Yes | |||
Renew | bit | Yes | ||||
UserTripRequest | varchar | 30 | Yes | |||
DateTripRequest | datetime | Yes | ||||
TimeTripRequest | varchar | 5 | Yes | |||
ActualPickupTime | varchar | 5 | Yes | |||
ActualDropTime | varchar | 5 | Yes | |||
DispatchTime | varchar | 5 | Yes | |||
OdometerOff | numeric | Yes | ||||
OdometerOn | numeric | Yes | ||||
CalculatedMiles | numeric | Yes | ||||
Timestamp | datetime | Yes | ||||
PickupLocationID | numeric | Yes | ||||
PickupLocationSource | varchar | 1 | Yes | |||
DestinationID | numeric | Yes | ||||
DestinationSource | varchar | 1 | Yes | |||
TripRequestDate | datetime | Yes | ||||
Driver | varchar | 3 | Yes | |||
LastUpdate | datetime | Yes | ||||
LastUpTime | varchar | 5 | Yes | |||
LastUpUser | varchar | 30 | Yes | |||
StartDate1 | datetime | Yes | ||||
StopDate1 | datetime | Yes | ||||
StartDate2 | datetime | Yes | ||||
StopDate2 | datetime | Yes | ||||
StartDate3 | datetime | Yes | ||||
StopDate3 | datetime | Yes | ||||
StartDate4 | datetime | Yes | ||||
StopDate4 | datetime | Yes | ||||
StartDate5 | datetime | Yes | ||||
StopDate5 | datetime | Yes | ||||
pgisx | varchar | 12 | Yes | |||
pgisy | varchar | 12 | Yes | |||
dgisx | varchar | 12 | Yes | |||
dgisy | varchar | 12 | Yes | |||
pgislatitude | varchar | 50 | Yes | |||
pgislongitude | varchar | 50 | Yes | |||
dgislatitude | varchar | 50 | Yes | |||
dgislongitude | varchar | 50 | Yes | |||
StatusReason | varchar | 50 | Yes |
Index Name | Index Description | Index Keys |
PK_Schedule | clustered, unique, primary key located on PRIMARY | ID |