Skip to main content

RADplus 2023 Update 56

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

RADplus required

Recommended Update Level

RADplus 2022 Update 119

Product Update Form Description

The forms 'Report Definition Export', 'Report Definition Import', and 'Site Specific Section Modeling Import/Export' are modified to support auditing.

Included Updates

None

Required Updates

None

Details
NEW1 CHANGED0 FIXED0
New (1)
Report Definition and Site Specific Section Modeling
The "Report Definition Export" and "Report Definition Import" forms are updated with a new field 'Report Definition Version". In addition, the "Site Specific Section Modeling Version' field in the 'Site Specific Section Modeling' is now available for all forms that are eligible for site specific section modeling. Also, new SQL tables 'SYSTEM.RADplus_Import_Audit' and 'SYSTEM.RADplus_Export_Audit' are added to keep a data audit trail of report definition and site specific section modeling import/exports.
Value Added: Provides a data audit trail for file imports and exports
Topics
• 835 • 835 Health Care Claim Payment/Advice • NX • Report Definition Import • Site Specific Section Modeling
 
Acceptance Tests
AV-89045 Summary | Details
Report Definition and Site Specific Section Modeling
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Report Definition (PM)
  • Report Definition Export
  • Report Definition Import (PM)
  • Site Specific Section Modeling (CWS)
  • Site Specific Section Modeling Import/Export (CWS)
Scenario 1: Report Definition "Export/Import" - "Version" number and "Audit" data validations
Specific Setup:
  • Have report [TestReport] form created using form "Report Definition"
  • The logged in user has access to form "Report Definition", "Report Definition Import" and "Report Definition Export"
  • Have a report or query to display data in tables 'SYSTEM.RADplus_Import_Audit' and 'SYSTEM.RADplus_Export_Audit'
Steps
  1. Open form "Report Definition Export"
  2. Select [TestReport]
  3. Validate the "Report Version Number" field present and arranged on the form layout along with the other expected fields
  4. Validate the "Report Version Number" field is populated with the current version number. For this test "1.01" is used. Note the version number value
  5. Validate the field is disabled
  6. Click [Begin Export]
  7. Validate the report export file name automatically includes the report definition name and the "Version" number noted in step 1a. For example: "ReportExportReportTestReportV1_01.TXT"
  8. Save the file in a desired folder location. Note the current date and time
  9. Close the form
  10. Navigate to the location of the export file saved in step 1b
  11. Open the exported file in a text editor, confirm the file is encrypted.
  12. Run a report or query on the "SYSTEM.RADplus_export_audit" table, displaying field data
  13. Validate the "Version" number field is populated with same value of the version field noted in step 1a
  14. Validate "data_entry_user_name" field is the logged in user
  15. Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 1b
  16. Validate the "Report Name" field contains [TestReport]
  17. Open form "Report Definition"
  18. Select [TestReport]
  19. Validate the "Report Version Number" field reflects the value in step 1a
  20. Validate the field is disabled
  21. Make any change to a prompt or parameter on the form
  22. Set field "Is Report Eligible for Export * to "Yes"
  23. Validate the "Report Version Number" has incremented. For this test the version number is now "1.02". Note the version number. Note: "Version Number" will be increased by ".01" whenever the form is updated i
  24. Submit the form
  25. Validate the form files successfully
  26. Open form "Report Definition Export"
  27. Select [TestReport]
  28. Validate the "Report Version Number" field is populated with the current version number noted in step 2a
  29. Click [Begin Export]
  30. Validate the report export file name automatically includes the report definition name and the "Version" number noted in step 2a. For example: "ReportExportReportTestReportV1_02.TXT"
  31. Save the file in a desired folder location. Note the date and time
  32. Close the form
  33. Run a report or query on the "SYSTEM.RADplus_export_audit" table, displaying field data
  34. Validate the "Version" number is populated with same value of the version number field noted in step 3a.
  35. Validate "data_entry_user_name" field is the logged in user
  36. Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 3b
  37. Validate the "Report Name" field contains [TestReport]
  38. Open the form 'Report Definition Import'
  39. Click [Select Report Import File]
  40. Navigate to the location of the original file version exported in step 1b
  41. Validate the field "Report Version Number To Be Imported" is populated with expected version number. For this example "1.01"
  42. Select the "Overwrite Existing" radio button
  43. Click [Begin Import Scan]
  44. Validate the "Import Scan Results" box contains: "Critical Error: Report Name: Report [TestReport]. The import file report version (1.01) is prior to the current report version (1.02). The file contains one or more critical errors and therefore can not be imported. Note the version number of the import file
  45. Validate the [Begin Import] button is disabled
  46. Select the "Create New" radio button
  47. Click [Yes] when prompted with the dialog "This report already exists within this system. Are you sure that you would like to create a new report
  48. Click [Begin Import Scan]
  49. Validate the "Import Scan Results" box contains "There are no errors/warnings found within the import file."
  50. Click [Begin Import]
  51. Click [Yes] at "Are you sure that you want to 'Create New'?" import dialog
  52. Click [OK] at the "Import Complete" dialog. Note the date and time
  53. Close the form. [Please Note: An export file that has been exported with update "RADplus 2023 Update 56" installed, will not be able to imported in systems that do not have that update installed yet]
  54. Run a report or query on the "SYSTEM.RADplus_import_audit" table, displaying field data
  55. Validate the "Version" number is populated with same value version number noted in step 4a
  56. Validate "data_entry_user_name" field is the logged in user
  57. `Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 4a
  58. Validate the "Report Name" field contains [TestReport]
  59. Open form "Report Definition"
  60. Search for [TestReport]
  61. Validate the search display two results for [TestReport], the original version and new copy of the report imported in step 4.
  62. Note: the search results will include the form name of the report appended by the form ID# in parenthesis. Note that the newly imported copy in step 4, will have the higher form (ID#) number. For example:
  63. TestReport (3)
  64. TestReport (4)
  65. Select the first selection, the current updated report
  66. Validate the "Report Version Number" is populated with the current version of the report, for example "1.02"
  67. Validate the change made to the prompt or parameter on the form in step 2a, is displayed as expected
  68. Close the form
  69. Re-open form "Report Definition"
  70. Search for [TestReport]
  71. From the search results select the second selection, which is the imported copy containing the original version of the report
  72. Validate the "Report Version Number" is populated with the version number of the original version of the report, for this example "1.01"
  73. Validate the change made to the prompt or parameter in step 2a is not present, as expected
  74. Close the form
Scenario 2: Site Specific Section Modeling "Export/Import" File - "Version" number and "Audit" data validations
Specific Setup:
  • Have a form [TestForm] that's available for site specific section modeling in form "Site Specific Section Modeling", for example form "Vitals Entry"
  • The logged in user has access to form "Site Specific Section Modeling" and "Site Specific Section Modeling Import/Export"
  • Have a report or query to display data in tables 'SYSTEM.RADplus_Import_Audit' and 'SYSTEM.RADplus_Export_Audit'
Steps
  1. Open form "Site Specific Section Modeling Import/Export"
  2. In the "Select Form to Export" field, select [TestForm]
  3. Validate the "Version Number" field is populated with the current version number and the field is disabled. For this test "1" is used. Note the version number value
  4. Click on the "light bulb" icon to display the help message for the field. Validate the help message is updated to include the following verbiage: "The 'Site Specific Section Modeling Version' is increased by .01 whenever the form is updated in 'Site Specific Section Modeling'. When the 'Site Specific Section Modeling Import/Export' form is used for importing, then the 'Site Specific Section Modeling Version' value will be set to the value from the imported file."
  5. Click [Begin Export]. Note the current date and time
  6. Navigate to a desired file location to save the file
  7. Save the file name with a desired file name and append the version number noted in step 1a to the name. For example, "SSTabExportTestFormV1"
  8. Note the current date and time the file is saved
  9. Close the form
  10. Run a report or query on the "SYSTEM.RADplus_export_audit" table, displaying field data
  11. Validate the "Version" number field is populated with same value of the version field noted in step 1a
  12. Validate "data_entry_user_name" field is the logged in user
  13. Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 1b
  14. Validate the "option_desc" field contain [TestForm]
  15. Open form "Site Specific Section Modeling"
  16. Select [TestForm]
  17. Validate the "Version Number" field reflects the value in step 1a and the field is disabled
  18. Make any change to a prompt or parameter on the form
  19. Submit the form
  20. Validate the form files successfully
  21. Open form "Site Specific Section Modeling Import/Export"
  22. Select [TestForm]
  23. Validate the "Version Number" field has been incremented. For this example "1.01".
  24. Click [Begin Export].
  25. Navigate to a desired file location to save the file
  26. Save the file name with a desired file name and append the new version number noted in step 3a to the name. For example, "SSTabExportTestFormV1.01"
  27. Note the current date and time the file is saved
  28. Close the form
  29. Run a report or query on the "SYSTEM.RADplus_export_audit" table, displaying field data
  30. Validate the "Version" number field is populated with same value of the version field noted in step 3a
  31. Validate "data_entry_user_name" field is the logged in user
  32. Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 3b
  33. Validate the "option_desc" field contain [TestForm]
  34. Open the form "Site Specific Section Modeling Import/Export"
  35. Click [Select Import File]
  36. Navigate to the location of the original file version exported in step 1b. For this test "SSTabExportTestFormV1"
  37. Validate the field "Version Number" is populated with expected version number. For this example "1".
  38. Click [Begin Import Scan]
  39. Validate the "Import Scan Results" box contains: " Warning: The Form Version Number In The System Is Higher Than The Form Version Number In The File"
  40. Click [OK]
  41. Click [Process Import File]. Note the current date and time of the import
  42. Close the form
  43. Run a report or query on the "SYSTEM.RADplus_import_audit" table, displaying field data
  44. Validate the "Version" number is populated with same value version number noted in step 4a
  45. Validate "data_entry_user_name" field is the logged in user
  46. `Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 4a
  47. Validate the "option_desc" field contain [TestForm]
  48. Open form "Site Specific Section Modeling"
  49. Select [TestForm]
  50. Validate the "Version Number" is populated with the original version exported in step 1. For this test "1" is noted.
  51. Validate the change made to the prompt or parameter on the form in step 2, is 'not' present as expected
  52. Close the form
  53. Open the form "Site Specific Section Modeling Import/Export"
  54. Click [Select Import File]
  55. Navigate to the location of the update file version exported in step 3. For this test "SSTabExportTestFormV1.01"
  56. Validate the field "Version Number" is populated with expected version number. For this example "1.01". Note the version number value.
  57. Click [Begin Import Scan]
  58. Validate the "Import Scan Results" box contains: "No errors or warnings found"
  59. Click [Process Import File]
  60. Click [OK] at the "Import Complete" dialog. Note the current date and time of the import
  61. Close the form
  62. Run a report or query on the "SYSTEM.RADplus_import_audit" table, displaying field data
  63. Validate the "Version" number is populated with same value version number noted in step 6a
  64. Validate "data_entry_user_name" field is the logged in user
  65. `Validate the "data_entry_date" and "data_entry_time" fields are consistent with the date and time noted in step 6a
  66. Validate the "option_desc" field contain [TestForm]
  67. Close the form
  68. Open form "Site Specific Section Modeling"
  69. Select [TestForm]
  70. Validate the "Version Number" is populated with the version number noted in step 6a
  71. Validate the change made to the prompt or parameter on the form in step 2, is present as expected
  72. Close the form
Topics
• 835 • 835 Health Care Claim Payment/Advice • NX • Report Definition Import • Site Specific Section Modeling
Table Changes
Table Column Change
SYSTEM.RadPlus_Import_Audit FACILITY added
SYSTEM.RadPlus_Import_Audit type_code added
SYSTEM.RadPlus_Import_Audit type_value added
SYSTEM.RadPlus_Import_Audit audit_option_id added
SYSTEM.RadPlus_Import_Audit audit_option_desc added
SYSTEM.RadPlus_Import_Audit version added
SYSTEM.RadPlus_Import_Audit report_name added
SYSTEM.RadPlus_Import_Audit content added
SYSTEM.RadPlus_Import_Audit option_id added
SYSTEM.RadPlus_Import_Audit option_desc added
SYSTEM.RadPlus_Import_Audit data_entry_date added
SYSTEM.RadPlus_Import_Audit data_entry_by added
SYSTEM.RadPlus_Import_Audit data_entry_time added
SYSTEM.RadPlus_Import_Audit data_entry_by_option added
SYSTEM.RadPlus_Import_Audit data_entry_user_id added
SYSTEM.RadPlus_Import_Audit data_entry_user_name added
SYSTEM.RadPlus_Import_Audit data_entry_source added
SYSTEM.RadPlus_Import_Audit data_entry_utc added
SYSTEM.RadPlus_Import_Audit data_entry_timezone_info_all added
SYSTEM.RadPlus_Import_Audit data_entry_time_j added
SYSTEM.RadPlus_Import_Audit data_entry_offset added
SYSTEM.RadPlus_Import_Audit data_entry_timezone_short added
SYSTEM.RadPlus_Export_Audit FACILITY added
SYSTEM.RadPlus_Export_Audit type_code added
SYSTEM.RadPlus_Export_Audit type_value added
SYSTEM.RadPlus_Export_Audit audit_option_id added
SYSTEM.RadPlus_Export_Audit audit_option_desc added
SYSTEM.RadPlus_Export_Audit version added
SYSTEM.RadPlus_Export_Audit report_name added
SYSTEM.RadPlus_Export_Audit content added
SYSTEM.RadPlus_Export_Audit option_id added
SYSTEM.RadPlus_Export_Audit option_desc added
SYSTEM.RadPlus_Export_Audit data_entry_date added
SYSTEM.RadPlus_Export_Audit data_entry_by added
SYSTEM.RadPlus_Export_Audit data_entry_time added
SYSTEM.RadPlus_Export_Audit data_entry_by_option added
SYSTEM.RadPlus_Export_Audit data_entry_user_id added
SYSTEM.RadPlus_Export_Audit data_entry_user_name added
SYSTEM.RadPlus_Export_Audit data_entry_source added
SYSTEM.RadPlus_Export_Audit data_entry_utc added
SYSTEM.RadPlus_Export_Audit data_entry_timezone_info_all added
SYSTEM.RadPlus_Export_Audit data_entry_time_j added
SYSTEM.RadPlus_Export_Audit data_entry_offset added
SYSTEM.RadPlus_Export_Audit data_entry_timezone_short added