| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
2 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 16 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
3 | P2B2_AB | HCM Declustering B2 - Absences | 12 | CNTR3 | National split | varbinary | 1 | 0 | | |
4 | P2BR_BRCONT | Employment/basic pay: additional information | 5 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
5 | P2BR_BRCUM | Working days (PRS) | 5 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
6 | P2BR_BRDEP | Dependents: master data | 5 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
7 | P2CN_CNREI | Payroll result: structure for retro difference details | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
8 | P2CN_CNREO | Payroll result: structure for retro difference details | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
9 | P2CN_SFEE | Payroll result: Service fee for personal file (CN) | 5 | CNTR3 | SI split | varbinary | 1 | 0 | | |
10 | P2CO_COAVA | PC2CO_AVA | 27 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
11 | P2CO_COGAR | PC2CO_GAR | 16 | CNTR3 | Hexadecimal field of length 1 | varbinary | 1 | 0 | | |
12 | P2HK_RETI | Payroll structure for retroactive accounting | 15 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
13 | P2HK_RETO | Payroll structure for retroactive accounting | 15 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
14 | P2IN_HFS | Payroll India - Hard Furnishing Scheme | 5 | CNTR3 | Split for Commuter Lump Sum | varbinary | 1 | 0 | | |
15 | P2IN_HRA | Housing(HRA/CLA/COA) details | 5 | CNTR3 | Split for Commuter Lump Sum | varbinary | 1 | 0 | | |
16 | P2IS_RETI | Payroll structure for retroactive accounting | 15 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
17 | P2IS_RETO | Payroll structure for retroactive accounting | 15 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
18 | P2KR_KRRP | Payroll Result Korea: Retirement Pension Plan | 5 | CNTR3 | Split for Retirement Pension | varbinary | 1 | 0 | | |
19 | P2KW_SI_KW | Payroll Result: PIFSS Data for Kuwait | 7 | CNTR3 | Split for Commuter Lump Sum | varbinary | 1 | 0 | | |
20 | P2KZ_FUP | Structure for Table FUP - Future Periods | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
21 | P2NZ_SALSAC | Salary Sacrifice Details | 12 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
22 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
23 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 11 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
24 | P2RC_CHVS | HR-CH: Payroll result insurance | 5 | CNTR3 | SI split | varbinary | 1 | 0 | | |
25 | P2RC_FMZR | Family-Related Bonus Register | 6 | CNTR3 | Object Identification | nvarchar | 2 | 0 | | |
26 | P2RD_VBL | Payroll Result: Supplementary Pension Public Sector | 5 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
27 | P2RH_HU_HKIF | P21PB | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
28 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
29 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 12 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
30 | P2RJ_MAT | Cumulation Table for Flexible Payroll | 6 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
31 | P2RL_EPF | Payroll result: EPF (Malaysia) | 4 | CNTR3 | Split for Commuter Lump Sum | varbinary | 1 | 0 | | |
32 | P2RQ_HT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
33 | P2RQ_NT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
34 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
35 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
36 | P2RR_RM | Payroll Results: Table for Master data (SG) | 73 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
37 | P2RR_SRT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
38 | P2RV_VAP | VAP Structure Norway | 5 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
39 | P2RX_AB | Cluster RD/B2: Table AB | 10 | CNTR3 | National split | varbinary | 1 | 0 | | |
40 | P2RX_CODIST | Distribution opf Liabilities | 12 | CNTR3 | Split for Commuter Lump Sum | varbinary | 1 | 0 | | |
41 | P2RX_GRT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
42 | P2RX_MODIF | HR-PAY: Modifiers | 8 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
43 | P2RX_RT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
44 | P2RX_RT_PERSON | Results Table (Person) | 14 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
45 | P2TH_PFUND | Payroll Results : Provident Fund TH | 5 | CNTR3 | SI split | varbinary | 1 | 0 | | |
46 | P2TN_TWOT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
47 | P2UA_FUP | table FUP - future periods | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
48 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
49 | P2UA_UART | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
50 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 14 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
51 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 14 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
52 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 14 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
53 | P2UN_HT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
54 | P2UN_NT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
55 | P2UR_FUP | table FUP - future periods | 13 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
56 | P2UR_RURT | Payroll Results: Results Table | 10 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPAustria |
57 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 11 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPDenmark |
58 | T5M9H | Split Indicators for Wage Types Sent to PBS | 11 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPGermany |
59 | T5D0I | Fictitious Run Control: Wage Type Assignment | 15 | CNTR3 | Delete Indicator VBL Contribution (PS) | nvarchar | 1 | 0 | | |
TOPJapan |
60 | T5JMA | Multiple payment model in a month | 3 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPPayroll |
61 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 9 | CNTR3 | Národní rozdelení | varbinary | 1 | 0 | | |
62 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 9 | CNTR3 | National split | varbinary | 1 | 0 | | |
TOPPayroll General Parts |
63 | T558D | Transfer Wage Types with Split Indicator | 9 | CNTR3 | HR: Outsourcing: Split Indicator - 3 NOT USED | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
64 | T7COT6 | Payroll external results transfer: COGAR | 16 | CNTR3 | Hexadecimal field of length 1 | varbinary | 1 | 0 | | |
65 | T7COT8 | Payroll external results transfer: COAVA | 27 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPPersonnel Management |
66 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 14 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | |
TOPTools |
67 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 11 | CNTR3 | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |