PAT_SPECIFIC_PACKAGES

Description:

The PAT_SPECIFIC_PACKAGES table contains information about Patient-Specific Packages. These include the Package ID, Linked Barcode, Linking User, and Link Instant of a Package-Specific Package.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	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.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6	PSP_IDENT	VARCHAR	No
	The unique identifier for the Patient-Specific Package.
7	PSP_LINKED_PACKAGE_NDC_ID	VARCHAR	No
	The unique identifier (.1 item) for the NDC record of the package linked to this Patient-Specific Package.
8	PSP_LINKED_PACKAGE_NDC_ID_NDC_CODE	VARCHAR	No
	The external code for the National Drug Code (NDC). An NDC represents packages of medications.
9	LINKING_USER_ID	VARCHAR	No
	The unique identifier (.1 item) for the EMP record of the user who linked the Patient-Specific Package to this patient.
10	LINKING_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
11	LINK_UTC_DTTM	DATETIME (UTC)	No
	The instant the Patient-Specific Package was linked to this patient.