TMLEAVE – No description in the Lawson data dictionary

System
Time and Attendance (TM)
Prefix
TLV
Primary key
COMPANY, PLAN-NAME, EFFECT-DATE
Fields
37
Updated by
0 programs
Referenced by
0 programs

TMLEAVE is a Lawson Time and Attendance table (prefix TLV); no description in the lawson data dictionary. It is indexed by COMPANY, PLAN-NAME, EFFECT-DATE (TLVSET1); alternate indexes: TLVSET2 and TLVSET3. It is related 1:1 to PRSYSTEM, PERSGROUP, PAYCLASS, PRPROCGRP and PRPAYCODE and 1:M to ATCLASS and TMLEAVEDTL. The table has 37 fields, 3 indexes and 8 documented relations.

About TMLEAVE

No description in the Lawson data dictionary.

Fields (37)

Column = COBOL field name without the TLV- 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
#TLV-COMPANY PK
COMPANY		Numeric 4——
#TLV-PLAN-NAME PK
PLAN_NAME		Alpha 10This field contains the plan name.—
#TLV-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.—
#TLV-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)——
#TLV-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.—
#TLV-GROUP-NAME
GROUP_NAME		Alpha 10——
#TLV-PROC-GROUP
PROC_GROUP		Alpha 10——
#TLV-ENT-FROM-DATE
ENT_FROM_DATE		Alpha 2—
  • AJ Adjusted Hire Date
  • AN Anniversary Date
  • HI Hire Date
  • SN Seniority Date
  • X Custom Calculation
—
#TLV-ENT-UNITS
ENT_UNITS		Numeric 5——
#TLV-ENT-UNITS-TYPE
ENT_UNITS_TYPE		Alpha 1—
  • H Hours
  • D Days
  • W Weeks
  • M Months
  • S Semi-Months
—
#TLV-ENT-PAY-CLASS
ENT_PAY_CLASS		Alpha 3——
#TLV-ATTEND-CLASS SET2
ATTEND_CLASS		Alpha 10A user-defined alphanumeric code that represents a group of attendance codes used for reporting and inquiring. Validated in the ATCLASS file.—
#TLV-REM-WAIT-DAYS
REM_WAIT_DAYS		Numeric 5——
#TLV-REM-LIMIT-UNIT
REM_LIMIT_UNIT		Numeric 5——
#TLV-REM-LIMIT-TYPE
REM_LIMIT_TYPE		Alpha 1—
  • H Hours
  • D Days
  • W Weeks
  • M Months
  • Y Years
—
#TLV-REM-LMT-PD-UNT
REM_LMT_PD_UNT		Numeric 5——
#TLV-REM-LMT-PD-TYP
REM_LMT_PD_TYP		Alpha 1—
  • H Hours
  • D Days
  • W Weeks
  • M Months
  • Y Years
—
#TLV-REM-LMT-PD-TIM
REM_LMT_PD_TIM		Alpha 1—
  • C Calendar
  • R Rolling
—
#TLV-REM-HOURS-PCD
REM_HOURS_PCD		Alpha 4——
#TLV-REM-TYPE
REM_TYPE		Alpha 1—
  • H Hours
  • D Days
—
#TLV-PLAN-IND SET3
PLAN_IND		Alpha 1—
  • 1 SSP
  • 2 OSP
  • 3 SMP
  • 4 OMP
  • 5 HOL
  • 6 SPP
  • 7 SAP
  • 8 SPPA
—
#TLV-PLAN-YR-ST-MM
PLAN_YR_ST_MM		Numeric 2——
#TLV-PLAN-YR-ST-DD
PLAN_YR_ST_DD		Numeric 2——
#TLV-PL-STRT-RULES
PL_STRT_RULES		Alpha 1—
  • 1 zero entlmt if abs spans yrend
  • 2 dont zero etlmt if spans yrend
  • X User Exit
—
#TLV-PLAN-ST-LIMIT
PLAN_ST_LIMIT		Numeric 5——
#TLV-PL-LIM-TYPE
PL_LIM_TYPE		Alpha 1——
#TLV-DAY-RATE-S
DAY_RATE_S		Alpha 1—
  • 1 ANN SAL /260
  • 2 ANN SAL /260 *FTE
  • 3 ANN SAL /365
  • 4 ANN SAL /365 *FTE
  • 5 ANN SAL / ANN HOURS
  • 6 ANN SAL / ANN HOURS * FTE
  • X USER DEFINED
—
#TLV-DAY-RATE-H
DAY_RATE_H		Alpha 1—
  • 1 PAY RATE*DAY HRS FROM WPT
  • 2 PAY RATE*DAY HRS FROM WPT*FTE
  • 3 PAY RATE*ANN HOURS/260
  • 4 PAY RATE*ANN HOURS/260*FTE
  • 5 PAY RATE*ANN HOURS/365
  • 6 PAY RATE*ANN HOURS/365*FTE
  • X USER DEFINED
—
#TLV-RETIRE-MALE
RETIRE_MALE		Numeric 2——
#TLV-RETIRE-FEMALE
RETIRE_FEMALE		Numeric 2——
#TLV-EXCL-NQ-PCD
EXCL_NQ_PCD		Alpha 4——
#TLV-PAY-TYPE
PAY_TYPE		Alpha 1—
  • L LUMP SUM
  • W WEEKLY
  • N NORMAL PAY FREQUENCY
  • M MONTHLY
  • 2 BI WEEKLY
  • 4 FOUR WEEKLY
—
#TLV-PAYMENT-DAY
PAYMENT_DAY		Alpha 1—
  • 1 SUNDAY
  • 2 MONDAY
  • 3 TUESDAY
  • 4 WEDNESDAY
  • 5 THURSDAY
  • 6 FRIDAY
  • 7 SATURDAY
—
#TLV-RECOVER-PCT
RECOVER_PCT		Signed 7.2——
#TLV-MPP-START
MPP_START		Numeric 5——
#TLV-MPP-END
MPP_END		Numeric 5——
#TLV-SMP-QW
SMP_QW		Numeric 5——

Indexes (3)

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
TLVSET1
  1. COMPANY
  2. PLAN-NAME
  3. EFFECT-DATE
PrimaryPR20.4
TLVSET2
  1. COMPANY
  2. ATTEND-CLASS
  3. PLAN-NAME
  4. EFFECT-DATE
KeyChange—
TLVSET3
  1. COMPANY
  2. PLAN-IND
  3. EFFECT-DATE
  4. PLAN-NAME
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPERSGROUPPAYCLASSPRPROCGRPPRPAYCODEATCLASSTMLEAVEDTLTMLEAVE

One to one (6) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TLV-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Group NamePERSGROUPRequired
TLV-COMPANY→PRG-COMPANY
TLV-GROUP-NAME→PRG-GROUP-NAME
PayclassPAYCLASSRequired
TLV-COMPANY→PCL-COMPANY
TLV-ENT-PAY-CLASS→PCL-PAY-CLASS
Proc GroupPRPROCGRPRequired
TLV-COMPANY→PRP-COMPANY
TLV-PROC-GROUP→PRP-PROC-GROUP
Spaces→PRP-PROCESS-LEVEL
PrpaycodePRPAYCODERequired
TLV-COMPANY→PCD-COMPANY
TLV-REM-HOURS-PCD→PCD-PAY-CODE
Spaces→PCD-PROCESS-LEVEL
Spaces→PCD-JOB-CODE
PrsystemPRSYSTEMRequired
TLV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
Attend ClassATCLASSRequired
TLV-COMPANY→ACL-COMPANY
TLV-ATTEND-CLASS→ACL-ATTEND-CLASS
—→ACL-ATTEND-CODE
TmleavedtlTMLEAVEDTLDelete Cascades
TLV-COMPANY→TLD-COMPANY
TLV-PLAN-NAME→TLD-PLAN-NAME
—→TLD-REM-UNITS

Programs

No Lawson programs are documented as updating or referencing this table.