Breastpump Issuance Report CLN013 (Output)

Contents ShowHide

The Breastpump Issuance Report CLN013 (Output) lists all participants who where issued a breastpump during the specified date range. The report is generated when the OK button is clicked on the Generate Breastpump Issuance Report screen.

The Detail version of this report lists each participant that received a breastpump during the specified date range and the total number issued for each breastpump. The Summary version of this report only includes the total number issued during the specified date range.

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 "Breastpump 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 "Breastpump Issuance - Summary" and the starting and ending date of the report when the page includes summary information. The starting and ending dates of the report will be entered on the Generate Breastpump 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

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.

Delivery Date (Detail)

Origin of Data Element

The value will be taken from the Postpartum.ActDelivDate from the current postpartum record of the participant.

Format

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

Mailing Address (Detail)

Origin of Data Element

The value will be taken from the Household.MailAddress for the household of the applicant.

Format

The value will print in its literal value.

Mailing City (Detail)

Origin of Data Element

The value will be taken from the Household.MailCity for the household of the applicant.

Format

The value will print in its literal value.

Mailing State (Detail)

Origin of Data Element

The value will be taken from the Household.MailState for the household of the applicant.

Format

The value will print in its literal value.

Mailing ZIP (Detail)

Origin of Data Element

The value will be taken from the Household.MailZIP for the household of the applicant.

Format

The value will print in #####-#### format.

Telephone (Detail)

Origin of Data Element

The value will be taken from the Household.Telephone1 for the household of the applicant.

Format

The value will print in the format ###-###-####.

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.

Issue Date (Detail)

Origin of Data Element

The value will be taken from the InventoryIssued.IssuedDate.

Format

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

ID (Detail)

Origin of Data Element

The value will be taken from the InventoryItem.SerialNbr. This includes products classified as a breastfeeding item with a Sub-class of breast pump.

Format

The value will print in its literal value.

Returned Date (Detail)

Origin of Data Element

The value will be taken from the InventoryIssued.ReturnedDate.

Format

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

Return Reason (Detail)

Origin of Data Element

The value will be the text description of the InventoryIssued.Returned ReasonCd from the Reference Dictionary table (INVRETURNRSN).

Format

The value will print in its literal value.

Date Kit Issued (Detail)

Origin of Data Element

The value will be taken from the InventoryIssued.IssuedDate. This includes inventory products classified as breastfeeding items that have a Sub-class of breastfeeding kit.

Format

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

Kits Received (Kits Recvd) (Detail)

Origin of Data Element

The value will be taken from the InventoryIssued.Quantity. This includes inventory products classified as breastfeeding items that have a Sub-class of breastfeeding kit.

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 Specific Breastpump Type

Only participants who where issued a breastpump of the type(s) specified by the user will be included in the report. This will be determined by examining the Product ManufacturerBrandType for the InventoryIssued.

Breastpumps 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"

Kits will be determined by examining the Product table criteria:

Class equal to 'BF'
Subclass equal to "K"

Breastpump Issued During Specified Date Range

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

Sort Order

Agency ID

The report is sorted first by Agency ID.

Clinic ID

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

Participant Name

The report will be sorted by the Participant Name 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 breastpump.

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 breastpump.

Grand Total

The total number issued will print for each breastpump.

Software Version: 2.40.00