|
|
PHARITEM FILE
REFERENCED BY
IC11.1 IC12.1 ICI8.1 RQID.1 RQIF.1 RQIH.1
RQIJ.1 IC598 PHI6.1 POI7.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHI-ITEM-GROUP Alpha 5
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
PHI-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
PHI-LOCATION Alpha 5
Element: Location Code This field contains a valid stocking
location within the company inventory.
PHI-ITEM Alpha 32
Element: Item Number This field contains the item
identifier.
PHI-NDC-NBR Alpha 15
Element: National Drug National Drug Code.
PHI-GPPC Alpha 8
Generic Product Generic Product Production Code.
Production Cd
PHI-AHFS Alpha 6
American Hosp American Hospital Formulary System Code.
Formulary System
PHI-GIPP Alpha 20
Standard Industry Standard Industry Product Identifier
Product ID Code.
PHI-MDPRODDESC Alpha 30
Element: Brand of Drug Generic name for the drug.
PHI-MDSTRENGTH Alpha 10
Element: Drug Strength Drug strength.
PHI-MDDOSEFORM Alpha 10
Element: Drug Form Drug form, e.g. tabs, caps, suspension,
etc.
PHI-MDPACKDESC Alpha 5
Container Container description, e.g. bottle,
Description package, vial, etc.
PHI-MDPACKSIZE Signed 13.4
Element: Count per ContThe count per container.
PHI-GPO-NBR Alpha 20
Element: Gpo Nbr
PHI-MFGBY Alpha 10
Element: Manufacturer Manufacturer identifier.
PHI-RESTRICT Alpha 6
Element: Restricted SerMedical service to which the drug is
restricted.
PHI-CHEMO Alpha 1
Element: Chemotherapy FChemotherapy flag.
N = No
Y = Yes
PHI-DEASKED Alpha 1
Drug Enforcement Drug Enforcement Agency Schedule.
Agency Schedl
PHI-SUB-FL Alpha 1
Element: Allow SubstituIndicates whether substituting with
another brand or size is allowed.
N = No
Y = Yes
PHI-UNITDOSE-FL Alpha 2
Unit Dose Version Identifies item as a unit dose version.
Flag UD = Unit Dose
PHI-CRITICAL-FL Alpha 1
Element: Critical Drug Critical Drug List specifier.
PHI-PHAR-OHQ Signed 13.4
Pharmacy's On-hand Pharmacy's on-hand quantity.
Quantity
PHI-MARKUP-PERC Percent 6.2 (Percent)
Element: Markup PercentMarkup percentage to be used in
calculating selling price to outside
users. The last receipt price plus this
markup percentage will be passed to
AR/billing.
PHI-CDM-NBR Alpha 22
Charge Description Charge Description Master number.
Master Nbr
PHI-USAGE-ACCT-FL Alpha 1
Element: Usage Acct Fl 0 = Inpatient
1 = Outpatient
PHI-USAGE-ACCOUNT Numeric 10
Element: Usage Account
PHI-DRUG-NAME Alpha 32
Element: Drug Name
PHI-USER-FIELD1 Alpha 30
Item Mster User This is the first user definable field.
Defined Field1 It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
PHI-USER-FIELD2 Alpha 10 (Lower Case)
Item Mster User This is the second user definable
Defined Field2 field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
PHI-USER-FIELD3 Alpha 10 (Lower Case)
Item Mster User
Defined Field2
PHI-USER-FIELD4 Alpha 10 (Lower Case)
Item Mster User
Defined Field2
PHI-USER-FIELD5 Alpha 10 (Lower Case)
Item Mster User
Defined Field2
PHI-USER-FIELD-N1 Signed 13.5
User Defined This field is the first user definable
Numeric Field 1 numeric field. It can be used to
capture any numeric data that the user
wants. The name of the field is
determined in IC00.
PHI-USER-FIELD-N2 Signed 13.5
User Defined
Numeric Field 1
PHI-USER-FIELD-N3 Signed 13.5
User Defined
Numeric Field 1
PHI-MED-ID Alpha 15
Element: Med Id
PHI-AWP-PRICE Signed 13.5
Element: Awp Price
PHI-RETAIL-PRICE Signed 13.5
Element: Retail Price
PHI-UPC Alpha 15
Universal Product Universal Product Code.
Code
PHI-ACTIVE-STATUS Alpha 1
Element: Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
PHI-ADDED-DATE Numeric 8 (yyyymmdd)
Element: Date
PHI-INACTIVE-DATE Numeric 8 (yyyymmdd)
Element: Inactive Date
PHI-AHFSNAME Alpha 40
Element: Ahfsname
PHI-BENCHMARK Alpha 10
Element: Benchmark
PHI-BRAND-NAME Alpha 30
Element: Brand Name Brand of drug or label name, e.g.
Tylenol.
PHI-MARKETED-BY Alpha 9
Element: Marketed By
PHI-PKG-MEASURE Alpha 4
Element: Pkg Measure
PHI-TIME-RELEASE Alpha 2
Element: Time Release
PHI-ITEM-CODE-USED Derived
Element: Item Code Used
PHARITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHISET1 ITEM-GROUP IC11.1 IC12.1
ITEM ICI8.1 RQID.1
COMPANY RQIF.1 RQIH.1
LOCATION RQIJ.1
NDC-NBR
UPC
PHISET10 ITEM-GROUP KeyChange
ITEM
DRUG-NAME
COMPANY
LOCATION
NDC-NBR
UPC
PHISET11 ITEM-GROUP KeyChange
DRUG-NAME
COMPANY
LOCATION
ITEM
NDC-NBR
UPC
PHISET12 ITEM-GROUP KeyChange
ACTIVE-STATUS
DRUG-NAME
COMPANY
LOCATION
ITEM
NDC-NBR
UPC
PHISET13 COMPANY KeyChange
LOCATION
DRUG-NAME
MDSTRENGTH
MDPACKDESC
ITEM
NDC-NBR
UPC
PHISET14 ITEM-GROUP KeyChange, Subset
ACTIVE-STATUS Where BRAND-NAME != Spaces
BRAND-NAME
COMPANY
LOCATION
ITEM
NDC-NBR
UPC
PHISET2 COMPANY KeyChange IC598 PHI6.1
LOCATION POI7.1
ITEM
NDC-NBR
UPC
PHISET3 NDC-NBR KeyChange
UPC
COMPANY
LOCATION
PHISET4 COMPANY KeyChange
LOCATION
ACTIVE-STATUS
DRUG-NAME
ITEM
NDC-NBR
UPC
PHISET5 GPPC KeyChange, Subset
COMPANY Where GPPC != Spaces
LOCATION
ITEM
NDC-NBR
UPC
PHISET6 AHFS KeyChange, Subset
COMPANY Where AHFS != Spaces
LOCATION
ITEM
NDC-NBR
UPC
PHISET7 GIPP KeyChange, Subset
COMPANY Where GIPP != Spaces
LOCATION
ITEM
NDC-NBR
UPC
PHISET8 MDPRODDESC KeyChange, Subset
COMPANY Where MDPRODDESC != Spaces
LOCATION
ITEM
NDC-NBR
UPC
PHISET9 GPO-NBR KeyChange, Subset
COMPANY Where GPO-NBR != Spaces
LOCATION
ITEM
NDC-NBR
UPC
PHARITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pharitemtondc ITEMNDC Required
When PHI-NDC-NBR != Spaces
PHI-ITEM-GROUP -> -ITEM-GROUP
PHI-ITEM -> -ITEM
PHI-NDC-NBR -> -NDC-NBR
Pharitemtoupc ITEMUPC Required
When PHI-UPC != Spaces
PHI-ITEM-GROUP -> IPC-ITEM-GROUP
PHI-ITEM -> IPC-ITEM
PHI-UPC -> IPC-UPC
Pharittoitmloc ITEMLOC Required
PHI-COMPANY -> ITL-COMPANY
PHI-LOCATION -> ITL-LOCATION
PHI-ITEM -> ITL-ITEM
Pharittoitmmst ITEMMAST Required
PHI-ITEM-GROUP -> ITE-ITEM-GROUP
PHI-ITEM -> ITE-ITEM
Procuregrp PROCUREGRP Required
PHI-ITEM-GROUP -> PCG-ITEM-GROUP
PHARITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemsrc ITEMSRC
PHI-COMPANY -> ITM-COMPANY
PHI-LOCATION -> ITM-LOCATION
PHI-ITEM -> ITM-ITEM
ITM-REPLENISH-PRI
Poitemven POITEMVEN
PCG-PROCURE-GROUP -> PIV-PROCURE-GROUP
PHI-ITEM -> PIV-ITEM
PIV-VENDOR
|
