Sentinel Routine Querying Tool Report Documentation
Public
Source
xxxxxxxxxx| t2conc | AmtSupp | Amount Supplied | 6 | N | comma10.0 | 0.67 | Y || t2conc | Eps_wEvents | New Episodes with an Event | 7 | N | comma10.0 | 0.67 | Y || t2conc | All_Events | All Events | 8 | N | comma10.0 | 0.67 | Y || t2conc | followuptime | Days At Risk | 9 | N | comma10.0 | 0.67 | Y || t2conc | followuptime/365.25 | Years at Risk | 10 | N | comma13.1 | 0.82 | Y |<br>**Table 3. tablecolumns_all File**| Table | IncludeinReport | Column | Order | ColumnLabel | ColumnFormat | CIrate ||--------|-----------------|---------------------------------------|-------|-----------------------------------------------------------------------------------|--------------|--------|| t1cida | N | Npts | 1 | New Users | comma10.0 | N || t1cida | N | (Npts/DenNumPts)*X | 2 | New Users per X Eligible Members | comma13.2 | N || t1cida | N | npts/dennumpts | 3 | Proportion of New Users per Eligible Member (95% Confidence Interval) | comma13.2 | P || t1cida | N | (npts/dennumpts)*X | 4 | Proportion of New Users per X Eligible Members (95% Confidence Interval) | comma13.2 | P || t1cida | N | Episodes | 5 | New Episodes | comma10.0 | N || t1cida | N | npts/dennummemdays | 6 | New User Rate per Eligible Person-Day (95% Confidence Interval) | comma13.2 | R || t1cida | N | (npts/dennummemdays)*X | 7 | New User Rate per X Eligible Person-Days (95% Confidence Interval) | comma13.2 | R || t1cida | N | AdjustedCodeCount | 8 | Adjusted Dispensings | comma10.0 | N || t1cida | N | AdjustedCodeCount/Npts | 9 | Adjusted Dispensing per User | comma13.2 | N || t1cida | N | RawCodeCount | 10 | Raw Dispensings | comma10.0 | N || t1cida | N | RawCodeCount/Npts | 11 | Raw Dispensings per User | comma13.2 | N || t1cida | N | DaySupp | 12 | Days Supplied | comma10.0 | N || t1cida | N | DaySupp/Episodes | 13 | Days Supplied per Episode | comma13.2 | N || t1cida | N | DaySupp/Npts | 14 | Days Supplied per User | comma13.2 | N || t1cida | N | DaySupp/AdjustedCodeCount | 15 | Days Supplied per Adjusted Dispensings | comma13.2 | N || t1cida | N | DaySupp/RawCodeCount | 16 | Days Supplied per Raw Dispensings | comma13.2 | N || t1cida | N | AmtSupp | 17 | Amount Supplied | comma10.0 | N || t1cida | N | AmtSupp/Episodes | 18 | Amount Supplied per Episode | comma13.2 | N || t1cida | N | AmtSupp/AdjustedCodeCount | 19 | Amount Supplied per Adjusted Dispensings | comma13.2 | N || t1cida | N | AmtSupp/RawCodeCount | 20 | Amount Supplied per Raw Dispensings | comma13.2 | N || t1cida | N | timetocensor | 21 | Time to Data End (Days) | comma13.0 | N || t1cida | N | DenNumPts | 22 | Eligible Members | comma10.0 | N || t1cida | N | DenNumMemDays | 23 | Eligible Member-Days | comma14.0 | N || t1cida | N | DenNumMemDays/365.25 | 24 | Eligible Member-Years | comma13.1 | N || t2cida | N | Npts | 1 | New Users | comma10.0 | N || t2cida | N | (Npts/DenNumPts)*X | 2 | New Users per X Eligible Members | comma13.2 | N || t2cida | N | Episodes | 3 | New Episodes | comma10.0 | N || t2cida | N | AdjustedCodeCount | 4 | Adjusted Dispensings | comma10.0 | N || t2cida | N | AdjustedCodeCount/Npts | 5 | Adjusted Dispensing per User | comma13.2 | N || t2cida | N | RawCodeCount | 6 | Raw Dispensings | comma10.0 | N || t2cida | N | RawCodeCount/Npts | 7 | Raw Dispensings per User | comma13.2 | N || t2cida | N | DaySupp | 8 | Days Supplied | comma10.0 | N || t2cida | N | DaySupp/Episodes | 9 | Days Supplied per Episode | comma13.2 | N || t2cida | N | DaySupp/Npts | 10 | Days Supplied per User | comma13.2 | N || t2cida | N | DaySupp/AdjustedCodeCount | 11 | Days Supplied per Adjusted Dispensings | comma13.2 | N || t2cida | N | DaySupp/RawCodeCount | 12 | Days Supplied per Raw Dispensings | comma13.2 | N || t2cida | N | AmtSupp | 13 | Amount Supplied | comma10.0 | N || t2cida | N | AmtSupp/Episodes | 14 | Amount Supplied per Episode | comma13.2 | N || t2cida | N | AmtSupp/AdjustedCodeCount | 15 | Amount Supplied per Adjusted Dispensings | comma13.2 | N || t2cida | N | AmtSupp/RawCodeCount | 16 | Amount Supplied per Raw Dispensings | comma13.2 | N || t2cida | N | Eps_wEvents | 17 | New Episodes with an Event | comma10.0 | N || t2cida | N | Eps_wEvents/Npts | 18 | Episodes with an Event per User | comma13.2 | N || t2cida | N | Eps_wEvents/Episodes | 19 | Episodes with an Event per Episode | comma13.2 | N || t2cida | N | Eps_wEvents/(followuptime/365.25) | 20 | Episodes with an Event per Member-Year at Risk | comma13.2 | N || t2cida | N | (Eps_wEvents/(followuptime/365.25))*X | 21 | Episodes with an Event per X Member-Years at Risk | comma13.2 | N || t2cida | N | eps_wevents/followuptime | 22 | Event Rate per Person-Day (95% Confidence Interval) | comma13.2 | R || t2cida | N | eps_wevents/(followuptime/30.35) | 23 | Event Rate per Person-Month (95% Confidence Interval) | comma13.2 | R || t2cida | N | eps_wevents/(followuptime/365.25) | 24 | Event Rate per Person-Year (95% Confidence Interval) | comma13.2 | R || t2cida | N | (eps_wevents/followuptime)*X | 25 | Event Rate per X Person-Days (95% Confidence Interval) | comma13.2 | R || t2cida | N | (eps_wevents/(followuptime/30.35))*X | 26 | Event Rate per X Person-Months (95% Confidence Interval) | comma13.2 | R || t2cida | N | (eps_wevents/(followuptime/365.25))*X | 27 | Event Rate per X Person-Years (95% Confidence Interval) | comma13.2 | R || t2cida | N | (Eps_wEvents/DenNumPts)*X | 28 | Episodes with an Event per X Eligible Members | comma13.2 | N || t2cida | N | eps_wevents/episodes | 29 | Proportion of Episodes with an Event (95% Confidence Interval) | comma13.2 | P || t2cida | N | (eps_wevents/episodes)*X | 30 | Proportion of Episodes with an Event per X New Episodes (95% Confidence Interval) | comma13.2 | P || t2cida | N | All_Events | 31 | All Events | comma10.0 | N || t2cida | N | followuptime | 32 | Days at Risk | comma10.0 | N || t2cida | N | followuptime/365.25 | 33 | Years at Risk | comma13.1 | N || t2cida | N | timetocensor | 34 | Time to Data End (Days) | comma13.0 | N || t2cida | N | DenNumPts | 35 | Eligible Members | comma10.0 | N || t2cida | N | DenNumMemDays | 36 | Eligible Member-Days | comma14.0 | N || t2cida | N | DenNumMemDays/365.25 | 37 | Eligible Member-Years | comma13.1 | N || t2conc | N | Npts | 1 | New Users | comma10.0 | N || t2conc | N | Episodes | 2 | New Episodes | comma10.0 | N || t2conc | N | AdjustedCodeCount | 3 | Adjusted Dispensings | comma10.0 | N || t2conc | N | AdjustedCodeCount/Npts | 4 | Adjusted Dispensing per User | comma13.2 | N || t2conc | N | RawCodeCount | 5 | Raw Dispensings | comma10.0 | N || t2conc | N | RawCodeCount/Npts | 6 | Raw Dispensings per User | comma13.2 | N || t2conc | N | DaySupp | 7 | Days Supplied | comma10.0 | N || t2conc | N | DaySupp/Episodes | 8 | Days Supplied per Episode | comma13.2 | N || t2conc | N | DaySupp/Npts | 9 | Days Supplied per User | comma13.2 | N || t2conc | N | DaySupp/AdjustedCodeCount | 10 | Days Supplied per Adjusted Dispensings | comma13.2 | N || t2conc | N | DaySupp/RawCodeCount | 11 | Days Supplied per Raw Dispensings | comma13.2 | N || t2conc | N | AmtSupp | 12 | Amount Supplied | comma10.0 | N || t2conc | N | AmtSupp/Episodes | 13 | Amount Supplied per Episode | comma13.2 | N || t2conc | N | AmtSupp/AdjustedCodeCount | 14 | Amount Supplied per Adjusted Dispensings | comma13.2 | N || t2conc | N | AmtSupp/RawCodeCount | 15 | Amount Supplied per Raw Dispensings | comma13.2 | N || t2conc | N | Eps_wEvents | 16 | New Episodes with an Event | comma10.0 | N || t2conc | N | Eps_wEvents/Npts | 17 | Episodes with an Event per User | comma13.2 | N || t2conc | N | Eps_wEvents/Episodes | 18 | Episodes with an Event per Episode | comma13.2 | N || t2conc | N | Eps_wEvents/(followuptime/365.25) | 19 | Episodes with an Event per Member-Year at Risk | comma13.2 | N || t2conc | N | (Eps_wEvents/(followuptime/365.25))*X | 20 | Episodes with an Event per X Member-Years at Risk | comma13.2 | N || t2conc | N | eps_wevents/followuptime | 21 | Event Rate per Person-Day (95% Confidence Interval) | comma13.2 | R || t2conc | N | eps_wevents/(followuptime/30.35) | 22 | Event Rate per Person-Month (95% Confidence Interval) | comma13.2 | R || t2conc | N | eps_wevents/(followuptime/365.25) | 23 | Event Rate per Person-Year (95% Confidence Interval) | comma13.2 | R || t2conc | N | (eps_wevents/followuptime)*X | 24 | Event Rate per X Person-Days (95% Confidence Interval) | comma13.2 | R || t2conc | N | (eps_wevents/(followuptime/30.35))*X | 25 | Event Rate per X Person-Months (95% Confidence Interval) | comma13.2 | R || t2conc | N | (eps_wevents/(followuptime/365.25))*X | 26 | Event Rate per X Person-Years (95% Confidence Interval) | comma13.2 | R || t2conc | N | eps_wevents/episodes | 27 | Proportion of Episodes with an Event (95% Confidence Interval) | comma13.2 | P || t2conc | N | (eps_wevents/episodes)*X | 28 | Proportion of Episodes with an Event per X New Episodes (95% Confidence Interval) | comma13.2 | P || t2conc | N | All_Events | 29 | All Events | comma10.0 | N || t2conc | N | followuptime | 30 | Days at Risk | comma10.0 | N || t2conc | N | followuptime/365.25 | 31 | Years at Risk | comma13.1 | N || Table | Column | ColumnLabel | Order | CIrate | ColumnFormat | IncludeinReport ||--------|---------------------------------------|-----------------------------------------------------------------------------------|-------|--------|--------------|-----------------|| t1cida | Npts | New Users | 1 | N | comma10.0 | N || t1cida | (Npts/DenNumPts)*X | New Users per X Eligible Members | 2 | N | comma13.2 | N || t1cida | npts/dennumpts | Proportion of New Users per Eligible Member (95% Confidence Interval) | 3 | P | comma13.2 | N || t1cida | (npts/dennumpts)*X | Proportion of New Users per X Eligible Members (95% Confidence Interval) | 4 | P | comma13.2 | N || t1cida | Episodes | New Episodes | 5 | N | comma10.0 | N || t1cida | npts/dennummemdays | New User Rate per Eligible Person-Day (95% Confidence Interval) | 6 | R | comma13.2 | N || t1cida | (npts/dennummemdays)*X | New User Rate per X Eligible Person-Days (95% Confidence Interval) | 7 | R | comma13.2 | N || t1cida | AdjustedCodeCount | Adjusted Dispensings | 8 | N | comma10.0 | N || t1cida | AdjustedCodeCount/Npts | Adjusted Dispensing per User | 9 | N | comma13.2 | N || t1cida | RawCodeCount | Raw Dispensings | 10 | N | comma10.0 | N || t1cida | RawCodeCount/Npts | Raw Dispensings per User | 11 | N | comma13.2 | N || t1cida | DaySupp | Days Supplied | 12 | N | comma10.0 | N || t1cida | DaySupp/Episodes | Days Supplied per Episode | 13 | N | comma13.2 | N || t1cida | DaySupp/Npts | Days Supplied per User | 14 | N | comma13.2 | N || t1cida | DaySupp/AdjustedCodeCount | Days Supplied per Adjusted Dispensings | 15 | N | comma13.2 | N || t1cida | DaySupp/RawCodeCount | Days Supplied per Raw Dispensings | 16 | N | comma13.2 | N || t1cida | AmtSupp | Amount Supplied | 17 | N | comma10.0 | N || t1cida | AmtSupp/Episodes | Amount Supplied per Episode | 18 | N | comma13.2 | N || t1cida | AmtSupp/AdjustedCodeCount | Amount Supplied per Adjusted Dispensings | 19 | N | comma13.2 | N || t1cida | AmtSupp/RawCodeCount | Amount Supplied per Raw Dispensings | 20 | N | comma13.2 | N || t1cida | timetocensor | Time to Data End (Days) | 21 | N | comma13.0 | N || t1cida | DenNumPts | Eligible Members | 22 | N | comma10.0 | N || t1cida | DenNumMemDays | Eligible Member-Days | 23 | N | comma14.0 | N || t1cida | DenNumMemDays/365.25 | Eligible Member-Years | 24 | N | comma13.1 | N || t2cida | Npts | New Users | 1 | N | comma10.0 | N || t2cida | (Npts/DenNumPts)*X | New Users per X Eligible Members | 2 | N | comma13.2 | N || t2cida | Episodes | New Episodes | 3 | N | comma10.0 | N || t2cida | AdjustedCodeCount | Adjusted Dispensings | 4 | N | comma10.0 | N || t2cida | AdjustedCodeCount/Npts | Adjusted Dispensing per User | 5 | N | comma13.2 | N || t2cida | RawCodeCount | Raw Dispensings | 6 | N | comma10.0 | N || t2cida | RawCodeCount/Npts | Raw Dispensings per User | 7 | N | comma13.2 | N || t2cida | DaySupp | Days Supplied | 8 | N | comma10.0 | N || t2cida | DaySupp/Episodes | Days Supplied per Episode | 9 | N | comma13.2 | N || t2cida | DaySupp/Npts | Days Supplied per User | 10 | N | comma13.2 | N || t2cida | DaySupp/AdjustedCodeCount | Days Supplied per Adjusted Dispensings | 11 | N | comma13.2 | N || t2cida | DaySupp/RawCodeCount | Days Supplied per Raw Dispensings | 12 | N | comma13.2 | N || t2cida | AmtSupp | Amount Supplied | 13 | N | comma10.0 | N || t2cida | AmtSupp/Episodes | Amount Supplied per Episode | 14 | N | comma13.2 | N || t2cida | AmtSupp/AdjustedCodeCount | Amount Supplied per Adjusted Dispensings | 15 | N | comma13.2 | N || t2cida | AmtSupp/RawCodeCount | Amount Supplied per Raw Dispensings | 16 | N | comma13.2 | N || t2cida | Eps_wEvents | New Episodes with an Event | 17 | N | comma10.0 | N || t2cida | Eps_wEvents/Npts | Episodes with an Event per User | 18 | N | comma13.2 | N || t2cida | Eps_wEvents/Episodes | Episodes with an Event per Episode | 19 | N | comma13.2 | N || t2cida | Eps_wEvents/(followuptime/365.25) | Episodes with an Event per Member-Year at Risk | 20 | N | comma13.2 | N || t2cida | (Eps_wEvents/(followuptime/365.25))*X | Episodes with an Event per X Member-Years at Risk | 21 | N | comma13.2 | N || t2cida | eps_wevents/followuptime | Event Rate per Person-Day (95% Confidence Interval) | 22 | R | comma13.2 | N || t2cida | eps_wevents/(followuptime/30.35) | Event Rate per Person-Month (95% Confidence Interval) | 23 | R | comma13.2 | N || t2cida | eps_wevents/(followuptime/365.25) | Event Rate per Person-Year (95% Confidence Interval) | 24 | R | comma13.2 | N || t2cida | (eps_wevents/followuptime)*X | Event Rate per X Person-Days (95% Confidence Interval) | 25 | R | comma13.2 | N || t2cida | (eps_wevents/(followuptime/30.35))*X | Event Rate per X Person-Months (95% Confidence Interval) | 26 | R | comma13.2 | N || t2cida | (eps_wevents/(followuptime/365.25))*X | Event Rate per X Person-Years (95% Confidence Interval) | 27 | R | comma13.2 | N || t2cida | (Eps_wEvents/DenNumPts)*X | Episodes with an Event per X Eligible Members | 28 | N | comma13.2 | N || t2cida | eps_wevents/episodes | Proportion of Episodes with an Event (95% Confidence Interval) | 29 | P | comma13.2 | N || t2cida | (eps_wevents/episodes)*X | Proportion of Episodes with an Event per X New Episodes (95% Confidence Interval) | 30 | P | comma13.2 | N || t2cida | All_Events | All Events | 31 | N | comma10.0 | N || t2cida | followuptime | Days at Risk | 32 | N | comma10.0 | N || t2cida | followuptime/365.25 | Years at Risk | 33 | N | comma13.1 | N || t2cida | timetocensor | Time to Data End (Days) | 34 | N | comma13.0 | N || t2cida | DenNumPts | Eligible Members | 35 | N | comma10.0 | N || t2cida | DenNumMemDays | Eligible Member-Days | 36 | N | comma14.0 | N || t2cida | DenNumMemDays/365.25 | Eligible Member-Years | 37 | N | comma13.1 | N || t2conc | Npts | New Users | 1 | N | comma10.0 | N || t2conc | Episodes | New Episodes | 2 | N | comma10.0 | N || t2conc | AdjustedCodeCount | Adjusted Dispensings | 3 | N | comma10.0 | N || t2conc | AdjustedCodeCount/Npts | Adjusted Dispensing per User | 4 | N | comma13.2 | N || t2conc | RawCodeCount | Raw Dispensings | 5 | N | comma10.0 | N || t2conc | RawCodeCount/Npts | Raw Dispensings per User | 6 | N | comma13.2 | N || t2conc | DaySupp | Days Supplied | 7 | N | comma10.0 | N || t2conc | DaySupp/Episodes | Days Supplied per Episode | 8 | N | comma13.2 | N || t2conc | DaySupp/Npts | Days Supplied per User | 9 | N | comma13.2 | N || t2conc | DaySupp/AdjustedCodeCount | Days Supplied per Adjusted Dispensings | 10 | N | comma13.2 | N || t2conc | DaySupp/RawCodeCount | Days Supplied per Raw Dispensings | 11 | N | comma13.2 | N || t2conc | AmtSupp | Amount Supplied | 12 | N | comma10.0 | N || t2conc | AmtSupp/Episodes | Amount Supplied per Episode | 13 | N | comma13.2 | N || t2conc | AmtSupp/AdjustedCodeCount | Amount Supplied per Adjusted Dispensings | 14 | N | comma13.2 | N || t2conc | AmtSupp/RawCodeCount | Amount Supplied per Raw Dispensings | 15 | N | comma13.2 | N || t2conc | Eps_wEvents | New Episodes with an Event | 16 | N | comma10.0 | N || t2conc | Eps_wEvents/Npts | Episodes with an Event per User | 17 | N | comma13.2 | N || t2conc | Eps_wEvents/Episodes | Episodes with an Event per Episode | 18 | N | comma13.2 | N || t2conc | Eps_wEvents/(followuptime/365.25) | Episodes with an Event per Member-Year at Risk | 19 | N | comma13.2 | N || t2conc | (Eps_wEvents/(followuptime/365.25))*X | Episodes with an Event per X Member-Years at Risk | 20 | N | comma13.2 | N || t2conc | eps_wevents/followuptime | Event Rate per Person-Day (95% Confidence Interval) | 21 | R | comma13.2 | N || t2conc | eps_wevents/(followuptime/30.35) | Event Rate per Person-Month (95% Confidence Interval) | 22 | R | comma13.2 | N || t2conc | eps_wevents/(followuptime/365.25) | Event Rate per Person-Year (95% Confidence Interval) | 23 | R | comma13.2 | N || t2conc | (eps_wevents/followuptime)*X | Event Rate per X Person-Days (95% Confidence Interval) | 24 | R | comma13.2 | N || t2conc | (eps_wevents/(followuptime/30.35))*X | Event Rate per X Person-Months (95% Confidence Interval) | 25 | R | comma13.2 | N || t2conc | (eps_wevents/(followuptime/365.25))*X | Event Rate per X Person-Years (95% Confidence Interval) | 26 | R | comma13.2 | N || t2conc | eps_wevents/episodes | Proportion of Episodes with an Event (95% Confidence Interval) | 27 | P | comma13.2 | N || t2conc | (eps_wevents/episodes)*X | Proportion of Episodes with an Event per X New Episodes (95% Confidence Interval) | 28 | P | comma13.2 | N || t2conc | All_Events | All Events | 29 | N | comma10.0 | N || t2conc | followuptime | Days at Risk | 30 | N | comma10.0 | N || t2conc | followuptime/365.25 | Years at Risk | 31 | N | comma13.1 | N |<br><br>