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