Breastpumps Loaned to Locations Report CLN024 (Output)

The Breastpumps Loaned to Locations Report CLN024 (Output) lists all breastpump that have been loaned to a specific location. The report does not list the breastpumps that were loaned and then returned to the inventory. The report is generated when the OK button is clicked on the Generate Breastpumps Loaned to Locations Report screen.

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 "Breastpumps Loaned to Locations".

Format

The headings 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.

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.

Loaned Date

Origin of Data Element

The value will be taken from the InventoryItem.StatusDate.

Format

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

Location

Origin of Data Element

The value will be taken from the InventoryItem.LocationName.

Format

The value will print in its literal value.

Breastpump Manufacturer

Origin of Data Element

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

Format

The value will print in its literal value.

Breastpump 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 in 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 in 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 in its literal value.

Subclass Type (Electric or Manual)

Origin of Data Element

This is the subclass 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 type code from the Product table.

Format

The value will print in its literal value.

ID

Origin of Data Element

The value will be taken from the InventoryItem.SerialNbr.

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.

Breastpump on Loan to Specific Locations

Only breastpumps that are current on loan to specific locations will be included in the report.

This will be determined by examining the InventoryItem table criteria:

• Status equal to "L"

• LoanedLocation valued

This will be determined by examining the Product table criteria:

• Class equal to 'BF'

• Subclass equal to "P"

• SubclassUse equal to "M" or "S"

• SubclassType equal to "M" or "E"

Loaned Date

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

The total number of breastpumps on loan to specific locations will print.

The total number of breastpumps on loan to specific locations will print.