Table ptms..Agencies

Column Name Type Length Nullable Description Relationships

RateCategory varchar 1 Yes

OtherCategory varchar 1 Yes

SenderID varchar 15 Yes

ReceiverID varchar 15 Yes

ExcludeFas bit Yes

AccountBalance money Yes

LastUpdate datetime Yes

MedicaidProviderID varchar 20 Yes

Timestamp datetime Yes

Identity ID int identity No

Agency varchar 3 Yes

Description varchar 30 Yes

LastName varchar 20 Yes

FirstName varchar 10 Yes

Address1 varchar 30 Yes

Address2 varchar 30 Yes

City varchar 20 Yes

State varchar 2 Yes

Zipcode varchar 5 Yes

Phone1 varchar 13 Yes

Phone2 varchar 13 Yes

Extension1 varchar 4 Yes

Extension2 varchar 4 Yes

Note1 varchar 60 Yes

Note2 varchar 60 Yes

Note3 varchar 60 Yes

Note4 varchar 60 Yes

Note5 varchar 60 Yes

Postcode varchar 8 Yes

FaxNo varchar 13 Yes

Indexes on this table

Index Name Index Description Index Keys

PK_Agencies clustered, unique, primary key located on PRIMARY ID

U_Agency nonclustered, unique located on PRIMARY Agency

	Column Name	Type	Length	Nullable	Description	Relationships
	RateCategory	varchar	1	Yes
	OtherCategory	varchar	1	Yes
	SenderID	varchar	15	Yes
	ReceiverID	varchar	15	Yes
	ExcludeFas	bit		Yes
	AccountBalance	money		Yes
	LastUpdate	datetime		Yes
	MedicaidProviderID	varchar	20	Yes
	Timestamp	datetime		Yes
Identity	ID	int identity		No
	Agency	varchar	3	Yes
	Description	varchar	30	Yes
	LastName	varchar	20	Yes
	FirstName	varchar	10	Yes
	Address1	varchar	30	Yes
	Address2	varchar	30	Yes
	City	varchar	20	Yes
	State	varchar	2	Yes
	Zipcode	varchar	5	Yes
	Phone1	varchar	13	Yes
	Phone2	varchar	13	Yes
	Extension1	varchar	4	Yes
	Extension2	varchar	4	Yes
	Note1	varchar	60	Yes
	Note2	varchar	60	Yes
	Note3	varchar	60	Yes
	Note4	varchar	60	Yes
	Note5	varchar	60	Yes
	Postcode	varchar	8	Yes
	FaxNo	varchar	13	Yes

Index Name	Index Description	Index Keys
PK_Agencies	clustered, unique, primary key located on PRIMARY	ID
U_Agency	nonclustered, unique located on PRIMARY	Agency