PAT_INDICATOR_INFO

Description:

The PAT_INDICATOR_INFO table contains information about your patient genomic indicator records.

Primary Key

Column Name	Ordinal Position
PAT_IND_CSN_ID	1

Column Information

	Name	Type	Discontinued?
1	PAT_INDICATOR_ID	NUMERIC	No
	This column contains the unique identifier (.1 item) for the pt indicators record.
2	CONTACT_DATE	DATETIME	No
	This column contains the date of this contact in calendar format.
3	PAT_IND_CSN_ID	NUMERIC	No
	This column contains the contact serial number (CSN) of the contact.
4	UPDATE_USER_ID	VARCHAR	No
	This column contains the EMP ID of the user that has made an update to this PGI record.
5	UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	INSTANT_OF_ENT_DTTM	DATETIME (Local)	No
	This column contains the instant of entry when the genomic indicator record is edited.
7	HIDDEN_FROM_PAT_YN	VARCHAR	No
	This column contains whether the genomic indicator is hidden from the patient. If null, the default is No. May contain organization-specific values: No Category Entries: No Yes
8	REMOVAL_REASON_C_NAME	VARCHAR	No
	This column contains the reason why a patient's genomic indicator was marked as "removed" from the patient's genomic indicators list. May contain organization-specific values: Yes Category Entries: Unspecified Entered in error Removed by translation engine