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: 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

Purpose: To help calculate the order of the doses given by an ID, vaccine group name, and their vaccination date Outcome: To display a list of IDs by the vaccine group and with the order of doses by vaccination date Format: Tableau table or calculated field ...