Skip to main content

RADplus 2023 Update 54

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

RADplus required

Recommended Update Level

RADplus 2023 Monthly Release 2023.03.00

Product Update Description

The following modifications are made to the State Form Tools: 1) The 'State Form Field Translations' form is modified to allow importing and exporting translations via CSV file. 2) A new option 'Single Submission Flagging' is added for State Form Definitions to prevent flagged data from resending if the data entry date of the primary table is modified. 3) An issue is resolved where an error was received when clicking the 'Refresh' button on the 'State Form Query Logging' form.

Required Updates

None

Included Updates

38

Details
NEW2 CHANGED0 FIXED1
New (2)
State Form Definition - Form
A new selection is added to the "Definition Options" prompt of the "State Form Definition" form, called 'Single Submission Flagging'. When selected in the definition, it will prevent data already flagged and compiled from being selected again even when data in the primary table used in the definition, is modified.
Value Added: Enhances the ability for users to filter out records already compiled
Topics
• State Forms
 
State Form Tools - Import/Export
The 'State Form Field Translations' form is modified with two new actions that will allow importing and exporting field translations, "Import Transactions from CSV" and "Export Transactions from CSV"
Value Added: Allows users the ability to import and export state from file field translations
Topics
• State Form Tools
 
Fixed (1)
State Form Query Logging- form
An issue is resolved to ensure that the "Query" field can be refreshed successfully, when pressing the 'Refresh' button on the "State Form Query Logging" form
Topics
• NX • State Form Tools
 
Acceptance Tests
AV-78354 Summary | Details
State Form Definition - Form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form Definition
  • State Form File Generation
Scenario 1: State Form Definition - file "Definition Options" validations
Specific Setup:
  • Have a definition file created [TestDef], in form "State Form Definition" for any table on the system. For this test a definition is created using the "Admission" table, that will select and display "PATID" and "Episode" for each client admission on the system
Steps
  1. Open form "State Form File Generation"
  2. Select definition file [TestDef]
  3. In the "File Generations Options" field,
  4. Click "Compile"
  5. Set prompt 'Generate Flag On Compile' to "Yes"
  6. Click [Process]
  7. Validate "Compile Complete" is displayed
  8. Click "Create File On Server"
  9. Click [Process]
  10. Validate a file is created and view the file
  11. Validate data as expected for each client admitted on the system, as expected
  12. In the "File Generations Options" field,
  13. Click "Compile" again
  14. Validate a message containing no records are found is displayed, since all records were previously flagged and no changes were made to any records since the last compile
  15. Open the 'Admission' form for any client [TestClient]
  16. Select an episode and change any of the data in the form and then submit the form
  17. Return to the "State Form File Generation"
  18. In the "File Generations Options" field,
  19. Click "Compile"
  20. Set prompt 'Generate Flag On Compile' to "Yes"
  21. Click [Process]
  22. Click "Create File On Server"
  23. Click [Process]
  24. Validate a file is created and view the file
  25. Validate data for just [TestClient] is present, as expected
  26. Open the 'State Form Definition' form
  27. Select definition file [TestDef]
  28. Select 'Single Submission Flagging' in the 'Definition Options' field
  29. File the definition
  30. Open the 'Admission' form for any client [TestClient]
  31. Select an episode and change any of the data in the form and then submit the form
  32. Return to the "State Form File Generation"
  33. In the "File Generations Options" field,
  34. Click "Compile"
  35. Set prompt 'Generate Flag On Compile' to "Yes"
  36. Click [Process]
  37. Click "Create File On Server"
  38. Click [Process]
  39. Validate no records are present even though the data was modified, since prompt "Single Submission Flagging" was selected in step 5
Topics
• State Forms
AV-89033 Summary | Details
State Form Tools - Import/Export
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form Field Translation
Scenario 1: State Form Field Translation Form - field entry and validation
Specific Setup:
  • Have a state form file created in form "State Form Definition" [FileA]
Steps
  1. Open form "State Form Field Translation"
  2. Select the state form [FileA] from the "State Form" field drop-down list.
  3. In the "Record" field, select a record.
  4. In the "Table" field, select the desired table.
  5. In the "Table Property" field, select the desired table property.
  6. In the "Action field", select "Single Translation"
  7. In the "Dictionary Code" field, enter a dictionary code [Code1]
  8. In the "State Forms Dictionary Code" field, enter a desired state form dictionary code [StateCode1]
  9. Click [Submit] to record the changes.
  10. Click [Yes] to return to the form
  11. In the "Dictionary Code" field, enter another dictionary code [Code2]
  12. In the "State Forms Dictionary Code" field, enter another desired state form dictionary code [StateCode2]
  13. Click [Submit] to record the changes.
  14. Click [Yes] to return to the form
  15. In the "Dictionary Code" field, enter another dictionary code [Code3]
  16. In the "State Forms Dictionary Code" field, enter another desired state form dictionary code [StateCode3]
  17. Click [Submit] to record the changes.
  18. Click [No] not to return to the form
  19. Open form "State Form Field Translation"
  20. Click the [Print Translations] button
  21. Validate the "File Name Override Field Translations" report contains the three codes filed in the previous steps
  22. Repeat step 2, selecting the same values
  23. In the "Dictionary Code" field, enter dictionary code [Code1] entered in step 4
  24. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode1]
  25. In the "Dictionary Code" field, enter dictionary code [Code2] entered in step 6
  26. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode2]
  27. In the "Dictionary Code" field, enter dictionary code [Code3] entered in step 8
  28. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode3]
  29. Navigate back to the "Action" field
  30. Select "Export Translations to CSV"
  31. Click the [Select CSV File] button
  32. Validate a file is location and save the file
  33. Navigate to location of the file and open it
  34. Validate all three translations entered in the previous steps, are present in the file as expected
  35. Closet the report
  36. Click the [Select Translations to Delete] button
  37. Validate all three translations are preset
  38. Click the check box for each item
  39. Click [OK] and [Yes] to continue
  40. Click [Submit]
  41. Click [Yes] to return to the form
  42. Repeat step 2, selecting the same values
  43. In the "Dictionary Code" field, enter dictionary code [Code1] entered in step 4
  44. Validate the "State Forms Dictionary Code" field is blank, as expected
  45. In the "Dictionary Code" field, enter dictionary code [Code2] entered in step 6
  46. Validate the "State Forms Dictionary Code" field is blank, as expected
  47. In the "Dictionary Code" field, enter dictionary code [Code3] entered in step 8
  48. Validate the "State Forms Dictionary Code" field is blank, as expected
  49. Navigate back to the "Action" field
  50. Select "Import Translations to CSV"
  51. Click the [Select CSV File] button
  52. Navigate to the location of file exported in step 14
  53. Select the file
  54. Validate a "Confirm" dialog is displayed, stating that 3 translations were processed and to submit the report to finalize the import
  55. Submit the form
  56. Return to the form
  57. Repeat step 2
  58. In the "Dictionary Code" field, enter dictionary code [Code1] entered in step 4
  59. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode1]
  60. In the "Dictionary Code" field, enter dictionary code [Code2] entered in step 6
  61. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode2]
  62. In the "Dictionary Code" field, enter dictionary code [Code3] entered in step 8
  63. Validate the "State Forms Dictionary Code" field, contains the expected value [StateCode3]
Topics
• State Form Tools
AV-90797 Summary | Details
State Form Query Logging- form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form File Generation
  • State Form Query Logging
Scenario 1: 'State Form Query Logging' form - Functionality and validations
Specific Setup:
  • Have a system with two state form file definitions created in form "State Form Definition" [SFileA] and [SFileB]
  • [SFileA] is a definition that contains one record [Rec]
  • [SFileB] is a definition that contains two records [Rec] and [Rec2]
  • Have a report to display data in the "RADplus_sf_audit_query" table, sorted by the "ID" field and displaying the fields "ID", "Query" and "Rec"
Steps
  1. Open form "State Form File Generation"
  2. Select definition [SFileA] in the "State Form" field. (Make a note of the file "ID" number located next to the state form file name)
  3. Select "Compile" in the "File Generation Options" field
  4. Populate the "File Description" field
  5. Click [Process]
  6. At the "Compile Complete" dialog, click [OK]
  7. Open form "State Form Query Logging"
  8. Select definition [SFileA] in the "State Form" field
  9. Validate the "Record" filed is automatically populated with the record name [Rec]. (Make a note of the record name)
  10. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  11. Click the [Refesh] button
  12. Validate the query field refreshes as expected with with the expected SQL query based on the table and selection criteria being executed in the record,
  13. Close the form
  14. Run the report created to query table "RADplus_sf_audit_query" table
  15. In the "ID" column, locate the row that contains a value starting with the definition "ID" for [SFileA], noted in step 1a
  16. Validate the "Record" field value matches the value noted in step 2a
  17. Validate the "Query" field value matches the value noted in step 2a
  18. Close the report
  19. Open form "State Form File Generation"
  20. Select definition [SFileB] in the "State Form" field. (Make a note of the file "ID" number, located next to the state form file name)
  21. Select "Compile" in the "File Generation Options" field
  22. Populate the "File Description" field
  23. Click [Process]
  24. At the "Compile Complete" dialog, click [OK]
  25. Open form "State Form Query Logging"
  26. Select definition [SFileB] in the "State Form" field
  27. Click the "Record" field
  28. Validate there are two records for selection, as expected. [Rec] and [Rec2]
  29. Select [Rec]
  30. Validate the "Record" field is automatically populated with the record name [Rec]. (Make a note of the record name)
  31. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  32. Click the [Refesh] button
  33. Validate the query field refreshes as expected with with the expected SQL query based on the table and selection criteria being executed in the record,
  34. Navigate back to the "Record" field
  35. Select [Rec2]
  36. Validate the "Record" field is automatically populated with the record name [Rec]. (Make a note of the record name)
  37. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  38. Click the [Refesh] button
  39. Validate the query field refreshes as expected with with the expected SQL query based on the table and selection criteria being executed in the record
  40. Run the report created to query table "RADplus_sf_audit_query" table
  41. In the "ID" column, locate the row(s) that contains a value starting with the definition "ID" for [SFileB], noted in step 4a
  42. Validate a row is found for record name [Rec]
  43. Validate the "Query" field value for record [Rec] matches the value noted in step 5a
  44. Validate a row is also found for record name [Rec]
  45. Validate the "Query" field value for record [Rec2] matches the value noted in step 5a
  46. Close the report
Topics
• NX • State Form Tools