Table ptms..Destinations

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

Zone varchar 6 Yes

Zonname varchar 25 Yes

Destination varchar 50 Yes

Facility varchar 1 Yes

Address1 varchar 50 Yes

Address2 varchar 50 Yes

City varchar 30 Yes

State varchar 2 Yes

Zipcode varchar 5 Yes

Phone varchar 13 Yes

DriverInstructions varchar 100 Yes

ProviderNumber varchar 20 Yes

Fax varchar 13 Yes

ActiveDestination varchar 1 Yes

ProviderLicense varchar 20 Yes

ProviderType varchar 4 Yes

Gisx numeric Yes

Gisy numeric Yes

Note1 varchar 50 Yes

NPI varchar 12 Yes

ZipExtension numeric Yes

RecordTypeStreets varchar 15 Yes

DefaultPurpose varchar 3 Yes

InsurancePlaceOfService varchar 1 Yes

MedicaidPlaceOfService varchar 2 Yes

PersonOrCompany varchar 1 Yes

ProviderFirstName varchar 10 Yes

ProviderLastName varchar 20 Yes

ProviderMI varchar 1 Yes

DestinationNumber varchar 20 Yes

LocationType varchar 1 Yes

ProcedureModifier varchar 1 Yes

SeviceMode varchar 3 Yes

GisLatitude varchar 50 Yes

GisLongitude varchar 50 Yes

Alias varchar 1 Yes

County varchar 50 Yes

Timestamp datetime Yes

LastUpDate datetime Yes

LastUpTime varchar 5 Yes

LastUpUser varchar 30 Yes

Indexes on this table

Index Name Index Description Index Keys

PK_Destinations clustered, unique, primary key located on PRIMARY ID

U_Destination nonclustered, unique located on PRIMARY Destination

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	Zone	varchar	6	Yes
	Zonname	varchar	25	Yes
	Destination	varchar	50	Yes
	Facility	varchar	1	Yes
	Address1	varchar	50	Yes
	Address2	varchar	50	Yes
	City	varchar	30	Yes
	State	varchar	2	Yes
	Zipcode	varchar	5	Yes
	Phone	varchar	13	Yes
	DriverInstructions	varchar	100	Yes
	ProviderNumber	varchar	20	Yes
	Fax	varchar	13	Yes
	ActiveDestination	varchar	1	Yes
	ProviderLicense	varchar	20	Yes
	ProviderType	varchar	4	Yes
	Gisx	numeric		Yes
	Gisy	numeric		Yes
	Note1	varchar	50	Yes
	NPI	varchar	12	Yes
	ZipExtension	numeric		Yes
	RecordTypeStreets	varchar	15	Yes
	DefaultPurpose	varchar	3	Yes
	InsurancePlaceOfService	varchar	1	Yes
	MedicaidPlaceOfService	varchar	2	Yes
	PersonOrCompany	varchar	1	Yes
	ProviderFirstName	varchar	10	Yes
	ProviderLastName	varchar	20	Yes
	ProviderMI	varchar	1	Yes
	DestinationNumber	varchar	20	Yes
	LocationType	varchar	1	Yes
	ProcedureModifier	varchar	1	Yes
	SeviceMode	varchar	3	Yes
	GisLatitude	varchar	50	Yes
	GisLongitude	varchar	50	Yes
	Alias	varchar	1	Yes
	County	varchar	50	Yes
	Timestamp	datetime		Yes
	LastUpDate	datetime		Yes
	LastUpTime	varchar	5	Yes
	LastUpUser	varchar	30	Yes

Index Name	Index Description	Index Keys
PK_Destinations	clustered, unique, primary key located on PRIMARY	ID
U_Destination	nonclustered, unique located on PRIMARY	Destination