 |
Lawson Insight Technical Documentation |
|
HCPATCHRG FILE
Patient Charge
This is the Patient Charge file.
REFERENCED BY
PC310 PC210
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 IC28.1 PC20.1 PC320 PC521
PC530 PC540 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.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
HPR-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-VISIT-NBR Alpha 12 AP125 AP126
Visit Number This is the identifier that makes a AP131 AP25.1
visit unique with a company. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-REV-CENTER Alpha 5 AP125 AP126
Rev Center The revenue center is the department AP131 AP25.1
that charges are associated with. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-CHARGE-NBR Alpha 10 AP125 AP126
Charge Nbr The number used by the patient billing AP131 AP25.1
system to charge patients for items AP25.2 AP26.1
used. AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-CHARGE-SEQ Numeric 4 AP125 AP126
Charge Seq This field contains a sequence number AP131 AP25.1
to make a record's key unique. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the desired AP131 AP25.1
quantity. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-DATE-OF-CHRG Numeric 8 (yyyymmdd) AP125 AP126
Date Of Chrg This is the date the supply was given AP131 AP25.1
to the patient. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-FROM-LOCATION Alpha 5 AP125 AP126
From Location This field contains the location that AP131 AP25.1
was the source of the supplies. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Update Date This field contains the date the record AP131 AP25.1
was updated. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC530
PC540 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
...
HPR-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC530
PC540 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
...
HPR-BATCH-NBR Numeric 6 AP125 AP126
Batch Number This is the identifier used to control AP131 AP25.1
charges being sent to a patient billing AP25.2 AP26.1
system. This batch number will be blank AP27.1 CXCP.1
until the charge has been sent to IC28.1 MA180
billing. Then it will contain the batch MA43.9 MA530
number so it is not sent on subsequent MA531 MA60.2
runs. The charge cannot be changed once MA60.3 MA60.5
is has been sent to billing. MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC530 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
HPR-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PC540
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
PO38.1 PO39.1
PO39.2 PO44.1
PO50.1 PO52.1
PO520 POI3.1
POIE.1 POII.1
POIJ.1 RQ10.1
RQ10.2 RQ35.1
...
HPR-PRICE Signed 15.2 AP125 AP126
Price This is the unit price of the item AP131 AP25.1
charged to the patient. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PC20.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
RQ35.1 WH130
...
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
|