10 Increasing the Cohort ID length
If you want the cohort ID to accept more than 20 characters, you must manually increase thecolumn length in the following tables and columns.
Erwin Data Model Tables and Columns
You must manually increase thecolumn length in the following tables and columns in the
erwin data model. You must also upload the Erwin data model after you make these
changes.
Table 10-1 The Tables and Column names to be altered in the Erwin data model:
Table | Column |
---|---|
stg_ins_cohort_assumed_cfs | v_ri_cohort_id |
stg_ins_cohort_actuals | v_ri_cohort_id |
FSI_RI_GROUP_INPUT_DETAIL | v_ri_group_code |
stg_ins_group_dimension_map | v_ri_group_code |
stg_ins_group_dimension_map | V_GROUP_CODE |
stg_cohort_master | V_COHORT_ID |
dim_cohort | V_COHORT_ID |
fsi_ins_group_input_detail | GROUP_CODE |
fsi_ri_group_input_detail | GROUP_CODE |
STG_INS_COHORT_ASSUMED_CFS | V_COHORT_ID |
STG_INS_COHORT_ACTUALS | V_COHORT_ID |
Script Tables and Columns
You must manually increase thecolumn length in the following tables and columns in the
script:
Table 10-2 The Tables and Column names to be altered in the Erwin Data Model
Table | Column |
---|---|
FSI_IFRS17_GROUP_OUTPUT | GROUP_CODE |
fsi_ifrs17_group_projections | GROUP_CODE |
FSI_IFRS17_GROUP_ONEROUS_DTLS | GROUP_CODE |
FSI_IFRS17_RI_GROUP_ONEROUS | GROUP_CODE |
FSI_IFRS17_RI_GROUP_OUTPUT | GROUP_CODE |
fsi_ins_group_cash_flows | group_id |
fsi_ins_group_cash_flows | RI_GROUP_ID |