FGC

Tables (50)

TB_FGC_ACL

  • acl_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
  • source_type — VARCHAR(14) — NOT NULL
  • gross_amount — NUMERIC(15,2) — NOT NULL
  • payout_rate_applied — NUMERIC(5,2)
  • net_amount — NUMERIC(15,2) — NOT NULL
  • accrual_year — INTEGER — NOT NULL
  • due_date — DATE
  • pay_mode — VARCHAR(10) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • cap_included_snapshot — BOOLEAN — NOT NULL
  • cap_check_id — BIGINT — Foreign key → TB_FGC_VCP.cap_check_id
  • batch_exec_id — BIGINT
  • close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_AFF

  • aff_id — BIGINT — Primary key — NOT NULL
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • insurer_agent_code — VARCHAR(30) — NOT NULL
  • registered_on — DATE
  • status — VARCHAR(12) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ARB

  • arb_check_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • checked_at — TIMESTAMPTZ — NOT NULL
  • applies_yn — BOOLEAN — NOT NULL
  • fee_sum_3y — NUMERIC(15,2) — NOT NULL
  • surrender_36m — NUMERIC(15,2) — NOT NULL
  • clawback_sum — NUMERIC(15,2) — NOT NULL
  • paid_premium_sum — NUMERIC(15,2) — NOT NULL
  • verdict — VARCHAR(8) — NOT NULL
  • excluded_reason — VARCHAR(20)
  • formula_snapshot — JSONB — NOT NULL
  • exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_AUD

  • audit_id — BIGINT — Primary key — NOT NULL
  • actor_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • actor_label — VARCHAR(50)
  • action — VARCHAR(40) — NOT NULL
  • entity_name — VARCHAR(60) — NOT NULL
  • entity_id — BIGINT
  • before_data — JSONB
  • after_data — JSONB
  • reason — VARCHAR(300)
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CAP

  • cap_rule_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • multiplier — NUMERIC(6,2) — NOT NULL
  • base_type — VARCHAR(30) — NOT NULL
  • target_coverage — VARCHAR(12) — NOT NULL
  • compliance_deduct_rate — NUMERIC(5,2)
  • compliance_apply_from — DATE
  • rule_from — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CBC

  • clawback_case_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • trigger_event_id — BIGINT — Foreign key → TB_FGC_CSH.status_event_id — NOT NULL
  • reason — VARCHAR(20) — NOT NULL
  • lapse_installment — INTEGER — NOT NULL
  • case_status — VARCHAR(14) — NOT NULL
  • noticed_at — DATE
  • objection_due — DATE
  • repayment_due — DATE
  • notice_amount — NUMERIC(15,2)
  • amount_provisional_yn — BOOLEAN — NOT NULL
  • notice_method — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CBD

  • clawback_line_id — BIGINT — Primary key — NOT NULL
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
  • target_acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id — NOT NULL
  • item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
  • kind — VARCHAR(12) — NOT NULL
  • paid_amount_base — NUMERIC(15,2) — NOT NULL
  • clawback_rate_id — BIGINT — Foreign key → TB_FGC_CBR.clawback_rate_id
  • applied_rate — NUMERIC(6,2) — NOT NULL
  • clawback_amount — NUMERIC(15,2) — NOT NULL
  • liable_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • calc_snapshot — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CBR

  • clawback_rate_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • scope — VARCHAR(14) — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
  • sector — VARCHAR(10)
  • product_group_code — VARCHAR(2)
  • item_scope — VARCHAR(30)
  • reason_scope — VARCHAR(20)
  • lapse_installment_from — INTEGER — NOT NULL
  • lapse_installment_to — INTEGER — NOT NULL
  • rate — NUMERIC(6,2) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CBV

  • recovery_id — BIGINT — Primary key — NOT NULL
  • clawback_case_id — BIGINT — Foreign key → TB_FGC_CBC.clawback_case_id — NOT NULL
  • method — VARCHAR(18) — NOT NULL
  • amount — NUMERIC(15,2) — NOT NULL
  • recovered_on — DATE — NOT NULL
  • payout_statement_id — BIGINT — Foreign key → TB_FGC_PYS.payout_statement_id
  • remaining_balance — NUMERIC(15,2) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CCA

  • alloc_id — BIGINT — Primary key — NOT NULL
  • pool_id — BIGINT — Foreign key → TB_FGC_CCP.pool_id — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • allocated_amount — NUMERIC(15,2) — NOT NULL
  • formula_snapshot — JSONB — NOT NULL
  • acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CCP

  • pool_id — BIGINT — Primary key — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
  • cost_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
  • total_amount — NUMERIC(15,2) — NOT NULL
  • alloc_basis — VARCHAR(24) — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CLS

  • close_id — BIGINT — Primary key — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • precheck_result — JSONB
  • closed_by — BIGINT — Foreign key → TB_FGC_USR.user_id
  • closed_at — TIMESTAMPTZ
  • note — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CON

  • contract_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • policy_no — VARCHAR(40) — NOT NULL
  • product_id — BIGINT — Foreign key → TB_FGC_PRD.product_id — NOT NULL
  • writing_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • servicing_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id — NOT NULL
  • contract_date — DATE — NOT NULL
  • converted_monthly_premium — NUMERIC(15,2) — NOT NULL
  • raw_premium_amount — NUMERIC(15,2)
  • raw_premium_basis — VARCHAR(30)
  • pay_cycle — VARCHAR(10) — NOT NULL
  • pay_period_months — INTEGER
  • coverage_class — VARCHAR(12) — NOT NULL
  • status — VARCHAR(14) — NOT NULL
  • regime — VARCHAR(10) — NOT NULL
  • customer_ref — VARCHAR(60)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CSC

  • schedule_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • plan_id — BIGINT — Foreign key → TB_FGC_DST.plan_id — NOT NULL
  • acquisition_cost — NUMERIC(15,2) — NOT NULL
  • basis_note — VARCHAR(300)
  • monthly_maint_amount — NUMERIC(15,2) — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • generated_at — TIMESTAMPTZ — NOT NULL
  • regenerated_of — BIGINT — Foreign key → TB_FGC_CSC.schedule_id
  • active_yn — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CSH

  • status_event_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL
  • event_date — DATE — NOT NULL
  • elapsed_installment — INTEGER
  • amount — NUMERIC(15,2)
  • before_status — VARCHAR(14) — NOT NULL
  • after_status — VARCHAR(14) — NOT NULL
  • source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_CSL

  • schedule_line_id — BIGINT — Primary key — NOT NULL
  • schedule_id — BIGINT — Foreign key → TB_FGC_CSC.schedule_id — NOT NULL
  • seq — INTEGER — NOT NULL
  • due_month — VARCHAR(7) — NOT NULL
  • component_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
  • planned_amount — NUMERIC(15,2) — NOT NULL
  • recipient_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • status_reason — VARCHAR(200)
  • acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
  • ledger_entry_id — BIGINT — Foreign key → TB_FGC_JEL.entry_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_DSC

  • component_id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TB_FGC_DST.plan_id — NOT NULL
  • component_code — VARCHAR(20) — NOT NULL
  • monthly_rate — NUMERIC(6,3) — NOT NULL
  • basis — VARCHAR(20) — NOT NULL
  • from_seq — INTEGER — NOT NULL
  • to_seq — INTEGER — NOT NULL
  • cap_note — VARCHAR(200)
  • reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
  • unconfirmed_yn — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_DST

  • plan_id — BIGINT — Primary key — NOT NULL
  • plan_code — VARCHAR(10) — NOT NULL
  • plan_name — VARCHAR(60) — NOT NULL
  • total_installments — INTEGER — NOT NULL
  • applies_contract_from — DATE — NOT NULL
  • applies_contract_to — DATE
  • reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_EXC

  • exception_id — BIGINT — Primary key — NOT NULL
  • exc_type — VARCHAR(24) — NOT NULL
  • severity — VARCHAR(8) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • ref_entity — VARCHAR(60) — NOT NULL
  • ref_id — BIGINT — NOT NULL
  • assignee_user_id — BIGINT — Foreign key → TB_FGC_USR.user_id
  • opened_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ
  • resolution_note — VARCHAR(400)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_EXP

  • expected_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id — NOT NULL
  • installment_no — INTEGER
  • period_month — VARCHAR(7) — NOT NULL
  • expected_amount — NUMERIC(15,2) — NOT NULL
  • basis_snapshot — JSONB — NOT NULL
  • batch_exec_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_FC

  • agent_id — BIGINT — Primary key — NOT NULL
  • agent_code — VARCHAR(20) — NOT NULL
  • agent_name — VARCHAR(60) — NOT NULL
  • rank — VARCHAR(14) — NOT NULL
  • org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id — NOT NULL
  • recruiter_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • appointed_on — DATE — NOT NULL
  • terminated_on — DATE
  • status — VARCHAR(12) — NOT NULL
  • life_registered_yn — BOOLEAN — NOT NULL
  • nonlife_registered_yn — BOOLEAN — NOT NULL
  • guarantee_insured_yn — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_FCH

  • agent_change_id — BIGINT — Primary key — NOT NULL
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • change_type — VARCHAR(14) — NOT NULL
  • before_value — VARCHAR(60)
  • after_value — VARCHAR(60)
  • effective_from — DATE — NOT NULL
  • reason — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_INC

  • incentive_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
  • program_name — VARCHAR(200) — NOT NULL
  • product_scope — VARCHAR(300)
  • valid_from — DATE — NOT NULL
  • valid_to — DATE — NOT NULL
  • next_month_rate — NUMERIC(7,2)
  • y2_after_rate — NUMERIC(7,2)
  • condition_note — VARCHAR(400)
  • source_doc — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_INS

  • insurer_id — BIGINT — Primary key — NOT NULL
  • insurer_code — VARCHAR(20) — NOT NULL
  • insurer_name — VARCHAR(100) — NOT NULL
  • sector — VARCHAR(10) — NOT NULL
  • lapse_deduct_timing — VARCHAR(12) — NOT NULL
  • active_yn — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_IPD

  • ipd_id — BIGINT — Primary key — NOT NULL
  • ips_id — BIGINT — Foreign key → TB_FGC_IPS.ips_id — NOT NULL
  • from_installment — INTEGER — NOT NULL
  • to_installment — INTEGER — NOT NULL
  • payable_yn — BOOLEAN — NOT NULL
  • pay_timing — VARCHAR(10)
  • note — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_IPS

  • ips_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • product_scope — VARCHAR(300)
  • changed_from — DATE
  • rule_note — VARCHAR(400)
  • reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ISL

  • statement_line_id — BIGINT — Primary key — NOT NULL
  • statement_id — BIGINT — Foreign key → TB_FGC_ISM.statement_id — NOT NULL
  • line_type — VARCHAR(12) — NOT NULL
  • policy_no_raw — VARCHAR(40) — NOT NULL
  • matched_contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
  • item_raw — VARCHAR(60)
  • matched_item_id — BIGINT — Foreign key → TB_FGC_ITM.item_id
  • installment_no — INTEGER
  • amount — NUMERIC(15,2) — NOT NULL
  • pay_date — DATE
  • agent_code_raw — VARCHAR(30)
  • matched_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ISM

  • statement_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • upload_file_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id — NOT NULL
  • total_amount — NUMERIC(15,2)
  • line_count — INTEGER
  • status — VARCHAR(12) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ITM

  • item_id — BIGINT — Primary key — NOT NULL
  • item_code — VARCHAR(30) — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(16) — NOT NULL
  • cap_included_yn — BOOLEAN — NOT NULL
  • arbitrage_included_yn — BOOLEAN — NOT NULL
  • allocation_type — VARCHAR(12) — NOT NULL
  • reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
  • note — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_JEH

  • journal_id — BIGINT — Primary key — NOT NULL
  • journal_no — VARCHAR(30) — NOT NULL
  • journal_type — VARCHAR(14) — NOT NULL
  • posted_at — TIMESTAMPTZ — NOT NULL
  • reversal_of — BIGINT — Foreign key → TB_FGC_JEH.journal_id
  • close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
  • batch_exec_id — BIGINT
  • description — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_JEL

  • entry_id — BIGINT — Primary key — NOT NULL
  • journal_id — BIGINT — Foreign key → TB_FGC_JEH.journal_id — NOT NULL
  • line_no — INTEGER — NOT NULL
  • account_code — VARCHAR(30) — NOT NULL
  • debit — NUMERIC(15,2) — NOT NULL
  • credit — NUMERIC(15,2) — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • source_acl_id — BIGINT — Foreign key → TB_FGC_ACL.acl_id
  • source_clawback_id — BIGINT — Foreign key → TB_FGC_CBD.clawback_line_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_MPC

  • profile_col_id — BIGINT — Primary key — NOT NULL
  • profile_id — BIGINT — Foreign key → TB_FGC_MPP.profile_id — NOT NULL
  • source_column — VARCHAR(100) — NOT NULL
  • target_field — VARCHAR(100) — NOT NULL
  • transform_expr — VARCHAR(300)
  • required_yn — BOOLEAN — NOT NULL
  • sample_value — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_MPP

  • profile_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • file_type — VARCHAR(20) — NOT NULL
  • profile_name — VARCHAR(100) — NOT NULL
  • version_no — INTEGER — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • note — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ORG

  • org_id — BIGINT — Primary key — NOT NULL
  • org_code — VARCHAR(20) — NOT NULL
  • org_name — VARCHAR(100) — NOT NULL
  • org_type — VARCHAR(12) — NOT NULL
  • parent_org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
  • manager_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • assoc_registered_yn — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PLV

  • policy_version_id — BIGINT — Primary key — NOT NULL
  • policy_type — VARCHAR(20) — NOT NULL
  • version_no — INTEGER — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • status — VARCHAR(10) — NOT NULL
  • reg_id — BIGINT — Foreign key → TB_FGC_REG.reg_id — NOT NULL
  • params — JSONB
  • approved_by — VARCHAR(50)
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PMH

  • payment_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • installment_no — INTEGER — NOT NULL
  • paid_on — DATE — NOT NULL
  • paid_amount — NUMERIC(15,2) — NOT NULL
  • method — VARCHAR(20)
  • source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PRD

  • product_id — BIGINT — Primary key — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • product_code — VARCHAR(30) — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • line — VARCHAR(12) — NOT NULL
  • coverage_class — VARCHAR(12) — NOT NULL
  • product_group — VARCHAR(30)
  • sales_channel — VARCHAR(10) — NOT NULL
  • clawback_group — VARCHAR(2)
  • version_no — INTEGER — NOT NULL
  • effective_from — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PRT

  • payout_rate_id — BIGINT — Primary key — NOT NULL
  • policy_version_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • scope — VARCHAR(14) — NOT NULL
  • rank — VARCHAR(14)
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • line — VARCHAR(12) — NOT NULL
  • perf_band_from — NUMERIC(15,2)
  • perf_band_to — NUMERIC(15,2)
  • rate — NUMERIC(5,2) — NOT NULL
  • agreement_type — VARCHAR(10) — NOT NULL
  • valid_from_quarter — VARCHAR(7) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PST

  • persistency_id — BIGINT — Primary key — NOT NULL
  • scope — VARCHAR(8) — NOT NULL
  • scope_id — BIGINT
  • base_month — VARCHAR(7) — NOT NULL
  • k_installment — INTEGER — NOT NULL
  • rate — NUMERIC(5,2) — NOT NULL
  • numerator — NUMERIC(15,2)
  • denominator — NUMERIC(15,2)
  • include_flags — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_PYS

  • payout_statement_id — BIGINT — Primary key — NOT NULL
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • gross_total — NUMERIC(15,2) — NOT NULL
  • clawback_offset — NUMERIC(15,2) — NOT NULL
  • ops_fee_deduct — NUMERIC(15,2) — NOT NULL
  • work_support_deduct — NUMERIC(15,2) — NOT NULL
  • risk_reserve_deduct — NUMERIC(15,2) — NOT NULL
  • taxable_income — NUMERIC(15,2) — NOT NULL
  • income_tax — NUMERIC(15,2) — NOT NULL
  • local_tax — NUMERIC(15,2) — NOT NULL
  • net_pay — NUMERIC(15,2) — NOT NULL
  • close_id — BIGINT — Foreign key → TB_FGC_CLS.close_id
  • status — VARCHAR(12) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_RAS

  • reassign_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • from_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • to_agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id — NOT NULL
  • reason — VARCHAR(20) — NOT NULL
  • successor_pay_rate — NUMERIC(5,2) — NOT NULL
  • effective_from — DATE — NOT NULL
  • approved_by — BIGINT — Foreign key → TB_FGC_USR.user_id
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_RCL

  • recon_line_id — BIGINT — Primary key — NOT NULL
  • recon_run_id — BIGINT — Foreign key → TB_FGC_RCR.recon_run_id — NOT NULL
  • expected_id — BIGINT — Foreign key → TB_FGC_EXP.expected_id
  • statement_line_id — BIGINT — Foreign key → TB_FGC_ISL.statement_line_id
  • diff_amount — NUMERIC(15,2) — NOT NULL
  • mismatch_type — VARCHAR(20) — NOT NULL
  • judgement — VARCHAR(10) — NOT NULL
  • exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_RCR

  • recon_run_id — BIGINT — Primary key — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id — NOT NULL
  • ran_at — TIMESTAMPTZ — NOT NULL
  • tolerance_policy_id — BIGINT — Foreign key → TB_FGC_PLV.policy_version_id — NOT NULL
  • matched_count — INTEGER
  • mismatched_count — INTEGER
  • status — VARCHAR(12) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_REG

  • reg_id — BIGINT — Primary key — NOT NULL
  • reg_code — VARCHAR(20) — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • source_type — VARCHAR(16) — NOT NULL
  • source_ref — VARCHAR(300)
  • effective_date — DATE
  • unconfirmed_yn — BOOLEAN — NOT NULL
  • note — VARCHAR(400)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_ROL

  • role_id — BIGINT — Primary key — NOT NULL
  • role_code — VARCHAR(20) — NOT NULL
  • role_name — VARCHAR(60) — NOT NULL
  • description — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_SRV

  • surrender_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • as_of_installment — INTEGER — NOT NULL
  • as_of_date — DATE
  • amount — NUMERIC(15,2) — NOT NULL
  • source — VARCHAR(10) — NOT NULL
  • source_upload_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_STG

  • staging_row_id — BIGINT — Primary key — NOT NULL
  • upload_file_id — BIGINT — Foreign key → TB_FGC_UPF.upload_file_id — NOT NULL
  • row_no — INTEGER — NOT NULL
  • raw_data — JSONB — NOT NULL
  • normalized_data — JSONB
  • valid_yn — BOOLEAN — NOT NULL
  • error_message — VARCHAR(400)
  • applied_entity — VARCHAR(60)
  • applied_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_UPF

  • upload_file_id — BIGINT — Primary key — NOT NULL
  • file_name — VARCHAR(200) — NOT NULL
  • file_hash — VARCHAR(64) — NOT NULL
  • insurer_id — BIGINT — Foreign key → TB_FGC_INS.insurer_id
  • file_type — VARCHAR(20) — NOT NULL
  • period_month — VARCHAR(7) — NOT NULL
  • uploaded_by — BIGINT — Foreign key → TB_FGC_USR.user_id — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • row_count — INTEGER
  • error_count — INTEGER
  • storage_path — VARCHAR(300) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_USR

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • user_name — VARCHAR(60) — NOT NULL
  • role_id — BIGINT — Foreign key → TB_FGC_ROL.role_id — NOT NULL
  • scope_org_id — BIGINT — Foreign key → TB_FGC_ORG.org_id
  • agent_id — BIGINT — Foreign key → TB_FGC_FC.agent_id
  • status — VARCHAR(12) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL

TB_FGC_VCP

  • cap_check_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — Foreign key → TB_FGC_CON.contract_id — NOT NULL
  • trigger_type — VARCHAR(20) — NOT NULL
  • checked_at — TIMESTAMPTZ — NOT NULL
  • cap_rule_id — BIGINT — Foreign key → TB_FGC_CAP.cap_rule_id — NOT NULL
  • limit_amount — NUMERIC(15,2) — NOT NULL
  • included_total — NUMERIC(15,2) — NOT NULL
  • usage_pct — NUMERIC(7,2) — NOT NULL
  • verdict — VARCHAR(8) — NOT NULL
  • detail_snapshot — JSONB — NOT NULL
  • exception_id — BIGINT — Foreign key → TB_FGC_EXC.exception_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT
  • updated_at — TIMESTAMPTZ — NOT NULL