Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            HCCHRGITEM FILE

                              Charge Item

This is the Patient Charge Item cross reference file.

REFERENCED BY

BL92.1    CX05.1    CX05.2    CX100     CX20.1    CX20.2
CX20.4    CX20.5    CX220     CX30.1    CX300     CX506
CX805     CXCP.1    IC59.1    PC20.1    PC530     PC540
OE114     OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE830     OE950     PO30.1
PO31.1    PO35.1    PO530     RQ35.1    WH130     WH132
WH190     WH20.7    WH222     WH30.1    WH30.2    WH30.3
WH31.1    WH31.2    WH31.3    WH32.1    WH32.2    WH32.3
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     WO132     WO140
IC281     IC521     IC522     IC523     IC525     IC526
IC527     PC210

UPDATED BY

PC10.1    PC120     PC810

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HCI-COMPANY          Numeric 4                                   PC10.1  PC810
Company              The company number represents an
                     established company and is entered on
                     all function codes.

HCI-REV-CENTER       Alpha 5                                     PC10.1  PC810
Revenue Center       The revenue center is the department
                     associated with charges.

HCI-CHARGE-NBR       Alpha 10                                    CX30.1  PC10.1
Charge Number        The number used by the patient billing      PC810
                     system to charge patients for items
                     used.

HCI-ITEM             Alpha 32                                    PC10.1  PC810
Item Number          This field contains the item
                     identifier.

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

HCI-PRICE            Signed 15.2                                 IC522   IC525
Price                This field contains the flat amount         IC526   IC527
                     that is applied as an add-on charge.        PC10.1  PC120
                                                                 PC810

HCI-UPDATE-DATE      Numeric 8  (yyyymmdd)                       PC10.1  PC120
Update Date          This field contains the date the record     PC810
                     was updated.

                         HCCHRGITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HCISET1   COMPANY                                                BL92.1  CX05.1
          REV-CENTER                                             CX05.2  CX100
          CHARGE-NBR                                             CX20.1  CX20.2
          ITEM                                                   CX20.4  CX20.5
                                                                 CX220   CX30.1
                                                                 CX300   CX506
                                                                 CX805   CXCP.1
                                                                 IC59.1  PC10.1
                                                                 PC120   PC20.1
                                                                 PC530   PC540
                                                                 PC810   OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 ...

HCISET2   COMPANY                                                BL92.1  CX100
          ITEM                                                   CX20.1  CX20.2
          REV-CENTER                                             CX20.4  CX20.5
                                                                 CX220   CX30.1
                                                                 CX300   CX506
                                                                 CXCP.1  IC281
                                                                 IC521   IC522
                                                                 IC523   IC525
                                                                 IC526   IC527
                                                                 IC59.1  PC10.1
                                                                 PC20.1  PC210
                                                                 PC540   OE114
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 ...

                         HCCHRGITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            HCI-COMPANY        -> ICC-COMPANY

Itemmast       ITEMMAST     Required

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

                         HCCHRGITEM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hcprcclass     HCPRCCLASS   Required
                            When HCI-PRICE-CLASS != Spaces

                            ICC-ITEM-GROUP     -> HPC-ITEM-GROUP
                            HCI-PRICE-CLASS    -> HPC-PRICE-CLASS
                                                  HPC-COST-LIMIT