LPLINK

LP Link Plan Table

REFERENCED BY
BN150 HR11.1 HR511 LT101 LT111 PR521
EXI2.1 EXI4.1 LP03.1 LP03.2 LP03.3 LP03.4
LP03.5 LP03.6 LP100 LP101 LP102 LP103
LP130 LP131 LP151 LP180 LP197 LP201
LP31.1 LP80.1 PA100 PA52.4 PR128 PR131
PR132 PR134 PR135 PR136 PR137 PR189
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR36.4 PR37.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 UK102 TA147


UPDATED BY
LP10.1 LP01.1 LP02.1 LP08.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LNK-COMPANY
Element: Company Hr
Numeric 4
LP10.1
LNK-LINK-PLAN-TB
Element: Ta Table
Alpha 10
LP10.1
LNK-LINK-TB-DESCR
Element: Ta Description
Alpha 30 (Lower Case)
LP10.1
LNK-TABLE-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Hours
02 = Earnings
LP10.1
LNK-ABSENCE-PLAN1
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP1
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD1
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN2
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP2
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD2
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN3
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP3
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD3
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN4
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP4
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD4
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN5
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP5
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD5
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN6
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP6
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD6
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN7
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP7
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD7
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN8
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP8
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD8
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN9
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP9
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD9
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-ABSENCE-PLAN10
Element: Ta Plan
Alpha 10
LP10.1
LNK-EMPLOYEE-GRP10
Element: Group Name
Alpha 10
LP10.1
LNK-LINK-SRV-CD10
Element: Ta Service Cd
Alpha 10
LP10.1
LNK-DATE-STAMP
Element: 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
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP10.1
LNK-USER-ID
Element: User
Alpha 10 (Lower Case)
LP10.1


LPLINK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LNKSET1 COMPANY
LINK-PLAN-TB
TABLE-TYPE
...
BN150 HR11.1
HR511 LT101
LT111 PR521
EXI2.1 EXI4.1
LP01.1 LP02.1
LP03.1 LP03.2
LP03.3 LP03.4
LP03.5 LP03.6
LP08.2 LP10.1
LP100 LP101
LP102 LP103
LP130 LP131
LP151 LP180
LP197 LP201
LP31.1 LP80.1


LPLINK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Absence Plan1 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN1->TAP-PLAN
Absence Plan10 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN10->TAP-PLAN
Absence Plan2 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN2->TAP-PLAN
Absence Plan3 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN3->TAP-PLAN
Absence Plan4 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN4->TAP-PLAN
Absence Plan5 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN5->TAP-PLAN
Absence Plan6 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN6->TAP-PLAN
Absence Plan7 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN7->TAP-PLAN
Absence Plan8 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN8->TAP-PLAN
Absence Plan9 TAPLAN Required
LNK-COMPANY->TAP-COMPANY
LNK-ABSENCE-PLAN9->TAP-PLAN
Company PRSYSTEM Required
LNK-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee Grp1 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP1->PRG-GROUP-NAME
Employee Grp10 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP10->PRG-GROUP-NAME
Employee Grp2 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP2->PRG-GROUP-NAME
Employee Grp3 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP3->PRG-GROUP-NAME
Employee Grp4 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP4->PRG-GROUP-NAME
Employee Grp5 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP5->PRG-GROUP-NAME
Employee Grp6 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP6->PRG-GROUP-NAME
Employee Grp7 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP7->PRG-GROUP-NAME
Employee Grp8 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP8->PRG-GROUP-NAME
Employee Grp9 PERSGROUP Required
LNK-COMPANY->PRG-COMPANY
LNK-EMPLOYEE-GRP9->PRG-GROUP-NAME
Link Srv Cd1 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD1->TSC-SERVICE-CODE
Link Srv Cd10 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD10->TSC-SERVICE-CODE
Link Srv Cd2 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD2->TSC-SERVICE-CODE
Link Srv Cd3 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD3->TSC-SERVICE-CODE
Link Srv Cd4 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD4->TSC-SERVICE-CODE
Link Srv Cd5 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD5->TSC-SERVICE-CODE
Link Srv Cd6 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD6->TSC-SERVICE-CODE
Link Srv Cd7 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD7->TSC-SERVICE-CODE
Link Srv Cd8 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD8->TSC-SERVICE-CODE
Link Srv Cd9 TASERVCODE Required
LNK-COMPANY->TSC-COMPANY
LNK-LINK-SRV-CD9->TSC-SERVICE-CODE


File created: Thu Jun 09 02:22:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.