TAEMPSERV – Employee LP Service Record

System: Absence Management (LP)
Prefix: TES
Primary key: COMPANY, EMPLOYEE, TES-OBJ-ID
Fields: 38
Updated by: 107 programs
Referenced by: 4 programs

TAEMPSERV is the Employee LP Service Record table in Lawson Absence Management (prefix TES). It is indexed by COMPANY, EMPLOYEE, TES-OBJ-ID (TESSET1); alternate indexes: TESSET10, TESSET11, TESSET2, TESSET3, TESSET4, TESSET5, TESSET6, TESSET7 and 2 more. It is related 1:1 to PRSYSTEM, CUCODES, DEPTCODE, EMPLOYEE, JOBCODE, PAEMPLOYEE, PRPAYCODE, TAREASCODE and 2 more and 1:M to PAPOSITION. It is updated by BN134, BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR02.1, HR06.1 and 99 more and referenced by HR00.1, HR01.1, LP260 and LP61.1. The table has 38 fields, 11 indexes and 13 documented relations.

About TAEMPSERV

No description in the Lawson data dictionary.

Fields (38)

Column = COBOL field name without the TES- 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 / column	Type	Description & values	Updated by
#`TES-COMPANY` PK COMPANY	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-TES-OBJ-ID` PK TES_OBJ_ID	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +36 more
#`TES-SERVICE-CODE` SET11 SERVICE_CODE	Alpha 10	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-EVENT-FLAG` EVENT_FLAG	Numeric 1	— `0` No `1` Yes	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-REASON-CODE` SET11 REASON_CODE	Alpha 4	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP54.1, LP553, LP554 +36 more
#`TES-EVENT-TYPE` EVENT_TYPE	Numeric 1	— `1` Absence `2` Non Absence	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-PLAN-BALANCE` PLAN_BALANCE	Numeric 1	— `0` None `1` Available `2` Reserve	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-SERVICE-STATUS` SET11 SET9 SERVICE_STATUS	Numeric 1	— `0` Created `2` Processed `9` Closed	BN150, EXI2.1, EXI4.1, LP130, LP140, LP197, LP199, LP53.1 +39 more
#`TES-EVENT-STATUS` SET11 SET9 EVENT_STATUS	Numeric 1	— `0` Created `1` Not Processed `2` Processed `9` Closed	BN150, EXI2.1, EXI4.1, LP130, LP140, LP197, LP199, LP53.1 +39 more
#`TES-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Batch `1` Future `2` Current `3` Error `4` Processed `5` Manual `9` Closed	BN150, BN66.1, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554 +45 more
#`TES-TIME-SEQ` TIME_SEQ	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP54.1, LP553, LP554 +36 more
#`TES-EXT-TIME-SEQ` EXT_TIME_SEQ	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-TR-DATE` SET10 SET2 SET3 SET5 SET8 SET9 TR_DATE	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-PER-END-DATE` SET4 SET6 PER_END_DATE	Numeric 8 (yyyymmdd)	Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-PROCESS-LEVEL` SET11 SET3 SET4 SET5 PROCESS_LEVEL	Alpha 5	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-HM-PROC-LEVEL` SET7 HM_PROC_LEVEL	Alpha 5	—	BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#`TES-DEPARTMENT` SET11 SET3 SET4 SET5 DEPARTMENT	Alpha 5	Contains the department.	BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
#`TES-POSITION` SET3 SET4 SET5 POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-JOB-CODE` SET11 SET3 SET4 SET5 JOB_CODE	Alpha 9	Contains a user-defined code that represents a type of job.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-HOURS` HOURS	Signed 7.2	Contains the hours.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +36 more
#`TES-WAGE-AMOUNT` WAGE_AMOUNT	Signed 18.2	—	BN150, BN66.1, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554 +41 more
#`TES-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-PCD-SEQ-NBR` PCD_SEQ_NBR	Numeric 8	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-POINTS` POINTS	Signed 7.2	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP54.1, LP553, LP554 +36 more
#`TES-OCCURRENCE` OCCURRENCE	Alpha 1	— `1` No `2` Yes	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP54.1, LP553, LP554 +36 more
#`TES-DAYS-IND` DAYS_IND	Numeric 1	— `1` Sunday `2` Monday `3` Tuesday `4` Wednesday `5` Thursday `6` Friday `7` Saturday	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
#`TES-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
#`TES-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
#`TES-CREATED-NG-BAL` CREATED_NG_BAL	Alpha 1	— `A` Created by LP Neg Bal Options	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more
#`TES-REQ-OBJ-ID` REQ_OBJ_ID	Numeric 12	—	—
#`TES-RESTORE-DATE` RESTORE_DATE	Numeric 8 (yyyymmdd)	—	LP151
#`TES-ABN-OBJ-ID` ABN_OBJ_ID	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, LP53.1, LP553, LP554, PR128 +35 more

Indexes (11)

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.

Index	Keys	Flags	Condition	Used in
`TESSET1`	`COMPANY` `EMPLOYEE` `TES-OBJ-ID`	Primary		BN134, BN150, BN66.1, HR11.1, PR521, EXI2.1, EXI4.1, LP130 +22 more (list truncated in source)
`TESSET10`	`COMPANY` `EMPLOYEE` `TR-DATE` `TES-OBJ-ID`	KeyChange		LP151, LP251, LP62.1, LP62.2
`TESSET11`	`COMPANY` `PROCESS-LEVEL` `DEPARTMENT` `SERVICE-STATUS` `EVENT-STATUS` `JOB-CODE` `EMPLOYEE` `TES-OBJ-ID` `SERVICE-CODE` `REASON-CODE`	KeyChange		HR00.1, HR01.1, HR02.1, HR06.1, HR506, LT101, LT111, LP08.2 +1 more
`TESSET2`	`COMPANY` `EMPLOYEE` `TR-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where ((STATUS = 2) Or (STATUS = 3) Or (STATUS = 4) Or (STATUS = 5) Or (STATUS = 9)) And (SERVICE-CODE != Spaces)	LP102, LP140
`TESSET3`	`COMPANY` `EMPLOYEE` `POSITION` `JOB-CODE` `PROCESS-LEVEL` `DEPARTMENT` `TR-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where (SERVICE-CODE != Spaces)	LP188
`TESSET4`	`COMPANY` `EMPLOYEE` `POSITION` `JOB-CODE` `PROCESS-LEVEL` `DEPARTMENT` `PER-END-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where ((STATUS = 2) Or (STATUS = 3) Or (STATUS = 4) Or (STATUS = 5) Or (STATUS = 9)) And (SERVICE-CODE != Spaces)	LP140, LP145, LP198
`TESSET5`	`COMPANY` `EMPLOYEE` `POSITION` `JOB-CODE` `PROCESS-LEVEL` `DEPARTMENT` `TR-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where (SERVICE-CODE != Spaces) And (PLAN-BALANCE != Zeroes) And (EVENT-STATUS != 9) And ((STATUS = 2) Or (STATUS = 3) Or (STATUS = 4) Or (STATUS = 5) Or (STATUS = 9))	LP140
`TESSET6`	`COMPANY` `EMPLOYEE` `PER-END-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where ((STATUS = 2) Or (STATUS = 3) Or (STATUS = 4) Or (STATUS = 5) Or (STATUS = 9)) And (SERVICE-CODE != Spaces)	LP140
`TESSET7`	`COMPANY` `HM-PROC-LEVEL` `EMPLOYEE` `TES-OBJ-ID`	KeyChange		HR00.1, HR01.1, LP197
`TESSET8`	`COMPANY` `EMPLOYEE` `TR-DATE` `TES-OBJ-ID`	KeyChange, Subset	Where (SERVICE-STATUS != 9) And (EVENT-STATUS != 9)	BN150, BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +22 more (list truncated in source)
`TESSET9`	`COMPANY` `EMPLOYEE` `TR-DATE` ↓ `TES-OBJ-ID` ↓ `SERVICE-STATUS` `EVENT-STATUS`	KeyChange		LP140, LP260, LP262, LP54.1, LP60.1, LP60.2, LP61.1

Relations

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

One to one (12) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`TES-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Currency

CUCODES

Required

When (TES-CURRENCY-CODE != Spaces)

TES-CURRENCY-CODE → CUC-CURRENCY-CODE

Department

DEPTCODE

Required

When (TES-DEPARTMENT != Spaces)

`TES-COMPANY`	→	`DPT-COMPANY`
`TES-PROCESS-LEVEL`	→	`DPT-PROCESS-LEVEL`
`TES-DEPARTMENT`	→	`DPT-DEPARTMENT`

Employee

EMPLOYEE

Required

`TES-COMPANY`	→	`EMP-COMPANY`
`TES-EMPLOYEE`	→	`EMP-EMPLOYEE`

Hm Proc Level

PRSYSTEM

Required

When TES-HM-PROC-LEVEL != Spaces

`TES-COMPANY`	→	`PRS-COMPANY`
`TES-HM-PROC-LEVEL`	→	`PRS-PROCESS-LEVEL`

Job Code

JOBCODE

Required

When (TES-JOB-CODE != Spaces)

`TES-COMPANY`	→	`JBC-COMPANY`
`TES-JOB-CODE`	→	`JBC-JOB-CODE`

Paemployee

PAEMPLOYEE

Required

`TES-COMPANY`	→	`PEM-COMPANY`
`TES-EMPLOYEE`	→	`PEM-EMPLOYEE`

Pay Code

PRPAYCODE

Required

When TES-PCD-SEQ-NBR != Zeroes

`TES-COMPANY`	→	`PCD-COMPANY`
`TES-PCD-SEQ-NBR`	→	`PCD-SEQ-NBR`

Process Level

PRSYSTEM

Required

When (TES-PROCESS-LEVEL != Spaces)

`TES-COMPANY`	→	`PRS-COMPANY`
`TES-PROCESS-LEVEL`	→	`PRS-PROCESS-LEVEL`

Reason Code

TAREASCODE

Required

When (TES-REASON-CODE != Spaces)

`TES-COMPANY`	→	`TRE-COMPANY`
`TES-REASON-CODE`	→	`TRE-REASON-CODE`

Service Code

TASERVCODE

Required

When (TES-SERVICE-CODE != Spaces)

`TES-COMPANY`	→	`TSC-COMPANY`
`TES-SERVICE-CODE`	→	`TSC-SERVICE-CODE`

Timerecord

TIMERECORD

Not Required

`TES-COMPANY`	→	`TRD-COMPANY`
`TES-EMPLOYEE`	→	`TRD-EMPLOYEE`
`TES-TIME-SEQ`	→	`TRD-TIME-SEQ`

One to many (1) — child tables

Relation Table Rules Condition Field map

Position

PAPOSITION

Valid When (TES-POSITION != Spaces)

`TES-COMPANY`	→	`POS-COMPANY`
`TES-POSITION`	→	`POS-POSITION`
—	→	`POS-EFFECT-DATE`

Programs

Updated by (107)

BN134 Current Flex Time Record Delete
BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
BN66.1 Estimated Pay Calculation
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR02.1 Department
HR06.1 Job Code
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR506 Job Code Conversion
HR511 Employee Conversion
LP08.2 Service Code
LP09.2 Reason Code
LP102 Employee Master Update
LP130 Absence Plan Payout
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP151 FMLA Rolling 12 Month Update
LP188 Length of Service Hours Update
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP199 Close Unprocessed Service Records
LP251 Employee Leave of Absence Report
LP262 Employee Event Audit Report
LP353 Employee Service History Purge
LP53.1 Employee Service Entry
LP54.1 Employee Event History Update
LP553 Employee Service and Event Conversion
LP554 Employee Service and Event History Conversion
LP60.3 Employee Service Totals
LP60.4 Employee Event Totals
LP62.1 Employee Date Calendar
LP62.2 Employee Days Calendar
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR29.1 Pension Payment Maintenance
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR38.1 Time Record Selection
PR39.1 One Time Deduction
PR45.1 Error Processing
PR512 Employee ACH Distribution Interface
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZH510 Update PCP from ZPENDPCP

Referenced by (4)

HR00.1 Company
HR01.1 Process Level
LP260 Employee Service and Event Report
LP61.1 Company Event Inquiry

TAEMPSERV – Employee LP Service Record

About TAEMPSERV

Fields (38) Copy as SQL

Indexes (11)

Relations

One to one (12) — lookups and parents

One to many (1) — child tables

Programs

Updated by (107)

Referenced by (4)

Fields (38)