Sentinel Routine Querying Tool Report Documentation

prescription (NDC) codes were used to define a covariate (i.e., CODETYPE

= DX and RX), the user would want more than one appendix to describe

covariate codes. To do so, the user should reference the diagnosis code

tab from their code spreadsheet in one row of `qrp_report.AppendixFile`

with `ORDER` = X and `APPENDIXTYPE` = covariate, then use another row to

reference the prescription code tab from their code spreadsheet with

`ORDER` = Y and `APPENDIXTYPE` = covariate. This would result in the

different code types appearing in two separate appendices, titled "List

of International Classification of Diseases, Tenth Revision, Clinical

"List of National Drug Codes (NDCs) Used to Define Covariates in this

Request."

​

Appendices are titled using the form "List of \[TYPE OF CODE\] Used to

Define \[RELEVANT STUDY PARAMETER\] in this Request." The label for

\[TYPE OF CODE\] is determined based on the code category and code type

specified in the code list referenced by `qrp_report.AppendixFile`. See

Table 1 below for labels used in code list appendices.

​

**Table 1. Appendix Title Code Type Labels**

​

| **Code Category** | **Code Type** | **Label for Appendix Title**                                                                    |

|-------------------|---------------|-------------------------------------------------------------------------------------------------|

| DX                | 09            | International Classification of Diseases, Ninth Revision, Clinical Modification (ICD-9-CM)      |

| DX                | 10            | International Classification of Diseases, Tenth Revision, Clinical Modification (ICD-10-CM)     |

| PX                | 09            | International Classification of Diseases, Ninth Revision, Clinical Modification (ICD-9-CM)      |

| PX                | 10            | International Classification of Diseases, Tenth Revision, Procedural Coding System (ICD-10-PCS) |

| PX                | HC            | Healthcare Common Procedure Coding System, Level II (HCPCS)                                     |

| PX                | H3            | Healthcare Common Procedure Coding System, Level III (HCPCS)                                    |

| PX                | ND            | National Drug Codes (NDC)                                                                       |

| PX                | RE            | Revenue (RE)                                                                                    |

| RX                | 09            | National Drug Code (NDC)                                                                        |

| RX                | 11            | National Drug Code (NDC)                                                                        |

​

​

Users should note that any columns included in the code file referenced

in `qrp_report.AppendixFile` will be output by the QRP Reporting Tool.

Code lists including National Drug Codes (NDCs) must include at a

minimum the NDC and generic name (which will be output in separate