The Breastfeeding Duration - Currently Breastfeeding (Healthy People Goals) Report OPR036 (Output) is an analysis of the duration of breastfeeding by race/ethnicity for participants who are currently breastfeeding with a birth date within the selected date range. The report is generated when the OK button is clicked on the Generate Breastfeeding Duration - Currently Breastfeeding Report screen and is also generated as part of the month-end process.
Enrolled participants are included in this report if the participant's date of birth is within the first day of the selected From month/year and the last day of the selected To month/year. The participant must be in a valid certification at the time the report is requested (current date). If the participant is currently breastfeeding, they are counted in the durations as of the date the report is requested (current date).
Participants with duration of less than one month are grouped into one of the durations (day) based upon their breastfeeding duration. Participants with duration of one month or more are grouped into each applicable durations (month) based upon their breastfeeding duration. For example, a participant with breastfeeding duration of 3 days is counted in the 2-4 day category while a participant with breastfeeding duration of 8 months and 5 days will be counted in the >= 1 Mo, >= 2 Mo, >= 3 Mo and >= 6 Mo categories.
Durations are:
1 day
2-4 days
5-7 days
8-30 days
>= 1 month
>= 2 months
>= 3 months
>=6 months
>= 12 months
The report also displays the counts by durations of participants fully breastfed, partially breastfed <= max and partially breastfed > max. These values are based on the amount breastfed at the point the report is requested. For instance, if breastfed amount is changed from fully breastfed to partially breastfed at the age of 6 1/2 months, the participant is considered partially breastfed for all duration categories.
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.
Origin of Data Element
The value is the following RPTID value:
"OPR036"
Format
The value is included as its literal value.
Origin of Data Element
The value is the current value of the REPORTHEADING business rule.
Format
The value is included as its literal value.
Origin of Data Element
The value is the following text:
"Breastfeeding Duration - Currently Breastfeeding"
Format
The value is included as its literal value and center aligned. It is positioned at the top of the report in the center below the Report Title.
Origin of Data Element
The user records this value when the report is submitted. During the month-end process this is the CCYYMM value from the CurrentMonthEndDt column of the ProcessControl table minus 14 months.
Format
This is an accounting month and year formatted as Month Name CCYY.
Origin of Data Element
The user records this value when the report is submitted. During the month-end process this is the CCYYMM value from the CurrentMonthEndDt column of the ProcessControl table.
Format
This is an accounting month and year formatted as Month Name CCYY.
Origin of Data Element
The value is the date on which the report is generated.
Format
The value is included in the following format: MM/DD/CCYY. The value will be the current system date when the report is generated.
Origin of Data Element
The value is the time at which the report is generated.
Format
The value is included in the following format: HH:MM:SS (AM/PM).
Origin of Data Element
The value is the current page of the report.
Format
The value is included as its literal value.
This section describes the data elements that print on the generated report. The data elements documented in this section display when the Display on Screen radio button, Send to Printer radio button, or the Save as PDF radio button is selected in the Report Destination radio button group on the Generate Breastfeeding Duration - Currently Breastfeeding Report screen when generating the report.
Origin of Data Element
When the INCLUDEGRANTEES business rule equals "Y", the report is defined as a grantee report, the selection criteria and information being reported determines this value as follows:
When reporting clinic data, the grantee code, grantee description, the agency code agency description, clinic code, and clinic description are printed.
When reporting agency data, the grantee code, grantee description, the agency code and agency description are printed.
When reporting grantee data, the grantee code and grantee description are printed.
When reporting state data, the text description of "State Total" is printed.
When the INCLUDEGRANTEES business rule does not equal "Y" or the report is not defined as a grantee report, the selection criteria and information being reported determines this value as follows:
When reporting clinic data, the agency code, agency description, clinic code and clinic description are printed.
When reporting agency data, the agency code and agency description are printed.
When reporting state data, the text description of "State Total" is printed .
Format
This is a fifty-character text value. The format is determined by the information being reported.
Origin of Data Element
This code value comes from the RaceEthnicity column of the Member table. The description value comes from RaceDescription column of the RaceEthnicity table for the associated RaceEthnicity code value.
Format
The code is a three-character value. The description is a thirty-character value.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y" and the CurrentlyBreastfed column of the Child table equals "Y".
The number of days breastfed is calculated by calculating the difference between the BreastFeedingBegan column of the Child table and the current date. If BreastFeedingBegan is equal to the current date, the participant is included in the "1 day" category.
Participants with duration of less than one month are grouped into one of the age categories (day) based upon their breastfeeding duration. Participants with duration of one month or more are grouped into each applicable age categories (month) based upon their breastfeeding duration. For example, a participant with breastfeeding duration of 3 days is counted in the 2-4 day category while a participant with breastfeeding duration of 8 months and 5 days will be counted in the >= 1 Mo, >= 2 Mo, >= 3 Mo and >= 6 Mo categories.
1 day (including 0 days)
2-4 days
5-7 days
8-30 days
>= 1 Mo (>= 31 days)
>= 2 Mo (>= 62 days)
>= 3 Mo (>= 92 days)
>= 6 Mo (>= 184 days)
>= 12 Mo (>= 366 days)
The percentage value is calculated by dividing each duration total for the race/ethnicity code by the total number of participants for that race/ethnicity (line). The result is multiplied by 100 and rounded to the nearest tenth.
Format
The count is a six-digit number. The percent value is a three-digit number plus one decimal place.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y" and the CurrentlyBreastfed column of the Child table equals "Y".
Format
This is a six-digit number.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "1".
The number of days breastfed is calculated by calculating the difference between the BreastFeedingBegan column of the Child table and the current date. The participants are grouped into one of the age categories defined above, based upon their breastfeeding duration.
The percentage value is calculated by dividing each duration total for the line by the total number of participants for the line. The result is multiplied by 100 and rounded to the nearest tenth.
Format
This is a six-digit number.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "1".
Format
This is a six-digit number.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "2".
The number of days breastfed is calculated by calculating the difference between the BreastFeedingBegan column of the Child table and the current date. The participants are grouped into one of the age categories defined above, based upon their breastfeeding duration.
The percentage value is calculated by dividing each duration total for the line by the total number of participants for the line. The result is multiplied by 100 and rounded to the nearest tenth .
Format
The count is a six-digit number. The percent value is a three-digit number plus one decimal place.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "2".
Format
This is a six-digit number.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "5".
The number of days breastfed is calculated by calculating the difference between the BreastFeedingBegan column of the Child table and the current date. The participants are grouped into one of the age categories defined above, based upon their breastfeeding duration.
The percentage value is calculated by dividing each duration total for the line by the total number of participants for the line. The result is multiplied by 100 and rounded to the nearest tenth.
Format
The count is a six-digit number. The percent value is a three-digit number plus one decimal place.
Origin of Data Element
This value is the count of selected participants for the race/ethnicity where EverBreastfed column of the Child table equals "Y", the CurrentlyBreastfed column of the Child table equals "Y" and the AmountBreastfeeding column of the Child table equals "5".
Format
This is a six-digit number.
Origin of Data Element
This value (line A) is the count of selected participants where EverBreastfed column of the Child table equals "Y" or "N".
Format
This is a six-digit number.
Origin of Data Element
This value (line B) is the count of selected participants where EverBreastfed column of the Child table equals "Y".
The percentage value is calculated by dividing the count of Infants Born in Date Range and Ever Breastfed by the count of Infants Born in Date Range (Ever Breastfed Yes/No) (Line B total divided by line A total). The result is multiplied by 100 and rounded to the nearest hundredth.
Format
The count is a six-digit number. The percent value is a three-digit number plus two decimal places.
Origin of Data Element
This value (line C) is the count of selected participants minus the count of selected participants where EverBreastfed column of the Child table equals "Y" or "N".
Format
The count is a six-digit number.
This section describes the data elements that print on the generated raw data spreadsheet. These data elements are displayed when the Save Raw Data as Spreadsheet radio button is selected in the Report Destination radio button group on the Generate Breastfeeding Duration - Currently Breastfeeding Report screen when generating the system output.
Origin of Data Element
This value comes from the GranteeAgency.GranteeID column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Grantee.Name column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Member.AgencyID column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Agency.Name column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Member.ServiceSiteID column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the ServiceSite.ServiceSiteName column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Member.StateWicID column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Race.EthnicityCD column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Race.EthnicityDescription column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Member.RaceEthnicity column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Race.RaceDescription column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the difference (in days) of the current date and Child.BreastfeedingBegan column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Child.EverBreastfed column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Child.CurrentlyBreastfed column.
Format
The value is left aligned and included as its literal value.
Origin of Data Element
This value comes from the Child.AmountBreastfeeding column.
Format
The value is left aligned and included as its literal value.
All WIC enrollees that meet the following selection criteria are included in the report totals. Data for hidden agencies will not be included.
The DateOfBirth column of the Member table is within the first day of the From month and the last day of the To month, inclusive.
The participant must currently be in a valid certification as of the date report was requested (ValidCertification column of the Member table = "Y").
If an individual clinic is selected, only data for that clinic is included. If multiple clinics are selected, data for each of the selected clinics will be included. If an individual agency is selected, summary data for that agency will be included. If an individual grantee is selected, summary data for that grantee will be included. If the state is selected, summary data for the state level will be included. Data for hidden agencies will not be included.
During the month-end process when all is selected, data for all clinics, agencies, grantees and state will be selected in the following sequence. Data for hidden agencies will not be included. Grantee data will be selected if the INCLUDEGRANTEES business rule equals "Y" and the report is defined as a grantee report.
Grantee 01, Agency 01, clinic 01
Grantee 01, Agency 01, clinic 02
Grantee 01, Agency 01 summary
Grantee 01, Agency 02, clinic 21
Grantee 01, Agency 02, clinic 22
Grantee 01, Agency 02 summary
Grantee 01 summary
Grantee 02, Agency 03, clinic 33
Grantee 02, Agency 03 summary
Grantee 02 summary
State summary.
The report will be sorted by clinic code, agency code, grantee code and state totals, depending on selection criteria of the report.
If one clinic is selected, this part of the sort order does not apply.
If multiple clinics are selected, the report is sorted by agency code then clinic code.
If the agency total is selected, this part of the sort order does not apply.
If the grantee total is selected, this part of the sort order does not apply.
If the state total is selected, this part of the sort order does not apply.
During month-end when all is selected and the INCLUDEGRANTEES business rule does not equal "Y" or the report is not defined as a grantee report, the report is sorted by agency code then clinic code. The state summary prints at the end.
During month-end when all is selected and the INCLUDEGRANTEES business rule equals "Y" and the report is defined as a grantee report, the report is sorted by grantee code, agency code then clinic code. The state summary prints at the end.
The report is sorted by ethnicity code within local clinic/agency/grantee/state. This part of the sort order does not apply to the summary report.
The report is sorted by the Race/Ethnicity code within ethnicity. This part of the sort order does not apply to the summary report
A page break occurs on change in clinic/agency/grantee.
No grand totals are defined for this system output.
This report can be generated on demand and will be generated during the month-end process, if the report is selected by the state.
During month-end, both a detail and summary report will be created. The From month/year value will be the CCYYMM value from the CurrentMonthEndDt column of the ProcessControl table minus 14 months. The To month/year value will be the CCYYMM value from the CurrentMonthEndDt column of the ProcessControl table.
|
Software Version: 2.40.00
