Medicaid Adjunctive Eligibility Report OPR013 (Output)

Contents Show

The Medicaid Adjunctive Eligibility Report OPR013 (Output) is an analysis of completed certifications and Medicaid certifications within the specified date ranges. The report is by Agency, service site, and category. Additional age group columns are included to give a total for the number of children 1 to 2 years old, children 2 to 3 years old, children 3 to 4 years old, and children 4 to 5 years old. A total for Completed Certifications, Medicaid Certifications, and percent of Medicaid Certifications to Completed Certifications is printed for each Agency and service site. The report will print from the temporary table, Medicaid-Adjunctive, that will be created with records that meet the selection criteria. The report is generated when the OK button is clicked on the Generate Medicaid Adjunctive Eligibility Report screen. This report will also be generated on a quarterly basis.

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.

Agency ID

Origin of Data Element

This value comes from the Agency-Id column of the temporary Medicaid-Adjunctive table.

Format

This is a three-character value.

Service Site ID

Origin of Data Element

This value comes from the ServiceSite-ID column of the temporary Medicaid-Adjunctive table.

Format

This is a three-character value.

Infant Total Cert Count

Origin of Data Element

This value comes from the Infant-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "I".

Format

This is a six-character value.

Child 01-02 Total Cert Count

Origin of Data Element

This value comes from the Child-1-2-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "C" and the child is 1 to 2 years old.

Format

This is a six-character value.

Child 02-03 Total Cert Count

Origin of Data Element

This value comes from the Child-2-3-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "C" and the child is 2 to 3 years old.

Format

This is a six-character value.

Child 03-04 Total Cert Count

Origin of Data Element

This value comes from the Child-3-4-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "C" and the child is 3 to 4 years old.

Format

This is a six-character value.

Child 04-05 Total Cert Count

Origin of Data Element

This value comes from the Child-4-5-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "C" and the child is 4 to 5 years old.

Format

This is a six-character value.

Pregnant Women Total Cert Count

Origin of Data Element

This value comes from the Pregnant-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "P".

Format

This is a six-character value.

Breastfed Total Cert Count

Origin of Data Element

This value comes from the Breastfed-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "B".

Format

This is a six-character value.

Non Breastfed Total Cert Count

Origin of Data Element

This value comes from the Non-Breastfed-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where the WICStatus column of the Member table equals "N".

Format

This is a six-character value.

Infant Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Infant-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "I" and Medicaid column of the INCOMECONTACT table equals "Y".

Format

This is a six-character value.

Child 01-02 Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Child-1-2-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants that fits these criteria:

Format

This is a six-character value.

Child 02-03 Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Child-2-3-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants that fits these criteria:

Format

This is a six-character value.

Child 03-04 Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Child-3-4-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants that fits these criteria:

Format

This is a six-character value.

Child 04-05 Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Child-4-5-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants that fits these criteria:

Format

This is a six-character value.

Pregnant Women Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Pregnant-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "P" and Medicaid column of the INCOMECONTACT table equals "Y".

Format

This is a six-character value.

Breastfed Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Breastfed-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "B" and Medicaid column of the INCOMECONTACT table equals "Y".

Format

This is a six-character value.

Non Breastfed Medicaid Cert Count

Origin of Data Element

This value comes from the Med-Non-Breastfed-Cnt column of the temporary Medicaid-Adjunctive table. It is the count of selected participants where WICStatus column of the Member table equals "N" and Medicaid column of the INCOMECONTACT table equals "Y".

Format

This is a six-character value.

Filter Criteria

Base of Data

This report is an analysis of completed certifications and Medicaid certifications within a specified date range. Totals are accumulated by WICStatus categories. In addition, for WICStatus equal to "C", the age of the child is calculated and totals are accumulated by these calculated ages. To calculate the child's age, the DateOfBirth column in the Member table will be subtracted from the CertStartDate column in the CERTCONTACT table, resulting in the Number-Years column.

Sort Order

Agency ID

The report is sorted first by Agency ID.

Service Site

This report will be sorted by the ServiceSite-ID within Agency.

Control Breaks

No control breaks are defined for this system output.

Grand Total

State Totals will be printed.

Frequency and Distribution

This report is run quarterly. It can also be generated on demand.

|

Software Version: 2.40.00

State Office