HRINTDELTA – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LID
Primary key
COMPANY, RECORD-TYPE, LTM-OBJ-ID, WORKASSIGNMENT, RCVR-FORM-NAME
Fields
10
Updated by
2 programs
Referenced by
4 programs

HRINTDELTA is a Lawson Human Resources table (prefix LID); no description in the lawson data dictionary. It is indexed by COMPANY, RECORD-TYPE, LTM-OBJ-ID, WORKASSIGNMENT, RCVR-FORM-NAME (LIDSET1). It is updated by LT11.1 and LT111 and referenced by LT22.1, LT22.2, LT22.3 and LT22.4. The table has 10 fields, 1 index and 0 documented relations.

About HRINTDELTA

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the LID- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
LID-COMPANY PK
COMPANY
Numeric 4LT11.1
LID-RECORD-TYPE PK
RECORD_TYPE
Alpha 1
  • E Employee
  • J Job
  • P Position
  • S Supervisor
LT11.1
LID-LTM-OBJ-ID PK
LTM_OBJ_ID
Numeric 13LT11.1
LID-WORKASSIGNMENT PK
WORKASSIGNMENT
Numeric 4LT11.1
LID-RCVR-FORM-NAME PK
RCVR_FORM_NAME
Alpha 22LT11.1
LID-PAD-FLD-NBR
PAD_FLD_NBR
Numeric 4LT11.1
LID-LTF-FLD-NBR
LTF_FLD_NBR
Numeric 4LT11.1
LID-ALPHA-VALUE
ALPHA_VALUE
Alpha 60 (Lower Case)
LID-DATE-VALUE
DATE_VALUE
Numeric 8 (yyyymmdd)
LID-NUMERIC-VALUE
NUMERIC_VALUE
Signed 12.6

Indexes (1)

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

IndexKeysFlagsConditionUsed in
LIDSET1COMPANY, RECORD-TYPE, LTM-OBJ-ID, WORKASSIGNMENT, RCVR-FORM-NAMEPrimaryLT11.1, LT111, LT22.1, LT22.2, LT22.3, LT22.4

Programs

Updated by (2)

Referenced by (4)