HCCHRGITEM – Charge Item

System
Inventory Control (IC)
Prefix
HCI
Primary key
COMPANY, REV-CENTER, CHARGE-NBR, ITEM
Fields
7
Updated by
3 programs
Referenced by
236 programs

HCCHRGITEM is the Charge Item table in Lawson Inventory Control (prefix HCI). It is indexed by COMPANY, REV-CENTER, CHARGE-NBR, ITEM (HCISET1); alternate indexes: HCISET2 and HCISET3. It is related 1:1 to ICCOMPANY and ITEMMAST and 1:M to HCPRCCLASS and ICHCIAUDIT. It is updated by PC10.1, PC120 and PC810 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 228 more. The table has 7 fields, 3 indexes and 4 documented relations.

About HCCHRGITEM

This is the Patient Charge Item cross reference file.

Fields (7)

Column = COBOL field name without the HCI- 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
#HCI-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.PC10.1, PC120, PC810
#HCI-REV-CENTER PK
REV_CENTER		Alpha 5The revenue center is the department that charges are associated with.PC10.1, PC120, PC810
#HCI-CHARGE-NBR PK
CHARGE_NBR		Alpha 80The number used by the patient billing system to charge patients for items used.CX30.1, IC526, PC10.1, PC120, PC810
#HCI-ITEM PK
ITEM		Alpha 32This field contains the item identifier.PC10.1, PC120, PC810
#HCI-PRICE-CLASS
PRICE_CLASS		Alpha 4A code that identifies the rules for calculating a patient charge price.PC10.1, PC120, PC810
#HCI-PRICE
PRICE		Signed 18.2—IC522, IC525, IC526, IC527, PC10.1, PC120, PC810
#HCI-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.PC10.1, PC120, PC810

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
HCISET1
  1. COMPANY
  2. REV-CENTER
  3. CHARGE-NBR
  4. ITEM
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
HCISET2
  1. COMPANY
  2. ITEM
  3. REV-CENTER
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
HCISET3
  1. COMPANY
  2. REV-CENTER
  3. ITEM
IC524

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
HCI-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
HCI-ITEM→ITE-ITEM

One to many (2) — child tables

RelationTableRulesConditionField map
HcprcclassHCPRCCLASSRequiredWhen HCI-PRICE-CLASS != Spaces
ICC-ITEM-GROUP→HPC-ITEM-GROUP
HCI-PRICE-CLASS→HPC-PRICE-CLASS
—→HPC-COST-LIMIT
IchciauditICHCIAUDIT
HCI-COMPANY→HIA-COMPANY
HCI-REV-CENTER→HIA-REV-CENTER
HCI-CHARGE-NBR→HIA-CHARGE-NBR
HCI-ITEM→HIA-ITEM
—→HIA-DATE
—→HIA-TIME
—→HIA-FLD-NBR

Programs

Updated by (3)

Referenced by (236)