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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HCISET1COMPANY, REV-CENTER, CHARGE-NBR, ITEMPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
HCISET2COMPANY, ITEM, REV-CENTERAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
HCISET3COMPANY, REV-CENTER, ITEMIC524

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredHCI-COMPANY → ICC-COMPANY
ItemmastITEMMASTRequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, HCI-ITEM → ITE-ITEM

One to many (2) — child tables

RelationTableRulesConditionField map
HcprcclassHCPRCCLASSRequiredWhen HCI-PRICE-CLASS != SpacesICC-ITEM-GROUP → HPC-ITEM-GROUP, HCI-PRICE-CLASS → HPC-PRICE-CLASS, → HPC-COST-LIMIT
IchciauditICHCIAUDITHCI-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)