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.

Field / columnTypeDescription & valuesUpdated by
HPP-OBJ-ID PK
OBJ_ID
Numeric 12DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-PATIENT-ID
PATIENT_ID
Alpha 20DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-VISIT-NBR
VISIT_NBR
Alpha 20DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-CASE-NBR
CASE_NBR
Alpha 20DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-PROC
PROC
Alpha 20DR100, 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 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-NRS-COORD
NRS_COORD
Alpha 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-SALES-REP
SALES_REP
Alpha 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-ORD-NBR
ORD_NBR
Alpha 20DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-REQUESTOR
REQUESTOR
Alpha 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-USERDEF1
USERDEF1
Alpha 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-USERDEF2
USERDEF2
Alpha 30DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-LOT
LOT
Alpha 20PO520, RQ23.1, RQ500, RQIF.1
HPP-SER-NBR
SER_NBR
Alpha 20PO520, RQ23.1, RQ500, RQIF.1
HPP-PAT-LAST-NAME
PAT_LAST_NAME
Alpha 60DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-PAT-FIRST-NAME
PAT_FIRST_NAME
Alpha 60DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-PAT-MIDDLE-NAM
PAT_MIDDLE_NAM
Alpha 60DR100, 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 20DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more
HPP-PROC-MODIFIER
PROC_MODIFIER
Alpha 2DR100, IC141, IC142, IC83.1, PO520, POIJ.1, RQ10.1, RQ10.3 +7 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HPPSET1OBJ-IDPrimaryAP125, 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)