TASERVICE – Service Class & Code Relations

System: Absence Management (LP)
Prefix: TSV
Primary key: COMPANY, SERVICE-CLASS, SERVICE-CODE
Fields: 5
Updated by: 7 programs
Referenced by: 52 programs

TASERVICE is the Service Class & Code Relations table in Lawson Absence Management (prefix TSV). It is indexed by COMPANY, SERVICE-CLASS, SERVICE-CODE (TSVSET1); alternate indexes: TSVSET2. It is related 1:1 to PRSYSTEM, TASERVCLSS and TASERVCODE. It is updated by HR00.1, HR01.1, LP08.1, LP08.2, LP08.3, LP08.4 and LP251 and referenced by BN150, EXI2.1, EXI4.1, LP10.1, LP102, LP130, LP140, LP145 and 44 more. The table has 5 fields, 2 indexes and 3 documented relations.

About TASERVICE

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the TSV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TSV-COMPANY` PK COMPANY	Numeric 4	—	LP08.3, LP08.4
`TSV-SERVICE-CLASS` PK SERVICE_CLASS	Alpha 3	—	LP08.3, LP08.4
`TSV-SERVICE-CODE` PK SERVICE_CODE	Alpha 10	—	LP08.3, LP08.4
`TSV-HOURS-FLAG` HOURS_FLAG	Alpha 1	— `1` Include `2` Exclude `3` Subtract	LP08.3, LP08.4
`TSV-WAGES-FLAG` WAGES_FLAG	Alpha 1	— `1` Include `2` Exclude `3` Subtract	LP08.3, LP08.4

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TSVSET1`	`COMPANY`, `SERVICE-CLASS`, `SERVICE-CODE`	Primary		BN150, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1, LP08.1, LP08.3 +22 more (list truncated in source)
`TSVSET2`	`COMPANY`, `SERVICE-CODE`, `SERVICE-CLASS`			BN150, PR521, EXI2.1, EXI4.1, LP08.2, LP08.4, LP130, LP199 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`TSV-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Service Class	TASERVCLSS	Required	`TSV-COMPANY` → `TSL-COMPANY`, `TSV-SERVICE-CLASS` → `TSL-SERVICE-CLASS`
Service Code	TASERVCODE	Required	`TSV-COMPANY` → `TSC-COMPANY`, `TSV-SERVICE-CODE` → `TSC-SERVICE-CODE`

Programs

Updated by (7)

HR00.1 Company
HR01.1 Process Level
LP08.1 Service Class
LP08.2 Service Code
LP08.3 Service Class and Code Relationships
LP08.4 Service Code and Class Relationships
LP251 Employee Leave of Absence Report

Referenced by (52)

BN150 Life Insurance Reportable Income
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
LP10.1 Link Plan Table
LP102 Employee Master Update
LP130 Absence Plan Payout
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP188 Length of Service Hours Update
LP198 General Ledger Liability Update
LP199 Close Unprocessed Service Records
LP210 Service Class Listing
LP260 Employee Service and Event Report
LP353 Employee Service History Purge
LP60.1 Employee Service Inquiry
LP60.3 Employee Service Totals
PR128 Offset Time Record Creation
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
PR189 Gross Up Calculation
PR29.1 Pension Payment Maintenance
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
PR45.1 Error Processing
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
TA147 Canada Vacation Audit
UK102 Bonus Pay Update