PAT_PRIM_LOC

Description:

The PAT_PRIM_LOC table contains the Primary Location information for your patients over time.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID assigned to the patient record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2	LINE	INTEGER	No
	The line number used to identify each line of Primary Location information for the patient.
3	LOC_ID	NUMERIC	No
	The unique ID of the location record for the Primary Location.
4	EFF_DATE	DATETIME	No
	The date from which the location is in effect as the member’s Primary Location.
5	TERM_DATE	DATETIME	No
	The date after which the location ceases to be the member’s Primary Location.
6	CLIN_HX_COMMENTS	VARCHAR	No
	Clinical history comments.