Breastfeeding Item Inventory Report CLN012 (Output)

The Breastfeeding Item Inventory Report CLN012 (Output) provides inventory management data as of a specified date. The report is generated when the OK button is clicked on the Generate Breastfeeding Item Inventory Report screen.

It is a point in time report. The report shows breastfeeding item orders, breastfeeding items that have been ordered but not received and breastfeeding item availability.

The Detail version of this report includes a separate line for each consignment of breastfeeding items to the clinics and the total amount for each breastfeeding item. The Summary version of this report only includes the total amount for each breastfeeding item.

The Breastfeeding Item Inventory Report CLN012 (Output) screen is available in the following application modules:

	Clinic
	State Office

Report Title

The title of the report will be the page heading of all reports. The subtitle of the report will be the text "Breastfeeding Item Inventory Report - Detail" and the reporting date for the report when the page includes detail information. The subtitle of the report will be the text "Breastfeeding Item Inventory Report - Summary" and the reporting date for the report when the page includes summary information. The reporting date for the report will be entered on the Generate Breastfeeding Item Inventory Report screen by the user.

Origin of Data Element

The title of the report will be the value of the REPORTHEADING business rule.

Format

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

Reporting Period MM/DD/CCYY - MM/DD/CCYY (Detail)

Origin of Data Element

This value comes from the selected date range.

Format

The values will print as their literal values.

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.

Breastfeeding 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 or kit (not a pump).

This will be determined by examining the Product table criteria:

• Class equal to 'BF'

• Subclass equal to "S" or "K"

Format

The value will print as its literal value.

Clinic

Origin of Data Element

This value comes from the ServiceSiteID and Name columns of the ServiceSite table.

Format

The values will print as their literal values.

Consigned Date (Detail - Clinic)

Origin of Data Element

This is the date when the breastfeeding items were consigned to the clinic inventory location. The date value comes from the ConsignedDttm column of the InventoryConsignedTrans table where the date is in the selected reporting range.

Format

This is a date value formatted MM/DD/CCYY.

Consigned Units (Detail - Clinic)

Origin of Data Element

This is the number of the breastfeeding items that were consigned to the clinic inventory location on the consigned date. The value comes from the Quantity column of the InventoryConsignedTrans table for the clinic inventory location.

Format

This is a seven-digit value.

Consigned Units Totals (Detail - Clinic)

Origin of Data Element

This is the sum of the Consigned Units column for the clinic.

Format

This is a seven-digit value.

Current Units On Hand Totals (Detail/Summary - Clinic)

Origin of Data Element

This is the number of breastfeeding items currently consigned to the clinic. The value is the Quantity column of the InventoryConsigned table for the clinic inventory location.

Format

This is a seven-digit value.

Units Ordered (Detail - Order Inventory Status)

Origin of Data Element

This value is the number of individual breastfeeding items on order as of today. The order request status is 02=Approved/Confirmed or 04=Partial Order Received/Pending. This column represents orders submitted by the state to the manufacturer. This value is the quantity of the order line item multiplied by the number of units in the line item order packaging.

OrderItem.Quantity * OrderPackaging.PackageQuantity

Format

This is a seven-digit value.

Date Received (Detail - Order Inventory Status)

Origin of Data Element

This is the date when the breastfeeding items were received. The value comes from the ReceivedDate column of the OrderItemReceived table matching the selected OrderRequest OrderItem. This column represents orders submitted by the state to the manufacturer.

Format

This will be a date field formatted as MM/DD/CCYY.

Units Received (Detail - Order Inventory Status)

Origin of Data Element

This value is the number of breastfeeding items that have been received. This column represents orders submitted by the state to the manufacturer. This value is the quantity of the order line item received multiplied by the number of units in the line item order packaging.

OrderItemReceived.Quantity * OrderPackaging.PackageQuantity

Format

This is a seven-digit value.

Pending Receipt (Detail - Order Inventory Status)

Origin of Data Element

This value is the number of individual breastfeeding items that have been ordered but not received. The value is the Units Ordered minus the Units Received value. This column represents orders submitted by the state to the manufacturer.

Format

This is a seven-digit value.

Units Consigned (Detail - Order Inventory Status)

Origin of Data Element

This is the count of breastfeeding items that were consigned to all inventory locations. The value is the sum of the Quantity in InventoryConsigned table for the InventoryLocations. This is the total number of product units assigned to clinics (all locations).

Format

This is a seven-digit value.

Units on Hand (Detail - Order Inventory Status)

Origin of Data Element

This is the number of breastfeeding items in general inventory and not consigned. The value is the QuantityInStock from the Inventory table. This column represents orders submitted by the state to the manufacturer.

Format

This is a seven-digit value.

Units Ordered Totals (Detail/Summary - Order Inventory Status)

Origin of Data Element

This value is the sum of the number of individual breastfeeding items on order as of today. The order request status is 02=Approved/Confirmed or 04=Partial Order Received/Pending. This column represents orders submitted by the state to the manufacturer. This value is the quantity of the order line item multiplied by the number of units in the line item order packaging.

OrderItem.Quantity * OrderPackaging.PackageQuantity

Format

This is a seven-digit value.

Units Received Totals (Detail/Summary - Order Inventory Status)

Origin of Data Element

This value is the sum of the number of breastfeeding items that have been received. This value is the quantity of the order line item received multiplied by the number of units in the line item order packaging.

OrderItemReceived.Quantity * OrderPackaging.PackageQuantity

Format

This is a seven-digit value.

Pending Receipt Totals (Detail/Summary - Order Inventory Status)

Origin of Data Element

This value is the sum of the number of individual breastfeeding items that have been ordered but not received. The value is the Units Ordered minus the Units Received value.

Format

This is a seven-digit value.

Units Consigned Totals (Detail/Summary - Order Inventory Status)

Origin of Data Element

This is the sum of the count of breastfeeding items that were consigned to all inventory locations. The value is the sum of the Quantity in InventoryConsigned table for the InventoryLocations.

Format

This is a seven-digit value.

Units on Hand Totals (Detail/Summary - Order Inventory Status)

Origin of Data Element

This is the sum of the number of breastfeeding items in general inventory and not consigned. The value is the QuantityInStock from the Inventory table.

Format

This is a seven-digit value.

Filter Criteria

Inventory as of Reporting Date (Detail)

The breastfeeding item inventory detail information for all agency and clinic inventory locations is included on the report as of the user-specified reporting date range.

Inventory as of Reporting Date (Summary)

The breastfeeding item inventory information is as of the current system date.

Selected Clinic(s)

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

Breastfeeding Items(s)

The inventory information for the user-specified breastfeeding item(s) is included on the report.

This will be determined by examining the Product table criteria:

• Class equal to 'BF'

• Subclass equal to "S" or "K"

Clinic Site

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

Control Breaks - Detail

Control Breaks - Summary

Order Inventory Status

The inventory status will be the total number of breastfeeding items ordered, received, pending, consigned and the total number of breastfeeding items on hand will print for each breastfeeding item.

The inventory status is activity performed by the state where items are ordered from the manufacturer and then consigned to a clinic location.