EXT_DEM_UPDATES

Description:

This table holds the systems and instants that updated demographics in Epic.

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	EXT_DEM_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	This column holds the instant that the associated patient's demographics were updated from an external system (Data Exchange Organization).
4	EXT_DEM_UPDATE_ORG_ID	NUMERIC	No
	This column holds the unique ID of the external system (Data Exchange Organization) from which we received the associated patient's demographic updates
5	EXT_DEM_UPDATE_ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.