| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5AA0 | Absence Quota Type for Recognition of Leave | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
2 | T5R2F | Quota Type Gerenation Rule Singapore | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
3 | T5R2G | Quota Generation Rule Lists Singapore | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
4 | T5UPBSPOOLA | Sick Leave Pool Attributes | 8 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
5 | T5UPBSPOOL_TRANS | Sick Leave Donation - transaction history record | 15 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
6 | T77TIM_AQGRP | Absence Quota Groups | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
7 | T77TIM_AQGRPT | Absence Quota Groups Description | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
8 | T7AE20 | Leave Passage : Evaluation Wage Types per Quota Type | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
9 | T7AE21 | Assign Off-cycle Encashment Methods | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
10 | T7AEPBS66 | Absence Type Limit Condition | 6 | MOZKO | Not used | nvarchar | 2 | 0 | | |
11 | T7INLEMET_WT_MAP | Map quota compensation method with WT for 267 infotype | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
12 | T7KW20 | Leave Passage : Evaluation Wage Types per Quota Type (KW) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
13 | T7KW31 | Assign Off-cycle Encashment Methods (KW) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
14 | T7OM20 | Leave Passage : Evaluation Wage Types per Quota Type (OM) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
15 | T7OM23 | Assign Off-cycle Encashment Methods (OM) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
16 | T7QA15 | Addtional Leave Quota Adjustment(QA) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
17 | T7QA20 | Leave Passage : Evaluation Wage Types per Quota Type (QA) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
18 | T7QA31 | Assign Off-cycle Encashment Methods (QA) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
19 | T7RU_T559D | Russian Validity Period: Absence Quotas for Default Values | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
20 | T7RU_T559L | Automatic Absence Quota Generation (Russian extension) | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
21 | T7SA29 | Leave Passage : Evaluation Wage Types per Quota Type | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
22 | T7SA31 | Assign Off-cycle Encashment Methods KSA | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
23 | T7SAPBS30 | Absence Quota Generation Refinement | 2 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
24 | T7UA556W | Wage Type Assignment for Absence Quota Comp-Ukranian fields | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPArgentina |
25 | T7AR69 | Vacation provision: Calculation wage types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPAustralia |
26 | T5QIA | PS Specific Characteristic for absence type | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
27 | T5QIG | Leave Quota Grouping | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
28 | T5QIT | Calculation rule for transfer frequency | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
29 | T5QLL | Australian Leave Loading - international leave | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
30 | T5QPR | Aust. Leave Provision for international leave | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
31 | T5QTR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPBelgium |
32 | T5B31 | Translation Table BE Educational Leave Quotums | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPBrazil |
33 | T7BR86 | Wage types for saving entitlement to leave reserve | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
34 | T7BRCP | Wage type assignment for absence double compensation | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
35 | T7BRQC | Quota compensation types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
36 | T7BRQT | Absence quota type | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
37 | T5DB_KTARTGRP | Absence Quota Types Groups for IT 2006 | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
38 | T5DB_KTARTGRT | Texts for Absence Quota Types Groups for IT 2006 | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
39 | T5DB_UREGELN | Leave Regulations for IT 2006 | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
40 | T5DB_ZUORDUREG | Assignments for Leave Regulations for IT 2006 | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPFinland |
41 | T7FIV1 | Assignment of Vacation Quota Types to Wage Types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPFrance |
42 | T77TNM_DE | TNM: deduction customizing table | 7 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
43 | T77TNM_QU | TNM: quota customizing table | 6 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPIntegration with Time Management |
44 | T5DTM_URL | Absence Quota Types Specific to Germany | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPNew Zealand |
45 | T7NZLC | Leave Payment Calculation Table - NZ | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
46 | T7NZLL | Leave Payment Calculation Table - NZ | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
47 | T7NZLT | Termination Wage Types for Leave NZ | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
48 | T7NZLV | Leave accrual payout rules on termination | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPNorway |
49 | T5V3G | Leave quota types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPayroll |
50 | T5HPBS64 | Controlling leave quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
51 | T5HPBS66 | Rules for leave quota conflicts | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
52 | T5HPBS67 | Long texts for leave quota category | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
53 | T5TL5 | Krácení kontingentu pro dovolenou v IT2006 | 3 | MOZKO | Seskup.dílc.personálních oblastí pro typy kontingentu casu | nvarchar | 2 | 0 | | |
54 | T7BGQ3 | Vacation debt | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
55 | T7SKL5 | Quota reduction for leave in IT2006 | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
56 | T7SKL6 | Quota reduction for leave in IT2006 | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
57 | T001P | Personnel Area/Subarea | 16 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
58 | T7COQP | Absence quota attributes | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
59 | T7PLL0 | Allowed limits configuration | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
60 | T554A | Breakdown of Absences After Quota Deduction | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
61 | T555L | Transfer to Absence Quotas | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
62 | T556A | Absence Quota Types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
63 | T556A_WEB | ESS Leave Request: Quota Types for Display | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
64 | T556B | Absence Quota Type Texts | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
65 | T556C | Counting Rule for Attendances and Absences | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
66 | T556D | Absence Counting With/Without Quotas Texts | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
67 | T556P | Attendance Quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
68 | T556P_WEB | ESS Leave Request: Quota Types to Be Displayed | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
69 | T556Q | Attendance Quota Type Texts | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
70 | T556R | Rules for Deduction Sequence for Absence Quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
71 | T556S | Texts for Deduction Sequence Rules for Absence Quotas | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
72 | T556U | Attendance/Absence Quota Compensation Types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
73 | T556V | Texts for Attendance/Absence Quota Compensation Types | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
74 | T556W | Wage Type Assignment for Att./Absence Quota Compensations | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
75 | T557J | Relation Table: Quota Types for Reporting | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
76 | T559D | Validity/Deduction Interval for Absence Quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
77 | T559D_WEB | ESS Leave Request: Obsolete; Now T556A_WEB | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
78 | T559E | Base Entitlement for Leave Accrual | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
79 | T559F | Processing of Absence Quota Remainders | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
80 | T559J | Convert Leave Types to Quota Types | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
81 | T559L | Automatic Absence Quota Generation | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
82 | T559QT | Transfer Remaining Quota to New Quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
83 | T559T | Texts for Leave Accrual Rule | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
84 | T559V | Validity Period: Absence Quotas for Default Values | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
85 | T7TIM_BSB_KTARTA | Assignment of Business Subject to an Absence Quota | 2 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
86 | T7TIM_BSB_KTARTP | Assignment of Business Subject to an Attendance Quota | 2 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
87 | T7TIM_QUOTA_STEP | Rule Blocks Under QUOTA | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPortugal |
88 | T5PV1 | HR-PT: Assignment of quota type selection rule group | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
89 | T5PV2 | HR-PT: Classification of absence quota types | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPublic Sector |
90 | T5QPBS2E | Parallel deduction sequence of quota types | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
91 | T5QPBS2F | LWOP/UNAL impact on individual leave type | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
92 | T5QPBS2N | Orgn change & simulation quota for Absence Quotas | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
93 | T5QPBS2O | Impact of Organizational change | 8 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
94 | T5QPBS2T | To determine the Seniority based on the Anniversary date | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
95 | T5QPBS5A | HR AU PS:Australian Leave Loading | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
96 | T5QPBS5B | HR AU PS:Australian Leave Loading for varying percentage | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPPublic sector Sweden |
97 | T5SVA_CE | Vacation debt | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
98 | T799L42 | Asignment between absence types and legal categories | 5 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPRussia |
99 | T7RU_556B | Absence Quota Type Texts | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPSweden |
100 | T5SVA | Vacation and Compensation debt | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPSwitzerland |
101 | T5C20 | Time Quotas for Subapplications CH | 4 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
102 | TMW_TDTYPE | Time Data ID | 22 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
TOPVenezuela |
103 | T7VE10 | Assignment of date class to absence quota | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |
104 | T7VEQP | Absence quota attributes | 3 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | | |