TASTRUCTUR

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
LP03.1 LP03.2 LP03.3 LP03.4 LP03.5 LP03.6
LP140 LP188 LP198 LP01.1 LP201 LP10.1


UPDATED BY
BN15.1 BN150 ES02.2 HR00.1 HR01.1 HR11.1
HR511 HR55.1 HR55.2 HR55.3 LT101 PR521
EXI2.1 EXI4.1 HS706 LP02.1 LP100 LP101
LP102 LP103 LP130 LP131 LP145 LP180
LP197 LP220 LP231 LP264 LP270 LP31.1
LP331 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 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 PR582 PR80.1 PR80.2
PR80.4 PR82.1 UK102 UK560 ZP530 TA147

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


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
LP03.1 LP03.2
LP03.3 LP03.4
LP03.5 LP03.6
LP101 LP103
LP130 LP201
LP231 LP264
LP270 LP331
LP370 LP63.1
LP63.2 LP64.1
LP64.2 LP64.3
TSTSET2 COMPANY
EMPLOYEE-GROUP
PLAN
BEGIN-DATE*
HR11.1 HR511
HR55.1 HR55.2
HR55.3 LT101
HS706 LP100
LP101 LP102
LP103 LP130
LP131 LP140
LP145 LP180
LP188 LP197
LP220 LP31.1
LP570 LP63.1
LP63.2 LP70.1
LP70.2 LP80.1
PA100 PA52.4
TSTSET3 COMPANY
PLAN
EMPLOYEE-GROUP
BEGIN-DATE*
...
BN150 PR521
EXI2.1 EXI4.1
LP01.1 LP10.1
LP130 LP145
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


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 11:19:48 2016

Home
Contact Us



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