Reports switch settings are stored in the database and there is no way to manage these in the Mosaic application or admin tool.
REPORTS_SWITCHES contains a record for each switch and possible value combination. Example below for the Adults Employment Status switch:
SWITCH_NAME | SWITCH_VALUE | DESCRIPTION | MAPPING_VI EW_NAME | MAPPING_V IEW_SQL |
Adults Employment Status | Employment | Employment status is recorded on a clients employment status screen. | NULL | NULL |
Adults Employment Status | Form | Employment status is recorded in form question. | NULL | NULL |
REPORT_SWITCH_MAPPINGS contains the current mapped value for each switch:
SWITCH_NAME | SWITCH_VALUE |
Adults Employment Status | Employment Status |
To update the switch setting, update the value with one of the allowed values from the REPORTS_SWITCHES table.