MEM_CUST_ATTR

Description:

This table holds member level custom attribute values.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CUST_ATTR_TYPE_C_NAME	VARCHAR	No
	Custom attribute value type indicator. May contain organization-specific values: Yes No Entries Defined
4	CUST_ATTR_DT1_DT	DATETIME	No
	First date value for the custom attribute.
5	CUST_ATTR_DT2_DT	DATETIME	No
	Second date value for the custom attribute.
6	CUST_ATTR_CD1_C_NAME	VARCHAR	No
	First coded category value for the custom attribute. May contain organization-specific values: Yes No Entries Defined
7	CUST_ATTR_TXT1	VARCHAR	No
	First free-text value for the custom attribute.
8	CUST_ATTR_TXT2	VARCHAR	No
	Second free-text value for the custom attribute.
9	CUST_ATTR_NUM1	NUMERIC	No
	First numeric value for the custom attribute.
10	CUST_ATTR_NUM2	NUMERIC	No
	Second numeric value for the custom attribute.
11	CUST_ATTR_CD2_C_NAME	VARCHAR	No
	Second coded category value for the custom attribute. The category values for this column were already listed for column: CUST_ATTR_CD1_C_NAME