Table ptms..NYCmn

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

ClientID varchar 10 Yes

MODE varchar 10 Yes

STARTDATE datetime Yes

STOPDATE datetime Yes

MEDID varchar 16 Yes

SSN varchar 11 Yes

LastName varchar 20 Yes

FirstName varchar 15 Yes

DOB varchar 10 Yes

ADDRESS1 varchar 50 Yes

CITY varchar 25 Yes

STATE varchar 2 Yes

ZIPCODE varchar 5 Yes

A1 varchar 3 Yes

A2 varchar 3 Yes

A3 varchar 3 Yes

A4 varchar 3 Yes

A5 varchar 3 Yes

DIAGNOSIS1 varchar 10 Yes

DIAGNOSIS2 varchar 10 Yes

DIAGNOSIS3 varchar 10 Yes

DIAGNOSIS4 varchar 10 Yes

DIAGNOSIS5 varchar 10 Yes

WHYDIAG varchar 250 Yes

REQWCSCOX bit Yes

REQASSIST bit Yes

ESCORT bit Yes

LIFEEQUIP bit Yes

REQEMT bit Yes

RECLINEMED bit Yes

RECLINEPSY bit Yes

REQVEHO2 bit Yes

DESTIN varchar 50 Yes

DADDRESS1 varchar 50 Yes

DCITY varchar 25 Yes

DSTATE varchar 2 Yes

DZIPCODE varchar 10 Yes

PROVNUM varchar 20 Yes

NPI varchar 10 Yes

DOCTOR varchar 50 Yes

SIGNDATE datetime Yes

HOSPNAME varchar 50 Yes

DOCADDRESS varchar 50 Yes

DOCCITY varchar 25 Yes

DOCSTATE varchar 2 Yes

DOCZIPCODE varchar 5 Yes

DOCPHONE varchar 13 Yes

WORKERNAME varchar 50 Yes

WORKERTITL varchar 30 Yes

WORKERPHON varchar 13 Yes

EnterUser varchar 30 Yes

EnterDate datetime Yes

EnterTime varchar 5 Yes

LastUser varchar 30 Yes

LastDate datetime Yes

LastTime varchar 5 Yes

Renewtrip bit Yes

NOTES varchar 250 Yes

Timestamp datetime Yes

sex varchar 1 Yes

Diagnosis6 varchar 10 Yes

Address2 varchar 50 Yes

Indexes on this table

Index Name Index Description Index Keys

PK_NYCmn clustered, unique, primary key located on PRIMARY ID

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	ClientID	varchar	10	Yes
	MODE	varchar	10	Yes
	STARTDATE	datetime		Yes
	STOPDATE	datetime		Yes
	MEDID	varchar	16	Yes
	SSN	varchar	11	Yes
	LastName	varchar	20	Yes
	FirstName	varchar	15	Yes
	DOB	varchar	10	Yes
	ADDRESS1	varchar	50	Yes
	CITY	varchar	25	Yes
	STATE	varchar	2	Yes
	ZIPCODE	varchar	5	Yes
	A1	varchar	3	Yes
	A2	varchar	3	Yes
	A3	varchar	3	Yes
	A4	varchar	3	Yes
	A5	varchar	3	Yes
	DIAGNOSIS1	varchar	10	Yes
	DIAGNOSIS2	varchar	10	Yes
	DIAGNOSIS3	varchar	10	Yes
	DIAGNOSIS4	varchar	10	Yes
	DIAGNOSIS5	varchar	10	Yes
	WHYDIAG	varchar	250	Yes
	REQWCSCOX	bit		Yes
	REQASSIST	bit		Yes
	ESCORT	bit		Yes
	LIFEEQUIP	bit		Yes
	REQEMT	bit		Yes
	RECLINEMED	bit		Yes
	RECLINEPSY	bit		Yes
	REQVEHO2	bit		Yes
	DESTIN	varchar	50	Yes
	DADDRESS1	varchar	50	Yes
	DCITY	varchar	25	Yes
	DSTATE	varchar	2	Yes
	DZIPCODE	varchar	10	Yes
	PROVNUM	varchar	20	Yes
	NPI	varchar	10	Yes
	DOCTOR	varchar	50	Yes
	SIGNDATE	datetime		Yes
	HOSPNAME	varchar	50	Yes
	DOCADDRESS	varchar	50	Yes
	DOCCITY	varchar	25	Yes
	DOCSTATE	varchar	2	Yes
	DOCZIPCODE	varchar	5	Yes
	DOCPHONE	varchar	13	Yes
	WORKERNAME	varchar	50	Yes
	WORKERTITL	varchar	30	Yes
	WORKERPHON	varchar	13	Yes
	EnterUser	varchar	30	Yes
	EnterDate	datetime		Yes
	EnterTime	varchar	5	Yes
	LastUser	varchar	30	Yes
	LastDate	datetime		Yes
	LastTime	varchar	5	Yes
	Renewtrip	bit		Yes
	NOTES	varchar	250	Yes
	Timestamp	datetime		Yes
	sex	varchar	1	Yes
	Diagnosis6	varchar	10	Yes
	Address2	varchar	50	Yes

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