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.