Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HCCHRGITEM


                            HCCHRGITEM FILE

                              Charge Item

This is the Patient Charge Item cross reference file.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    CXCP.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO190     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POID.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ35.1    WH130     WH132     WH190     WH20.2
WH20.7    WH222     WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HCI-COMPANY            Numeric 4
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

HCI-REV-CENTER         Alpha 5
Element: Rev Center    The revenue center is the department
                       that charges are associated with.

HCI-CHARGE-NBR         Alpha 10
Element: Charge Nbr    The number used by the patient billing
                       system to charge patients for items
                       used.

HCI-ITEM               Alpha 32
Element: Item          This field contains the item
                       identifier.

HCI-PRICE-CLASS        Alpha 4
Element: Price Class   A code that identifies the rules for
                       calculating a patient charge price.

HCI-PRICE              Signed 18.2
Element: Intl Amt

HCI-UPDATE-DATE        Numeric 8  (yyyymmdd)
Element: Update Date   This field contains the date the record
                       was updated.

                         HCCHRGITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HCISET1   COMPANY                                                AP125   AP126
          REV-CENTER                                             AP131   AP20.1
          CHARGE-NBR                                             AP20.2  AP20.3
          ITEM                                                   AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

HCISET2   COMPANY                                                AP125   AP126
          ITEM                                                   AP131   AP20.1
          REV-CENTER                                             AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

HCISET3   COMPANY
          REV-CENTER
          ITEM

                         HCCHRGITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            HCI-COMPANY        -> ICC-COMPANY  (ICCSET1)

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP     -> ITE-ITEM-GROUP
                            HCI-ITEM           -> ITE-ITEM