PAT_CARE_REG

Description:

This table contains data for Patient Care Registration. Multiple rows may appear for each registration. Each row represents the data for one registration as it was added, deleted, or modified by a user at a particular point in time.

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	ROW_IDENTIFIER	VARCHAR	No
	The row identifier is used to group current data and audit trail data that are related to the same Patient Care Registration. In this table, multiple rows may appear with the same row identifier. Each row represents an edit that was made to the particular registration. The most current set of data for the registration can be found by looking at the most recent date and time in the EDIT_DATETIME column.
4	USER_ID	VARCHAR	No
	This item holds the User ID of the user who made the change. This column is frequently used to link to the CLARITY_EMP table.
5	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	EDIT_DATETIME	DATETIME (UTC)	No
	This item holds the date and time (in UTC) when the change was made.
7	TYPE_C_NAME	VARCHAR	No
	The Patient Care Registration Type category ID for the registration. May contain organization-specific values: Yes
8	POS_ID	NUMERIC	No
	The unique ID of the organization with which the patient is registered in this particular registration.
9	START_DATE	DATETIME	No
	The start date on which the registration became effective.
10	END_DATE	DATETIME	No
	The end date, after which the registration is no longer effective.
11	IS_DELETED_YN	VARCHAR	No
	Y indicates that the user deleted a registration that was made in error. May contain organization-specific values: No Category Entries: No Yes
12	COMMENT	VARCHAR	No
	User-entered comments about a registration.
13	ADMSN_NOTIF_YN	VARCHAR	No
	Yes indicates that the organization wishes to receive a notification upon the patient's admission. The category values for this column were already listed for column: IS_DELETED_YN
14	EXTERNAL_IDENTIFIER	VARCHAR	No
	An externally assigned identifier for a patient care organization.