TASTRUCTUR

Absence Plan Structure

Plan Structure is used to assign a specific set of rules to each Accrual Plan and Employee Group combination. This allows different rules to be applied to different employee goups within the same accrual plan. The only rule that is not required is the general ledger rule.

REFERENCED BY
BN15.1 ES02.2 LP01.1 LP180 LP201 LP231
LP264 LP270 LP331 LP370 LP63.1 LP63.2
LP64.1 LP64.2 LP64.3 LP70.2 LP70.1 LP80.1
LP88.1 HR55.1 HR55.2 HR55.3 HS19.1 HS706
LP102 LP131 LP140 LP151 LP197 LP220
LP31.1 LP570 PR160 PR180


UPDATED BY
LP02.1 LP02.2 LP103 BN150 HR00.1 HR01.1
PR521 EXI2.1 EXI4.1 LP03.1 LP03.2 LP03.3
LP03.4 LP03.5 LP03.6 LP101 LP130 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 HR11.1 HR511
LT101 LT111 LP100 LP145 LP188 PA100
PA52.4 LP10.1 LP198

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TST-COMPANY
Element: Company Hr		Numeric 4
LP02.1
TST-PLAN
Element: Ta Plan		Alpha 10
LP02.1
TST-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
LP02.1
TST-BEGIN-DATE
Element: Ta Begin Date		Numeric 8 (yyyymmdd)
LP02.1
TST-END-DATE
Element: Ta End Date		Numeric 8 (yyyymmdd)
LP02.1 LP103
TST-ACCRUAL-OPTION
Element: Ta Option		Numeric 1

1 = Hours
2 = Earnings
3 = Hours and Earnings
LP02.1
TST-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
LP02.1
TST-SERVICE-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-ACCRUAL-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-ELIGIBLE-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-LIMIT-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-PAYROLL-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-GL-RULE
Element: Ta Rule		Alpha 10
LP02.1
TST-ROUND-METH-HRS
Element: Ta Method		Numeric 1

0 = None
1 = Normal
2 = High
3 = Low
LP02.1
TST-ROUND-TO-HRS
Element: Ta Round To		Signed 18.6
LP02.1
TST-ROUND-METH-ERN
Element: Ta Method		Numeric 1

0 = None
1 = Normal
2 = High
3 = Low
LP02.1
TST-ROUND-TO-ERN
Element: Ta Round To		Signed 18.6
LP02.1
TST-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.
LP02.1 LP103
TST-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP02.1 LP103
TST-USER-ID
Element: User		Alpha 10 (Lower Case)
LP02.1 LP103
TST-BAL-TRANSFER
Element: Ta Option		Numeric 1
LP02.2


TASTRUCTUR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TSTSET1 COMPANY
PLAN
EMPLOYEE-GROUP
BEGIN-DATE
...
BN15.1 BN150
ES02.2 HR00.1
HR01.1 PR521
EXI2.1 EXI4.1
LP01.1 LP02.1
LP02.2 LP03.1
LP03.2 LP03.3
LP03.4 LP03.5
LP03.6 LP101
LP103 LP130
LP180 LP201
LP231 LP264
LP270 LP331
LP370 LP63.1
LP63.2 LP64.1
TSTSET2 COMPANY
EMPLOYEE-GROUP
PLAN
BEGIN-DATE*
...
HR11.1 HR511
HR55.1 HR55.2
HR55.3 HS19.1
LT101 LT111
HS706 LP100
LP101 LP102
LP103 LP130
LP131 LP140
LP145 LP151
LP180 LP188
LP197 LP220
LP31.1 LP570
LP63.1 LP63.2
LP70.1 LP70.2
LP80.1 PA100
TSTSET3 COMPANY
PLAN
EMPLOYEE-GROUP
BEGIN-DATE*
...
BN150 PR521
EXI2.1 EXI4.1
LP01.1 LP10.1
LP130 LP145
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


TASTRUCTUR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accrual Rule TAACCRUAL Required
TST-COMPANY->TAR-COMPANY
TST-ACCRUAL-RULE->TAR-ACCRUAL-RULE
Company PRSYSTEM Required
TST-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (TST-CURRENCY-CODE !=Spaces )
TST-CURRENCY-CODE->CUC-CURRENCY-CODE
Eligible Rule TAELIGIBLE Required
When (TST-ELIGIBLE-RULE !=Spaces )
TST-COMPANY->TEG-COMPANY
TST-ELIGIBLE-RULE->TEG-ELIGIBLE-RULE
Employee Group PERSGROUP Required
TST-COMPANY->PRG-COMPANY
TST-EMPLOYEE-GROUP->PRG-GROUP-NAME
Gl Rule TAGENLEDGR Required
When (TST-GL-RULE !=Spaces )
TST-COMPANY->TGE-COMPANY
TST-GL-RULE->TGE-GL-RULE
Limit Rule TALIMIT Required
TST-COMPANY->TLM-COMPANY
TST-LIMIT-RULE->TLM-LIMIT-RULE
Payroll Rule TAPAYROLL Required
When (TST-PAYROLL-RULE !=Spaces )
TST-COMPANY->TPR-COMPANY
TST-PAYROLL-RULE->TPR-PAYROLL-RULE
Plan TAPLAN Required
TST-COMPANY->TAP-COMPANY
TST-PLAN->TAP-PLAN
Service Rule TASERVRULE Required
TST-COMPANY->TSR-COMPANY
TST-SERVICE-RULE->TSR-SERVICE-RULE


TASTRUCTUR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bn Plan Group BNTAGROUP
TST-COMPANY->BTG-COMPANY
TST-PLAN->BTG-TA-PLAN
TST-EMPLOYEE-GROUP->BTG-EMPLOYEE-GROUP
  BTG-PLAN-CODE
Bn Ta Employee BNTAEMPBAL
TST-COMPANY->BTE-COMPANY
TST-PLAN->BTE-TA-PLAN
TST-EMPLOYEE-GROUP->BTE-EMPLOYEE-GROUP
  BTE-EMPLOYEE
  BTE-POSITION
  BTE-PLAN-CODE
  BTE-START-DATE
Taeemaster TAEEMASTER Delete Restricted
TST-COMPANY->TEM-COMPANY
TST-PLAN->TEM-PLAN
TST-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
  TEM-EMPLOYEE
  TEM-POSITION

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

Home
Contact Us



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