TALOSHRS – No description in the Lawson data dictionary

System
Absence Management (LP)
Prefix
TLH
Primary key
COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, PLAN-RULE, ACCRUAL-TYPE, YEAR
Fields
13
Updated by
22 programs
Referenced by
1 program

TALOSHRS is a Lawson Absence Management table (prefix TLH); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, PLAN-RULE, ACCRUAL-TYPE, YEAR (TLHSET1); alternate indexes: TLHSET2 and TLHSET3. It is related 1:1 to PRSYSTEM, EMPLOYEE, PERSGROUP, PAEMPLOYEE, TAPLAN and TAEEMASTER and 1:M to PAPOSITION and TASTRUCTUR. It is updated by HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP140 and 14 more and referenced by LP231. The table has 13 fields, 3 indexes and 9 documented relations.

About TALOSHRS

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the TLH- 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
#TLH-COMPANY PK
COMPANY		Numeric 4—LP188, LP88.1
#TLH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.LP188, LP88.1
#TLH-PLAN PK
PLAN		Alpha 10—LP188, LP88.1
#TLH-EMPLOYEE-GROUP PK
EMPLOYEE_GROUP		Alpha 10—LP188, LP88.1
#TLH-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.LP188, LP88.1
#TLH-PLAN-RULE PK
PLAN_RULE		Numeric 2Contains the units of measure for the summarized totals.
  • 01 Accrual
  • 02 Allotment
  • 03 Ongoing Balance Limit
  • 04 Annual Accrual Limit
  • 05 Carryover Limit
  • 06 GL Liability
LP188, LP88.1
#TLH-ACCRUAL-TYPE PK
ACCRUAL_TYPE		Numeric 2—LP188, LP88.1
#TLH-YEAR PK
YEAR		Numeric 4Contains the payroll year in which the allocation was taken.LP188, LP88.1
#TLH-HOURS
HOURS		Signed 7.2Contains the hours.LP188, LP88.1
#TLH-HM-PROC-LEVEL SET3
HM_PROC_LEVEL		Alpha 5—LP188, LP88.1
#TLH-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.LP188, LP88.1
#TLH-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LP188, LP88.1
#TLH-USER-ID
USER_ID		Alpha 10 (Lower Case)—LP188, LP88.1

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
TLHSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. PLAN-RULE
  7. ACCRUAL-TYPE
  8. YEAR
PrimaryHR11.1, HR511, LT101, LT111, LP100, LP101, LP102, LP103 +13 more
TLHSET2
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. PLAN-RULE
  7. ACCRUAL-TYPE
  8. YEAR ↓
LP231, LP88.1, LP88.2
TLHSET3
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PLAN
  5. EMPLOYEE-GROUP
  6. POSITION
  7. PLAN-RULE
  8. ACCRUAL-TYPE
  9. YEAR
KeyChange—

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TLH-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
TLH-COMPANY→EMP-COMPANY
TLH-EMPLOYEE→EMP-EMPLOYEE
Group NamePERSGROUPRequired
TLH-COMPANY→PRG-COMPANY
TLH-EMPLOYEE-GROUP→PRG-GROUP-NAME
Hm Proc LevelPRSYSTEMRequiredWhen TLH-HM-PROC-LEVEL != Spaces
TLH-COMPANY→PRS-COMPANY
TLH-HM-PROC-LEVEL→PRS-PROCESS-LEVEL
PaemployeePAEMPLOYEERequired
TLH-COMPANY→PEM-COMPANY
TLH-EMPLOYEE→PEM-EMPLOYEE
PlanTAPLANRequired
TLH-COMPANY→TAP-COMPANY
TLH-PLAN→TAP-PLAN
TaeemasterTAEEMASTERRequired
TLH-COMPANY→TEM-COMPANY
TLH-EMPLOYEE→TEM-EMPLOYEE
TLH-PLAN→TEM-PLAN
TLH-EMPLOYEE-GROUP→TEM-EMPLOYEE-GROUP
TLH-POSITION→TEM-POSITION

One to many (2) — child tables

RelationTableRulesConditionField map
PositionPAPOSITIONValid When TLH-POSITION != Spaces
TLH-COMPANY→POS-COMPANY
TLH-POSITION→POS-POSITION
—→POS-EFFECT-DATE
TastructurTASTRUCTUR
TLH-COMPANY→TST-COMPANY
TLH-EMPLOYEE-GROUP→TST-EMPLOYEE-GROUP
TLH-PLAN→TST-PLAN
—→TST-BEGIN-DATE

Programs

Updated by (22)

Referenced by (1)