LPLINK – LP Link Plan Table

System
Absence Management (LP)
Prefix
LNK
Primary key
COMPANY, LINK-PLAN-TB, TABLE-TYPE
Fields
37
Updated by
4 programs
Referenced by
63 programs

LPLINK is the LP Link Plan Table table in Lawson Absence Management (prefix LNK). It is indexed by COMPANY, LINK-PLAN-TB, TABLE-TYPE (LNKSET1). It is related 1:1 to TAPLAN, PRSYSTEM, PERSGROUP and TASERVCODE. It is updated by LP01.1, LP02.1, LP08.2 and LP10.1 and referenced by BN150, EXI2.1, EXI4.1, HR11.1, HR511, LP03.1, LP03.2, LP03.3 and 55 more. The table has 37 fields, 1 index and 31 documented relations.

About LPLINK

No description in the Lawson data dictionary.

Fields (37)

Column = COBOL field name without the LNK- 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
#LNK-COMPANY PK
COMPANY		Numeric 4—LP10.1
#LNK-TABLE-TYPE PK
TABLE_TYPE		Numeric 2Contains the units of measure for the summarized totals.
  • 01 Hours
  • 02 Earnings
LP10.1
#LNK-ABSENCE-PLAN1
ABSENCE_PLAN1		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP1
EMPLOYEE_GRP1		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN2
ABSENCE_PLAN2		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP2
EMPLOYEE_GRP2		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN3
ABSENCE_PLAN3		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP3
EMPLOYEE_GRP3		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN4
ABSENCE_PLAN4		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP4
EMPLOYEE_GRP4		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN5
ABSENCE_PLAN5		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP5
EMPLOYEE_GRP5		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN6
ABSENCE_PLAN6		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP6
EMPLOYEE_GRP6		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN7
ABSENCE_PLAN7		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP7
EMPLOYEE_GRP7		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN8
ABSENCE_PLAN8		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP8
EMPLOYEE_GRP8		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN9
ABSENCE_PLAN9		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP9
EMPLOYEE_GRP9		Alpha 10—LP10.1
#LNK-ABSENCE-PLAN10
ABSENCE_PLAN10		Alpha 10—LP10.1
#LNK-EMPLOYEE-GRP10
EMPLOYEE_GRP10		Alpha 10—LP10.1
#LNK-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.LP10.1
#LNK-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LP10.1
#LNK-USER-ID
USER_ID		Alpha 10 (Lower Case)—LP10.1

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.

IndexKeysFlagsConditionUsed in
LNKSET1
  1. COMPANY
  2. LINK-PLAN-TB
  3. TABLE-TYPE
PrimaryBN150, HR11.1, HR511, LT101, LT111, PR521, EXI2.1, EXI4.1 +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)
TAPLANPRSYSTEMPERSGROUPTASERVCODELPLINK

One to one (31) — lookups and parents

RelationTableRulesConditionField map
Absence Plan1TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN1→TAP-PLAN
Absence Plan10TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN10→TAP-PLAN
Absence Plan2TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN2→TAP-PLAN
Absence Plan3TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN3→TAP-PLAN
Absence Plan4TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN4→TAP-PLAN
Absence Plan5TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN5→TAP-PLAN
Absence Plan6TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN6→TAP-PLAN
Absence Plan7TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN7→TAP-PLAN
Absence Plan8TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN8→TAP-PLAN
Absence Plan9TAPLANRequired
LNK-COMPANY→TAP-COMPANY
LNK-ABSENCE-PLAN9→TAP-PLAN
CompanyPRSYSTEMRequired
LNK-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Employee Grp1PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP1→PRG-GROUP-NAME
Employee Grp10PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP10→PRG-GROUP-NAME
Employee Grp2PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP2→PRG-GROUP-NAME
Employee Grp3PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP3→PRG-GROUP-NAME
Employee Grp4PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP4→PRG-GROUP-NAME
Employee Grp5PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP5→PRG-GROUP-NAME
Employee Grp6PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP6→PRG-GROUP-NAME
Employee Grp7PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP7→PRG-GROUP-NAME
Employee Grp8PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP8→PRG-GROUP-NAME
Employee Grp9PERSGROUPRequired
LNK-COMPANY→PRG-COMPANY
LNK-EMPLOYEE-GRP9→PRG-GROUP-NAME
Link Srv Cd1TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD1→TSC-SERVICE-CODE
Link Srv Cd10TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD10→TSC-SERVICE-CODE
Link Srv Cd2TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD2→TSC-SERVICE-CODE
Link Srv Cd3TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD3→TSC-SERVICE-CODE
Link Srv Cd4TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD4→TSC-SERVICE-CODE
Link Srv Cd5TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD5→TSC-SERVICE-CODE
Link Srv Cd6TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD6→TSC-SERVICE-CODE
Link Srv Cd7TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD7→TSC-SERVICE-CODE
Link Srv Cd8TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD8→TSC-SERVICE-CODE
Link Srv Cd9TASERVCODERequired
LNK-COMPANY→TSC-COMPANY
LNK-LINK-SRV-CD9→TSC-SERVICE-CODE

Programs

Updated by (4)

Referenced by (63)