| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RJ_JP_CPT | Payroll result: Retirement Benefit Result | 7 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
TOPJapan |
2 | T7JPBP_ALLOCSA | Assign Allocation Course to Retirement Benefit Plan | 6 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
3 | T7JPCP_CALCGRP | Define Contribution Amount Calculation Groups | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
4 | T7JPCP_CALCGRPT | Contribution Amount Calculation Group Description | 4 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
5 | T7JPCP_CALGRPA | Contribution Amount Calculation Group Assignment | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
6 | T7JPCP_CBACPAR | Virtual Individual Account Balance Parameters | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
7 | T7JPCP_CBFCPAR | Re-assessment Rate Decision Factor Parameters | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
8 | T7JPCP_CBFCTBL | Reassessment Rate Factor Parameter Value Table | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
9 | T7JPCP_CLBSDAS | Calculation Basis Parameter Basic Pay Data Source | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
10 | T7JPCP_CLBSPAR | Calculation Basis Parameter | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
11 | T7JPCP_CLFCPAR | Calculation Factor Parameter | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
12 | T7JPCP_CLFCPART | Calculation Factor Parameter Text | 4 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
13 | T7JPCP_CLFCTBL | Calculation Factor Parameter Value Table | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
14 | T7JPCP_DBBERQ | Pension Benefit Eligibility Requisites | 4 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
15 | T7JPCP_FORMULA | Calculation Formulas | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
16 | T7JPCP_PREMFML | Premium Calculation Formula | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
17 | T7JPCP_PREMPAR | Premium Rate/Amount Parameter | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
18 | T7JPCP_PREMPART | Premium Rate/Amount Parameter Text | 4 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
19 | T7JPCP_PRFCTBL | Premium Amount/Rate Parameters Value Table | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
20 | T7JPCP_REDRULE | Reduction Rule of Current Assignment Period Basis Payment | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
21 | T7JPCP_REVPERA | Assign Period Parameter | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
22 | T7JPCP_STDKDT | Key Date for Standard Premium Parameter | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |
23 | T7JPCP_SUBPLN | DB Plan Sub Plan | 3 | SUB_PLAN | Corporate Pension Sub-plan | nvarchar | 4 | 0 | | |