- Clarity Human Services Help Center
- Data Analysis
- Looker Field Spotlight
-
New Clarity Human Services Interface
-
News and Announcements
-
Getting Started
- Accessing Clarity Human Services
- Client Records and Households
- Program Enrollments
- Managing Client Data in Screens
- Services
- Entering Client Location Data
- Files, Notes, and Contacts
- Charts and Goals
- The Attendance Module
- Working with the Referrals Tab and Community Queues
- Recording and Managing Referrals in the Client Record
-
Clarity Human Services: Customer Portal
-
Clarity Human Services: INVENTORY
-
Clarity Human Services: Outreach
-
System Administration
-
HUD and Federal Partner Resources
-
Agency Management
-
Coordinated Entry
-
Report Library
-
Data Analysis
-
Data Integration and Migration
-
Submit a Request
-
System Status
-
COVID-19 Resources
Looker Field Spotlight - Deleted Data Overview
The Client Model and Project Descriptor Model are the two models that contain deleted data. However, there are instances where deleted data fields may be included in other models.
To ensure that reports produce the expected results, use the following tips to identify deleted fields and filter appropriately.
Searching for Deleted Fields in Looker
By searching "deleted" in the "Find a Field" search bar in Looker, you can locate fields associated with data that may have been deleted. These deleted data fields can be included in Looks to review if data has been deleted.
Filtering Deleted Fields in Looker
Additionally, once the fields from applicable views are identified, Looker users can utilize filtering (basic filters or custom filters) within a Look using these "Deleted (Yes/No)" fields to include/exclude deleted data based on your analysis needs. This enables more precise control when creating content allowing you to either include or ignore records that are marked as deleted, depending on your business logic or reporting requirements.