Descrizione

Arbitrary identifier for each unique PRESCRIBING record.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1300638

Descrizione

Arbitrary person-level identifier. Used to link across tables. All PATIDs must be present in the DEMOGRAPHIC table.

Tipo di dati

text

Alias

UMLS CUI [1]

C2348585

Descrizione

Arbitrary encounter-level identifier. This is an optional relationship; the ENCOUNTERID should be present if the prescribing activity is directly associated with an encounter. All ENCOUNTERIDs in this table must be present in the ENCOUNTER table.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Descrizione

Provider code for the provider who prescribed the medication. The provider code is a pseudoidentifier with a consistent crosswalk to the real identifier. All PROVIDERIDs in this table must be present in the PROVIDER table.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C0033080

UMLS CUI [1,3]

C1300638

Descrizione

Order date of the prescription by the provider. If RX_ORDER_DATE is not known, a permissible substitution is the RX_START_DATE (if known) or the date the order was signed by the provider.

Tipo di dati

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0011008

Descrizione

Order time of the prescription by the provider.

Tipo di dati

time

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0040223

Descrizione

Start date of order. This attribute may not be consistent with the date on which the patient actually begin taking the medication.

Tipo di dati

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0808070

Descrizione

End date of order (if available).

Tipo di dati

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0806020

Descrizione

Dose of a given mediation, as ordered by the provider. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

float

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C1705178

Descrizione

Units of measure associated with the dose of the medication as ordered by the provider. Do not impute or derive. Populate only if captured in the source system as a discrete value. Choose the standardized unit of measure that is most reflective of the source data. The Value Set Appendix contains a list of the units most commonly associated with medication records. Partners can use this table to aid in their mapping efforts, but they should refer back to the full value set if they have a medication record with a unit of measure that is not present in this curated list. This is a mixed case value set and entries should be handled accordingly.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C0869039

Descrizione

Quantity ordered. Number precision and scale updated in v4.1. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

float

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

Descrizione

The unit associated with the quantity prescribed. This is equivalent to RxNorm Dose Form. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

UMLS CUI [1,3]

C1519795

Descrizione

Number of refills ordered (not including the original prescription). If no refills are ordered, the value should be zero. Number precision and scale updated in v4.1. If value is non-numeric, leave field blank and populate RAW_RX_REFILLS with originating source value. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

float

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C0149761

Descrizione

Number of days supply ordered, as specified by the prescription. Number precision and scale updated in v4.1. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1561604

UMLS CUI [1,2]

C3166216

UMLS CUI [1,3]

C0449238

Descrizione

Specified frequency of medication. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

text

Alias

UMLS CUI [1]

C3476109

Descrizione

Flag to indicate that all or part of medication frequency instructions includes “as needed.” Select Yes if medication order includes instructions to take medication “as needed” or with any other frequency “as needed” (e.g., Two times a day, as needed). This field is a derived attribute, and is not expected to be an explicit data field within a source system.

Tipo di dati

boolean

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0815189

Descrizione

Route of medication delivery. The value set for Route is derived from SNOMED and may include values that are more granular than what is present in the source system. If a direct mapping is available, use the appropriate SNOMED code. If there is any possible ambiguity, use “OT” and then store the source value in RAW_RX_ROUTE. For example, an Injection could map to Subcutaneous or Intramuscular or Intraocular, depending on the drug, so that would best be mapped to “OT.” Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

text

Alias

UMLS CUI [1]

C0013153

Descrizione

Basis of the medication order. The PRESCRIBING table can contain orders for many different activities, and this field is intended to connect the provider’s prescribing order with how the order was fulfilled (such as outpatient dispensing or administration by a healthcare professional). (Value set items updated and field definition expanded in v3.1.)

Tipo di dati

text

Alias

UMLS CUI [1,1]

C0392360

UMLS CUI [1,2]

C0033080

UMLS CUI [1,3]

C1272683

Descrizione

Where an RxNorm mapping exists for the source medication, this field contains the RxNorm concept identifier (CUI) at the highest possible specificity. The ordering strategy for RxNorm Term Types has been updated to indicate a preference of brand name CUIs over generics, when available. It has also been expanded to include addition RxNorm Term Types. Please see Reference Table 4 for more information. Do not assign a RxNorm Term Type that is not supported by the source data (i.e., if the medication order in source system is missing strength information, do not use any of the RxNorm Term Types that incorporate the strength component). This field may be a derived attribute, and is not necessarily expected to be an explicit data field within a source system. Expected format of RXNORM_CUI codes: Length of 2-7, no alphabetical characters. Do not assign more than one RxCUI per order. Ensure that a single prescribing record is not assigned multiple RxCUIs.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C2348662

UMLS CUI [1,2]

C3166216

Descrizione

Source of the prescribing information. This field is a derived attribute, and is not expected to be an explicit data field within a source system. Use “OD” for medication orders entered into the EHR or for electronic prescriptions. Use “DR” for all medication orders that are derived or imputed through analytical procedures (e.g., natural language processing). This does not apply to medication orders mapped from a superset terminology or drug database (e.g., MediSpan, FDB). For those records, use “OD” (General Guidance #4).

Tipo di dati

text

Alias

UMLS CUI [1,1]

C0683836

UMLS CUI [1,2]

C3166216

Descrizione

Flag to indicate whether the provider indicated that the medication order was to be dispensed as written. his information is typically captured within EHRs or e- prescribing as part of the ordering process. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Tipo di dati

text

Alias

UMLS CUI [1]

C1880360

Descrizione

Field for originating, full textual medication name from the source.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C0027365

UMLS CUI [2,1]

C0013227

UMLS CUI [2,2]

C0027365

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C3476109

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C2348662

UMLS CUI [1,2]

C3166216

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C1708005

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C3166216

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C0869039

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C0013153

Descrizione

Field for originating value, prior to mapping into the PCORnet CDM value set.

Tipo di dati

text

Alias

UMLS CUI [1]

C0149761