Notifications
Clear all
Topic starter
Any advice on how to handle a situation when a provider doesn't start a note on the same day as the visit and forgets to back date the clinical date?
Is adding an append with some dictation stating the visit took place on another date sufficient?
Anyone have a workflow or procedure to handle these situations?
Posted : May 19, 2015 8:33 am
I usually have them send me the request to change it via SQL.
Just change the date and input the Unique SDID for the document.
You can change it using this script:::
UPDATE DOCUMENT
SET CLINICALDATE = dbo.Convert_Date_to_ID('1/1/2015 10:00PM')
WHERE SDID = 'INPUT SDID HERE'
Posted : May 19, 2015 8:41 am
We do it via SQL also. Ours is a little more detailed so I'll share it in case it's useful.I'd be interested to see how others resolve this as well.
Set @pid to the PID of the patient, @docid to the document ID in the chart, and @clinicaldate to the corrected clinical date.
When completed, ensure that you either commit to commit the change, or rollback to revert it (in case something went wrong).
declare @pid varchar (8), @docid varchar (4), @clinicaldate varchar (16);
set @pid = '82008';
set @docid = '177';
set @clinicaldate = '2011-09-23';
select document.pid, document.clinicaldate from document, patientprofile
where
document.pid = patientprofile.pid and
patientprofile.patientid = @pid and
document.visdocid = @docid;
begin tran
update document set document.clinicaldate = cast(DATEDIFF(second, '1960-01-01', @clinicaldate) as numeric) * '1000000' from document,patientprofile where document.pid = patientprofile.pid and patientprofile.patientid = @pid and document.visdocid = @docid;select document.pid, document.clinicaldate from document, patientprofile where document.pid = patientprofile.pid and patientprofile.patientid = @pid and document.visdocid = @docid;
-- You MUST commit or rollback this transaction or you will bring the EMR to a screeching HALT!!!!!!!
--commit
--rollback
Posted : May 19, 2015 9:04 am
The only issue with that SLHV is sometimes CPS will duplicate Vis Doc ID's. I have seen this for multiple offices.
Posted : May 19, 2015 9:57 am
Can either of the above also be run on CEMR?
Posted : May 20, 2015 2:17 am
Acantu - I don't want to just assume, but for your script, we would end that with Commit, correct? Also, can this be done if it is in either Signed or on hold status?
Thanks,
Linda
Posted : May 20, 2015 6:26 am
Hi Dawn, yes, this can run on EMR Oracle, if you need assistance, please let me know.
Hi Linda, yes, it will work with both Signed and on Hold documents, also it should look like this, the original post was just the transaction script, but yes, should be embedded in a transaction, should be like this:
BEGIN TRY
BEGIN TRANSACTION
UPDATE DOCUMENT
SET CLINICALDATE = dbo.Convert_Date_to_ID('1/1/2015 10:00PM')
WHERE SDID = 'INPUT SDID HERE'
COMMIT
END TRY
BEGIN CATCH
IF @@ERROR > 0
ROLLBACK
END CATCH
Also, to get your SDID for your Document, you can run this script
SELECT SDID, SUMMARY, STATUS, dbo.Convert_ID_to_date(CLINICALDATE) AS CLINICALDATE, VISDOCID
FROM DOCUMENT
WHERE PID IN (SELECT PID FROM PatientProfile WHERE PatientId = 'ENTER PATIENT ID HERE' AND pstatus = 'A')
AND VISDOCID = 'INPUT VISIT DOC ID HERE'
Posted : May 20, 2015 6:43 am
Topic starter
What about the OBS values? They would still have the same date as when the original document was created.
Posted : May 20, 2015 7:44 am
the OBS Values will stay the same, unless you want those to be changed, but usually we do not touch that as those are the dates that it was actually inputted.
Posted : May 20, 2015 7:46 am
Thank you very much.
Posted : May 20, 2015 8:00 am
