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