Contents Show
The Breastpump Inventory Report CLN011 (Output) shows breastpump orders, breastpumps that have been ordered but not received, breastpumps received and assigned/unassigned, and breastpump availability. The report is generated when the OK button is clicked on the Generate Breastpump Inventory Report screen.
The Detail version of this report includes a separate line for each consignment of breastpumps to the clinics and the total quantity for each breastpump. The Summary version of this report only includes the total lines.
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.
The title of the report will be the page heading of all reports. The subtitle of the report will be the text "Breastpump 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 "Breastpump 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 Breastpump 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.
Origin of Data Element
This value comes from the selected date range.
Format
The values will print as their literal values.
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.
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.
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 as its literal value.
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.
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.
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.
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.
Origin of Data Element
This is the date when the breastpumps 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.
Origin of Data Element
This is the number of breastpumps 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.
Origin of Data Element
This is the sum of the Consigned Units column for the clinic.
Format
This is a seven-digit value.
Origin of Data Element
This is the number of breastpumps 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.
Origin of Data Element
For tracked inventory only:
This is the number breastpumps consigned to the clinic that are currently issued. The value is the count of breastpumps in the InventoryItem table for the clinic inventory location where the status is equal to issued.
Format
This is a seven-digit value.
Origin of Data Element
For tracked inventory only:
This is the number of breastpumps consigned to the clinic that are currently loaned to a location. The value is the count of breastpumps in the InventoryItems table where the status is equal to loaned.
Format
This is a seven-digit value.
Origin of Data Element
This value is the number of breastpumps that are consigned (not issued, loaned or retired). It is calculated as the number of Current Units Consigned minus the Units Issued minus the Units Loaned.
Format
This is a seven-digit value.
Origin of Data Element
This value is the number of individual breastpumps on order as of today. The order request status is 02=Approved/Confirmed or 04=Partial Order Received/Pending. 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.
Origin of Data Element
This is the date when the breastpumps were received. The value comes from the ReceivedDate column of the OrderItemReceived table matching the selected OrderRequest OrderItem.
Format
This will be a date field formatted as MM/DD/CCYY.
Origin of Data Element
This value is the number of breastpumps 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.
Origin of Data Element
This value is the number of individual breastpumps 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.
Origin of Data Element
This is the count of breastpumps 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.
Origin of Data Element
This is the number of breastpumps in general inventory and not consigned. The value is the QuantityInStock from the Inventory table.
Format
This is a seven-digit value.
Origin of Data Element
This value is the sum of the number of individual breastpumps on order as of today. The order request status is 02=Approved/Confirmed or 04=Partial Order Received/Pending. 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.
Origin of Data Element
This value is the sum of the number of breastpumps 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.
Origin of Data Element
This value is the sum of the number of individual breastpumps 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.
Origin of Data Element
This is the sum of the count of breastpumps 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.
Origin of Data Element
This is the sum of the number of breastpumps in general inventory and not consigned. The value is the QuantityInStock from the Inventory table.
Format
This is a seven-digit value.
The breastpump inventory detail information for all agency and clinic inventory locations is included on the report as of the user-specified reporting date range.
The order status page is always as of the current system date.
The breastpump inventory information is as of the current system date.
The information for the user-specified clinic sites is included on the report. The clinics are bridged to InventoryLocation through the Location table.
The breastpump inventory information for the user-specified breastpump type(s) is included on the report.
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"
The report will be sorted by the Clinic Site within Agency.
The report will be sorted by the Manufacturer within Clinic Site.
The report will be sorted by the ManufacturerBrand within Manufacturer.
The report will be sorted by the ManufacturerBrandType within ManufacturerBrand.
The report will be sorted by the SubclassUse within ManufacturerBrandType.
The report will be sorted by the SubclassType within SubclassUse.
A subtotal break will occur on change in Manufacturer/Brand/Type/SubclassUse-Type.
The inventory status will be the total number of breastpumps ordered, received, pending, consigned and the total number of breastpumps on hand will print for each breastpump.
|
Software Version: 2.40.00