Skip to main content

Avatar Cal-PM 2024 Update 20

Product Requirements and Recommendations

Avatar Cal-PM required
RADplus required

Recommended Update Level

Avatar Cal-PM 2024 Monthly Release 2024.00.01
RADplus 2024 Monthly Release 2024.00.01

Product Update Description

The following issues are resolved: 1) Cal-OMS Admission web service will not default 'Medication Prescribed As Part Of Treatment' field to "None (0)" if no option is selected. 2) Cal-OMS Discharge and Admission web services will not default the 'Pregnant At Any Time During Treatment' and 'Pregnant At Admission' field respectively to "No (0)" if 'Enable LA County Reporting Requirements' registry setting is not enabled. 3) Cal-OMS Discharge and Admission web services will not default the 'Secondary Drug Frequency', 'Secondary Drug Route' and 'Secondary Drug Age First Use' fields to "99902" when 'Secondary Drug Code' field is set to "None (0)".

Required Updates

None

Included Updates

None

Details

NEW0 CHANGED0 FIXED2
Fixed (2)
Web Service - Cal-OMS Admission
Resolves an issue to ensure that the 'Cal-OMS Admission' web service defaults the value for the 'Medication Prescribed As Part Of Treatment' and 'Pregnant At Admission' fields when those fields are empty while submitting the web service request.
Topics
• Cal-OMS • Cal-Oms Admission • Web Services
 
Web Service - Cal-OMS Discharge
Resolves an issue to ensure that system defaults the value of the field PregnantDuringTreatment to 0 when the WEBSVC CalOMS Discharge is submitted with the blank value for the field if the patient is male and LA County Reporting is set to 'N'.
Topics
• Cal-OMS • Web Services
 
Acceptance Tests

AV-94071 Summary | Details
Web Service - Cal-OMS Admission
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • SOAPUI - CalOMSAdmissionSoap - FileCalOMSAdmission
  • SOAPUI - CalOMSAdmissionSoap - FileCalOMSDischarge
  • Cal-OMS Admission Web Service
Scenario 1: WEBSVC.CalOMSAdmission - Verification of Web Service Filing - Enable LA County Reporting Requirements=YC
Specific Setup:
  • Registry Setting:
  • Avatar Cal-PM Registry Setting 'Enable LA County Reporting Requirements' must be enabled (set to 'YC').
  • Avatar Cal-PM Registry Setting 'Enable Non LA County Requirements' must be enabled (set to 'Y').
  • Admission:
  • A new client is admitted or an existing client is identified. Note the client id, admission program, admission program code to be used as a location of admission.
  • Crystal Reports or other SQL reporting tool.
Steps
  1. Create a SoapUI project for Avatar Cal-PM 'Cal-OMS Admission' web service.
  2. Populate all the required/desired fields to create a Cal-OMS admission record for the client identified. Note all the data defined while creating web service request.
  3. Using the 'Cal-OMS Admission' web service (and/or 'Cal-OMS Admission V2' web service), submit request to 'FileCalOMSAdmission' method to create or update Cal-OMS Admission record.
  4. Confirm 'Cal-OMS Admission' web service responds with confirmation data/ID on successful filing of 'FileCalOMSAdmission' method. Example:"<Confirmation>ClientID:305||EP:1||UniqueID:OMA.001</Confirmation>"
  5. Confirm 'Cal-OMS Admission' web service responds with confirmation message on successful filing of 'FileCalOMSAdmission' method. Example:"<Message>Cal-OMS Admission web service has been filed successfully.</Message>"
  6. Confirm 'Cal-OMS Admission' web service responds with successful status value on successful filing of 'FileCalOMSAdmission' method. Example:"<Status>1</Status>"
  7. Open Avatar Cal-PM 'Cal-OMS Admission' form and select client/episode/Cal-OMS Admission record filed via web service for view/update.
  8. Confirm Cal-OMS Admission record is created/updated in Avatar Cal-PM, with values/data submitted via web service, including the following fields: 'Record To Be Submitted', 'Ethnicity', 'What is your Principal Source of Referral?', 'Primary Drug Route of Administration', 'Secondary Drug Route of Administration', 'Which of the following medication is prescribed as part of treatment?', 'Current Living Arrangements', 'Race 1', 'Race 2', 'Race 3', 'Race 4', 'Race 5'.
  9. Open Crystal Reports or other SQL reporting tool.
  10. In Avatar Cal-PM SQL table 'SYSTEM.cal_oms_admission', ensure data values are filed/present for all fields as filed via web service, including LA-Specific field values noted above.
Scenario 2: WEBSVC.CalOMSAdmission and WEBSVC.CalOMSDischarge - Enable LA County Reporting Requirements=N
Specific Setup:
  • The registry setting 'Enable LA County Reporting Requirements' is set to 'N'.
  • Admission:
  • A new client is admitted or an existing client is identified. Note the client id, admission program, admission program code to be used as a location of admission.
  • Crystal Reports or other SQL reporting tool.

  • The 'Cal-OMS Admission' is submitted for the client with populating data in each field.
  • The GUID value is selected from the 'SYSTEM'.cal_oms_admission table for the client ID.
Steps
  1. Open the SoapUI or any other web service testing tool.
  2. Create a SoapUI project for Avatar Cal-PM 'Cal-OMS Admission' web service.
  3. Create Cal-OMS Admission web service request for the client identified in the setup section with all the fields EXCEPT for the following tags/fields:
  4. *<MedsAsPartOfTreatment>/'Medication Prescribed As Part Of Treatment' = empty
  5. <PregnantAtAdmission>/'Pregnant At Admission' = empty
  6. SecondaryDrugCode = 0
  7. SecondaryDrugFrequency = empty
  8. SecondaryDrugRoute = file empty
  9. SecondaryDrugAgeFirstUse = empty
  10. Using the 'Cal-OMS Admission' web service (and/or 'Cal-OMS Admission V2' web service), submit request to 'FileCalOMSAdmission' method to create or update Cal-OMS Admission record.
  11. Confirm 'Cal-OMS Admission' web service responds with confirmation data/ID on successful filing of 'FileCalOMSAdmission' method. Example:"<Confirmation>ClientID:305||EP:1||UniqueID:OMA.001</Confirmation>".
  12. Confirm 'Cal-OMS Admission' web service responds with confirmation message on successful filing of 'FileCalOMSAdmission' method. Example:"<Message>Cal-OMS Admission web service has been filed successfully.</Message>"
  13. Confirm 'Cal-OMS Admission' web service responds with successful status value on successful filing of 'FileCalOMSAdmission' method. Example:"<Status>1</Status>".
  14. Open Crystal Reports or other SQL reporting tool
  15. Query 'SELECT GUID.* FROM SYSTEM.cal_oms_admission WHERE PATID= [ClientID].
  16. Verify 'GUID' field populates correctly with the unique value. Note this GUID to be used at the time of editing 'WEBSVC.CalOMSDischarge' web service if needed.
  17. Verify the 'meds_part_treatment_code' field defaults to NULL.
  18. Verify the 'meds_part_treatment_value' field defaults to NULL
  19. Verify the 'pregnant_code' field defaults to 0.
  20. Verify the 'pregnant_value' field defaults to No.
  21. Verify the 'sec_drug_code' field defaults to 0.
  22. Verify the 'sec_drug_value' field defaults to None.
  23. Verify the 'sec_drug_first_use' field defaults to 99902
  24. Verify the 'sec_drug_route_code' field defaults to 99902.
  25. Verify the 'sec_drug_route_value' field defaults to None or Not Applicable.
  26. Verify the 'sec_drug_freq' field defaults to 99902.
  27. Close the SQL data viewer tool.
  28. Go back to SoapUI or any other web service testing tool.
  29. Create Cal-OMS Discharge web service request for the client identified in the setup section with all the fields EXCEPT for the following tags/fields:
  30. PregnantDuringTreatment = empty.
  31. SecondaryDrugCode = 0.
  32. SecondaryDrugFrequency = empty.
  33. SecondaryDrugRoute = file empty.
  34. SecondaryDrugAgeFirstUse = empty.
  35. Enter the client ID used above during Cal-OMS admission, episode number, discharge date and status, GUID value in the property 'AssociatedCalOMSAdmission'.
  36. Submit the web service request.
  37. Confirm 'Cal-OMS Admission' web service responds with confirmation data/ID on successful filing of 'FileCalOMSDischarge' method. Example:"<Confirmation>ClientID:305||EP:1||UniqueID:OMD.001</Confirmation>".
  38. Confirm 'Cal-OMS Admission' web service responds with confirmation message on successful filing of 'FileCalOMSDischarge' method. Example:"<Message>Cal-OMS Discharge web service has been filed successfully.</Message>".
  39. Confirm 'Cal-OMS Admission' web service responds with successful status value on successful filing of 'FileCalOMSDischarge' method. Example:"<Status>1</Status>".
  40. Open Crystal Reports or other SQL reporting tool.
  41. Create a Query against 'SYSTEM.cal_oms_discharge' table.
  42. Run the query for the client used in the above step.
  43. Verify 'GUID' field populate correctly with the unique value.
  44. Verify the 'pregnant_code' field defaults to 0.
  45. Verify the 'pregnant_value' field defaults to No.
  46. Verify the 'sec_drug_code' field defaults to 0.
  47. Verify the 'sec_drug_value' field defaults to None.
  48. Verify the 'sec_drug_route_code' field defaults to 99902.
  49. Verify the 'sec_drug_route_value' field defaults to None or Not Applicable.
  50. Verify the 'sec_drug_freq' field defaults to 99902.
  51. Close the SQL data viewer tool.
Scenario 3: WEBSVC.CalOMSDischarge - Verification of Web Service Filing - Enable LA County Reporting Requirements=YC
Specific Setup:
  • Registry Setting:
  • Avatar Cal-PM Registry Setting 'Enable LA County Reporting Requirements' must be enabled (set to 'YC').
  • Avatar Cal-PM Registry Setting 'Enable Non LA County Requirements' must be enabled (set to 'Y').
  • Admission:
  • A new client is admitted or an existing client is identified. Note the client id, admission program, admission program code to be used as a location of admission.
  • Crystal Reports or other SQL reporting tool.
  • Cal-OMS admission is filed for the client and 'GUID' value received from the SYSTEM.cal_oms_admission table to be used in Associated CalOMS admission. Note the value.
Steps
  1. Using the 'Cal-OMS Discharge' web service (and/or 'Cal-OMS Discharge V2' web service), submit request to 'FileCalOMSDischarge' method to create or update Cal-OMS Discharge record.
  2. Confirm 'Cal-OMS Discharge' web service responds with confirmation data/ID on successful filing of 'FileCalOMSDischarge' method. Example <Confirmation>ClientID:305||EP:1||UniqueID:OMD.001</Confirmation>"
  3. Confirm 'Cal-OMS Discharge' web service responds with confirmation message on successful filing of 'FileCalOMSDischarge' method. Example:"<Message>Cal-OMS Discharge web service has been filed successfully.</Message>".
  4. Confirm 'Cal-OMS Discharge' web service responds with successful status value on successful filing of 'FileCalOMSDischarge' method. Example:"<Status>1</Status>".
  5. Open Avatar Cal-PM 'Cal-OMS Discharge' form and select client/episode/Cal-OMS Discharge record filed via web service for view/update.
  6. Confirm Cal-OMS Discharge record is created/updated in Avatar Cal-PM, with values/data submitted via web service.

Topics
• Cal-OMS • Cal-Oms Admission • Web Services
AV-94987 Summary | Details
Web Service - Cal-OMS Discharge
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • SOAPUI - CalOMSAdmissionSoap - FileCalOMSDischarge
  • Cal-OMS Admission Web Service
  • SOAPUI - CalOMSAdmissionSoap - FileCalOMSAdmission
Scenario 1: WEBSVC.CalOMSAdmission and WEBSVC.CalOMSDischarge - Enable LA County Reporting Requirements=N
Specific Setup:
  • The registry setting 'Enable LA County Reporting Requirements' is set to 'N'.
  • Admission:
  • A new client is admitted or an existing client is identified. Note the client id, admission program, admission program code to be used as a location of admission.
  • Crystal Reports or other SQL reporting tool.

  • The 'Cal-OMS Admission' is submitted for the client with populating data in each field.
  • The GUID value is selected from the 'SYSTEM'.cal_oms_admission table for the client ID.
Steps
  1. Open the SoapUI or any other web service testing tool.
  2. Create a SoapUI project for Avatar Cal-PM 'Cal-OMS Admission' web service.
  3. Create Cal-OMS Admission web service request for the client identified in the setup section with all the fields EXCEPT for the following tags/fields:
  4. *<MedsAsPartOfTreatment>/'Medication Prescribed As Part Of Treatment' = empty
  5. <PregnantAtAdmission>/'Pregnant At Admission' = empty
  6. SecondaryDrugCode = 0
  7. SecondaryDrugFrequency = empty
  8. SecondaryDrugRoute = file empty
  9. SecondaryDrugAgeFirstUse = empty
  10. Using the 'Cal-OMS Admission' web service (and/or 'Cal-OMS Admission V2' web service), submit request to 'FileCalOMSAdmission' method to create or update Cal-OMS Admission record.
  11. Confirm 'Cal-OMS Admission' web service responds with confirmation data/ID on successful filing of 'FileCalOMSAdmission' method. Example:"<Confirmation>ClientID:305||EP:1||UniqueID:OMA.001</Confirmation>".
  12. Confirm 'Cal-OMS Admission' web service responds with confirmation message on successful filing of 'FileCalOMSAdmission' method. Example:"<Message>Cal-OMS Admission web service has been filed successfully.</Message>"
  13. Confirm 'Cal-OMS Admission' web service responds with successful status value on successful filing of 'FileCalOMSAdmission' method. Example:"<Status>1</Status>".
  14. Open Crystal Reports or other SQL reporting tool
  15. Query 'SELECT GUID.* FROM SYSTEM.cal_oms_admission WHERE PATID= [ClientID].
  16. Verify 'GUID' field populates correctly with the unique value. Note this GUID to be used at the time of editing 'WEBSVC.CalOMSDischarge' web service if needed.
  17. Verify the 'meds_part_treatment_code' field defaults to NULL.
  18. Verify the 'meds_part_treatment_value' field defaults to NULL
  19. Verify the 'pregnant_code' field defaults to 0.
  20. Verify the 'pregnant_value' field defaults to No.
  21. Verify the 'sec_drug_code' field defaults to 0.
  22. Verify the 'sec_drug_value' field defaults to None.
  23. Verify the 'sec_drug_first_use' field defaults to 99902
  24. Verify the 'sec_drug_route_code' field defaults to 99902.
  25. Verify the 'sec_drug_route_value' field defaults to None or Not Applicable.
  26. Verify the 'sec_drug_freq' field defaults to 99902.
  27. Close the SQL data viewer tool.
  28. Go back to SoapUI or any other web service testing tool.
  29. Create Cal-OMS Discharge web service request for the client identified in the setup section with all the fields EXCEPT for the following tags/fields:
  30. PregnantDuringTreatment = empty.
  31. SecondaryDrugCode = 0.
  32. SecondaryDrugFrequency = empty.
  33. SecondaryDrugRoute = file empty.
  34. SecondaryDrugAgeFirstUse = empty.
  35. Enter the client ID used above during Cal-OMS admission, episode number, discharge date and status, GUID value in the property 'AssociatedCalOMSAdmission'.
  36. Submit the web service request.
  37. Confirm 'Cal-OMS Admission' web service responds with confirmation data/ID on successful filing of 'FileCalOMSDischarge' method. Example:"<Confirmation>ClientID:305||EP:1||UniqueID:OMD.001</Confirmation>".
  38. Confirm 'Cal-OMS Admission' web service responds with confirmation message on successful filing of 'FileCalOMSDischarge' method. Example:"<Message>Cal-OMS Discharge web service has been filed successfully.</Message>".
  39. Confirm 'Cal-OMS Admission' web service responds with successful status value on successful filing of 'FileCalOMSDischarge' method. Example:"<Status>1</Status>".
  40. Open Crystal Reports or other SQL reporting tool.
  41. Create a Query against 'SYSTEM.cal_oms_discharge' table.
  42. Run the query for the client used in the above step.
  43. Verify 'GUID' field populate correctly with the unique value.
  44. Verify the 'pregnant_code' field defaults to 0.
  45. Verify the 'pregnant_value' field defaults to No.
  46. Verify the 'sec_drug_code' field defaults to 0.
  47. Verify the 'sec_drug_value' field defaults to None.
  48. Verify the 'sec_drug_route_code' field defaults to 99902.
  49. Verify the 'sec_drug_route_value' field defaults to None or Not Applicable.
  50. Verify the 'sec_drug_freq' field defaults to 99902.
  51. Close the SQL data viewer tool.
Scenario 2: WEBSVC.CalOMSDischarge - Verification of Web Service Filing - Enable LA County Reporting Requirements=YC
Specific Setup:
  • Registry Setting:
  • Avatar Cal-PM Registry Setting 'Enable LA County Reporting Requirements' must be enabled (set to 'YC').
  • Avatar Cal-PM Registry Setting 'Enable Non LA County Requirements' must be enabled (set to 'Y').
  • Admission:
  • A new client is admitted or an existing client is identified. Note the client id, admission program, admission program code to be used as a location of admission.
  • Crystal Reports or other SQL reporting tool.
  • Cal-OMS admission is filed for the client and 'GUID' value received from the SYSTEM.cal_oms_admission table to be used in Associated CalOMS admission. Note the value.
Steps
  1. Using the 'Cal-OMS Discharge' web service (and/or 'Cal-OMS Discharge V2' web service), submit request to 'FileCalOMSDischarge' method to create or update Cal-OMS Discharge record.
  2. Confirm 'Cal-OMS Discharge' web service responds with confirmation data/ID on successful filing of 'FileCalOMSDischarge' method. Example <Confirmation>ClientID:305||EP:1||UniqueID:OMD.001</Confirmation>"
  3. Confirm 'Cal-OMS Discharge' web service responds with confirmation message on successful filing of 'FileCalOMSDischarge' method. Example:"<Message>Cal-OMS Discharge web service has been filed successfully.</Message>".
  4. Confirm 'Cal-OMS Discharge' web service responds with successful status value on successful filing of 'FileCalOMSDischarge' method. Example:"<Status>1</Status>".
  5. Open Avatar Cal-PM 'Cal-OMS Discharge' form and select client/episode/Cal-OMS Discharge record filed via web service for view/update.
  6. Confirm Cal-OMS Discharge record is created/updated in Avatar Cal-PM, with values/data submitted via web service.
Topics
• Cal-OMS • Web Services