| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_RIDH | HCM-FSCD: List of HCM Posting runs to be processed | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
2 | CNVHCM_COMPARL_T | TDMS4HCM: Protocoll information for payroll compare | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
3 | P01BN_STAT | Status Table for Contribution Statements | 30 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
4 | P01PF_REBUILD | Garnishment Principle of Origin: Results of Rebuild | 16 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
5 | P01PF_REB_HIST | Garnishment Principle of Origin: Results of Rebuild History | 16 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
6 | P2BG_BG_CUX | Difference table of payroll results | 6 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
7 | P2BG_BG_DIF | Difference table of payroll results | 6 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
8 | P2CO_COSSO | PC2CO_SSO | 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
9 | P2CO_COTAX | PC2CO_TAX | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
10 | P2MX_GRORD | Maintenance payment order | 15 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
11 | P2NZ_P5NZB | Payroll Result: Leave Balance P5NZB - NZ | 6 | PABRJ | Pay Period Year | nvarchar | 4 | 0 | | |
12 | P2PH_SSSB | HR-PH: Include for SSS structure - Philippines | 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
13 | P2RA_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
14 | P2RB_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
15 | P2RD_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
16 | P2RE_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
17 | P2RH_HU_NREN | P21PA | 20 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
18 | P2RI_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
19 | P2RJ_KGT | Kijungai time occured in for-period with Position info | 11 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
20 | P2RK_GRORD | Payroll results Canada: Garnishment order | 16 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
21 | P2RK_VC2 | Vacation pay entitlement per reference year | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
22 | P2RN_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
23 | P2RO_RO_CUX | Difference table of payroll results | 6 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
24 | P2RO_RO_DIF | Difference table of payroll results | 6 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
25 | P2RQ_LSLPR | Payroll Results: LSLPR Table | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
26 | P2RQ_LVEPR | Payroll Results: LVEPR Table | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
27 | P2RQ_P5BAL | Payroll Results: P5BAL Table | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
28 | P2RQ_PASUM | Payment summary components | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
29 | P2RQ_SUPCOM | Superable salary components | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
30 | P2RR_CAW | Payroll Results: Table for CPF on AW/SG | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
31 | P2RR_RM | Payroll Results: Table for Master data (SG) | 27 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
32 | P2RR_SP | Payroll Results: Special Payments | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
33 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 25 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
34 | P2RX_ARRRS | Payroll Results: Arrears Table | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
35 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
36 | P2UN_SUPCOM | Superable salary components For NPO | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
37 | T549Q | Payroll Periods | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
38 | T549S | Personnel Date Specifications Per Payroll Period | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
39 | T7RU51AV_P | Relation between Year and WType for income for this year | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPAustria |
40 | PA0978 | HR Master Record for Infotype 0978 | 24 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
41 | T5A8D | Revaluation Factor/Number | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPBelgium |
42 | T5BVP | Definition of SI periods | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPCanada |
43 | T5K8E | HR-CA: Transfer additional external payroll results | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPCompany Pension Scheme Germany |
44 | P01CABR | Actions from Payroll Accounting | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPConstruction Industry |
45 | T5DBY | Construction Pay Data Center Numbers / SFP Data Medium | 8 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
TOPDenmark |
46 | T5M49 | Date Identifiers for Special Payroll | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
47 | T5M5Y | Assignment of Year and PBS Track to an Original Payroll | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
48 | T5M7D | Status Line for Payroll Run | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
49 | T5M7T | PBS File Entries (HR DK Payroll) | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
50 | T5M7U | Retrieval of DA-DS Statistics | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
51 | T5M7W | File Entries Assignment from T5M7V | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
52 | T5M7X | Entries for Form X1 - Special Payment Days | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
53 | T5M7Z | Field Values from Last Payroll | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
54 | T5M8E | Verify Changes to Wage Type Texts | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
55 | T5M8P | SAP-PBS interface: Transfer year-end values | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
56 | T5M8S | Employer assignment in original period | 10 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
57 | T5M8Z | Employer Assignment in Original Period | 13 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
58 | T5M9A | SAP-PBS Interface: Transfer of New Year Values | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
59 | T5M9B | SAP-PBS: Year End Values (Revision) | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
60 | T5M9C | SAP-PBS Interface: New Year Values (Revision) | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
61 | T5MFD | Retrieval of Official Statistics for DA/DS and FA | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
62 | T5MFH | Special Transfer Days for Wage Types | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
63 | T5MFJ | Correct FA Absence Statistics | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
64 | T5MP1 | General Messages for the PBS Remuneration Statement | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPFinland |
65 | T7FI549Q | Finnish pay periods to average calculation relevance | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPGermany |
66 | T5D15 | EDI Funds | 15 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
67 | T5D16 | Advanced Payment - Statement of Contributions Paid | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
68 | T5D47 | Correction of Contributions on Basis of Previous Month | 2 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
69 | T5D4U | File Numbers for E-Mail Procedure with Health Ins. Funds | 11 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPInterface to External Payroll Systems |
70 | T5UOT | Tax Services: Terminations and Inactives | 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPOff-Cycle |
71 | T52OCG | Off-Cycle: Indicators for Batch: Payroll, Subsequent Program | 11 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPayroll |
72 | PA3234 | HR master record, infotype 3234 | 35 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
73 | T7SIRI | Index valorizacije | 2 | PABRJ | Obracunsko leto | nvarchar | 4 | 0 | | |
74 | T7SIRI8 | Index valorizacije od 2008 | 2 | PABRJ | Obracunsko leto | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
75 | PA0267 | HR Master Record: Infotype 0267 (One time Payment off-cycle) | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
76 | T549M | Monthly Assignment: Payroll Period (no longer used) | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
77 | T549Z | Calendar for payment model | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
78 | T54C1 | Calendar for Cumulation | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
79 | T558B | Payroll Account Transfer: Payroll Periods | 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
80 | T569U | Logs for Control Records | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
81 | T569V | Control Records | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPension fund General Parts |
82 | T5CPB | HR-CH: Pension fund postings | 9 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
83 | T72FA | HR-PF: FI Index Table | 28 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPension fund Netherlands |
84 | T5ND1 | HR-CH: Pension fund postings | 9 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
85 | PA0015 | HR Master Record: Infotype 0015 (Additional Payments) | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
86 | PA0832 | HR master record for infotypes 0832 | 26 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
87 | T549U | Recurr. Pymts/Deducs: Payment Periods per Payment Interval | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
88 | T549X | Recurr. Pymts/Deducs: Payment Periods | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
89 | T7COT1 | Payroll external results transfer: COSSO | 8 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
90 | T7COT7 | Payroll external results transfer: COTAX | 7 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
91 | T7SIRS | Average republika Slovenia | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPersonnel Management |
92 | /BKC/S21_COMPB | C&T! - Time evaluation results | 2 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
93 | /BKC/S21_COMPBNP | C&T! - Time evaluation results | 1 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPPublic Sector |
94 | T5PBSR2F | Special MSO Calculation Rules | 5 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPRecruitment |
95 | PB0015 | Applicant Master Record Infotype 0015 (Additional Payments) | 33 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPReporting |
96 | P05T_CVZ_REG | HCIB: Registration table | 3 | PABRJ | HCIB for year period | nvarchar | 4 | 0 | | |
97 | P05T_CVZ_REG_DAT | (De)registration data for HCIB | 3 | PABRJ | HCIB for year period | nvarchar | 4 | 0 | | |
98 | P05T_CVZ_UITW | CVZ: Tabel voor uitwisselingsbestand | 3 | PABRJ | HCIB for year period | nvarchar | 4 | 0 | | |
TOPReuse Services for Country Development |
99 | PA0262 | HR Master Record: Infotype 0262 | 27 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPSocial Insurance |
100 | P01BD_STAT | Data Module Alternative Correspondence Address | 18 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
101 | P01BM_STAT | Control Records for PPO DEUEV Notifications | 22 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
102 | P01BV_STAT | Status Table for PPO Contribution Collect. Notif. Procedure | 21 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
103 | P01D3_DSAP | DEUEV Confirmation: Control Record for Notifications | 14 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
104 | P01DS_STAT | Control Records for DEUEV Immediate Notifications | 22 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
105 | P01EA_STAT | Status Table for Reimbursement Process | 19 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
106 | P01EE_STAT | Admin. Records for Data Exchange for Compensation Benefits | 20 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
107 | P01EL_PROT | Log Table for the ELENA Procedure | 14 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
108 | P01EL_STAT | Status Table for the ELENA Notification Procedure | 19 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
109 | P01ZS_STAT | Status Table for Paying Office Procedure | 19 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | |
TOPSpain |
110 | T5EI6 | Arrears by period and grouper | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPTaiwan |
111 | T7TW1N | Sequence number of LI/NHI reporting | 2 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
112 | T7TW2F | Sequence number of income tax return reporting | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
113 | T7TW2G | Tax media filing sequence number reservation | 4 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPTools |
114 | HRPYO_D_CYCL | Cycles | 6 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |
TOPUSA |
115 | T5U8A | Transfer ext.payroll result: Tax cumulation data (USA) | 3 | PABRJ | Payroll Year | nvarchar | 4 | 0 | | |