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
