Generate Formula Usage Report

Contents Show

The Generate Formula Usage Report screen is used to generate a Formula Usage Report OPR028 (Output) of the different formulas that were issued and redeemed in the time period.

For detailed information about the system output generated, see Formula Usage Report OPR028 (Output).

The Generate Formula Usage Report screen is available in the following application module:

State Office

State Office

Generate Formula Usage Report screen

Screen Access

Screen Access

Interface Initialization

Upon initial display of the screen, the following occurs:

  • The title bar text is set to "Generate Formula Usage Report".

  • The Local Agency drop-down list box defaults to "all".

  • The Clinic drop-down list box defaults to "all".

  • The WIC Category defaults to "all".

  • The Formula drop-down list box is initially blank.

  • The Show Details check box is initially unchecked.

  • The Month drop-down list box is enabled and defaults to blank unless the month value of the CurrentMonthEndDt column of the ProcessControl table equals one of the values in the list, in which case it will default to that value.

  • The Year masked edit box and spin control are enabled and the masked edit box defaults to the year value of the CurrentMonthEndDt column of the ProcessControl table.

  • The Report Destination radio button group is visible and enabled as the default. The Display on Screen radio button is initially selected as the default.

  • The OK button is visible and enabled as the default.

  • The Cancel button is visible and enabled as the default.

Screen Elements

Unless otherwise stated below, all controls on the Generate Formula Usage Report screen are visible and enabled when:

If one or more special conditions exist that affect a control on the Generate Formula Usage Report screen, the condition(s) are documented for that specific control below.

Agency drop-down list box

  Select the agency for which to generate the report in the Agency drop-down list box.

The drop-down list box is enabled when the screen is active. The drop-down list box contains all Agencies within the state from the AGENCY table. When enabled, the drop-down list box defaults to blank.

Clinic drop-down list box

  Select the clinic for which to generate the report in the Clinic drop-down list box.

The drop-down list box contains all Clinics associated with the agency currently selected in the Agency drop-down list box. The drop-down list box is enabled when the screen is active and an agency is selected in the Agency drop-down list box. The user will be able to subset the options displayed by selecting one clinic or all clinics. The drop-down list box contains all Clinics contained in the Clinic table associated with the selected agency in numeric order by Clinic ID. This drop-down list box includes a value of "(all)". The drop-down list box is initially blank. If a selection is made in this drop-down list box, upon a change to the Clinic the attribute will be emptied. Upon selecting "(all)" in the drop-down list box, the attribute will be emptied and disabled. If no selection is made in the drop-down list box, the report will include all clinics in the state. When enabled, the drop-down list box initially defaults to "(all)".

WIC Category drop-down list box

  Select the WIC category for which to generate the report in the WIC Category drop-down list box.

The drop-down list box is enabled when the screen is active. The drop-down list box contains all available WIC categories contained in the WIC Category table. Options in the drop-down list box are arranged in alphabetical order. The drop-down list box includes an option of a value of "(all)". The user will be able to subset the options displayed by selecting one or all WIC categories. The drop-down list box initially defaults to "(all)". If no selection is made in the drop-down list box, the report includes all WIC categories.

Formula drop-down list box

  Select the formula to run the report against in the Formula drop-down list box.

The list will display all distribution items with the food category 'formula' contained in the FoodDistributionItem table in alphabetical order. This list will include a value of "(all)". The control is initially blank. The control is initially blank.

If no selection is made in this column, the report includes all formulas.

Show Details check box

  Select the Show Details check box to indicate the report is to include the detail information of each Participant who was issued formula food instruments.

The control is initially unchecked.

Month drop-down list box

  Select the month the report covers in the Month drop-down list box.

This is a read-only drop-down list box. The drop-down list box contains all months from the Reference Dictionary, which are displayed as options in calendar month order. It defaults to the month value of the CLOSEMONTHENDDT column of the PROCESSCONTROL table. A selection is required in this control.

Year masked edit box and spin control

  Enter or select the year the report covers in the Year masked edit box and spin control.

The masked edit box only allows the entry of numeric digits. The maximum size of the control is four (4) digits. The masked edit box defaults to the year value of the CurrentMonthEndDt column of the ProcessControl table. Selection of the increment or decrement buttons of the spin control increases or decreases the value by one (1). The month/year entered must be less than the values used by the month-end process.

If the Month/Year entered is greater than the month/year value of the CurrentMonthEndDt column of the ProcessControl table, when the OK button is clicked the system displays the E0043 standard error message.

Report Destination radio button group

  Select an option in the Report Destination radio button group.

This radio button group includes controls that allow you to specify the destination of the generated system output. The title text of the radio button group is set to "Report Destination". A selection is required in this radio button group. The following radio buttons are included in the group:

Display on Screen radio button

Select the Display on Screen radio button to display the system output on your computer's monitor after it is generated. A report printer must currently be defined for your workstation.

Send to Printer radio button

Select the Send to Printer radio button to send the system output to the report printer currently defined for your workstation after it is generated. Printers are specified on the Default Printers screen.

Save as PDF radio button

Select the Save as PDF radio button to save the system output as a PDF file after it is generated.

OK button

  Click the OK button to generate the system output.

It is the default button for the screen.

It does not have a mnemonic. Its keyboard shortcut is the Enter key.

Depending on the selection in the Report Destination radio button group, one of the following occurs when the OK button is clicked:

The system output is generated and the Generate Reports screen displays when the button is clicked. Some reports can take a bit of time to generate. For these reports, a progress bar displays when the button is clicked.

Cancel button

Click the Cancel button to close the screen without generating the system output.

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Generate Reports screen displays when the button is clicked.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

If no data can be validated and saved on the screen:

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Control Label

Required

Agency

X

Clinic

X

WIC Category

X

Formula

X

Show Details

ยท

Month

X

Year

X

Report Destination radio button group

X

|

State Office