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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TSC-COMPANY PKCOMPANY | Numeric 4 | — | LP08.2 |
#TSC-SERVICE-CODE PKSERVICE_CODE | Alpha 10 | — | LP08.2 |
#TSC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP08.2 |
#TSC-EVENTEVENT | Numeric 1 | —
| LP08.2 |
#TSC-REASON-CODEREASON_CODE | Alpha 4 | — | LP08.2 |
#TSC-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | LP08.2 |
#TSC-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | LP08.2 |
#TSC-STATUSSTATUS | Numeric 1 | —
| LP08.2 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TSCSET1 |
| 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 |
| |||||||
| Currency | CUCODES | Required | When (TSC-CURRENCY-CODE != Spaces) |
| ||||||
| Reason Code | TAREASCODE | Required | When (TSC-REASON-CODE != Spaces) |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ta Service | TASERVICE | Delete Cascades |
|
Programs
Updated by (5)
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