| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 37 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
2 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 114 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
3 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 114 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
4 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 47 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
5 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 47 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
6 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 47 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
7 | P2RD_DOWP | Payroll Results; Additional Data WPBP (PSG) | 8 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
8 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 54 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
9 | P2RK_DOWP | Payroll Results: Additional WPBP Data (PSG) | 8 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
10 | P2RT_CZDAV | P18_03 | 38 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
11 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 54 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
12 | P2RU_DOWP | Payroll Results: Additional WPBP Data (PSG) | 8 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
13 | P2RX_C1 | Cost Distribution Table C1 | 35 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPBudget Management |
14 | HRP1503 | DB Table for Infotype 1503 | 19 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPConfirmations |
15 | AFRV | Confirmation pool | 45 | DART | Character field, length 2 | nvarchar | 2 | 0 | | |
16 | AFRV_DEL | Backup Copy for Confirmation Pool | 45 | DART | Character field, length 2 | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
17 | T5DBV | Construction Pay: Cost Assignment: Hostels | 34 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
18 | T5DBX | Construction Pay: Incentive Wage Connection | 34 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPPayroll |
19 | T5TPSC1SPLIT | Rozdelení nákladu | 45 | DART | Druh služby (PSG) | nvarchar | 2 | 0 | | |
TOPPersonnel Time Events |
20 | TPTCOR_KOSTL | Cost Assignment (Correction Scenario) | 16 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
21 | ASSOB | Assignment Objects | 33 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
22 | CC1ERP | Incorrect Time Events from CC1, Postings | 115 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
23 | CC1TEV | Temporary Buffer for Time Events from CC1 | 39 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
24 | COIFT | Interface to Activity Allocation | 65 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
25 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 70 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
26 | PTEX2003GEN | Interface Table for IT 2003: General Information | 69 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
27 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 45 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
28 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 69 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
29 | TEVEN_MORE | Additional Data for Time Events | 114 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPPlant Data Collection |
30 | RUECK | Temp. storage for subsystem confirmations | 40 | DART | Character field, length 2 | nvarchar | 2 | 0 | | |
TOPPublic Sector |
31 | PA0231 | HR Master Record: Infotype 0231 / View 0001 (PSG) | 24 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
32 | T5D7C | Service Types | 3 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
33 | T5D7D | Service Type Texts | 4 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
34 | T5D7E | Service Categories | 3 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
35 | T5D7F | Service Category Texts | 4 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
36 | T5D7Y | Assignment of Exception Indicator(s) to Service Types | 3 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
37 | T5D8M | Position Table for College Statistics | 11 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPStaffing |
38 | HRT1018 | Table Division Infotype 1018 Cost Distribution | 16 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPThird Party Remittance |
39 | T51R6_FUNDINFO | Remittance detail table for all entities | 11 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |
TOPTravel Planning |
40 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 37 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | | |