This view compiles relevant information about each group activity with a record for each attendee.

• GroupActivityID

• ServiceID

• OrganizationID

• OrganizationName

• GroupActivity

• DateTimeStart

• GroupActivitiesClientID - a unique identifier for each row

• AttendanceYN

• ClientID

• ClientName

• Gender

• DOB

• AgeAtActivity

• IndigenousIdent

• VeteranStatus

• CitizenshipStatus

• RacialIdent

• HousingStatusAtActivity

Documentation

• vw_ACRE_GroupActivities_Clients - Sample Output.csv

• vw_ACRE_GroupActivities_Clients - Schema.csv