4.5 Type 6 Table File Lookup Table Parameters

The Type 6 Table File lookup table is required to be specified to produce the Type 6 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 6 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 [User-defined Strata Levels Look-up file]. Note that only one Table File that included all requested output should be specified. Table 4.7 contains detailed specifications for the Table File.

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

  • T1 (Not yet functional): t6counts = Number Of New Users Over Time, By Month-Year
  • T2 (Not yet functional): t6counts = Number Of Overall Users Over Time, By Month-Year
  • T3 (Not yet functional): t6trend = Number Of Overall Users Over Time Of Episode Span, By Month-Year
  • T4 (Not yet functional): t6counts = Number Of Dispensings Over Time, By Month-Year
  • T5 (Not yet functional): t6disp = Descriptive Statistics Of Days Supplied Per Dispensing
  • T6 (Not yet functional): t6episdur = Descriptive Statistics Of Cumulative Exposure Duration
  • T7 (Not yet functional): t6uptake = Descriptive Statistics Of Time To Product Uptake
  • T8: t6censor = Summary of Episode Duration by Reason Episodes Ended
  • T9: t6plota = Summary of Time to First Switch or Episode End
  • T10: t6plotb = Summary of Time to Second Switch or Episode End
  • T11 (Not yet functional): t6switchepisdur = Descriptive Statistics Of Switch Pattern Episode Duration
  • T12 (Not yet functional): t6plota = Frequency Distribution Of Time To First Switch
  • T13 (Not yet functional): t6plotb = Frequency Distribution Of Time To Second Switch
  • T14 (Not yet functional): t6plota = Descriptive Statistics Of Time To First Switch
  • T15 (Not yet functional): t6plotb = Descriptive Statistics Of Time To Second Switch

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 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 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 T8, T9, and/or T10, 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. 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.

Table 4.7: Type 6 Look-up Table Values for All Tables and Stratifications
table dataset tablesub tablesubstrat levelnum levelid1 levelid2 levelid3 includeinreport censorreason categories
T1 t6counts overall 3 year month year N
T1 t6counts sex 3 sex sex year sex month year N
T1 t6counts agegroup 3 agegroup agegroup year agegroup month year N
T1 t6counts race 3 race race year race month year N
T1 t6counts hispanic 3 hispanic hispanic year hispanic month year N
T1 t6counts sex agegroup 3 sex agegroup sex agegroup year sex agegroup month year N
T1 t6counts sex race 3 sex race sex race year sex race month year N
T1 t6counts sex hispanic 3 sex hispanic sex hispanic year sex hispanic month year N
T1 t6counts agegroup race 3 agegroup race agegroup race year agegroup race month year N
T1 t6counts agegroup hispanic 3 agegroup hispanic agegroup hispanic year agegroup hispanic month year N
T2 t6counts overall 3 year month year N
T2 t6counts sex 3 sex sex year sex month year N
T2 t6counts agegroup 3 agegroup agegroup year agegroup month year N
T2 t6counts race 3 race race year race month year N
T2 t6counts hispanic 3 hispanic hispanic year hispanic month year N
T2 t6counts sex agegroup 3 sex agegroup sex agegroup year sex agegroup month year N
T2 t6counts sex race 3 sex race sex race year sex race month year N
T2 t6counts sex hispanic 3 sex hispanic sex hispanic year sex hispanic month year N
T2 t6counts agegroup race 3 agegroup race agegroup race year agegroup race month year N
T2 t6counts agegroup hispanic 3 agegroup hispanic agegroup hispanic year agegroup hispanic month year N
T3 t6trend overall 2 year month year N
T3 t6trend sex 2 sex year sex month year N
T3 t6trend agegroup 2 agegroup year agegroup month year N
T3 t6trend race 2 race year race month year N
T3 t6trend hispanic 2 hispanic year hispanic month year N
T3 t6trend sex agegroup 2 sex agegroup year sex agegroup month year N
T3 t6trend sex race 2 sex race year sex race month year N
T3 t6trend sex hispanic 2 sex hispanic year sex hispanic month year N
T3 t6trend agegroup race 2 agegroup race year agegroup race month year N
T3 t6trend agegroup hispanic 2 agegroup hispanic year agegroup hispanic month year N
T4 t6counts overall 3 year month year N
T4 t6counts sex 3 sex sex year sex month year N
T4 t6counts agegroup 3 agegroup agegroup year agegroup month year N
T4 t6counts race 3 race race year race month year N
T4 t6counts hispanic 3 hispanic hispanic year hispanic month year N
T4 t6counts sex agegroup 3 sex agegroup sex agegroup year sex agegroup month year N
T4 t6counts sex race 3 sex race sex race year sex race month year N
T4 t6counts sex hispanic 3 sex hispanic sex hispanic year sex hispanic month year N
T4 t6counts agegroup race 3 agegroup race agegroup race year agegroup race month year N
T4 t6counts agegroup hispanic 3 agegroup hispanic agegroup hispanic year agegroup hispanic month year N
T5 t6disp overall 1 daysupp N
T5 t6disp sex 1 sex daysupp N
T5 t6disp agegroup 1 agegroup daysupp N
T5 t6disp race 1 race daysupp N
T5 t6disp hispanic 1 hispanic daysupp N
T5 t6disp sex agegroup 1 sex agegroup daysupp N
T5 t6disp sex race 1 sex race daysupp N
T5 t6disp sex hispanic 1 sex hispanic daysupp N
T5 t6disp agegroup race 1 agegroup race daysupp N
T5 t6disp agegroup hispanic 1 agegroup hispanic daysupp N
T6 t6episdur overall 1 cumepisodelength N
T6 t6episdur sex 1 sex cumepisodelength N
T6 t6episdur agegroup 1 agegroup cumepisodelength N
T6 t6episdur race 1 race cumepisodelength N
T6 t6episdur hispanic 1 hispanic cumepisodelength N
T6 t6episdur sex agegroup 1 sex agegroup cumepisodelength N
T6 t6episdur sex race 1 sex race cumepisodelength N
T6 t6episdur sex hispanic 1 sex hispanic cumepisodelength N
T6 t6episdur agegroup race 1 agegroup race cumepisodelength N
T6 t6episdur agegroup hispanic 1 agegroup hispanic cumepisodelength N
T7 t6uptake overall 1 uptakedays N
T7 t6uptake sex 1 sex uptakedays N
T7 t6uptake agegroup 1 agegroup uptakedays N
T7 t6uptake race 1 race uptakedays N
T7 t6uptake hispanic 1 hispanic uptakedays N
T7 t6uptake sex agegroup 1 sex agegroup uptakedays N
T7 t6uptake sex race 1 sex race uptakedays N
T7 t6uptake sex hispanic 1 sex hispanic uptakedays N
T7 t6uptake agegroup race 1 agegroup race uptakedays N
T7 t6uptake agegroup hispanic 1 agegroup hispanic uptakedays N
T8 t6censor overall 1 episodelength N
T9 t6plota overall 1 ttswitch N
T10 t6plotb overall 1 ttswitch N
T11 T6switchepisdur overall 1 episodelength N
T11 T6switchepisdur sex 1 sex episodelength N
T11 T6switchepisdur agegroup 1 agegroup episodelength N
T11 T6switchepisdur race 1 race episodelength N
T11 T6switchepisdur hispanic 1 hispanic episodelength N
T11 T6switchepisdur sex agegroup 1 sex agegroup episodelength N
T11 T6switchepisdur sex race 1 sex race episodelength N
T11 T6switchepisdur sex hispanic 1 sex hispanic episodelength N
T11 T6switchepisdur agegroup race 1 agegroup race episodelength N
T11 T6switchepisdur agegroup hispanic 1 agegroup hispanic episodelength N
T12 t6plota overall 2 ttswitch N
T12 t6plota sex 2 sex sex ttswitch N
T12 t6plota agegroup 2 agegroup agegroup ttswitch N
T12 t6plota race 2 race race ttswitch N
T12 t6plota hispanic 2 hispanic hispanic ttswitch N
T12 t6plota sex agegroup 2 sex agegroup sex agegroup ttswitch N
T12 t6plota sex race 2 sex race sex race ttswitch N
T12 t6plota sex hispanic 2 sex hispanic sex hispanic ttswitch N
T12 t6plota agegroup race 2 agegroup race agegroup race ttswitch N
T12 t6plota agegroup hispanic 2 agegroup hispanic agegroup hispanic ttswitch N
T13 t6plotb overall 2 ttswitch N
T13 t6plotb sex 2 sex sex ttswitch N
T13 t6plotb agegroup 2 agegroup agegroup ttswitch N
T13 t6plotb race 2 race race ttswitch N
T13 t6plotb hispanic 2 hispanic hispanic ttswitch N
T13 t6plotb sex agegroup 2 sex agegroup sex agegroup ttswitch N
T13 t6plotb sex race 2 sex race sex race ttswitch N
T13 t6plotb sex hispanic 2 sex hispanic sex hispanic ttswitch N
T13 t6plotb agegroup race 2 agegroup race agegroup race ttswitch N
T13 t6plotb agegroup hispanic 2 agegroup hispanic agegroup hispanic ttswitch N
T14 t6plota overall 2 ttswitch N
T14 t6plota sex 2 sex sex ttswitch N
T14 t6plota agegroup 2 agegroup agegroup ttswitch N
T14 t6plota race 2 race race ttswitch N
T14 t6plota hispanic 2 hispanic hispanic ttswitch N
T14 t6plota sex agegroup 2 sex agegroup sex agegroup ttswitch N
T14 t6plota sex race 2 sex race sex race ttswitch N
T14 t6plota sex hispanic 2 sex hispanic sex hispanic ttswitch N
T14 t6plota agegroup race 2 agegroup race agegroup race ttswitch N
T14 t6plota agegroup hispanic 2 agegroup hispanic agegroup hispanic ttswitch N
T15 t6plotb overall 2 ttswitch N
T15 t6plotb sex 2 sex sex ttswitch N
T15 t6plotb agegroup 2 agegroup agegroup ttswitch N
T15 t6plotb race 2 race race ttswitch N
T15 t6plotb hispanic 2 hispanic hispanic ttswitch N
T15 t6plotb sex agegroup 2 sex agegroup sex agegroup ttswitch N
T15 t6plotb sex race 2 sex race sex race ttswitch N
T15 t6plotb sex hispanic 2 sex hispanic sex hispanic ttswitch N
T15 t6plotb agegroup race 2 agegroup race agegroup race ttswitch N
T15 t6plotb agegroup hispanic 2 agegroup hispanic agegroup hispanic ttswitch N