Developing Bridge-compatible stored procedures

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to: navigation, search

Overview

When developing a stored procedure to file patient information into the TouchWorks EHR there are certain parameters that must be included and patient related parameters must have certain names (e.g. the patient last name field could not be named @PLastName, it must be @LastName or @PatientLastName).

This is applicable to Bridge v2.x, which is compatible with ConnectR v4.6 or greater.


Output parameters

You must include the following:

  • @BridgedObjectID: This is an output parameter used to identify the object to which the object was bridged.
  • @BridgedEncounterID: This is an output parameter used to identify the encounter associated to which the object was bridged.
  • @Status: The status - 0 is success. Negative statuses indicate the type of error, e.g. -100 for patient cannot be identified.

Example:
    @BridgedObjectID uniqueid OUTPUT,
    @BridgedEncounterID uniqueid OUTPUT,
    @Status int OUTPUT

Naming for patient-related fields

The following fields must have one of the parameter names included below it. If the parameter is not named correctly, it will not be picked up by Bridge.

Patient Last Name:

  • @PATIENTLASTNAME
  • @PATIENTLAST

Patient First Name:

  • @PATIENTFIRSTNAME
  • @PATIENTFIRST

Patient Middle Name:

  • @PATIENTMIDDLENAME
  • @PATIENTMIDDLE

Patient DOB:

  • @PATIENTDOB

Patient SSN:

  • @PATIENTSSN

MRN (Organization MRN):

  • @ORGANIZATIONALMRN
  • @ORGANIZATIONMRN
  • @PATIENTMRN
  • @INTERNALORGPATIENTMRN

MRN (Enterprise MRN):

  • @ENTERPRISEMRN

Organization ID:

  • @OrganizationIDOfMRN
  • @OrgOfMRN
  • @PatientOrg
  • @InternalOrganizationOfMRN
  • @InternalOrganization

Registration System:

  • @RegSystem

The last three parameters of your stored procedure must be the following:

  • @dummyBO UNIQUEID = 0 OUTPUT,
  • @dummyBE UNIQUEID = 0 OUTPUT,
  • @dummyStatus INT = 0 OUTPUT