Mid-certification Assessment Report (Output)

The Mid-certification Assessment Report (Output) lists all mid-certification assessment participants within the specified criteria. The report is generated when the OK button is clicked on the Generate Mid-certification Assessment Report screen.

Grantee ID

Origin of Data Element

This value comes from the GranteeID column of the Grantee table.

Format

This value prints as the literal value.

Grantee Name

Origin of Data Element

This value comes from the Name column of the Grantee table.

Format

This value prints as the literal value.

Agency ID

Origin of Data Element

This value comes from the AgencyID column of the Agency table.

Format

This value prints as the literal value.

Agency Name

Origin of Data Element

This value comes from the Name column of the Agency table.

Format

This value prints as the literal value.

Clinic ID

Origin of Data Element

This value comes from the ServiceSiteID column of the ServiceSite table.

Format

This value prints as the literal value.

Clinic Name

Origin of Data Element

This value comes from the ServiceSiteName column of the ServiceSite table.

Format

This value prints as the literal value.

WIC Category

Origin of Data Element

This value comes from the Description column of the WicStatus table. The lookup value comes from the CertWicStatus column of the CertContact table.

Format

This value prints as the literal value.

Household ID

Origin of Data Element

This value comes from the HouseholdID column of the Member table.

Format

This value prints as the literal value.

State WIC ID

Origin of Data Element

This value comes from the StateWICID column of the Member table.

Format

This value prints as the literal value.

Name

Origin of Data Element

This value comes from the LastName, FirstName, and MiddleInitial columns of the Member table.

Format

This value prints as the literal value.

Date of Birth

Origin of Data Element

This value comes from the DateOfBirth column of the Member table.

Format

This value prints in MM/DD/CCYY format.

Auth Rep Name

Origin of Data Element

This value comes from the AuthRepLastName, AuthRepFirstName, and AuthRepMiddleInitial columns of the Household table.

Format

This value prints as the literal value.

Telephone

Origin of Data Element

This value comes from the DateOfBirth column of the Member table.

Format

The value prints in ###-###-#### format.

LDTU

Origin of Data Element

This value comes from the LastCheckLDTU column of the Member table.

Format

This value prints in MM/DD/CCYY format.

Certification Effective Date

Origin of Data Element

This value comes from the EffectiveDate column of the CertContact table.

Format

This value prints in MM/DD/CCYY format.

Certification End Date

Origin of Data Element

This value comes from the EndDate column of the CertContact table.

Format

This value prints in MM/DD/CCYY format.

Mid-certification Due Date

Origin of Data Element

This value comes from the DueDate column of the MidCertification table.

Format

This value prints in MM/DD/CCYY format.

Mid-certification Completed Date

Origin of Data Element

This value comes from the CompletedDate column of the MidCertification table.

Format

This value prints in MM/DD/CCYY format.

{WIC Category} Total - Due

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring on or after the day the report ran.

Format

The value is a six-digit number.

{WIC Category} Total - Missed

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring before the day the report ran.

Format

The value is a six-digit number.

{WIC Category} Total - Completed

Origin of Data Element

This value is the sum of all records in the grouping that have a non-blank Mid-certification Completed Date.

Format

The value is a six-digit number.

Clinic Total - Due

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring on or after the day the report ran.

Format

The value is a six-digit number.

Clinic Total - Missed

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring before the day the report ran.

Format

The value is a six-digit number.

Clinic Total - Completed

Origin of Data Element

This value is the sum of all records in the grouping that have a non-blank Mid-certification Completed Date.

Format

The value is a six-digit number.

Agency Total - Due

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring on or after the day the report ran.

Format

The value is a six-digit number.

Agency Total - Missed

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring before the day the report ran.

Format

The value is a six-digit number.

Agency Total - Completed

Origin of Data Element

This value is the sum of all records in the grouping that have a non-blank Mid-certification Completed Date.

Format

The value is a six-digit number.

Grantee Total - Due

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring on or after the day the report ran.

Format

The value is a six-digit number.

Grantee Total - Missed

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring before the day the report ran.

Format

The value is a six-digit number.

Grantee Total - Completed

Origin of Data Element

This value is the sum of all records in the grouping that have a non-blank Mid-certification Completed Date.

Format

The value is a six-digit number.

State Total - Due

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring on or after the day the report ran.

Format

The value is a six-digit number.

State Total - Missed

Origin of Data Element

This value is the sum of all records in the grouping that have a blank Mid-certification Completed Date and a Mid-certification Due Date occurring before the day the report ran.

Format

The value is a six-digit number.

State Total - Completed

Origin of Data Element

This value is the sum of all records in the grouping that have a non-blank Mid-certification Completed Date.

Format

The value is a six-digit number.

Sort Order

Grantee ID / Agency ID / Clinic ID / WIC Category / Name

This report is sorted first by the Grantee ID, then the Agency ID, Clinic ID, WIC Category, and finally by Name.

Control Breaks

Grantee ID

A page break will occur on change in Grantee.

Agency ID

A page break will occur on change in Agency.

Clinic ID

A page break will occur on change in Clinic.

WIC Category

A page break will occur on change in WIC Category.