Access denied. Audit Trail is available only for Project Manager role.

pm = CreateObject("Component", "Menu"); myArgument = 'chart'; pid = (isDefined("getP") AND getP.recordcount GT 0) ? getP.Patient_Id : session.cs.patientid; pm.MenuFunction(myArgument, pid, '', '', '', ''); SELECT COLUMN_NAME, ORDINAL_POSITION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = 'pAssessments' ORDER BY ORDINAL_POSITION

Audit Trail - pAssessments

Select an assessment to view its audit trail. Go to Chart

SELECT a.*, CASE WHEN a.Status = 3 THEN 'Retired (Previous Version)' WHEN a.Status = 0 THEN 'Active' WHEN a.Status = 1 THEN 'Inactive' WHEN a.Status = 2 THEN 'Deleted' WHEN a.Status = 4 THEN 'Incomplete' ELSE CONCAT('Status ', a.Status) END AS StatusLabel, CASE WHEN IFNULL(a.Record_Mod_By,0) < 50 THEN COALESCE(NULLIF(TRIM(su.Full_Name),''), su.Username, CONCAT('SuperUser ', IFNULL(a.Record_Mod_By,0))) ELSE CONCAT(COALESCE(e.Emp_Last,''), ', ', COALESCE(e.Emp_First,'')) END AS ModifiedByName, CASE WHEN IFNULL(a.Record_Mod_By,0) >= 50 THEN e.Emp_Email ELSE NULL END AS ModifiedByEmail FROM #Request.prefix_db_agency#.pAssessments a LEFT JOIN #Request.prefix_db_lookup#.pEmployee e ON e.Emp_ID = a.Record_Mod_By AND IFNULL(a.Record_Mod_By,0) >= 50 LEFT JOIN #Request.prefix_db_lookup#.SuperUsers su ON su.User_ID = a.Record_Mod_By AND IFNULL(a.Record_Mod_By,0) < 50 WHERE a.Assmt_ID = AND a.Patient_ID = ORDER BY a.AutoAssmt_ID DESC, a.Record_Mod_Date DESC

Audit Trail - pAssessments – Assessment ID #GetAuditHistory.Assmt_ID#

Note: For pAssessments, Status 3 indicates a retired (previous version) record. Most recent edits are shown first.

No audit history found for this assessment.

Complete Change History – #totalEdits# edit(s) on this assessment (most recent first)

All changes are listed below.

Current (most recent) Revision #GetAuditHistory.currentRow# of #GetAuditHistory.recordcount# #GetAuditHistory.AutoAssmt_ID# = record created – #StatusLabel#

Who Modified:

#HTMLEditFormat(ModifiedByName)# (#HTMLEditFormat(ModifiedByEmail)#) User ID #Record_Mod_By# System / Unknown

When Modified:

#DateFormat(Record_Creation_Date, "mm/dd/yyyy")# at #TimeFormat(Record_Creation_Date, "HH:mm:ss")# N/A

#changeTitle# (#versionPair#)

Field	Previous Value	New Value
#HTMLEditFormat(row.field)#	#HTMLEditFormat(row.old)#	#HTMLEditFormat(row.new)#