Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
ADDRESSID	2	ADDRESS

	Name	Type
1	LKREGREFERRALSOURCEID	INT
	Description: Primary key

	Name	Type
2	ADDRESSID	INT
	Description: AddressId is a foreign key to the Address table

	Name	Type
3	CODE	NVARCHAR
	Description: The code used to identify the referral source

	Name	Type
4	DESCLONG	NVARCHAR
	Description: The full description used to identify the referral source

	Name	Type
5	DESCSHORT	NVARCHAR
	Description: The abbreviated description used to identify the referral source

	Name	Type
6	NAMEPFX	NVARCHAR
	Description: Title

	Name	Type
7	FIRSTNAME	NVARCHAR
	Description: First Name

	Name	Type
8	LASTNAME	NVARCHAR
	Description: Last Name

	Name	Type
9	NAMESFX	NVARCHAR
	Description: Name Suffix

	Name	Type
10	PHONENUM	NVARCHAR
	Description: Phone Number

	Name	Type
11	EFFECTIVEDATE	DATETIME2
	Description: The calendar date indicating when the referral source code becomes effective for use in the system

	Name	Type
12	DISCONTINUEDATE	DATETIME2
	Description: The calendar date indicating when the referral source code is no longer available for use in the system