Lawson Insight Technical Documentation |
|
TATABLE
TATABLE FILE
REFERENCED BY
HR11.1 HR511 LP02.1 LP03.1 LP03.2 LP03.3
LP03.4 LP03.5 LP03.6 LP07.1 LP08.1 LP100
LP101 LP140 LP145 LP180 LP197 LP198
LP201 LP203 LP204 LP31.1 LP80.1 PA100
PA52.4 LP188
UPDATED BY
LP04.2 LP04.3 LP04.4 LP04.5 LP04.6 LP04.7
LP04.8 LP04.9 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TBL-COMPANY Numeric 4 LP04.2 LP04.3
Element: Company Hr LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TABLE Alpha 10 LP04.2 LP04.3
Element: Ta Table LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-DESCRIPTION Alpha 30 (Lower Case) LP04.2 LP04.3
Element: Ta Description LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-EFFECTIVE-DATE Numeric 8 (yyyymmdd) LP04.2 LP04.3
Element: Ta Begin Date LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TABLE-TYPE Numeric 2 LP04.2 LP04.3
Element: Ta Type Contains the units of measure for the LP04.4 LP04.5
summarized totals. LP04.6 LP04.7
01 = Hours LP04.8 LP04.9
02 = Earnings
TBL-TABLE-BASIS Numeric 1 LP04.2 LP04.3
Element: Ta Basis 1 = Cycle LP04.4 LP04.5
2 = Hours LP04.6 LP04.7
LP04.8 LP04.9
TBL-RULE-TYPE Numeric 2 LP04.2 LP04.3
Element: Ta Type Contains the units of measure for the LP04.4 LP04.5
summarized totals. LP04.6 LP04.7
01 = Accrual LP04.8 LP04.9
02 = Allotment
03 = Limit
04 = GL
TBL-CYCLE-FREQ Numeric 2 LP04.2 LP04.3
Element: Ta Frequency 01 = Weekly LP04.4 LP04.5
02 = Biweekly
03 = Semimonthly
04 = Four weekly
05 = Monthly
06 = Bimonthly
07 = Quarterly
08 = Four monthly
09 = Semiannually
10 = Annually
TBL-CYCLE-SRV-TYPE Numeric 2 LP04.2 LP04.3
Element: Ta Type Contains the units of measure for the LP04.4 LP04.5
summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp grp; position
TBL-HOURS-SRV-CLS Alpha 3 LP04.6 LP04.7
Element: Ta Service Cls LP04.8 LP04.9
TBL-HOURS-SRV-TYPE Numeric 2 LP04.6 LP04.7
Element: Ta Type Contains the units of measure for the LP04.8 LP04.9
summarized totals.
01 = LTD plan
02 = LTD plan; employee group
03 = LTD plan; emp grp; position
04 = All LTD
11 = YTD plan
12 = YTD plan; employee group
13 = YTD plan; emp grp; position
14 = All YTD
21 = PYT plan
22 = PYT plan; employee group
23 = PYT plan; emp grp; position
24 = All PYT
TBL-DATE-STAMP Numeric 8 (yyyymmdd) LP04.2 LP04.3
Element: Date Stamp This field contains the server date LP04.4 LP04.5
(month, date, and year) of the last LP04.6 LP04.7
change to this record. LP04.8 LP04.9
TBL-TIME-STAMP Numeric 6 (hhmmss) LP04.2 LP04.3
Element: Time Stamp Contains the server time (hour, minute, LP04.4 LP04.5
and second) when the record was last LP04.6 LP04.7
changed. LP04.8 LP04.9
TBL-USER-ID Alpha 10 (Lower Case) LP04.2 LP04.3
Element: User LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TATABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TBLSET1 COMPANY HR00.1 HR01.1
TABLE HR11.1 HR511
EFFECTIVE-DATE* LP02.1 LP03.1
LP03.2 LP03.3
LP03.4 LP03.5
LP03.6 LP04.2
LP04.3 LP04.4
LP04.5 LP04.6
LP04.7 LP04.8
LP04.9 LP07.1
LP08.1 LP100
LP101 LP140
LP145 LP180
LP197 LP198
LP201 LP203
...
TBLSET2 COMPANY LP04.2 LP04.3
TABLE-TYPE LP04.4 LP04.5
TABLE LP04.6 LP04.7
EFFECTIVE-DATE* LP04.8 LP04.9
TBLSET3 COMPANY Subset LP04.2 LP04.3
TABLE-BASIS Where (TABLE-BASIS = 1 ) LP04.4 LP04.5
TABLE
EFFECTIVE-DATE*
TBLSET4 COMPANY Subset LP04.6 LP04.7
TABLE-BASIS Where (TABLE-BASIS = 2 ) LP04.8 LP04.9
TABLE LP188
EFFECTIVE-DATE*
TATABLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TBL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Hours Srv Cls TASERVCLSS Required
When (TBL-HOURS-SRV-CLS != Spaces )
TBL-COMPANY -> TSL-COMPANY
TBL-HOURS-SRV-CLS -> TSL-SERVICE-CLASS
TATABLE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Tatablex TATABLEX Delete Cascades
TBL-COMPANY -> TBX-COMPANY
TBL-TABLE -> TBX-TABLE
TBL-EFFECTIVE-DATE -> TBX-EFFECTIVE-DATE
TBX-FROM
|