Skip to main content

FoRSE Mapping

Use the FoRSE Mapping form in myAvatar (Avatar PM > System Maintenance > System Definition > FoRSE Mapping) to indicate where in myAvatar the data reportable to FoRSE is captured. Also use this form to establish any necessary translation of myAvatar data to the codes or text identified by FoRSE to consistently identify data elements.

This configuration is used to map myAvatar forms to FoRSE surveys. Unlimited mappings can be added for FoRSE survey and myAvatar form combinations.

Prerequisite:

  • Complete the mapping for the FoRSE Demographic form V2 first, before entering other mappings. The FoRSE Mapping form does not allow other mappings to be entered unless the FoRSE Demographic Form V2 is completed.
FoRSE Demographic form V2

All questions for the FoRSE Demographic Form V2 survey are required and should be entered when updating client demographics. If not entered, then myAvatar defaults to using the following information:

Age At Admission If the date of birth (DOB) is not entered, the age defaults to "0".
Gender This is a required myAvatar element.
Sexual Orientation If not entered, this value defaults to "Unknown".
Race/Ethnicity (choose all that apply) If not entered, this value defaults to "Other".
Fields on FoRSE Mapping form
Field SQL Columns Description
Type of Survey FoRSEInstrumentID

FoRSE Surveys defined here: https://naatpdata.com/v2/docs/APIdoc_Surveys.php

EHR Facility IDs FacilityID

The Facility ID is used when establishing the connection to register new facilities and check the status.

A separate message is sent for each EHR facility selected here.

Enabled

enabled_code

enabled_value

 

 

FoRSE field mapping

Field Mapping

Question Number FoRSEQuestionID FoRSE Question ID in survey definition
Question Text FoRSEQuestionDesc FoRSE Question Text
Avatar Form

care_record_form_product

care_record_form_id

care_record_form_desc

Avatar Form ID
Avatar Field

care_record_field_num

care_record_field_desc

Avatar Field ID
FoRSE field translation 

Field Translation (SYSTEM.FoRSEFieldTranslation)

ID (System use only) JOIN_TO_FORSEMAPPING This column is not available in the grid. It is saved in the background to link the tables.
Avatar Code (Dictionary) carerecord_code This is the dictionary code to be replaced with the FoRSE code upon submission. This allows pre-existing dictionaries that may not align with the codes FoRSE needs to send the correct FoRSE codes.

Please note when defining the mapping initially, these codes are auto populated along with the matched ones in FoRSE.

Important: Review to ensure the codes are defaulted properly (matching to each other as expected).

Avatar Code (Text) carerecord_text Free text value to be replaced with FoRSE code upon submission
FoRSE Code forse_code FoRSE code that is sent
FoRSE Code (Text) forse_text FoRSE text that is sent

 

► See also
► SQL tables
  • SYSTEM.FoRSEMapping
  • SYSTEM.FoRSEFieldTranslation

 

  • Was this article helpful?