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