Difference between revisions of "Developing Bridge-compatible stored procedures"
Nate.Bessa (talk | contribs) (Found that three more parameters are absolutely required by the bridge.) |
Nate.Bessa (talk | contribs) |
||
Line 15: | Line 15: | ||
Example:<code><br> | Example:<code><br> | ||
− | @BridgedObjectID uniqueid | + | @BridgedObjectID uniqueid OUTPUT,<br> |
− | @BridgedEncounterID uniqueid | + | @BridgedEncounterID uniqueid OUTPUT,<br> |
@Status int OUTPUT<br> | @Status int OUTPUT<br> | ||
</code> | </code> |
Latest revision as of 15:02, 5 May 2016
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
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