HCPCS – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
HCC
Primary key
HCPCS-CODE, SEQ-NBR
Fields
5
Updated by
1 program
Referenced by
0 programs

HCPCS is a Lawson Inventory Control table (prefix HCC); no description in the lawson data dictionary. It is indexed by HCPCS-CODE, SEQ-NBR (HCCSET1). It is updated by IC811. The table has 5 fields, 1 index and 0 documented relations.

About HCPCS

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the HCC- 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
#HCC-HCPCS-CODE PK
HCPCS_CODE		Alpha 7—IC811
#HCC-SEQ-NBR PK
SEQ_NBR		Numeric 6—IC811
#HCC-RIC
RIC		Alpha 1—IC811
#HCC-LONG-DESC
LONG_DESC		Alpha 80 (Lower Case)—IC811
#HCC-SHORT-DESC
SHORT_DESC		Alpha 30 (Lower Case)—IC811

Indexes (1)

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
HCCSET1
  1. HCPCS-CODE
  2. SEQ-NBR
PrimaryIC811

Programs

Updated by (1)