Sentinel Routine Querying Tool Report Documentation
Public
Commits
Andrew Simon authored 2ac75246c11
| 1 1 |  |
| 2 2 | |
| 3 3 | # Sentinel Routine Querying Reporting Tool |
| 4 4 | |
| 5 5 | ## Type 6 Lookup Table Parameters |
| 6 6 | |
| 7 7 | The Type 6 Table File lookup table is required to be specified for a Type 6 analysis. The Table File is used to specify which tables and corresponding stratifications to produce for the output in the report. The Type 6 Figure File lookup table is optional to be specified for a Type 6 analysis. The Figure file is used to specify which figures and corresponding stratifications to produce for the output in the report. The lookup tables below are 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 and one Figure file that include all requested output should be specified. |
| 8 8 | |
| 9 9 | Fourteen tables and three figures can be requested, as indicated by the TABLE parameter in the Table File and the FIGURE parameter in the Figure File: |
| 10 10 | |
| 11 - | 1. T1: Distribution of Cumulative Exposure Duration |
| 12 - | 2. T2: Descriptive Statistics of Cumulative Exposure Duration |
| 13 - | 3. T3: Distribution of First Exposure Episode Duration |
| 14 - | 4. T4: Descriptive Stats of First Exposure Episode Duration |
| 15 - | 5. T5: Distribution of Second and Subsequent Exposure Episode Duration |
| 16 - | 6. T6: Descriptive Stats of Second and Subsequent Exposure Episode Duration |
| 17 - | 7. T7: Distribution of All Exposure Episode Durations |
| 18 - | 8. T8: Descriptive Stats of All Exposure Episode Durations |
| 19 - | 9. T9: Distribution of Days Supplied per Dispensing |
| 20 - | 10. T10: Descriptive Stats of Days Supplied per Dispensing |
| 21 - | 11. T11 Descriptive Stats of Length of First Gap Between Treatment Episodes |
| 22 - | 12. T12: Descriptive Stats of Length of Second and Subsequent Gaps Between Treatment Episodes |
| 23 - | 13. T13: Descriptive Stats of Length of All Gaps Between Treatment Episodes |
| 24 - | 14. T14: Counts of Reason for Censoring, All Episodes and First Episode |
| 25 - | 15. F1: New Users Per Month Post-Study Start + Cumulative New Users Per Month Since Study Start |
| 26 - | 16. F2: Dispensings Per Month Post-Study Start + Cumulative Dispensings Per Month Since Study Start |
| 27 - | 17. F3: Days Supply Per Month Post-Study Start + Cumulative Dispensings Per Month Since Study Start |
| 28 - | 18. F4: Survival Curve for Length of First Treatment Episode |
| 29 - | 19. F5: Survival Curve for one censoring reason by group |
| 11 + | 1. T1: |
| 12 + | 2. T2: |
| 13 + | 3. T3: |
| 14 + | 4. T4: |
| 15 + | 5. T5: |
| 16 + | 6. T6: |
| 17 + | 7. T7: |
| 18 + | 8. T8: |
| 19 + | 9. T9: |
| 20 + | 10. T10: |
| 21 + | 11. T11 |
| 22 + | 12. T12: |
| 23 + | 13. T13: |
| 24 + | 14. T14: |
| 25 + | 15. F1: |
| 26 + | 16. F2: |
| 27 + | 17. F3: |
| 28 + | 18. F4: |
| 29 + | 19. F5: |
| 30 + | 20. F6: |
| 31 + | 21. F7: |
| 30 32 | |
| 31 33 | LEVELNUM specifies the number of level ID variables required in order to produce the table/figure. 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. The INCLUDEINREPORT parameter is the only user-defined variable. Users must enter “Y” or “N” to indicate whether to output the corresponding table/figure and strata in the report. |
| 32 34 | |
| 33 35 | |
| 34 36 | **Table 1: Type 6 Look-up Table Values for All Tables and Stratifications** |
| 35 37 | |
| 36 38 | | Table | Dataset | Tablesub | Tablesubstrat | Levelnum | Levelid1 | Levelid2 | Levelid3 | Includeinreport | |
| 37 39 | |-------|-----------------|-------------------|---------------|----------|------------------------------------|------------------------------|------------------------------|-----------------| |
| 38 40 | | T1 | t6counts | overall | | 3 | | year | month year | | |
| 39 41 | | T1 | t6counts | sex | | 3 | sex | sex year | sex month year | | |