Skip to main content

Avatar MSO 2024 Update 17

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar MSO required
RADplus required

Recommended Update Level

Avatar MSO 2024 Monthly Release 2024.01.01
RADplus 2024 Monthly Release 2024.01.01

Product Update Description

The following changes are made: 1) The error '[UNDEFINED]%0AmBd5+3^%sqlcq.AVMSO.cls105.1 *%CC]' is resolved when querying the 'table_parentmap_per_prov' table and facility is not defined. 2) The max length of all multi code select fields in the 'plan_covered_services' table have been increased from 254 to 5000.

Required Updates

None

Included Updates

None

Details
NEW1 CHANGED0 FIXED1
New (1)
'Plan Definition' Form, SQL Information
The max length of all multi-code selection fields in Avatar MSO SQL table 'SYSTEM.plan_covered_services' table have been increased to 5000 characters

The max length of the following multi-code selection fields in Avatar MSO SQL table 'SYSTEM.plan_covered_services' table have been increased from 254 to 5000 characters:

  • 'cpt_coverage_group_code'
  • 'cpt_service_codes_code'
  • 'diag_code_for_cvg_code'
  • 'diag_code_no_cvg_code'
  • 'diag_grp_for_cvg_code'
  • 'diag_grp_no_cvg_code'
  • 'elig_reason_code'
  • 'icd10_diag_code_for_cvg_code'
  • 'icd10_diag_code_no_cvg_code'
  • 'procedure_group_code'
  • 'rev_coverage_group_code'
  • 'revenue_code_code'
Value Added: Increases field size for multi-code selection fields in Avatar MSO SQL table 'SYSTEM. plan_covered_services'
Topics
• Plan Definition
 
Fixed (1)
'MSO To Parent System Integration Mapping' Form, SQL Information
An issue is resolved to ensure that error '[UNDEFINED]%0AmBd5+3^%sqlcq.AVMSO.cls105.1 *%CC]' does not occur when querying Avatar MSO SQL table 'SYSTEM.table_parentmap_per_prov' table and facility is not defined.
Topics
• MSO To Parent System Integration Mapping
 
Acceptance Tests
AV-96048 Summary | Details
'Plan Definition' Form, SQL Information
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Plan Definition
Scenario 1: 'Plan Definition' - Verification of SQL Table Information
Specific Setup:
  • Crystal Reports or other SQL reporting tool
Steps
  1. Open Avatar MSO 'Plan Definition' form.
  2. Search/select existing Benefit Plan for update and click 'OK' button to open, or click 'New Plan' button to enter new Benefit Plan.
  3. Enter/select values for fields in 'Plan Definition' main/first section of form as required/desired.
  4. Navigate to 'Plan Coverage Definition' section of form.
  5. Select existing Plan Covered Services row and click 'Edit Selected Item' button, or click 'Add New Item' button to enter new Plan Covered Services row.
  6. Enter/select values for fields in 'Plan Coverage Definition' section of form as required/desired; enter/update additional Plan Covered Services row(s) as desired.
  7. Click 'Submit' button to save/file 'Plan Definition' form/record.
  8. Open Crystal Reports or other SQL reporting tool.
  9. In Avatar MSO SQL table 'SYSTEM.plan_covered_services', ensure that entries filed via 'Plan Definition' form ('Plan Coverage Definition' section) are present in SQL table information.
  10. In Avatar MSO SQL table 'SYSTEM.plan_covered_services', ensure that the field size/maximum character allowance for multi-code selection fields is 5000 characters, including the following fields:
  11. 'cpt_coverage_group_code'
  12. 'cpt_service_codes_code'
  13. 'diag_code_for_cvg_code'
  14. 'diag_code_no_cvg_code'
  15. 'diag_grp_for_cvg_code'
  16. 'diag_grp_no_cvg_code'
  17. 'elig_reason_code'
  18. 'icd10_diag_code_for_cvg_code'
  19. 'icd10_diag_code_no_cvg_code'
  20. 'procedure_group_code'
  21. 'rev_coverage_group_code'
  22. 'revenue_code_code'
Topics
• Plan Definition
AV-96405 Summary | Details
'MSO To Parent System Integration Mapping' Form, SQL Information
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • MSO to Parent System Integration Mapping
Scenario 1: 'MSO To Parent System Integration Mapping' - Verification of SQL Table Information
Specific Setup:
  • One or more Avatar MSO Contracting Provider/Performing Provider records eligible for PM/Cal-PM parent system Program/Practitioner mapping
  • Crystal Reports or other SQL reporting tool
Steps
  1. Open Avatar MSO 'MSO To Parent System Integration Mapping' form.
  2. In first/main section of form, navigate to Avatar MSO 'Contracting Provider/Performing Provider' to Avatar PM/Cal-PM 'Staff/Program' mapping fields (third page/sub-section).
  3. Enter/select value for 'Contracting Provider' and 'Performing Provider' fields.
  4. Enter/select corresponding values for 'Staff' and 'Program' fields.
  5. Click 'File' button to save/file 'Contracting Provider/Performing Provider' to 'Staff/Program' mapping entry; ensure user is presented with filing confirmation dialog noting 'Mapping Has Been Filed Successfully.'
  6. Repeat selection/entry of additional 'Contracting Provider/Performing Provider' to 'Staff/Program' mapping entries as desired.
  7. Open Crystal Reports or other SQL reporting tool.
  8. In Avatar MSO SQL table 'SYSTEM.table_parentmap_per_prov', ensure that all Avatar MSO 'Contracting Provider/Performing Provider' to Avatar PM/Cal-PM 'Staff/Program' mapping entries filed via 'MSO To Parent System Integration Mapping' form ('Plan Coverage Definition' section) are present in SQL table information.
Topics
• MSO To Parent System Integration Mapping
Table Changes
Table Column Change
SYSTEM.plancoveredservices cptcoveragegroupcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices cptservicecodescode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices diagcodeforcvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices diagcodenocvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices diaggrpforcvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices diaggrpnocvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices eligreasoncode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices icd10diagcodeforcvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices icd10diagcodenocvgcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices proceduregroupcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices revcoveragegroupcode Increased max column length from 254 to 5000
SYSTEM.plancoveredservices revenuecodecode Increased max column length from 254 to 5000