HRLTMPOS – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
LPO- Primary key
COMPANY,POSITION,EFFECT-DATE,CREATE-DATE,CREATE-TIME,SEQ-NBR- Fields
- 30
- Updated by
- 3 programs
- Referenced by
- 0 programs
HRLTMPOS is a Lawson Human Resources table (prefix LPO); no description in the lawson data dictionary. It is indexed by COMPANY, POSITION, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR (LPOSET1); alternate indexes: LPOSET2, LPOSET3 and LPOSET4. It is updated by HLTM.1, HR51.3 and HR52.3. The table has 30 fields, 4 indexes and 0 documented relations.
About HRLTMPOS
No description in the Lawson data dictionary.
Fields (30)
Column = COBOL field name without the LPO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LPO-COMPANY PKCOMPANY | Numeric 4 | — | HLTM.1, HR51.3, HR52.3 |
LPO-POSITION PKPOSITION | Alpha 12 | — | HLTM.1, HR51.3, HR52.3 |
LPO-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.3, HR52.3 |
LPO-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-POSIT-STATUSPOSIT_STATUS | Numeric 1 | — | HLTM.1, HR51.3, HR52.3 |
LPO-ACTIVE-FLAGACTIVE_FLAG | Numeric 1 | — | HLTM.1, HR51.3, HR52.3 |
LPO-JOB-CODEJOB_CODE | Alpha 9 | — | HLTM.1, HR51.3, HR52.3 |
LPO-ORG-UNITORG_UNIT | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-LOCAT-CODELOCAT_CODE | Alpha 10 | — | HLTM.1, HR51.3, HR52.3 |
LPO-KEY-POS-REASONKEY_POS_REASON | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-CRITCAL-REASONCRITCAL_REASON | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-POSITION-LEVELPOSITION_LEVEL | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-POS-FAMILYPOS_FAMILY | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-POS-CATEGORYPOS_CATEGORY | Alpha 20 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-RECORD-TYPERECORD_TYPE | Alpha 10 | — | HLTM.1, HR51.3, HR52.3 |
LPO-RECORD-SOURCERECORD_SOURCE | Alpha 10 | — | HLTM.1, HR51.3, HR52.3 |
LPO-CREATE-DATE PKCREATE_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.3, HR52.3 |
LPO-CREATE-TIME PKCREATE_TIME | Numeric 6 (hhmmss) | — | HLTM.1, HR51.3, HR52.3 |
LPO-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.3, HR52.3 |
LPO-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | HLTM.1, HR51.3, HR52.3 |
LPO-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HLTM.1, HR51.3, HR52.3 |
LPO-SEQ-NBR PKSEQ_NBR | Numeric 4 | — | HLTM.1, HR51.3, HR52.3 |
LPO-ORIGIN-CODEORIGIN_CODE | Numeric 2 | — | HLTM.1, HR51.3, HR52.3 |
LPO-WFM-PROCESSEDWFM_PROCESSED | Numeric 1 | — | HLTM.1 |
LPO-LTM-PROCESSEDLTM_PROCESSED | Numeric 1 | — | HLTM.1, HR51.3, HR52.3 |
LPO-USER-CHG-FLAGUSER_CHG_FLAG | Alpha 1 | — | HR51.3, HR52.3 |
LPO-USER-COMMENTSUSER_COMMENTS | Alpha 50 (Lower Case) | — | HR51.3, HR52.3 |
LPO-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | — | HLTM.1, HR51.3, HR52.3 |
LPO-DEPARTMENTDEPARTMENT | Alpha 5 | — | HLTM.1, HR51.3, HR52.3 |
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 |
|---|---|---|---|---|
LPOSET1 | COMPANY, POSITION, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Primary | HLTM.1, HR51.3, HR52.3 | |
LPOSET2 | COMPANY, POSITION, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | HLTM.1 | ||
LPOSET3 | COMPANY, POSITION, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where LTM-PROCESSED = Zeroes | — |
LPOSET4 | COMPANY, POSITION, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where WFM-PROCESSED = Zeroes | — |