TAPLAN

Absence Plan

REFERENCED BY
BN15.1 BN215 ES02.2 HR11.1 HR511 HR93.8
HS17.1 HS19.1 HS19.2 HTAP.1 LT101 LT111
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 LP151 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 LP64.3
LP70.1 LP70.2 LP80.1 LP88.1 PA100 PA52.4
BN150 PR521 EXI2.1 EXI4.1 LP198 PR128
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
PR36.4 PR37.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.2 PR80.4 PR82.1 UK102
TA147


UPDATED BY
LP01.1 HR00.1 HR01.1 HR04.2 HR04.3 HR04.7
HR04.8 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 HR92.3

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
LT111 PR521
EXI2.1 EXI4.1
LP10.1 LP100
LP130 LP140
LP145 LP188
LP198 PA100
PA52.4 PR128
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 02:22:11 2016

Home
Contact Us



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