Breastfeeding Supplies Issuance Report CLN014 (Output)

Contents Show

The Breastfeeding Supplies Issuance Report CLN014 (Output) lists all participants who where issued breastfeeding supplies during the specified date range. The report is generated when the OK button is clicked on the Generate Breastfeeding Supplies Issuance 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.

Report Title

Origin of Data Element

The title of the report will be the value of the REPORTHEADING business rule. The subtitle of the report will be the text "Breastfeeding Supplies Issuance - Detail" and the starting and ending date of the report when the page includes detail information. The subtitle of the report will be the text "Breastfeeding Supplies Issuance - Summary" and the reporting date for the report when the page includes summary information. The starting and ending dates of the report will be entered on the Generate Breastfeeding Supplies Issuance Report screen by the user.

Format

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

Agency

Origin of Data Element

This value comes from the AgencyID and Name columns of the AGENCY table.

Format

The values will print as their literal values.

Clinic

Origin of Data Element

This value comes from the ServiceSiteID and Name columns of the SERVICE-SITE table.

Format

The values will print as their literal values.

State WIC ID (Detail)

Origin of Data Element

The value will be taken from the Member.StateWICID.

Format

The value will print as its literal value.

Participant Name (Detail)

Origin of Data Element

The value will be taken from the Member.FirstName, Member.MiddleInitial and Member.LastName.

Format

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

Issue Date (Detail)

Origin of Data Element

The value will be taken from the InventoryIssued.IssueDate.

Format

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

Breasfeeding Item

Origin of Data Element

The value will be the text description of the breastfeeding item from the Product table Manufacturer, ManufacturerBrand and ManufacturerBrandType. This includes products classified as a breastfeeding item with a Sub-class of breastfeeding supply (not a pump and not a kit).

This will be determined by examining the Product table criteria:

Format

The value will print in its literal value.

Quantity

Origin of Data Element

The value will be taken from the InventoryIssued.Quantity.

Format

The value will print in its literal value.

Filter Criteria

Clinic

The information for the user-specified clinic sites is included on the report. The clinics are bridged to InventoryLocation through the Location table.

Participants Issued Breastfeeding Supplies during Specified Date Range

Only participants who where issued breastfeeding supplies between the user-specified starting and ending dates will be included in the report. This will be determined by examining the InventoryIssued.IssueDate where the customer is a WIC participant.

Sort Order

Agency

The report is sorted first by Agency.

Clinic ID

The report will be sorted by the Clinic ID within Agency ID.

Issued Date

The report will be sorted chronologically by the Issued Date within Clinic ID.

Control Breaks

Clinic ID

A page break will occur on change in Clinic ID.

At the end of each Clinic the total number issued will print for each breastfeeding item.

Agency ID

A page break will occur on change in Agency ID.

At the end of each Agency the total number issued will print for each breastfeeding item.

Grand Total

The total number issued will print for each breastfeeding item. A grand total number of breastfeeding items issued will print when the page includes summary information.

|

Software Version: 2.40.00

Clinic