| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RX_BENTAB | Benefits payroll results international | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
2 | T77BENPLANGRP | Benefits Plan Archiving Object Subgroup | 5 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
3 | T7AE17 | Benefit Plan Wage Type to Overwrite EE Cost | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
4 | T7SA27 | Benefit Plan Wage Type to Overwrite EE Cost | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPBenefit Integration |
5 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
6 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
7 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
8 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
9 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
10 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 33 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
11 | T7USBEN03 | Catch-up contribution for Savings plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
12 | T7USBEN04 | High Deductible Health Plan Contributions | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
13 | T7USBENH1 | For saving records of issued HIPAA certificates | 5 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
14 | T7USBENPE | US pension related data (e.g. Soc. Sec. wages and taxes) | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPBenefits |
15 | PA0167 | HR Master Record: Infotype 0167 (Health Plans) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
16 | PA0168 | HR Master Record: Infotype 0168 (Insurance Plans) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
17 | PA0169 | HR Master Record: Infotype 0169 (Savings Plan) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
18 | PA0170 | HR Master Record: Infotype 0170 (Flexible Spending Accounts) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
19 | PA0172 | HR Master Record: Infotype 0172 (FSA Claims) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
20 | PA0212 | HR Master Record: Infotpye 0212 (COBRA Health Plan) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
21 | PA0236 | HR Master Record: Infotype 0236 (Credit Plans) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
22 | PA0377 | HR Master Record: Infotype 0377 (Miscellaneous Plans) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
23 | PA0379 | HR Master Record: Infotype 0379 (Stock Purchase Plans) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
24 | PA0565 | HR Master Record: Infotype 0565 (Retirement Plan Val. Res.) | 25 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
25 | PA0602 | HR Master Record: Infotype 0602 (Retirement Plan Cumulation) | 25 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
26 | PA0671 | HR Master Record - Infotype 0671 (COBRA Flex. Spending Acct) | 26 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
27 | T5UB6 | Benefit Standard Health Selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
28 | T5UB7 | Benefit standard insurance selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
29 | T5UBA | Benefit plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
30 | T5UBB | Benefit health option/dependent coverage assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
31 | T5UBC | To be deleted - no longer used! | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
32 | T5UBD | To be deleted - no longer used! | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
33 | T5UBE | Benefit Health Plan Option | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
34 | T5UBG | Benefit Flexible Spending Account | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
35 | T5UBH | Benefit cost rule variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
36 | T5UBI | Benefit cost rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
37 | T5UBU | Benefit program | 5 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
38 | T5UCA | Benefit plan texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
39 | T5UCC | To be deleted - no longer used! | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
40 | T5UCE | Benefit health plan option texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
41 | T5UCH | Benefit cost rule variant texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
42 | T5UDP | To be deleted - no longer used! | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
43 | T74FA | Benefit insurance plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
44 | T74FB | Benefits Coverage Rule Variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
45 | T74FC | Benefits Insurance Coverage Rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
46 | T74FD | Benefit Savings Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
47 | T74FE | Benefit employer contribution rule variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
48 | T74FF | Benefit employer contribution rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
49 | T74FG | Benefit employee contribution rule variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
50 | T74FH | Benefit employee contribution rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
51 | T74FI | Benefit credit plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
52 | T74FJ | Benefit credit rule variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
53 | T74FK | Benefit credit rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
54 | T74FL | Benefit miscellaneous plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
55 | T74FM | Benefit Standard Savings Selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
56 | T74FN | Benefit Standard Spending Account Selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
57 | T74FO | Benefit standard credit selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
58 | T74FP | Benefit Standard Miscellaneous Selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
59 | T74FQ | Benefit standard stock purchase selection | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
60 | T74FR | Benefit evidence of insurability | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
61 | T74FS | Benefit evidence of insurability option assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
62 | T74FT | Benefit evidence of insurability option jump assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
63 | T74FU | Benefit combined coverage limit | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
64 | T74FV | Benefit combined coverage limit expression | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
65 | T74FW | Benefit combined contribution limit | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
66 | T74FX | Benefit combined contribution limit expression | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
67 | T74FY | Benefit prerequisite plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
68 | T74FZ | Benefit corequisite plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
69 | T74GA | Benefit insurance plan texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
70 | T74GB | Benefit insurance coverage rule variant texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
71 | T74GE | Benefit employer contribution rule variant texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
72 | T74GG | Benefit employee contribution rule variant texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
73 | T74GJ | Benefit credit rule variant texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
74 | T74GL | Benefit miscellaneous plan texts | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
75 | T74GU | Benefit combined coverage limit text | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
76 | T74GW | Benefit combined contribution limit text | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
77 | T74HD | Benefit stock purchase plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
78 | T74HE | Benefit payment model assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
79 | T74HH | To be deleted - no longer used! | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
80 | T74HI | Benefit reasons for off-cycle payroll assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
81 | T74HO | Benefit Equivalent Length of Service | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPClaims Processing Asia |
82 | T7XAS0 | Wage Type Assignment to Claim Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
83 | T7XAS6 | Claim variant for Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
84 | T7XAS7 | Text table for claim formula for Plan | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
85 | T7XAS8 | Claim rule for Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
86 | T7XAS9 | Assignment of Claim formula and Panel doctors to Claim Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
87 | T7XASG | Claims processing Balance table | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
88 | T7XAST | Claims processing transaction table | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPGeneral Parts |
89 | T74_FBN04 | Number of Holiday Buying or Selling for Holiday Plan | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
90 | T74_FBN05 | Flexible Benefits Holiday Buying or Selling Limitation | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
91 | T74_FBN07 | Flexible Benefits Holiday Plan Quota & Wage Type Setting | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
92 | T74_FBN08 | Annual Tax Free Boundary | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
93 | T74_FBN09 | Benefit Plan Option Jump Assignment | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
94 | T74_FBN13 | Benefit Insurance Plan Option Relevant Family | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
95 | T74_FBN16 | Annual Flexible Benefits Plan Cost Pro-rate for New Starter | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
96 | T74_FBN_GB01 | Flexible Benefits Plan General Attribute (GB) | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
97 | T74_FBN_GB02 | Flexible Benefits Plan Company Car Attribute (GB) | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
98 | T74_FBN_GB04 | Flexible Benefits Plan GB Pension Attribute | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
99 | T74_FBN_GB05 | Flexible Benefits Employee Pension Contribution Rule (GB) | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
100 | T74_FBN_GB08 | Option Salary Sacrifice of Flexible Benefit Plan GB Pension | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
101 | T74_FBN_GB11 | Email Data for GB Flexible Benefit | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPJapan |
102 | T5J98 | HR Conversion IT0144 to IT0169 JP | 5 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPMexico |
103 | T7MX50 | Administration of investment period for savings fund | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPNetherlands |
104 | P05FBN_ADD_PLAN | Flexible Benefits NL: Additional Data Benefit Plans | 3 | BPLAN | Benefit Plan | nvarchar | 4 | 0 | | |
105 | P05FBN_AFWPL | Additional Data Absence Plans | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
106 | P05FBN_AFWPL_IND | Entry Factor Absence Plans | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
107 | P05FBN_VERR | Cancellation | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
108 | P05FBN_WZR_PLAN | Set Changeable Plans for Adjustment Reasons | 5 | BPLAN | Benefit Plan | nvarchar | 4 | 0 | | |
109 | PA3200 | HR Master Record for Infotype 3200 | 25 | BPLAN | Benefit Plan | nvarchar | 4 | 0 | | |
TOPNon Profit Organizations |
110 | T7UNBEN_T5UBA | NPO Benefit Plan Cost Rule Variant | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
111 | T7UNBEN_T5UBH | NPO Benefit Cost Rule | 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
112 | T7UNBEN_T5UCH | NPO Benefit Cost Rule Text | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPPublic sector Sweden |
113 | T5SK0_CE | KPA events | 8 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
114 | T5SK1_CE | KPA absences | 8 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
115 | T5SK2_CE | KPA income | 6 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPSweden |
116 | T5SPP | HR-SE: Information needed to be reported to Alecta | 16 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |
TOPUSA |
117 | T5UPBSPA16 | Federal Health Plan Mapping (PS) | 4 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | |