COVERAGE_MEM_ATTR

Description:

The COVERAGE_MEM_ATTR table contains a list of coverage attributes assigned to members on coverages.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
LINE	2
PAT_ID	3
ATTR_LINE	4

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The unique ID assigned to the coverage record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2	LINE	INTEGER	No
	The line count for patients on the coverage.
3	PAT_ID	VARCHAR	No
	The unique patient ID for each line on the coverage.
4	ATTR_LINE	INTEGER	No
	The line number used to identify each attribute for a patient.
5	CVG_ATTR_C	INTEGER	No
	The coverage attribute attached to the member/coverage combination.
6	EFF_DATE	DATETIME	No
	The effective date of the coverage attribute for the member on the coverage.
7	TERM_DATE	DATETIME	No
	The termination date of the coverage attribute for the member on the coverage.
8	COMMENTS	VARCHAR	No
	The free text comment associated with the coverage attribute for the member on the coverage.