Table ptms..Clients

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

ClientID varchar 10 Yes

IntakeDate datetime Yes

LastUpDate datetime Yes

LastName varchar 20 Yes

FirstName varchar 10 Yes

MI varchar 1 Yes

ADDRESS1 varchar 50 Yes

ADDRESS2 varchar 50 Yes

PHONE varchar 13 Yes

CITY varchar 20 Yes

STATE varchar 2 Yes

ZIPCODE varchar 5 Yes

A1 varchar 3 Yes

F1 varchar 3 Yes

P1 varchar 3 Yes

EXPDATE1 datetime Yes

MEDID varchar 16 Yes

A2 varchar 3 Yes

F2 varchar 3 Yes

P2 varchar 3 Yes

EXPDATE2 datetime Yes

SSN varchar 11 Yes

A3 varchar 3 Yes

F3 varchar 3 Yes

P3 varchar 3 Yes

EXPDATE3 datetime Yes

olddob varchar 8 Yes

jdob numeric Yes

A4 varchar 3 Yes

F4 varchar 3 Yes

P4 varchar 3 Yes

EXPDATE4 datetime Yes

SPECIAL varchar 3 Yes

DRVINSTR varchar 255 Yes

SEX varchar 1 Yes

A5 varchar 3 Yes

F5 varchar 3 Yes

P5 varchar 3 Yes

EXPDATE5 datetime Yes

SPECIALDC varchar 10 Yes

GISX numeric Yes

PICKUPPL varchar 50 Yes

PICKUPA1 varchar 50 Yes

PICKUPA2 varchar 50 Yes

MASTER varchar 1 Yes

ZONCODE varchar 6 Yes

ZONNAME varchar 25 Yes

ACCTBAL money Yes

BTNAME varchar 30 Yes

BTADD1 varchar 50 Yes

BTADD2 varchar 50 Yes

BTCITY varchar 25 Yes

BTSTATE varchar 2 Yes

BTZIPCODE varchar 5 Yes

BTPHONE varchar 13 Yes

RACE varchar 1 Yes

MARITAL varchar 1 Yes

INCOME varchar 1 Yes

INCSOURCE varchar 3 Yes

NOSCUR numeric Yes

NOSTD numeric Yes

CANCUR numeric Yes

CANTD numeric Yes

RTPCUR numeric Yes

RTPTD numeric Yes

TTPCUR numeric Yes

TTPTD numeric Yes

CASEMNGR varchar 100 Yes

EMCONTACT varchar 100 Yes

EMPHONE varchar 13 Yes

TRIPCODE1 varchar 3 Yes

TRIPCODE2 varchar 3 Yes

TRIPCODE3 varchar 3 Yes

TRIPCODE4 varchar 3 Yes

TRIPCODE5 varchar 3 Yes

AUTHSRCE1 varchar 1 Yes

AUTHSRCE2 varchar 1 Yes

AUTHSRCE3 varchar 1 Yes

AUTHSRCE4 varchar 1 Yes

AUTHSRCE5 varchar 1 Yes

AUTHTYPE1 varchar 1 Yes

AUTHTYPE2 varchar 1 Yes

AUTHTYPE3 varchar 1 Yes

AUTHTYPE4 varchar 1 Yes

AUTHTYPE5 varchar 1 Yes

CURPRD1 numeric Yes

CURPRD2 numeric Yes

CURPRD3 numeric Yes

CURPRD4 numeric Yes

CURPRD5 numeric Yes

PRVPRD1 numeric Yes

PRVPRD2 numeric Yes

PRVPRD3 numeric Yes

PRVPRD4 numeric Yes

PRVPRD5 numeric Yes

AMTAUTH1 numeric Yes

AMTAUTH2 numeric Yes

AMTAUTH3 numeric Yes

AMTAUTH4 numeric Yes

AMTAUTH5 numeric Yes

UPTRAN varchar 1 Yes

PASSWORD varchar 8 Yes

COMMENT1 varchar 100 Yes

DISAB varchar 3 Yes

ESCORT varchar 1 Yes

DWELL numeric Yes

LANGUAGE varchar 1 Yes

MISC1 varchar 1 Yes

CAPADJ numeric Yes

upjdate numeric Yes

XUPTIME numeric Yes

PHYSICIAN varchar 100 Yes

PHYS_LIC varchar 12 Yes

REGION varchar 4 Yes

PHTYPE varchar 1 Yes

EMPHTYPE varchar 1 Yes

EMPHOWN varchar 1 Yes

PHYPHONE varchar 13 Yes

CASEPHONE varchar 13 Yes

CERTIFYBY varchar 10 Yes

CERTNAME varchar 20 Yes

CERT_LIC varchar 12 Yes

CERTDATE varchar 8 Yes

NUMINHOUSE numeric Yes

RECSTAT varchar 1 Yes

ADA varchar 1 Yes

ZIPEXT varchar 4 Yes

PHEXT varchar 4 Yes

CITYOFRES varchar 20 Yes

OWNVEH varchar 1 Yes

OTHDRV varchar 1 Yes

HEADHOUSE varchar 1 Yes

HHNAME varchar 30 Yes

OTHINSUR varchar 1 Yes

PCA varchar 1 Yes

OTHID varchar 13 Yes

SERMODE varchar 3 Yes

DIAG1 varchar 5 Yes

DIAG2 varchar 5 Yes

PRIORAUTH varchar 12 Yes

PASTDATE varchar 8 Yes

PAENDATE varchar 8 Yes

PRTA4NOTES varchar 1 Yes

LASTSERV numeric Yes

DOB datetime Yes

GISY numeric Yes

LastDateofService datetime Yes

LastUpTime varchar 5 Yes

LastUpUser varchar 30 Yes

GisLatitude varchar 50 Yes

GisLongitude varchar 50 Yes

County varchar 50 Yes

Timestamp datetime Yes

Phyphoneext varchar 10 Yes

Casephoneext varchar 10 Yes

SuspendStart datetime Yes

SuspendEnd datetime Yes

Indexes on this table

Index Name Index Description Index Keys

PK_Clients clustered, unique, primary key located on PRIMARY ID

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	ClientID	varchar	10	Yes
	IntakeDate	datetime		Yes
	LastUpDate	datetime		Yes
	LastName	varchar	20	Yes
	FirstName	varchar	10	Yes
	MI	varchar	1	Yes
	ADDRESS1	varchar	50	Yes
	ADDRESS2	varchar	50	Yes
	PHONE	varchar	13	Yes
	CITY	varchar	20	Yes
	STATE	varchar	2	Yes
	ZIPCODE	varchar	5	Yes
	A1	varchar	3	Yes
	F1	varchar	3	Yes
	P1	varchar	3	Yes
	EXPDATE1	datetime		Yes
	MEDID	varchar	16	Yes
	A2	varchar	3	Yes
	F2	varchar	3	Yes
	P2	varchar	3	Yes
	EXPDATE2	datetime		Yes
	SSN	varchar	11	Yes
	A3	varchar	3	Yes
	F3	varchar	3	Yes
	P3	varchar	3	Yes
	EXPDATE3	datetime		Yes
	olddob	varchar	8	Yes
	jdob	numeric		Yes
	A4	varchar	3	Yes
	F4	varchar	3	Yes
	P4	varchar	3	Yes
	EXPDATE4	datetime		Yes
	SPECIAL	varchar	3	Yes
	DRVINSTR	varchar	255	Yes
	SEX	varchar	1	Yes
	A5	varchar	3	Yes
	F5	varchar	3	Yes
	P5	varchar	3	Yes
	EXPDATE5	datetime		Yes
	SPECIALDC	varchar	10	Yes
	GISX	numeric		Yes
	PICKUPPL	varchar	50	Yes
	PICKUPA1	varchar	50	Yes
	PICKUPA2	varchar	50	Yes
	MASTER	varchar	1	Yes
	ZONCODE	varchar	6	Yes
	ZONNAME	varchar	25	Yes
	ACCTBAL	money		Yes
	BTNAME	varchar	30	Yes
	BTADD1	varchar	50	Yes
	BTADD2	varchar	50	Yes
	BTCITY	varchar	25	Yes
	BTSTATE	varchar	2	Yes
	BTZIPCODE	varchar	5	Yes
	BTPHONE	varchar	13	Yes
	RACE	varchar	1	Yes
	MARITAL	varchar	1	Yes
	INCOME	varchar	1	Yes
	INCSOURCE	varchar	3	Yes
	NOSCUR	numeric		Yes
	NOSTD	numeric		Yes
	CANCUR	numeric		Yes
	CANTD	numeric		Yes
	RTPCUR	numeric		Yes
	RTPTD	numeric		Yes
	TTPCUR	numeric		Yes
	TTPTD	numeric		Yes
	CASEMNGR	varchar	100	Yes
	EMCONTACT	varchar	100	Yes
	EMPHONE	varchar	13	Yes
	TRIPCODE1	varchar	3	Yes
	TRIPCODE2	varchar	3	Yes
	TRIPCODE3	varchar	3	Yes
	TRIPCODE4	varchar	3	Yes
	TRIPCODE5	varchar	3	Yes
	AUTHSRCE1	varchar	1	Yes
	AUTHSRCE2	varchar	1	Yes
	AUTHSRCE3	varchar	1	Yes
	AUTHSRCE4	varchar	1	Yes
	AUTHSRCE5	varchar	1	Yes
	AUTHTYPE1	varchar	1	Yes
	AUTHTYPE2	varchar	1	Yes
	AUTHTYPE3	varchar	1	Yes
	AUTHTYPE4	varchar	1	Yes
	AUTHTYPE5	varchar	1	Yes
	CURPRD1	numeric		Yes
	CURPRD2	numeric		Yes
	CURPRD3	numeric		Yes
	CURPRD4	numeric		Yes
	CURPRD5	numeric		Yes
	PRVPRD1	numeric		Yes
	PRVPRD2	numeric		Yes
	PRVPRD3	numeric		Yes
	PRVPRD4	numeric		Yes
	PRVPRD5	numeric		Yes
	AMTAUTH1	numeric		Yes
	AMTAUTH2	numeric		Yes
	AMTAUTH3	numeric		Yes
	AMTAUTH4	numeric		Yes
	AMTAUTH5	numeric		Yes
	UPTRAN	varchar	1	Yes
	PASSWORD	varchar	8	Yes
	COMMENT1	varchar	100	Yes
	DISAB	varchar	3	Yes
	ESCORT	varchar	1	Yes
	DWELL	numeric		Yes
	LANGUAGE	varchar	1	Yes
	MISC1	varchar	1	Yes
	CAPADJ	numeric		Yes
	upjdate	numeric		Yes
	XUPTIME	numeric		Yes
	PHYSICIAN	varchar	100	Yes
	PHYS_LIC	varchar	12	Yes
	REGION	varchar	4	Yes
	PHTYPE	varchar	1	Yes
	EMPHTYPE	varchar	1	Yes
	EMPHOWN	varchar	1	Yes
	PHYPHONE	varchar	13	Yes
	CASEPHONE	varchar	13	Yes
	CERTIFYBY	varchar	10	Yes
	CERTNAME	varchar	20	Yes
	CERT_LIC	varchar	12	Yes
	CERTDATE	varchar	8	Yes
	NUMINHOUSE	numeric		Yes
	RECSTAT	varchar	1	Yes
	ADA	varchar	1	Yes
	ZIPEXT	varchar	4	Yes
	PHEXT	varchar	4	Yes
	CITYOFRES	varchar	20	Yes
	OWNVEH	varchar	1	Yes
	OTHDRV	varchar	1	Yes
	HEADHOUSE	varchar	1	Yes
	HHNAME	varchar	30	Yes
	OTHINSUR	varchar	1	Yes
	PCA	varchar	1	Yes
	OTHID	varchar	13	Yes
	SERMODE	varchar	3	Yes
	DIAG1	varchar	5	Yes
	DIAG2	varchar	5	Yes
	PRIORAUTH	varchar	12	Yes
	PASTDATE	varchar	8	Yes
	PAENDATE	varchar	8	Yes
	PRTA4NOTES	varchar	1	Yes
	LASTSERV	numeric		Yes
	DOB	datetime		Yes
	GISY	numeric		Yes
	LastDateofService	datetime		Yes
	LastUpTime	varchar	5	Yes
	LastUpUser	varchar	30	Yes
	GisLatitude	varchar	50	Yes
	GisLongitude	varchar	50	Yes
	County	varchar	50	Yes
	Timestamp	datetime		Yes
	Phyphoneext	varchar	10	Yes
	Casephoneext	varchar	10	Yes
	SuspendStart	datetime		Yes
	SuspendEnd	datetime		Yes

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