TATABLE

REFERENCED BY
LP08.1 LP140 LP02.1 LP07.1 LP201 LP203
LP204


UPDATED BY
HR00.1 HR01.1 HR11.1 HR511 LT101 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 LP100 LP101 LP102 LP103 LP131
LP145 LP180 LP188 LP197 LP198 LP31.1
LP80.1 PA100 PA52.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TBL-COMPANY
Element: Company Hr
Numeric 4
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TABLE
Element: Ta Table
Alpha 10
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-EFFECTIVE-DATE
Element: Ta Begin Date
Numeric 8 (yyyymmdd)
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TABLE-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Hours
02 = Earnings
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TABLE-BASIS
Element: Ta Basis
Numeric 1

1 = Cycle
2 = Hours
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-RULE-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Accrual
02 = Allotment
03 = Limit
04 = GL
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-CYCLE-FREQ
Element: Ta Frequency
Numeric 2

01 = Weekly
02 = Biweekly
03 = Semimonthly
04 = Four weekly
05 = Monthly
06 = Bimonthly
07 = Quarterly
08 = Four monthly
09 = Semiannually
10 = Annually
LP04.2 LP04.3
LP04.4 LP04.5
TBL-CYCLE-SRV-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp grp; position
LP04.2 LP04.3
LP04.4 LP04.5
TBL-HOURS-SRV-CLS
Element: Ta Service Cls
Alpha 3
LP04.6 LP04.7
LP04.8 LP04.9
TBL-HOURS-SRV-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the 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
LP04.6 LP04.7
LP04.8 LP04.9
TBL-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.
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBL-USER-ID
Element: User
Alpha 10 (Lower Case)
LP04.2 LP04.3
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
TABLE
EFFECTIVE-DATE*
...
HR00.1 HR01.1
HR11.1 HR511
LT101 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
LP102 LP103
LP131 LP140
LP145 LP180
TBLSET2 COMPANY
TABLE-TYPE
TABLE
EFFECTIVE-DATE*
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBLSET3 COMPANY
TABLE-BASIS
TABLE
EFFECTIVE-DATE*
Subset
Where(TABLE-BASIS =1)
LP04.2 LP04.3
LP04.4 LP04.5
TBLSET4 COMPANY
TABLE-BASIS
TABLE
EFFECTIVE-DATE*
Subset
Where(TABLE-BASIS =2)
LP04.6 LP04.7
LP04.8 LP04.9
LP188


TATABLE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:19:49 2016

Home
Contact Us



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