HRLTMEMPOS – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
LPP- Primary key
COMPANY,EMPLOYEE,POS-LEVEL,EFFECT-DATE,CREATE-DATE,CREATE-TIME,SEQ-NBR- Fields
- 43
- Updated by
- 3 programs
- Referenced by
- 0 programs
HRLTMEMPOS is a Lawson Human Resources table (prefix LPP); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR (LPPSET1); alternate indexes: LPPSET2, LPPSET3 and LPPSET4. It is updated by HLTM.1, HR51.6 and HR52.6. The table has 43 fields, 4 indexes and 0 documented relations.
About HRLTMEMPOS
No description in the Lawson data dictionary.
Fields (43)
Column = COBOL field name without the LPP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LPP-COMPANY PKCOMPANY | Numeric 4 | — | HLTM.1, HR51.6, HR52.6 |
LPP-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | HLTM.1, HR51.6, HR52.6 |
LPP-POS-LEVEL PKPOS_LEVEL | Numeric 2 | — | HLTM.1, HR51.6, HR52.6 |
LPP-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | — | HLTM.1, HR51.6, HR52.6 |
LPP-DEPARTMENTDEPARTMENT | Alpha 5 | — | HLTM.1, HR51.6, HR52.6 |
LPP-POSITIONPOSITION | Alpha 12 | — | HLTM.1, HR51.6, HR52.6 |
LPP-JOB-CODEJOB_CODE | Alpha 9 | — | HLTM.1, HR51.6, HR52.6 |
LPP-SUPERVISORSUPERVISOR | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-SUPERVISOR-INDSUPERVISOR_IND | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-IS-SUPERVISORIS_SUPERVISOR | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-LOCAT-CODELOCAT_CODE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-NBR-FTENBR_FTE | Signed 7.6 | — | HLTM.1, HR51.6, HR52.6 |
LPP-PAY-RATEPAY_RATE | Signed 13.4 | — | HLTM.1, HR51.6, HR52.6 |
LPP-CURRENCY-CODECURRENCY_CODE | Alpha 5 | — | HLTM.1, HR51.6, HR52.6 |
LPP-PERS-ACT-CODEPERS_ACT_CODE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-REASON-CODEREASON_CODE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-REASON-CODE2REASON_CODE2 | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-ORG-UNITORG_UNIT | Alpha 20 (Lower Case) | — | HLTM.1, HR51.6, HR52.6 |
LPP-UNION-CODEUNION_CODE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-BARGAIN-UNITBARGAIN_UNIT | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-DATE-ASSIGNDATE_ASSIGN | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-POS-EFF-DTPOS_EFF_DT | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-JOB-REQJOB_REQ | Alpha 20 | — | HLTM.1, HR51.6, HR52.6 |
LPP-JOB-APPJOB_APP | Alpha 20 | — | HLTM.1, HR51.6, HR52.6 |
LPP-CANDIDATECANDIDATE | Alpha 20 | — | HLTM.1, HR51.6, HR52.6 |
LPP-RECORD-TYPERECORD_TYPE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-RECORD-SOURCERECORD_SOURCE | Alpha 10 | — | HLTM.1, HR51.6, HR52.6 |
LPP-CREATE-DATE PKCREATE_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-CREATE-TIME PKCREATE_TIME | Numeric 6 (hhmmss) | — | HLTM.1, HR51.6, HR52.6 |
LPP-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | HLTM.1, HR51.6, HR52.6 |
LPP-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.6, HR52.6 |
LPP-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | HLTM.1, HR51.6, HR52.6 |
LPP-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HLTM.1 |
LPP-SEQ-NBR PKSEQ_NBR | Numeric 4 | — | HLTM.1, HR51.6, HR52.6 |
LPP-ORIGIN-CODEORIGIN_CODE | Numeric 2 | — | HLTM.1, HR51.6, HR52.6 |
LPP-WFM-PROCESSEDWFM_PROCESSED | Numeric 1 | — | HLTM.1 |
LPP-LTM-PROCESSEDLTM_PROCESSED | Numeric 1 | — | HLTM.1, HR51.6, HR52.6 |
LPP-USER-CHG-FLAGUSER_CHG_FLAG | Alpha 1 | — | HLTM.1, HR51.6, HR52.6 |
LPP-USER-COMMENTSUSER_COMMENTS | Alpha 50 (Lower Case) | — | HLTM.1, HR51.6, HR52.6 |
LPP-WORK-SCHEDULEWORK_SCHEDULE | Alpha 10 | — | — |
LPP-SHIFTSHIFT | Numeric 1 | — | — |
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 |
|---|---|---|---|---|
LPPSET1 | COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Primary | HLTM.1, HR51.6, HR52.6 | |
LPPSET2 | COMPANY, EMPLOYEE, POS-LEVEL, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | — | ||
LPPSET3 | COMPANY, EMPLOYEE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where LTM-PROCESSED = Zeroes | HLTM.1 |
LPPSET4 | COMPANY, EMPLOYEE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where WFM-PROCESSED = Zeroes | — |