| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 13 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
2 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 13 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
3 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 14 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
4 | P05TPRNL_EE_RG | Pension Return: Income Relationship - Sector Risk Group | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
5 | P05TPRNL_PR_OUT | Pension Return: PR - Output Data | 4 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
6 | P05TPRNL_SYCHIR | Pension Return: System Change - IR Number per PERNR | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
7 | P2RB_ST | Tax payroll Belgium | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
8 | P2RB_SV | Social Insurance payroll Belgium | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
9 | P2RD_ST | Payroll Result: Tax (G) | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
10 | P2RD_SV | Payroll Result: Social Insurance | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
11 | P2RD_SVZ | Payroll Result: Supplementary Social Insurance | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
12 | P2RP_MF | HR-PT: Payroll Results: Membership fees | 5 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
13 | P2RP_SCRT | HR-PT: Cumulated result table (Legal entity dependent) | 5 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
14 | P2RP_SS | HR-PT: Payroll Results: Social Security | 35 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
15 | P2RP_TX | HR-PT: Payroll Results: Tax | 24 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
16 | P2RT_SV | Structure SV - insurance CZ | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
17 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 18 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
18 | P2RU_CLM | Overpayments Processing structure | 16 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
19 | P2RU_CLM_PERSON | Overpayments Processing structure | 18 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
20 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 14 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
21 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 18 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
22 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 18 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
23 | P2RV_ST | ST for Norway (Cluster for tax) | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
24 | P2RX_VERSC | Payroll Status Information | 6 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
25 | P2SK_SV | Structure of table SV - insurance SK | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
26 | P2VE_INC_EVAL | HRMS-VE: INCE Payment Results | 6 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
27 | P2VE_LPH_EVAL | HRMS-VE: Results from Housing Scheme (RPVH) | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
28 | P2VE_SI_EVAL | HRMS-VE: Cumulated Social Insurance Results | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
29 | P2VE_TAX_EVAL | HRMS-VE: Information on Income Tax | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
30 | T5REG | Employee Information Log for Destruction of Data | 15 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
31 | T5RPD | Personnel Data Deletion Log | 25 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
32 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
33 | T7RU9A | Addresses of organizations | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
34 | T7RUADVN | ADV-6-2 external sums | 4 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
35 | T7RUDSV3R | DSV-3: Run | 16 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
36 | T7RUPACKGR | PFR Packages group | 14 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPBelgium |
37 | T5BVH | Social Balance Data | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPCompany Pension Scheme Germany |
38 | P01CVH | Actuarial CPS Header Records | 31 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPCross-Application Objects in HR |
39 | HRP5581 | DB Table for Infotype 5581 | 30 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPNetherlands |
40 | T5N5D | NSI: Created Data Records | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
41 | T5N9A | Authority Addresses (NL) | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPPayroll |
42 | T5TA1 | External transfers | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
43 | T7SKA1 | External transfers | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
44 | HRPY_RGDIR | Directory for Payroll Results | 12 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
45 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 12 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
46 | PYORGSCREEN | PNP900 Selection Screen: Fields for Organizational Selection | 10 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
47 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 31 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
48 | T001P | Personnel Area/Subarea | 14 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPPortugal |
49 | T5P1J | HR-PT: Grouping and characteristics of legal entity (JUPER | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPPublic Sector |
50 | P01O_TVOED_SZ_RR | Earlier December Data for RA Trigger: ASP TVoeD/TVAoeD | 4 | JUPER | Legal Person on December 1 for Last November Payroll | nvarchar | 4 | 0 | | |
51 | PDPBSZV363 | Estimated Tax-Free Contributions (Acc. to Sec.3 No.63) | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPRecruitment |
52 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 31 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPReporting |
53 | P05TPRNL_EE_ADM | Pension Return: Admin Income Relationship - Pers Level | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
54 | P05TPRNL_EE_ADMS | Pension Return: Admin of Status Income Relationship - Pers L | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
55 | P05TPRNL_EE_IRI | Pension Return: Income Relationship Indicators | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
56 | P05TPRNL_EE_IRP | Pension Return: Income Relationship - Income Period - Pers L | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
57 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
58 | P05TPRNL_EE_PR | Pension Return: Income Relationship Pens/Ins Relationship PL | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
59 | P05TPRNL_EE_PRP | Pension Return: Income Rel - Pens/Ins Relation Period - PL | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
60 | P05TPRNL_EE_PRPI | Pension Return: Income Rel - Pens/Ins Rel Period Indic PL | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
61 | P05TPRNL_LP_ADM | Pension Return: Administration - Legal Pers Level | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
62 | P05TPRNL_LP_ADMS | Pension Return: Administration of Status - Legal Pers Level | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
63 | P05TPRNL_LP_COLL | Pension Return: Collective Return - Legal Pers Level | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
64 | P05T_AE_AANGIFTE | Wage Return: Administrative Unit - Collective Return | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
65 | P05T_AE_AANG_CUM | Wage Return: Cumulated Values Collective | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
66 | P05T_AE_ADM | Wage Return: Administrative Unit - Admin. Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
67 | P05T_AE_ADM_STAT | Wage Return: Administrative Unit - Status Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
68 | P05T_AE_CORSALDO | Wage Return: Administrative Unit - Balance Adjustments | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
69 | P05T_AE_WGF | Wage Return: Administrative Unit - Redundancy Pay Scheme | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
70 | P05T_AE_WGF_CUM | Wage Return: Administrative Unit: Sect/Risk Group Cumulated | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
71 | P05T_A_EXT | Wage Return: Collective Employer Data - Wage Return | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
72 | P05T_CVZ_REG | HCIB: Registration table | 2 | JUPER | Representing Legal Person | nvarchar | 4 | 0 | | |
73 | P05T_CVZ_REG_DAT | (De)registration data for HCIB | 2 | JUPER | Representing Legal Person | nvarchar | 4 | 0 | | |
74 | P05T_CVZ_UITW | CVZ: Tabel voor uitwisselingsbestand | 2 | JUPER | Representing Legal Person | nvarchar | 4 | 0 | | |
75 | P05T_EDM_PERSOON | Personal data for Day-one-announcement (EDM) | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
76 | P05T_IV_AANGIFTE | Wage Return: Income Relationship - Nominative Return | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
77 | P05T_IV_AANG_CUM | Wage Return: Cumulated Values per Income Relationship | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
78 | P05T_IV_AA_BSN | Wage Return: Cumulated Values for BSN Changers | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
79 | P05T_IV_ADM | Wage Return: Income Relationship - Admin. Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
80 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
81 | P05T_IV_DA | Wage Return: Income Relationship - Return Data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
82 | P05T_IV_DA_BSN | Wage Return: Other Cumulated Return Data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
83 | P05T_IV_DA_CUM | Wage Return: Other Cumulated Return Data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
84 | P05T_IV_INKPER | Wage Return: Income Relationship - Income Period | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
85 | P05T_IV_INKPERSA | Wage Return: Income Relationship - Income Period SI | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
86 | P05T_IV_PERSOON | Wage Return: Income Relationship - Personal Data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
87 | P05T_IV_RG | Wage Return: Income Relationship - Risk Group Sector | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
88 | P05T_IV_RG_CUM | Wage Return: Income Relationship: Sect./Riskgrp. cumulated | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
89 | P05T_RESP2LA | Wage Return: Rel. between Response Message and Wage Return | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
90 | P05T_T_WCR_CODE | Codes for the Work Cost Regulation | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
91 | P05T_T_WCR_CODET | WCR Code Description | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
92 | P05T_UITS_KENT | Indicator Exclusion | 2 | JUPER | Representing Legal Person | nvarchar | 4 | 0 | | |
93 | P05T_WCR_CWT | WCR Code for wage type | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
94 | P05T_WCR_EE_DATA | WCR Data on Employee Level | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
95 | P05T_WCR_ER_DATA | WCR Data on Employer Level | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
96 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
97 | P05T_WCR_FL | WCR: Final Levy and Final Settlement | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
98 | P05T_WCR_PROT | WCR Protocol Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
99 | P05T_WCR_STAT | WCR Status Table | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
100 | T5N1L | Social Insurance Contribution Data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
101 | T77PRNL_SYCHNG | Pension Return: System Change | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPRussia |
102 | T7RU9A_GRP | Assignment groups to Organization | 3 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPSpain |
103 | T5E02 | Company tax data | 2 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
TOPVenezuela |
104 | T7VEI2 | Transfer of external payroll results: INC contribution | 6 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
105 | T7VEL1 | Transfer of ext. payroll res.: Housing Scheme (RPVH) contr. | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
106 | T7VES4 | Transfer of External Payroll Results: SSO/RPE | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |
107 | T7VET1 | Transfer of External Payroll Results: Income Tax | 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | |