Single-use Breastpumps Pending Receipt Report (Output)

The Single-use Breastpumps Pending Receipt Report (Output) is an exception report. A line will be printed for every outstanding single-use breastpump order. Outstanding single-use breastpump orders are those orders that have an order request status of either "Approved/Confirmed Order" (no receipt yet) or "Partial Receipt Pending" (only partially received). The report is generated when the OK button is clicked on the Generate Single-use Breastpumps Pending Receipt Report screen.

Report Title

The title of the report will be the page heading of all reports. The subtitle of the report will be the text "Single-use Breastpumps Pending Receipt Report".

Origin of Data Element

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

Format

The values will print as their literal values.

Date Ordered

Origin of Data Element

This value comes from the OrderDate column of the ORDERREQUEST table.

Format

This is an eight-digit value formatted MM/DD/CCYY.

Order Number

Origin of Data Element

This value comes from the OrderID column of the ORDERREQUEST table.

Format

This is a ten-digit value.

Manufacturer

Origin of Data Element

The value will be the text description of the breastpump manufacturer from the Manufacturer table. This includes products classified as a breastfeeding item with a Sub-class of breast pump.

Format

The value will print as its literal value.

Brand

Origin of Data Element

This is the brand of the breastpump. The value will be the text description of the breastpump brand from the ManufacturerBrand table.

Format

The value will print as its literal value.

Breastpump Type

Origin of Data Element

This is the type of breastpump. The value will be the text description of the breastpump brand type from the ManufacturerBrandType table.

Format

The value will print as its literal value.

Subclass Use (Single or Muliple)

Origin of Data Element

This is the subclass use of the breastpump product. The value will be the text description from the Reference Dictionary descriptions table where the Reference Dictionary category = 'INVPDCTSUBCLASSUSE' of the sub-class use code from the Product table.

Format

The value will print as its literal value.

Subclass Type (Electric or Manual)

Origin of Data Element

This is the subclass use type of the breastpump product. The value will be the text description from the Reference Dictionary descriptions table where the Reference Dictionary category = 'INVPDCTSUBCLASSTYP' of the sub-class use code from the Product table.

Format

The value will print as its literal value.

Order Packaging Quantity

Origin of Data Element

This value comes from the OrderPackaging column of the ORDERPACKAGING table. This is the quantity or individual number of items in the packaging.

Format

The value will print as its literal value.

Line Item Quantity Ordered

Origin of Data Element

This value comes from the Quantity column of the ORDERITEM table.

Format

The value will print as its literal value.

Line Item Quantity Received

Origin of Data Element

This value comes from the Quantity column of the ORDERITEMRECEIVED table.

Units Ordered

Origin of Data Element

This value is the number of individual breastpumps on order. This value is the quantity ordered multiplied by the quantity, number of items, in the line item order packaging.

OrderItem.Quantity * OrderPackaging.PackageQuantity

Format

The value will print as its literal value.

Units Received

Origin of Data Element

This value is the number of individual breastpumps that have been received. This value is the quantity received multiplied by the quantity, number of items, in the line item order packaging.

OrderItemReceived.Quantity * OrderPackaging.PackageQuantity

Format

This is a seven-digit value.

Units Pending Receipt

Origin of Data Element

This value is the number of individual breastpumps that have been ordered but not recorded as received. Cancelled orders are not considered in total. The value is the Items Ordered value minus the Items Received value.

Format

This is a seven-digit value.

Filter Criteria

Base of Data

Only outstanding single-use breastpump orders will print on this report. The report includes OrderRequests meeting the following criteria:

• OrderRequest Status = either

• 02=Approved/Confirmed Order (Ordered)

• 04=Partial Receipt Pending

• OrderItem Product

• Class equal to 'BF'

• Subclass equal to "P"

• SubclassUse equal to "S"

Sort Order

Order Date

The report will be sorted by the Order Date within Agency.

Order Number

The report will be sorted by the Order Number within Order Date.

Manufacturer

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

Manufacturer Brand

The report will be sorted by the ManufacturerBrand within Manufacturer.

Manufacturer Brand Type

The report will be sorted by the ManufacturerBrandType within ManufacturerBrand.

Subclass Use

The report will be sorted by the SubclassUse within ManufacturerBrandType.

Subclass Type

The report will be sorted by the SubclassType within SubclassUse.