This dataset is an improved version of vw_ClientBasics that respects the privacy of clients. It includes names, gender, DOB, age, and citizenship, veteran, and indigenous statuses. In addition, it suppresses data for hidden clients and clients with declined - anonymous consent and indicates whether clients are hidden and/or declined.

This view contains the following columns, pulling data from all clients:

• ClientID

• FileNumber

• LastName - suppressed if Declined or Hidden

• FirstName - suppressed if Declined or Hidden

• MiddleName - suppressed if Declined or Hidden

• AKA1 - suppressed if Declined or Hidden

• AKA2 - suppressed if Declined or Hidden

• ClientFullName

• DOB - suppressed if Declined or Hidden

• CurrentAge - suppressed if Declined or Hidden

• AgeGroup

• Gender

• Indigenous

• Citizenship

• Veteran

• HiddenYN

• DeclinedYN

• ClusterID

• Cluster

• ViewVersion

Documentation

• vw_ACRE_Clients_Privacy - Sample Output.csv

• vw_ACRE_Clients_Privacy - Schema.csv