Initial Contacts Report CLN040 (Output)

Report ID

Origin of Data Element

The value is the following RPTID value:

Format

The value is included as its literal value.

Report Title

Origin of Data Element

The value is the current value of the REPORTHEADING business rule.

Format

The value is included as its literal value.

Run Date

Origin of Data Element

The value is the date on which the report is generated.

Format

The value is included in the following format: MM/DD/CCYY. The value will be the current system date when the report is generated.

User Name

Origin of Data Element

The value is the name of the user signed in to the system when the report is generated.

Format

The value is included as its literal value. Because of space constraints, all characters of the user's first and last name may not print within the space allotted.

Report Subtitle

Origin of Data Element

The value is the following text:

Format

The value is included as its literal value and center aligned. It is positioned at the top of the report in the center below the Report Title.

Run Time

Origin of Data Element

The value is the time at which the report is generated.

Format

The value is included in the following format: HH:MM:SS (AM/PM).

Report Date Range

Origin of Data Element

The report date range is the inclusive range of days from which the data included in the report is retrieved and includes a beginning date and an ending date.

Format

The value is center aligned and included in the following format:

"MM/DD/CCYY - MM/DD/CCYY"

Page

Origin of Data Element

The value is the current page of the report.

Format

The value is included as its literal value.

Agency

The agency label and values identify the agency by which the report is grouped.

Origin of Data Element

The values included are populated from the AgencyID and Name columns of the Agency database table.

Format

The label and values are left aligned, positioned on the left margin, and included in the following format:

Agency: {Agency.AgencyID} - {Agency.Name}

Clinic

Origin of Data Element

This value comes from the SERVICESITENAME column of the SERVICESITE table.

Format

This is a thirty- (30-) character value. The label and values are left aligned, positioned on the left margin, and included in the following format:

Clinic: {SERVICESITE.SERVICESITEID} - {SERVICESITE.SERVICESITENAME}

WIC Category (Category)

Origin of Data Element

This value comes from the Description column of the WICStatus table associated with the WICStatus column of the Member table.

Format

The value will print as its literal value. This is a 20-character value.

Household ID

Origin of Data Element

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

Format

This is an eight-character value.

Initial Contact Date

Origin of Data Element

This value comes from the InitialContactDate column of the InitialContact table.

Format

The value is included in the following format: MM/DD/CCYY.

First Appt Offered Date

Origin of Data Element

This value comes from the FirstAppointmentOfferedDate column of the InitialContact table.

Format

The value is included in the following format: MM/DD/CCYY.

Certification Effective Date

This value is the date from which the participant is certified and can utilize WIC benefits.

Origin of Data Element

The value is the CertEffectiveDate column of the CertContact table. It is the minimum value of the certification effective date for the certification with a certification ID matching the CertificationID in the InitialContact table.

Format

The value is included in the following format: MM/DD/CCYY.

Migrant at Initial Contact

Origin of Data Element

This value comes from the InitialMigrant column of the InitialContact table.

Format

This is an "N" if the participant was not migrant at the time of the initial contact.

Processing Standard Number of Days

Origin of Data Element

If the participant's InitialContact.InitialContactDate column is not null and the participant's InitialContact.FirstAppointmentOfferedDate column is not null, then this value is the difference in days calculated by subtracting the participant's InitialContact.InitialContactDate column from the InitialContact.FirstAppointmentOfferedDate column.

If the participant's InitialContact.InitialContactDate column is not null and the participant's current CertContact.CertEffectiveDate column is not null, then this value is the difference in days calculated by subtracting the participant's InitialContact.InitialContactDate column from the participant's current CertContact.CertEffectiveDate column.

If the participant's InitialContact.FirstAppointmentOfferedDate column is null or the participant's current CertContact.CertEffectiveDate column is null, the value is "Unknown".

Format

This value is formatted as the positive literal value or "Unknown".

Initial Contact type

Origin of Data Element

This value comes from the description of the initial contact type in the Initial Contact Type category of reference dictionary where the value matches the InitialContactTypeID in the Initial Contact table.

Format

This is displayed as the literal value of the description from reference dictionary.

Comments

Origin of Data Element

This value comes from the Comments column of the InitialContact table.

Format

This is a 50-character text value.

Filter Criteria

Date Range

A participant's data is included when the participant's InitialContact.InitialContactDate column is between the From date and the To date.