Resource Repository

Purpose: This report checks the current inventory of active VFC providers and indicates if the provider is missing any of the following ACIP-recommended vaccines required to be available in inventory: DTaP, HepA, HepB, HPV, mening, MMR, PCV, polio, rotavirus, ...

Purpose: This report summarizes VFC inventory that has been marked as “wastage” (wasted, spoiled, or expired) within the previous month. Data is summarized by overall wastage by vaccine and by individual provider. Outcome: This script outputs a three-ta...

Purpose: This code produces a report that summarizes the unknown/unrecognized NDC codes submitted by providers via HL7 during the previous week. The report also compares the list of NDC codes captured in the current report to the previous report and counts how...

Purpose: This code provides vaccination coverage rates and data quality metrics by provider, county, and state for different combinations of overlapping age groups. Outcome: The first script in this series will result in a data frame containing columns ind...

Purpose: The purpose of this query is to verify the total number of vaccines for each patient's record. Also can be used for coverage reporting. Outcome: SQL table with columns for patient identifier, patient name, date of birth, and columns representing the ...

Purpose: To create variable to capture if a client/patient received its childhood series by 24 months Outcome: To calculate childhood series immunization coverage rates by 24 months Format: CSV, Tableau Audience: Data analysts

Purpose: To get count of patients Outcome: To get count of patients Format: Single field Audience: IIS staff

Purpose: To include code in query to create aggregate race/ethnicity groups Outcome: To create groups for reporting combined race/ethnicity data Format: CSV Audience: Data analysts