Overview

Encounter Sequence can be used (v3.4.0233 or later version) to import data into non-fixed encounters.  The Encounter Sequence is a value unique to an encounter.  The Encounter Sequence for an encounter can be exported through the Data Management page, Bulk Data Tools tab, "Export All Subject Data' link.

Case 1: Have Encounter Date, but no Encounter Sequence

• If encounter date matches an existing encounter, import will update matching encounter.
• If no encounter found with matching encounter date, import will create a new encounter.
• If there are multiple encounters for the encounter date, then must have the encounter sequence.

Case 2: No Encounter Date and have Encounter Sequence.

• If Encounter Sequence matches an existing encounter, import will update matching encounter.
• If no encounter found with matching Encounter Sequence, validation error for missing Encounter Date

Case 3: Have Encounter Date and have Encounter Sequence.

• If Encounter Sequence matches an existing encounter, import will update matching encounter (including Encounter Date).
• If no encounter found with matching Encounter Sequence, import will create a new encounter.

If an Encounter Sequence is needed for a new encounter (for example existing non-fixed encounters exist for the same encounter date being imported), use a value like -1 (which would not exist in the database) and StudyTRAX will create a valid Encounter Sequence.

If importing encounter data using Encounter Sequence and no Encounter Date, check the box for "Allow Subjects To Exist".   The variable code (column heading) to use for Encounter Sequence is:  EncounterSequence