ITEMNDC

Item National Drug Code

The Item NDC file contains the National Drug Codes related to an item in the Item Master file.
UPDATED BY
IC11.1 IC11.6 IC511 IC598 IC800 ICI8.1
ICIC.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5
PO26.8 PO28.2 PO36.2 PO536 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIH.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDC-ITEM-GROUP
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDC-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDC-NDC-NBR
Element: Ndc Nbr
Alpha 15
National Drug Code.
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDC-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDC-MDPRODDESC
Element: Mdproddesc
Alpha 30
Generic Name for the drug
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDSTRENGTH
Element: Mdstrength
Alpha 10
Drug strength.
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDDOSEFORM
Element: Mddoseform
Alpha 10
Drug form, e.g. tabs, caps, suspension, etc.
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDPACKDESC
Element: Mdpackdesc
Alpha 5
Container description, e.g. bottle, package, vial, etc.
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MDPACKSIZE
Element: Mdpacksize
Signed 13.4
The count per container.
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-MFGBY
Element: Mfgby
Alpha 10
Manufacturer identifier.
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-UNITDOSE-FL
Element: Unitdose Fl
Alpha 1
Identifies item as a unit dose version.
Y = Yes
N = No
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-BRAND-NAME
Element: Brand Name
Alpha 35 (Lower Case)
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-DRUG-NAME
Element: Drug Name
Alpha 32
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDC-ITEM-TYPE-NDC
Element: Item Type Ndc
Derived


ITEMNDC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDCSET1 ITEM-GROUP
ITEM
NDC-NBR
IC11.1 IC11.6
IC511 IC800
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
RQID.1 RQIF.1
RQIH.1 RQIJ.1
IDCSET2 NDC-NBR
ITEM-GROUP
ICI8.1 ICIC.1
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO26.8
PO28.2 PO36.2
PO536 RQID.1
RQIF.1 RQIH.1
RQIJ.1
IDCSET5 ITEM-GROUP
ITEM
UOM
NDC-NBR
KeyChange
IC11.1 IC598
ICI8.1 ICIC.1
RQIC.1 RQID.1
RQIF.1 RQIG.1
RQIH.1 RQIJ.1
IDCSET6 ITEM-GROUP
NDC-NBR
ICI8.1 ICIC.1
RQID.1 RQIF.1
RQIH.1 RQIJ.1


ITEMNDC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemndctoitem ITEMMAST Required
IDC-ITEM-GROUP->ITE-ITEM-GROUP
IDC-ITEM->ITE-ITEM


File created: Thu Jun 09 11:17:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.