Tables [dbo].[Audit_ChartView_DiscInfo]
Audit of Chart view disclosures and Download Chart
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Audit_ChartView_DiscInfo_AuditLogID: AuditLogIDAuditLogID[dbo].[uniqueid]9NOT NULLAudit Log entry. Link to Audit_Log.ID
Indexes IX_Audit_ChartView_DiscInfo_RecordID_MethodRecordID[dbo].[uniqueid]9NOT NULLIdentifier along with Column Method
RequestReceivedDTTMdatetime8NOT NULLRequested Date and Time
DisclosureDTTMdatetime8NULL allowedDisclosed Date and Time
ReasonForDisclosurevarchar(255)255NOT NULLReason
ChartViewvarchar(255)255NOT NULLChart View
Indexes IX_Audit_ChartView_DiscInfo_RecordID_MethodMethodvarchar(10)10NOT NULLMethod of Disclosure
ChartDisclosedBy[dbo].[uniqueid]9NOT NULLWho Disclosed. Link to Works.dbo.IDX_User.ID
PDFLocationvarchar(255)255NOT NULL('')PDF Location
Commentsvarchar(255)255NOT NULL('')Comments
Manifestvarchar(max)maxNULL allowedChart Data in rtf
DocumentCountvarchar(6)6NULL allowedDocument Count