Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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