CL_LNK_CONTACT

Description:

This table contains the overtime single items in the Linked Order Groups (LNK) master file.

Primary Key

Column Name	Ordinal Position
LNK_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	LNK_ID	NUMERIC	No
	The unique ID for the linked order group.
2	CONTACT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	CONTACT_SERIAL_NUM	NUMERIC	No
	The unique contact serial number (CSN) of the linked order group contact.
5	CONTACT_NUM	INTEGER	No
	The contact number in the linked order group record.
6	CNCT_TYPE_C_NAME	VARCHAR	No
	The contact type category ID for the linked order group record, which describes the action taken on the linked order group. May contain organization-specific values: No Category Entries: Pended Ordered Verified Modified PendedModified
7	INST_OF_ENTRY_TM	DATETIME (Local)	No
	The last instant this linked order group record was edited.