HCPATCHRG – Patient Charge

System
Inventory Control (IC)
Prefix
HPR
Primary key
COMPANY, VISIT-NBR, REV-CENTER, FROM-LOCATION, DATE-OF-CHRG, ITEM, CHARGE-SEQ
Fields
15
Updated by
225 programs
Referenced by
2 programs

HCPATCHRG is the Patient Charge table in Lawson Inventory Control (prefix HPR). It is indexed by COMPANY, VISIT-NBR, REV-CENTER, FROM-LOCATION, DATE-OF-CHRG, ITEM, CHARGE-SEQ (HPRSET1); alternate indexes: HPRSET2 and HPRSET3. It is related 1:1 to ICLOCATION, HCCHRGITEM, HCPATVISIT, ICCOMPANY, ITEMLOC and ITEMMAST. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more and referenced by PC210 and PC310. The table has 15 fields, 3 indexes and 6 documented relations.

About HCPATCHRG

This is the Patient Charge file.

Fields (15)

Column = COBOL field name without the HPR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#HPR-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-VISIT-NBR PK
VISIT_NBR		Alpha 12This is the identifier that makes a visit unique with a company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-REV-CENTER PK
REV_CENTER		Alpha 5The revenue center is the department that charges are associated with.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-CHARGE-NBR
CHARGE_NBR		Alpha 80The number used by the patient billing system to charge patients for items used.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-ITEM PK
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-CHARGE-SEQ PK
CHARGE_SEQ		Numeric 4This field contains a sequence number to make a record's key unique.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-DATE-OF-CHRG PK
DATE_OF_CHRG		Numeric 8 (yyyymmdd)This is the date the supply was given to the patient.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-FROM-LOCATION PK
FROM_LOCATION		Alpha 5This field contains the location that was the source of the supplies.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-UPDATE-DATE SET3
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-UPDATE-TIME SET3
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-BATCH-NBR SET3
BATCH_NBR		Numeric 6This is the identifier used to control charges being sent to a patient billing system. This batch number will be blank until the charge has been sent to billing. Then it will contain the batch number so it is not sent on subsequent runs. The charge cannot be changed once is has been sent to billing.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-UNIT-COST
UNIT_COST		Signed 18.5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-PRICE
PRICE		Signed 18.2This is the unit price of the item charged to the patient.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPR-FICA-NBR
FICA_NBR		Alpha 20——

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HPRSET1
  1. COMPANY
  2. VISIT-NBR
  3. REV-CENTER
  4. FROM-LOCATION
  5. DATE-OF-CHRG
  6. ITEM
  7. CHARGE-SEQ
PrimaryPC20.1, PC310, PC320, PC521
HPRSET2
  1. COMPANY
  2. FROM-LOCATION
  3. DATE-OF-CHRG
  4. ITEM
  5. VISIT-NBR
  6. CHARGE-SEQ
PC210
HPRSET3
  1. COMPANY
  2. BATCH-NBR
  3. REV-CENTER
  4. UPDATE-DATE
  5. UPDATE-TIME
  6. VISIT-NBR
  7. CHARGE-SEQ
KeyChangePC530

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICLOCATIONHCCHRGITEMHCPATVISITICCOMPANYITEMLOCITEMMASTHCPATCHRG

One to one (6) — lookups and parents

RelationTableRulesConditionField map
From LocationICLOCATIONRequired
HPR-COMPANY→ICL-COMPANY
HPR-FROM-LOCATION→ICL-LOCATION
HcchrgitemHCCHRGITEMRequired
HPR-COMPANY→HCI-COMPANY
HPR-REV-CENTER→HCI-REV-CENTER
HPR-CHARGE-NBR→HCI-CHARGE-NBR
HPR-ITEM→HCI-ITEM
HcpatvisitHCPATVISITRequired
HPR-COMPANY→HPV-COMPANY
HPR-VISIT-NBR→HPV-VISIT-NBR
IccompanyICCOMPANYRequired
HPR-COMPANY→ICC-COMPANY
ItemlocITEMLOCRequired
HPR-COMPANY→ITL-COMPANY
HPR-FROM-LOCATION→ITL-LOCATION
HPR-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
HPR-ITEM→ITE-ITEM

Programs

Updated by (225)

Referenced by (2)