Pending Certifications Report CLN007 (Output)

The Pending Certifications Report CLN007 (Output) allows the user to print a report containing participants that have an incomplete certification. The report is generated when the OK button is clicked on the Generate Pending Certifications Report screen.

As of

Origin of Data Element

This value is the date the report is requested.

Format

This is a date formatted MM/DD/CCYY.

Clinic

Origin of Data Element

The agency code, agency description, clinic code and clinic description will be printed.

Format

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

Household ID

Origin of Data Element

This value is the HouseholdID column of the Member table for selected participants.

Format

The value is an eight-character value.

State WIC ID

Origin of Data Element

This value is the StateWICID column of the Member table for selected participants.

Format

The value is an eight-character value.

Participant Name

Origin of Data Element

This value is the FirstName, LastName and MiddleInitial columns of the Member table for selected participants.

Format

The value will print in {last name}, {first name} {middle initial}. format.

Address

Origin of Data Element

This value is the MailAddress, MailCity, MailState and MailZIP columns of the Household table for the selected participant.

Format

This is a character value formatted address, city, st zip.

Telephone

Origin of Data Element

The value is the Telephone1 column of the Household table for the selected participant.

Format

This is a ten-character value formatted XXX-XXX-XXXX.

Certification Start Date

Origin of Data Element

This value is the CertStartDate column of the Member table for the selected participant.

Format

This is a date in the format of MM/DD/CCYY.

Incomplete Reasons

Origin of Data Element

This value is determined as data is being selected for the report. One of the following text values will print. See the Filter Criteria section.

• Pending Proof of Identification

• Pending Proof of Residency

• No Proof of Income

• Pending Proof of Income

• No Proof of Adjunctive Eligibility

• No Blood Work

• Pending Delayed Blood Work

Format

This is a thirty-five character value.

Appointment Date

Origin of Data Element

This is the date of the next appointment for the participant. The value comes from the AppointmentDate column of the Appointment table. The next appointment for the participant is defined as one either on or after the date the report is requested. If an appointment is not scheduled for the participant either on or after the report date, blanks will print.

Format

The value will print in MM/DD/CCYY format.

Filter Criteria

Base of Data

All WIC participants with an incomplete certification attempt that has not been terminated and is incomplete for one of the defined reasons will be included in the report. Hidden agencies will not be included. Participants must meet the following selection criteria.

• AgencyID column of the Member table equals the agency signed on as.

• ServiceSiteID column of the Member table equals one of the selected clinics.

• PendingCertificationID column of the Member table is not null.

• Terminated column of the Member table is "N".

Incomplete Reasons

Participants must be assigned an incomplete reason and must meet one of the following selection criteria to be included in the report.

• "Pending Proof of Identification" will be assigned if the following is true.

• Homeless column of the Household table equals "N".

• IdentificationProof column of the Member table is null

• "Pending Proof of Residency" will be assigned if the following is true.

• Homeless column of the Household table equals'‘N'.

• ResidencyProof column of the Member table equals the value for the state business rule PENDINGRESIDENCYPROOFVALUE.

• "No Proof of Income" will be assigned if the following is true.

• No IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table.

• "Pending Proof of Income" will be assigned if the following is true.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the PendingProof column of the IncomeContact table equals "Y".

• "No Proof of Adjunctive Eligibility" will be assigned if any of the following is true.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the TANF column of the IncomeContact table equals "Y" and the TANFProofCd column of the IncomeContact table is null.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the Medicaid column of the IncomeContact table equals "Y" and the MedicaidProofCd column of the IncomeContact table is null.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the FoodStamps column of the IncomeContact table equals "Y" and the FoodStampsProofCd column of the IncomeContact table is null.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the FDPIR column of the IncomeContact table equals "Y" and the FDPIRProofCd column of the IncomeContact table is null.

• An IncomeContact is found where the CertStartDate column of the IncomeContact table is greater than or equal to the CertStartDate of the Member table and the Other column of the IncomeContact table equals "Y" and the OtherProofCd column of the IncomeContact table is null.

• "No Blood Work" will be assigned if the following is true.

• Bloodwork is found where the CertStartDate column of the Bloodwork table is greater than or equal to the CertStartDate of the Member table.

• "Pending Delayed Blood Work" will be assigned if the following is true.

• Bloodwork is found where the CertStartDate column of the Bloodwork table is greater than or equal to the CertStartDate of the Member table and the DelayedBloodwork column of the Bloodwork table equals "Y".

Sort Order

Clinic Number

The report will be sorted first by clinic code.

Certification Start Date

The report will be sorted by the certification start date within clinic code.

Household ID

The report will be sorted by the household ID within certification start date.

State WICID

The report will be sorted by the state WICID within household ID.

Incomplete Reasons

The report will be sorted by the incomplete reasons within state WICID.

At the end of each clinic the total number of participants with incomplete certifications will print.