We have a custom letter that extracts certain data from an office visit to be sent to the referring provider.
Does anyone know how we can pull in the signing provider of the office visit into the letter? QuickText / MEL?
Use LIST_OBS delimited (for anything you are pulling in or know is in the document), field 4 is signing user, should be he same user that signed the document.
Can I ask how you are pulling data from a specific letter? I am not even aware that what you describe is possible.
Since a letter is its own document, how do you have a new document (which is a letter) pulling data from a specific letter?
gibsonmi said:
Use LIST_OBS delimited (for anything you are pulling in or know is in the document), field 4 is signing user, should be he same user that signed the document.
Thank you, that gets me the data, however I need to manipulate it further. My goal is to get the equivalent of the "Electronically Signed by..." line in the document into this letter. Any ideas?
joeg1962 said:
Can I ask how you are pulling data from a specific letter? I am not even aware that what you describe is possible.
Since a letter is its own document, how do you have a new document (which is a letter) pulling data from a specific letter?
I'm pulling data from a signed document into a letter.
Sam said:
Thank you, that gets me the data, however I need to manipulate it further. My goal is to get the equivalent of the "Electronically Signed by..." line in the document into this letter. Any ideas?
So you want like this?
Electronically signed by Michael Gibson on 09/17/2013 at 3:01 PM
________________________________________________________________________
Its standard text except the signed date and time, there is a date and time field in LIST_OBS, its 2 and 3, but they might reflect the date and time the document was opened instead of signed, have you looked at those?
If those are not correct I think you would have to dive into mldefs, "SignedObs" object from mldefs7.txt would get you what you need to be specific. I can't think of a way to do it with out of the box functions off the top of my head
I'm just trying to pull in the provider's name. The date isn't necessary. This letter will be printed after the office visit is completed, by support staff--not the provider.
So like this?
{fn EndSig(var){
local temp = LIST_OBS(var,'Signed','delimited','value')
if temp=="" then return "" endif //prevent errors if nothing is found
local hold = getfield(temp,"^","")//you only need the first obs, its the most recent
return ("Electronically Signed by " + hold[5] + hret + "____________________________________________________")
}}{EndSig("WEIGHT")}
I didnt test it but I think thats what you are asking for, based on the idea that you are capturing WEIGHT every visit, you could replace that with anything though