| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T77TIM_AQGRP | Absence Quota Groups | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
2 | T77TIM_AQGRPT | Absence Quota Groups Description | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
3 | T7RU_T559L | Automatic Absence Quota Generation (Russian extension) | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPAustralia |
4 | T5QIA | PS Specific Characteristic for absence type | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
5 | T5QIT | Calculation rule for transfer frequency | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
6 | T5QLL | Australian Leave Loading - international leave | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
7 | T5QPR | Aust. Leave Provision for international leave | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPBenefits |
8 | T5UB3 | Benefit area | 28 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPFinland |
9 | T7FIWT | Worktime equalisation /free shift matrix) | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
10 | T7FIWTEM | WTE Model (Finland) | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPNew Zealand |
11 | T7NZLL | Leave Payment Calculation Table - NZ | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPPayroll |
12 | T5TL5 | Krácení kontingentu pro dovolenou v IT2006 | 4 | MOBDE | Seskupení personálních oblastí pro evidenci casu | nvarchar | 2 | 0 | | |
13 | T7SKL5 | Quota reduction for leave in IT2006 | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
14 | T7SKL6 | Quota reduction for leave in IT2006 | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
15 | T7UAH0 | Time codes | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
16 | T001P | Personnel Area/Subarea | 15 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
17 | T555A | Time Types | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
18 | T555A_WEB | Time Types to Be Displayed | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
19 | T555B | Time Type Texts | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
20 | T555C | Permitted PDC PIN Codes | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
21 | T555E | Time Evaluation Messages | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
22 | T555F | Time Evaluation Error Texts | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
23 | T555H | Site-Restricted Access Control Groups | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
24 | T555I | PDC Master Record Information | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
25 | T555J | Transfer to Time Types | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
26 | T555K | Transfer to Time Wage Types | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
27 | T555L | Transfer to Absence Quotas | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
28 | T555O | Access Control Groups (time-restricted) | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
29 | T555P | Employee Time Transfer Type | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
30 | T555Q | Texts for Time Transfer Type | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
31 | T555X | Texts for Access Control Groups (time-restricted) | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
32 | T555Y | Processing Type/Time Type According to Att./Absence Class | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
33 | T555Z | Time Type Determination | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
34 | T557H | Relation Table: Time Types Accumulation | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
35 | T557M | Time Types Relationships Table (from Period Totals Table) | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
36 | T559E | Base Entitlement for Leave Accrual | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
37 | T559F | Processing of Absence Quota Remainders | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
38 | T559L | Automatic Absence Quota Generation | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
39 | T559P | Limits for Time Balances | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
40 | T559Q | Texts for Time Balance Limits | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
41 | T559T | Texts for Leave Accrual Rule | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
42 | T559U | Overtime rules | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
43 | T559W | Text Table for Time Evaluation Classes | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
44 | T559X | Evaluation Classes for Times (Internal Table TIP) | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
45 | T559Y | Text Table for Conditions for Employee Times | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
46 | T559Z | Conditions for Employee Times in Time Evaluation | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
47 | T705B | PDC Processing Statuses | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
48 | T705E | Reaction to Error Transaction | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
49 | T7TIM_BSB_MESSG | Assignment of Business Subject to a Message | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
50 | T7TIM_BSB_ZTART | Assignment of Business Subject to a Time Type | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
51 | T7TIM_LIMIT_STEP | Rule Blocks Under LIMIT | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
52 | T7TIM_QUOTA_STEP | Rule Blocks Under QUOTA | 6 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPPortugal |
53 | T5PV1 | HR-PT: Assignment of quota type selection rule group | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPPublic Sector |
54 | T5QPBS2O | Impact of Organizational change | 9 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
55 | T5QPBS2T | To determine the Seniority based on the Anniversary date | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
56 | T5QPBS5A | HR AU PS:Australian Leave Loading | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
57 | T5QPBS5B | HR AU PS:Australian Leave Loading for varying percentage | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPShift Planning |
58 | T77EI | Contents of Info Column for Shift Planning | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPShift Planning for Public Sector |
59 | T7PBS_SP_TSN_D | Assgmt Time Type to Exam. Scheme/Training Path and Grouping | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
60 | T7PBS_SP_TSN_E | Time Statement for Nurses: Column Customizing for UI | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
61 | T7PBS_SP_TSN_E_T | Grouping for Practical Training: Texts | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPSwitzerland |
62 | T5C20 | Time Quotas for Subapplications CH | 5 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
63 | TMW_TDTYPE | Time Data ID | 29 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPUSA |
64 | T7US_FMLA_DETRUL | Table of Relationships: FMLA Rule and Feature FMLMO | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
65 | T7US_FMLA_DETWWK | Table of Relationships: Week Converter and Feature WWKMO | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
66 | T7US_FMLA_RU2RE | Assignment of FMLA Reasons to FMLA Rules | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
67 | T7US_FMLA_RULE | Rules for Administrating FMLA Events | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
68 | T7US_FMLA_RULTXT | Rule Texts for Administration of FMLA Events | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
69 | T7US_FMLA_WRKWK | Rule for Determining Week Converter | 2 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
70 | T7US_FMLA_WWKTXT | Rule Texts for Determining Weekly Working Time | 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |
TOPVenezuela |
71 | T7VE10 | Assignment of date class to absence quota | 4 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | | |