| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RJ_JP_CPT | Payroll result: Retirement Benefit Result | 6 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
TOPJapan |
2 | PA0888 | HR Master Record: Infotype 0888 | 24 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
3 | PA0889 | HR Master Record: Infotype 0889 | 24 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
4 | PA0903 | HR Master Record: Infotype 0903 | 24 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
5 | T7JPBP_ALLOCSA | Assign Allocation Course to Retirement Benefit Plan | 5 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
6 | T7JPCP_APPOFFI | Define Applied Office Data | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
7 | T7JPCP_BENATTR | Define Benefit Attributes | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
8 | T7JPCP_BENMODA | Assign Benefit Modifier to Pension Plan | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
9 | T7JPCP_CALCGRP | Define Contribution Amount Calculation Groups | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
10 | T7JPCP_CALCGRPT | Contribution Amount Calculation Group Description | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
11 | T7JPCP_CALGRPA | Contribution Amount Calculation Group Assignment | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
12 | T7JPCP_CBACPAR | Virtual Individual Account Balance Parameters | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
13 | T7JPCP_CBFCPAR | Re-assessment Rate Decision Factor Parameters | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
14 | T7JPCP_CBFCTBL | Reassessment Rate Factor Parameter Value Table | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
15 | T7JPCP_CLBSDAS | Calculation Basis Parameter Basic Pay Data Source | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
16 | T7JPCP_CLBSPAR | Calculation Basis Parameter | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
17 | T7JPCP_CLFCPAR | Calculation Factor Parameter | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
18 | T7JPCP_CLFCPART | Calculation Factor Parameter Text | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
19 | T7JPCP_CLFCTBL | Calculation Factor Parameter Value Table | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
20 | T7JPCP_CTRC | Maintain Contract Data | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
21 | T7JPCP_DBBERQ | Pension Benefit Eligibility Requisites | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
22 | T7JPCP_DCDTRMD | Distribution Method of Amount Exceeding Maximum Contribution | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
23 | T7JPCP_DTFLSTR | Define Data File Structure | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
24 | T7JPCP_DTRUL | Define Contribution Determination and Reference Date Rule | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
25 | T7JPCP_ELGRQ | Participation Eligibility Requisites | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
26 | T7JPCP_FORMRCD | Define Form Record | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
27 | T7JPCP_FORMRCDT | Define Form Record Description | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
28 | T7JPCP_FORMSPC | Define Form Specification | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
29 | T7JPCP_FORMULA | Calculation Formulas | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
30 | T7JPCP_IMPLCO | Define Corporate-type DC plan Implementing Companies | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
31 | T7JPCP_INELGRQ | Participation Ineligibility Requisites | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
32 | T7JPCP_PAYMTHD | Define Pre-paid Retirement Allowance Contribution Method | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
33 | T7JPCP_PAYPER | Define Pre-paid Retirement Allowance Calculatuion period | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
34 | T7JPCP_PENSION | Corporate Pension Plan | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
35 | T7JPCP_PENSIONT | Corporate Pension Plan Text Table | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
36 | T7JPCP_PGPLNAS | Assign Participant Group to Pension Plan | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
37 | T7JPCP_PREMFML | Premium Calculation Formula | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
38 | T7JPCP_PREMPAR | Premium Rate/Amount Parameter | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
39 | T7JPCP_PREMPART | Premium Rate/Amount Parameter Text | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
40 | T7JPCP_PRFCTBL | Premium Amount/Rate Parameters Value Table | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
41 | T7JPCP_REDRULE | Reduction Rule of Current Assignment Period Basis Payment | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
42 | T7JPCP_REPCO | Define Corporate-type DC plan Representitive Company | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
43 | T7JPCP_REVPERA | Assign Period Parameter | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
44 | T7JPCP_STDKDT | Key Date for Standard Premium Parameter | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
45 | T7JPCP_SUBPLN | DB Plan Sub Plan | 2 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |
46 | T7JPCP_SUBPLNT | DB Plan Sub Plan Text Table | 3 | RET_BEN_PLN | Retirement Benefits Plan | nvarchar | 4 | 0 | | |