Table ptms..Schedule

  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    

Indexes on this table

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