CONSENT_LINK_AUDIT
Description:
This table stores the link review history

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_LNK_CASE_ID VARCHAR No
The case the consent is historically linked to.
4 CONSENT_LNK_PANEL VARCHAR No
The panels on a case the consent is historically linked to
5 CONSENT_LNK_CINST_UTC_DTTM DATETIME (UTC) No
The instant at which a historically linked consent was linked
6 CONSENT_LNK_CUSER_ID VARCHAR No
The user who linked a historically linked consent
7 CONSENT_LNK_CUSER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 CONSENT_LNK_CACT_C_NAME VARCHAR No
The action by which a historically linked consent was linked
May contain organization-specific values: No
Category Entries:
Consent Created - Automatically Linked
Consent Created - Manually Linked
Consent Attached - Automatically Linked
Consent Attached - Manually Linked
Consent Detached
Consent Reviewed - No Changes Needed
Consent Reviewed - Changes to Linked Panels
Consent Edited