Client Picture - Table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Import Client Picture (PM)
Scenario 1: Validate data in the "SYSTEM.RADplus_client_picture" table
Specific Setup:
- Have a report or query [TestReport]" created to display data in the ""SYSTEM.RADplus_client_picture"' table
- Have client [ClientA] who does not have a picture image uploaded yet in the system
- Have an image [TestImageA] on the system available for import for [ClientA]
- Have client [ClientB] who already has a picture image uploaded [TestImageB]
- Have an image [TestImageC] on the system available for import to replace the current image for [ClientB]
- [TestUser] has access to form "Import Client Picture"
- Log in as [TestUser]
Steps
- Access the 'Import Client Picture' form.
- Select [ClientA] in the 'Client' field.
- Right click in the 'Picture' field.
- Click [Acquire Image].
- Navigate to [TestImageA] and select the image
- Validate the image in the 'Picture' field is displayed as expected
- Submit the form. [Note the current date and time]
- Validate the form files successfully
- Access [TestReport] and generate the report or query
- Locate the row just submitted for [ClientA]
- Validate the "PATID" field value for [ClientA], is populated as expected
- Validate the 'data_entry_date" field value reflects the date noted in step 1
- Validate the 'data_entry_time" field value reflects the time noted in step 1
- If "UTC" time is enabled on the system:
- Validate the 'data_entry_utc" field value reflects the date and time noted in step 1 but in "UTC" time and date format. (For example, if the time zone is "Eastern" and the date and time in step 1 was "6/22/23" at "1:52 PM", the value would be display as "6/22/2023 5:52:16PM")
- Validate the "data_entry_timezone_info_all" field value is displayed as expected, based on the time zone. (For example, if the time zone is "Eastern", the value displayed would be "EDT;Eastern Daylight Time;-0400")
- Validate the 'data_entry_by_login' field value is [TestUser]
- Validate the "picture" field is populated with [TestImageA], as expected
- Access the 'Import Client Picture' form.
- Select [ClientB] in the 'Client' field.
- Validate [TestImageB], is displayed as expected
- Right click on the image in the 'Picture' field.
- Click [Acquire Image].
- Navigate to [TestImageC] and select the image
- Validate that image is now displayed as expected
- Submit the form. [Note the current date and time]
- Validate the form files successfully
- Access [TestReport] and generate the report or query
- Locate the row just submitted for [ClientB]
- Validate the "PATID" column for [ClienB], is populated as expected
- Validate the 'data_entry_date" field value reflects the date noted in step 3
- Validate the 'data_entry_time" field value reflects the time noted in step 3
- When "UTC" time is enabled on the system:
- Validate the 'data_entry_utc" field value reflects the date and time noted in step 3 in "UTC" time format
- Validate the "data_entry_timezone_info_all" field values displayed as expected based on the time zone.
- Validate the 'data_entry_by_login' field value is [TestUser]
- Validate the "picture" field is populated with [TestImageC], as expected
|
Topics
• NX
• SQL Data Access
|
