Example 1 Report Business Logic Result Construct Result Construct Result Construct Element for Constructing Data Element 1 Data Element 2 Data Element 3 Report Element Report Element Using the Date Range Person is an Marital Status Service Referral 1, Form 1, Table provided, find all Enrollee Single, Never Married Housing A, Question 1 Enrolled Clients Data Source Married TANF during the reporting Location: Separated Early Intervention period. Divorced Mental health {Table A, Enrollee Then Widowed treatment Flag indicated} Identify Marital Status Substance abuse Unknown/Did Not Data Field Location: Report treatment Identify Service Referral {Screen Name and Data Source Location: Field Location} Data Source Location: Using Marital Status and Referral for {Table A, Marital Status} {Table A, Service Service create an Referral} Data Field Location: aggregate, count for Data Field Location: each column (Service {Screen Name and Field Referral) and row Location} {Screen Name and Field (Marital Status). Location} Then Add all counts for each row Then Add all counts for each column Then Total all counts for rows and columns Example 2 Report Element Business Logic Data Element 1 Data Element 2 Data Element 3
Example 1 Report Element Business Logic for Constructing Report Element Result Construct Data Element 1 Result Construct Data Element 2 Result Construct Data Element 3 Report Element 1, Form 1, Table A, Question 1 Using the Date Range provided, find all Enrolled Clients during the reporting period. Then Identify Marital Status Identify Service Referral Using Marital Status and Referral for Service create an aggregate, count for each column (Service Referral) 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: {Table A, 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: {Table A, Marital Status} Data Field Location: {Screen Name and Field Location} Service Referral Housing TANF Early Intervention Mental health treatment Substance abuse treatment Data Source Location: {Table A, Service Referral} Data Field Location: {Screen Name and Field Location} Example 2 Report Element Business Logic Data Element 1 Data Element 2 Data Element 3
4.1_Data-Reporting-Map_Final.docx