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.