HRLTMJOBCD – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
LTJ- Primary key
COMPANY,JOB-CODE,EFFECT-DATE,CREATE-DATE,CREATE-TIME,SEQ-NBR- Fields
- 22
- Updated by
- 3 programs
- Referenced by
- 0 programs
HRLTMJOBCD is a Lawson Human Resources table (prefix LTJ); no description in the lawson data dictionary. It is indexed by COMPANY, JOB-CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR (LTJSET1); alternate indexes: LTJSET2, LTJSET3 and LTJSET4. It is updated by HLTM.1, HR51.4 and HR52.4. The table has 22 fields, 4 indexes and 0 documented relations.
About HRLTMJOBCD
No description in the Lawson data dictionary.
Fields (22)
Column = COBOL field name without the LTJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LTJ-COMPANY PKCOMPANY | Numeric 4 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-JOB-CODE PKJOB_CODE | Alpha 9 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-JOB-LEVELJOB_LEVEL | Alpha 20 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-JOB-FAMILYJOB_FAMILY | Alpha 20 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-JOB-CATEGORYJOB_CATEGORY | Alpha 20 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-RECORD-TYPERECORD_TYPE | Alpha 10 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-RECORD-SOURCERECORD_SOURCE | Alpha 10 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-CREATE-DATE PKCREATE_DATE | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-CREATE-TIME PKCREATE_TIME | Numeric 6 (hhmmss) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HLTM.1, HR51.4, HR52.4 |
LTJ-SEQ-NBR PKSEQ_NBR | Numeric 4 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-ORIGIN-CODEORIGIN_CODE | Numeric 2 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-WFM-PROCESSEDWFM_PROCESSED | Numeric 1 | — | — |
LTJ-LTM-PROCESSEDLTM_PROCESSED | Numeric 1 | — | HLTM.1, HR51.4, HR52.4 |
LTJ-USER-CHG-FLAGUSER_CHG_FLAG | Alpha 1 | — | HR51.4, HR52.4 |
LTJ-USER-COMMENTSUSER_COMMENTS | Alpha 50 (Lower Case) | — | HR51.4, HR52.4 |
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 |
|---|---|---|---|---|
LTJSET1 | COMPANY, JOB-CODE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Primary | HLTM.1, HR51.4, HR52.4 | |
LTJSET2 | COMPANY, JOB-CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | HLTM.1 | ||
LTJSET3 | COMPANY, JOB-CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where LTM-PROCESSED = Zeroes | — |
LTJSET4 | COMPANY, JOB-CODE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBR | Subset | Where WFM-PROCESSED = Zeroes | — |