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