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

	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