Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Audit_ChartView_DiscInfo
Touchworks 25.2
[dbo].[Audit_ChartView_DiscInfo]
MS_Description
Audit of Chart view disclosures and Download Chart
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
AuditLogID
[dbo].[uniqueid]
9
NOT NULL
Audit Log entry. Link to Audit_Log.ID
RecordID
[dbo].[uniqueid]
9
NOT NULL
Identifier along with Column Method
RequestReceivedDTTM
datetime
8
NOT NULL
Requested Date and Time
DisclosureDTTM
datetime
8
NULL allowed
Disclosed Date and Time
ReasonForDisclosure
varchar(255)
255
NOT NULL
Reason
ChartView
varchar(255)
255
NOT NULL
Chart View
Method
varchar(10)
10
NOT NULL
Method of Disclosure
ChartDisclosedBy
[dbo].[uniqueid]
9
NOT NULL
Who Disclosed. Link to IDX_User.ID
PDFLocation
varchar(255)
255
NOT NULL
('')
PDF Location
Comments
varchar(255)
255
NOT NULL
('')
Comments
Manifest
varchar(max)
max
NULL allowed
Chart Data in rtf
DocumentCount
varchar(6)
6
NULL allowed
Document Count