Tables [dbo].[Audit_ChartView_DiscInfo]
Audit of Chart view disclosures and Download Chart
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Audit_ChartView_DiscInfo_AuditLogID: AuditLogIDAuditLogIDnumeric(16,0)9NOT NULLAudit Log entry. Link to Audit_Log.ID
Indexes IX_Audit_ChartView_DiscInfo_RecordID_MethodRecordIDnumeric(16,0)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
ChartDisclosedBynumeric(16,0)9NOT NULLWho Disclosed. Link to Works.dbo.IDX_User.ID
PDFLocationvarchar(255)255NOT NULLPDF Location
Commentsvarchar(255)255NOT NULLComments
Manifestvarchar(max)maxNULL allowedChart Data in rtf
DocumentCountvarchar(6)6NULL allowedDocument Count