Minority Health Disparity Survey Report CLD019 (Output)

Contents Show

The Minority Health Disparity Survey Report CLD019 (Output) is a summary of records that fall within the Fiscal year selected from the Caseload-Count-Undup-Federal table. The report is broken into totals by Minority codes, showing a count for women and a count for infants and children. The Minority codes that have counts accumulated for them are defined in the program to be: 20-African American/Black, 40-American Indian/Alaskan Native, 60 or 70-Asian American, 30 through 38-Hispanic/Latino, 50-Native Hawaiian/Pacific Islander, 88-Other and 99 or blank-Unknown. There will also be a 'Total' count. The report will show totals by Agency and there will another total at the end of the report for the State. The report is generated when the OK button is clicked on the Generate Minority Health Disparity Survey Report screen and is also generated on an annual basis during the September end of month process.

Data Elements

This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.

Fiscal Year

Origin of Data Element

The user records this value when the report is submitted.

Format

This is a four-character value in the format of CCYY.

Agency/State Total

Origin of Data Element

The selection criteria and information being reported determine this value.

Format

This is a fifty-character value. The format is determined by the information being reported.

Race Name

Origin of Data Element

This value comes from an array with set headings reflecting the different race names.

Format

This is a fifty-character value.

Agency Women Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "B", "N" or "P", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

Agency Infant/Child Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "I" or "C", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

Agency Total Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "I", "C", "B", "N" or "P", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

State Women Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "B", "N" or "P", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

State Infant/Child Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "I" or "C", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

State Total Count by Race

Origin of Data Element

This value is the count of selected participants where Enroll-Part-WICStatus column of the Caseload-Count-Undup-Federal table equals "I", "C", "B", "N" or "P", is one of the minority codes and falls in the selected fiscal year.

Format

This is a six-character value.

Filter Criteria

Base of Data

The Minority Health Disparity Survey report is a summary of records that fall within the Fiscal year selected from the Caseload-Count-Undup-Federal table. Agency and State totals are accumulated for the various race codes.

Sort Order

Agency ID

The report is sorted first by Agency ID.

Control Breaks

This report will show totals by Agency.

Grand Total

State Totals will be printed.

Frequency and Distribution

This report can be generated on demand and will be generated yearly, from October through September, during the month-end process, if the report is selected by the state.

|

State Office