| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_ABWKONTI | HCM Declustering B2 - Absence Quotas (Table ABWKONTI) | 16 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
2 | P2B2_ANWKONTI | HCM Declustering B2 - Attendance Quotas (Table ANWKONTI) | 15 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
3 | P2NZ_ACCRCALC | Leave Accrual on Term Calculation | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
4 | P2NZ_LVAWE | Payroll Result: Leave Entitlement LVAWE - NZ | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
5 | P2NZ_LVPAY | Payroll Result: Leave Payment LVPAY - NZ | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
6 | P2RQ_LSLPR | Payroll Results: LSLPR Table | 28 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
7 | P2RQ_LVEPR | Payroll Results: LVEPR Table | 21 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
8 | P2VE_ABS_EVAL | HRMS-VE: Wage Management for Valuation of Vacations | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
9 | PA0613 | HR Master Record: Infotype 0613 | 28 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
10 | PA3253 | HR Master Record: Infotype 3253 | 48 | KTART | Quota Type for Ticket Entitlement | nvarchar | 2 | 0 | | |
11 | PA3254 | HR Master Record: Infotype 3254 | 43 | KTART | Quota Type for Ticket Entitlement | nvarchar | 2 | 0 | | |
12 | PA3304 | HR Master Record: Infotype 3304 | 72 | KTART | Quota Type for Leave Passage Entitlement | nvarchar | 2 | 0 | | |
13 | PA3352 | HR Master Record: Infotype 3352 | 35 | KTART | Quota Type for Leave Passage Entitlement | nvarchar | 2 | 0 | | |
14 | PB3304 | Applicant data infotype 3304 (model) | 72 | KTART | Quota Type for Leave Passage Entitlement | nvarchar | 2 | 0 | | |
15 | T5AA0 | Absence Quota Type for Recognition of Leave | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
16 | T5R2F | Quota Type Gerenation Rule Singapore | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
17 | T5R2G | Quota Generation Rule Lists Singapore | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
18 | T5UPBSPOOLA | Sick Leave Pool Attributes | 9 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
19 | T5UPBSPOOL_TRANS | Sick Leave Donation - transaction history record | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
20 | T77PADRU_VACRS | Reasons of reserves for vacations | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
21 | T7AE20 | Leave Passage : Evaluation Wage Types per Quota Type | 4 | KTART | Quota Type for Ticket Entitlement | nvarchar | 2 | 0 | | |
22 | T7INLEMET_WT_MAP | Map quota compensation method with WT for 267 infotype | 7 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
23 | T7KW20 | Leave Passage : Evaluation Wage Types per Quota Type (KW) | 4 | KTART | Quota Type for Leave Passage Entitlement | nvarchar | 2 | 0 | | |
24 | T7QA15 | Addtional Leave Quota Adjustment(QA) | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
25 | T7QA20 | Leave Passage : Evaluation Wage Types per Quota Type (QA) | 4 | KTART | Quota Type for Leave Passage Entitlement | nvarchar | 2 | 0 | | |
26 | T7SA29 | Leave Passage : Evaluation Wage Types per Quota Type | 4 | KTART | Quota Type for Ticket Entitlement | nvarchar | 2 | 0 | | |
27 | T7SAPBS30 | Absence Quota Generation Refinement | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
28 | TNWCH_EDI_RETCD | EDI Antwortcodes | 4 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
29 | TNWCH_EDI_RETCDT | EDI Antwortcodes - Texte | 5 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
TOPArgentina |
30 | T7AR69 | Vacation provision: Calculation wage types | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPAustralia |
31 | T5QIG | Leave Quota Grouping | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
32 | T5QLL | Australian Leave Loading - international leave | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
33 | T5QPR | Aust. Leave Provision for international leave | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
34 | T5QRT | Term. Rules for Long Serv-Leave & Leave Loading Australia | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
35 | T5QTR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 8 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPBasic Data |
36 | NKIP | IS-H: Pre-Approved Insurance Verification Information - Item | 4 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
37 | NKTR | IS-H: Business Partners/Insurance Providers | 4 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
38 | NPTW | IS-H: Rules for Charge Factor Value Determ. | 8 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
39 | TN18 | IS-H: Insurance Provider Types | 2 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
40 | TN18U | IS-H: Texts for Insurance Provider Types | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
41 | TNF31 | IS-H: Work Organizers with Ins. Prov. Conditions | 6 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
42 | TNF32 | IS-H: Work Organizers with Billing Type and Ins. Prov. Cond. | 6 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
TOPBelgium |
43 | T5B31 | Translation Table BE Educational Leave Quotums | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
44 | T5B32 | History Table Declared Courses Educational Leave | 2 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPBrazil |
45 | T7BR86 | Wage types for saving entitlement to leave reserve | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
46 | T7BRQT | Absence quota type | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
47 | T5DB_UREGELN | Leave Regulations for IT 2006 | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPFinland |
48 | T7FIWTEM | WTE Model (Finland) | 12 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | | |
TOPIntegration with Time Management |
49 | T5DTM_URL | Absence Quota Types Specific to Germany | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPJapan |
50 | T7JPLA_VADPD | Define Leave Quota Validity for Time Off from Overtime | 3 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPNew Zealand |
51 | HNZLVPAY | Table for modified LVPAY cluster table records | 7 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
52 | PA0312 | Leave History Adjustments NZ | 38 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
53 | PT2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 27 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
54 | T7NZLC | Leave Payment Calculation Table - NZ | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
55 | T7NZLL | Leave Payment Calculation Table - NZ | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
56 | T7NZLT | Termination Wage Types for Leave NZ | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
57 | T7NZLV | Leave accrual payout rules on termination | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
58 | T7NZPL | A/A types with absence quotas affected by parental leave | 8 | KTART | Absence quota impacted by parental leave | nvarchar | 2 | 0 | | |
TOPNon Profit Organizations |
59 | T7UNPAD_QT_KTART | NPO Quota Types Attributes | 2 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPNorway |
60 | T5V3G | Leave quota types | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
61 | NTFI | IS-H: Service Catalog Determination Rules | 8 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
62 | NVBRK | IS-H: Billing document header data | 62 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
63 | TN18B | IS-H: Propose Contract Scheme by Ins. Prov. Type | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
64 | TN21A | IS-H: Billing Type Determination | 5 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
65 | TN22K | IS-H: Copayment Amount per Ins. Provider/Ins. Provider Type | 4 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
66 | TNHCO | Basic Settings HCO | 12 | KTART | IS-H: Order type for cost object-based orders | nvarchar | 4 | 0 | | |
67 | TNVSL | IS-H: Rules for Determining Multiplication Factors | 7 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
TOPPayroll |
68 | T5HPBS61 | Köztisztviseloi pótszabadság megképzését vezérlo tábla | 7 | KTART | Távollétkeret-típus | nvarchar | 2 | 0 | | |
69 | T5HPBS62 | Közalkalmazotti pótszabadság megképzését vezérlo tábla | 8 | KTART | Távollétkeret-típus | nvarchar | 2 | 0 | | |
70 | T5HPBS63 | Generating leave quotas | 6 | KTART | Leave quota category | nvarchar | 2 | 0 | | |
71 | T5HPBS67 | Long texts for leave quota category | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
72 | T5HPBS70 | HR-H: Szabadságkeretek a 2006-os IT-on | 2 | KTART | Távollétkeret-típus | nvarchar | 2 | 0 | | |
73 | T7BGQ3 | Vacation debt | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
74 | T7COQP | Absence quota attributes | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
75 | PA2006 | HR Time Record: Infotype 2006 (Absence Quotas) | 27 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
76 | PA2007 | HR Time Record: Infotype 2007 (Attendance Quotas) | 27 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
77 | PA2013 | HR Time Record: Infotype 2013 (Quota Corrections) | 27 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
78 | T554A | Breakdown of Absences After Quota Deduction | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
79 | T554S | Attendance and Absence Types | 18 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | | |
80 | T556A | Absence Quota Types | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
81 | T556A_WEB | ESS Leave Request: Quota Types for Display | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
82 | T556B | Absence Quota Type Texts | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
83 | T556P | Attendance Quotas | 4 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
84 | T556P_WEB | ESS Leave Request: Quota Types to Be Displayed | 5 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
85 | T556Q | Attendance Quota Type Texts | 5 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
86 | T559J | Convert Leave Types to Quota Types | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
87 | T7TIM_BSB_KTARTA | Assignment of Business Subject to an Absence Quota | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
88 | T7TIM_BSB_KTARTP | Assignment of Business Subject to an Attendance Quota | 4 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
TOPPortugal |
89 | T5PV2 | HR-PT: Classification of absence quota types | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPPublic Sector |
90 | T5QPBS2E | Parallel deduction sequence of quota types | 6 | KTART | Quotas to be deducted parallely | nvarchar | 2 | 0 | | |
91 | T5QPBS2F | LWOP/UNAL impact on individual leave type | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
92 | T5QPBS2L | Leave Provision for Australia - Public sector | 3 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
93 | T5QPBS2T | To determine the Seniority based on the Anniversary date | 9 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | | |
94 | T5QPBS5A | HR AU PS:Australian Leave Loading | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
95 | T5QPBS5B | HR AU PS:Australian Leave Loading for varying percentage | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPPublic sector Sweden |
96 | T5SVA_CE | Vacation debt | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
97 | T799L42 | Asignment between absence types and legal categories | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPRussia |
98 | T7RU_556B | Absence Quota Type Texts | 5 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
99 | /ISHFR/TN21A | IS-H FR: Determine Billing Type | 6 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
100 | /ISHFR/TNWFR_B2 | IS-H FR: Control Settings for B2 Dispatch | 5 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
101 | NAKR1 | IS-H AT: LKF - Grunddaten | 32 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
102 | NKLP | IS-H: Individual outpatient srv / ins.providers (AT) | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
103 | NLDIS_001 | ISH NL: DIS - Versicherungsgrund | 3 | KTART | IS-H: Soort kostendrager (b.v. particulier, wettelijk) | nvarchar | 3 | 0 | | |
104 | NNTF | IS-H NL: Service Catalog Determination | 11 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
105 | NWATLHO | IS-H AT: Leistungshöchstwerte | 5 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
106 | NWCH_NKTR_PROF | Ausschluss Pro-forma-Rechnungen an Patienten | 2 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
107 | TNA16 | IS-H: IP Types/Types of Coverage VAT Assessment Austria | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
108 | TNA21A | IS-H: Determining the flat rate type (VERA) | 5 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
109 | TNAUMLEI | IS-H AT: Umschlüsselung Leistung | 10 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
110 | TNNC2 | IS-H NL: Insurance provider types (internal) | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
111 | TNNC3 | IS-H NL: Kostenübernahme von leistungen | 11 | KTART | IS-H: Soort kostendrager (b.v. particulier, wettelijk) | nvarchar | 3 | 0 | | |
112 | TNNP4 | IS-H NL: Classes for IP Types / Default Values | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
113 | TNWAT_DEK_KOST | IS-H AT: Dekaden (Kostenträgerdaten) | 3 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
114 | TNWAT_LEIKOM_HDR | IS-H AT: Leistungskombinationen umschlüsseln - Header | 8 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
115 | TNWCH74 | IS-H CH: Vertragstypen Zuordnungstabelle | 7 | KTART | IS-H: tipo ente pag. (ad es. privato, pubblico) | nvarchar | 3 | 0 | | |
116 | TNWCH81 | IS-H CH: Billing Type Determination | 6 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
117 | TNWCH83 | Ermittlung der Baserate | 11 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
118 | TNWCH91 | Items for Fee Relevance | 12 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
119 | TNWCHIVTOE | IS-H CH: Zuordnung Fachl. OE zu Tages- und Fallpauschale | 4 | KTART | IS-H: tipo ente pag. (ad es. privato, pubblico) | nvarchar | 3 | 0 | | |
120 | TNWCHKTRGR | IS-H CH: Dynamische Kostenträgergruppen | 7 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
121 | TNWCHSDRG01 | Swiss-DRG - Leistungsregeln DRG-Leistung generieren | 5 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
122 | TNWCHTM00 | IS-H CH: TARMED - Regelwerk für Leistungsregeln | 5 | KTART | IS-H: tipo ente pag. (ad es. privato, pubblico) | nvarchar | 3 | 0 | | |
123 | TNWCH_EDIKTR | IS-H CH: Control Data for EDI Procedure for Ins. Provider | 3 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | | |
124 | TNWCH_EDIKTR_EO | Steuerung EDI-Verfahren für externe Aufträge | 3 | KTART | IS-H: Kostenträgerart (z.B. privat, gesetzlich) | nvarchar | 3 | 0 | | |
TOPSouth Africa |
125 | T5W4A | Leave parameter table - Southern Africa | 6 | KTART | Attendance or absence quota type | nvarchar | 2 | 0 | | |
TOPSweden |
126 | T5SVA | Vacation and Compensation debt | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
127 | TMW_TDTYPE | Time Data ID | 24 | KTART | Attendance Quota Type | nvarchar | 2 | 0 | | |
TOPVenezuela |
128 | T7VEA1 | Transfer of External Payroll Results: Vacations | 6 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |
129 | T7VEQP | Absence quota attributes | 4 | KTART | Absence Quota Type | nvarchar | 2 | 0 | | |