CONSENT_LINKED_SURG_PROCS

Description: |
Contains data pertaining to the surgical procedures the consent document covers.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | VARCHAR | No |
The unique identifier (.1 item) for the document 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 | CONSENT_PROC_ID | VARCHAR | No |
The procedures attached to consent from the case, networked to the procedures list (ORP).
4 | CONSENT_PROC_ID_PROC_NAME | VARCHAR | No |
The name of the surgical procedure record.
5 | CONSENT_PROC_LATERALITY_LRB_C_NAME | VARCHAR | No |
The procedure lateralities attached to consent from the case.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
6 | CONSENT_PROC_DESCRIPTION | VARCHAR | No |
The procedure descriptions attached to consent from the case.
7 | CONSENT_PROC_CASE_ID | VARCHAR | No |
The surgical case that the surgical procedure linked to this consent is on.
8 | CONSENT_PROC_PANEL | INTEGER | No |
The panel to which this procedure on consent belongs.