Database Management - SQL Query
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- App Dashboard
- CPT Code Definition (PM)
- Dynamic Form - Edit Service Fee Definition
- File Import
- Registry Settings (PM)
Scenario 1: Cal-PM: File Import - Service Fee/Cross Reference
Specific Setup:
- Service Codes: Create two new service codes ( Service Code 1 & Service Code 2).
- Use Service Fee/Cross Reference Maintenance to add a fee to Service Code 1.
- Create a 'File Import' file for 'Service Fee/Cross Reference' for Service Code 2. Note the service code, from date, and fee.
- The 'File Import' spreadsheet will be included in the update zip file.
Steps
- Open' File Import'.
- Load the file created in setup.
- Compile the file.
- If necessary correct errors, delete the existing file, load and compile again.
- Post the compiled file.
- Open 'Service Fee/Cross Reference Maintenance'.
- Select 'Edit Existing' in 'Enter New Or Edit Existing Fee/Cross Reference'
- Enter 'Service Code 2'.
- Enter the 'From Date'.
- Click [Select Fee/Cross Ref To Edit/Default From Existing].
- Select the desired row in the 'Edit Service Fee Definition' grid,
- Click [OK].
- Validate the data that was submitted in 'File Import' was saved.
Scenario 2: Cal-PM - SQL Table - SYSTEM.billing_tx_xref_table.
Specific Setup:
- Prior to the update being installed, use Crystal Reports or other SQL reporting tool to process a query of the SYSTEM.billing_tx_xref_table. Save the results.
Steps
- After installation of the update, use Crystal Reports or other SQL reporting tool to process a query of the SYSTEM.billing_tx_xref_table. Save the results.
- Compare the results of the two queries to verify that the data is the same.
|
Topics
• Database Management
|
Cal-OMS Submission
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- App Dashboard
- Cal-OMS Annual Update
- Cal-OMS Submission
- Dynamic Form - Cal-OMS Annual Update
- Registry Settings (PM)
Scenario 1: Cal-OMS - Annual Update
Specific Setup:
- Registry Setting: Note the value of 'Avatar PM->California Required EDI->Cal OMS Reporting->->->Annual Update Number'.
- A value of 'N' excludes the 'Annual Update Number' field on the 'Cal-OMS Annual Update' form.
- A value of 'D' includes the 'Annual Update Number' field on the 'Cal-OMS Annual Update' form as a display only field and will contain the previously submitted 'Annual Update Number'
- A value of 'E' includes the 'Annual Update Number' field on the 'Cal-OMS Annual Update' form as an enabled field. The user can override an existing value, or add a value if blank, if the entry is an integer. If a value is removed and left blank, the standard logic will apply the next time the 'Cal-OMS Annual Update' is processed.
- Client: Select a client that has a submitted 'Cal-OMS Admission' and is due for the 'Cal-OMS Annual Update'.
Steps
- Open 'Cal-OMS Annual Update' for desired client.
- Add Data for all required field and desired optional fields. Note the date of entry.
- Click [Submit].
- Open 'Cal-OMS Submission'.
- Select 'Compile' in 'Option'.
- Enter a 'Through Date' that includes the date of entry.
- Click [Yes].
- Select 'Print' in 'Option'.
- Select desired file in 'Select File To Print/Submit'.
- Click [Print Selected File Annual Update Information].
- Validate that the selected client is included in the report.
- Close the report.
- Close the form.
|
Topics
• Cal-OMS
|
Cal-OMS Submission - Deletion of submitted Discharge
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Admission (Outpatient)
- App Dashboard
- Cal-OMS Admission
- Cal-OMS Discharge
- Cal-OMS Submission
- Dynamic Form - Cal-OMS File Submission
- Program Maintenance
Scenario 1: Cal-OMS Submission - After Deletion of Cal-OMS Discharge
Specific Setup:
- All Cal-OMS setup is complete.
- Client 1: Is age 17 or younger and has a Cal-OMS admission in a Detox program. The admission has been submitted as a ‘Final’ submission.
- Client 2: Is age 18 or older and has a Cal-OMS admission. The admission has been submitted as a ‘Final’ submission.
Steps
- Open ‘Cal-OMS Youth/Detox Discharge’ for Client 1. Note the date of discharge.
- Complete all the fields on the form, noting that some fields are disabled based on values in other fields.
- Submit the form.
- Open ‘Cal-OMS Discharge’ for Client 2. Note the date of discharge.
- Complete all the fields, in all sections, of the form, noting that some fields are disabled based on values in other fields.
- Submit the form.
- Open ‘Cal-OMS Submission’.
- Select ‘Compile’ in ‘Option’.
- Enter a ‘Through Date’ that included the above dates of discharge.
- Click [Submit].
- Select 'Print' in 'Option'
- Select the compiled file in 'Select File To Print/Submit'.
- Click [Print Selected File Discharge Information].
- Validate that both clients are in the report and contain no errors.
- Close the report.
- Close the form.
- Open ‘Cal-OMS Youth/Detox Discharge’ for Client 1.
- Select 'Discharge Delete' in 'Record to be Submitted'.
- Click Submit.
- Open ‘Cal-OMS Discharge’ for Client 2
- Select 'Discharge Delete' in 'Record to be Submitted'.
- Click Submit.
- Open ‘Cal-OMS Submission’.
- Select ‘Compile’ in ‘Option’.
- Enter a ‘Through Date’ that included the above dates of discharge.
- Click [Submit].
- Select 'Print' in 'Option'
- Select the compiled file in 'Select File To Print/Submit'.
- Click [Print Selected File Discharge Information].
- Validate that both clients are in the report and contain no errors.
- Close the report.
- Close the form.
|
Topics
• NX
|