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
LP198


UPDATED BY
LP02.1 LP103 BN15.1 BN150 ES02.2 HR00.1
HR01.1 PR521 EXI2.1 EXI4.1 LP01.1 LP101
LP130 LP140 LP201 LP231 LP264 LP270
LP271 LP331 LP370 LP63.1 LP63.2 LP64.1
LP64.2 LP64.3 LP70.2 LP70.1 LP80.1 LP88.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
PR80.1 PR80.4 PR80.2 PR82.1 UK102 UK560
TA147 HR11.1 HR511 HR55.1 HR55.2 HR55.3
HS706 LP100 LP102 LP131 LP145 LP180
LP197 LP220 LP31.1 LP570 PA100 PA52.4
LP10.1 PR160 PR180

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
LP101 LP103
LP130 LP140
LP201 LP231
LP264 LP270
LP271 LP331
LP370 LP63.1
LP63.2 LP64.1
LP64.2 LP64.3
LP70.2 LP80.1
LP88.1 PR128
TSTSET2 COMPANY
EMPLOYEE-GROUP
PLAN
BEGIN-DATE*
HR11.1 HR511
HR55.1 HR55.2
HR55.3 HS706
LP100 LP101
LP102 LP103
LP130 LP131
LP140 LP145
LP180 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*
LP01.1 LP10.1
LP145 LP198
PR160 PR180
PR80.2


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: Wed Jun 08 20:50:02 2016

Home
Contact Us



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