Lawson Insight Technical Documentation |
|
TASTRUCTUR
TASTRUCTUR FILE
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 BN150 ET530 ETI2.1 ES02.2 LP01.1
LP03.1 LP03.2 LP03.3 LP03.4 LP03.5 LP03.6
LP101 LP130 LP201 LP231 LP264 LP270
LP331 LP370 LP63.1 LP63.2 LP64.1 LP64.2
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 PR80.1 PR80.2 PR82.1
UK102 UK560 TA147 HR11.1 HR511 HR55.1
HR55.2 HR55.3 LP100 LP140 LP145 LP180
LP188 LP197 LP220 LP31.1 LP570 PA100
PA52.4 LP198 PR160 PR180
UPDATED BY
LP02.1 LP103 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TST-COMPANY Numeric 4 LP02.1
Element: Company Hr
TST-PLAN Alpha 10 LP02.1
Element: Ta Plan
TST-EMPLOYEE-GROUP Alpha 10 LP02.1
Element: Group Name
TST-BEGIN-DATE Numeric 8 (yyyymmdd) LP02.1
Element: Ta Begin Date
TST-END-DATE Numeric 8 (yyyymmdd) LP02.1 LP103
Element: Ta End Date
TST-ACCRUAL-OPTION Numeric 1 LP02.1
Element: Ta Option 1 = Hours
2 = Earnings
3 = Hours and Earnings
TST-CURRENCY-CODE Alpha 5 LP02.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
TST-SERVICE-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-ACCRUAL-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-ELIGIBLE-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-LIMIT-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-PAYROLL-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-GL-RULE Alpha 10 LP02.1
Element: Ta Rule
TST-ROUND-METH-HRS Numeric 1 LP02.1
Element: Ta Method 0 = None
1 = Normal
2 = High
3 = Low
TST-ROUND-TO-HRS Signed 18.6 LP02.1
Element: Ta Round To
TST-ROUND-METH-ERN Numeric 1 LP02.1
Element: Ta Method 0 = None
1 = Normal
2 = High
3 = Low
TST-ROUND-TO-ERN Signed 18.6 LP02.1
Element: Ta Round To
TST-DATE-STAMP Numeric 8 (yyyymmdd) LP02.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TST-TIME-STAMP Numeric 6 (hhmmss) LP02.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TST-USER-ID Alpha 10 (Lower Case) LP02.1
Element: User
TASTRUCTUR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TSTSET1 COMPANY BN15.1 BN150
PLAN ET530 ETI2.1
EMPLOYEE-GROUP ES02.2 HR00.1
BEGIN-DATE HR01.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
LP70.2 LP80.1
...
TSTSET2 COMPANY HR11.1 HR511
EMPLOYEE-GROUP HR55.1 HR55.2
PLAN HR55.3 LP100
BEGIN-DATE* LP101 LP103
LP130 LP140
LP145 LP180
LP188 LP197
LP220 LP31.1
LP570 LP63.1
LP63.2 LP70.1
LP70.2 LP80.1
PA100 PA52.4
TSTSET3 COMPANY LP01.1 LP145
PLAN LP198 PR160
EMPLOYEE-GROUP PR180 PR80.2
BEGIN-DATE*
TASTRUCTUR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|