Modeled Forms - Table Alias
Scenario 1: Modeled Forms - "Table Alias" field and data validations
Specific Setup:
- Have a client [TestClient] who is active in an existing episode
- Have a modeled form [TestForm] that contains:
- A field [TestField] that is not mapped to any of the field in the "Vital Signs" alias table. For this example a "Dictionary" type field is used
- Mapped "Table" aliased fields. For this test [TestForm] has the following fields in its table [TestTable], that are mapped in "Table Definition" to the following fields in the "CWS" table alias, "Vital Signs":
- Date
- Time
- Diastolic Blood Pressure
- Systolic Blood Pressure
- Respiration
- Please Note: For the "CWS" "Vital Signs" table alias used in this test, the "Date" and "Time" alias fields are required to be populated at the time submission in order to file the data submitted in the mapped alias fields, into the "SYSTEM.cw_vital_signs" table.
- Have a report created to display data in the modeled table [TestTable]
- Have a report created to display data in the "SYSTEM.cw_vital_signs" table
- Have a report created to display data in the "SYSTEM.RADplus_error_log" table
Steps
- On the home view, select [TestClient]
- Open form [TestForm]
- Populate the field [TestField]
- Populate the table alias mapped "Date" and "Time" fields
- Populate the other mapped alias fields noted in the setup.
- Submit the form
- Validate the form submits successfully
- Run the report to display data in the modeled table [TestTable]
- Validate data for all fields populated in step 2a and b, are displayed as expected
- Run the report to display data in the "SYSTEM.cw_vital_signs" table
- Validate rows for all the mapped table alias fields populated in step 2b, are displayed as expected
- Run the report to display data in the "SYSTEM.RADplus_error_log"
- Validate there are no messages related to the table alias submission displayed, as expected
- Open form [TestForm] and add a new row
- Populate just the field [TestField], which is not a mapped alias field
- Submit the form
- Validate the form files successfully
- Run the report to display data in the modeled table [TestTable]
- Validate data for field [TestField] populated in step 3a is displayed populated as expected
- Validate none of the other fields are populated in the report, as expected
- Run the report to display data in the "SYSTEM.cw_vital_signs" table
- Validate there are no rows populated from the form submission in step 4a, as the required table alias mapped "Date" and "Time" fields were both not populated.
- Run the report to display data in the "SYSTEM.RADplus_error_log"
- Validate there are no messages related to table alias submission, as both of the required alias mapped fields were not populated, indicating no attempt to file data in the alias table
- Open form [TestForm] and add a new row
- Populate field [TestField]
- Leave either the alias mapped "Date" or mapped "Time" field unpopulated, and populate any of the other alias mapped fields.
- Submit the form
- Validate the form submits successfully
- Run the report to display data in the modeled table [TestTable]
- Validate data for all fields populated in step 4a and 4b, are displayed as expected
- Run the report to display data in the "SYSTEM.cw_vital_signs" table
- Validate there are no rows populated for the submission in step 4c, as one of the two required fields for alias table submission was not populated.
- Run the report to display data in the "SYSTEM.RADplus_error_log"
- Validate there is a row with a message stating "Table Alias Submission Failed Validation" displayed
|
Topics
• Diagnosis
• NX
|