LNO_NOADD_SINGLE

Description: |
The LNO_NOADD_SINGLE table contains information about your patient note records. This includes patient summary extracts, lab result reports, and other generated patient documents. All LNO records are included in this table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EXTRACT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EXTRACT_ID | NUMERIC | No |
The unique ID of the patient summary extract record.
2 | EXTRACT_NAME | VARCHAR | No |
The internal name of the patient summary extract.
3 | TRANSFER_DATE | DATETIME | No |
The date that the extract was transferred to the external document management system.
4 | EXT_DOC_LINK | VARCHAR | No |
The link to the document stored in an external document management system.
5 | 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.
6 | EXTRACT_INSTANT | DATETIME (Local) | No |
The instant in which the patient summary extract was created.
7 | TRIGGER_USER_ID | VARCHAR | No |
The user who triggered the extract. Contains the internal ID of that user.
8 | TRIGGER_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.