Skip to content

DB Context: varappuzha (PostgreSQL 13, Cooperative Bank Core Banking)

Schema: varappuzha | All tables below are in this schema.

STATUS FLAGS (universal)

  • authorize_status: AUTHORIZED | CREATED | DELETED
  • status: ACTIVE | CLOSED | DELETED
  • prod_type: OA | DEP | LOAN | ADV | SUS
  • behaves_like: SB | CA | RD | FD | TL | OD | KCC

CORE RELATIONS

customer(cust_id)
 ├─ act_master(cust_id→act_num) ← cash_trans/transfer_trans(act_num)
 ├─ deposit_acinfo(cust_id→deposit_no) ← deposit_sub_acinfo(deposit_no)
 ├─ loans_borrower(cust_id→borrow_no) ← loans_facility_details(borrow_no→acct_num)
 │    └─ loans_sanction_details(borrow_no,sanction_no)
 └─ share_acct(cust_id)
ac_hd(ac_hd_id) ─ gl(ac_hd_id) ─ ac_hd_param(ac_hd_id)
branch_master(branch_code) ─ user_master ─ day_end(branch_code)

TABLES BY MODULE

Customer/Account customer, cust_addr, cust_phone, cust_joint, cust_guardian, cust_type, cust_history act_master, act_joint, act_param_detail, act_nominee_detail, act_authorize, act_lien, act_freeze, act_charges, act_closing, act_interest, act_action_history, pass_book

Operative Accounts (Savings) op_ac_product, op_ac_account_param, op_ac_int_cat_master, op_ac_intratemaint_param, op_ac_intpay_param, op_ac_intrecv_param, op_ac_charges_param, op_ac_achead_param, op_ac_spclitem_param

Deposits (FD/RD) deposit_acinfo, deposit_sub_acinfo, deposits_product, deposits_prod_achd, deposits_prod_intpay, deposits_prod_rd, deposits_prod_renewal, deposits_prod_scheme, deposits_prod_tax deposit_recurring, deposit_rdinstall, deposit_roi_group, deposit_roi_group_cat, deposit_roi_group_prod, deposit_roi_group_type_rate deposit_tds_deduction, deposit_freeze, deposit_lien, deposit_nominee_detail, deposit_poa deposit_standing_instru, deposit_ren_list, deposit_dayend_balance, deposit_interest, deposit_provision

MDS (Chit/Monthly Deposit Scheme) mds_application, mds_master_maintenance, mds_scheme_details, mds_product_general_details, mds_product_other_details, mds_trans_details, mds_installment_schedule, mds_prized_money_details, mds_money_payment_details, mds_closure_details, mds_acct_head, mds_receipt_entry, mds_member_receipt_entry

Loans loans_borrower, loans_facility_details, loans_sanction_details, loans_sanction, loans_product loans_prod_achd, loans_prod_intcalc, loans_prod_intrec, loans_prod_charges, loans_prod_classification loans_classify_details, loans_installment, loans_repay_schedule, loans_repayment, loans_interest loans_int_maintenance, loans_disbursement, loans_drawing_power, loans_guarantor_details loans_security_details, loans_security_gold_stock, loans_security_land, loans_security_vehicle, loans_security_salary, loans_security_member loans_doc, loans_dayend_balance, loan_trans_details, loans_ots_details, loans_waive_off (Agricultural: agri_loans_ mirrors above; Advances/OD: adv_ / advances_; Bills: bills_)

Shares share_acct, share_acct_details, share_conf_details, share_dividend, share_dividend_calc_master, share_dividend_calc_details, share_joint, share_nominee_detail, share_poa, share_transfer, share_resolution

GL / Accounting gl, gl_abstract, ac_hd, mjr_ac_hd, sub_ac_hd, ac_hd_param, ac_hd_acct_info, accounthead_table, branch_gl, branch_gl_group, trans_ref_gl, gl_limit, addtogl

Transactions cash_trans, transfer_trans, trans_parameters, trans_value_date, batch_process, daily_deposit_trans

Clearing & Remittance inward_clearing, outward_clearing, inward_bouncing, outward_return, outward_tally, inward_tally clearing_param, cheque_issue, cheque_stop_payment, remittance_product, remit_issue, remit_issue_trans, rtgs_neft_acknowledgement, pay_in_slip

Branch / System Admin branch_master, user_master, role_master, access_lvl_master, day_end daily_daybegin_status, daily_daybegin_status_final, daily_dayend_status, daily_dayend_status_final holiday_master, parameters, param_settings, admin_param, screen_master, menu_master, terminal_master user_login_history, password_history, log, err_log

Employee / Payroll employee_master, employee_basic, employee_addr, employee_other_details, employee_present_details payroll, salary_master, salary_details, salary_grade, salary_structure, salary_credit salary_recovery_list_master, salary_recovery_list_detail, emp_leave, leave_application, leave_master paycodes_master, pay_account, pay_settings, scale_master, income_tax_employee, incometax_slab

Agents agent_master, agent_prod_mapping, agent_collection_prod, agent_commision_slab, agents_monthly_schedule

Locker locker_product, locker_master, locker_issue_joint, locker_operation, locker_freeze, locker_surrender, locker_prod_charges

Other atm_card_master, ace_upi_transaction, tds_config, tds_collected, service_tax_details forex_exchange_rate, forex_currency_exchange, other_bank, ifsc_bank_branch investment_master, investment_deposit, borrowing_master, drf_product, drf_transaction npa_history, reconciliation_trans, standing_instruction, sms_parameter, id_generation, lookup_master trading_purchase, trading_sales_master, trading_stock, gahan_document_details (gold appraisal) mpr_ (MPR reports), rpt_ (report config), query_report_master