PHARITEM FILE
REFERENCED BY
IC11.1 IC12.1 ICI8.1 RQID.1 RQIH.1 IC598
PHI6.1 POI7.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHI-ITEM-GROUP Alpha 5
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
Company The company number represents an
established company and is entered on
all function codes.
PHI-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
PHI-ITEM Alpha 32
Item Number This field contains the item
identifier.
PHI-NDC-NBR Alpha 15
National Drug Code 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
Brand of Drug Brand of drug or label name, e.g.
Tylenol.
PHI-MDSTRENGTH Alpha 10
Drug Strength Drug strength.
PHI-MDDOSEFORM Alpha 10
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
Count per Container The count per container.
PHI-GPO-NBR Alpha 20
Gpo Nbr
PHI-MFGBY Alpha 10
Manufacturer Manufacturer identifier.
PHI-RESTRICT Alpha 6
Restricted Service Medical service to which the drug is
restricted.
PHI-CHEMO Alpha 1
Chemotherapy Flag Chemotherapy flag.
N = No
Y = Yes
PHI-DEASKED Alpha 1
Drug Enforcement Drug Enforcement Agency Schedule.
Agency Schedl
PHI-SUB-FL Alpha 1
Allow Substitutes Indicates 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
Critical Drug List 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)
Markup Percentage Markup 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
Usage Acct Fl 0 = Inpatient
1 = Outpatient
PHI-USAGE-ACCOUNT Numeric 10
Usage Account
PHI-DRUG-NAME Alpha 32
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 This field is the third user definable
Defined Field3 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
PHI-USER-FIELD4 Alpha 10 (Lower Case)
Item Mster User This field is the fourth user definable
Defined Field4 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
PHI-USER-FIELD5 Alpha 10 (Lower Case)
User Mster User This field is the fifth user definable
Defined Field5 field. It can be used to capture any
data that the user wants. The name of
the field is determined in IC00.
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 This field is the second user definable
Numeric Field 2 numeric field. This field can be used
to capture any numeric data that the
user wants. The name of the field is
determined in IC00.
PHI-USER-FIELD-N3 Signed 13.5
User Defined This field is the third user definable
Numeric Field 3 numeric field. This field can be used
to capture any data that the user wants.
The name of the field is determined in
IC00.
PHI-MED-ID Alpha 15
Med Id
PHI-AWP-PRICE Signed 13.5
Awp Price
PHI-RETAIL-PRICE Signed 13.5
Retail Price
PHI-UPC Alpha 15
Universal Product Universal Product Code.
Code
PHI-ACTIVE-STATUS Alpha 1
Status The status of the account. If Inactive,
no posting can be done to the account.
1 = Active
2 = Inactive
PHI-ADDED-DATE Numeric 8 (yyyymmdd)
Date Item was Added
PHI-INACTIVE-DATE Numeric 8 (yyyymmdd)
Inactive Date
PHI-AHFSNAME Alpha 40
Ahfsname
PHI-BENCHMARK Alpha 10
Benchmark
PHI-BRAND-NAME Alpha 30
Brand Name
PHI-MARKETED-BY Alpha 9
Marketed By
PHARITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHISET1 ITEM-GROUP IC11.1 IC12.1
ITEM ICI8.1 RQID.1
COMPANY RQIH.1
LOCATION
NDC-NBR
UPC
PHISET10 MFGBY KeyChange
COMPANY
LOCATION
ITEM
NDC-NBR
UPC
PHISET11 LOCATION KeyChange
COMPANY
ITEM
NDC-NBR
UPC
PHISET12 DRUG-NAME KeyChange
COMPANY
LOCATION
ITEM
NDC-NBR
UPC
PHISET13 COMPANY KeyChange
LOCATION
DRUG-NAME
MDSTRENGTH
MDPACKDESC
ITEM
NDC-NBR
UPC
PHISET2 COMPANY KeyChange IC598 PHI6.1
LOCATION POI7.1
ITEM
NDC-NBR
UPC
PHISET3 NDC-NBR KeyChange
UPC
COMPANY
LOCATION
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
Pharittoitmloc ITEMLOC Required
PHI-COMPANY -> ITL-COMPANY (ITLSET1)
PHI-LOCATION -> ITL-LOCATION
PHI-ITEM -> ITL-ITEM
Pharittoitmmst ITEMMAST Required
PHI-ITEM-GROUP -> ITE-ITEM-GROUP
PHI-ITEM -> ITE-ITEM
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
|
