Data Dictionary
Selected table: MEDICATION
- Home
- Data Dictionary
- Table List
- MEDICATION
id | Physical Name | Logical Name | Description | Category |
---|---|---|---|---|
1 | ENCTRSS_ID | NDW Encounter Record Identifier | This identifier is generated internally by the NDW and is used to uniquely identify an encounter record. | 100.0000 |
1 | EXPORT_ID | Export ID | Each export file that is received by the DW will be assigned a unique export ID number. This will allow us to track each record back to the "raw data file" if necessary. It also allows us to track certain information specific to each export such as number of records, date received, etc. | 100.0000 |
1 | MED_NDC_CODE | Medication NDC Code | National Drug Code (NDC) for this medication as stored in the local system. Nationally recognized standard code set | 17.0000 |
1 | MED_NM | Medication Name | Name of the medication as stored in the local system. | 17.0000 |
1 | MED_QTY | Medication Quantity | Quantity of medicine dispensed (e.g., number of pills, milliliters of a liquid preparation, grams of a topical cream, etc.). Entry is a number, units (# of pills, mls, mgs, etc.) are implicit in the NDC code. (Formatted as a number up to 9999999.999.) | 17.0000 |
1 | REGION_ABBR_CD | Region Abbreviation Code | Alpha (3-char) designator indicating the IHS region (e.g. ALB for Albuquerque). | N/A |
1 | SEQ_NBR | Sequence Number | For the first occurrence, the sequence number is 1; for the second occurrence, the sequence number is 2, and so on. | 100.0000 |
1 | VA_DRUG_CLASS_CD | VA Drug Class Code | Code representing the VA Drug Class. This code is assigned by the local system. Nationally recognized standard code set. | 17.0000 |