|
Name |
Type |
Discontinued? |
|
| 1 |
NOTE_ID |
VARCHAR |
No |
|
|
|
| The note ID for the note record. |
|
|
| 2 |
RELEVANT_REC_EVENT_ID |
VARCHAR |
No |
|
|
|
| Holds the Events (IEV) record which contains records marked relevant to the Note such as problems, allergies, lab results, etc. |
|
|
| 3 |
GROUP_NOTE_ID |
VARCHAR |
No |
|
|
|
| This item stores the group note ID for notes that are created in a group documentation context. |
|
|
| 4 |
LETTER_DEST_C_NAME |
VARCHAR |
No |
|
|
|
| The letter destination category ID for the note. This column is only populated if this row is for a Customer Relationship Management letter. |
| May contain organization-specific values: No |
| Category Entries: |
| Patient Portal |
| Print |
| Print and Portal |
| Email |
| Patient Portal Retracted |
| Print and Portal Retracted |
|
|
| 5 |
LETTER_FINAL_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant the letter was finalized. This column is only populated if this row is for a Customer Relationship Management letter. |
|
|
| 6 |
HNO_RECORD_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| Record type. |
| May contain organization-specific values: No |
| Category Entries: |
| PB Guarantor Note |
| PB Guarantor Letter |
| PB Insurance Follow-up Letter |
| PB Hospital Account Note |
| PB Visit Account Letter |
| CRM Letter |
| CRM Envelope |
| CRM Email |
| HB Guarantor Note |
| HB Hospital Account Note |
| HB Guarantor Letter |
| HB Hospital Account Letter |
| HB Liability Bucket Letter |
| HB Liability Bucket Note |
| HB Contractual History Note |
| EB Guarantor Note |
| Reg Financial Assistance Letter |
| Reg Financial Assistance Tracker Note |
| Reg Financial Assistance Case Note |
|
|
| 7 |
RFL_LETTER_ENC_CSN |
NUMERIC |
No |
|
|
|
| Stores the encounter in which the referral communication letter was written |
|
|
| 8 |
CONV_MSG_CID |
NUMERIC |
No |
|
|
|
| This item contains the Community ID (CID) of a related In Basket Message (EOW) record. |
|
|
| 9 |
OUTREACH_TEMPLATE_ID |
NUMERIC |
No |
|
|
|
| This item stores the campaign outreach template that created the letter. |
|
|
| 10 |
SOURCE_EDITS_CSN |
NUMERIC |
No |
|
|
|
| Stores a Contact Serial Number (CSN) pointer to the General Use Notes (HNO) record that holds edits to the parent note while an attestation is in progress. |
|
|
| 11 |
EXT_DOC_EVNT_ID |
VARCHAR |
No |
|
|
|
| External autoreconciled note event identifier |
|
|
| 12 |
EXT_NOTE_TYPE |
VARCHAR |
No |
|
|
|
| Autoreconciled external note type name |
|
|
| 13 |
EXT_DUP_NOTE_ID |
VARCHAR |
No |
|
|
|
| Autoreconciled extneral note duplicate source note |
|
|
| 14 |
EXT_DUP_NOTE_C_NAME |
VARCHAR |
No |
|
|
|
| Autoreconciled external note duplicate note type |
| May contain organization-specific values: No |
| Category Entries: |
| Same reference ID |
| Duplicate text |
| Same globally unique ID |
|
|
| 15 |
PARENT_NOTE_ID |
VARCHAR |
No |
|
|
|
| The parent note ID of a soft-deleted transcription record. |
|
|
| 16 |
ACTIVE_C_NAME |
VARCHAR |
No |
|
|
|
| Whether the note is active. This item is not populated for all notes. |
| May contain organization-specific values: No |
| Category Entries: |
| Active |
| Inactive |
|
|
| 17 |
EXT_AUTHOR |
VARCHAR |
No |
|
|
|
| Name of the external note's author. The name is stored as pieces delimited by character 127 and is ordered as follows: Last Name, Last Name from Spouse, First Name, Middle Name, Last Name Prefix, Spouse Last Name Prefix, Title, Suffix, Academic Initials. |
|
|
| 18 |
NOTE_UPDATE_INST_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The last time this note was received through Care Everywhere. The value of Received Assessment and Plan Existence Days (I DXC 17000) defines how long notes with this item set exist before they are deleted. Scheduled task Remove HNO Records (E1J 88032) deletes notes and all of their references that have not been received within the amount of days defined by Received Assessment and Plan Existence Days (I DXC 17000) Received Assessment and Plan Existence Days (I DXC 17000) defaults to 30 days if not set. |
|
|
| 19 |
ROUT_RECPNT_COMMUNICATION_ID |
NUMERIC |
No |
|
|
|
| This is a Communication Management (LCA) record that contains information about recipients that users selected for routing in the clinical note editor. |
|
|
| 20 |
EXTERNAL_SOURCE_IDENT |
VARCHAR |
No |
|
|
|
| If this note is associated with information in an outside system, the ID of that information can be stored here. |
|
|
| 21 |
EXTERNAL_PROBLEM_IDENT |
VARCHAR |
No |
|
|
|
| The reference ID for the external problem linked to the note. |
|
|
