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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 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
TSVSET1
  1. COMPANY
  2. SERVICE-CLASS
  3. SERVICE-CODE
PrimaryBN150, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1, LP08.1, LP08.3 +22 more (list truncated in source)
TSVSET2
  1. COMPANY
  2. SERVICE-CODE
  3. SERVICE-CLASS
BN150, PR521, EXI2.1, EXI4.1, LP08.2, LP08.4, LP130, LP199 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TSV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Service ClassTASERVCLSSRequired
TSV-COMPANY→TSL-COMPANY
TSV-SERVICE-CLASS→TSL-SERVICE-CLASS
Service CodeTASERVCODERequired
TSV-COMPANY→TSC-COMPANY
TSV-SERVICE-CODE→TSC-SERVICE-CODE

Programs

Updated by (7)

Referenced by (52)