FCSP AD-HOCS These queries assist with missing data for Caregivers and Care Recipients. Use this in conjunction with the Ad-Hoc How To document. 1. Null or Missing Demographic Data AND Employment Data - Caregiver (Query: Clients with Service Units in a Time Interval) [Age] is null or [Ethnicity] is null or [Living Status] is null or [Marital Status] is null or [Poverty Status] is null or [Race] is null or [Rural] is null or [Sex] is null or [Sex at birth] is null or [Sexual orientation] is null or [Zip (5 digit)] is null OR [Client Employment\Status] is null 2. Null or Missing ADL/IADL - Care Recipient [Query: Clients Receiving Service (Detailed)] Note: Query run against CARE RECIPIENT, so need to have Dummy Care Plans in place otherwise query will not work. [client\California ADLs/IADLs\Last Updated] is null or [client\California ADLs/IADLs\Bathing Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Dressing Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Eating Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Heavy House Work Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Light House Work Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Manage Medications Safe Functioning Level (Level)\Safe Level of Functioning] is null or [California ADLs/IADLs\Money Management Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Meal Prep/Cleanup Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Shopping/Errands Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Telephone Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Toileting Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Transferring Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Transportation Safe Functioning Level (Level)\Safe Level of Functioning] is null or [client\California ADLs/IADLs\Walking Safe Functioning Level (Level)\Safe Level of Functioning] is null 3A. Care Plan Disposition - Caregiver (Query: Clients Receiving Service (Detailed)) - Disposition shows not active, but end date is blank. [Disposition] is null or [Disposition] in ('Won''t Follow Care Plan', 'Service No Longer Needed', 'Past Active', 'Other Reason', 'On Waiting List', 'On Hold', 'No Longer SNF Certifiable', 'No Longer MSSP Eligible', 'No Longer Medi-Cal Eligible', 'No Longer Desires Services', 'Moved out of Service Area', 'Institutionalization', 'High Cost of Services', 'Deceased') and [End Date] is null 3B. Care Plan Disposition - Caregiver (Query: Clients Receiving Service (Detailed)) - End date in the Care Plan, but disposition shows Active. [Disposition] = 'Activated' and [End Date] >= '7/1/2011' 4. Does Caregiver have a Client Record AND a Caregiver Record? (Query: Service Units in a Date Range) NOTE: when you copy/paste the Ad-hoc below, you MUST enter the date manually between the single quotes or you will not get any results or inaccurate results. Date Service should be the last day of the previous fiscal year so you are only looking for those caregivers are receiving services in the current fiscal year. [Client\Caregiver (Synchronized)\Client (Synchronized)\Name] is null and [Funding Source] in ('Title III E') and [Date Service] > '6/30/2016' 5. Null or Missing Employment Status (Query: Clients with Service Units By Time Interval) [Client Employment\Status] is null