# 20231117 Fri. 1600-1700 intellect meeting

### First, we would like to discuss the issues mentioned in the email：
- [x] 1. 是否能提供idl_lms.m_proj_finbal_view組合的SQL Script？
Can you provide an SQL script for idl_lms.m_proj_finbal_view combinations?
- [x] 1. of_dit.gr010mb與idl_lms.gr010mb兩張資料表用途有何不同？
What are the different purposes of of_dit.gr010mb and idl_lms.gr010mb?
- [x] 1. 事實上我們在LMS資料庫中找不到gr010mb這張資料表，只找的到gr010mb1，想確認這兩張是否為同樣的內容?
It appears that we cannot find the "gr010mb" table in the LMS database, but we can only find "gr010mb1." We would like to confirm if these two tables contain the same content.
4. 請協助填寫以下表格的重要參數：
The Properties of below table (Transactional/Non-transactional、Primary Key、UpdateTimestamp)
https://docs.google.com/spreadsheets/d/1B76Pz7--Vg9v5Dh4_BD8l5QjY2e4qv-g/edit?usp=sharing&ouid=103663549630509319624&rtpof=true&sd=true

Ps.Definition of Transactional/Non-transactional
"Transactional" means that when there is new data written into a table, it will only continue to add new rows without modifying old data, as seen in transactional tables such as transaction records.

"Non-transactional" means that when new data is written, it may not only add new rows but also directly modify the content of existing columns, such as the order status in an order data table.

### Other new questions:
1. 我們可以在哪張資料表找到轉資訊，另外是否會註記在 m_proj_info 中，是用mpi_dpd_REC_ST判斷轉催、轉呆和結清嗎?
Where can we Find the "Actual Write-Off Amount" in intellect database table?
And will cases transferred to Write-Off status be annotated in the m_proj_info table?
We use this field (mpi_dpd_REC_ST(A - Authorized record、C - Closed))to exclude customers who have been transferred for collection轉催, written off轉呆, or settled結清, correct?

- [x] 1. 在這張資料表(P_FEES_CHARGES_COMPONENTS)中，PFCC_FEE_CD 是如何與目前貸款案件對應的?PFCC_COMPONENT是否可由使用者自定義呢?
In this table (P_FEES_CHARGES_COMPONENTS), how does PFCC_FEE_CD correspond to the current loan cases? Can the PFCC_COMPONENT be customized by the user?

- [x] 1. 想請問m_proj_info資料表，mpi_proj_id ,mpi_cust_id,.mpi_con_id 這三個欄位合起來是否應該是唯一值呢?目前從資料表中看起來，這三個欄位合起來仍然有重複的問題。
May I inquire about the M_Proj_info table? Should the combination of mpi_proj_id, mpi_cust_id, and mpi_con_id be unique? Currently, it appears that there are still duplicates in the combined values of these three columns in the table.

- [x] 1. 請問如何於intellect 資料表中，找到哪些客戶是轉呆帳(Write-Off)後又有還錢（轉呆後收回）的紀錄？
How can I identify customers in the 'Intellect' table who have records of both 'Write-Off' and subsequent repayment ('Repayment after Write-Off')? Please provide a query to achieve this.

1. 我們想計算客戶的額度使用率，並使用「已使用額度/已核准額度」來計算，想請問已使用額度建議是由clms裡的CL006MB.LMT_UTL_CURBAL資料欄位計算、還是從lms裡將各筆loan outstanding balance的加總？
We want to calculate the utilization rate of customers and use the formula 'Used Quota/(divided)Approved Quota' for the calculation. Could you please clarify whether the 'Used Quota' should be derived from the **'CL006MB.LMT_UTL_CURBAL'** field in the 'clms' dataset or by **summing up the outstanding balances of all loans** from the 'lms' dataset?