ACTRLIMIT – Accrual Transaction Limit

System
Event Management (TA)
Prefix
ATL
Primary key
COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC
Fields
5
Updated by
4 programs
Referenced by
2 programs

ACTRLIMIT is the Accrual Transaction Limit table in Lawson Event Management (prefix ATL). It is indexed by COMPANY, PLAN-NAME, LIMIT-TYPE, THRU-LIM-CYC (ATLSET1). It is related 1:1 to PRSYSTEM and PLANMASTER. It is updated by TA20.1, TA20.3, TA20.5 and TA40.1 and referenced by TA220 and ZH230. The table has 5 fields, 1 index and 2 documented relations.

About ACTRLIMIT

The Accrual Transaction Limit file is used with the Time Accrual Plan file to establish accrual and eligible hours limits.

Fields (5)

Column = COBOL field name without the ATL- 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
#ATL-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company.TA20.3, TA20.5, TA40.1
#ATL-PLAN-NAME PK
PLAN_NAME		Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA20.3, TA20.5, TA40.1
#ATL-LIMIT-TYPE PK
LIMIT_TYPE		Alpha 1Contains accrual and eligible limit types.
  • A Accrual
  • E Eligibile
TA20.3, TA20.5, TA40.1
#ATL-THRU-LIM-CYC PK
THRU_LIM_CYC		Numeric 7Contains the last limit cycle for which the accrual limit is effective.TA20.3, TA20.5
#ATL-MAX-BALANCE
MAX_BALANCE		Signed 9.4Contains the maximum number of hours employees can have in their accrual balance during the limit cycle.TA20.3, TA20.5, TA40.1

Indexes (1)

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
ATLSET1
  1. COMPANY
  2. PLAN-NAME
  3. LIMIT-TYPE
  4. THRU-LIM-CYC
PrimaryZH230, TA20.1, TA20.3, TA20.5, TA220, TA40.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
ATL-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Plan NamePLANMASTERRequired
ATL-COMPANY→PLM-COMPANY
ATL-PLAN-NAME→PLM-PLAN-NAME

Programs

Updated by (4)

Referenced by (2)