TASERVCODE – Absence Plan Service Code

System: Absence Management (LP)
Prefix: TSC
Primary key: COMPANY, SERVICE-CODE
Fields: 8
Updated by: 5 programs
Referenced by: 81 programs

TASERVCODE is the Absence Plan Service Code table in Lawson Absence Management (prefix TSC). It is indexed by COMPANY, SERVICE-CODE (TSCSET1). It is related 1:1 to PRSYSTEM, CUCODES and TAREASCODE and 1:M to TASERVICE. It is updated by HR00.1, HR01.1, LP08.2, LP09.2 and LP208 and referenced by BN150, ES02.2, EXI2.1, EXI4.1, HR11.1, HR511, LP02.1, LP03.1 and 73 more. The table has 8 fields, 1 index and 4 documented relations.

About TASERVCODE

No description in the Lawson data dictionary.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`TSC-COMPANY` PK COMPANY	Numeric 4	—	LP08.2
`TSC-SERVICE-CODE` PK SERVICE_CODE	Alpha 10	—	LP08.2
`TSC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP08.2
`TSC-EVENT` EVENT	Numeric 1	— `0` No `1` Yes	LP08.2
`TSC-REASON-CODE` REASON_CODE	Alpha 4	—	LP08.2
`TSC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	LP08.2
`TSC-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	LP08.2
`TSC-STATUS` STATUS	Numeric 1	— `0` Active `1` Inactive	LP08.2

Indexes (1)

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
`TSCSET1`	`COMPANY`, `SERVICE-CODE`	Primary		BN150, ES02.2, HR00.1, HR01.1, HR11.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`TSC-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When (TSC-CURRENCY-CODE != Spaces)	`TSC-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Reason Code	TAREASCODE	Required	When (TSC-REASON-CODE != Spaces)	`TSC-COMPANY` → `TRE-COMPANY`, `TSC-REASON-CODE` → `TRE-REASON-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Ta Service	TASERVICE	Delete Cascades		`TSC-COMPANY` → `TSV-COMPANY`, `TSC-SERVICE-CODE` → `TSV-SERVICE-CODE`, → `TSV-SERVICE-CLASS`

Programs

Updated by (5)

HR00.1 Company
HR01.1 Process Level
LP08.2 Service Code
LP09.2 Reason Code
LP208 Service Code Listing

Referenced by (81)

BN150 Life Insurance Reportable Income
ES02.2 Absence Plan Balances Rule
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR511 Employee Conversion
LP02.1 Plan Structure
LP03.1 Service Rule
LP03.2 Accrual Rule
LP03.3 Eligibility Rule
LP03.4 Limit Rule
LP03.5 Payroll Rule
LP03.6 General Ledger Rule
LP10.1 Link Plan Table
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP130 Absence Plan Payout
LP131 Zero Balance Update
LP140 Employee Absence Plan Calculation
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP197 Absence Plan Close
LP199 Close Unprocessed Service Records
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP209 Reason Code Listing
LP210 Service Class Listing
LP260 Employee Service and Event Report
LP262 Employee Event Audit Report
LP31.1 Employee Absence Plan Master
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.1 Employee Service Inquiry
LP80.1 Employee Absence Plan Transfer
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant
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
PR20.4 Pay Code
PR220 Pay Code Listing
PR29.1 Pension Payment Maintenance
PR30.1 Standard 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
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