Report Element 1, Using the Date Person is an Enrollee Marital Status Race Form 1, Table B, Range Provided, find Data Source Single, Never American Indian or Question 5 all Enrolled Clients Location: Married Alaska Native during the reporting Married Asian period. {Database Table, Separated Black or African Enrollee Flag Then Divorced American indicated} Widowed Native Hawaiian or Identify Marital Unknown/Did Not Other Pacific Status Data Field Location: Islander Report Identify Race White {Screen Name and More than one Field Location} Using Marital Status category selected Data Source Location: and Race, create an Unanswered/Did Not aggregate count for {Database Table, Report each column (Race) Marital Status} Data Source Location: and row (Marital Status). (Database Table, Race) Data Field Location: Then {Screen Name and Data Field Location: Add all counts for Field Location} each row {Screen Name and Field Then Location} Add all counts for each column Then Total all counts for rows and columns
Report Element 1, Form 1, Table B, Question 5 Using the Date Range Provided, find all Enrolled Clients during the reporting period. Then Identify Marital Status Identify Race Using Marital Status and Race, create an aggregate count for each column (Race) and row (Marital Status). Then Add all counts for each row Then Add all counts for each column Then Total all counts for rows and columns Person is an Enrollee Data Source Location: {Database Table, Enrollee Flag indicated} Data Field Location: {Screen Name and Field Location} Marital Status Single, Never Married Married Separated Divorced Widowed Unknown/Did Not Report Data Source Location: {Database Table, Marital Status} Data Field Location: {Screen Name and Field Location} Race American Indian or Alaska Native Asian Black or African American Native Hawaiian or Other Pacific Islander White More than one category selected Unanswered/Did Not Report Data Source Location: (Database Table, Race) Data Field Location: {Screen Name and Field Location}
4.1_Data-Reporting-Map_Final.docx