A04_SOW_IHS_DRA___Final_0001.pdf

Statement of Work (SOW)

Demographic Data and Analysis Services Indian Health Service Office of Public Health Support Division of Program Statistics

PART 1

GENERAL INFORMATION

1. GENERAL: This is a non-personnel services contract to provide Demographic Research and Analysis.

The Government shall not supervise or control the contract service providers performing the services herein. Such contract service providers shall be accountable solely to thePer Contractor, who, in turn, is responsible to the Government.

1.1 Description of Services/Introduction: The Contractor shall provide all personnel, equipment, supplies, facilities, transportation, tools, materials, supervision, and other items and non-personal services necessary to perform Demographic Research and Analysis as defined in this Statement of Work except for those items specified as Government-furnished property and services. The Contractor shall perform to the standards in this Contract.

1.2 Background: Since at least 1996, the Office of Public Health Support Division of Program Statistics has used county-level data provided to DPS by the Centers for Disease Control and Prevention (CDC) National Center for Health Statistics (NCHS) as well as the National Institutes of Health (NIH) National Cancer Institute to correctly report the race of American Indians and Alaska Natives (Al/AN) using aggregated state birth and death certificates. After processing, the data analysis results have been used for planning, budget formulation, and resource allocation.

The Indian Health Service (IHS) and Indian Tribes use demographic data for planning, outcome measurement, and determining the health status of Al/AN. In addition, resource allocations occur based on such data; therefore, these data must be adjusted to correct Al/AN race errors on state death certificates.

Other similar errors occur with birth certificates. Published studies have determined that the race of Al/AN decedents is often identified incorrectly on state death certificates when the race is compared for these same individuals in other sources. See this link for details of the IHS study whose methods are currently used for mortality data. These adjustment factors or similar newer ones will be provided to the effort.

https://www.ihs.gov/sites/dps/themes/responsive2017/display_objects/documents/AdjustingForMiscoding OfIndianRaceOnStateDeathCertificates.pdf

Given these needs, statistical expertise and assistance are required to augment statistical data processing and programming, as well as data analysis, tabulation, and reporting of Al/AN demographic data with accurate adjustment for the misreporting of race.

1.3 Objectives:

• To supply 100% of deliverables within the contract period per the agreed-upon timeline.

• To work with the demographic data provided by the Government in a safe, secure manner, ensuring the privacy of the people represented in this data.

• To calculate and report accurate mortality, natality and related natality phenomena rates by age, sex, administrative region of IHS (area), and cause(s) of death for American Indians/Alaska Natives in the IHS service area and US All Races

• To discover and employ the use of indirect standardization or similar techniques to correct for the misclassification of race on birth certificates for American Indians/Alaska Natives in the IHS service area and US All Races for all data years.

• To calculate and report life expectancy and years of potential life lost (YPLL) by age, sex, and administrative region of IHS (area) for American Indians/Alaska Natives in the IHS service area and US All Races for all data years.

https://www.ihs.gov/sites/dps/themes/responsive2017/display_objects/documents/AdjustingForMiscodingOfIndianRaceOnStateDeathCertificates.pdf https://www.ihs.gov/sites/dps/themes/responsive2017/display_objects/documents/AdjustingForMiscodingOfIndianRaceOnStateDeathCertificates.pdf

• To report the results of the demographic data as described immediately above (mortality, natality, life expectancy, YPLL and related demographic topics) in a manner that staff of the Division of Program Statistics can readily present these to the publisher of its reports, Trends in Indian Health and Regional Differences in Indian Health as well as specialized, more minor focused reports.

Reports will also have to be machine-readable.

• To provide technical assistance on demographic data questions and to provide code and a lucid, understandable explanation of how it works or what it says when needed.

• To provide one ad-hoc study per quarter (every 90 days) on a particular demographic research/analysis topic.

1.4 Scope: Demographic research analysis services will be provided to include custom statistical programming with confidential data. Services include programming calculations of demographic data tables from Government provided data using Government provided methods and reporting the results in DPS staff and machine-readable forms. Four sets of age groups and a normative comparison to two reference populations would be required. The Contractor will develop, generate, and provide statistical programs and data files to the IHS Windows secure server via a government-furnished laptop. Contractor assistance is needed to support the Division of Program Statistics' continued efforts to compute, analyze, report, and document these population health measures. The Contractor will actively participate in discovering and applying standardization methods in calculating natality rates, requiring knowledge of public health demography and epidemiological methods sufficient to explore standardization techniques and apply them in practice to existing data. The Contractor will be provided with and apply adjustment factors to the Mortality and Linked Birth/Infant Death Files provided by CDC or NIH. Once misclassification correction approaches are solved, the Government will provide relevant Natality files.

This effort will require detailed statistical programming skills to prepare adjusted multiyear Al/AN mortality files, including computer programming steps that will involve using the linked birth/infant death files, which are used to prepare adjusted counts for Al/AN infant death. See Part 5, Specific Tasks, for a description of the required tasks. The Contractor will possess a minimum of key personnel as described in section 1.6.8 below.

1.5 Period of Performance: The period of performance shall be for one (1) Base Year of 12 months and four (4) 12-month option years.

1.6 General Information

1.6.1 Recognized Holidays:

The Contractors' weekly schedule is. No work is expected on Weekends or Federal Holidays shown below:

Government holidays are:

1. New Year's Day, January 1

2. Martin Luther King's Birthday, 3rd Monday in January

3. Presidents Day, 3rd Monday in February

4. Memorial Day Last Monday in May

5. Juneteenth, June 19

6. Independence Day, July 4

7. Labor Day, 1st Monday in September

8. Columbus Day, 2nd Monday in October

9. Veterans Day, November 11

10. Thanksgiving Day, 4th Thursday in November

11. Christmas Day, December 25

1.6.2 Hours of Operation: The Contractor is responsible for conducting business between the hours of 8:00 AM - 4:30 PM Eastern Time, Monday thru Friday, except on Federal holidays or when the Government facility is closed due to local or national emergencies, administrative closings, or similar Government directed facility closings. The Contractor must always maintain an adequate workforce for the uninterrupted performance of all tasks defined within this SOW when the Government facility is not closed for the above reasons. When hiring personnel, the Contractor shall keep in mind that the stability and continuity of the workforce are essential.

1.6.3 Place of Performance: The work under this Contract will be performed virtually with the Government 95 percent of the time except when work requires person-to-person contact, such as when the PIV identification card is obtained to use the GFE.

1.6.4 Type of Contract: The Government will award a FFP contract.

1.6.5 Deliverables: Please send all deliverables to the attention of the Director, Division of Program Statistics, Rockville, MD. Kirk Greenway, kirk.greenway@ihs.gov, 5600 Fishers Lane Suite 09E, Rockville, MD 20857.

1.6.5 Security Requirements: All users given access to IHS systems containing individually identifiable health information or IHS sensitive information must sign an agreement stating they will comply with the IHS rules for using computer resources and handling IHS sensitive information. They must complete ISSA and privacy training before being given access and sign an appropriate Nondisclosure Agreement (NDA).

The Contract will have attached an appropriate Business Associate Agreement (BAA), a copy of which will be retained by the COR and the Privacy Office of IHS.

1.6.5.1 Physical Security: The Contractor shall safeguard all government equipment, information and property provided for contractor use. Any operator of the Government-furnished laptop must pass a background check sufficient to retain a PIV card needed to access the IHS network and Windows secure server. Government equipment and materials shall be secured at the close of each work period.

1.6.6. Special Qualifications: The Contractor is responsible for ensuring all employees possess and maintain current training status for all training required by the Indian Health Service Office of Human Resources or Office of Information Technology.

1.6.6 Post-Award Conference/Periodic Progress Meetings: The Contractor agrees to attend any post-award conference convened by the contracting activity or contract administration office per Federal Acquisition Regulation Subpart 42.5. As appropriate, the contracting officer, Contracting Officers Representative (COR), and other Government personnel will meet periodically with the Contractor to review the Contractor's performance. At these meetings, the contracting officer will apprise the Contractor of how the Government views the Contractor's performance, and the Contractor will apprise the Government of problems, if any, being experienced. Appropriate action shall be taken to resolve outstanding issues. These meetings shall be at no additional cost to the Government. These meetings will be virtual at the discretion of the Government.

1.6.7 Contracting Officer Representative (COR): A separate letter will identify the (COR). The COR monitors all technical aspects of the Contract and assists in contract administration. The COR is authorized to perform the following functions: assure that the Contractor performs the technical requirements of the Contract: perform inspections necessary in connection with contract performance: maintain written and oral communications with the Contractor concerning technical aspects of the Contract: issue written interpretations of technical requirements, including Government drawings, designs, specifications: monitor Contractor's performance and notifies both the Contracting Officer and Contractor of any deficiencies;

coordinate availability of Government-furnished property, and provide site entry of Contractor personnel.

A letter of designation issued to the COR, a copy of which is sent to the Contractor, states the responsibilities and limitations of the COR, especially concerning changes in cost or price, estimates or changes in delivery dates. The COR is not authorized to change any of the terms and conditions of the resulting order.

mailto:kirk.greenway@ihs.gov

1.6.8 Key Personnel: The Government considers the following personnel key personnel: public health (PH) demographer, demographic statistical programmer/analyst, and junior research analyst/administrative assistant. The Contractor shall provide a project manager who shall be responsible for the performance of the work. The name of this person and an alternate who shall act for the Contractor when the manager is absent shall be designated in writing to the contracting officer. The project manager or alternate shall have full authority to act for the Contractor on all contract matters relating to the daily operation of this Contract.

The project manager or alternate shall be available between 8:00 AM to 4:30 PM, Monday thru Friday, except for Federal holidays or when the government facility is closed for administrative reasons.

Qualifications for all key personnel are listed below:

1.6.8.1 Project manager and Alternate. The Project manager and Alternate must have knowledge and experience in public health demography and familiarity with vital event, economic (unemployment, income, educational attainment) and disease data.

1.6.8.2 Public health (PH) demographer. The PH demographer must have a certification and experience in demography and a related degree to at least a Masters degree plus 2-3 years of relevant work experience including computer programming and analysis.

1.6.8.3 Demographic Statistical Programmer/Analyst. The Demographic Statistical Programmer/Analyst must have a certification and 3-5 years experience in statistical package (SAS strongly preferred, SPSS, STATA) and or computer language programming (R strongly preferred, or possibly Python, SQL.

1.6.8.4 Junior Research Analyst/Administrative Assistant. The Junior Research Analyst should have experience in specific training and subject matter to include skills in using Microsoft Office software (Word, Excel, PowerPoint).

1.6.9 Identification of Contractor Employees: All contract personnel attending meetings, answering Government telephones, and working in other situations where their contractor status is not apparent to third parties are required to identify themselves as such to avoid creating an impression in the minds of members of the public that they are Government officials. They must also ensure that all documents or reports produced by contractors are suitably marked as contractor products or that contractor participation is appropriately disclosed. The contractor personnel shall obtain and wear visitor badges or make visible contractor status or services affiliation in the performance of this service.

1.6.10 Contractor Travel: The Contractor will not be required to travel except to an off-site location to obtain a Personal Identification Card or PIV. All travel requirements, including plans, agenda, itinerary, and dates, must be included. Travel costs shall be billed per regulatory implementation of Public Law 99- 234 and FAR 31.205-46 Travel Costs, the Federal Travel Regulations

1.6.11 Other Direct Costs: Contractor and subcontractor personnel performing work under this Contract may include reproduction and shipping expenses associated with training activities and visits to contractor facilities. The contracting officer must preapprove these costs.

1.6.12 Data Rights: The Government has unlimited rights to all documents/material produced under this Contract. All documents and materials, including the source codes of any software produced under this Contract, shall be Government owned and are the Government's property with all rights and privileges of ownership/copyright belonging exclusively to the Government. These documents and materials may not be used or sold by the Contractor without written permission from the Contracting Officer. All materials supplied to the Government shall be the sole property of the Government and may not be used for any other purpose. This right does not abrogate any other Government rights.

1.6.13 Organizational Conflict of Interest: The contractor employee may be required to sign a conflict of interest certificate if the Contracting Officer determines the contract and associated work may potentially affect the employee's or the employer's financial interest. When the Contracting Officer determines the potential exist, the contractor employee through the contract Project Manager shall be required to sign a Conflict of Interest Certificate.

PART 2

DEFINITIONS & ACRONYMS

2. DEFINITIONS AND ACRONYMS:

2.1. DEFINITIONS:

2.1.1. CONTRACTOR. A supplier or vendor is awarded a contract to provide specific supplies or services to the Government. The term used in this Contract refers to the prime.

2.1.2. CONTRACTING OFFICER. A person with authority to enter into, administer, and or terminate contracts and make related determinations and findings on behalf of the Government. Note: The only individual who can legally bind the Government.

2.1.3. CONTRACTING OFFICER'S REPRESENTATIVE (COR). An employee of the US Government appointed by the contracting officer to administer the Contract. Such appointment shall be in writing and state the scope of authority and limitations. This individual has the authority to provide technical direction to the Contractor as long as that direction is within the scope of the Contract, does not constitute a change, and has no funding implications. This individual does NOT have the authority to change the terms and conditions of the Contract.

2.1.4. DEFECTIVE SERVICE. A service output that does not meet the standard of performance associated with the Statement of Work.

2.1.5. DELIVERABLE. Anything that can be physically delivered, including through electronic computer file transfer, may include non-manufactured things such as intermediate data products, meeting minutes or reports.

2.1.6. KEY PERSONNEL. Contractor personnel are evaluated in a source selection process, which may be required to be used in the performance of a contract by the Key Personnel listed in the SOW. When key personnel are used as an evaluation factor in best-value procurement, an offer can be rejected if it does not have a firm commitment from the persons listed in the proposal.

2.1.7. PHYSICAL SECURITY. Actions that prevent the loss or damage of Government property.

2.1.8. SUBCONTRACTOR. One that enters into a contract with a prime contractor. The Government does not have the privity of a contract with the subcontractor.

2.1.9. WORK DAY. The number of hours per day the Contractor provides services under the Contract.

2.1.10. WORK WEEK. Monday through Friday unless specified otherwise.

2.1.11. DEMOGRAPHY. Demography is the scientific study of human populations primarily concerning their size, their structure and their development; it takes into account the quantitative aspects of their general characteristics, especially regarding size and density, distribution, and vital statistics (births, marriages, deaths, diseases, etc.)

2.1.12. RESEARCH. The discovery and description of processes, patterns, or characteristics developed from computer data models.

2.1.13. ANALYSIS. The statement in clear, plain, simple terms of the results of discovery or description in data models or similar developed from research with data and existing peer-reviewed literature.

2.2. ACRONYMS:

ACOR Alternate Contracting Officer's Representative AI/AN American Indian/Alaska Native CDC Centers for Disease Control CFR Code of Federal Regulations CONUS Continental United States (excludes Alaska and Hawaii) COR Contracting Officer Representative COTS Commercial-Off-the-Shelf FAR Federal Acquisition Regulation HIPAA Health Insurance Portability and Accountability Act of 1996 IHS Indian Health Service KO Contracting Officer NCHS National Center for Health Statistics (part of the CDC) NCI National Cancer Institute (part of the NIH) NIH National Institutes of Health OCI Organizational Conflict of Interest OCONUS Outside Continental United States (includes Alaska and Hawaii) ODC Other Direct Costs POC Point of Contact PIV Personnel Identity Verification Card PRS Performance Requirements Summary SOW Statement of Work TE Technical Exhibit

PART 3

GOVERNMENT-FURNISHED PROPERTY, EQUIPMENT, AND SERVICES

3. GOVERNMENT-FURNISHED ITEMS AND SERVICES:

3.1. Services: The Government will provide requirements, data, and direction in the research and analysis of demographic data. The Government will provide, when needed, identification following a background check, such as an identification card, network access, and an ihs.gov email address.

3.2 Facilities: The Government will provide virtual meeting rooms for the Contractor to meet with the Government routinely.

3.3 Equipment: The Government will furnish equipment such as a laptop and space in a secure virtual computer processing and storage environment.

3.4 Materials: The Government will provide Standard Operating Procedures and Policies related to the Contractor's support of demographic data research and analysis. The Government shall provide access to county identifiers and additional data/information (where applicable) needed.

PART 4

CONTRACTOR-FURNISHED ITEMS AND SERVICES

4. CONTRACTOR-FURNISHED ITEMS AND RESPONSIBILITIES:

4.1 General: The Contractor shall furnish all supplies and training-related materials required to perform work under this Contract not listed under Section 3 of this SOW.

4.2 Nondisclosure agreement. The Contractor shall provide the names of all key personnel working with the IHS-provided data and materials who work for the firm and have signed the nondisclosure agreement.

A Business Associate Agreement (BAA) will be signed by the Contractor firm's representative and maintained by both the Contractor and the Government, specifically the IHS Privacy Act Office.

4.2. Materials: The Contractor shall furnish materials such as software, office supplies, telecommunications, and secure storage of intermediate documents and data files necessary to meet the requirements under this SOW.

4.3. Equipment: The Contractor shall furnish laptop(s) used by Contractor key personnel to meet the requirements under this SOW.

PART 5

SPECIFIC TASKS

5. Specific Tasks:

5.1. General: The Contractor shall work independently and not as an agent of the Government. The Contractor shall furnish all the necessary services, qualified personnel, material, equipment, travel, and facilities not otherwise provided by the Government as needed to perform the Statement of Work task list below unless information security requirements of the Government require it, or it is not available in the public domain (confidential parameters for calculations, data furnished only by the Government) in which case, the Government will supply Government-furnished equipment (GFE) or materials for the task. The Contractor shall use the IHS demographic statistical methodologies provided for the project, such as the methods to adjust for misclassification of race in vital events data and its categories/process specific to the IHS or the US Government.

5.1.1 Work with the Secure Windows Server: Access demographic data from a secure government server using a government-furnished laptop for research and analysis working in files in any scripting tool or language to perform the work, preferably SAS or R, or another similar tool which both the Government and the Contractor can read, write, and interpret. See also data transfers in 5.3. below.

5.1.2 Adjustment for Misclassification of Race in Vital Records. Develop an approach (first year only) to adjust the racial misclassification by race for natality (see 5.2.4 below). Use racial misclassification factors successfully in the adjustment of mortality, births and infant deaths, and natality datasets. The methods for mortality depend on linking data but instead use studies developed from National Death Index linkages, however, the approach to natality cannot employ a National Birth Index linkage since none exists at the time of this writing.

5.2. Research/Analysis Support (timing is given in Technical Exhibit 1) :

5.2.1 Produce demographic tables as data sets needed for Regional Differences in Indian Health and one edition of Trends in Indian Health

5.2.1.1 Denominators for rates. The Contractor shall supply American Indian Alaska Native eligible population age, sex, administrative region of IHS (area, service unit, PRCDA, county) for the present, estimating 30 years in the future. Administrative boundary tables and methods of calculation would be provided and explained which are used by the Government. To calculate the rates, a denominator of eligible population data set and an appropriate data set based on each NCHS file (natality, linked infant birth death, mortality).

5.2.1.1.1 Mortality Data Set. 2014-2021 (three year data years for a total of six). The Mortality dataset with adjustment factors applied adjustment factors to compensate for misreporting of Al/AN race on the state death certificates. This will need to match the denominator file in being apportioned by age group, sex, county, service unit, and purchased referred care delivery area. This will be delivered with a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum;

government readable statistical code and data file. The data set will be checked. Up to four drafts of the dataset might be checked before the rates are finalized and presented in the tables in the excel template workbook. In addition, at the national level, six data sets of three year data years with adjustment factors by age group and sex will need to be produced from 2008 to 2015.

5.2.1.1.2 Linked Birth and Infant Death Data Set. 2014-2019 (three year data years for a total of four). The dataset will have adjustment factors applied adjustment factors to compensate for misreporting of Al/AN race on the state death certificates. This will need to match the denominator file in being apportioned by age group, sex, county, service unit, and purchased referred care delivery area. This will be delivered with a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum;

government readable statistical code and data file. The data set will be checked. Up to four drafts of the dataset might be checked before the rates are finalized and presented in the tables in the excel template workbook. In addition, at the national level, six data sets of three year data years with adjustment factors by age group and sex will need to be produced from 2008 to 2015.

5.2.1.1.3 Natality Data Set. 2014-2021 (three year data years for a total of six). The dataset will have adjustment factors applied adjustment factors to compensate for misreporting of Al/AN race on the state death certificates. This will need to match the denominator file in being apportioned by age group, sex, county, service unit, and purchased referred care delivery area. This will be delivered with a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum;

government readable statistical code and data file. The data set will be checked. Up to four drafts of the dataset might be checked before the rates are finalized and presented in the tables in the excel template workbook. In addition, at the national level, six data sets of three year data years with adjustment factors by age group and sex will need to be produced from 2008 to 2015.

5.2.1.1.4. Technical support will be offered in verbal and written form to explain differences, if found, between the produced rate tables from the approved, confirmed datasets in 5.2.1.1 to 5.2.1.1.3 and previously published results.

5.2.1.2. Tables for Trends in Indian Health. One hundred fifty tables would be provided for Trends in Indian Health, of which 14 data years of data would be needed for 28 of them. See the most recent Trends in Indian Health 2014 at https://shorturl.at/ghEX0 These will be for AI/AN and US All Races at the National Level. These will be delivered in a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum; government readable statistical code and data file. A templated set of Microsoft Excel workbooks and PowerPoint slides will be provided as a model to follow exactly.

5.2.1.3. Tables for Regional Differences in Indian Health. See https://shorturl.at/noGZ2 Seventy-five tables that would be by 12 IHS Areas with nearly identical subject matter to Trends in Indian Health will be provided for Regional Differences in Indian Health for the most recent data year. They will be regional, not national. Calculation of these tables will involve the use of sub-regional (area level) tables and descriptions of the administrative units (county, service unit, PRCDA) of the Indian Health Service. These will be delivered in a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum; government readable statistical code and data file. A templated set of Microsoft Excel workbooks and PowerPoint slides will be provided as a model to follow exactly.

5.2.1.4 Tables for Life Expectancy Report. See https://shorturl.at/dfJ56 These will be delivered in a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum;

government readable statistical code and data file. A templated set of Microsoft Excel workbooks and PowerPoint slides will be provided as a model to follow exactly. See 5.2.2 below.

5.2.1.5 Table for Years of Potential Life Lost (YPLL) See https://shorturl.at/hpry7 . These (see p. 75-77 in the url) will be delivered in a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum; government readable statistical code and data file. A templated set of Microsoft Excel workbooks and PowerPoint slides will be provided as a model to follow exactly.

Accompanying data set and code will be produced and delivered with the tables.

5.2.1.6 Quarterly ad hoc report. Up to 32 additional demographic tables for special studies would be needed at a rate of no more than eight tables every 90 days. For an example of how the CDC does a data brief on a demographic topic, see https://shorturl.at/ghkrK for a good example of a kind of document that would use the data tables produced by the Contractor. These will be delivered in a Word document explanation; excel spreadsheet (.xlsx) final with approximately four drafts maximum; government readable statistical code and data file. A templated set of Microsoft Excel workbooks and PowerPoint slides will be provided as a model to follow exactly.

5.2.2 Assist with the measure calculations to the IHS Area level needed for the Annual Life Expectancy Report. See https://shorturl.at/dfJ56 https://shorturl.at/ghEX0 https://shorturl.at/noGZ2 https://shorturl.at/dfJ56 https://shorturl.at/hpry7 https://shorturl.at/ghkrK https://shorturl.at/dfJ56

5.2.2.1 A series of tables would be constructed, and calculations replicated from Microsoft Excel workbooks which would be automated in a code which the government would possess and be able to interpret afterward.

5.2.3 Evaluate and aid in research for methods of correcting for misclassification of race in birth certificates in year one only of the project to apply in subsequent years. These would be delivered in Word document explanation; excel spreadsheet (.xlsx); government readable code and data files as needed Final with four drafts maximum.

5.2.3.1. Initial discussion of the issues and methods of natality file racial misclassification adjustment to be demonstrated can be seen in such articles as https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3922476/ and https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10099553/

5.2.4 Note: quarterly special reports on a demographic topic given to the Contractor for measure and brief descriptive narrative; reports would be 4-6 pages long. See the example in 5.2.1.5

5.2.5 Provide Technical Assistance as necessary to the Division of Program Statistics.

5.2.5.1 Questions about the code, what is in it, how it works, what were the algorithms that calculated results.

5.2.5.2 Questions about the meaningfulness or significance of results.

5.2.5.3 Questions from other governmental entities

5.2.5.4 Special code written to answer questions not addressed in earlier programs.

5.3. Data and Code Transfers. Provision of new versions of the code, lookup tables to be used in programming/analysis, and machine and DPS staff readable final and intermediate files will be accomplished through uploads in the Windows secure server and through secure data transfer system emails https://securedata.ihs.gov/bds/Logout.do

5.4. Reporting.

5.4.1. Monthly project status report. The Contractor shall provide a written and verbal monthly report to the COR, including meeting minutes and a summary of technical assistance provided, with a status on all deliverables and projects being worked on, including fund burn rates.

5.4.2. Annual project status report. The Contractor shall provide a written final annual report to the COR, including an aggregate of monthly reports focusing on deliverable content, iterations to complete the deliverable, and successes and challenges related to supporting demographic research and analysis.

5.4.3. Reports for publications. A slide deck and Excel workbooks will be provided to template each report's DPS staff- and machine-readable tables. Due dates are given in Technical Exhibit 1.

5.4.3.1. Note: the two publications of primary interest are Trends in Indian Health and Regional Differences in Indian Health.

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3922476/ https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10099553/ https://securedata.ihs.gov/bds/Logout.do

PART 6

APPLICABLE PUBLICATIONS

6. APPLICABLE PUBLICATIONS (CURRENT EDITIONS)

6.1. The Contractor must abide by all applicable regulations, publications, manuals, and local policies and procedures related to public health demographic research and analysis support. The DPS Publications website contains many documents (samples of all reports mentioned in this SOW) that will be revised with new editions with the work from this Contract at https://www.ihs.gov/dps/publications https://www.ihs.gov/dps/publications

PART 7

ATTACHMENT/TECHNICAL EXHIBIT LISTING

7. Attachment/Technical Exhibit List:

7.1. Attachment 1/Technical Exhibit 1 – Deliverables Schedule

7.2 Attachment 2/Technical Exhibit 2 – Estimated Workload Data

TECHNICAL EXHIBIT 1

DELIVERABLES SCHEDULE

Deliverable Reference Frequency Due Date Duration First year only

Submit To:

Regional Differences in Indian Health, datasets and tables

Datasets:

5.2.1.1, 5.2.1.1.1, 5.2.1.1.2., 5.2.1.1.3, 5.2.1.1.4;

Tables:

5.2.1.3 one per year

28 weeks after date of contract (ADC) 28 weeks DPS, IBC

Trends in Indian Health, datasets and tables

Datasets:

5.2.1.1, 5.2.1.1.1, 5.2.1.1.2., 5.2.1.1.3, 5.2.1.1.4;

Tables:

5.2.1.2 one per year 28 weeks ADC 28 weeks DPS, IBC

Life Expectancy report, datasets and tables

Datasets:

5.2.2, Tables:

5.2.2, 5.2.2.1, and 5.2.1.4 one per year 20 weeks ADC 20 weeks DPS, IBC

YPLL datasets and tables 5.2.1.5 one per year 20 weeks ADC 20 weeks DPS, IBC Exploration, discovery and implementation of direct or indirect standardization methods to correct AI/AN identification and calculation of natality rates

5.1.2, 5.2.1.1.3,

5.2.4 one per year 24 weeks ADC 24 weeks

X (Tables to be used in Regional Differences and Trends items listed above) DPS, IBC

Quarterly special reports as needed on special topics under the direction of the Director, Division of Program Statistics to possibly include analysis of an issue raised by Congress, analysis of currently unreported causes of death, opioid or substance abuse mortality issues, analysis of currently unreported issues related to births, or the calculation of one or several HP 2030 measures by Area. 5.2.1.6 four per year Quarterly

Approximately 13 weeks apart DPS, IBC

Technical assistance/reporting as requested for the Division of Program Statistics 5.2.6 one per month

As needed and requested by the government

Every 4 weeks minimum DPS, IBC

TECHNICAL EXHIBIT 3

ESTIMATED WORKLOAD DATA

ITEM

NAME

ESTIMATED QUANTITY

(Annually)

1 Project Manager Hours 1,040

2 Public Health Demographer Hours 2,080

3 Demographic Statistical Programmer/Analyst Hours 2,080

4 Junior Research Analyst/Administrative Assistant Hours

2,080

ITEM