Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             HCPATCHRG FILE

                             Patient Charge

This is the Patient Charge file.

REFERENCED BY

PC310     PC210

UPDATED BY

CXCP.1    PC20.1    PC320     PC521     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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HPR-COMPANY          Numeric 4                                   CXCP.1  PC20.1
Company              The company number represents an            PC540   POIJ.1
                     established company and is entered on       WH130   WH33.1
                     all function codes.                         WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

HPR-VISIT-NBR        Alpha 12                                    CXCP.1  PC20.1
Visit Number         This is the identifier that makes a         PC540   POIJ.1
                     visit unique with a company.                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

HPR-REV-CENTER       Alpha 5                                     CXCP.1  PC20.1
Rev Center           The revenue center is the department        PC540   POIJ.1
                     that charges are associated with.           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

HPR-CHARGE-NBR       Alpha 10                                    CXCP.1  PC20.1
Charge Nbr           The number used by the patient billing      PC540   POIJ.1
                     system to charge patients for items         WH130   WH33.1
                     used.                                       WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

HPR-ITEM             Alpha 32                                    CXCP.1  PC20.1
Item Number          This field contains the item                PC540   POIJ.1
                     identifier.                                 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

HPR-CHARGE-SEQ       Numeric 4                                   CXCP.1  PC20.1
Charge Seq           This field contains a sequence number       PC540   POIJ.1
                     to make a record's key unique.              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

HPR-QUANTITY         Signed 13.4                                 CXCP.1  PC20.1
Quantity             This field contains the desired             PC540   POIJ.1
                     quantity.                                   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

HPR-DATE-OF-CHRG     Numeric 8  (yyyymmdd)                       CXCP.1  PC20.1
Date Of Chrg         This is the date the supply was given       PC540   POIJ.1
                     to the patient.                             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

HPR-FROM-LOCATION    Alpha 5                                     CXCP.1  PC20.1
From Location        This field contains the location that       PC540   POIJ.1
                     was the source of the supplies.             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

HPR-UPDATE-DATE      Numeric 8  (yyyymmdd)                       CXCP.1  PC20.1
Update Date          This field contains the date the record     PC530   PC540
                     was updated.                                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

HPR-UPDATE-TIME      Numeric 6                                   CXCP.1  PC20.1
Update Time          This field contains the system time         PC530   PC540
                     when the record was updated.                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

HPR-BATCH-NBR        Numeric 6                                   CXCP.1  PC530
Batch Number         This is the identifier used to control      POIJ.1  WH130
                     charges being sent to a patient billing     WH33.1  WH33.2
                     system. This batch number will be blank     WH33.3  WH33.4
                     until the charge has been sent to           WH33.5  WH33.6
                     billing. Then it will contain the batch     WH33.8  WH33.9
                     number so it is not sent on subsequent      WH34.1  WH34.2
                     runs. The charge cannot be changed once     WH34.3  WH34.4
                     is has been sent to billing.

HPR-UNIT-COST        Signed 13.5                                 CXCP.1  PC20.1
Unit Cost            This field contains the unit cost.          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

HPR-PRICE            Signed 15.2                                 CXCP.1  PC20.1
Price                This is the unit price of the item          POIJ.1  WH130
                     charged to the patient.                     WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

HPR-FICA-NBR         Alpha 15
Social Security
Number

                         HCPATCHRG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HPRSET1   COMPANY                                                PC20.1  PC310
          VISIT-NBR                                              PC320   PC521
          REV-CENTER
          FROM-LOCATION
          DATE-OF-CHRG
          ITEM
          CHARGE-SEQ

HPRSET2   COMPANY                                                PC210
          FROM-LOCATION
          DATE-OF-CHRG
          ITEM
          VISIT-NBR
          CHARGE-SEQ

HPRSET3   COMPANY       KeyChange                                PC530
          BATCH-NBR
          REV-CENTER
          UPDATE-DATE
          UPDATE-TIME
          VISIT-NBR
          CHARGE-SEQ

                         HCPATCHRG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

From Location  ICLOCATION   Required

                            HPR-COMPANY          -> ICL-COMPANY
                            HPR-FROM-LOCATION    -> ICL-LOCATION

Hcchrgitem     HCCHRGITEM   Required

                            HPR-COMPANY          -> HCI-COMPANY
                            HPR-REV-CENTER       -> HCI-REV-CENTER
                            HPR-CHARGE-NBR       -> HCI-CHARGE-NBR
                            HPR-ITEM             -> HCI-ITEM

Hcpatvisit     HCPATVISIT   Required

                            HPR-COMPANY          -> HPV-COMPANY
                            HPR-VISIT-NBR        -> HPV-VISIT-NBR

Iccompany      ICCOMPANY    Required

                            HPR-COMPANY          -> ICC-COMPANY

Itemloc        ITEMLOC      Required

                            HPR-COMPANY          -> ITL-COMPANY
                            HPR-FROM-LOCATION    -> ITL-LOCATION
                            HPR-ITEM             -> ITL-ITEM

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            HPR-ITEM             -> ITE-ITEM