1. Overview 
Under the Online Time Deposit project (2020)in Hogan they have  developed the New Fund calculation engine to track the new funds deposited by the customers.  The purpose is to offer an higher interest rate to the client,  who open their Time Deposit on Online / Mobile banking using the new funds brought in by customer.  

New funds are identified by specific transaction codes and tracked  up to last  five working days .  Also, the utilisation of the new fund is also tracked as and when a new deposit is created using such fund. 

Hogan Specification 

https://confluence.global.standardchartered.com/pages/viewpage.action?spaceKey=CB&title=Online++Time+Deposit+-+New+Funds+Engine

2. Proposed Process 
Atlas does not have this feature and will built similar feature with enhanced controls .

2.1. New Fund Definition
Tracking will be driven by Customer segments 

Source of Funds Only Credits

Outside the bank 

Cash

Cheque

Cashier Order

Bank Transfers through CHATs

TT

FPS



Redemption from Investment Products
ELI
Debt Securities (Bonds & Structured Products)
Insurance
Securities
Unit Trust 
FX  Conversion 
Converting from HKD to USD etc is considered as fresh funds
Total New funds  =  Sum of new funds  from current day and last 4 business working days (identified through specific transaction types / codes)
Utilized funds  =  Funds used to create deposit from Digital channels (identified through specific transaction types / codes) tracked for current day and previous 4 working days
Available New Funds = Total New funds - Utilized Funds 
Funds at individual account level gets consolidated at Customer level based on currency; This consolidation at customer level is based on primary holder of an account
New Funds are captured at account level, and sum up to customer level 
Reversal and backdated transaction are not considered 
All transaction in Atlas can be identified by transaction code . Existing feature (Statistical groups) for  tracking the incoming credits will be re used. 

NOTE: For the new fund tracking, certain transactions from certain channels might required to be tracked through Statistical group. This can be achieved by defining different transaction codes for different channels and mapped to the defined statistical group for New Funds Engine. 



Hogan /Atlas Setup

New Funds Txn codes.xlsx



 Click here to expand...
2.2.
New Fund Definition Parameter 
New fund definition parameter screen to define the segment that will be eligible for tracking new funds .  Since definition is by segment it is not restricted only to Retail segments  .



Attributes :

Statistical group code  :   To identify and track incoming funds 
New Fund Definition Days  :  Defines the number of days to track for new funds 
History Tracking Days: Defines the number of days to track new funds entries in history table
Segment code: Segment code for which new funds needs to be tracked (Child table)


Primary Keys: 

Parent Table

Statistical Group Code 
Child Table

Statistical Group Code 
Segment Code

Tables to be created: NFNDDAYS, NFNDDAYSDT

KEYSTONEHK-11043 - Jira server returned an error: [Ljava.lang.Object;@5cc0b16d

2.3. New Fund Definition Parameter Enquiry
This will be enquiry corresponding to the New funds Parameter screen. 

Input Parameter:

Segment Code 


KEYSTONEHK-11049 - Jira server returned an error: [Ljava.lang.Object;@5cc0b16d

2.4. NTB Definition in Atlas 
Proposed logic in Atlas to identify if the customer is an NTB (NOTE : Same as current NTB definition in iBanking)

Oldest CASA Account opening date => System date - 60
Relationship ID open date => System date - 365 days
Atlas will parametrized the values and basis the parameters system will calculate and validate if the customer is NTB or ETB.