CHILD_NOTE_INFO
Description:
The CHILD_NOTE_INFO table contains information about child notes that are linked to clinical notes. Each row represents one child note and contains information such as the user that created the link, when the link was created, and what type of link it is.

Primary Key
Column Name Ordinal Position
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier for the note record.
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 TEXT_NOTE_CSN_ID NUMERIC No
This holds the note contact serial number (CSN) pointer to the record where the child note's text can be found. Any workflow that links a child note to a clinical note must populate this item with the pointer to the child note contact.
4 LINK_TYPE_C_NAME VARCHAR No
This holds the type of linked note. Any workflow that links a child note to a clinical note must populate this item with the type of child note that is being linked. Different link types will have different effects on how the parent clinical note displays or behaves.
May contain organization-specific values: No
Category Entries:
Current Attestation
Previous Attestation
Removed Attestation
Incomplete Attestation
Save Summary
Attest Summary
5 LINK_USER_ID VARCHAR No
Contains the user ID of the user who added the corresponding child note. Any workflow that links a child note to a clinical note must specify the user adding the link in this item.
6 LINK_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 LINK_UTC DATETIME (UTC) No
Holds the instant, in UTC format, that the child note was added to the note. Any workflow that links a child note to a clinical note must populate this item with the UTC timestamp of when the link was added.
8 SOURCE_NOTE_CSN_ID NUMERIC No
Contains the note contact serial number (CSN) of the source contact the child note was originally added to. Any workflow that links a child note to a clinical note must specify which contact on the parent clinical note the child note applies to.
9 LINK_DTTM DATETIME (Local) No
Holds the instant, in local time zone format, that the child note was added to the note. This item is automatically calculated based on the Child Note - Instant (UTC) item (I HNO 34253).