4.4 Type 5 Table File Lookup Table Parameters

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

Twenty-two tables can be requested, as indicated by the TABLE parameter in the Table File. They will be displayed in this order, with censor tables at the end of the report:

  • T1: t5disp = Categorical Summary of Days Supplied per Dispensing
  • T2: t5disp = Continuous Summary of Days Supplied per Dispensing
  • T3: t5episdur = Categorical Summary of Patients’ Cumulative Treatment Episode Durations
  • T4: t5episdur = Continuous Summary of Patients’ Cumulative Treatment Episode Durations
  • T5: t5episdur = Categorical Summary of All Treatment Episodes
  • T6: t5episdur = Continuous Summary of All Treatment Episodes
  • T7: t5episdur = Categorical Summary of First Treatment Episodes
  • T8: t5episdur = Continuous Summary of First Treatment Episodes
  • T9: t5episdur = Categorical Summary of Second and Subsequent Treatment Episodes
  • T10: t5episdur = Continuous Summary of Second and Subsequent Treatment Episodes
  • T11: t5gaps = Continuous Summary of All Treatment Episode Gaps
  • T12: t5gaps = Continuous Summary of First Treatment Episode Gaps
  • T13: t5gaps = Continuous Summary of Second and Subsequent Treatment Episode Gaps
  • T18: t5disp = Summary of Filled Daily Dose in Each Dispensing
  • T19: t5dose = Summary of Average Filled Daily Dose in Each Treatment Episode
  • T20: t5dose = Summary of Average Filled Daily Dose in Each Patient’s First Valid Episode
  • T21: t5dose = Summary of Cumulative Filled Dose in All Treatment Episodes
  • T22: t5dose = Summary of Cumulative Filled Dose in Each Patient’s First Treatment Episode
  • T14: t5censor = Summary of Reasons First Treatment Episodes Ended
  • T15: t5censor = Summary of Episode Duration for First Treatment Episodes Ended due to [CensorReason]
  • T16: t5censor = Summary of Reasons Treatment Episodes Ended
  • T17: t5censor = Summary of Episode Duration for Treatment Episodes Ended due to [CensorReason]

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. If LEVELNUM = 2 than the output defined in LEVELID1 and LEVELID2 is required to be included in the distributed results, however if LEVELNUM = 1, then only output defined in LEVELID1 is required to be included in the distributed results. There are three 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 t5censor 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 first episode durations (t5episdur) and/or all episode durations (t5episdur), 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. 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 t5dose table, the AFDD_OUTPUT_CAT parameter in the QRP Type 5 File must be specified.

Table 4.6: Type 5 Look-up Table Values for All Tables and Stratifications
table dataset tablesub tablesubstrat levelnum levelid1 levelid2 levelid3 includeinreport categories censorreason
T1 t5disp overall 2 daysupp N
t5disp sex 2 sex daysupp sex N
t5disp agegroup 2 agegroup daysupp agegroup N
t5disp race 2 race daysupp race N
t5disp hispanic 2 hispanic daysupp hispanic N
t5disp sex agegroup 2 sex agegroup daysupp sex agegroup N
t5disp sex race 2 sex race daysupp sex race N
t5disp sex hispanic 2 sex hispanic daysupp sex hispanic N
t5disp agegroup race 2 agegroup race daysupp agegroup race N
t5disp agegroup hispanic 2 agegroup hispanic daysupp agegroup hispanic N
T2 t5disp overall 2 daysupp N
t5disp sex 2 sex daysupp sex N
t5disp agegroup 2 agegroup daysupp agegroup N
t5disp race 2 race daysupp race N
t5disp hispanic 2 hispanic daysupp hispanic N
t5disp sex agegroup 2 sex agegroup daysupp sex agegroup N
t5disp sex race 2 sex race daysupp sex race N
t5disp sex hispanic 2 sex hispanic daysupp sex hispanic N
t5disp agegroup race 2 agegroup race daysupp agegroup race N
t5disp agegroup hispanic 2 agegroup hispanic daysupp agegroup hispanic N
T3 t5episdur overall 2 cumepisodelength N
t5episdur sex 2 sex cumepisodelength sex N
t5episdur agegroup 2 agegroup cumepisodelength agegroup N
t5episdur year 2 year cumepisodelength year N
t5episdur year month 2 year month cumepisodelength year month N
t5episdur year quarter 2 year quarter cumepisodelength year quarter N
t5episdur race 2 race cumepisodelength race N
t5episdur hispanic 2 hispanic cumepisodelength hispanic N
t5episdur sex agegroup 2 sex agegroup cumepisodelength sex agegroup N
t5episdur sex race 2 sex race cumepisodelength sex race N
t5episdur sex hispanic 2 sex hispanic cumepisodelength sex hispanic N
t5episdur agegroup race 2 agegroup race cumepisodelength agegroup race N
t5episdur agegroup hispanic 2 agegroup hispanic cumepisodelength agegroup hispanic N
T4 t5episdur overall 2 cumepisodelength N
t5episdur sex 2 sex cumepisodelength sex N
t5episdur agegroup 2 agegroup cumepisodelength agegroup N
t5episdur year 2 year cumepisodelength year N
t5episdur year month 2 year month cumepisodelength year month N
t5episdur year quarter 2 year quarter cumepisodelength year quarter N
t5episdur race 2 race cumepisodelength race N
t5episdur hispanic 2 hispanic cumepisodelength hispanic N
t5episdur sex agegroup 2 sex agegroup cumepisodelength sex agegroup N
t5episdur sex race 2 sex race cumepisodelength sex race N
t5episdur sex hispanic 2 sex hispanic cumepisodelength sex hispanic N
t5episdur agegroup race 2 agegroup race cumepisodelength agegroup race N
t5episdur agegroup hispanic 2 agegroup hispanic cumepisodelength agegroup hispanic N
T5 t5episdur overall 2 episodelength N
t5episdur sex 2 sex episodelength sex N
t5episdur agegroup 2 agegroup episodelength agegroup N
t5episdur year 2 year episodelength year N
t5episdur year month 2 year month episodelength year month N
t5episdur year quarter 2 year quarter episodelength year quarter N
t5episdur race 2 race episodelength race N
t5episdur hispanic 2 hispanic episodelength hispanic N
t5episdur sex agegroup 2 sex agegroup episodelength sex agegroup N
t5episdur sex race 2 sex race episodelength sex race N
t5episdur sex hispanic 2 sex hispanic episodelength sex hispanic N
t5episdur agegroup race 2 agegroup race episodelength agegroup race N
t5episdur agegroup hispanic 2 agegroup hispanic episodelength agegroup hispanic N
T6 t5episdur overall 2 episodelength N
t5episdur sex 2 sex episodelength sex N
t5episdur agegroup 2 agegroup episodelength agegroup N
t5episdur year 2 year episodelength year N
t5episdur year month 2 year month episodelength year month N
t5episdur year quarter 2 year quarter episodelength year quarter N
t5episdur race 2 race episodelength race N
t5episdur hispanic 2 hispanic episodelength hispanic N
t5episdur sex agegroup 2 sex agegroup episodelength sex agegroup N
t5episdur sex race 2 sex race episodelength sex race N
t5episdur sex hispanic 2 sex hispanic episodelength sex hispanic N
t5episdur agegroup race 2 agegroup race episodelength agegroup race N
t5episdur agegroup hispanic 2 agegroup hispanic episodelength agegroup hispanic N
T7 t5episdur overall 2 episodenum episodenum episodelength N
t5episdur sex 2 episodenum sex episodenum episodelength sex N
t5episdur agegroup 2 episodenum agegroup episodenum episodelength agegroup N
t5episdur year 2 episodenum year episodenum episodelength year N
t5episdur year month 2 episodenum year month episodenum episodelength year month N
t5episdur year quarter 2 episodenum year quarter episodenum episodelength year quarter N
t5episdur race 2 episodenum race episodenum episodelength race N
t5episdur hispanic 2 episodenum hispanic episodenum episodelength hispanic N
t5episdur sex agegroup 2 episodenum sex agegroup episodenum episodelength sex agegroup N
t5episdur sex race 2 episodenum sex race episodenum episodelength sex race N
t5episdur sex hispanic 2 episodenum sex hispanic episodenum episodelength sex hispanic N
t5episdur agegroup race 2 episodenum agegroup race episodenum episodelength agegroup race N
t5episdur agegroup hispanic 2 episodenum agegroup hispanic episodenum episodelength agegroup hispanic N
T8 t5episdur overall 2 episodenum episodenum episodelength N
t5episdur sex 2 episodenum sex episodenum episodelength sex N
t5episdur agegroup 2 episodenum agegroup episodenum episodelength agegroup N
t5episdur year 2 episodenum year episodenum episodelength year N
t5episdur year month 2 episodenum year month episodenum episodelength year month N
t5episdur year quarter 2 episodenum year quarter episodenum episodelength year quarter N
t5episdur race 2 episodenum race episodenum episodelength race N
t5episdur hispanic 2 episodenum hispanic episodenum episodelength hispanic N
t5episdur sex agegroup 2 episodenum sex agegroup episodenum episodelength sex agegroup N
t5episdur sex race 2 episodenum sex race episodenum episodelength sex race N
t5episdur sex hispanic 2 episodenum sex hispanic episodenum episodelength sex hispanic N
t5episdur agegroup race 2 episodenum agegroup race episodenum episodelength agegroup race N
t5episdur agegroup hispanic 2 episodenum agegroup hispanic episodenum episodelength agegroup hispanic N
T9 t5episdur overall 2 episodenum episodenum episodelength N
t5episdur sex 2 episodenum sex episodenum episodelength sex N
t5episdur agegroup 2 episodenum agegroup episodenum episodelength agegroup N
t5episdur year 2 episodenum year episodenum episodelength year N
t5episdur year month 2 episodenum year month episodenum episodelength year month N
t5episdur year quarter 2 episodenum year quarter episodenum episodelength year quarter N
t5episdur race 2 episodenum race episodenum episodelength race N
t5episdur hispanic 2 episodenum hispanic episodenum episodelength hispanic N
t5episdur sex agegroup 2 episodenum sex agegroup episodenum episodelength sex agegroup N
t5episdur sex race 2 episodenum sex race episodenum episodelength sex race N
t5episdur sex hispanic 2 episodenum sex hispanic episodenum episodelength sex hispanic N
t5episdur agegroup race 2 episodenum agegroup race episodenum episodelength agegroup race N
t5episdur agegroup hispanic 2 episodenum agegroup hispanic episodenum episodelength agegroup hispanic N
T10 t5episdur overall 2 episodenum episodenum episodelength N
t5episdur sex 2 episodenum sex episodenum episodelength sex N
t5episdur agegroup 2 episodenum agegroup episodenum episodelength agegroup N
t5episdur year 2 episodenum year episodenum episodelength year N
t5episdur year month 2 episodenum year month episodenum episodelength year month N
t5episdur year quarter 2 episodenum year quarter episodenum episodelength year quarter N
t5episdur race 2 episodenum race episodenum episodelength race N
t5episdur hispanic 2 episodenum hispanic episodenum episodelength hispanic N
t5episdur sex agegroup 2 episodenum sex agegroup episodenum episodelength sex agegroup N
t5episdur sex race 2 episodenum sex race episodenum episodelength sex race N
t5episdur sex hispanic 2 episodenum sex hispanic episodenum episodelength sex hispanic N
t5episdur agegroup race 2 episodenum agegroup race episodenum episodelength agegroup race N
t5episdur agegroup hispanic 2 episodenum agegroup hispanic episodenum episodelength agegroup hispanic N
T11 t5gaps overall 2 gapnum gapnum gaplength N
t5gaps sex 2 gapnum sex gapnum gaplength sex N
t5gaps agegroup 2 gapnum agegroup gapnum gaplength agegroup N
t5gaps year 2 gapnum year gapnum gaplength year N
t5gaps year month 2 gapnum year month gapnum gaplength year month N
t5gaps year quarter 2 gapnum year quarter gapnum gaplength year quarter N
t5gaps race 2 gapnum race gapnum gaplength race N
t5gaps hispanic 2 gapnum hispanic gapnum gaplength hispanic N
t5gaps sex agegroup 2 gapnum sex agegroup gapnum gaplength sex agegroup N
t5gaps sex race 2 gapnum sex race gapnum gaplength sex race N
t5gaps sex hispanic 2 gapnum sex hispanic gapnum gaplength sex hispanic N
t5gaps agegroup race 2 gapnum agegroup race gapnum gaplength agegroup race N
t5gaps agegroup hispanic 2 gapnum agegroup hispanic gapnum gaplength agegroup hispanic N
T12 t5gaps overall 2 gapnum gapnum gaplength N
t5gaps sex 2 gapnum sex gapnum gaplength sex N
t5gaps agegroup 2 gapnum agegroup gapnum gaplength agegroup N
t5gaps year 2 gapnum year gapnum gaplength year N
t5gaps year month 2 gapnum year month gapnum gaplength year month N
t5gaps year quarter 2 gapnum year quarter gapnum gaplength year quarter N
t5gaps race 2 gapnum race gapnum gaplength race N
t5gaps hispanic 2 gapnum hispanic gapnum gaplength hispanic N
t5gaps sex agegroup 2 gapnum sex agegroup gapnum gaplength sex agegroup N
t5gaps sex race 2 gapnum sex race gapnum gaplength sex race N
t5gaps sex hispanic 2 gapnum sex hispanic gapnum gaplength sex hispanic N
t5gaps agegroup race 2 gapnum agegroup race gapnum gaplength agegroup race N
t5gaps agegroup hispanic 2 gapnum agegroup hispanic gapnum gaplength agegroup hispanic N
T13 t5gaps overall 2 gapnum gapnum gaplength N
t5gaps sex 2 gapnum sex gapnum gaplength sex N
t5gaps agegroup 2 gapnum agegroup gapnum gaplength agegroup N
t5gaps year 2 gapnum year gapnum gaplength year N
t5gaps year month 2 gapnum year month gapnum gaplength year month N
t5gaps year quarter 2 gapnum year quarter gapnum gaplength year quarter N
t5gaps race 2 gapnum race gapnum gaplength race N
t5gaps hispanic 2 gapnum hispanic gapnum gaplength hispanic N
t5gaps sex agegroup 2 gapnum sex agegroup gapnum gaplength sex agegroup N
t5gaps sex race 2 gapnum sex race gapnum gaplength sex race N
t5gaps sex hispanic 2 gapnum sex hispanic gapnum gaplength sex hispanic N
t5gaps agegroup race 2 gapnum agegroup race gapnum gaplength agegroup race N
t5gaps agegroup hispanic 2 gapnum agegroup hispanic gapnum gaplength agegroup hispanic N
T14 t5censor overall 1 episodenum N
T15 t5censor overall 1 episodenum episodelength N
T16 t5censor overall 1 N
T17 t5censor overall 2 episodelength N
T18 t5disp overall 2 cfdd_output_cat cfdd N
t5disp sex 2 sex cfdd_output_cat sex N
t5disp agegroup 2 agegroup cfdd_output_cat agegroup N
t5disp race 2 race cfdd_output_cat race N
t5disp hispanic 2 hispanic cfdd_output_cat hispanic N
t5disp sex agegroup 2 sex agegroup cfdd_output_cat sex agegroup N
t5disp sex race 2 sex race cfdd_output_cat sex race N
t5disp sex hispanic 2 sex hispanic cfdd_output_cat sex hispanic N
t5disp agegroup race 2 agegroup race cfdd_output_cat agegroup race N
t5disp agegroup hispanic 2 agegroup hispanic cfdd_output_cat agegroup hispanic N
T19 t5dose overall 2 afdd_output_cat afdd N
t5dose sex 2 sex afdd_output_cat sex N
t5dose agegroup 2 agegroup afdd_output_cat agegroup N
t5dose year 2 year afdd_output_cat year N
t5dose year month 2 year month afdd_output_cat year month N
t5dose year quarter 2 year quarter afdd_output_cat year quarter N
t5dose race 2 race afdd_output_cat race N
t5dose hispanic 2 hispanic afdd_output_cat hispanic N
t5dose sex agegroup 2 sex agegroup afdd_output_cat sex agegroup N
t5dose sex race 2 sex race afdd_output_cat sex race N
t5dose sex hispanic 2 sex hispanic afdd_output_cat sex hispanic N
t5dose agegroup race 2 agegroup race afdd_output_cat agegroup race N
t5dose agegroup hispanic 2 agegroup hispanic afdd_output_cat agegroup hispanic N
T20 t5dose overall 2 episodenum afdd_output_cat episodenum afdd episodenum N
t5dose sex 2 episodenum sex afdd_output_cat episodenum sex N
t5dose agegroup 2 episodenum agegroup afdd_output_cat episodenum agegroup N
t5dose year 2 year afdd_output_cat year N
t5dose year month 2 year month afdd_output_cat year month N
t5dose year quarter 2 year quarter afdd_output_cat year quarter N
t5dose race 2 episodenum race afdd_output_cat episodenum race N
t5dose hispanic 2 episodenum hispanic afdd_output_cat episodenum hispanic N
t5dose sex agegroup 2 episodenum sex agegroup afdd_output_cat episodenum sex agegroup N
t5dose sex race 2 episodenum sex race afdd_output_cat episodenum sex race N
t5dose sex hispanic 2 episodenum sex hispanic afdd_output_cat episodenum sex hispanic N
t5dose agegroup race 2 episodenum agegroup race afdd_output_cat episodenum agegroup race N
t5dose agegroup hispanic 2 episodenum agegroup hispanic afdd_output_cat episodenum agegroup hispanic N
T21 t5dose overall 2 cumdose_output_cat cumdose N
t5dose sex 2 sex cumdose_output_cat sex N
t5dose agegroup 2 agegroup cumdose_output_cat agegroup N
t5dose year 2 year cumdose_output_cat year N
t5dose year month 2 year month cumdose_output_cat year month N
t5dose year quarter 2 year quarter cumdose_output_cat year quarter N
t5dose race 2 race cumdose_output_cat race N
t5dose hispanic 2 hispanic cumdose_output_cat hispanic N
t5dose sex agegroup 2 sex agegroup cumdose_output_cat sex agegroup N
t5dose sex race 2 sex race cumdose_output_cat sex race N
t5dose sex hispanic 2 sex hispanic cumdose_output_cat sex hispanic N
t5dose agegroup race 2 agegroup race cumdose_output_cat agegroup race N
t5dose agegroup hispanic 2 agegroup hispanic cumdose_output_cat agegroup hispanic N
T22 t5dose overall 2 episodenum cumdose_output_cat episodenum cumdose episodenum N
t5dose sex 2 episodenum sex cumdose_output_cat episodenum sex N
t5dose agegroup 2 episodenum agegroup cumdose_output_cat episodenum agegroup N
t5dose year 2 year cumdose_output_cat year N
t5dose year month 2 year month cumdose_output_cat year month N
t5dose year quarter 2 year quarter cumdose_output_cat year quarter N
t5dose race 2 episodenum race cumdose_output_cat episodenum race N
t5dose hispanic 2 episodenum hispanic cumdose_output_cat episodenum hispanic N
t5dose sex agegroup 2 episodenum sex agegroup cumdose_output_cat episodenum sex agegroup N
t5dose sex race 2 episodenum sex race cumdose_output_cat episodenum sex race N
t5dose sex hispanic 2 episodenum sex hispanic cumdose_output_cat episodenum sex hispanic N
t5dose agegroup race 2 episodenum agegroup race cumdose_output_cat episodenum agegroup race N
t5dose agegroup hispanic 2 episodenum agegroup hispanic cumdose_output_cat episodenum agegroup hispanic N