4.3 Type 4 Level 1 Table File Lookup Table Parameters

The Type 4 Level 1 Table File lookup table is required to be specified to produce the Type 4 Level 1 summary tables described on this page. All lookup tables can be found in the Reporting Tool templatefiles folder. The user will download the Reporting Tool, select the Type 4 Level 1 Table File lookup table, and edit the relevant parameters directly in the lookup table.

The Table File is used to specify which tables and corresponding stratifications to produce in the report. The lookup table below is used to map the requested output with the strata level variables necessary to compute the appropriate metrics. Requested strata level variables must be requested in the distributed qrp.USERSTRATA file. Note that only one Table File that includes all requested output should be specified.

Six tables can be requested, as indicated by the TABLE parameter in the Table File:

4.3.1 Tables

  • T1: t4preg = Pregnancy Episodes [and Matched Non-Pregnant Episodes] with [Exposure(s) of Interest]
  • T2: t4preg = [Exposure(s) of Interest] Episodes Among Pregnant [and Matched Non-Pregnant] Cohort[s]
  • T3: t4preg = [Exposure(s) of Interest] Codes Among Pregnant [and Matched Non-Pregnant] Cohort[s], Without Adjusting for Same-Day Dispensings
  • T4: t4preg = [Exposure(s) of Interest] Codes Among Pregnant [and Matched Non-Pregnant] Cohort[s], Adjusting for Same-Day Dispensings
  • T5: t4preggestwk = Pregnancy Episodes [and Matched Non-Pregnant Episodes] with [Exposure(s) of Interest], by Gestational Week
  • T6: t4preggestwk = [Exposure(s) of Interest] Episodes Among Pregnant [and Matched Non-Pregnant] Cohort[s], by Gestational Week
  • T7: t4cida = Summary of Outcomes of Interest Among Prengancy Episodes

LEVELNUM specifies the number of level ID variables required in order to produce the table. For example, if LEVELNUM = 2, then the output defined in LEVELID1 and LEVELID2 is required to be included in the distributed results, but the output defined in LEVELID3 is optional and not necessary to output the table. The INCLUDEINREPORT parameter is the only user-defined variable. Users must enter “Y” or “N” to indicate whether to output the corresponding table and strata in the report. Note that TABLESUBSTRAT = “t4nopreg” or “t4nopreggestwk” allows the user to include a section in the tables for a matched non-pregnant cohort if it was requested in the distributed qrp.USERSTRATA file.

The order of the stratifications in the Table File can be adjusted by the user, and defines the order that the stratified tables will appear in the report. To request output stratified by user-defined categories for categorical variables not previously defined in the Query Request Package (QRP), users can specify the CATEGORIES parameter with the stratification categories of interest (e.g., “1-15 16-30 31-60 61+”) for the corresponding table. Note that in order to produce tables that include stratified output for categorical variables that are previously defined in the QRP, the parameter corresponding to the stratification variable must be specified with user-defined categories in the QRP (rather than using the CATEGORIES parameter).

Table 4.5: Type 4 Look-up Table Values for All Tables and Stratifications
Table Dataset Tablesub Tablesubstrat Levelnum Levelid1 Levelid2 Levelid3 Includeinreport Categories
T1 t4preg overall t4preg 2 moiname N
t4preg overall t4nopreg 2 moiname N
T2 t4preg overall t4preg 2 moiname N
t4preg overall t4nopreg 2 moiname N
T3 t4preg overall t4preg 2 moiname N
t4preg overall t4nopreg 2 moiname N
T4 t4preg overall t4preg 2 moiname N
t4preg overall t4nopreg 2 moiname N
T5 t4preggestwk overall t4preggestwk 1 moiname N
t4preggestwk overall t4nopreggestwk 1 moiname N
T6 t4preggestwk overall t4preggestwk 1 moiname N
t4preggestwk overall t4nopreggestwk 1 moiname N
T7 t4cida overall 1 N
t4cida agegroup 1 agegroup N
t4cida year 1 year N
t4cida year month 1 year month N
t4cida year quarter 1 year quarter N
t4cida race 1 race N
t4cida hispanic 1 hispanic N
t4cida prepostind 1 prepostind N
t4cida zip3 1 zip3 N
t4cida state 1 state N
t4cida zip_uncertain 1 zip_uncertain N
t4cida cb_reg 1 cb_reg N
t4cida hhs_reg 1 hhs_reg N
t4cida covar# 1 covar# N
t4cida agegroup year 1 agegroup year N
t4cida agegroup year month 1 agegroup year month N
t4cida agegroup year quarter 1 agegroup year quarter N
t4cida year month agegroup race 1 year month agegroup race N
t4cida year quarter agegroup race 1 year quarter agegroup race N
t4cida year month agegroup Hispanic 1 year month agegroup Hispanic N
t4cida year quarter agegroup Hispanic 1 year quarter agegroup Hispanic N
t4cida year month Hispanic race 1 year month Hispanic race N
t4cida year quarter Hispanic race 1 year quarter Hispanic race N
t4cida zip3 zip_uncertain 1 zip3 zip_uncertain N
t4cida zip3 prepostind 1 zip3 prepostind N
t4cida zip3 prepostind zip_uncertain 1 zip3 prepostind zip_uncertain N
t4cida zip3 agegroup 1 zip3 agegroup N
t4cida zip3 agegroup zip_uncertain 1 zip3 agegroup zip_uncertain N
t4cida zip3 year 1 zip3 year N
t4cida zip3 year zip_uncertain 1 zip3 year zip_uncertain N
t4cida zip3 race 1 zip3 race N
t4cida zip3 race zip_uncertain 1 zip3 race zip_uncertain N
t4cida zip3 hispanic 1 zip3 hispanic N
t4cida zip3 hispanic zip_uncertain 1 zip3 hispanic zip_uncertain N
t4cida state zip_uncertain 1 state zip_uncertain N
t4cida state prepostind 1 state prepostind N
t4cida state prepostind zip_uncertain 1 state prepostind zip_uncertain N
t4cida state agegroup 1 state agegroup N
t4cida state agegroup zip_uncertain 1 state agegroup zip_uncertain N
t4cida state year 1 state year N
t4cida state year zip_uncertain 1 state year zip_uncertain N
t4cida state race 1 state race N
t4cida state race zip_uncertain 1 state race zip_uncertain N
t4cida state hispanic 1 state hispanic N
t4cida state hispanic zip_uncertain 1 state hispanic zip_uncertain N
t4cida zip_uncertain prepostind 1 zip_uncertain prepostind N
t4cida zip_uncertain agegroup 1 zip_uncertain agegroup N
t4cida zip_uncertain year 1 zip_uncertain year N
t4cida hhs_reg zip_uncertain 1 hhs_reg zip_uncertain N
t4cida hhs_reg prepostind 1 hhs_reg prepostind N
t4cida hhs_reg prepostind zip_uncertain 1 hhs_reg prepostind zip_uncertain N
t4cida hhs_reg agegroup 1 hhs_reg agegroup N
t4cida hhs_reg agegroup zip_uncertain 1 hhs_reg agegroup zip_uncertain N
t4cida hhs_reg year 1 hhs_reg year N
t4cida hhs_reg year zip_uncertain 1 hhs_reg year zip_uncertain N
t4cida hhs_reg race 1 hhs_reg race N
t4cida hhs_reg race zip_uncertain 1 hhs_reg race zip_uncertain N
t4cida hhs_reg hispanic 1 hhs_reg hispanic N
t4cida hhs_reg hispanic zip_uncertain 1 hhs_reg hispanic zip_uncertain N
t4cida cb_reg zip_uncertain 1 cb_reg zip_uncertain N
t4cida cb_reg prepostind 1 cb_reg prepostind N
t4cida cb_reg prepostind zip_uncertain 1 cb_reg prepostind zip_uncertain N
t4cida cb_reg agegroup 1 cb_reg agegroup N
t4cida cb_reg agegroup zip_uncertain 1 cb_reg agegroup zip_uncertain N
t4cida cb_reg year 1 cb_reg year N
t4cida cb_reg year zip_uncertain 1 cb_reg year zip_uncertain N
t4cida cb_reg race 1 cb_reg race N
t4cida cb_reg race zip_uncertain 1 cb_reg race zip_uncertain N
t4cida cb_reg hispanic 1 cb_reg hispanic N
t4cida cb_reg hispanic zip_uncertain 1 cb_reg hispanic zip_uncertain N
t4cida race prepostind 1 race prepostind N
t4cida race agegroup 1 race agegroup N
t4cida race year 1 race year N
t4cida race year month 1 race year month N
t4cida race year quarter 1 race year quarter N
t4cida hispanic agegroup 1 hispanic agegroup N
t4cida hispanic year 1 hispanic year N
t4cida hispanic year month 1 hispanic year month N
t4cida hispanic year quarter 1 hispanic year quarter N
t4cida year race hispanic 1 year race hispanic N
t4cida year agegroup hispanic 1 year agegroup hispanic N
t4cida year agegroup race 1 year agegroup race N
t4cida prepostind agegroup 1 prepostind agegroup N
t4cida prepostind hispanic 1 prepostind hispanic N
t4cida prepostind year 1 prepostind year N
t4cida prepostind year race 1 prepostind year race N
t4cida prepostind year hispanic 1 prepostind year hispanic N
t4cida prepostind agegroup year 1 prepostind agegroup year N
t4cida prepostind year month 1 prepostind year month N
t4cida prepostind year quarter 1 prepostind year quarter N
t4cida agegroup covar# 1 agegroup covar# N
t4cida year covar# 1 year covar# N
t4cida year month covar# 1 year month covar# N
t4cida year quarter covar# 1 year quarter covar# N
t4cida race covar# 1 race covar# N
t4cida hispanic covar# 1 hispanic covar# N
t4cida prepostind covar# 1 prepostind covar# N
t4cida zip3 covar# 1 zip3 covar# N
t4cida state covar# 1 state covar# N
t4cida zip_uncertain covar# 1 zip_uncertain covar# N
t4cida cb_reg covar# 1 cb_reg covar# N
t4cida hhs_reg covar# 1 hhs_reg covar# N
t4cida agegroup year covar# 1 agegroup year covar# N
t4cida agegroup year month covar# 1 agegroup year month covar# N
t4cida agegroup year quarter covar# 1 agegroup year quarter covar# N
t4cida year month agegroup race covar# 1 year month agegroup race covar# N
t4cida year quarter agegroup race covar# 1 year quarter agegroup race covar# N
t4cida year month agegroup Hispanic covar# 1 year month agegroup Hispanic covar# N
t4cida year quarter agegroup Hispanic covar# 1 year quarter agegroup Hispanic covar# N
t4cida year month Hispanic race covar# 1 year month Hispanic race covar# N
t4cida year quarter Hispanic race covar# 1 year quarter Hispanic race covar# N
t4cida zip3 zip_uncertain covar# 1 zip3 zip_uncertain covar# N
t4cida zip3 prepostind covar# 1 zip3 prepostind covar# N
t4cida zip3 prepostind zip_uncertain covar# 1 zip3 prepostind zip_uncertain covar# N
t4cida zip3 agegroup covar# 1 zip3 agegroup covar# N
t4cida zip3 agegroup zip_uncertain covar# 1 zip3 agegroup zip_uncertain covar# N
t4cida zip3 year covar# 1 zip3 year covar# N
t4cida zip3 year zip_uncertain covar# 1 zip3 year zip_uncertain covar# N
t4cida zip3 race covar# 1 zip3 race covar# N
t4cida zip3 race zip_uncertain covar# 1 zip3 race zip_uncertain covar# N
t4cida zip3 hispanic covar# 1 zip3 hispanic covar# N
t4cida zip3 hispanic zip_uncertain covar# 1 zip3 hispanic zip_uncertain covar# N
t4cida state zip_uncertain covar# 1 state zip_uncertain covar# N
t4cida state prepostind covar# 1 state prepostind covar# N
t4cida state prepostind zip_uncertain covar# 1 state prepostind zip_uncertain covar# N
t4cida state agegroup covar# 1 state agegroup covar# N
t4cida state agegroup zip_uncertain covar# 1 state agegroup zip_uncertain covar# N
t4cida state year covar# 1 state year covar# N
t4cida state year zip_uncertain covar# 1 state year zip_uncertain covar# N
t4cida state race covar# 1 state race covar# N
t4cida state race zip_uncertain covar# 1 state race zip_uncertain covar# N
t4cida state hispanic covar# 1 state hispanic covar# N
t4cida state hispanic zip_uncertain covar# 1 state hispanic zip_uncertain covar# N
t4cida zip_uncertain prepostind covar# 1 zip_uncertain prepostind covar# N
t4cida zip_uncertain agegroup covar# 1 zip_uncertain agegroup covar# N
t4cida zip_uncertain year covar# 1 zip_uncertain year covar# N
t4cida hhs_reg zip_uncertain covar# 1 hhs_reg zip_uncertain covar# N
t4cida hhs_reg prepostind covar# 1 hhs_reg prepostind covar# N
t4cida hhs_reg prepostind zip_uncertain covar# 1 hhs_reg prepostind zip_uncertain covar# N
t4cida hhs_reg agegroup covar# 1 hhs_reg agegroup covar# N
t4cida hhs_reg agegroup zip_uncertain covar# 1 hhs_reg agegroup zip_uncertain covar# N
t4cida hhs_reg year covar# 1 hhs_reg year covar# N
t4cida hhs_reg year zip_uncertain covar# 1 hhs_reg year zip_uncertain covar# N
t4cida hhs_reg race covar# 1 hhs_reg race covar# N
t4cida hhs_reg race zip_uncertain covar# 1 hhs_reg race zip_uncertain covar# N
t4cida hhs_reg hispanic covar# 1 hhs_reg hispanic covar# N
t4cida hhs_reg hispanic zip_uncertain covar# 1 hhs_reg hispanic zip_uncertain covar# N
t4cida cb_reg zip_uncertain covar# 1 cb_reg zip_uncertain covar# N
t4cida cb_reg prepostind covar# 1 cb_reg prepostind covar# N
t4cida cb_reg prepostind zip_uncertain covar# 1 cb_reg prepostind zip_uncertain covar# N
t4cida cb_reg agegroup covar# 1 cb_reg agegroup covar# N
t4cida cb_reg agegroup zip_uncertain covar# 1 cb_reg agegroup zip_uncertain covar# N
t4cida cb_reg year covar# 1 cb_reg year covar# N
t4cida cb_reg year zip_uncertain covar# 1 cb_reg year zip_uncertain covar# N
t4cida cb_reg race covar# 1 cb_reg race covar# N
t4cida cb_reg race zip_uncertain covar# 1 cb_reg race zip_uncertain covar# N
t4cida cb_reg hispanic covar# 1 cb_reg hispanic covar# N
t4cida cb_reg hispanic zip_uncertain covar# 1 cb_reg hispanic zip_uncertain covar# N
t4cida race prepostind covar# 1 race prepostind covar# N
t4cida race agegroup covar# 1 race agegroup covar# N
t4cida race year covar# 1 race year covar# N
t4cida race year month covar# 1 race year month covar# N
t4cida race year quarter covar# 1 race year quarter covar# N
t4cida hispanic agegroup covar# 1 hispanic agegroup covar# N
t4cida hispanic year covar# 1 hispanic year covar# N
t4cida hispanic year month covar# 1 hispanic year month covar# N
t4cida hispanic year quarter covar# 1 hispanic year quarter covar# N
t4cida year race hispanic covar# 1 year race hispanic covar# N
t4cida year agegroup hispanic covar# 1 year agegroup hispanic covar# N
t4cida year agegroup race covar# 1 year agegroup race covar# N
t4cida prepostind agegroup covar# 1 prepostind agegroup covar# N
t4cida prepostind hispanic covar# 1 prepostind hispanic covar# N
t4cida prepostind year covar# 1 prepostind year covar# N
t4cida prepostind year race covar# 1 prepostind year race covar# N
t4cida prepostind year hispanic covar# 1 prepostind year hispanic covar# N
t4cida prepostind agegroup year covar# 1 prepostind agegroup year covar# N
t4cida prepostind year month covar# 1 prepostind year month covar# N
t4cida prepostind year quarter covar# 1 prepostind year quarter covar# N