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.

Field / column	Type	Description & values	Updated by
`TLV-COMPANY` PK COMPANY	Numeric 4	—	—
`TLV-PLAN-NAME` PK PLAN_NAME	Alpha 10	This 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` ATTEND_CLASS	Alpha 10	A 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` 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 RATEDAY HRS FROM WPT `2` PAY RATEDAY HRS FROM WPTFTE `3` PAY RATEANN HOURS/260 `4` PAY RATEANN HOURS/260FTE `5` PAY RATEANN HOURS/365 `6` PAY RATEANN 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`TLVSET1`	`COMPANY`, `PLAN-NAME`, `EFFECT-DATE`	Primary	PR20.4
`TLVSET2`	`COMPANY`, `ATTEND-CLASS`, `PLAN-NAME`, `EFFECT-DATE`	KeyChange	—
`TLVSET3`	`COMPANY`, `PLAN-IND`, `EFFECT-DATE`, `PLAN-NAME`		—

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`TLV-COMPANY` → `PRS-COMPANY (PRSSET1)`, `Spaces` → `PRS-PROCESS-LEVEL`
Group Name	PERSGROUP	Required	`TLV-COMPANY` → `PRG-COMPANY`, `TLV-GROUP-NAME` → `PRG-GROUP-NAME`
Payclass	PAYCLASS	Required	`TLV-COMPANY` → `PCL-COMPANY`, `TLV-ENT-PAY-CLASS` → `PCL-PAY-CLASS`
Proc Group	PRPROCGRP	Required	`TLV-COMPANY` → `PRP-COMPANY`, `TLV-PROC-GROUP` → `PRP-PROC-GROUP`, `Spaces` → `PRP-PROCESS-LEVEL`
Prpaycode	PRPAYCODE	Required	`TLV-COMPANY` → `PCD-COMPANY`, `TLV-REM-HOURS-PCD` → `PCD-PAY-CODE`, `Spaces` → `PCD-PROCESS-LEVEL`, `Spaces` → `PCD-JOB-CODE`
Prsystem	PRSYSTEM	Required	`TLV-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Attend Class	ATCLASS	Required		`TLV-COMPANY` → `ACL-COMPANY`, `TLV-ATTEND-CLASS` → `ACL-ATTEND-CLASS`, → `ACL-ATTEND-CODE`
Tmleavedtl	TMLEAVEDTL	Delete 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.