| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPJapan |
1 | T7JPCP_CALCGRP | Define Contribution Amount Calculation Groups | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
2 | T7JPCP_CALCGRPT | Contribution Amount Calculation Group Description | 5 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
3 | T7JPCP_CALGRPA | Contribution Amount Calculation Group Assignment | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
4 | T7JPCP_CBACPAR | Virtual Individual Account Balance Parameters | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
5 | T7JPCP_CBFCPAR | Re-assessment Rate Decision Factor Parameters | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
6 | T7JPCP_CBFCTBL | Reassessment Rate Factor Parameter Value Table | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
7 | T7JPCP_CLBSDAS | Calculation Basis Parameter Basic Pay Data Source | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
8 | T7JPCP_CLBSPAR | Calculation Basis Parameter | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
9 | T7JPCP_CLFCPAR | Calculation Factor Parameter | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
10 | T7JPCP_CLFCPART | Calculation Factor Parameter Text | 5 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
11 | T7JPCP_CLFCTBL | Calculation Factor Parameter Value Table | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
12 | T7JPCP_FORMULA | Calculation Formulas | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
13 | T7JPCP_PREMFML | Premium Calculation Formula | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
14 | T7JPCP_PREMPAR | Premium Rate/Amount Parameter | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
15 | T7JPCP_PREMPART | Premium Rate/Amount Parameter Text | 5 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
16 | T7JPCP_PRFCTBL | Premium Amount/Rate Parameters Value Table | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
17 | T7JPCP_REDRULE | Reduction Rule of Current Assignment Period Basis Payment | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
18 | T7JPCP_REVPERA | Assign Period Parameter | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |
19 | T7JPCP_STDKDT | Key Date for Standard Premium Parameter | 4 | CONT_CALC_GRP | Contribution Amount Calculation Group | nvarchar | 2 | 0 | | |