Participants for Chart Audit Report OPR051 (Output)

Contents Show

The Participants for Chart Audit Report OPR051 (Output) allows the user to print a report that randomly selects participants in WIC for chart audits based on fiscal year, agency or clinic, WIC category, and the percentage of participants for the selected WIC category. The report is generated when the OK button is clicked on the Generate Participants for Chart Audit Report screen

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

The value is taken from the Agency ID column of the Agency table. This is tied to the participant record by the AgencyID column of the Member table.

Format

The value prints as its literal value.

Agency Name

Origin of Data Element

The value is taken from the Name column of the Agency table.

Format

The value prints as its literal value.

Clinic ID

Origin of Data Element

The value is taken from the ServiceSiteID column of the ServiceSite table. This is tied to the participant record by the ServiceSiteID column of the Member table.

Format

The value prints as its literal value.

Clinic Name

Origin of Data Element

The value is taken from the ServiceSiteName column of the ServiceSite table.

Format

The value prints as its literal value.

WIC Category

Origin of Data Element

The value is taken from the Description column of the WICStatus table. This is tied to the participant record by the WICStatus column of the Member table.

Format

The value prints as its literal value.

Household ID

Origin of Data Element

The value is taken from the HouseholdID column of the Member table.

Format

The value prints as its literal value.

State WIC ID

Origin of Data Element

The value is taken from the StateWICID column of the Member table.

Format

The value prints as its literal value.

First Name

Origin of Data Element

The value is taken from the FirstName column of the Member table.

Format

The value prints as its literal value.

Last Name

Origin of Data Element

The value is taken from the LastName column of the Member table.

Format

The value prints as its literal value.

Date of Birth

Origin of Data Element

The value is taken from the DateOfBirth column of the Member table.

Format

The value prints as in MM/DD/CCYY date format.

High Risk

Origin of Data Element

The value is taken from the HighRisk column of the CertContact table. This is tied to the participant record by the StateWICID column of the Member table.

Format

The value prints as its literal value.

Certifying Staff Member

Origin of Data Element

The value is taken from the FirstName, MiddleInitial, and LastName columns of the UserProfile table.

Format

The value prints in {first name} {middle initial}. {last name} format.

Sort Order

Agency / Clinic / WIC Category / State WIC ID

The report is sorted by agency, clinic, WIC category, and then State WIC ID.

Control Breaks

Agency, Clinic, WIC Category

A page break occurs on change in agency, clinic, or WIC category.

|

State Office