4.1 Type 1 Table File Lookup Table Parameters

The Type 1 Table File lookup table is required to be specified to produce the Type 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 1 Table File, 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. Table 4.3 contains detailed specifications for the Table File.

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

  • T1: t1cida = Summary of Background Rates
  • T1: t1censor = Summary of Time to End of Observable Data
  • T2: t1censor = Summary of Reasons for End of Observable Data
  • T3: t1censor = Summary of Time to End of Observable Data due to Censor Reason

LEVELNUM specifies the number of level ID variables required in order to produce the table. For example, if LEVELNUM = 1, then the output defined in LEVELID1 is required to be included in the distributed results, but the output defined in LEVELID2 and LEVELID3 is optional and not necessary to output the table. There are two user-specified parameters. To indicate whether to output the corresponding table and strata in the report, user must enter “Y” or “N” for the INCLUDEINREPORT parameter. To select reasons for censoring to output in t1censor table(s), user can specify the CENSORREASON parameter with the censoring reasons of interest—e.g., cens_elig cens_dth cens_dpend cens_qryend. To request output stratified by user-defined categories for categorical variables not previously defined in the Query Request Package (QRP), user can specify the CATEGORIES parameter with the stratification categories of interest—e.g., 1-15 16-30 31-60 61+—for the corresponding table. If output for individual baseline characteristics is to be included in the report, rows in the table below with “covar#”” need to be replaced with rows for each baseline characteristic (covar1, covar2, etc). User can define the order of stratified tables in the report using the Table File. User can also edit TABLESUB parameter in the Table File to specify the order of stratifications in the report.

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). For example, in order to produce the t1censor table, the CENSOR_OUTPUT_CAT parameter in the qrp.Type1File must be specified.

Table 4.3: Type 1 Table File Lookup Table Values for All Tables and Stratifications
table dataset tablesub tablesubstrat levelnum levelid1 levelid2 levelid3 includeinreport censorreason categories
T1 t1cida overall 1 N
t1cida sex 1 sex N
t1cida agegroup 1 agegroup N
t1cida year 1 year N
t1cida year month 1 year month N
t1cida year quarter 1 year quarter N
t1cida race 1 race N
t1cida hispanic 1 hispanic N
t1cida zip3 1 zip3 N
t1cida state 1 state N
t1cida zip_uncertain 1 zip_uncertain N
t1cida cb_reg 1 cb_reg N
t1cida hhs_reg 1 hhs_reg N
t1cida covar# 1 covar# N
t1cida sex agegroup 1 sex agegroup N
t1cida sex agegroup year 1 sex agegroup year N
t1cida sex agegroup year month 1 sex agegroup year month N
t1cida sex agegroup year quarter 1 sex agegroup year quarter N
t1cida agegroup year 1 agegroup year N
t1cida agegroup year month 1 agegroup year month N
t1cida agegroup year quarter 1 agegroup year quarter N
t1cida sex year 1 sex year N
t1cida sex year month 1 sex year month N
t1cida sex year quarter 1 sex year quarter N
t1cida year month agegroup race 1 year month agegroup race N
t1cida year quarter agegroup race 1 year quarter agegroup race N
t1cida year month agegroup Hispanic 1 year month agegroup Hispanic N
t1cida year quarter agegroup Hispanic 1 year quarter agegroup Hispanic N
t1cida year month sex Hispanic 1 year month sex Hispanic N
t1cida year quarter sex Hispanic 1 year quarter sex Hispanic N
t1cida year month sex race 1 year month sex race N
t1cida year quarter sex race 1 year quarter sex race N
t1cida year month Hispanic race 1 year month Hispanic race N
t1cida year quarter Hispanic race 1 year quarter Hispanic race N
t1cida zip3 zip_uncertain 1 zip3 zip_uncertain N
t1cida zip3 sex 1 zip3 sex N
t1cida zip3 sex zip_uncertain 1 zip3 sex zip_uncertain N
t1cida zip3 agegroup 1 zip3 agegroup N
t1cida zip3 agegroup zip_uncertain 1 zip3 agegroup zip_uncertain N
t1cida zip3 year 1 zip3 year N
t1cida zip3 year zip_uncertain 1 zip3 year zip_uncertain N
t1cida zip3 race 1 zip3 race N
t1cida zip3 race zip_uncertain 1 zip3 race zip_uncertain N
t1cida zip3 hispanic 1 zip3 hispanic N
t1cida zip3 hispanic zip_uncertain 1 zip3 hispanic zip_uncertain N
t1cida state zip_uncertain 1 state zip_uncertain N
t1cida state sex 1 state sex N
t1cida state sex zip_uncertain 1 state sex zip_uncertain N
t1cida state agegroup 1 state agegroup N
t1cida state agegroup zip_uncertain 1 state agegroup zip_uncertain N
t1cida state year 1 state year N
t1cida state year zip_uncertain 1 state year zip_uncertain N
t1cida state race 1 state race N
t1cida state race zip_uncertain 1 state race zip_uncertain N
t1cida state hispanic 1 state hispanic N
t1cida state hispanic zip_uncertain 1 state hispanic zip_uncertain N
t1cida zip_uncertain sex 1 zip_uncertain sex N
t1cida zip_uncertain agegroup 1 zip_uncertain agegroup N
t1cida zip_uncertain year 1 zip_uncertain year N
t1cida hhs_reg zip_uncertain 1 hhs_reg zip_uncertain N
t1cida hhs_reg sex 1 hhs_reg sex N
t1cida hhs_reg sex zip_uncertain 1 hhs_reg sex zip_uncertain N
t1cida hhs_reg agegroup 1 hhs_reg agegroup N
t1cida hhs_reg agegroup zip_uncertain 1 hhs_reg agegroup zip_uncertain N
t1cida hhs_reg year 1 hhs_reg year N
t1cida hhs_reg year zip_uncertain 1 hhs_reg year zip_uncertain N
t1cida hhs_reg race 1 hhs_reg race N
t1cida hhs_reg race zip_uncertain 1 hhs_reg race zip_uncertain N
t1cida hhs_reg hispanic 1 hhs_reg hispanic N
t1cida hhs_reg hispanic zip_uncertain 1 hhs_reg hispanic zip_uncertain N
t1cida cb_reg zip_uncertain 1 cb_reg zip_uncertain N
t1cida cb_reg sex 1 cb_reg sex N
t1cida cb_reg sex zip_uncertain 1 cb_reg sex zip_uncertain N
t1cida cb_reg agegroup 1 cb_reg agegroup N
t1cida cb_reg agegroup zip_uncertain 1 cb_reg agegroup zip_uncertain N
t1cida cb_reg year 1 cb_reg year N
t1cida cb_reg year zip_uncertain 1 cb_reg year zip_uncertain N
t1cida cb_reg race 1 cb_reg race N
t1cida cb_reg race zip_uncertain 1 cb_reg race zip_uncertain N
t1cida cb_reg hispanic 1 cb_reg hispanic N
t1cida cb_reg hispanic zip_uncertain 1 cb_reg hispanic zip_uncertain N
t1cida race sex 1 race sex N
t1cida race agegroup 1 race agegroup N
t1cida race year 1 race year N
t1cida race year month 1 race year month N
t1cida race year quarter 1 race year quarter N
t1cida hispanic sex 1 hispanic sex N
t1cida hispanic agegroup 1 hispanic agegroup N
t1cida hispanic year 1 hispanic year N
t1cida hispanic year month 1 hispanic year month N
t1cida hispanic year quarter 1 hispanic year quarter N
t1cida year agegroup race 1 year agegroup race N
t1cida year sex race 1 year sex race N
t1cida year agegroup hispanic 1 year agegroup hispanic N
t1cida year sex hispanic 1 year sex hispanic N
t1cida year race hispanic 1 year race hispanic N
t1cida sex covar# 1 sex covar# N
t1cida agegroup covar# 1 agegroup covar# N
t1cida year covar# 1 year covar# N
t1cida year month covar# 1 year month covar# N
t1cida year quarter covar# 1 year quarter covar# N
t1cida race covar# 1 race covar# N
t1cida hispanic covar# 1 hispanic covar# N
t1cida zip3 covar# 1 zip3 covar# N
t1cida state covar# 1 state covar# N
t1cida zip_uncertain covar# 1 zip_uncertain covar# N
t1cida cb_reg covar# 1 cb_reg covar# N
t1cida hhs_reg covar# 1 hhs_reg covar# N
t1cida sex agegroup covar# 1 sex agegroup covar# N
t1cida sex agegroup year covar# 1 sex agegroup year covar# N
t1cida sex agegroup year month covar# 1 sex agegroup year month covar# N
t1cida sex agegroup year quarter covar# 1 sex agegroup year quarter covar# N
t1cida agegroup year covar# 1 agegroup year covar# N
t1cida agegroup year month covar# 1 agegroup year month covar# N
t1cida agegroup year quarter covar# 1 agegroup year quarter covar# N
t1cida sex year covar# 1 sex year covar# N
t1cida sex year month covar# 1 sex year month covar# N
t1cida sex year quarter covar# 1 sex year quarter covar# N
t1cida year month agegroup race covar# 1 year month agegroup race covar# N
t1cida year quarter agegroup race covar# 1 year quarter agegroup race covar# N
t1cida year month agegroup Hispanic covar# 1 year month agegroup Hispanic covar# N
t1cida year quarter agegroup Hispanic covar# 1 year quarter agegroup Hispanic covar# N
t1cida year month sex Hispanic covar# 1 year month sex Hispanic covar# N
t1cida year quarter sex Hispanic covar# 1 year quarter sex Hispanic covar# N
t1cida year month sex race covar# 1 year month sex race covar# N
t1cida year quarter sex race covar# 1 year quarter sex race covar# N
t1cida year month Hispanic race covar# 1 year month Hispanic race covar# N
t1cida year quarter Hispanic race covar# 1 year quarter Hispanic race covar# N
t1cida zip3 zip_uncertain covar# 1 zip3 zip_uncertain covar# N
t1cida zip3 sex covar# 1 zip3 sex covar# N
t1cida zip3 sex zip_uncertain covar# 1 zip3 sex zip_uncertain covar# N
t1cida zip3 agegroup covar# 1 zip3 agegroup covar# N
t1cida zip3 agegroup zip_uncertain covar# 1 zip3 agegroup zip_uncertain covar# N
t1cida zip3 year covar# 1 zip3 year covar# N
t1cida zip3 year zip_uncertain covar# 1 zip3 year zip_uncertain covar# N
t1cida zip3 race covar# 1 zip3 race covar# N
t1cida zip3 race zip_uncertain covar# 1 zip3 race zip_uncertain covar# N
t1cida zip3 hispanic covar# 1 zip3 hispanic covar# N
t1cida zip3 hispanic zip_uncertain covar# 1 zip3 hispanic zip_uncertain covar# N
t1cida state zip_uncertain covar# 1 state zip_uncertain covar# N
t1cida state sex covar# 1 state sex covar# N
t1cida state sex zip_uncertain covar# 1 state sex zip_uncertain covar# N
t1cida state agegroup covar# 1 state agegroup covar# N
t1cida state agegroup zip_uncertain covar# 1 state agegroup zip_uncertain covar# N
t1cida state year covar# 1 state year covar# N
t1cida state year zip_uncertain covar# 1 state year zip_uncertain covar# N
t1cida state race covar# 1 state race covar# N
t1cida state race zip_uncertain covar# 1 state race zip_uncertain covar# N
t1cida state hispanic covar# 1 state hispanic covar# N
t1cida state hispanic zip_uncertain covar# 1 state hispanic zip_uncertain covar# N
t1cida zip_uncertain sex covar# 1 zip_uncertain sex covar# N
t1cida zip_uncertain agegroup covar# 1 zip_uncertain agegroup covar# N
t1cida zip_uncertain year covar# 1 zip_uncertain year covar# N
t1cida hhs_reg zip_uncertain covar# 1 hhs_reg zip_uncertain covar# N
t1cida hhs_reg sex covar# 1 hhs_reg sex covar# N
t1cida hhs_reg sex zip_uncertain covar# 1 hhs_reg sex zip_uncertain covar# N
t1cida hhs_reg agegroup covar# 1 hhs_reg agegroup covar# N
t1cida hhs_reg agegroup zip_uncertain covar# 1 hhs_reg agegroup zip_uncertain covar# N
t1cida hhs_reg year covar# 1 hhs_reg year covar# N
t1cida hhs_reg year zip_uncertain covar# 1 hhs_reg year zip_uncertain covar# N
t1cida hhs_reg race covar# 1 hhs_reg race covar# N
t1cida hhs_reg race zip_uncertain covar# 1 hhs_reg race zip_uncertain covar# N
t1cida hhs_reg hispanic covar# 1 hhs_reg hispanic covar# N
t1cida hhs_reg hispanic zip_uncertain covar# 1 hhs_reg hispanic zip_uncertain covar# N
t1cida cb_reg zip_uncertain covar# 1 cb_reg zip_uncertain covar# N
t1cida cb_reg sex covar# 1 cb_reg sex covar# N
t1cida cb_reg sex zip_uncertain covar# 1 cb_reg sex zip_uncertain covar# N
t1cida cb_reg agegroup covar# 1 cb_reg agegroup covar# N
t1cida cb_reg agegroup zip_uncertain covar# 1 cb_reg agegroup zip_uncertain covar# N
t1cida cb_reg year covar# 1 cb_reg year covar# N
t1cida cb_reg year zip_uncertain covar# 1 cb_reg year zip_uncertain covar# N
t1cida cb_reg race covar# 1 cb_reg race covar# N
t1cida cb_reg race zip_uncertain covar# 1 cb_reg race zip_uncertain covar# N
t1cida cb_reg hispanic covar# 1 cb_reg hispanic covar# N
t1cida cb_reg hispanic zip_uncertain covar# 1 cb_reg hispanic zip_uncertain covar# N
t1cida race sex covar# 1 race sex covar# N
t1cida race agegroup covar# 1 race agegroup covar# N
t1cida race year covar# 1 race year covar# N
t1cida race year month covar# 1 race year month covar# N
t1cida race year quarter covar# 1 race year quarter covar# N
t1cida hispanic sex covar# 1 hispanic sex covar# N
t1cida hispanic agegroup covar# 1 hispanic agegroup covar# N
t1cida hispanic year covar# 1 hispanic year covar# N
t1cida hispanic year month covar# 1 hispanic year month covar# N
t1cida hispanic year quarter covar# 1 hispanic year quarter covar# N
t1cida year agegroup race covar# 1 year agegroup race covar# N
t1cida year sex race covar# 1 year sex race covar# N
t1cida year agegroup hispanic covar# 1 year agegroup hispanic covar# N
t1cida year sex hispanic covar# 1 year sex hispanic covar# N
t1cida year race hispanic covar# 1 year race hispanic covar# N
t1censor overall 1 censdays_value_cat censdays_value N
t1censor sex 1 sex censdays_value_cat N
t1censor agegroup 1 agegroup censdays_value_cat N
t1censor year 1 year censdays_value_cat N
T2 t1censor overall 1 censdays_value_cat N
t1censor sex 1 sex censdays_value_cat N
t1censor agegroup 1 agegroup censdays_value_cat N
t1censor year 1 year censdays_value_cat N
T3 t1censor overall 1 censdays_value_cat censdays_value N
t1censor sex 1 sex censdays_value_cat N
t1censor agegroup 1 agegroup censdays_value_cat N
t1censor year 1 year censdays_value_cat N