Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            HCCHRGITEM FILE

                              Charge Item

This is the Patient Charge Item cross reference file.

REFERENCED BY

CXCP.1    IC59.1    PC20.1    PC530     PC540     POIJ.1
WH130     WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4    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
Rev Center           The revenue center is the department
                     that charges are associated with.

HCI-CHARGE-NBR       Alpha 10                                    PC10.1  PC810
Charge Nbr           The number used by the patient billing
                     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                                                CXCP.1  IC59.1
          REV-CENTER                                             PC10.1  PC120
          CHARGE-NBR                                             PC20.1  PC530
          ITEM                                                   PC540   PC810
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

HCISET2   COMPANY                                                CXCP.1  IC281
          ITEM                                                   IC521   IC522
          REV-CENTER                                             IC523   IC525
                                                                 IC526   IC527
                                                                 IC59.1  PC10.1
                                                                 PC20.1  PC210
                                                                 PC540   POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

                         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