(CDR) Clinical Database Repository
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Table Definition (CWS)
- User Definition
Scenario 1: (CDR) Clinical Database Repository - Table validations
Specific Setup:
- Have a system where the child namespace (for example "CWS") is connected to the parent namespace (PM) with "Clinical Data Repository (CDR)" set to "Yes", in form "Connect/Disconnect Application Namespace".
- Have a "Modeled" table [TableA] that exists in the child namespace, that is contained in an "Envelope" set with prompt "Include Envelope within CDR (Clinical Data Repository)" set to "Yes" in form "Envelope Definition"
- Have a modeled form that contains [TableA]
- Have data submitted in [TableA]
- Have a user [UserA], who will be assigned permissions to the table during testing
- Have access to an SQL query or reporting program, for example "Crystal Reports"
Steps
- Open form "User Definition" and select [UserA]
- Navigate to the "Form and SQL Tables" section
- Click "Select Tables for Product SQL Access"
- Locate the "Avatar PM" section
- Search for the CDR schema name of child namespace. For example if the child namespace name is "CWS", the default schema name would be "CWSSYSTEM"
- Click on the arrow next to CDR Schema name, to display the list of tables
- Validate [TableA] is displayed for selection
- Select the table
- Click [OK] and submit the form
- Open the SQL query or reporting program, for example "Crystal Reports"
- Make a connection to the testing database
- In the list of "Tables" displayed for selection, locate the "Avatar PM" section
- Search for the CDR schema name of child namespace.
- Click on the arrow next to CDR Schema name
- Click the plus (+) sign next to "Tables", to expand the list of tables
- Validate [TableA] is displayed for selection
- Select the table and continue on, selecting fields for the report
- Click "Print Preview"
- Validate data filed in the table is displayed as expected
- Open form "Table Definition"
- Select [TableA]
- Click [Submit] to refile the table
- Validate the table files successfully
- Repeat steps 1 thru 2
- Validate results are as expected
|
Topics
• NX
• SQL Data Access
|
