Table ptms..Providers

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

Provider varchar 4 Yes

Description varchar 30 Yes

LastName varchar 15 Yes

FirstName varchar 10 Yes

Title varchar 30 Yes

ADDRESS1 varchar 40 Yes

ADDRESS2 varchar 40 Yes

CITY varchar 20 Yes

STATE varchar 2 Yes

ZIPCODE varchar 5 Yes

PHONE1 varchar 13 Yes

EXT1 varchar 4 Yes

PHONE2 varchar 13 Yes

EXT2 varchar 4 Yes

NOTE varchar 60 Yes

NPI varchar 12 Yes

PROVTYPE varchar 1 Yes

SERVTYPE varchar 1 Yes

DROPRATE money Yes

SERVAREA varchar 10 Yes

RATEPERHR money Yes

RATEPERMIL money Yes

Postcode varchar 8 Yes

FEDTAXID varchar 9 Yes

OTHERID varchar 12 Yes

FAXNO varchar 13 Yes

CATEGORY varchar 4 Yes

TAG varchar 1 Yes

EMAIL varchar 50 Yes

AllowWebVerification bit Yes

Medcode bit Yes

Timestamp datetime Yes

Indexes on this table

Index Name Index Description Index Keys

PK_Providers clustered, unique, primary key located on PRIMARY ID

U_Provider nonclustered, unique located on PRIMARY Provider

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	Provider	varchar	4	Yes
	Description	varchar	30	Yes
	LastName	varchar	15	Yes
	FirstName	varchar	10	Yes
	Title	varchar	30	Yes
	ADDRESS1	varchar	40	Yes
	ADDRESS2	varchar	40	Yes
	CITY	varchar	20	Yes
	STATE	varchar	2	Yes
	ZIPCODE	varchar	5	Yes
	PHONE1	varchar	13	Yes
	EXT1	varchar	4	Yes
	PHONE2	varchar	13	Yes
	EXT2	varchar	4	Yes
	NOTE	varchar	60	Yes
	NPI	varchar	12	Yes
	PROVTYPE	varchar	1	Yes
	SERVTYPE	varchar	1	Yes
	DROPRATE	money		Yes
	SERVAREA	varchar	10	Yes
	RATEPERHR	money		Yes
	RATEPERMIL	money		Yes
	Postcode	varchar	8	Yes
	FEDTAXID	varchar	9	Yes
	OTHERID	varchar	12	Yes
	FAXNO	varchar	13	Yes
	CATEGORY	varchar	4	Yes
	TAG	varchar	1	Yes
	EMAIL	varchar	50	Yes
	AllowWebVerification	bit		Yes
	Medcode	bit		Yes
	Timestamp	datetime		Yes

Index Name	Index Description	Index Keys
PK_Providers	clustered, unique, primary key located on PRIMARY	ID
U_Provider	nonclustered, unique located on PRIMARY	Provider