HRLTMDATA – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LTD
Primary key
COMPANY, EMPLOYEE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR
Fields
83
Updated by
5 programs
Referenced by
0 programs

HRLTMDATA is a Lawson Human Resources table (prefix LTD); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBR (LTDSET1); alternate indexes: LTDSET2, LTDSET3, LTDSET4, LTDSET5 and LTDSET6. It is updated by HLTM.1, HR51.2, HR51.8, HR52.2 and HR751. The table has 83 fields, 6 indexes and 0 documented relations.

About HRLTMDATA

No description in the Lawson data dictionary.

Fields (83)

Column = COBOL field name without the LTD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
LTD-COMPANY PK
COMPANY		Numeric 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-EMPLOYEE PK
EMPLOYEE		Numeric 9—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-DEPARTMENT
DEPARTMENT		Alpha 5—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-PREFIX-TITLE
PREFIX_TITLE		Alpha 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-MIDDLE-NAME
MIDDLE_NAME		Alpha 15 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-LAST-NAME-PRE
LAST_NAME_PRE		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-NICK-NAME
NICK_NAME		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SUFFIX
SUFFIX		Alpha 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-DATE-HIRED
DATE_HIRED		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADJ-HIRE-DATE
ADJ_HIRE_DATE		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-TERM-DATE
TERM_DATE		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-EMP-STATUS
EMP_STATUS		Alpha 2—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SEX
SEX		Alpha 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-BIRTHDATE
BIRTHDATE		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-PERS-ACT-CODE
PERS_ACT_CODE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-REASON-CODE
REASON_CODE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-REASON-CODE2
REASON_CODE2		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADDR1
ADDR1		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADDR2
ADDR2		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADDR3
ADDR3		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADDR4
ADDR4		Alpha 30 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CITY
CITY		Alpha 58 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-STATE
STATE		Alpha 2—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ZIP
ZIP		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-COUNTRY-CODE
COUNTRY_CODE		Alpha 2—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ADDRESS-TYPE
ADDRESS_TYPE		Numeric 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-POSITION
POSITION		Alpha 12—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-JOB-CODE
JOB_CODE		Alpha 9—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-IMA-SUPERVISOR
IMA_SUPERVISOR		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SUPERVISOR-CD
SUPERVISOR_CD		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SUPER-REPORTTO
SUPER_REPORTTO		Alpha 10——
LTD-NBR-FTE
NBR_FTE		Signed 7.6—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WORK-EMAIL
WORK_EMAIL		Alpha 60 (Lower Case)——
LTD-PAY-RATE
PAY_RATE		Signed 13.4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CURR-CODE
CURR_CODE		Alpha 5—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SALARY-CLASS
SALARY_CLASS		Alpha 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-COUNTY
COUNTY		Alpha 25 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-IND-SUPERVISOR
IND_SUPERVISOR		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-HM-PHONE-NBR
HM_PHONE_NBR		Alpha 15—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-REL-TO-ORG
REL_TO_ORG		Alpha 20—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-REL-STATUS
REL_STATUS		Alpha 20—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WORK-TYPE
WORK_TYPE		Alpha 20—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ORG-UNIT
ORG_UNIT		Alpha 20 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-JOB-REQ
JOB_REQ		Numeric 9—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-JOB-APP
JOB_APP		Numeric 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CANDIDATE
CANDIDATE		Numeric 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-LOCATION
LOCATION		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-BARGAIN-UNIT
BARGAIN_UNIT		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-UNION-CODE
UNION_CODE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-EXEMPT-EMP
EXEMPT_EMP		Alpha 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-APPLICANT-ID
APPLICANT_ID		Numeric 9—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-REMOTE
REMOTE		Numeric 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ANNIVERSARY-DT
ANNIVERSARY_DT		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SENIORITY-DT
SENIORITY_DT		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-RECORD-TYPE
RECORD_TYPE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-RECORD-SOURCE
RECORD_SOURCE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CREATE-DATE PK
CREATE_DATE		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CREATE-TIME PK
CREATE_TIME		Numeric 6 (hhmmss)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-CREATE-USER
CREATE_USER		Alpha 10 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-USER-ID
USER_ID		Alpha 10 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SEQ-NBR PK
SEQ_NBR		Numeric 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-ORIGIN-CODE
ORIGIN_CODE		Numeric 2—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WFM-PROCESSED
WFM_PROCESSED		Numeric 1—
  • 0 Not Applicable
  • 1 Unprocessed
  • 2 Error
  • 9 Processed
HLTM.1, HR51.2, HR51.8, HR52.2, HR751
LTD-LTM-PROCESSED
LTM_PROCESSED		Numeric 1—
  • 0 Unprocessed
  • 1 Processed
  • 2 Error
  • 8 Not Applicable
HLTM.1, HR51.2, HR51.8, HR52.2
LTD-USER-CHG-FLAG
USER_CHG_FLAG		Alpha 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-USER-COMMENTS
USER_COMMENTS		Alpha 50 (Lower Case)—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-HIRE-SOURCE
HIRE_SOURCE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-PAY-PLAN
PAY_PLAN		Alpha 4—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-WORK-SCHEDULE
WORK_SCHEDULE		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SHIFT
SHIFT		Numeric 1—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-SECURITY-NBR
SECURITY_NBR		Alpha 10—HLTM.1, HR51.2, HR51.8, HR52.2
LTD-LMS-PROCESSED
LMS_PROCESSED		Numeric 1—
  • 0 Unprocessed
  • 9 Processed
HR51.2, HR51.8, HR52.2

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LTDSET1COMPANY, EMPLOYEE, EFFECT-DATE, CREATE-DATE, CREATE-TIME, SEQ-NBRPrimaryHLTM.1, HR51.2, HR51.8, HR52.2
LTDSET2COMPANY, EMPLOYEE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBRHLTM.1
LTDSET3COMPANY, EMPLOYEE, RECORD-TYPE, CREATE-DATE, CREATE-TIME, SEQ-NBRSubsetWhere LTM-PROCESSED = Zeroes—
LTDSET4COMPANY, RECORD-TYPE, EMPLOYEE, CREATE-DATE, CREATE-TIME, SEQ-NBRSubsetWhere (WFM-PROCESSED = 1) And (RECORD-TYPE = "WFM")HR751
LTDSET5COMPANY, RECORD-TYPE, EMPLOYEE, WFM-PROCESSED, LTM-PROCESSED, CREATE-DATE, CREATE-TIME, SEQ-NBRKeyChangeHR751
LTDSET6COMPANY, EMPLOYEE, CREATE-DATE, CREATE-TIME, SEQ-NBRSubsetWhere LMS-PROCESSED = Zeroes—

Programs

Updated by (5)