HCPATCHRG FILE
Patient Charge
This is the Patient Charge file.
REFERENCED BY
PC310 PC210
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 PC20.1
PC320 PC521 PC530 PC540 OE114 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE830 OE950 PO31.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPR-COMPANY Numeric 4 BL92.1 CX100
Company The company number represents an CX20.1 CX20.2
established company and is entered on CX20.4 CX20.5
all function codes. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-VISIT-NBR Alpha 12 BL92.1 CX100
Visit Number This is the identifier that makes a CX20.1 CX20.2
visit unique with a company. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-REV-CENTER Alpha 5 BL92.1 CX100
Revenue Center The revenue center is the department CX20.1 CX20.2
associated with charges. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-CHARGE-NBR Alpha 10 BL92.1 CX100
Charge Number The number used by the patient billing CX20.1 CX20.2
system to charge patients for items CX20.4 CX20.5
used. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-CHARGE-SEQ Numeric 4 BL92.1 CX100
Charge Seq This field contains a sequence number CX20.1 CX20.2
to make a record's key unique. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-QUANTITY Signed 13.4 BL92.1 CX100
Quantity This field contains the requested CX20.1 CX20.2
quantity. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-DATE-OF-CHRG Numeric 8 (yyyymmdd) BL92.1 CX100
Date Of Chrg This is the date the supply was given CX20.1 CX20.2
to the patient. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-FROM-LOCATION Alpha 5 BL92.1 CX100
From-Location This field contains the location that CX20.1 CX20.2
was the source of the supplies. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Update Date This field contains the date the record CX20.1 CX20.2
was updated. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC530
PC540 PO31.1
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
HPR-UPDATE-TIME Numeric 6 BL92.1 CX100
Update Time This field contains the system time CX20.1 CX20.2
when the record was updated. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC530
PC540 PO31.1
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
HPR-BATCH-NBR Numeric 6 BL92.1 CX100
Batch Number This is the identifier used to control CX20.1 CX20.2
charges being sent to a patient billing CX20.4 CX20.5
system. This batch number will be blank CX220 CX30.1
until the charge has been sent to CX300 CX506
billing. Then it will contain the batch CXCP.1 OE114
number so it is not sent on subsequent OE30.1 OE30.2
runs. The charge cannot be changed once OE30.3 OE30.4
is has been sent to billing. OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC530 PO31.1
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
HPR-UNIT-COST Signed 13.5 BL92.1 CX100
Unit Cost This field contains the unit cost. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PC540
PO31.1 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
HPR-PRICE Signed 15.2 BL92.1 CX100
Price This is the unit price of the item CX20.1 CX20.2
charged to the patient. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PC20.1 PO31.1
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
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
|