Extensions

Advanced Analytics

Give teams relevant visibility into their responsibilities.

Choose sources

Identify the operational source, owner and reporting boundary. Agree which facilities, encounters and financial records can contribute to each view and how data completeness will be checked.

  • Data owner
  • Source system, entity scope and data ownership
View the full workflow
01 / 04
01

Advanced Analytics

From the first action to the final record.

01

Choose sources

Identify the operational source, owner and reporting boundary. Agree which facilities, encounters and financial records can contribute to each view and how data completeness will be checked.

Responsible team
Data owner
Data & records
Source system, entity scope and data ownership
02

Define measures

Specify the unit of analysis, numerator, denominator, exclusions and reporting period. Reconcile financial and activity totals before treating a dashboard as an accepted measure.

Responsible team
Operations and finance analysts
Data & records
Metric definition, period, filters and control totals
03

Publish a view

Configure the selected dashboard provider and view for its facility context. Verify role access, refresh behaviour, filters and the meaning of each displayed value with the intended users.

Responsible team
Reporting administrator
Data & records
Dashboard configuration, context and access permissions
04

Monitor & maintain

Review source freshness and changes to definitions or mappings. Agree export controls and retain acceptance evidence when a view is used for operational or financial decisions.

Responsible team
Dashboard and source owners
Data & records
Freshness, reconciliation and definition change record
02

Your configuration

The data that makes this module yours.

  1. Download the template for your account’s selected release.
  2. Use the sample to understand formats; replace every example with approved data.
  3. Load parent records first, then use their exact identifiers in dependent files.
  4. Upload in the named setup step, fix validation errors and review the preview.
  5. Apply and save; test the workflow and record approval before activation.
Your organizationorganization.csvAccount configuration

Use the registered details of your organization. Do not enter patient records here.

Upload in the matching account setup step, review the preview, apply the values and Save and continue. The tenant version may define different columns; download its template inside setup.

Columns, formats and example values
ColumnRequiredFormatExample
Registered organization namelegal_nameYestextExample Healthcare Organization
Commercial registration numberregistration_numberYestextEXAMPLE-CR-001
CountrycountryYesSA / AE / BH / KW / QA / OM / EG / OTHERSA
Tax registration numbervat_numberOptionaltext—
Facilitiesfacilities.csvAccount configuration

Add every facility included in your subscription. These become real, separate facilities in your app.

Upload in the matching account setup step, review the preview, apply the values and Save and continue. The tenant version may define different columns; download its template inside setup.

Load / review first: Your organization

Columns, formats and example values
ColumnRequiredFormatExample
Facility namenameYestextExample Facility
Facility typetypeYeshospital / clinic / polyclinic / laboratory / otherclinic
Facility licenselicense_numberYestextEXAMPLE-LICENSE-001
AddressaddressYestextExample training address
PhonephoneYestext+966500000000
Time zonetimezoneYesAsia/Riyadh / Asia/Dubai / Asia/Qatar / Africa/Cairo / UTCAsia/Riyadh
Departmentsdepartments.csvAccount configuration

Create departments, consultation rooms, wards and beds. You can add more inside your app.

Upload in the matching account setup step, review the preview, apply the values and Save and continue. The tenant version may define different columns; download its template inside setup.

Load / review first: Facilities

Columns, formats and example values
ColumnRequiredFormatExample
Facility number (starting at 1)facilityYesinteger 1–10001
Department namenameYestextExample Department
Rooms, wards and bedslocations.csvAccount configuration

Create departments, consultation rooms, wards and beds. You can add more inside your app.

Upload in the matching account setup step, review the preview, apply the values and Save and continue. The tenant version may define different columns; download its template inside setup.

Load / review first: Facilities

Columns, formats and example values
ColumnRequiredFormatExample
Facility numberfacilityYesinteger 1–10001
Location namenameYestextExample Room
TypekindYesroom / ward / bedroom
Inside location (optional)parentOptionaltext—
Planned teamstaff.csvAccount configuration

Your verified account becomes the facility administrator. Invite staff in the account portal; staff seats are enforced.

Upload in the matching account setup step, review the preview, apply the values and Save and continue. The tenant version may define different columns; download its template inside setup.

Columns, formats and example values
ColumnRequiredFormatExample
NamenameYestextExample Staff
Work emailemailYesemailstaff@example.invalid
Clinical roleroleYesfacility_admin / doctor / nurse / pharmacist / reception / billing / memberdoctor
Services & department catalogueservices.csvAccount configuration

Healthcare service directory

Upload in Your products · configuration data. Apply, then Save and continue checks cross-file references. Launch imports supported records in one transaction and reconciles counts. Function settings are validated against the supported registry, applied natively and read back; prices, catalogue mappings and hardware require approval before activation.

Load / review first: Departments · Rooms, wards and beds

Columns, formats and example values
ColumnRequiredFormatExample
Local service codeservice_codeYestextEXAMPLE-SVC-001
English namename_enYestextExample service
Arabic namename_arYestextخدمة تدريبية
Facility numberfacilityYesinteger 1–10001
DepartmentdepartmentYestextExample Department
LocationlocationYestextExample Room
Service functioninternal_typeYesgeneral / scheduling / lab / pharmacy / storescheduling
Service prices & SBS mappingservice_billing.csvAccount configuration

Draft charge definitions with release-bound SBS codes

Upload in Your products · configuration data. Apply, then Save and continue checks cross-file references. Launch imports supported records in one transaction and reconciles counts. Function settings are validated against the supported registry, applied natively and read back; prices, catalogue mappings and hardware require approval before activation.

Load / review first: Services & department catalogue

Columns, formats and example values
ColumnRequiredFormatExample
Facility numberfacilityYesinteger 1–10001
Local service codeservice_codeYestextEXAMPLE-SVC-001
Gross price in minor currency unitsgross_price_minorYesinteger 0–214748364715000
CurrencycurrencyYesSARSAR
SBS codesbs_codeOptionaltext—
SBS releasesbs_releaseOptionaltext—
Mapping approval referencemapping_evidenceOptionaltext—
Function settings · scheduling closuresproduct_settings.csvAccount configuration

Registry function settings applied to native scheduling closures with readback

Upload in Your products · configuration data. Apply, then Save and continue checks cross-file references. Launch imports supported records in one transaction and reconciles counts. Function settings are validated against the supported registry, applied natively and read back; prices, catalogue mappings and hardware require approval before activation.

Load / review first: Rooms, wards and beds

Columns, formats and example values
ColumnRequiredFormatExample
Facility numberfacilityYesinteger 1–10001
Selected feature IDfeatureYesschedulingscheduling
Function settingfunction_keyYesscheduling.closuresscheduling.closures
Closure namenameYestextExample closure
First closed datevalid_fromYesYYYY-MM-DD2026-12-01
Last closed datevalid_toYesYYYY-MM-DD2026-12-01
Closed fromstart_timeYesHH:MM08:00
Closed untilend_timeYesHH:MM17:00
Room (blank closes the whole facility)locationOptionaltextExample Room
organizationsrcm_organizations.csvImplementation record

Create the legal payer, insurer, administrator/TPA and provider counterparties that every downstream contract, policy, tariff and integration route names.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Columns, formats and example values
ColumnRequiredFormatExample
internal codeinternal_codeYesSource-backed valueTO-CONFIRM
legal name arlegal_name_arYesSource-backed valueTO-CONFIRM
legal name enlegal_name_enYesSource-backed valueTO-CONFIRM
country codecountry_codeYesSource-backed valueSA
statusstatusYesReadiness condition: status=activedraft
evidence stateevidence_stateYesReadiness condition: evidence_state in activation-grade evidenceabsent
commercial registrationcommercial_registrationOptionalSource-backed valueTO-CONFIRM
tax numbertax_numberOptionalSource-backed valueTO-CONFIRM
license numberlicense_numberOptionalSource-backed valueTO-CONFIRM
parent organizationparent_organizationOptionalSource-backed valueTO-CONFIRM
contact directorycontact_directoryOptionalSource-backed valueTO-CONFIRM
Approval referenceapproval_referenceYestextEXAMPLE-REF-001
insurer rolesrcm_insurer_roles.csvImplementation record

Mark which organization is the risk-bearing payer/insurer so policy, claim and settlement decisions do not infer that a TPA is the payer.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: organizations

Columns, formats and example values
ColumnRequiredFormatExample
organizationorganizationYesSource-backed valueTO-CONFIRM
roleroleYesReadiness condition: role=insurerinsurer
effective fromeffective_fromYesSource-backed value2026-10-09
statusstatusYesReadiness condition: status=activedraft
evidence stateevidence_stateYesReadiness condition: evidence_state in activation-grade evidenceabsent
effective toeffective_toOptionalSource-backed value2026-10-09
network scopenetwork_scopeOptionalSource-backed valueTO-CONFIRM
notesnotesOptionalSource-backed valueTO-CONFIRM
Approval referenceapproval_referenceYestextEXAMPLE-REF-001
provider contractsrcm_provider_contracts.csvImplementation record

Record the signed hospital-provider commercial contract that gives authority for allowed pricing, billing windows and settlement terms.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: organizations · insurer roles

Columns, formats and example values
ColumnRequiredFormatExample
payer or insurer orgpayer_or_insurer_orgYesSource-backed valueTO-CONFIRM
provider facilityprovider_facilityYesSource-backed valueTO-CONFIRM
contract numbercontract_numberYesSource-backed valueEXAMPLE-CONTRACT-001
effective fromeffective_fromYesSource-backed value2026-10-09
currencycurrencyYesSource-backed valueSAR
statusstatusYesReadiness condition: status=activedraft
evidence stateevidence_stateYesReadiness condition: evidence_state in activation-grade evidenceabsent
effective toeffective_toOptionalSource-backed value2026-10-09
network tiernetwork_tierOptionalSource-backed valueTO-CONFIRM
claim submission deadlineclaim_submission_deadlineOptionalSource-backed valueTO-CONFIRM
payment termspayment_termsOptionalSource-backed valueTO-CONFIRM
appeal termsappeal_termsOptionalSource-backed valueTO-CONFIRM
Approval referenceapproval_referenceYestextEXAMPLE-REF-001
Revenue & reconciliation controlsrcm_financial_controls.csvImplementation record

Reconcile normal, denied, partially paid, reversed and unmatched activity with explicit finance ownership.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: Service prices & SBS mapping · provider contracts · Acceptance tests

Columns, formats and example values
ColumnRequiredFormatExample
Control codecontrol_codeYestextEXAMPLE-FIN-01
Transaction typetransaction_typeYescharge / invoice / claim / remittance / reversal / refund / write_offclaim
CurrencycurrencyYesISO 4217SAR
Expected source totalsource_totalYesdecimal1000.00
Observed target totaltarget_totalYesdecimal1000.00
Approved tolerancetoleranceYesdecimal; do not assume a tolerance0.00
Exception queue / ownerexception_routeYestextFinance review
Reconciliation evidenceevidence_referenceYestextEXAMPLE-REF-001
Approval referenceapproval_referenceYestextEXAMPLE-REF-002
Project scopeproject_scope.csvImplementation record

Freeze products, versions, facilities, delivery mode and acceptance scope.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Columns, formats and example values
ColumnRequiredFormatExample
Catalogue product IDproduct_idYestextoutpatient
Agreed releasereleaseYestextTO-CONFIRM
Operating modemodeYesnative / connectednative
Facility scopefacility_scopeYestextall
Included in this projectincludedYestrue / falsetrue
Accountable roleowner_roleYestextProject owner
Acceptance evidenceacceptance_testYestextApproved end-to-end test
Approval referenceapproval_referenceYestextEXAMPLE-REF-001
Access & approvalsaccess_matrix.csvImplementation record

Map roles to permitted actions and verify access across facility boundaries.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: Facilities · Planned team

Columns, formats and example values
ColumnRequiredFormatExample
RoleroleYestextdoctor
Facility scopefacility_scopeYestextEXAMPLE-FACILITY-001
ResourceresourceYestextPatient record
ActionactionYestextread
AllowedallowedYestrue / falsetrue
Approverapprover_roleYestextSecurity owner
Test evidenceevidence_referenceYestextEXAMPLE-REF-001
Service catalogueservice_catalogue.csvMigration preparation

Define services and approved code mappings before orders, tariffs and interfaces.

Upload this preparation file in Account setup → Implementation files & acceptance evidence. It is saved in your account records. Use the secure migration workspace for actual clinical data. Approve the source-to-target mapping and import adapter for the selected release before any load. Run a dry run, reconcile counts and retain the result log.

Load / review first: Departments

Columns, formats and example values
ColumnRequiredFormatExample
Local service codeservice_codeYestextEXAMPLE-SVC-001
English namename_enYestextExample service
Arabic namename_arYestextخدمة تدريبية
Department codedepartment_codeYestextEXAMPLE-DEPT-001
Unit of serviceunitYestextTO-CONFIRM
Code systemcode_systemYestextTO-CONFIRM
Catalogue releasereleaseYestextTO-CONFIRM
Approved external mappingexternal_codeYestextTO-CONFIRM
Effective fromeffective_fromYesYYYY-MM-DD2026-10-09
Clinical workflow configurationclinical_workflows.csvImplementation record

Record locally approved pathways, responsibilities and exception handling.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: Departments · Access & approvals

Columns, formats and example values
ColumnRequiredFormatExample
Workflow IDworkflow_idYestextEXAMPLE-WF-001
Product IDproduct_idYestextoutpatient
Entry evententry_eventYestextPatient arrival
Responsible roleresponsible_roleYestextNurse
Required informationrequired_informationYestextVerified identity and visit context
Next eventnext_eventYestextClinical consultation
Handover ownerhandover_ownerYestextDoctor
Exception pathexception_pathYestextIdentity mismatch to review
Workflow approvalapproval_referenceYestextEXAMPLE-REF-001
Interface specificationinterfaces.csvImplementation record

Define the agreed message contract. Store references to credentials, never the credentials themselves.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: Facilities · Service catalogue · Existing systems & versions

Columns, formats and example values
ColumnRequiredFormatExample
Interface IDinterface_idYestextEXAMPLE-IF-001
Source systemsource_systemYestextSRC-EPIC-001
Target systemtarget_systemYestextMANSOQ
DirectiondirectionYesinbound / outbound / bidirectionalinbound
Protocol and versionprotocol_versionYestextTO-CONFIRM
Message scopemessage_scopeYestextTO-CONFIRM
Identifier mappingidentifier_mappingYestextTO-CONFIRM
Secret manager referencesecret_referenceYestextREFERENCE-ONLY
Retry and duplicate policyretry_policyYestextTO-CONFIRM
Failure ownerfailure_ownerYestextIntegration owner
Test evidencetest_referenceYestextEXAMPLE-REF-001
Acceptance testsuat_cases.csvImplementation record

Record complete positive, negative, boundary, access and failure tests per product.

Upload in Account setup → Implementation files & acceptance evidence. The data is saved in your account implementation records. Review with the named owner, record approval and attach the evidence. This register records decisions; it does not activate production configuration.

Load / review first: Project scope · Clinical workflow configuration

Columns, formats and example values
ColumnRequiredFormatExample
Test IDtest_idYestextUAT-001
Product IDproduct_idYestextoutpatient
ScenarioscenarioYestextVisit from arrival to financial follow-up
PreconditionspreconditionsYestextApproved setup and synthetic data
Exact actionsactionsYestextTO-CONFIRM
Expected resultexpected_resultYestextTO-CONFIRM
Actual resultactual_resultYestextNOT-RUN
StatusstatusYesnot_run / pass / fail / blockednot_run
Evidence referenceevidence_referenceYestextEXAMPLE-REF-001
Approverapprover_roleYestextProduct owner
Existing systems & versionssource_systems.csvImplementation record

Inventory every source EHR, department system, archive and ERP separately, including the exact installed product and licensed extraction route.

Upload this planning CSV in Account setup → Implementation files & acceptance evidence. Preview, apply and save. Keep source clinical files and identity crosswalk records in the approved secure migration workspace. Record actual evidence references after review; this register does not run a vendor connector or import patient history.

Load / review first: Project scope

Columns, formats and example values
ColumnRequiredFormatExample
System IDsystem_idYestextSRC-EPIC-001
VendorvendorYestextEpic
Installed productproductYestextEpic EHR
Installed releasereleaseYestextTO-CONFIRM
EnvironmentenvironmentYestest / production / archivetest
Facilities coveredfacility_scopeYestextEXAMPLE-FACILITY-001
Source administrator rolesource_ownerYestextSource EHR administrator
Approved extraction routeexport_routeYestextEHI export assessment pending
Licence/access evidencelicence_referenceYestextEXAMPLE-REF-001
Release-specific specificationspecification_referenceYestexthttps://open.epic.com/TechnicalSpecifications
Open the full implementation handbook: assumptions, migration, interfaces, acceptance and cutover
03

Illustrative operating cases

Two cases. Every handover explained.

01Illustrative scenario

Facility activity dashboard

Operations needs a view of accepted service activity for one facility and reporting period.

Prepare first
Source owner, encounter grain, period, exclusions, dashboard provider and permitted audience.
  1. Agree the definition of counted activity and its source.
  2. Reconcile a representative period to accepted control totals.
  3. Configure the provider view, facility context and user access.
  4. Validate filters and refresh behaviour with operational users before accepting the view.

Acceptance evidence

Users know the measure, period, exclusions and source freshness behind each displayed value.

02Illustrative scenario

Revenue view with stale source data

Finance notices a report differs from another view after a failed refresh.

Prepare first
Last accepted refresh, financial source, metric definitions and reconciliation owner.
  1. Identify the stale refresh and affected period rather than showing missing data as zero.
  2. Compare grain, filters, currency and excluded states between views.
  3. Restore the accepted source or provider refresh and reconcile control totals.
  4. Record the issue and any definition change before republishing the view.

Acceptance evidence

Freshness and definition differences are visible, and financial totals reconcile after recovery.

04

Worked operating scenarios

When the normal path changes.

Stale source or failed refresh

Display the last accepted refresh, investigate the provider and source and avoid interpreting missing data as zero activity.

Two reports disagree

Compare their grain, time window, filters and exclusions, then reconcile to the named source before changing the definition.

05

Delivery boundary

Know what connects, and what needs approval.

The analytics connector supplies provider-based dashboard access. Specific dashboards, metrics, warehouse design and external finance feeds require a defined reporting scope and acceptance.

Operating modes
Native
Product readiness
Scope review required for your release
Supported release
Confirm in the accepted scope

Your questions, answered.

What does MANSOQ Advanced Analytics cover?

Selected operational, departmental and revenue reports, separate from standard Core reporting. Choose sources: Identify the operational source, owner and reporting boundary. Agree which facilities, encounters and financial records can contribute to each view and how data completeness will be checked. Define measures: Specify the unit of analysis, numerator, denominator, exclusions and reporting period. Reconcile financial and activity totals before treating a dashboard as an accepted measure. Publish a view: Configure the selected dashboard provider and view for its facility context. Verify role access, refresh behaviour, filters and the meaning of each displayed value with the intended users. Monitor & maintain: Review source freshness and changes to definitions or mappings. Agree export controls and retain acceptance evidence when a view is used for operational or financial decisions.

Explore the details
What setup data does Advanced Analytics need?

Configure the selected release using the account templates, then validate references and preview before import. Required planning and setup files include Interface specification (interfaces.csv); Access & approvals (access_matrix.csv); Revenue & reconciliation controls (rcm_financial_controls.csv); Function settings · scheduling closures (product_settings.csv); Acceptance tests (uat_cases.csv). Each file’s field guide identifies whether it imports setup records or documents a migration/decision.

Explore the details
How does Advanced Analytics handle exceptions?

Stale source or failed refresh Display the last accepted refresh, investigate the provider and source and avoid interpreting missing data as zero activity. Two reports disagree Compare their grain, time window, filters and exclusions, then reconcile to the named source before changing the definition.

Explore the details
How does Advanced Analytics connect with other systems?

The analytics connector supplies provider-based dashboard access. Specific dashboards, metrics, warehouse design and external finance feeds require a defined reporting scope and acceptance.

Explore the details
Explore all frequently asked questions