7.7 AP 'Yet to Clarify' Analysis
|
Version |
Date Released |
Notes / Changes |
|
1.0 |
June 2017 |
Initial release |
|
1.1 |
September 2017 |
Code changes to improve robustness of report when managing migrated data. Added Service Centre for local report writers to bring the field in, if required. |
This report provides an analysis of all AssetPlus stages that were completed in a user-defined time period, with a basic aggregation of how many times ‘Yet to Clarify’ was entered for eligible questions.
Parameters
|
Parameter |
Type |
Details |
|
Period Start |
Date |
Start of the time period for the analysis (the report includes stages completed after this date and before the Period End date). |
|
Period End |
Date |
End of the time period for the analysis (the report includes stages completed before this date but after the Period Start date). |
|
Enter Question |
Drop-down |
List of all the questions that can be answered ‘Yet to Clarify’. This filters the results to that question only and shows the stages where the question was answered ‘Yet to Clarify’. The report can run against all questions or a single one. |
|
Residence Status |
Drop-down |
Residence status on the start date of the assessment (YJ Case | Summary | YJ Residence Status). |
|
Enter Workgroup |
Text |
Free text field. If required, enter a workgroup to return only clients for whom the workgroup is responsible (Client View | Administration | Managing Team). Defaults to N/A to return all clients. |
|
Enter Report View |
Drop-down |
Enables the choice between a formatted view for reporting to managers, or a data only view for exporting to a spreadsheet for further manipulation. |
|
Enter Worker |
Text |
Free text field. If required, enter a user’s name to filter the results to display only stages owned by that user. The name must match the user’s name as recorded in One One exactly. Defaults to ‘N/A’ to return all stages. |
Summary
The summary section lists each question for which ‘Yet to Clarify’ is a possible response in AssetPlus. It is organised by framework section, and the questions are listed by order of appearance in the framework. Next to each question is the number of times that a ‘Yet to Clarify’ response has been recorded for that question across all stages meeting the selection parameters. If the question has never been answered in any of the included stages, there is no number next to it.
Fields
Only basic stage information is shown, as there are too many questions for all the answers to be listed in the result set. The report calculates information for the summary in the background.
|
Field |
Details |
Source |
|
ONE ID |
Person ID |
Snapshot data. |
|
Fullname |
Surname, Forename |
Snapshot data. |
|
DOB |
Date of Birth |
Snapshot data. |
|
Age |
Age at the Analysis date |
Calculated from DOB. |
|
Gender |
Gender |
Snapshot data. |
|
Ethnicity |
Mapped value for YJMIS |
Mapped from snapshot data. |
|
LAC Status |
Current, Previous, Never or Unknown |
Calculated from answers in the AssetPlus stage. |
|
Residence |
Local, Other or No Residence |
Residence on the stage end date. Returns ‘No Residence’ if the stage pre-dates the earliest effective date for residence. |
|
Workgroup |
Managing Team |
View Client | Administration | Managing Team. |
|
Stage Start |
Date |
Assessment date from AssetPlus. |
|
Stage Type |
Text |
Stage type from AssetPlus |
|
Stage Owner |
User |
Stage owner from AssetPlus. |
|
Stage Proxy Owner |
User |
Stage proxy owner from AssetPlus. |
|
Stage End |
Date |
Stage end date from AssetPlus. |