HRLTMSUPER – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
LSP- Primary key
COMPANY,CODE,EFFECT-DATE,CREATE-DATE,CREATE-TIME,SEQ-NBR- Fields
- 21
- Updated by
- 3 programs
- Referenced by
- 0 programs
HRLTMSUPER is a Lawson Human Resources table (prefix LSP); no description in the lawson data dictionary. It is indexed by COMPANY, CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR (LSPSET1); alternate indexes: LSPSET2, LSPSET3 and LSPSET4. It is updated by HLTM.1, HR51.5 and HR52.5. The table has 21 fields, 4 indexes and 0 documented relations.
About HRLTMSUPER
No description in the Lawson data dictionary.
Fields (21)
Column = COBOL field name without the LSP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LSP-COMPANY PKCOMPANY | Numeric 4 | — | HLTM.1, HR51.5, HR52.5 |
LSP-CODE PKCODE | Alpha 10 | — | HLTM.1, HR51.5, HR52.5 |
LSP-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.5, HR52.5 |
LSP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | HLTM.1, HR51.5, HR52.5 |
LSP-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | — | HLTM.1, HR51.5, HR52.5 |
LSP-PARENT-SUPERPARENT_SUPER | Alpha 10 | — | HLTM.1, HR51.5, HR52.5 |
LSP-SUPERVISR-TYPESUPERVISR_TYPE | Alpha 10 | — | HLTM.1, HR51.5, HR52.5 |
LSP-RECORD-TYPERECORD_TYPE | Alpha 10 | — | HLTM.1, HR51.5, HR52.5 |
LSP-RECORD-SOURCERECORD_SOURCE | Alpha 10 | — | HLTM.1, HR51.5, HR52.5 |
LSP-CREATE-DATE PKCREATE_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.5, HR52.5 |
LSP-CREATE-TIME PKCREATE_TIME | Numeric 6 (hhmmss) | — | HLTM.1, HR51.5, HR52.5 |
LSP-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | HLTM.1, HR51.5, HR52.5 |
LSP-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.5, HR52.5 |
LSP-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | HLTM.1, HR51.5, HR52.5 |
LSP-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HLTM.1, HR51.5, HR52.5 |
LSP-SEQ-NBR PKSEQ_NBR | Numeric 4 | — | HLTM.1, HR51.5, HR52.5 |
LSP-ORIGIN-CODEORIGIN_CODE | Numeric 2 | — | HLTM.1, HR51.5, HR52.5 |
LSP-WFM-PROCESSEDWFM_PROCESSED | Numeric 1 | — | HLTM.1 |
LSP-LTM-PROCESSEDLTM_PROCESSED | Numeric 1 | — | HLTM.1, HR51.5, HR52.5 |
LSP-USER-CHG-FLAGUSER_CHG_FLAG | Alpha 1 | — | HR51.5, HR52.5 |
LSP-USER-COMMENTSUSER_COMMENTS | Alpha 50 (Lower Case) | — | HR51.5, HR52.5 |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LSPSET1 | COMPANY, CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Primary | HLTM.1, HR51.5, HR52.5 | |
LSPSET2 | COMPANY, CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | HLTM.1 | ||
LSPSET3 | COMPANY, CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where LTM-PROCESSED = Zeroes | — |
LSPSET4 | COMPANY, CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where WFM-PROCESSED = Zeroes | — |