HRLTMRULE – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LTR
Primary key
COMPANY
Fields
36
Updated by
3 programs
Referenced by
85 programs

HRLTMRULE is a Lawson Human Resources table (prefix LTR); no description in the lawson data dictionary. It is indexed by COMPANY (LTRSET1); alternate indexes: LTRSET2. It is updated by HR50.1, HR55.1 and LT10.1 and referenced by BN305, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1, HPRS.1 and 77 more. The table has 36 fields, 2 indexes and 0 documented relations.

About HRLTMRULE

No description in the Lawson data dictionary.

Fields (36)

Column = COBOL field name without the LTR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#LTR-COMPANY PK
COMPANY
Numeric 4—HR50.1, LT10.1
#LTR-EMPLOYEE-GROUP
EMPLOYEE_GROUP
Alpha 10—HR50.1, LT10.1
#LTR-MLT-NP-POS-IND
MLT_NP_POS_IND
Numeric 1—HR50.1, LT10.1
#LTR-RULE-TYPE SET2
RULE_TYPE
Numeric 1—HR50.1, LT10.1
#LTR-ORG-UNT-SOURCE
ORG_UNT_SOURCE
Numeric 1—HR50.1, LT10.1
#LTR-USER-FIELD
USER_FIELD
Alpha 2—HR50.1, LT10.1
#LTR-EMPLOYEE-ADDR
EMPLOYEE_ADDR
Numeric 1—HR50.1, LT10.1
#LTR-ADDRESS-TYPE
ADDRESS_TYPE
Numeric 1—HR50.1, LT10.1
#LTR-HIRE-ACTION1
HIRE_ACTION1
Alpha 10—HR50.1, LT10.1
#LTR-HIRE-ACTION2
HIRE_ACTION2
Alpha 10—HR50.1, LT10.1
#LTR-HIRE-ACTION3
HIRE_ACTION3
Alpha 10—HR50.1, LT10.1
#LTR-JOB-IF-CODE
JOB_IF_CODE
Alpha 1—HR50.1, LT10.1
#LTR-JOB-AUTO-CRT
JOB_AUTO_CRT
Alpha 1—HR50.1, LT10.1
#LTR-JOB-CLASS-DEST
JOB_CLASS_DEST
Numeric 1—HR50.1, LT10.1
#LTR-JOB-LEVEL
JOB_LEVEL
Alpha 2—HR50.1, LT10.1
#LTR-JOB-FAMILY
JOB_FAMILY
Alpha 2—HR50.1, LT10.1
#LTR-JOB-CATEGORY
JOB_CATEGORY
Alpha 2—HR50.1, LT10.1
#LTR-POS-IF-POSITNS
POS_IF_POSITNS
Alpha 1—HR50.1, LT10.1
#LTR-POS-ACT-STATUS
POS_ACT_STATUS
Numeric 1—HR50.1, LT10.1
#LTR-POS-ORG-U-SRC
POS_ORG_U_SRC
Numeric 1—HR50.1, LT10.1
#LTR-POS-USER-FIELD
POS_USER_FIELD
Alpha 2—HR50.1, LT10.1
#LTR-POS-KEY-REASON
POS_KEY_REASON
Alpha 2—HR50.1, LT10.1
#LTR-POS-CRITCAL-RN
POS_CRITCAL_RN
Alpha 2—HR50.1, LT10.1
#LTR-POS-LEVEL
POS_LEVEL
Alpha 2—HR50.1, LT10.1
#LTR-POS-FAMILY
POS_FAMILY
Alpha 2—HR50.1, LT10.1
#LTR-POS-CATEGORY
POS_CATEGORY
Alpha 2—HR50.1, LT10.1
#LTR-HSU-IF-SUPER
HSU_IF_SUPER
Alpha 1—HR50.1, LT10.1
#LTR-HSU-SUPER-TYPE
HSU_SUPER_TYPE
Numeric 1—HR50.1, LT10.1
#LTR-PEP-IF-EMPOS
PEP_IF_EMPOS
Alpha 1—HR50.1, LT10.1
#LTR-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)—HR50.1, LT10.1
#LTR-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)—HR50.1, LT10.1
#LTR-USER-ID
USER_ID
Alpha 10 (Lower Case)—HR50.1, LT10.1
#LTR-EMP-IF-EMP
EMP_IF_EMP
Alpha 1—
  • 1 No
  • 2 Yes
HR50.1, LT10.1
#LTR-INTERFACE-OPT
INTERFACE_OPT
Numeric 1—
  • 1 LTM
  • 2 WFM
  • 3 Both
HR50.1, LT10.1
#LTR-WFM-JOB-OPTION
WFM_JOB_OPTION
Numeric 1—
  • 1 Jobs
  • 2 Positions
HR50.1, LT10.1
#LTR-WFM-WORK-OPT
WFM_WORK_OPT
Numeric 1—
  • 1 Pay Plan
  • 2 Work Schedule
—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LTRSET1
  1. COMPANY
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
LTRSET2
  1. COMPANY
  2. RULE-TYPE
—

Programs

Updated by (3)

Referenced by (85)