HCPATPROC – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
HPP
Primary key
OBJ-ID
Fields
22
Updated by
221 programs
Referenced by
1 program

HCPATPROC is a Lawson Inventory Control table (prefix HPP); no description in the lawson data dictionary. It is indexed by OBJ-ID (HPPSET1). It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more and referenced by POI7.1. The table has 22 fields, 1 index and 0 documented relations.

About HCPATPROC

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the HPP- 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
#HPP-OBJ-ID PK
OBJ_ID
Numeric 12—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PATIENT-ID
PATIENT_ID
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-VISIT-NBR
VISIT_NBR
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-CASE-NBR
CASE_NBR
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PROC
PROC
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PROC-DATE
PROC_DATE
Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PHYS-NAME
PHYS_NAME
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-NRS-COORD
NRS_COORD
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-SALES-REP
SALES_REP
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-ORD-NBR
ORD_NBR
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-REQUESTOR
REQUESTOR
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-USERDEF1
USERDEF1
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-USERDEF2
USERDEF2
Alpha 30—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-LOT
LOT
Alpha 20—PO520, RQ23.1, RQ500, RQIF.1
#HPP-SER-NBR
SER_NBR
Alpha 20—PO520, RQ23.1, RQ500, RQIF.1
#HPP-PAT-LAST-NAME
PAT_LAST_NAME
Alpha 60—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PAT-FIRST-NAME
PAT_FIRST_NAME
Alpha 60—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PAT-MIDDLE-NAM
PAT_MIDDLE_NAM
Alpha 60—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-BIRTHDATE
BIRTHDATE
Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-GENDER
GENDER
Alpha 1—
  • M Male
  • F Female
  • O Other
DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-SSN
SSN
Alpha 20—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
#HPP-PROC-MODIFIER
PROC_MODIFIER
Alpha 2—DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more

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
HPPSET1
  1. OBJ-ID
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (221)

Referenced by (1)