...
Data in this report will include review forms of all statuses.
Report Criteria Options | |
|---|---|
| Organisation Overall | Select whether to run your report at top level YES will show the data within the report at the top level (e.g. Trust Level) NO will show the data within the report at a lower level (e.g. site level) |
| Organisation | Depending on the option selected in Organisation Overall you can then select the relevant Trust/Site |
| review Form | This will show all review forms within the system available to the Trust/Site |
| Report period type | Select to see data for reviews with priority statuses of Standard (batch/discharge month) Review Start Date (the first date the review form was saved) |
| Period From | This will show a list of all batch options within the system for the relevant Trust/Site and Review Form |
| Period To | This will show a list of all batch options within the system for the relevant Trust/Site and Review Form |
| Report Data Explanations | |
|---|---|
| Case Review Details | |
| Case and Review Key | This shows the unique identifiers used within the system for the case record and the review form |
| Case Review | This splits the information in the first column to show the unique identifier of the case record |
| Review | This splits the information in the first column to show the unique identifier of the review form |
| Top Level Organisation | Trust code the data is assigned to |
| Organisation | Site code the data is assigned to |
| Case Review Subject ID | PatientID |
| Batch Date | Batch group the data belongs to (currently used the discharge date) |
| Review Start Date Batch | Date the review form was initially saved |
| Case Review Type | |
| Case Review Status | Whether the review has been closed or is still open In Progress and Not Started = Open Complete = closed |
| Review Status | Current status of the review i.e. Not Started/In Progress/Complete |
| Display Name | Name of the review form/review type |
| Version Number | Version of the review form that was available at the time the data was entered, version numbers increase when changes have been made to the review form itself |
| Case Review Q and A | |
| Case and Review Key | This shows the unique identifiers used within the system for the case record and the review form |
| Case Review | This splits the information in the first column to show the unique identifier of the case record |
| Review | This splits the information in the first column to show the unique identifier of the review form |
| Question Code | The unique identifier for the question in the review form |
| Question Type | The type of answers that can be given to the question SingleLineString = a single row free text field, limited to 350 characters MultiLineString = large box field in which large amounts of text and paragraphs can be entered, limited to 10,000 characters SelectList = a list of answer options from which only one answer can be selected MultiSelectList = a list of answer options from which multiple options can be selected CareProblem = refers to the problems in healthcare table which is included in some (but not all) review forms DateTime = date and time field |
| Group Name | The tab and tab section name where the question is located within the review form |
| QType | Related to the Question Type information with extra category to show if the question has a scoring element to it Score = this shows which question types are used in standard scoring e.g. Hogan scores Freetext = MultiLineString and SingleLineString SelectList =SelectList and MultiSelectList Other = DateTime or CareProblem |
| Question | Question text on the review form |
| Answer | Answer entered for the question on the review form |
| CaseReviewAdditionalInfo | |
| Case Review | This splits the information in the first column to show the unique identifier of the case record |
| InformationGroupNumber | Grouping numbering to show where the information is taken from within the case record 1 = ProviderSpell information 2 = Patient information |
| Information Source | Linked to the InformationGroupNumber and shows the name of the group 1 = ProviderSpell information 2 = Patient information |
| Information Element | Information field title e.g. Date of Birth |
| Element Data | Linked to the Information Element and shows the case record data for that element |