Notifications
Clear all
Topic starter
We are an FQHC with a main facility and a remote location at a local high school.
We need to export the immunization information under seperate facility codes.
Should we set up a single export including both facilities or seperate exports including only the appropriate locations of care?
We have enable the scheduled export task for the main facility. The export file continues to include LinkLogic-Test in its MSH HL7 message. I have checked the task configuration in CPS and the "export data in test mode" box is not selected. I have even stopped and restarted Linklogic. Any possible solutions?
Thank you.
John at Outside In
Posted : November 14, 2012 7:53 am
Topic starter
I was able to get Link Logic after changing the relationships to indicate patients were in the registry by default. Now that works how do I verify? I wrote the sql query below, but its results do not match what was processed last evening.
SELECT
DISTINCT
PatientProfile
.PatientId, PatientProfile.searchname,CAST(PatientProfile.Birthdate ASvarchar(12))AS BirthDate,DATEDIFF(YYYY, PatientProfile.Birthdate,
OBS
.OBSDATE)AS AgeDateOfVaccination, OBS.OBSVALUE AS VfcCodeUsed,CAST(OBS.OBSDATE ASvarchar(20))AS VaccinationDate,
dbo
.Convert_ID_to_date(DOCUMENT.CLINICALDATE)as ClincalDate, OBSDATE, HIERGRPS.GROUPNAME, OBSHEAD.NAME, OBSHEAD.DESCRIPTION, OBSHEAD.MLCODE,
LOCREG
.SEARCHNAME AS Location
FROM
OBSHEAD INNERJOIN
OBS
ON OBSHEAD.HDID = OBS.HDID INNERJOIN
PatientProfile
ONCAST(OBS.PID ASvarchar(20))=CAST(PatientProfile.PId ASvarchar(20))INNERJOIN
HIERGRPS
ON OBSHEAD.GROUPID = HIERGRPS.GROUPID INNERJOIN
[DOCUMENT]
ON OBS.PID = [DOCUMENT].PID AND OBS.SDID = [DOCUMENT].SDID INNERJOIN
LOCREG
ON [DOCUMENT].LOCOFCARE = LOCREG.LOCID
WHERE
(dbo.Convert_ID_to_date(DOCUMENT.CLINICALDATE)BETWEEN'12/13/2012'AND'12/14/2012') --- Changing to OBSdate makes no difference.
--AND (PatientProfile.PatientProfileId = 57531)
AND
OBSHEAD
.NAME like'VFC%'
ORDER
BY OBS.OBSDATE, PatientProfile.searchname
Thank you.
John 
Posted : December 14, 2012 1:51 am
