TAPLAN

REFERENCED BY
BN15.1 BN150 BN215 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 HR92.1 HR92.2 HR93.8 HS17.1
LT101 PR521 EXI2.1 EXI4.1 HS706 LP03.1
LP03.2 LP03.3 LP03.4 LP03.5 LP03.6 LP100
LP101 LP102 LP103 LP130 LP131 LP138
LP140 LP145 LP180 LP188 LP197 LP220
LP240 LP264 LP270 LP31.1 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 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 ZP530 TA147
HTAP.1 LP02.1 LP10.1 LP15.1 LP201 LP32.1
LP32.2 LP32.3


UPDATED BY
HR00.1 HR01.1 LP01.1 LP198 LP231 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 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
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 LT101
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


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: Thu Jun 09 11:19:47 2016

Home
Contact Us



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