Lawson Insight Technical Documentation |
|
TAPLAN
TAPLAN FILE
REFERENCED BY
BN15.1 BN215 ET700 ES02.2 HR04.2 HR04.3
HR04.7 HR04.8 HR11.1 HR511 HR80.1 HR80.2
HR80.3 HR80.4 HR80.5 HR80.6 HR80.7 HR80.8
HR80.9 HR81.1 HR81.2 HR81.3 HR81.4 HR81.5
HR81.6 HR81.7 HR81.8 HR81.9 HR82.1 HR82.2
HR82.3 HR82.4 HR82.5 HR82.6 HR82.7 HR82.8
HR82.9 HR83.1 HR83.2 HR83.3 HR83.4 HR83.5
HR83.6 HR83.7 HR83.8 HR83.9 HR84.1 HR84.2
HR84.3 HR84.4 HR84.5 HR84.6 HR84.7 HR84.8
HR84.9 HR85.1 HR85.2 HR85.3 HR85.4 HR85.5
HR85.6 HR85.7 HR85.8 HR86.1 HR86.2 HR86.3
HR86.4 HR86.5 HR86.6 HR86.7 HR86.8 HR86.9
HR87.1 HR87.2 HR87.3 HR87.4 HR87.5 HR87.6
HR87.7 HR87.8 HR87.9 HR88.1 HR88.2 HR88.3
HR88.4 HR88.5 HR88.6 HR88.7 HR89.1 HR89.2
HR89.3 HR89.4 HR89.5 HR89.6 HR89.7 HR89.8
HR89.9 HR91.7 LP02.1 LP03.1 LP03.2 LP03.3
LP03.4 LP03.5 LP03.6 LP100 LP101 LP103
LP130 LP138 LP140 LP145 LP15.1 LP180
LP188 LP197 LP201 LP220 LP231 LP240
LP264 LP270 LP31.1 LP32.1 LP32.2 LP32.3
LP331 LP34.1 LP370 LP570 LP63.1 LP63.2
LP64.1 LP64.2 LP70.1 LP70.2 LP80.1 LP88.1
PA100 PA52.4 BN150 ET530 ETI2.1 LP198
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR160 PR180 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 PR37.1 PR45.1 PR529 PR530
PR560 PR80.1 PR80.2 PR82.1 UK102 UK560
TA147
UPDATED BY
LP01.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAP-COMPANY Numeric 4 LP01.1
Element: Company Hr
TAP-PLAN Alpha 10 LP01.1
Element: Ta Plan
TAP-DESCRIPTION Alpha 30 (Lower Case) LP01.1
Element: Ta Description
TAP-STATUS Numeric 1 LP01.1
Element: Ta Status 1 = Active
2 = Inactive
TAP-AUTO-ENROLL Numeric 1 LP01.1
Element: Ta Auto Enroll0 = No
1 = Yes
TAP-BALANCE-TYPE Numeric 1 LP01.1
Element: Ta Balance 1 = Employee group
2 = Position code
TAP-ENROLL-TYPE Numeric 1 LP01.1
Element: Ta Enroll Type1 = Employee Group
2 = Employee group; position code
3 = Employee group; position level
TAP-TABLE-BASIS Numeric 1 LP01.1
Element: Ta Basis 1 = Cycle based
2 = Hours based
TAP-CATEGORY Alpha 10 LP01.1 LP180
Element: Ta Category
TAP-WEB-AVAILABLE Alpha 1 LP01.1
Element: Web Available 1 = Not Available
2 = Available
TAP-WEB-AVAIL-SUPV Alpha 1 LP01.1
Element: Web Avail Supv1 = Not Available
2 = Available
TAP-DATE-STAMP Numeric 8 (yyyymmdd) LP01.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TAP-TIME-STAMP Numeric 6 (hhmmss) LP01.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TAP-USER-ID Alpha 10 (Lower Case) LP01.1
Element: User
TAPLAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TAPSET1 COMPANY BN15.1 BN215
PLAN ET700 ES02.2
HR00.1 HR01.1
HR04.2 HR04.3
HR04.7 HR04.8
HR11.1 HR511
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
...
TAPSET2 COMPANY Subset
PLAN Where (WEB-AVAILABLE = "2" )
TAPSET3 COMPANY Subset
PLAN Where (WEB-AVAIL-SUPV = "2" )
TAPSET4 COMPANY Subset BN150 ET530
PLAN Where (STATUS = 1 ) ETI2.1 HR11.1
HR511 LP100
LP130 LP140
LP145 LP188
LP198 PA100
PA52.4 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR160
PR180 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
TAPLAN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Category PCODES Required
When (TAP-CATEGORY != Spaces )
"TC" -> PCO-TYPE
TAP-CATEGORY -> PCO-CODE
Company PRSYSTEM Required
TAP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
TAPLAN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bn Plan Group BNTAGROUP
TAP-COMPANY -> BTG-COMPANY
TAP-PLAN -> BTG-TA-PLAN
BTG-EMPLOYEE-GROUP
BTG-PLAN-CODE
Bn Ta Employee BNTAEMPBAL Delete Restricted
TAP-COMPANY -> BTE-COMPANY
TAP-PLAN -> BTE-TA-PLAN
BTE-EMPLOYEE-GROUP
BTE-EMPLOYEE
BTE-POSITION
BTE-PLAN-CODE
BTE-START-DATE
Employees TAEEMASTER Delete Restricted
TAP-COMPANY -> TEM-COMPANY
TAP-PLAN -> TEM-PLAN
TEM-EMPLOYEE-GROUP
TEM-EMPLOYEE
TEM-POSITION
Structure TASTRUCTUR
TAP-COMPANY -> TST-COMPANY
TAP-PLAN -> TST-PLAN
TST-EMPLOYEE-GROUP
TST-BEGIN-DATE
|