TAPLAN

REFERENCED BY
BN15.1 BN215 ES02.2 HR11.1 HR511 HR93.8
HS706 LP02.1 LP03.1 LP03.2 LP03.3 LP03.4
LP03.5 LP03.6 LP10.1 LP100 LP101 LP102
LP103 LP130 LP131 LP138 LP140 LP145
LP15.1 LP180 LP188 LP197 LP220 LP240
LP264 LP270 LP271 LP31.1 LP32.1 LP32.2
LP32.3 LP331 LP34.1 LP370 LP570 LP63.1
LP63.2 LP64.1 LP64.2 LP64.3 LP70.1 LP70.2
LP80.1 LP88.1 PA100 PA52.4 BN150 PR521
EXI2.1 EXI4.1 PR128 PR130 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 PR37.1 PR45.1 PR529 PR530
PR560 PR582 PR82.1 UK102 UK560 TA147


UPDATED BY
LP01.1 HR00.1 HR01.1 HTAP.1 LP201 LP231
LP198 PR160 PR180 PR80.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAP-COMPANY
Element: Company Hr		Numeric 4
LP01.1
TAP-PLAN
Element: Ta Plan		Alpha 10
LP01.1
TAP-DESCRIPTION
Element: Ta Description		Alpha 30 (Lower Case)
LP01.1
TAP-STATUS
Element: Ta Status		Numeric 1

1 = Active
2 = Inactive
LP01.1
TAP-AUTO-ENROLL
Element: Ta Auto Enroll		Numeric 1

0 = No
1 = Yes
LP01.1
TAP-BALANCE-TYPE
Element: Ta Balance		Numeric 1

1 = Employee group
2 = Position code
LP01.1
TAP-ENROLL-TYPE
Element: Ta Enroll Type		Numeric 1

1 = Employee Group
2 = Employee group; position code
3 = Employee group; position level
LP01.1
TAP-TABLE-BASIS
Element: Ta Basis		Numeric 1

1 = Cycle based
2 = Hours based
LP01.1
TAP-CATEGORY
Element: Ta Category		Alpha 10
LP01.1 LP180
TAP-WEB-AVAILABLE
Element: Web Available		Alpha 1

1 = Not Available
2 = Available
LP01.1
TAP-WEB-AVAIL-SUPV
Element: Web Avail Supv		Alpha 1

1 = Not Available
2 = Available
LP01.1
TAP-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.
LP01.1
TAP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP01.1
TAP-USER-ID
Element: User		Alpha 10 (Lower Case)
LP01.1


TAPLAN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TAPSET1 COMPANY
PLAN
...
BN15.1 BN215
ES02.2 HR00.1
HR01.1 HR11.1
HR511 HR93.8
HTAP.1 HS706
LP01.1 LP02.1
LP03.1 LP03.2
LP03.3 LP03.4
LP03.5 LP03.6
LP10.1 LP100
LP101 LP102
LP103 LP130
LP131 LP138
LP140 LP145
LP15.1 LP180
TAPSET2 COMPANY
PLAN
Subset
Where(WEB-AVAILABLE ="2")
TAPSET3 COMPANY
PLAN
Subset
Where(WEB-AVAIL-SUPV ="2")
TAPSET4 COMPANY
PLAN
Subset
Where(STATUS =1)
...
BN150 HR11.1
HR511 PR521
EXI2.1 EXI4.1
LP10.1 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


TAPLAN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:50:02 2016

Home
Contact Us



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