REFERENCED BY
HR11.1 | HR511 | LT101 | LT111 | LP02.1 | LP03.1 |
LP03.2 | LP03.3 | LP03.4 | LP03.5 | LP03.6 | LP07.1 |
LP100 | LP101 | LP102 | LP103 | LP131 | LP140 |
LP145 | LP151 | LP180 | LP197 | LP198 | LP201 |
LP203 | LP204 | LP31.1 | LP80.1 | PA100 | PA52.4 |
LP188 |
LP04.2 | LP04.3 | LP04.4 | LP04.5 | LP04.6 | LP04.7 |
LP04.8 | LP04.9 | HR00.1 | HR01.1 | LP08.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
TBL-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||
TBL-TABLE Element: Ta Table | Alpha 10 |
|
||||||||
TBL-DESCRIPTION Element: Ta Description | Alpha 30 (Lower Case) |
|
||||||||
TBL-EFFECTIVE-DATE Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||||||||
TBL-TABLE-TYPE Element: Ta Type | Numeric 2 Contains the units of measure for the summarized totals. 01 = Hours 02 = Earnings |
|
||||||||
TBL-TABLE-BASIS Element: Ta Basis | Numeric 1 1 = Cycle 2 = Hours |
|
||||||||
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 |
|
||||||||
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 |
|
||||||||
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 |
|
||||||||
TBL-HOURS-SRV-CLS Element: Ta Service Cls | Alpha 3 |
|
||||||||
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 |
|
||||||||
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. |
|
||||||||
TBL-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||
TBL-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TBLSET1 |
COMPANY TABLE EFFECTIVE-DATE* |
|
|||||||||||||||||||
TBLSET2 |
COMPANY TABLE-TYPE TABLE EFFECTIVE-DATE* |
|
| ||||||||||||||||||
TBLSET3 |
COMPANY TABLE-BASIS TABLE EFFECTIVE-DATE* |
|
| ||||||||||||||||||
TBLSET4 |
COMPANY TABLE-BASIS TABLE EFFECTIVE-DATE* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Hours Srv Cls | TASERVCLSS |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tatablex | TATABLEX |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.