1. Null or Missing Demographic Data (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


[Note:  If you want to see Nutrition Risk dates that are more than a year old, also add the line below to the Missing Demogragraphic Data Ad Hoc and type in a date one year back from today in the capitalized area]


[Client Nutrition Risk\Last Updated] <= ENTER/SELECT DATE ONE YEAR BACK FROM TODAY

2. Null or Missing Demographic Data [Query: Clients Receiving Service (Detailed)]

[client\Age] is null or 
[client\Ethnicity] is null or 
[client\Living Status] is null or 
[Client\Marital Status] is null
[client\Poverty Status] is null or
[client\Race] is null or 
[client\Rural] is null or 
[client\Sex] is null or 
[client\Sex at birth] is null or
[client\Sexual orientation] is null or
[client\Zip (5 digit)] is null

3. Null or Missing Nutrition Risk (Query: Clients with Service Units in a Time Interval)

[Client Nutrition Risk\Last Updated] is null


4. Missing ADL/IADL (Query: Clients with Service Units in a Time Interval) - NAPIS (AAA) ONLY 

[California ADLs/IADLs\Last Updated] is null
 or [California ADLs/IADLs\Bathing Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Dressing Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Eating Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Heavy House Work Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Light House Work Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [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 [California ADLs/IADLs\Meal Prep/Cleanup Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Shopping/Errands Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Telephone Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Toileting Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Transferring Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Transportation Safe Functioning Level (Level)\Safe Level of Functioning] is null
 or [California ADLs/IADLs\Walking Safe Functioning Level (Level)\Safe Level of Functioning] is null


5. Missing ADL/IADL [Clients Receiving Service (Detailed)] - Care Plans ONLY.  Client may not have service units. NAPIS (AAA) ONLY.

[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


6. Care Plan Disposition [Query: Clients Receiving Service (Detailed)] - Disposition shows as not Active, but end date is blank OR End date in the care plan, but Disposition shows Active.


[Disposition] = 'Activated' and [End Date] >'6/30/2015' and [Funding Source] in ('Title III B', 'Title III C1', 'Title III C2', 'Title III E', 'Title V', 'Title VII B') or [Disposition] in ('Deceased', 'High Cost of Services', 'Institutionalization', 'Moved out of Service Area', 'No Longer Desires Services', 'No Longer Medi-Cal Eligible', 'No Longer MSSP Eligible', 'No Longer SNF Certifiable', 'On Hold', 'On Waiting List', 'Other Reason', 'Past Active', 'Service No Longer Needed', 'Won''t Follow Care Plan') and [End Date] is null and [Funding Source] in ('Title III B', 'Title III C1', 'Title III C2', 'Title III E', 'Title V', 'Title VII B')

After copying the information into the Ad-hoc and clicking the Execute button, 

Enter start date/end date, leave all other fields blank, and click the Query button.