Table ptms..ScheduledTripSuspensions

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

ClientID varchar 10 Yes

ScheduleRecordNumber numeric Yes

StopDate0 datetime Yes

Startdate0 datetime Yes

Stopjdate numeric Yes

Starjdate numeric Yes

SuspendedCancelled0 varchar 1 Yes

SuspendedCancelled1 varchar 1 Yes

SuspendedCancelled2 varchar 1 Yes

Filler5 varchar 5 Yes

Stopdate1 datetime Yes

Startdate1 datetime Yes

Stopj1 numeric Yes

Starj1 numeric Yes

Stopdate2 datetime Yes

Startdate2 datetime Yes

Stopj2 numeric Yes

Starj2 numeric Yes

Timestamp datetime Yes

Indexes on this table

Index Name Index Description Index Keys

PK_ScheduledTripSuspensions clustered, unique, primary key located on PRIMARY ID

U_ClientIDScheduleRecordNumber nonclustered, unique located on PRIMARY ClientID,
ScheduleRecordNumber

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	ClientID	varchar	10	Yes
	ScheduleRecordNumber	numeric		Yes
	StopDate0	datetime		Yes
	Startdate0	datetime		Yes
	Stopjdate	numeric		Yes
	Starjdate	numeric		Yes
	SuspendedCancelled0	varchar	1	Yes
	SuspendedCancelled1	varchar	1	Yes
	SuspendedCancelled2	varchar	1	Yes
	Filler5	varchar	5	Yes
	Stopdate1	datetime		Yes
	Startdate1	datetime		Yes
	Stopj1	numeric		Yes
	Starj1	numeric		Yes
	Stopdate2	datetime		Yes
	Startdate2	datetime		Yes
	Stopj2	numeric		Yes
	Starj2	numeric		Yes
	Timestamp	datetime		Yes

Index Name	Index Description	Index Keys
PK_ScheduledTripSuspensions	clustered, unique, primary key located on PRIMARY	ID
U_ClientIDScheduleRecordNumber	nonclustered, unique located on PRIMARY	ClientID, ScheduleRecordNumber