Home

LEP Transactions User Manual

1. Policy Maintenance Detail New 5 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number SI Load Override Default Load Details Policy Information Policy Details Additional Details Intermediary Details Beneficiary Details Constituent Details MEAS Load Override Details 10f1 Policy Number Transaction Number Transaction Date Fund ID Policy holder LoadID Transaction Type R m r Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open DateTime Authorized This section is only enabled for funds that have allocation time loads mapped to them as applicable for the transaction type Policy Number Optional System displays the Policy Number Transaction Number Optional System displays the Transaction Number Transaction Date Optional System displays the Transaction Date Fund ID Optional System displays the Fund ID Policy Holder Optional System displays the Policy Holder Load ID Optional System displays the Load ID Transaction Type Optional System defaults the Transaction Type val ORACLE 3 2 2 8 Ref Type Optional System defaults the Reference Type Projected Return Value Optional The Syste
2. sseeseisseeeiinseeerrnrseerrrnrerrnnnnnee 8 2 8 2 3 Saving Information Entered eeessssereesiieneernnnnerrrnnnnnrrnnnnenenrnnerrnnnnneeanae 8 2 8 3 Cession Maintenance Summary Screen ssssssssssseeirsserirrssstrretsttrrrsttttrnsssrenssent 8 3 8 3 1 Retrieving Cession Maintenance in Cession Maintenance Screen 8 3 8 3 2 Editing Cession Maintenance sssesesrsrrrrserrrnerrrnnnnerrrnnurrrnnnnnnerrnnrrranne 8 4 8 3 3 Viewing Cession Maintenance seesesrsreesrrerrrrrnnnrerrrrenrrenannneerrrnerrennne 8 4 8 3 4 Deleting Cession Maintenance esssseeeesrrrierrrrrrrerrrrnnnrrrnnnneerrrnnsrrennnnee 8 4 8 3 5 Authorizing Cession Maintenance ssseeesesseeerinnserrnnnreernrnneeernnneeern 8 5 8 3 6 Amending Cession Maintenance ee ssseessisssesrirnrerrrnreeernnrreerrnnreeenene 8 5 8 3 7 Authorizing Amended Cession Maintenance sseeeeiisseeeeessneererreeeen 8 5 Policy Cession Maintenance ssssssssssnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnne 9 1 gT MOdUSTO Menene E EE a ten es 9 1 10 11 9 2 Attaching Cession ID to Policy eee eeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeesenaaeeeeeeeaeeees 9 1 92 1 INVOKING Sro eene a E EO iets a nd ee ee 9 1 9 2 2 Fields in Policy Cession Maintenance SCIreen ccccccesseeceeessieeeeeeenaes 9 2 9 2 3 Saving Information Entered ccccccccceceeceeeeseeeeeeeenneeeeeeesneeeeesssaeeeee
3. 6 3 4 6 3 5 6 3 6 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Policy Transaction Surrender screen is opened in view mode Deleting Surrender Transaction You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Transaction Surrender Summary screen as follows 1 Invoke the Policy Transaction Surrender Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Transaction Surrender Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Surrender Transaction An unauthorize
4. Rule Effective Date dd MM yyyy Mandatory When you enter the Policy Number the Rule Effective Date which is the date from which the new status of the Policy is effective will be displayed You will not be allowed to change this field ice ORACLE Present Status Display When you enter the Policy Number the existing status of the Policy will be displayed You will not be allowed to change this field Present Status Code Display Each status carries a Status Code The existing status code of the Policy will be displayed You will not be allowed to change this field New Status Mandatory Select the new status of the Policy from the option list Note When you change the status of a Policy to Death Without Commutation Death With Commutation Policy Holder Retirement and Early Policy Holder Retirement all standing instructions on premium annuity recurring switch will be cancelled When you change the status of a Policy to Matured surrenders on the Policy will not be validated against the Surrender Limit The Policy Holder will be allowed to carry out as many surrender transactions as he wishes New Status Code Display When you select the changed status of the Policy the new status code will be displayed You will not be allowed to change this field Generate Redemption Transaction Mandatory If you want redemption transaction to be generated for the policy sele
5. You can invoke the Cession Maintenance Summary screen by typing LESCMSD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Cession Maintenance Summary Authorized Open X Cession ID a Cession Type SelectOne v Advanced Search Records per page 15 v 1 of 1 a Authorized Open Cession ID Cession Type 8 3 1 Retrieving Cession Maintenance in Cession Maintenance Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in Cession Maintenance Summary screen 1 Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved 2 Select the status of the record in the open field If you choose the Blank Space option then all the records are retrieved e Cession ID e Cession Type After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the re
6. m Load Details Section Transaction Number Mandatory Enter the transaction number Fund ID Mandatory Enter the fund ID Load ID Mandatory Select the ID of the load that must be applied for the selected product 128 ORACLE From Entity Mandatory Specify the entity that bears this load To Entity Mandatory Specify the entity that will be recipients of the load Load Amount Mandatory Enter the load amount Load Amount in Fee Currency Mandatory Enter the load amount in fee currency Note If load is applied at product level the policy transaction amount gets converted in terms of product base currency while computing the amount slabs The transaction amount in product base currency is calculated using the latest available exchange rate for the default source If exchange rate is not available for the currency pair the allocation fails 126 ORACLE 13 Annexure 13 1 Introduction This annexure explains certain procedures that apply to both the LEP and UT modules References to the Agency Branch and Fund Manager User Manuals have been made For complete information on the procedures and processes that have been mentioned here refer to the manuals mentioned 13 2 Fund Distribution Processing The system tracks the dividends proceeds separately for Unit Trust UT Transactions and Policies The dividend on a Policy is always reinvested The dividend due for a policy
7. Fax Number Optional Enter the fax number of the beneficiary ou ORACLE 3 2 2 6 Email ID Optional Enter the email ID of the beneficiary Account Details Bank Optional Specify the bank code of the beneficiary s bank You can select the same from the option list if the bank code is a valid code in the system Branch Display The branch of the bank is defaulted for the selected beneficiary bank Account Currency Account Number Account Type Display The values are defaulted for the selected beneficiary bank IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the account holder Specifying Constituent Details When you click Constituent Details link the following screen is invoked Policy Maintenance Detail New 753 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Si Laad Override Default Load Details Policy information Policy Details Additional Details Intermediary Details Beneficiary Details RMMENNEEIEI Load Override Details Constituent Details Existing UH X Constituent ID Constituent Type Relationship Description Description Status Personal Details FirstName Date Of Birth Middle Name Last Name Address Details Address City Zip Code State or Country Account Details Branch Bank Bank Name Branch Name Payment Details Asset Allocation Premium Details Annuity Details R
8. IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the account holder Saving the information entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button 10 4 ORACLE 10 3 Policy Journal Maintenance Summary Screen You can invoke the Policy Journal Maintenance Summary screen by typing LESPLJNL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Journal Maintenance Summary Authorized Open Journal Txn Number Reference Number Journal Txn Date E3 From Date To Date Advanced Search Reset Records per page 15 v 1 of 1 Authorized Open Journal Txn Number Reference Number Journal Txn Date FromDate ToDate Policy Num 10 3 1 Retrieving Policy Journal Entry in Policy Journal Maintenance Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Policy Journal Maintenance Summary screen e Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved e Select
9. Policy Term Years Optional You can enter the policy term Sig ORACLE 3 2 2 3 Specifying Additional Details When you click Additional Details link the following screen is invoked Policy Maintenance Detail New 9 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Policy Information Policy Details MMNEEEEEMIE Intermediary Details Beneficiary Details Constituent Details Load Override Details Maximum Annual Add Investment Step Contribution Amount Minimum Withdrawal Minimum Annual Maximum Withdrawal Withdrawal Limit Percentage Participating Employer Additional Investments X Description Allowed Auto Clear Provisional Minuimum Additional Balance bwasiment Option Not Allowed X Maximum Additional Auto Clear Investment Reinvestments Option Not Allowed X Remarks Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open Exit DateTime Authorized Maximum Annual Contribution Numeric Optional This is the maximum amount that the Policy Holder can invest annually in a Policy in this Product This amount includes top ups if any The amount displayed is the amount specified for the Product You can change the same for the Policy Minimum Wi
10. Unit Holder CIF Number a Apply At CIF Level Apply Deal At Not Selected v Load ID Records per page 15 v 1of1 Authorized Open Status DealTransaction Number Unit Holder CIF Number FirstName Apply At CIF Level Authorize To retrieve the details of a record in the UnitHolder Summary screen you need to specify the search criteria for the system to retrieve records You can retrieve records based on e Authorization Status e Record Status e UnitHolder CIF Number e Apply At CIF Level e Apply Deal At e Load ID You can specify any or all of the search criteria Click Search button to view the records You can view the record details by double clicking on the particular record The details of the selected record will be displayed in the UnitHolderDeal Maintenance screen os ORACLE 6 2 3 4 Specifying Transaction Details Policy Transaction Surrender Detail New 5 Enter Query Policy Transaction Policy Txn Number Reference Number Policy Number Policy Start Date Product ID Product Name Policy Holder ID Policy Holder Name Maturity Date Ph Deal Policy Financial Wizard GERRI Asset Allocation Payment Details Broker Details Load Override Details Details Transaction Currency Transaction Entry Date Currency Name Policy Transaction Date Transaction Amount Policy Base Currency Transaction Mode Amount Portfolio Surrender No Perc
11. button in the Policy Transaction TOPUP Detail screen the following screen in invoked Policy Fin Wizard Detail Save Policy Financial Wizard Policy Number Product ID Policy Base Currency Product Base Currency Policy Holder ID Policy Holder Name Options Market Ratio Contribution Amount Compounded Contribution Portfolio Amount All View Information Details 1of1 Options NetAmount Amountin Product Currency Details 1of1 FundiD Units NAV NetAmount Split Percentage Policy Number The Policy Fin Wizard Detail screen enables a Policy Holder to know at a glance the value of his policy and the details of his holdings in the funds Policy Financial Wizard section Policy Number Policy number provided in policy transaction details will be displayed here Product ID The product ID of the LEP product gets displayed here Policy Base Currency The base currency of the policy gets displayed here Product Base Currency The base currency of the product gets displayed here 4 4 ORACLE 4 2 3 3 4 2 3 4 Policy Holder ID Display Unitholder ID provided by you in the policy transaction details will be displayed here Policy Holder Name Policy Holder name will be displayed Options section The details of the holdings that can be viewed are given below e Market Ratio e Contribution Amount e Compounded Contribution e Portfolio Am
12. Note This field is enabled only if you have selected the option Adjustment for Previous Cycle WHT Amount Numeric Conditional Specify the amount of with holding that is applicable on the annuity amount The withholding tax details will be calculated by the system based on the amount you enter here on the journal transaction date and the tax ledger entries will be made for the new withholding tax amount 10 3 ORACLE 10 2 2 3 If a Product is not mapped with Withholding Tax then user can uncheck Adjustment for Previous Cycle otherwise system will not allow the user to save the journal without maintaining WHT Amount If the user maintains WHT Amount as 0 system will through an error saying WHT Amount should be greater than 0 Note This field is enabled only if you have selected the option Adjustment for Previous Cycle Remarks You can enter the important information any in this field Payment Details Section You can select the mode of payment and select the type of payment in this section Payment Mode Alphanumeric Mandatory Select the mode of payment as Transfer Payment Type Mandatory Specify whether the payment will be made to the Policy Holder or to a third party Maintained Bank Accounts Mandatory Select the bank account of the Policy Holder The following bank account details will be displayed e Bank e Branch e Account Number e Account Type e Account Currency
13. Rands in the second year The system will compare the higher contribution amount of the two years against the amount X Rands If X exceeds the higher say Y by more than 120 the Policy Maturity Date will be reset New Maturity Date Current Application Date Minimum Term The existing rule will not be changed but there will be a remark stating the Policy was amended by the system as a result of the 120 Rule The minimum term tenor considered here will be the one you have saved during Policy creation which might not be same as the default Product tenor LEP NAV Correction When an NAV correction is made the system reverses all relevant policy transactions and generates new transactions If the original transaction has been allocated the new transaction will also be allocated This will be an EOD Batch Process 113 ORACLE You have the option of executing this process manually through the NAV Correction Policy Transaction Reversal screen You can invoke this screen by typing UTDPLREV in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Nav Correction Policy Transaction Reversal i New 753 Enter Query This helps when you want to allocate transactions that have undergone NAV correction prior to the EOD Batch Process Click Execute button to execute the process online Click Submit button to submit a job for the same Not
14. Account Transfer e Demand Draft Payment Date Date Format Mandatory Specify the date on which the initial investment was done You can deposit the amount in different currencies and on different dates Payment Currency Alphanumeric Mandatory Enter the currency in which the initial investment is being done The initial amount can be deposited in multiple currencies Payment Amount Numeric Mandatory Enter the initial investment amount being paid in the particular currency Account Currency Display The transaction currency is displayed You are not allowed to change this value Account Number Mandatory Specify the number of the transfer account Account Type Mandatory Select the account type of the transfer account a0 ORACLE IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the account holder Exchange Rate Details The system will default the following exchange rate details for each settlement e Source ID e Exchange Rate Applied e Transaction Currency Amount e Override Exchange Rate e FX Deal Date e FX Value Date However if required you can override the default values and input new values If exchange rate details are not available for any settlement when the transaction or policy is entered the system will not generate a UT transaction Once all the settlement details have been enriched in the Policy Transaction Exchange Rate Enrichment scre
15. Allotted No Net Investible Amount Faith Allocation Details Fund Transactions Allocation Details Fee Details Allocation Details 1of1 Alloted Units Confirmed Units Unit Price Base Price Allocation Price LoadAmount Unit Cost Price Date Switch In Allocation Details 1of1 Alloted Units Confirmed Units Unit Price Base Price Allocation Price Load Amount Unit Cost Price D Allocation Details Allotted Units Specify the allotted units Confirmed Units Enter the confirmed units Unit Price Specify the Price Base Price Mandatory Specify the base price Allocation Price Mandatory Specify the allocation price Load Amount Enter the load amount 124 ORACLE Unit Cost Mandatory Enter the unit cost Price Date Mandatory Specify the price date 12 1 3 3 Specifying Fee Details Allocation Details New 73 Enter Query Product ID Transaction Amount Policy Number Date of Allocation Transaction Type Gross Amount Policy Txn Number Switch In Gross Amount Allotted No Net Investible Amount Faich Allocation Derails Fund Transactions Allocation Details Fee Details Load Details 1of1 Transaction Number FundID LoadID From Entity Load Amount Load AmtiIn Fee Ccy m Derived Fee Details 1of1 Transaction Number FundiD LoadID From Entity To Entity Load Amount Load Amt In Fee Ccy
16. Let us assume you are trying to enter a future date policy transaction on 11 01 2007 System Date with the following details e Policy Transaction Date 11 02 2007 e Future Date Limit 45 The system will allow you to save this transaction as the policy transaction date is within the future date limit range However you cannot enter a policy with the transaction date beyond 45 days For future dated policy top up transactions e f multiple funds are attached and a future date limit validation fails for one or more associated funds the system will reject the complete transaction You will have to select a transaction date which is within the future date limit for all the funds chosen under Asset Allocation e The validation will be made against the latest available fund rule as of the transaction date that you enter The system will display a warning indicating that the transaction is future dated The system will calculate the settlement date be based on the transaction date entered e If there is any change in the fund system level holiday the future dated transaction date also becomes a holiday The system will carry forward the transactions which are falling on a holiday to the next working date Note The Transaction Date must be later than the Start Date of the Policy earlier than the End Date of the Policy and must not be a holiday The transaction date cannot be earlier than the policy start date or the first Ru
17. SUR to ACT Annuities premiums dividends and broker commissions that have been missed out can be computed through the back data propagation facility This computation will not be done by the system during re activation of the policy Policy Start Date dd MM yyyy Display When you select the Policy Number the start date of the selected Policy is displayed here Product ID Display When the Policy is specified the ID of the product under which the corresponding policy has been created is displayed in this field Product Name Display When the Policy is specified the name of the product under which the corresponding policy has been created is displayed in this field Policy Holder ID Display When you specify the Policy Number the ID of the Policy Holder is displayed here Policy Holder Name Display When the Policy Number is selected the name of the corresponding Policy Holder is displayed here Maturity Date dd MM yyyy Display The maturity date of the policy is taken from the policy creation details and displayed here You will not be allowed to change the same You will also have to enter information in the fields in the following tabs in this screen e Transaction Details e Asset Allocation e Payment Details e Brokers Details ca ORACLE e Load Override Details 6 2 3 2 Policy Financial Wizard When you click Policy Financial Wizard button the following screen in invoked Policy Fin W
18. Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Interest Rate Maintenance Detail screen is closed and the changes made are reflected in the Interest Rate Maintenance Summary screen Viewing Interest Rate To view an Interest Rate you have previously entered you must retrieve the same in the Interest Rate Maintenance Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Interest Rate that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option Fag ORACLE 3 7 4 3 7 5 3 7 6 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Interest Rate Maintenance screen is opened in view mode Deleting Interest Rate You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Interest Rate Maintenance Summary screen as follows 1 Invoke the Interest Rate Maintenance Summary screen
19. You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Policy Cession Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 29 ORACLE 6 Click Save to save your changes The Policy Cession Detail screen is closed and the changes made are reflected in the Policy Cession Summary screen 9 3 3 Viewing Policy Cession To view a Policy Cession you have previously entered you must retrieve the same in the Policy Cession Summary screen as follows 1 Invoke the Policy Cession Summary Screen from the Browser 2 Select the status of the record that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in
20. termed as Amend Operation 1 Invoke the Policy Journal Maintenance Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Policy Journal Maintenance screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Policy Journal Entry An amended Policy Journal Entry must be authorized for the amendment to be made effective in the system 10 7 ORACLE Authorization of amended records can be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions 1 6 ORACLE 11 1 11 2 11 Batch Activities Introduction For the purpose of processing transactions in the LEP products the system provides a number of processes that must be initiated by the user during either the End of Day Processes EOD or Beginning of Day Processes BOD These processes and their functioning are explained below Sequence of Batch Fu
21. A Active e C Cancel e N Not Started oa ORACLE e P Pause e S Stop Note If you select the status STOP escalation will not be applied on the annuity Transactions will not be generated for Sls on annuities whose status is STOP It is pos sible for you to change the status of such Sls to ACTIVE during amendment of the policy During amendment of a policy you can change the status of an active SI to Paused Stopped or Cancelled However if you have checked the box Phase In you will not be allowed to select the options Paused and Stopped During amendment of an SI marked Not Started you can change all details except the status of the SI You will be allowed to delete the SI During amendment of an active SI Escalation End Date can be amended only it is greater than the System Date Escalation Start Date and Escalation Frequency can be amended only if escalation has not been applied on the policy Start Date DD MM YYYY Date Format Mandatory Specify the date beginning from which the annuity payment is to be made for this Policy Subsequent to this payment annuity payments will be made according to the annuity frequency specified for the Policy Note The Annuity Start Date must not be equal to and earlier than the Policy Start Date End Date DD MMI YYYY Date Format Mandatory Specify the date on which the last annuity payment is to
22. Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Status Change Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Policy Status Change screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Policy Status Change An amended Policy Status Change must be authorized for the amendment to be made effective in the system rs ORACLE Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions ee ORACLE 8 1 8 2 8 2 1 8 Cession Maintenance Introduction In some cases Policy Holders with endowment policies might desire to cede their policies This would typically mean that ownership of the policy might be ceded or transferred to another i
23. Average Unit Cost Getting Help Online help is available for all tasks You can get help for any function by clicking the help icon provided or by pressing F1 ORACLE 2 1 2 UH Deal Maintenance Introduction In some cases the AMC may wish to offer a special unique load option to be applied on all transactions involving a specific CIF Account or unit holder This could also be at the request of the investor This special load option would override the existing load option mapped to the fund or load group Such a load option is called a deal for an investor You can set up a deal for an investor for a particular Product You have the option of selecting a specific fund under the Product to which the load is to be applied or applying the load to the Product in which case the deal will apply to all funds mapped to it The Unitholder Deal Maintenance Detail screen is where a deal is setup You can invoke the Unitholder Deal aA ORACLE Maintenance Detail screen by typing UTDUHDEL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Unitholder Deal Maintenance Detail New 7 amp 3 Enter Query Client Information Unit Holder CIF Number Find Unit Halder Deal Details Deal Transaction Number Status Actve Apply At CIF Level Product ID Apply Deal At Load Level v Product Name Fund ID Deal Based On F
24. Commutation Death With Commutation Policy Holder Retirement and Early Policy Holder Retirement in the drop down list against the field New Status Date of Death dd MM yyyy Optional Enter the date of death of the Policy Holder Note This check box will be enabled only for the options Death Without Commutation Death With Commutation Policy Holder Retirement and Early Policy Holder Retirement in the drop down list against the field New Status Allow Surrender Mandatory only if the New Status is Death Without Commutation Select Yes to indicate the Policy can be surrendered Allow Closure Mandatory only if the New Status is Death Without Commutation Select Yes to indicate the Policy can be closed as ORACLE 7 2 2 1 7 2 2 2 7 2 3 Allow Transfer Mandatory only if the New Status is Death Without Commutation Select Yes to indicate the Policy can be transferred Adjustment Transaction Type Mandatory only if the New Status is Claim Select the adjustment transaction type from the option list Description Optional You may enter any remarks on the status change of the Policy Policy Details section The following policy details are displayed in the Policy Details section when you select a Policy Number e Policy Holder Name e Product Name e Policy Base Currency e Policy End Date dd MM yyyy Payment
25. Information link the following screen is invoked Policy Maintenance Detail New 5 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Si Load CQverride Default Load Details ERE Policy Details Additional Details Intermediary Details Beneficiary Details Constituent Details Load Override Details Policy Details Product Defaulting Funding Factor Product ID bgaa ae Product Description ano ssetAllocation By 4 Policy Number A By Fund Reference Number Rule Effective Date Funding Frequency Policy Status Code ACT Description Cession Status Transaction Currency smit si Include Interestin No ii coun Investment Preferred Fund For Initial Investment Amount Redempion Interest Amount Description Intial Investment Policy Txn Number Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Deal Date FX Value Date Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open DateTime Authorized Policy Details Section Product ID Mandatory Select the product in which the Policy Holder wants to buy the Policy The option list includes all valid and active Products Product Description Dis
26. Record Successfully Saved This indicates the record has been saved Click Ok button On saving the policy the system provides a feature to withdraw the units Fee Transaction Generated Prior to Surrender Transaction During the 100 surrender transaction process the system will check for any fee transaction that is Un Allotted If there is an Un allotted fee transaction then the transaction will be reversed The fee must be taken through fee override and the fee transaction will not get generated Note For 100 Unit Transfer Surrender Transaction with transaction type as BALANCE TRANSFER OUT fee transaction generated for the policy will get reversed amp will not be overridden Surrender Transaction Generated Prior to Fee Transaction During the fee redemption transaction generation process the system will check for any 100 surrender transaction that is Un Allotted If there is an Un allotted transaction then the Fee would be taken through fee override and the fee transaction will not get generated Note For 100 Unit Transfer Surrender Transaction with transaction type as BALANCE TRANSFER OUT fee transaction will not be generated amp will not be overridden Surrender Transaction before Annuity Generation When you have entered all the mandatory information for a 100 surrender transaction system will if the annuity is applicable for the policy and for the month e f annuity is
27. Start Date of the Policy is specified the system computes the maturity date for the Policy by adding the Minimum Tenor that has been specified at the product level for all policies to the Policy Start Date and defaults the computed date in this field You can change this date The concept of a Maturity Date enables the AMC to keep track of premature closures of policies that take place so that the applicable exit fees may be levied A Policy that has matured continues to exist in the product for all activities but no transactions will be accepted into the Policy after the Policy End Date Policy End Date DD MM YYYY Date Format Mandatory Specify the date beyond which the Policy should cease to be active This date must not be earlier than the application date or the Policy Start Date Type of Policy Optional Specify whether the Policy being created is a new Policy a rollover from an existing Policy or whether the customer is transferring retirement assets Transfer in option is applicable for fresh investment If Balance Transfer in is chosen from the drop down list the policy asset allocation will be enhanced to capture the unit transferred in each fund and WAC The system will generate unit based transaction for such an initial investment Note The option list includes the option Accelerated Annuity If you select this option in case of death of a policy holder the policy will be transferred to a new policy opened
28. Transaction Switch Summary Auth Status Record Status Policy Txn Number Policy Number Product ID aa Transaction Type X Transaction Date e Policy Holder ID aJ Transaction Reference La Number om EI Advanced Search Records per page 15 v 1 of 1 Auth Status Record Status Status Policy Txn Number Policy Number ProductID Transaction Type Transact Retrieving Transaction Switch in Policy Transaction Switch Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Policy Transaction Switch Summary screen e Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved e Select the status of the record in the Open field If you choose the Blank Space option then all the records are retrieved e Policy Txn Number e Policy Number e Product ID e Transaction Type e Transaction Date e Policy Holder ID e Transaction Reference Number After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen oN ORACLE 5 3 2 5 3 3 Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Policy Transac
29. amount and not the interest earned on the same The Funding Factor which is the percentage of the initial contribution or top ups which is retained by Life Company and the Funding Frequency which is the frequency at which the installment is paid back to the customer are specified for the product The Repayment Period which is the period within which the entire amount is to be paid back to the customer is also specified This EOD Process carries out the funding repayment for the policies marked for the same This is also a BOD Process LEP Generate Plan Transactions A policy transaction might involve one or more funds This process generates one transaction per fund The process will pick up all policy transactions that do not have underlying UT transactions generated The system intimates the user upon completion of the activity and the successful generation of underlying transactions This process is also scheduled as a BOD process to take care of all the system generated policy transactions that might have occurred as a result of other Batch Activities Note If a policy transaction triggers a number of underlying subscription transactions at the fund level the process of generation must be successful for each of these underlying transac tions at the fund level If not the generation is aborted for all underlying transactions for that policy LEP Update Product Fiscal Year This process updates the fiscal year
30. as percentage to ensure guaranteed execution of transaction You will then have to change the Transaction Mode to Percentage and indicate the percentage as 100 Transaction Currency Mandatory If the switch is done in a currency other than the policy base currency then you are required to specify the transaction currency If you do not then the system will default the base currency of the corresponding policy or plan from the Policy details record as the transaction currency Percentage Holding 5 Characters Maximum Numeric Mandatory if Transaction Mode is Percentage of Holdings If the specified Transaction Mode is Percentage of Holdings then specify the percentage of the Policy Holder s holdings that is to be reckoned as the transaction amount for this transaction When you specify this percentage the transaction amount is computed and displayed in the Transaction Amount field and locked The percentage you specify here must not exceed one hundred Policy Base Currency Display When the Policy is selected the corresponding Plan or Policy Base Currency is displayed here from the policy details record This currency cannot be changed at this stage Remarks Alphanumeric Optional Enter a brief description of the transaction or any applicable remarks about the transaction Exchange Rate Details The policy transaction currency can be different from the base currency of the policy In this sec
31. be made for this Policy This date must not be the same as the Annuity Start Date Note The annuity period for annuity Sls cannot overlap Value Numeric Optional The amount that is to be paid as annuity to the Policy Holder over a time period in definite intervals frequencies against the initial investment towards this Policy in this Product is displayed here You can change this amount at this stage Note The is not applicable if the type of policy is Accelerated Annuity If the value specified here is a percentage it must be within the Annuity Minimum Ratio and the Annuity Maximum Ratio specified at product level aaa ORACLE Note If you have selected the option Amount against the field Mode the value you enter will be the annuity amount to be paid in the frequency specified If you have selected the option Percentage the percentage value of the policy annuity amount will be calculated and paid in the frequency specified The same is illustrated with the following example Case 1 The Mode is Amount Value is 1000 currency units Frequency is Monthly In this case 1000 currency units will be paid to the policy holder every month Case 2 The Mode is Percentage Value is 10 Frequency is Monthly In this case 10 of the policy anniversary amount will be paid to the policy holder in that year Frequency Mandatory Specify the frequency at which annuity payments mu
32. button The following screen is displayed Summary Authorized Open Effective Date e Interest Rate Transaction Currency a3 Advanced Search Reset Records perpage 15 v 101 a Authorized Open Effective Date Interest Rate Transaction Currency Latest Rule Retrieving Interest Rate in Interest Rate Maintenance Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Interest Rate Maintenance Summary screen e Select the status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved e Select the status of the record in the Record Status field If you choose the Blank Space option then all the records are retrieved Effective Date Transaction Currency Interest Rate After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen oat ORACLE 3 7 2 3 7 3 Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Authorization Status Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and
33. dates for all products for which the fiscal year end date is the next working day on the application date The fiscal year is updated to the next fiscal year LEP Update Plan Transaction Allotted Status A policy transaction is considered allotted only if all the underlying Unit Trust UT transactions are allotted This batch process checks if all the underlying UT transactions are allotted and if they are it marks the policy transactions as allotted we ORACLE 11 3 5 11 3 6 11 3 6 1 LEP Plan Financial Bucket Adjustment This process facilitates the adjustment of investment in the funding bucket in the event of repayment of the funded amount The process will also adjust the funded units if there is a reversal of a surrender or top up transaction The process works as follows e On the application date the process identifies the funding amount repayment transactions at a policy level for funded endowment products e The units repaid for these transactions are identified e The funding units in the funded bucket are reduced for each of the funds by subtracting the funding units with the funding repaid units LEP Plan Annuity 5 20 Validation Process When a policy is created and authorized this EOD process performs the following functions e The policy amount is allotted into the underlying portfolio and the Net Invested Amount NIA is validated against the minimum and the maximum annuity ratio specifie
34. display the ratio based on the currency and amount details provided To calculate the ratio the transaction amounts will be If the settlements are maintained in only one currency then you can enter either the ratio or the transaction amount Note If the type of policy is Balance Transfer in the number of units being transferred in are mentioned and not the ratio of investment WAC Specify the take on WAC here This will be used as the opening WAC in respective funds CGT computation for initial investment transaction will be based on the take on WAC Note WAC is mandatory in case of Balance Transfer In type of policy Payment Details Section The Settlement Details screen is invoked when you click on this button Settlement Details Caloulare Interest Clear Settlement Details Bank Code Payment Mode Select Mode Of Payment Description Payment Type Self Cheque Number Payment Date RS a Payment Currency a Payment Amount Branch Code ane Account Currency i i a Account Number ccount Operation Type Account Type IBAN Exchange Rate Details Source ID Override Exchange Rate No Exchange Rate Applied FX Deal Date Transaction Currency Amount FX Value Date Interest Details Interest Rate Interest Calc Days Interest Amount BasisDays 365 Interest Amount In Transaction Currency 3 24 ORACLE Sequence Number Optional You can enter the sequence
35. exchange rate you need to enter the exchange rate to be used here If exchange rate is not available then the system will generate the transactions as incomplete ones Such transactions can be enriched later through the Policy Transaction Enrichment Screen Override Exchange Rate Optional Select Yes if you wish to change the exchange rate that is displayed here If you select Yes however you need to specify the exchange rate to be used for the transaction in the Exchange Rate Applied field Select No if you wish to retain the exchange rate that is displayed by the system FX Deal Date Date format Optional The system will default the transaction date of the policy top up transaction here You can change it if required aM ORACLE 4 2 9 3 FX Value Date Date format Optional The system will default the transaction date of the policy top up transaction here You can change it if required Specifying Payment Details Policy Transaction TOPUP Detail New 9 Enter Query Paley arasan Transaction Reference Policy Txn Number te Ponca EENE foc Name Product ID an Policy Holder ID Policy Maturity Date Policy Financial Wizard Transaction Details Asset Allocation Payment Details Broker Details Load Override Details Payment Details Bank Code PaymentMode Select Mode Of Payment Description PaymentType self Branch Code Payment Date Bran
36. fields Cession ID 3 Characters Alphanumeric Mandatory Specify a unique identification for the particular cession Cession Type Mandatory Select the appropriate type of cession that applies to this Cession ID from the drop down list The cession type could be either Permanent or Temporary Cession Description 30 Characters Alphanumeric Mandatory Give a description of the cession that is being maintained in this record Generate Policy Transfer Transaction Display You can select Yes to generate policy transfer transaction Else select No Allow Policy Surrender Optional You can select Yes to allow policy surrender Allow Policy Closure Optional You can select Yes to allow policy closure You will need to carry out the following steps in order to close a policy e Amend the Maturity Date of the policy through the Policy Find Options screen e Then change the status of the policy to Matured through the Policy Status Change screen Note This check box will be enabled only if the Cession Type is Temporary Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the following confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button oe ORACLE 8 3 Cession Maintenance Summary Screen
37. for the records matching the criteria specified above e Process e Product ID e Policy Number e Policy Txn Number e Source ID e From Currency e To Currency e Amount e Exchange Rate Applied e Override Exchange Rate e FX Deal Date e FX Value Date If you have selected Policy Settlement as the enrichment option then all settlement details for the selected policy are available and the exchange rates can be enriched from settlement currency to transaction currency If Policy Transaction has been selected as the enrichment option then exchange rate details to convert the policy transaction amount into policy base currency can be changed after the settlements of the policy transactions have been enriched Note If you have not changed the FX Deal Date and FX Value Date that is the dates are cur rent dates then the LEP policy settlement and policy transaction will not be available for oe ORACLE 3 6 3 6 1 3 6 2 3 6 2 1 enrichment on the next day This is because clearance would have been done during EOD If you change the FX Deal Date and FX Value Date to the next day then policy settlement and policy transaction will be available for enrichment the next day Maintaining Interest Rate Details The interest rate that is to be used for interest calculation is maintained using the Interest Rate Maintenance screen In order to arrive at the rate of interest you have t
38. fund name Ratio Specify the ratio You can click delete icon to delete any specified fund Note If the From and To funds do not belong to the same AMC the switch will be a pseudo switch The system will generate a redemption transaction on the same day and the sub scription transaction on the settlement day While doing a reversal for 100 Switch Trans action prior fee system should throw an override able warning message if periodic fee has been charged for the switch 5 2 9 3 Specifying Broker Details The broker details can be fetched in the following two ways 1 It can be fetched directly by clicking Fetch Broker Details button The system will automatically default the broker details maintained at the policy level ote ORACLE 2 It can also be selected in the screen itself by clicking add icon Select the Broker Code from the option list You should also specify the split percentage You can follow this step when you want to fetch the broker details that are maintained at the policy level Policy Transaction Switch Detail New Enter Query Policy Transaction Transaction Reference Number li Policy Number eo Product ID Name Policy Holder ID Policy Maturity Date Policy Txn Number Policy Financial Wizard Transaction Details Asset Allocation REE Load Override Details Faich Broker Details Broker Details 1of1 Broker Code Broker Name Parent Broker Code
39. have checked the Include Interest in Investment box then the total of settlement and interest amounts for each currency needs to be equal to the asset allocation transaction amount for the currency You need to manually add the interest amount calculated in the settlement details to the transaction amount for the particular currency in the asset allocation details Ifthe Include Interest in Investment box has not been checked then sum of cur rency wise settlement amount should be equal to the asset allocation transaction amount for the currency WAC Mandatory Enter the Weighted Average Cost Transaction Currency Alphanumeric Optional Specify the transaction currency for the initial contribution If many currencies have been mentioned in the settlements then you are required to enter the amount for individual currencies You can specify a transaction currency only if the transaction is amount based Exchange Rate Source Alphanumeric Optional The system will display the exchange source maintained at the default set up in system parameters You can change it by selecting the required exchange rate source from the adjoining option list This will be used by the system to convert the transaction amount in terms of fund base currency Exchange Rate Applied Numeric Optional The system will default the exchange rate available for the currency based on the exchange source specified If you have elected to override the
40. investment amount interest amount and the asset allocation details for a policy that has been authorized as long as it has not been allocated When you modify the details the system will reverse the existing initial investment transaction and create a new policy transaction for the modified amount You can modify the policy any number of times till policy allocation If transactions like allocation premium annuity recurring switch top ups and surrender have been generated for the policy the system will not allow you to modify the initial investment amount Consider the following cases ORACLE Case 1 The product is a multiple premium product you enter the initial investment amount and premium details The Start Date for the premiums is a system date when the policy is authorized When the policy is Authorized a transaction will be created on the date mentioned for the initial investment amount you have entered Case 2 The product is a multiple premium product you enter the initial investment amount and premium details The Start Date for the premiums is the System Date When the policy is saved e A transaction will be created for the initial investment amount you have entered e A transaction will also be generated for the first premium amount at EOD Case 3 The product is a multiple premium product you do not enter any initial investment amount but only the premium amount The Start Date for the premiums is th
41. keys are contained in brackets For example lt ALT SHIFT gt keys Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function Exit ie ORACLE Icons Function H Add Row E Delete Row z Option List Refer the Procedures User Manual for further details about the icons 1 7 Abbreviations and Acronyms The following acronyms and abbreviations are adhered to in this User Manual Abbreviation Meaning Acronym ADMIN User Administrator AGY The Agency Branch component of the system AMC Asset Management Company BOD Beginning of Day CDSC Contingent Deferred Sales Charge CGT Capital Gains Tax CIF Customer Information File EOD End of Day EPU Earnings per unit FC IS Oracle FLEXCUBE Investor Services FMG The Fund Manager component of the system FPADMIN Oracle FLEXCUBE Administrator ID Identification IHPP Inflation Hedged Pension Plan IPO Initial Public Offering LEP Life and Endowment Products LOI Letter of Intent NAV Net Asset Value REG The Registrar component of the system ROA Rights of Accumulation ROI Return on Investment ra ORACLE 1 8 Abbreviation Acronym Meaning Sl Standing Instructions SMS Security Management System URL Uniform Resource Locator VAT Value Added Tax WAUC Weighted
42. mandatory information click Ok button The following message will be displayed The system displays the following confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button ae ORACLE 4 2 11 4 3 4 3 1 Processing Back Data Propagation for Transactions You can correct erroneous transactions as well as enter those that have been missed out and compute the effect these have on the current holdings of the unit holder through the back data propagation process To facilitate this propagation process two schemas are used the business or normal schema and the report schema You are required to enter the correct data in the business schema for the required transactions and select these for propagation again from the business schema The transactions will be simulated in the report schema and the results can be viewed in the business schema Refer the chapter Back Data for more details on the back data propagation process Policy Transaction Topup Summary Screen Invoke the Policy Transaction Topup Summary screen by typing LESPLTOP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Transaction Topup Summary Auth Status Record Status Policy Txn Number Policy Number Product ID a Transaction Type 7 Transaction Date e Policy
43. of the following details in the Policy Status Change Summary screen 1 Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved 2 Select the status of the record in the Open field If you choose the Blank Space option then all the records are retrieved e Policy Number e Rule Effective Date e Present Status Code e New Status Code After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Policy Number Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value i ORACLE 7 3 2 7 3 3 7 3 4 Example You can search the record for Policy Status by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Policy Number starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Policy Number ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fe
44. opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the transaction Amending Interest Rate After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Interest Rate Maintenance Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized oe ORACLE 3 7 7 3 7 8 3 7 8 1 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Interest Rate Maintenance screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Interest Rate An amended Interest Rate must be authorized for the amendment to be made effective in the system Authorization of amended records can only be do
45. provisional balance ou ORACLE If the policy transaction already has an underlying UT transaction with this option checked then system throws up a warning and tracks the provisionally allotted transactions for auto clearing Auto Clear Reinvestments Use this field to indicate that for a complete switch transaction the out flow transaction should include freeze held and reinvestment units Note The Auto Clear Provisional Balance and Auto Clear Reinvestments fields will be checked or unchecked based on the specification for the same in the policy maintenance screen However you can change the defaulted value These options will be enabled if the Percentage of Holdings is 100 Transaction Currency Alphanumeric Optional Specify the transaction currency for the initial contribution If many currencies have been mentioned in the settlements then you are required to enter the amount for individual currencies You can specify a transaction currency only if the transaction is amount based Source ID Alphanumeric Optional The system will display the exchange source maintained at the default set up in system parameters You can change it by selecting the required exchange rate source from the adjoining option list This will be used by the system to convert the transaction amount in terms of fund base currency Override Exchange Rate Optional Select Yes if you wish to change the exchange rate t
46. retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Cession Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the transaction 20 ORACLE 9 3 6 Amending Policy Cession After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Cession Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the reco
47. talks about maintaining ces Gnapter 3 sions in the system LEP Transactions Policy Cession Once you have maintained various Chapter 10 cessions in the system you may want to attach one to a Policy Refer to this chapter for information on the same LEP Transactions Policy Journal Maintenance Whenever you make an Chapter 11 adjustment to the annuity amount you need to post it as a policy journal entry Refer to this chapter for information on the same Chapter 12 LEP Transactions Batch Functions lists and explains the various End Of P Day EOD and Beginning Of Day BOD Batch Activities LEP Transactions Allocation Details explains how to enter and save Allo Chapter 13 cation Details Chapter 14 LEP Transactions Annexure explains certain procedures that apply to both the LEP and UT modules Conventions Used in this Manual Before you begin using this User Manual it is important to understand the typographical conventions used in it General Conventions Convention Type of Information Italic type Functional foreign terms Validations for fields on a screen References to related Headings Users Manuals For emphasis Numbered Bullet Step by step procedures Keyboard Conventions Convention Type of Information Keys All keys of the keyboard are represented in capital letters For example lt CTRL gt Shortcut All short cut
48. the Policy Maintenance Summary screen from the browser 2 Select the status of the record that you want to retrieve for reversal 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to reverse in the list of displayed records in the lower portion of the screen The Policy Maintenance Detail screen is opened in View mode 5 Select Reverse operation from the Action list The system prompts you to confirm the reversal of record 6 Click the Save button to save your changes Authorizing Reversal of Policy A reversed policy must be authorized The process of authorization is subsequently the same as that for normal transactions Maintaining Ratio Percentage Fund Products and Policies invested by the client can be divided into components The components can be singular or a combination of two or more components According to the Prudential Investment Guidelines these Funds are classified as components or combination of the same these can be invested according to a specified percentage For example a fund investment of F1 can be allocated under the following ratios of components e Onshore Cash 25 e Onshore Property 40 e Offshore Cash 35 The cumulative investment ratio would add up to the total Fund I
49. the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Unitholder Deal Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Unitholder Deal Detail screen is closed and the changes made are reflected in the Unitholder Deal Summary screen Viewing Unit Holder Deal To view a Unitholder Deal you have previously entered you must retrieve the same in the Unitholder Deal Summary screen as follows 1 Invoke Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the Unitholder Deal that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the l
50. the account holder Enter escalation information in the following fields Escalation Start Date DD MM YYYY Date Format Optional Specify the date from which escalation will commence This date must be earlier than the End Date of the Policy and must be later than the Premium Start Date wee ORACLE 3 2 2 11 Escalation End Date DD MM YYYY Date Format Optional Specify the date from which the escalation must cease to be applied on the annuity This date must be later than the Premium Start Date If the Premium Escalation Start Date has been specified then the End Date is mandatory and must be specified Escalation Mode Mandatory Annuity payments can be escalated periodically as a pre defined percentage amount or market value Select the mode from the drop down list Escalation Frequency Mandatory Select the frequency at which the escalation is to be applied from the values in the drop down list If the Start Date has been specified the frequency is mandatory and must be specified Escalation Value Mandatory Specify the escalation amount that is to be applied Cheque Details Enter the check details in the following fields Cheque Number Mandatory Enter the cheque number of the cheque by which the premium is being paid Cheque Date DD MM YYYY Date Format Mandatory Enter the cheque date of the cheque by which the premium is being paid Annuity Details Section As mentioned earlier this sec
51. the checker must reject the record oe ORACLE 4 2 9 4 2 9 1 Amending Unit Holder Deal After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Unitholder Deal screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Specifying Transaction Details Policy Transaction TOPUP Detail New 7 Enter Query Policy Transaction Transaction Reference Number Policy Start Date m Product ID Product Name Policy Holder ID meme n Ph Daal Policy Maturity Date Transaction Details Asset Allocation Payment Details Broker Details Load Override Details Policy Txn Number Policy Number Details Transaction Amount Transaction Date Transaction Mode Amount Transaction Entry
52. transaction amount that is to be redeemed in each of the selected funds The sum of these amounts must not be greater than the total transaction amount specified in the transaction details tab for this transaction Typically this field is only applicable for transactions for which the mode is Amount If different currencies have been mentioned in settlements then you can specify only the transaction amount The system will default the ratio If all the currencies in settlements are the same then you can specify either the transaction amount or the ratio Note If you have specified the investment ratios in each fund the investment amounts are com puted and displayed here and this field is locked Source ID Alphanumeric Optional The system will display the exchange source maintained at the default set up in system parameters You can change it by selecting the required exchange rate source from the adjoining option list This will be used by the system to convert the transaction amount in terms of fund base currency Override Exchange Rate Optional Select Yes if you wish to change the exchange rate that is displayed here If you select Yes however you need to specify the exchange rate to be used for the transaction in the Exchange Rate Applied field Select No if you wish to retain the exchange rate that is displayed by the system Exchange Rate Applied Numeric Optional The system will d
53. values can be amended and you can specify the required percentages Switch Asset Allocation Details Capture the funds INTO which the investment amount is being moved in the Switch Asset Allocation section oe ORACLE Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Select funds INTO which you are moving the investment amount Units Ratio Numeric Mandatory Specify the percentage of the amount that must be invested in each of the selected funds The sum of all such percentages must add up to 100 and not fall below or exceed it The percentages specified here must not be fractional Typically this field is only applicable for transactions for which the Transaction Mode is Percentage Note If you have specified the investment amounts in each fund the investment ratios are com puted and displayed here and this field is locked The latest investment ratio applicable for the Policy is displayed here when the form is opened These values can be amended and you can specify the required percentages 3 2 2 13 Initial Load Override Details Section You can override or alter the value of any load including derived loads if any mapped to the selected fund in the Initial Load Override Details screen which is invoked by clicking on the initial load override button in the Policy Maintenance Details screen Policy Maintenance Detail Initial Load Overri
54. you want to modify in the list of displayed records The Cession Maintenance Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Cession Maintenance Detail screen is closed and the changes made are reflected in the Cession Maintenance Summary screen Viewing Cession Maintenance To view a Cession Maintenance you have previously entered you must retrieve the same in the Cession Maintenance Summary screen as follows 1 Invoke the Cession Maintenance Summary Screen from the Browser 2 Select the status of the record that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Cession Maintenance screen is opened in view mode Deleting Cession Maintenance You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Cession Maintenance Summary screen
55. 0 Rule batch checks the annuity amount which is specified as 3000 currency units against total contribution amount 100 000 currency units This amounts to less than 5 of the total contribution amount and hence violates the 5 20 Rule The system marks the Exclusive top up transaction T1 as Inclusive and logs an entry into the error report with the reason for failure of the 5 20 check For any subsequent top up transactions the system considers the same NIA initial top up amount and the latest top up amount for the 5 20 validation in the policy year Note As seen in the case above the initial top up amount T1 was made Inclusive This amount will be considered for any subsequent validation as an Inclusive top up and not an Ex clusive top up The logging in of the error report and the change adjustment in annuity details are operationally controlled Note The system considers the following formulae while calculating the annuity amount Case 1 When top up is Inclusive Annuity Amount gt Minimum Annuity Percentage Latest Anniversary Value All Inclusive Net contributions made during the year The current top up amount will be included in the contribution Annuity Amount lt Maximum Annuity Percentage Latest Anniversary Value All Inclusive net contributions made during the year The current top up amount will be included in the contribution Case 2 When top up
56. 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Transaction Switch Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the transaction Amending Transaction Switch After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Transaction Switch Summary screen from the Browser a ORACLE 5 3 7 5 3 8 5 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to amend The Policy Transaction Switch screen will be displayed in Amendmen
57. 3 4 Deleting Policy Journal EntrY assssnnnserinennnnrinnnnnnnnnrnrnnnnnrnnnnnnnnnnnnnnnena 10 6 10 3 5 Authorizing Policy Journal Entry ccccccccccsseeeeenteeeeeeeeneeeeseenaeeeeeeeaaes 10 7 10 3 6 Amending Policy Journal Ent y ccccccccccesseeeeeenneeeeeeeenteeeeeeesaeeeeeeeaaes 10 7 10 3 7 Authorizing Amended Policy Journal Entry ccccccccscesseeeesenteeeeteesaeees 10 7 Batek ACtivitieS r reee E eee eee 11 1 TiTe IMTROGUCH ONG e A RA ieee eal AE a A A 11 1 11 2 Sequence of Batch FUNCTIONS 0 ccccccecceeeeeeeeeeeeececaeceeeeeeeeeeeeeeesececsncacneeeeeeeees 11 1 Tho Batch FUNCIONS ie seein iin a inten aint 11 2 11 3 1 LEP Plan Funding Repayment cccccccscceceseeeeeteeeneeteeseneeeeeeseeaneees 11 2 11 3 2 LEP Generate Plan Transactions ccccccccccceeseeeeeeseteeeeeteneeeeeetenaeeees 11 2 11 3 3 LEP Update Product Fiscal Y r cccccccccceceseceneenenteceeeesteteeeetetneens 11 2 11 3 4 LEP Update Plan Transaction Allotted StatuS 2 c ccccccceeceeeeteesees 11 2 11 3 5 LEP Plan Financial Bucket Adjustment ccccccceeeeeeeceeenneeeeetetneeeeeees 11 3 11 3 6 LEP Plan Annuity 5 20 Validation ProC SS 0 c ccccsccccsseietteeeeenneneeeeees 11 3 T13 LEP 120 Rule SUPPO a e scares thaes heen tiated eta ee 11 5 11 3 8 LEP NAV Correction aeien re R EEE 11 5 11 3 9 LEP Set Latest Rule for Product 0 cccccceccceceeeseeeeeeeeeeeeeeeeneneeeeeeeeanees 11
58. 4 Creating Future dated Rules for POlCIOS ecceecceceeeteeeeeteeneeeeteneneneees 3 46 3 2 5 Processing Back Data Propagation for Transactions cccceceeeeeeeees 3 46 3 3 Policy Maintenance Summary SCreen ccccceeeceeeeeeeeeeeeeeeeeeeneeeeeseeeneeeeeeeeenaeees 3 47 3 3 1 Retrieving Policy in Policy Maintenance Screen cccccesseeeeteeneetees 3 47 9 3 2 Edling POUEY aurae ek a ae eae deena 3 48 3 33 Viewing POLICY a0 ccciveets cet eaeeteeeeiedlieteapntitesidee hatesieenisieteeienditdiedenciees 3 48 O24 Deleting PONV i 533 rE E A R A TENE A 3 49 239 AUthOriZinG FOO a a raa e A E ARA 3 49 3206 Amending FOCI rerne eko EEE ir EEE Le TAA 3 49 3 3 7 Authorizing Amended POLICY ecceceeceteeeneeeeeteeeeeeeeteeeeeeeeeteeeaeeeeeteeaaeeees 3 50 3 3 8 Reversing Poley nasrin asiveinii eantaire A EA EEEa NE AELE aa 3 50 3 3 9 Authorizing Reversal of Policy eessseesssnerenerrrnanrnnnnnneerrnnnrrannnnreerrnnrrnna 3 50 3 4 Maintaining Ratio Percentage seeessseessssrreseerrnesrrnnneesrenneesinnnneestenneeetnnnaesenenneent 3 50 3 90 Enriching Policy Transactions seencienrar ernan EE ENERE 3 51 3 5 1 Fields in the Policy Transaction Exchange Rate Enrichment Soro N aces cceeeseccccceeeneeeecneeeteeeecdebeneseednenenesecenentesesernenseneaneets 3 51 3 6 Maintaining Interest Rate Details eee cece cere eeeneeeeeeeeaeeeeeeeeiaeeeeeeenaaes 3 53 93 6 1 INVOKING SCIOGN orinis iorreiipas ii
59. 6 11 3 10 LEP Set Latest Rule for Planiuu ecccccccccessccteeeseeeeeteseceeeeesenaaeeeeteeaeeees 11 6 11 3 11 LEP Plan Anniversary Value COMputatiOn 00 0 c ccceccecetntteeeeetnneeeeeeees 11 6 11 3 12 LEP Plan Annuity Escalation cccccccccssccccesteeeseeeneeeeesesneeeeenenaeeees 11 7 11 3 13 LEP Plan Recurring Switch Escalations cccccccccccesseeeeeeneeeeeteeenanees 11 7 11 3 14 LEP Plan Premium Escalation 00 cccccccsccccceceeeeeseeenneeeseseseeeesenenaeees 11 7 11 3 15 LEP Recurring Plan Annuity Processing cccccecseeeetetsteeeeetetnneeeeeees 11 7 11 3 16 LEP Recurring Plan Switch Processing ccccccccceeseeeeeetenseteeteneaeeees 11 7 11 3 17 LEP Recurring Plan Premium ProceSSing ccccccsseeeeeesteeteeteeneeeees 11 7 11 3 18 LEP Plan Funding Repayment cccccccccccesseeeseeenneeeeeeeeaaeeeeeeeeneaneees 11 7 11 3 19 LEP Generate Plan Redemption Transactions for Pe nodiG Fe CS iia hist sth ah ad ec vee se ae E ee 11 7 12 13 14 11 3 20 LEP Process Plan Surrender 0 ccccccccccccccseccsceecsssseceeenceseseeeessaeeeeeanaes 11 7 11 3 21 LEP BOD Plan Transaction Generations ccccccececseccseecceseseeseeansnanes 11 8 11 3 22 LEP Cash Management Switch ProCeSS cccccccsceeseesteeeetnteeeeenees 11 8 Allocation Details siccecsccct si ciccedese uc cecte cede tensceencl ne citecsteess Giceecganiccdec tease 12 1 12 1 Allocation Detalls senin antes
60. AN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the account holder 6 2 3 7 Specifying Broker Details Policy Transaction Surrender Detail New 5 Enter Query Policy Transaction Policy Txn Number Reference Number Policy Number Policy Start Date Product ID Product Name Policy Holder ID Policy Holder Name Maturity Date Policy Financial Wizard Transaction Details Asset Allocation Payment Details EERE Load Override Details Broker Details Feich Aroker Details Broker Details 1of1 LG Broker Code Broker Name Parent Broker Code Split Percentage m Input By Date Time Authorized By Date time Modification Number Authorized Broker Code Mandatory Select the broker code from the option list Broker Name Once you select the broker code the broker name gets populated Parent Broker Code Once you select the broker code the parent broker code gets populated Split Percentage Percentage Format Mandatory if you select any broker in the Intermediary field Specify the percentage of the commission that the selected broker is entitled to receive on any transactions put through for the investor When the Policy Number is selected the split percentage as mentioned in the policy is defaulted here This percentage must not exceed one hundred percent onl ORACLE Note If you specify more than one broker in this section the split percentages f
61. AN A ANEA A ERARA 4 1 4 2 3 Fields in Policy Transaction TOPUP SCre n u cesesscceccetsteeeeeeentteteeeeenaas 4 2 4 2 4 Retrieving Unit Holder Deal in Unitholder Deal Screen nsessninnneeeanaae 4 6 4 2 5 Editing Unit Holder Daal raseriet ri ette tiaina AREE EE NO TAEA 4 7 4 2 6 Viewing Unit Holder Deall 0 ccccccccccecttteeeeceeenneeeeeeeeneeeeeetnaeeeeeetnaeeeenees 4 8 4 2 7 Deleting Unit Holder Deal cccccccceeteeteeeeeeettneeeeeetnnneeeeeetnaeeeeestnaeeeenees 4 8 4 2 8 Authorizing Unit Holder Deal cccccccccieeeceeceetteneeeeeenneeeeeeetneeeeeeetnaeeeeneeas 4 8 4 2 9 Amending Unit Holder Deal ui ccecccccccceceeeeceetnneeeeeetntneeeeeetnneeesestnaeeeenees 4 9 4 2 10 Saving Information Entered 0 0 0 ccccceteeeee eee teeeneeeeeteeeenaeeeseeeaaaeeeteeenaaees 4 19 4 2 11 Processing Back Data Propagation for Transactions ccccccceeeeeeees 4 20 4 3 Policy Transaction Topup Summary Screen eeceeceeeeeeeeeeeeeeeeeneeeeeeeennaeeeeereee 4 20 4 3 1 Retrieving Topup Transaction in Policy Topup Screen 2 cccccceeeeee 4 20 4 3 2 Editing TopUp Transaction 2 cccceeecccccecceeeeeeeeteecneneecaeeeseeeeeeeeetteeseens 4 21 4 3 3 Viewing TopUp Transaction cccceceeeeeceeeceeeeeeeeeeeteeeneeneeseceeeeeeeeneteteens 4 22 4 3 4 Deleting TopUp TranSaction cccccccceeecceceeeeeeeeeeeteecneeneeseeeeeeeseeeeteteees 4 22 4 3 5 Authorizing TopUp TranSactiOn 2 cccccseccecc
62. Allocation Policy Transaction Surrender Detail i New 7 Enter Query Policy Transaction Policy Txn Number Reference Number Policy Number Policy Start Date Product ID Product Name Policy Holder ID Policy Holder Name Maturity Date Policy Financial Wizard Transaction Details Asset Allocation Payment Details Broker Details Load Override Details Details 1of1 Fund ID Fund Name Transaction Currency Transaction Amount Source ID Override Exc m No gt Input By Date Time Authorized By Date time Modification Number auri Unauthorized v Capture the fund wise pattern of distribution of the surrender amount in the Asset Allocation Details section of this tab If the redemption is in different currencies you need to mention the currency wise details here Fund ID Mandatory All the funds mapped for the selected product where the Policy holder has a balance are displayed in the option list Select the required funds Fund Name Display The name of the fund that you select will be displayed oy ORACLE Transaction Currency Alphanumeric Optional Specify the transaction currency for the transaction If many currencies have been mentioned in the settlements then you are required to enter the amount for individual currencies You can specify a transaction currency only if the transaction is amount based Transaction Amount Numeric Mandatory Specify the portion of the
63. Authorized It is mandatory for you to maintain beneficiary details only if the option Beneficiary Details Mandatory has been checked for the underlying product Existing UH Mandatory Select Yes for existing Unit Holder Else No Beneficiary ID Mandatory If the beneficiary is an existing Policy Holder you can invoke the same from the option list Else specify the same 12 ORACLE Relationship Mandatory Specify the relationship of the beneficiary with the Policy Holder Ratio Mandatory Specify the percentage of the Policy Holder s holdings that belongs to the beneficiary The ratio should sum up to 100 Date of Birth DD MM YYYY Optional Enter the date of birth of the beneficiary Type Mandatory Specify whether the beneficiary is a primary or secondary holder Beneficiary for Select Ownership or Proceeds from the drop down list Personal Details First Name Middle Name and Last Name Display The names are defaulted for the selected identification type Identification ID Display The identification ID is defaulted for the selected identification type Identification Type Select the identification type from the option list Address Details State or Country City Zip Code and Address Optional Enter the address of the beneficiary including details such as the city zip code and state or country Phone Number Optional Enter the phone number of the beneficiary
64. Changing Status of Policy c cc eecceeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeseeeaeeeeesenaaeeeeeeeaanees 7 1 LLT WOKING SCOGII daurrean teie erian EnA ee SA EEA eS RSE N tet ae STARE tena 7 1 7 2 2 Fields in Policy Status Change Screen c cccccccesseeeeeeseeeeteeeeneeeeeeesaeeees 7 2 T 23 Saving Information Entered ieee erneiere renine na EEE 7 5 7 3 Policy Status Change Summary Screen eessseeeeeeseeresseirrsstrirrrsstnrnsesrnnnssrennnt 7 6 7 3 1 Retrieving Policy Status in Policy Status Change SCree n cccccceeee 7 6 7 3 2 Editing Policy Status Change ausera ieiu aiai eiaeia eiai a 7 7 7 3 3 Viewing Policy Status Change sseesiisseeeennnneerrnnrenernnnneernnnneernnnneeeenne 7 7 7 3 4 Deleting Policy Status Change cccccccsececeeeeteeeeeeetnneeeeeeesneeeeeeetneeeeesenaa 7 7 7 3 5 Authorizing Policy Status Change ee ssseeeesseeeeennnesrrnnnneernnnneerrrnneeeeene 7 8 7 3 6 Amending Policy Status Change seesseeenseeeeinnneeeerenneeerrnseeerrrnnernnnnnee 7 8 7 3 7 Authorizing Amended Policy Status Change c ccccccccccecsteeeeeeeenteeeeeees 7 8 Cession Maintenance ssssssssssssusnnunnnnnnnnnnnnnnnnnnnnnnnnnnnunnnnnnnnnnnnnnnnnnnnn nnna 8 1 g1 InthOductionys eea r aie AER 8 1 8 2 Creating and Saving Cession ID essssessssereserrrressrirresseernnestnnnnesettnnneatnnanessnnnneeennna 8 1 82t INVOKING STOO eraran E E EEE E N 8 1 8 2 2 Fields in Cession Maintenance Screen
65. Conditional Specify the exchange rate to be used to convert the transaction amount from transaction base currency to policy base currency if you have chosen to override the exchange rate Specifying Policy Details When you click Policy Details tab the following screen is invoked Policy Maintenance Detail M New 4 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Si Load Override Default Load Details Policy information MANSAB Accitional Details Intermediary Details Beneficiary Details Constituent Details Load Override Details Policy Dates Dates Defaulting Next Anniversary Date Creation Date Previous famines Policy Start Date ue i is a Override Anniversary No MaturityDateBasis meet Maturity Date Policy Administrator Policy End Date Policy Amount Type Of Policy ROA Applicable Select One Description Allow ROA At CIF Level Yes Product Level Defaulting Guarantee Period Statement Frequency Take on Annuity Amount Description Number Of Surrenders Policy Base Currency i Allowed ipti Retirement Age Description Life Expect Life Cover Applicable v Life Expectancy Policy Terms Years Life Cover Amount Proof Of Existence E Certificate Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load De
66. Date Funding Percentage Transaction Currency Phase In To Be Currency Name Cancelled Balance Transfer No Transaction Type Txn Type Desc Include Interestin No Investment Top up Inclusive No Policy Base Currency Remarks Interest Amount Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Deal Date FX Value Date Input by Date time Mod No Authorized by Date time UUWE Unauthorized Transaction Date dd MM yyyy Date Format Mandatory Specify the date for the transaction You can enter a backdated transaction here if backdated transactions are allowed in the corresponding product If backdated transactions are not allowed then this date must not be earlier than the Application Date The system supports future dated policy transactions Therefore you can enter the transaction date of a policy greater than the system date Future Date Limit Numeric Optional As stated earlier the system allows you to enter future dated policy transactions os ORACLE The Future Date Limit indicates the number of days in terms of Fund Calendar days up to which future dating of transactions will be allowed The system validates the transaction date against the Future Date Limit and ensures that the transaction date is within the future date limit In other words the transaction date cannot be beyond the number of days expressed as Future Date Limit Example
67. Details section The payment details displayed in this section will depend on whether the surrender money is payable to the client or the product If the surrender money is payable to the client the payment details of the client will be displayed If payable to the product the payment details of the product will be displayed e Bank e Branch e Account Number e Account Type e Account Currency e Account Name e IBAN Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the following confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button os ORACLE 7 3 Policy Status Change Summary Screen You can invoke the Policy Status Change Summary screen by typing LESPLSTA in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Status Change Summary Authorized Open Policy Number Bi Rule Effective Date Present Status Code 3 New Status Code com EI Records per page 15 v Authorized Open Policy Number Rule Effective Date Present Status Code New Status Code 7 3 1 Retrieving Policy Status in Policy Status Change Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all
68. Holder ID a Transaction Reference 7 Number Advanced Search Records per page 15 v 1 of 1 om EI Auth Status Record Status Status Policy Txn Number Policy Number Product ID Transaction Type Transaci 4 m Retrieving Topup Transaction in Policy Topup Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Policy TopUp Summary screen e Select the status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved e Select the status of the record in the Record Status field If you choose the Blank Space option then all the records are retrieved e The Policy Transaction Number e The Policy Number e The Product ID e TXNTYPE e Transaction Date 4 20 ORACLE 4 3 2 e Policy Holder ID e Transaction Reference Number After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combina
69. ID e Transaction Type e Transaction Date e Policy Holder ID e Transaction Reference Number After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen G20 ORACLE 6 3 2 6 3 3 Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Product ID by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product ID starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Surrender Transaction You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Transac
70. No Fund Name Unit Holder Name Fund Base Currency Settlement Details Receipt Details Project Allocation Details Allocation Details Vi Input By DateTime Aod No Authorized By DateTime utes Unauthorized 13 1 ORACLE 14 Function ID Glossary L LEDCMSD ee 8 1 LEDPLALC osne 12 1 LEDPLAN icici 3 1 LEDPLCES ee 9 1 LEDPLINE iiss gninis 10 1 LEDPLSTA sa siticssasiscceeettcnsss 7 1 LEDPLSUR ee 6 2 LEDPLSWI 0 ee 5 1 LEDPLTOP ee 4 1 LEDTXNEE 0 eee 3 51 LESCMSD onii siigde 8 3 LESPLAN d srisigiiicnidooiaiis 3 47 LESPLCES ciisiinsiandunise 9 4 LESPLJNL ooien 10 5 LESPLSTA iioii 7 6 LESPLSUR sictescdincccncceses 6 20 LESPLSWL 0 eee 5 17 LESPLTOP sttscssveticcstestc 4 20 U UTDINRMN nosis 3 53 UTDPLREV ee 11 6 UTDUHDEL 2 2 UTSINRMN ee 3 54 14 1 ORACLE
71. ORACLE LEP Transaction User Guide Oracle FLEXCUBE Investor Servicing Release 12 0 3 0 0 Part No E53392 01 April 2014 LEP Transaction User Guide April 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently danger
72. Partial or Full Redemption Transactions known as Surrender Transactions e Partial or Full Switch Transactions Note Policy transactions can be carried out through the Agency Branch component only Policy Transactions can only be initiated into authorized policies for which the underlying initial investment transaction has already been generated The policy transaction must be authorized before it becomes effective and the underlying transactions are generated This chapter deals with Switch transactions 5 2 Switch Transactions A partial or total switch transaction is effected when a Policy Holder chooses to re allocate his assets in the underlying funds of the policy As a result he re distributes his investment in some or all funds of the policy He may choose to invest in a different fund set or change his investment ratios in the same funds The funds he wishes to invest should be mapped as allowable portfolios for the product In the system a switch transaction is processed as two separate transactions the first involving a redemption from the first or From fund and the second involving a subscription to the second or To fund 5 2 1 Entering Switch Transaction The following are the steps you need to follow to enter and save a Switch Transaction Each of these steps is explained in detail in subsequent sections e Invoke the Policy Transaction Switch screen e Enter information in the Policy Transact
73. Periodic Fee is the sum of admin and broker periodic fee computed in the last batch run for the policy computes Projected Annuity Payment for all policies where the Cash Management Account fund forms a part of the annuity asset allocations computes the Projected Outflow from CMA Projected Outflow is the sum of Projected Annuity Payment and Projected Periodic Fee e The system then compares the Projected Outflow from CMA with the market value of the Cash Management Account e If the Projected Outflow from CMA is greater than the market value of the CMA the system switches funds equal to the Switch Amount to the Cash Management Account from other policy funds Switch Amount is the difference between Projected Outflow from CMA and the Cash Management Account Market Value The switch amount is generated proportionately from the available funds and directed into the CMA fund it ORACLE 12 1 12 1 1 12 1 2 12 1 3 12 Allocation Details Allocation Details Entering Allocation Details The following are the steps you need to follow to enter and save Allocation Details Each of these steps is explained in detail in subsequent sections 1 Invoke the Allocation Details screen 2 Enter information in the Allocation Details screen 3 Save the information entered Invoking Screen You can invoke the Allocation Details screen by typing LEDPLALC in the field at the top right corner of t
74. Reference Number 16 Characters Maximum Alphanumeric Optional Specify a unique identification for this Policy transaction that will be used in all subsequent references to this transaction before it is authorized Policy Number Mandatory Select the Policy on which this transaction is to be effected You can use the Find Policy Options screen The Policy selected must be an authorized active Policy on which the underlying initial investment transaction has already been generated Policy Start Date dd MM yyyy Display When you select the Policy Number the start date of the selected Policy is displayed here 2 ORACLE Policy Holder ID Display When you specify the Policy Number the ID of the Policy holder is displayed here Name Display When the Policy Number is selected the name of the corresponding Policyholder is displayed here Product ID Display When the Policy is specified the ID of the product under which the corresponding Policy has been created is displayed in this field Product Name Display When the Policy is specified the name of the product under which the corresponding Policy has been created is displayed in this field Policy Maturity Date dd MM yyyy Display The maturity date of the Policy is taken from the Policy creation details and displayed here You will not be allowed to change the same ta ORACLE 4 2 3 2 Policy Financial Wizard When you click Policy Financial Wizard
75. Specify the date from which escalation will commence This date must be earlier than the End Date of the Policy and must be later than the Annuity Start Date Escalation End Date DD MM YYYY Date Format Optional Specify the date from which the escalation must cease to be applied on the annuity This date must be later than the Annuity Start Date If the Annuity Escalation Start Date has been specified then the End Date is mandatory and must be specified aag ORACLE 3 2 2 12 Escalation Mode Mandatory Annuity payments can be escalated periodically as a pre defined percentage amount or market value Select the mode from the drop down list Escalation Frequency Mandatory Select the frequency at which the escalation is to be applied from the values in the drop down list If the Start Date has been specified the frequency is mandatory and must be specified Escalation Value Mandatory Specify the escalation amount that is to be applied Recurring Switch Details Section In this section enter the details of any recurring switch transactions that the Policy Holder may want to enter into The details maintained would be standing instructions for a switch transaction gt Recurring Switch Details Recurring Switch Details Sequence Number Frequency SI Number Transaction Currency Status PortFolio Switch Start Date PhaseIn No a gar Type HOLDINGS No Of Annuity Occurrences Escalation Start Date Es
76. Split Percentage Input By Date Time Modification Number Authorized By Date time Muses Unauthorized Broker Details Section Broker Code Broker Code is defined when a broker is created Select the broker code from the option list Broker Name Once you select the broker code the broker name gets populated Parent Broker Code Once you select the broker code system the parent broker code gets populated Split Percentage Percentage Format Mandatory if you select any broker in the Intermediary field Specify the percentage of the commission that the selected broker is entitled to receive on any transactions put through for the investor When the Policy Number is selected the split percentage as mentioned in the policy is defaulted here This percentage must not exceed one hundred percent Note If you specify more than one broker in this section the split percentages for all brokers when summed up must not exceed or fall below one hundred percent Delete You can click delete icon to delete any specified fund aM ORACLE 5 2 9 4 Specifying Load Override Details Policy Transaction Switch Detail New 9 Enter Query Policy Transaction Transaction Reference Number Policy Start Date Product Name Policy Txn Number Policy Number Product ID Name Policy Holder ID j Policy Maturity Date Policy Financial Wizard Transaction Details Asset Allocation Broker Details Lo
77. Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Unitholder Deal Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record Amending Unit Holder Deal After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Unitholder Deal screen will be di
78. ad Override Detaits Details 1of1 Fund ID LoadID Change Type Change Value Group Id Ref Type SelectOne Fund ID Load ID ParentLoadID ChangeType Change Value Ref Type SelectOne Input By Date Time Modification Number Authorized By Date time AUU Unauthorized You can override or alter the value of load mapped to the selected fund You can do so in the Load Override Details screen which is invoked when you click on the Load Override Details Link Refer the Section Load Override Details Link in the chapter Policy for a detailed discussion of the load override details 5 2 10 Un Allotted Fee Transaction During the fee redemption transaction generation process the system will check for 100 switch transaction that is Un Allotted If Un allotted then the fee transaction is reversed e If there is an external switch Pseudo the fee would be taken proportionately from the switch in fund s by means of a fee override and the fee transaction would not get generated e If there is an internal switch the fee transaction would be generated from the switch in fund Note And during the 100 switch transaction process the system will check for any fee trans action that is un allotted Annuity Transaction When you have entered all the mandatory information for a 100 switch transaction system checks if the annuity is applicable for the
79. ails link the following screen is invoked Policy Maintenance Detail New 7 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Al Load Override Policy information Policy Details Additional Details MAMBE Beneficiary Details Constituent Details Load Override Details Intermediary Details 1of1 M Intermediary Description Parent Broker Code Split Percentage Payment Details AssetAllocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open DateTime Authorized The default intermediary details maintained for the unit holder involved in the transaction are displayed here However you can change the defaulted values Intermediary Alphanumeric Optional From the list select the broker preferred by the Policy Holder Parent Broker Code The system will display the parent broker code once the intermediary code is chosen Split Percentage Percentage Format Mandatory if you select any broker in the Intermediary field Specify the percentage of the commission that the selected broker is entitled to receive on any transactions put through for the investor os ORACLE This percentage must not exceed one hundred percent Note If you specify more than one broker in this section the split percentag
80. al Investment Amount ERTA Interest Amount Description Intial Investment Policy Txn Number Exchange Rate Details Exchange Rate Applied Override Exchange Rate No Amount Applied Source ID FX Deal Date FX Value Date Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open DateTime Authorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Maintenance Fields in Policy Maintenance Screen Unit Holder ID Mandatory Enter the Unit Holder ID of the Policy Holder System allows you to create a policy for unauthorized Unit Holder IDs However a policy can be authorized only if the policy holder has been authorized in the system Unit Holder Name System will default Unitholder Name for the selected Unit Holder ID CIF Number Mandatory Enter the CIF Number of the Policy Holder Note You have the option of using the Find Options screen to enter the CIF Number and Unit Holder ID This screen is invoked when you click on the option list Once you have entered the Unit holder ID the CIF Number and the Unit Holder Name will get updated a2 ORACLE 3 2 2 1 Specifying Policy Information When you click Policy
81. alphanumeric value Example You can search the record for Product ID by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product ID starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Interest Rate You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Interest Rate Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Interest Rate Maintenance Detail screen is displayed 5
82. an do so in the Recurring Switch Load Details screen which is invoked when you click on the Recurring Switch Load Details button in the Policy Maintenance Details screen Policy Maintenance Detail 1of1 E Load ID Group Id Change Type Change Value Txn Type Ref Type Select One 1of1 Load ID LoadID ChangeType Change Value Txn Type Ref Type Select One Load ID Display Only The ID of the load that has been mapped to the fund is displayed here The load ID is displayed as a link To view details of the load click the ID link If a derived load has been mapped it is also displayed here and can be overridden ot ORACLE Group ID Display Mandatory Displays the Group ID Change Type Optional When you override or alter a load at the time of entering a transaction you can effect the change in any of the following ways e Discount reducing the load return value in all the slabs e Increase increasing the load return value in all slabs e Return Value assigning an altered return value that will be applicable to all the loads Change Value Numeric Optional Specify the altered return value for the allocation time load that you are overriding Txn Type Display Mandatory This displays the Transaction Type Ref Type Display Mandatory This displays the Reference Type 3 2 2 17 Add Info Click on this link to enter any additional information that you wish You should have defi
83. ansaction Amending Policy After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Maintenance Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Policy Maintenance screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record a8 ORACLE 3 3 7 3 3 8 3 3 9 3 4 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Policy An amended policy must be authorized for the amendment to be made effective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions Reversing Policy You can reverse a policy that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke
84. applicable for the policy system will calculate the next annuity generation date using annuity frequency amp annuity payment lag If difference between annuity generation date amp 100 surrender transaction date is greater than or equal to 4 days then system will check for the funds for which 100 surrender is being processed are also part of the annuity asset allocation If funds are common between 100 surrender transaction amp annuity asset allocation then following warning message will be displayed Annuity transaction is applicable for this policy are you sure you wish to proceed with this transaction You can select override the message and proceed the transaction 9 18 ORACLE 6 2 5 6 2 6 e If difference between annuity generation date amp 100 surrender transaction date is less than 4 days then system will check for the funds for which 100 surrender is being processed are also part of the annuity asset allocation If funds are common between 100 surrender transaction amp annuity asset allocation then error message will be displayed as Annuity is in progress this transaction can not be processed You will not be allowed to proceed with this transaction Processing Back Data Propagation for Transactions You can correct erroneous transactions as well as enter those that have been missed out and compute the effect these have on the current holdings of the unit holder through the back data propagation p
85. are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Unitholder Deal Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Unit Holder Deal An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Unitholder Deal Summary screen 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Unitholder Deal Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error
86. as follows 1 Invoke the Cession Maintenance Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion es ORACLE 8 3 5 8 3 6 8 3 7 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Cession Maintenance Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Cession Maintenance An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Cession Maintenance Summary screen 1 Invoke the Cession Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double
87. ash Management Account in this chapter for more details on the operation of the Cash Management Account Description Display The system displays the description of the specified preference for fund redemption Initial Investment Policy Txn Number Display The system displays the transaction number of the initial investment policy Specifying Exchange Rate Details The exchange rate details that are defaulted here or that you modify here will be used to convert the policy transaction amount as well as the interest on initial investment amount into the policy base currency Amount Applied Display Only The system displays the transaction amount in terms of the policy base currency Source ID Alphanumeric Optional You can select the source ID required from the adjoining option list If you do not specify any the system will default the source ID when you save the policy FX Deal Date Date Optional Enter the deal date for exchange rate FX Value Date Date Optional Enter the value date for the exchange rate a ORACLE 3 2 2 2 Override Exchange Rate Alphanumeric Optional Select Yes if you wish to change the exchange rate that is displayed here If you select Y however you need to specify the exchange rate to be used for the transaction in the Exchange Rate Applied field Select No if you wish to retain the exchange rate that is displayed by the system Exchange Rate Applied Numeric
88. at are to be invested in each of the selected funds Specify the percentage of the amount that must be invested in each of the selected funds The sum of all such percentages must add up to 100 and not fall below or exceed it The percentages specified here must not be fractional The latest investment ratio applicable for the Policy is displayed here when the form is opened These values can be amended and you can specify the required percentages If there are many currencies specified as part of settlements then the system will not allow you to enter a ratio Instead you need to enter the transaction currency and transaction amount for each currency The system will compute and display the ratio based on the currency and amount details provided To calculate the ratio the transaction amounts will be converted to policy transaction currency based on the exchange rate defined in settlements If the settlements are maintained in only one currency then you can enter either the ratio or the transaction amount Transaction Amount Numeric Mandatory Specify the portion of the transaction amount that is to be invested in each of the selected funds If different currencies have been mentioned in settlements then you can specify only ats ORACLE the transaction amount The system will default the ratio If all the currencies in settlements are the same then you can specify either the transaction amount or the ratio Note If you
89. ated transaction here but this must not be earlier than the first Rule Effective Date of the policy By default the application date is displayed in this field 10 2 ORACLE 10 2 2 2 Policy Holder Display When the Policy Number is selected the name of the corresponding Policyholder is displayed here Outstanding Payment Section From Date DD MM YYYY Mandatory Specify the date that marks the beginning of the period for which the journal entry is made This date cannot be a future date Note This date cannot be lesser than or equal to the date of policy creation To Date DD MM YYYY Mandatory Specify the date that marks the end of the period for which the journal entry is made This date cannot be a future date Adjustment for Previous Cycle Optional Select Yes to indicate that the journal entry being posted is an adjustment for the previous cycle Journal Amount Numeric Conditional Enter the outstanding amount to be paid to the customer System will treat the value specified here as the gross annuity amount Note The field will be disabled if the Adjustment for Previous Cycle option is checked Net Annuity Amount Numeric Conditional Enter the adjusted net annuity amount here The annuity details will be calculated by the system based on the amount you enter here on the journal transaction date and the tax ledger entries will be made for the new net annuity amount
90. ates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Table of Contents About This Manual cccccesciscas cecoecciecaccsactessereete cccsveracectecaacasttavecnsacassaseecaeeenet 1 1 Tel aae ea E ETA atic A ON T I E aaa 1 1 12 Related DOCUMeEmMS ecceri deiri aiii aai ia A ia 1 1 To AUGEN oe r a E e A N 1 1 Tt ranza T E at SA A OAE 1 1 1 5 Conventions Used in this M nual ssie nenita e aa REE AEE ARER 1 2 1 5 1 General CONVENTIONS sirsiran ea aa iiia eaa iaa e a aiara 1 2 1 5 2 Keyboard CONVENTIONS sessist tee eee ente eee eeeteee eee taaaeeeeeetiaaeeeeeetaaeeeenee 1 2 Wo lt GlOSSAary o ICONS arara an ekack cadets edi EE AS AEA R EA dade tee et deta 1 2 1 7 Abbreviations and ACronys cccccceeseeeeeeeeeeeeeeeeeeaeeeeeeeaaeeeseeeaaeeeseeeseeeeeseeaes 1 3 TS Getting HA enaa E ainiiient et E a iat itis 1 4 UH Deal Maintenance xocccc22scscecc cc cisassteesesete cece dense cceke excites stave ete 2 1 21 Introduction caian a EAEAN S ANAT EA EAN A 2 1 adol oa A E TTT A A S 3 1 SA PTOGUCION erR es ee Ati teases ed ee eee 3 1 3 2 Creating and Saving Policy Auauna reaa E EREE 3 1 32 1 INVOKING Stroo aour utes ede Adee anda eee 3 1 3 2 2 Fields in Policy Maintenance SCre N cccecceccstteeeeeeensteeeeeeentaeeeeeeeaaes 3 2 3 2 3 Saving Information Entered 0 0 0 cceesc cence eee eeeee eee teeeeeeeeeeeeeeaeeeeeeeenanees 3 46 3 2
91. calation Frequency Escalation End Date Description Escalation Mode Select One Escalation Value Asset Allocation Details 1of1 Fund ID Units Ratio Switch Asset Allocation 1of1 Fund ID Units Ratio 290 ORACLE Recurring Switch Details Sequence Number Optional You can enter the sequence number SI Number Display When you save the details of the Policy you are entering the Standing Instructions or Sl Number will be generated by the system and displayed Note During amendment of a Policy you will not be allowed to change the number of occurrence that you already have specified Status Mandatory Select the status of the recurring switch from the option list The options available are e A Active e C Cancel e N Not Started e P Pause e S Stop Note If you select the status STOP escalation will not be applied on the annuity Transactions will not be generated for Sls on annuities whose status is STOP It is pos sible for you to change the status of such Sls to ACTIVE during amendment of the policy During amendment of a policy you can change the status of an active SI to Paused Stopped or Cancelled During amendment of an SI marked Not Started you can change all details except the status of the SI You will be allowed to delete the SI During amendment of an active SI Esca
92. ch Name Payment Currency Cheque Number 7 Payment Amount Clearing Date pi Account Type n ji sar Account Number EEEE nae Account Currency IBAN Exchange Rate Details Source ID Override Exchange Rate No Exchange Rate Applied FX Deal Date Transaction Currency FX Value Date Amount Interest Details Interest Rate Interest Calc Days _ Interest Amount BasisDays 360 Interest Amount In Transaction Currency Input by Date time Mod No Authorized by Date time ieee Unauthorized Capture the details of payments made by the Policy Holder towards processing of the transaction in this tab Payment Details Bank Code Mandatory Select the Bank code from the option list Branch Code Mandatory Select the Branch code from the option list Cheque Number Mandatory Enter the cheque number of the cheque draft number of the demand draft by which the payment is being made o gt ORACLE Clearing Date DD MM YYYY Date Format Mandatory Specify the Clearing Date of the payment Cheque Date Date Format Mandatory Enter the cheque date of the cheque draft number of the demand draft by which the payment is being made Payment Type Mandatory Specify whether the payment will be made by the Policyholder or a 3rd party Payment Mode Mandatory Select the mode through which the payment is made by the Policyholder This could be any one of the following as applicable e Cash e Cheque e Money Transfer
93. cified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Product Type by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product Type starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product Type ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product Type contains the numeric value 17 For example GSD217 GSD172 AGC17 etc 9 3 2 Editing Policy Cession You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Cession Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field
94. click the record that you wish to authorize The Cession Maintenance Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the transaction Amending Cession Maintenance After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Cession Maintenance Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Cession Maintenance screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Cession Maintenance An amended Cession Maintenance must be authorized for the amendment to be made e
95. cord by using combination of and alphanumeric value Example ee ORACLE 8 3 2 8 3 3 8 3 4 You can search the record for Product Type by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product Type starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product Type ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product Type contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Cession Maintenance You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Cession Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that
96. corresponding to the latest rule for the policy LEP Recurring Plan Premium Processing This BOD Batch Process generates periodic premium transactions for the Policies for which premium is applicable This transaction is generated using the premium setup corresponding to the latest rule for the Policy LEP Plan Funding Repayment See Plan Funding Repayment This will be a BOD Process LEP Generate Plan Redemption Transactions for Periodic Fees After the periodic fee has been calculated for a Product by the system this BOD Batch Process generates a redemption transaction in policyholder s account for the calculated Periodic Fees LEP Process Plan Surrender This process reduces the funded units in the underlying portfolio for a Policy in the event of a surrender transaction initiated by the policyholder It functions as follows e On the Application Date this process identifies the surrender transactions that have been effected at a policy level for funded endowment products and checks for the existence of funded units for these policies Met ORACLE e The funded units are then reduced in proportion to the surrender transaction e The value of the reduced funded units is moved to the suspense bank account maintained for the product using the same policy transaction number corresponding to the surrender transaction The value is arrived at using the redemption price for each fund 11 3 20 1 LEP Batch P
97. ct Yes Else select No Note This field will be enabled only for the options Claim and Surrender in the drop down list against the field New Status Surrender Money Payable Mandatory Indicate to whom the surrender money is payable Offset Value Optional Numerical Specify the amount that will be deducted from the surrender money payable to the Policy Holder ine ORACLE Back Date Surrender Optional During a status change to Surrender or Claim a 100 redemption transaction will be generated If you want redemption transaction to be back dated select Yes The transaction date can then be entered in the field Last Transaction Date Note This field will be enabled only for the options Claim and Surrender in the drop down list against the field New Status Last Transaction Date dd MM yyyy Mandatory if box Back Date Surrender is checked Initially this field will display the date on which the last transaction was carried out If you have checked the box Back Date Surrender you can change this date Note The date that you enter here should necessarily be between the date that was originally displayed in this box and today s date Average Salary Last 2 Years Optional Enter the average salary of the Policy Holder in the last two years Note This field will be enabled only for the options Death Without
98. ction currency maintained at the fund level will be default if all the transaction currencies for the fund are the same If various currencies have been maintained at the fund level then the system will default the policy base currency as the policy transaction currency Include Interest in Investment Optional Select from the adjoining drop down list if the interest earned on the initial investment should be considered along with the initial investment for investment in the policy If you select Yes the interest amount will be included in the investment and a single transaction will be generated for both You need to manually add the interest amount calculated in the settlement details to the transaction amount of the particular currency in the asset allocation details For instance if the interest amount is USD 1000 and the transaction amount is USD 100000 then you are required to add USD 1000 to the transaction amount for the currency USD in the asset allocation details If you select No the interest amount will be generated as a separate UT transaction Initial Investment Amount Optional You have the option of entering the initial amount to be invested in the policy If the product is a single premium product the box Multiple Premiums Allowed is not checked while creating a product and you enter an amount here the system will generate a transaction for this amount You will be allowed to change the initial
99. ctions known as Surrender Transactions e Partial or Full Switch Transactions Note Policy transactions can be carried out through the Agency Branch component only Policy Transactions can only be initiated into authorized policies for which the underlying initial investment transaction has already been generated The Policy transaction must be authorized before it becomes effective and the underlying transactions are generated This chapter deals with Top Up transactions 4 2 Top Up Transactions After subscribing to a Policy in any of the Products of the AMC the Policyholder may deem it necessary to increase his contribution in the Policy at any given point of time In such an event he can request for a Policy transaction to be initiated Such investments are called top ups in the system 4 2 1 Entering Top up Transaction The following are the steps you need to follow to enter and save a Top Up transaction Each of these steps is explained in detail in subsequent sections e Invoke the Policy Transaction Top Up screen e Enter information in the Policy Transaction Top Up screen e Save the information entered 4 2 2 Invoking screen Invoke the Policy Transaction TOPUP Detail screen by typing LEDPLTOP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 4 ORACLE 4 2 3 4 2 3 1 The following screen is invoked Policy T
100. cy Transaction Topup Summary screen as follows 1 Invoke the Policy Transaction Topup Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Transaction TOPUP Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing TopUp Transaction An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Transaction TopUp Summary screen 1 Invoke the Policy Transaction Topup Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the scree
101. cy Transaction Exchange rate Enrichment D New 4 Enter Query Enrichment Option Policy Settlement Details Product ID From Date Policy Number To Date Policy Txn Number OK Source ID Source Name Exchange rate Enrichment Detail 1of1 m Product ID Policy Number Policy Txn Number From Currency From Amount To Currency To Amount Source f Fields in the Policy Transaction Exchange Rate Enrichment Screen Enter the required details here Enrichment Option Alphanumeric Optional Select the enrichment option from the adjoining drop down list The options are e Policy Settlement e Policy Transaction Product ID Alphanumeric Optional Specify the Product ID for which you wish to enrich transactions Fal ORACLE Policy Number Alphanumeric Optional Specify the policy number for which enrichment is required Policy Txn Number Specify the policy transaction number for which enrichment is required Source ID Specify the Source ID for which enrichment is required Source Name The system defaults the name for the Source ID selected From Date Specify the date from which enrichment is required To Date Specify the date till which enrichment is required After you specify the required details press OK The system will display all the matching records in the Exchange Rate Enrichment Details grid 3 5 1 1 Exchange Rate Enrichment Details In this grid the system will display the following values
102. d Manager User manual is organized under the following chapter sequence About This Manual explains the structure audience organization and Chapter 1 related documents of this manual LEP Transactions An Overview enables you learn about LEP Transac Chapter 2 tions Chapter 3 LEP Transactions UH Deal Maintenance explains the deal maintenance LEP Transactions Policy takes you through the process of entering the details of a Policy A reference has been made to the Agency Branch User Manual The chapter to which a reference has been made will help you Chapiers create a Unit Holder in the system This is to be done before a Policy is created in the system as every Policy Holder in the system should be a valid Unit Holder LEP Transactions Policy Transaction Top Up Refer to this chapter for Chapter 5 i information on entering Policy Transactions LEP Transactions Policy Transaction Switch Refer to this chapter for Chapter 6 information on entering Policy Switch Transactions LEP Transactions Policy Transaction Surrender Refer to this chapter Chapter 7 l for information on entering Policy Surrender Transactions Chapter 8 LEP Transactions Policy Status Change Refer to this chapter for infor mation on changing the status of a Policy t1 ORACLE 1 5 1 5 1 1 5 2 1 6 LEP Transactions Cession Maintenance
103. d as 100 ey ORACLE 6 3 6 3 1 Refer to the chapter Product and Batch Activities for further information on Automatic Surrender Policy Transaction Surrender Summary Screen You can invoke the Policy Transaction Surrender Summary screen by typing LESPLSUR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Transaction Surrender Summary Record Status Auth Status Policy Txn Number a Policy Number EH Product ID ai Transaction Type Ad Transaction Date E Policy Holder ID 2 Transaction Reference a Number Advanced Search Ea Records per page 15 v S ee Auth Status Record Status Status Policy Txn Number Policy Number ProductID Transaction Type Transacl le Authorized Retrieving Surrender Transaction in Policy Transaction Surrender Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Policy Transaction Surrender Summary screen 1 Select the status of the record in the Auth Status field If you choose the Blank Space option then all the records are retrieved 2 Select the status of the record in the Record Status field If you choose the Blank Space option then all the records are retrieved e Policy Txn Number e Policy Number e Product
104. d at the policy level The ad hoc top up contribution is marked as Inclusive even if it is Exclusive if it violates the minimum maximum annuity ratio specified e A procedure is then used to validate the 5 20 rule using the annuity amount specified and the NIA as parameters and an error report is logged if the 5 20 Rule is violated on any on any of the following events Saving of a policy Amendment of a policy Top Up transaction On the Anniversary Date Anniversary Escalations 5 20 Rule The annuity amount that is paid to the policyholder must be within the range of the Minimum Annuity Ratio 5 and the Maximum Annuity Ratio 20 of the Net Investible amount NIA The Net Investible Amount is the investment amount minus the initial fees and charges The annuity should not be accepted if the annuity amount either falls below the 5 threshold of the NIA or exceeds the 20 threshold of the NIA and all inclusive top up transactions Consider the example given below Case A Let us consider a Policy Holder who buys a policy in an ELLA product He initially contributes 60000 currency units net of initial charges on 15t January 2005 On 15 January 2005 EOD the 5 20 Rule batch checks the annuity amount which has been specified as 3000 currency units against the NIA 60 000 currency units This amounts to 5 of the NIA per month for a period of 5 years There is no violation of the rule here Now let us s
105. d record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Transaction Surrender Summary screen 1 Invoke the Policy Transaction Surrender Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Transaction Surrender Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record Amending Surrender Transaction After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Transaction Surrender Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for a
106. de 1of1 LoadID Change Type Group Id Change Value Txn Type Ref Type m Select one Load Override 1of1 Load ID Change Type Change Value Txn Type Ref Type Select one Initial Load Override Details Load ID Display Only The ID of the load that has been mapped to the fund is displayed here The load ID is displayed as a link To view details of the load click the ID link ORACLE If a derived load has been mapped it is also displayed here and can be overridden Change Type Optional When you override or alter a load at the time of entering a transaction you can effect the change in any of the following ways e Discount reducing the load return value in all the slabs e Increase increasing the load return value in all slabs e Return Value assigning an altered return value that will be applicable to all the loads Group ID Display Mandatory Displays the Group ID Change Value Numeric Optional Specify the altered return value for the allocation time load that you are overriding Txn Type Display Mandatory This displays the transaction type Ref Type Display Mandatory This displays the reference type Pal ORACLE 3 2 2 14 Premium Load Override Section You can override or alter the value of load applied on premium payment mapped to the selected fund You can do so in the Load Override Details screen which is invoked when you click on the Load Override Details button
107. e NAV Correction does not support the correction of an initial investment if the transaction has been allotted or if any underlying policy transactions have been generated NAV cor rection will also not support the reversal correction of policy switch transactions if it is across AMCs provided there is no allocation lag 11 3 9 LEP Set Latest Rule for Product When a new Product is setup or after a Product has been amended if the System Date is equal to the Rule Effective Date of the Product this BOD Batch Process will set the current rule as the latest rule The new rule will be considered for all the validation processes 11 3 10 LEP Set Latest Rule for Plan When a new Plan Policy is setup or after a Plan Policy has been amended if the System Date is equal to the Rule Effective Date of the Plan Policy this BOD Batch Process will set the current rule as the latest rule The new rule will be considered for all the validation processes 11 3 11 LEP Plan Anniversary Value Computation The system facilitates the revaluation of annuity payments on every Anniversary Date through this BOD process It works along the following lines 1 The process checks if the Application Date is an Anniversary Date 11 ORACLE 11 3 12 11 3 13 11 3 14 11 3 15 11 3 16 11 3 17 11 3 18 11 3 19 11 3 20 2 Ifso the anniversary revaluation is done for all ELLA policies and the computed values updated in the
108. e the transaction amount is computed and displayed in the Transaction Amount field and locked In case you have specified the percentage as 100 then the transaction amount is displayed as zero The percentage you specify here must not exceed one hundred Adjustment Transaction Mandatory This box is enabled if the transaction is mentioned under the Transaction Sub Types for Adjustment Withdrawal However you can edit it If the transaction is an adjustment withdrawal then system would not validate the No of withdrawals allowed at Product Policy level Also the withdrawal counter at the policy level would not be updated oF ORACLE Phaseln To Be Cancelled Optional You can choose to cancel all none or specific Ids of the active Phaseln setup Surrender Money Payable Mandatory Specify to whom the surrender money is payable by selecting the same from the option list Transaction Type Optional Select the Adjustment Transaction Type from the option list The option list includes options which can be maintained in the System Parameters Maintenance screen under the Param Code PLCYSURRTYPE For further information on the System Parameters Maintenance screen refer to the chapter Maintaining System Parameters Description System displays the description of the selected transaction type Remarks Alphanumeric Optional Enter a brief description of the transaction or any applicable remarks about the transaction Surr
109. e Policy Journal Maintenance screen e Enter information in the Policy Journal Maintenance screen e Save the information entered 10 2 1 Invoking Screen You can invoke the Policy Journal Maintenance Detail screen by typing LEDPLJNL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is invoked E3 Policy Journal Maintenance New 5 Enter Query Policy Journal Journal Txn Number Journal Type Select JournalType Policy Number Journal Currency Reference Number Policy SI Number Journal Txn Date Policy Holder OutStanding Payment From Date Journal Amount To Date Remarks WHT Amount Net Annuity Amount Payment Details Payment Mode Select Payment Mode Account Type Bank Account Number Branch Account Currency IBAN Input by DateTime Authorized by DateTime Mod No Open Authorized 10 1 ORACLE 10 2 2 10 2 2 1 Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Journal Maintenance Fields in Policy Journal Maintenance Screen Policy Journal Section Journal Number System Generated This is a unique identification for the journal entry made for the policy It is generated by the system when all details that are mandatory for the journal entry have been successfully entered and the policy journal entry is saved This jou
110. e System Date When the policy is Authorized an initial investment transaction will be generated with the premium amount Case 4 The product is a multiple premium product you do not enter any initial investment amount but only the premium amount The Start Date for the premiums is a future date When the policy is Authorized an initial investment transaction will be generated on the date specified with the premium amount Note In a scenario as described under Case 4 you will be allowed to amend the premium amount till the date specified You will however not be allowed to enter an initial invest ment amount after you authorize a policy Case 5 The product is a multiple premium product you do not enter either the initial investment amount or the premium amount No transaction will be generated on saving the policy An initial investment transaction will be generated only if you enter any premium details at a later stage Note The initial investment amount and premium amounts are independent of each other This means that changing the initial investment will not change the premium amount and vice versa Let us say for example you have not entered the initial investment amount and have entered only the premium amount You now wish to enter an initial investment amount You may do so before the policy is authorized and in doing so the premium amount you have entered will not be affected Similarly if you cha
111. e are reflected in the Policy Maintenance Summary screen Viewing Policy To view a Policy you have previously entered you must retrieve the same in the Policy Maintenance Summary screen as follows 1 2 Invoke the Summary Screen from the Browser Select the status of the Policy that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Policy Maintenance screen is opened in view mode 348 ORACLE 3 3 4 3 3 5 3 3 6 Deleting Policy You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Maintenance Summary screen as follows 1 Invoke the Policy Maintenance Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved a
112. e done for a policy top up based on the payment date and transaction date alt ORACLE Basis Days Mandatory Numeric Select the interest basis days based on which the interest will be calculated The options available are e 360 days e 365 days 4 2 9 4 Specifying Broker Details Policy Transaction TOPUP Detail New 9 Enter Query Policy Transaction Transaction Reference Number Policy Start Date Product Name Product ID N Policy Holder ID ai Policy Maturity Date Policy Txn Number Policy Number Policy Financial Wizard Transaction Details Asset Allocation Payment Details MARENDE Load Override Details Broker Details Faich Broker Details Broker Details 1of1 Broker Code Broker Name Parent Broker Code Split Percentage Input by Date time Mod No Authorized by Date time ANUIES Unauthorized v exit Broker Code System will fetch the Broker Mapped for the Policy User can also input the broker code from the option Isit Broker Name Display Upon selection of the broker code the system displays the name of the selected broker code Parent Broker Code Display The system displays the parent broker code Split Percentage Percentage Format Mandatory if you select any broker in the Intermediary field Specify the percentage of the commission that the selected broker is entitled to receive on any transactions put thro
113. e following bank account details will be displayed e Bank oN ORACLE e Branch e Account Number e Account Type e Account Currency e Account Holder Name When you specify that the Mode of Payment is Money Transfer and the Payment Type is Third Party you will have to specify the following Identification Number Enter the identification number assigned to the third party Contact Name Enter the name of the contact person Address Line1 and Line 2 Alphanumeric Mandatory Specify the address of the third party for which the transfer payment must be made Bank Mandatory Select the name of the bank in which the transfer account is present from the drop down list Branch Code Alphanumeric Mandatory Specify the branch code of the bank in which the transfer account is present Account Type Mandatory Select the account type of the transfer account Account Number Mandatory Specify the number of the transfer account Account Currency Display The transaction currency is displayed You are not allowed to change this value Clearing Date Date Format Mandatory Specify the Clearing Date of the payment Note During Surrender transaction if the third party bank detail is set to Payment Type you can select the Verified and Unverified bank details from the option list However if you choose the bank account as Unverified a warning message will be put up 6 15 ORACLE IB
114. e required percentages If there are many currencies specified as part of settlements then the system will not allow you to enter a ratio Instead you need to enter the transaction currency and transaction amount for each currency The system will compute and display the ratio based on the currency and amount details provided To calculate the ratio the transaction amounts will be converted to policy transaction currency based on the exchange rate defined in settlements If the settlements are maintained in only one currency then you can enter either the ratio or the transaction amount Transaction Amount Numeric Mandatory Specify the portion of the transaction amount units that are to be invested in each of the selected funds The sum of these amount units must not be greater than the total transaction amount units specified in the transaction details tab for this transaction If different currencies have been mentioned in settlements then you can specify only the transaction amount The system will default the ratio If all the currencies in settlements are the same then you can specify either the transaction amount or the ratio Note If you have specified the investment ratios in each fund the investment amounts are com puted and displayed here and this field is locked Auto Clear Provisional Balance For a complete switch transaction you can use this field to indicate that the outflow transaction should include units in
115. ecceeeeeeeeetecneenteaeceeeeeeeeteneteens 4 22 4 3 6 Amending TopUp Transaction 2 2 cccccccccccecceceeeeteceeensecaeseeeeseeeeeentesseens 4 23 4 3 7 Authorizing Amended Transaction TODUD c ccssceeeesteeeeeeeeeeeeteteteens 4 23 4 3 8 Reversing TopUp TranSaction 22 ccccccecccccceceeeeeetectecenenneceeeeeeeeeeenteeseens 4 23 5 Policy Transactions Switch assssannnnsnnnnnnnnnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 5 1 Delis Introduction oneri a AAE eet ea ne tae ads 5 1 5 2 Switch Transactions aececi aneii in eii E AA E NSSE E AAA 5 1 9 2 1 Entering Switch Transaton iseitis raii dear iei lesii a AR 5 1 9 2 2 INVOKING Screen niesienie iinis eaat REEE EE Eaa RE TEAN AREE 5 1 5 2 3 Fields in Policy Transaction Switch SCre n cccccccsscceceesseeeeeeenteeeeeeeeaes 5 2 5 2 4 Retrieving Unit Holder Deal in Unitholder Deal Screen 0 cccceireeee 5 5 9 2 5 Editing Unit Holder Deal osasi an e a AE a E ERE 5 6 5 2 60 Viewing Unit Holder De all cccccccccccseceeeceesnnneeeeeeennaeeeeeeenaeeeeeeseaeeeeeseaaas 5 6 5 2 7 Deleting Unit Holder Deal 02 ceceeccccseteeeeeeeenneeeeeeeeneeeeeeesnaeeeeeeeenaeeeeesenias 5 7 5 2 8 Authorizing Unit Holder Deal 0 c cccsccecsssteeeeceeenteeeeeeeeneeeeeeeenaeeteeseaaes 5 7 5 2 9 Amending Unit Holder Deal cccccccscececceststeeeeeeenneeeeeeesnieeeeeeennaeeeeesenaas 5 7 5 2 10 Un Allotted Fee TranSaction cccccccccceeeceeteceeeeeeeetseeeeeeetineeeeee
116. ecords whose Product Number starts from Alphabet A For example AGC17 AGVO6 AGC74 etc Search by 7 System will fetch all the records whose Product Number ends by numeric value 7 For example AGC17 GSD267 AGC77 etc Search by 17 System will fetch all the records whose Product Number contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Policy You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 2 Invoke the Policy Maintenance Summary screen from the Browser Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to modify in the list of displayed records The Policy Maintenance Detail screen is displayed Select Unlock Operation from Action list to modify the record Modify the necessary information Click Save to save your changes The Policy Maintenance Detail screen is closed and the changes mad
117. ect Yes however you need to specify the exchange rate to be used for the transaction in the Exchange Rate Applied field Select No if you wish to retain the exchange rate that is displayed by the system Exchange Rate Numeric Optional The system will default the exchange rate available for the currency based on the exchange source specified If you have elected to override the exchange rate you need to enter the exchange rate to be used here If exchange rate is not available then the system will generate the transactions as incomplete ones Such transactions can be enriched later through the Policy Transaction Enrichment Screen FX Deal Date Date format Optional The system will default the starting date of the policy here You can change it if required FX Value Date Date format Optional The system will default the starting date of the policy here You can change it if required a8 ORACLE 3 2 2 9 Units Ratio 3 Characters Maximum Numeric Mandatory For each fund that is displayed specify the ratio of investment or the number of units to be made in the fund out of the total contribution towards the Policy The sum total of the investment ratio should add up to 100 If there are many currencies specified as part of settlements then the system will not allow you to enter a ratio Instead you need to enter the transaction currency and transaction amount for each currency The system will compute and
118. ecurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by Authorized by Identification ID Identification Type Phone Number Fax Number E Mail ID Account Type Account Number Account Currency IBAN 3 18 ORACLE It is mandatory for you to maintain constituent details only if the option Constituent Details Mandatory has been checked for the underlying product Constituent Details The constituent details are given below Existing UH Mandatory Select Yes for existing Unit Holder Else No Constituent Type Mandatory Select all the stakeholders of the Policy from the option list Constituent ID Mandatory Specify the ID of the constituent from the option list You can either select a valid Unit Holder in the system or enter a Constituent ID Relationship Mandatory Select from the option list the relationship of the constituent to the Policy Holder Status Select the status Alive or Dead Personal Details The personal details are given below Identification Type Select the identification type from the option list Identification ID Display The identification ID is defaulted for the selected identification type Date of Birth Optional Enter the date of birth of the constituent holder First Name Middle Name and Last Name Display The names are defaulted for the selected ide
119. efault the exchange rate available for the currency based on the exchange source specified If you have elected to override the exchange rate you need to enter the exchange rate to be used here If exchange rate is not available then the system will generate the transactions as incomplete ones Such transactions can be enriched later through the Policy Transaction Enrichment Screen FX Deal Date Date format Optional The system will default the start date of the policy here You can change it if required FX Value Date Date format Optional The system will default the start date of the policy here You can change it if required B 10 ORACLE Units The Units field enables you to allot units applied for each fund under asset allocation This is based on the gross amount of the unit product To show the number of units applied to the fund under allocation specify the number of units allocated Once the Transaction Mode is selected as units the following fields are defaulted e Portfolio Surrender option is chosen as true and the field is disabled for entry e The Transaction amount is defaulted as Zero and the field is disabled for entry e The percentage of holdings are rendered zero and the field is disabled for further input It is necessary for you to enter the Units applied for each Fund under the asset allocation details Ratio Numeric Mandatory Specify the percentage of the amount that must be redeemed in each of t
120. elds on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Policy Transaction Switch Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Policy Transaction Switch Detail screen is closed and the changes made are reflected in the Policy Transaction Switch Summary screen Viewing Transaction Switch To view a Policy Switch you have previously entered you must retrieve the same in the Policy Transaction Switch Summary screen as follows 1 Invoke the Policy Transaction Switch Summary screen from the browser ote ORACLE 5 3 4 5 3 5 5 3 6 2 Select the status of the Policy that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the
121. en and the FCIS Enrich Exchange Rate Detail screen the system will compute the transaction amount and generate the UT transaction If it is not enriched then the system will pick the exchange rate during EOD and generate the UT transaction Interest Details When you click the Enrich button in the Transaction Detail tab if the investment amount has been deposited prior to the transaction date the system will calculate and display the interest on the payment amount in the Policy Information tab The interest will be calculated from the date of payment till the transaction date When you click Calculate Interest button in the Settlement Details screen the system will calculate and display the interest amount in the Interest Amount field in the same screen Interest Rate Numeric Optional Enter the rate of interest that is to be used to calculate interest amount for the particular currency Alternatively you can maintain the interest rate in the Interest Rate Maintenance screen If you do not maintain an interest rate the system will take it as null Interest Amount Display Only The system computes and displays the interest amount Interest Amount in Transaction Currency Display Only The system computes and displays the interest amount in terms of the transaction currency Interest Calc Days Display Only The system calculates the number of days for which interest calculation has to b
122. enance Cession Date First name Cession ID Cession Remarks Transferee Name Policy Number Policy Holder ID Product ID Cession Type SelectOne v Transferee ID Cessionary Details Cessionary Name City Cessionary Ref Number State Contact Person Address Line 1 Address Line 2 Input by Authorized by Mod No Zip Code Phone Number Fax Number E Mail DateTime DateTime Open Authorized 9 1 ORACLE 9 2 2 9 2 2 1 Fields in Policy Cession Maintenance Screen Policy Cession Maintenance section In the Policy Cession Maintenance section you will have to enter information in the following fields Policy Number Alphanumeric Mandatory Select the number of the Policy that must be marked with a Cession ID Note This number must represent an authorized enabled and active policy for which at least one underlying transaction has been generated authorized and allocated The Policy Number entered here must represent a Policy that comes under a Product that is authorized and active You can use the button alongside this field to view a list of valid policies and select the required one When you specify the Policy Number all the details of the Policy are picked up from the policy record and populated in the corresponding fields in this form Cession Date Display The date on which the transfer is affected is the Policy Cession Date It is deemed to be the application date
123. ender Limit Display For the Product that you have chosen for the Policy Holder you would have selected the Withdrawal Limit Basis The Surrender Limit will be calculated based on this specification and displayed here Exchange Rate Details The policy transaction currency can be different from the base currency of the policy In this section you can maintain the details related to the exchange rate to be used for currency conversion Amount Applied The amount calculated based on the exchange rate specified gets displayed here after the calculation Exchange Rate Applied The exchange rate corresponding to the combination of policy base currency and policy transaction currency gets displayed here The exchange rate for a surrender transaction will be between policy base currency and transaction currency Source ID Mandatory Specify the source from which the exchange rate is obtained or select the source ID from the option list provided ORACLE 6 2 3 5 Override Exchange Rate Select the option to indicate if you wish to override the exchange rate that gets defaulted Select Yes to indicate that you wish to override the exchange rate and No to indicate otherwise Click Calculate to calculate the amount using the exchange rate specified The interest amount associated with the policy transaction also gets converted to policy base currency based on the exchange rate specified Specifying Asset
124. ender Screen cccccccseeeeeenseeeeeeeenaes 6 2 6 2 4 Saving Information Entered 0 0 0 ccceeccccceeeee eee e teens eee ceeeeeeeeeseeeeaeeeeteeeanees 6 18 6 2 5 Processing Back Data Propagation for Transactions 0ccccccceeeereeeees 6 19 6 2 6 Automatic Surrender Of Policy eessesesersneseerrrnerrrrnnnnnerrrnnrennnnnnenrrnnnrrenns 6 19 6 3 Policy Transaction Surrender Summary Screen ee eeeeeeeeeeeeteeeeeeettaeeeeeeeenaees 6 20 6 3 1 Retrieving Surrender Transaction in Policy Transaction Surrender SCION ccccccccceceeeteteeeeeetenieeeeeetnaeeeeeetiaeeeenene 6 20 6 3 2 Editing Surrender TranSaction cccccccccesceeeeceeeeeseceneeeeeseseseeeetenenaeeees 6 21 6 3 3 Viewing Surrender Transaction ccccccccsccceeeesneeeeeeeenceeeeteeneeeeeteenateees 6 21 6 3 4 Deleting Surrender TransactiOn ccccccccceceececeeeeeseeeceeeeteeeseeeetenaaeees 6 22 6 3 5 Authorizing Surrender Transaction ccccccccccecseeeeteenseeeeeeeeeeeeeeteeseaeeees 6 22 6 3 6 Amending Surrender TranSa ction c ccccccccecceseeeeteeeneeeeeteeesteeeeeeeseeees 6 22 6 3 7 Authorizing Amended Surrender Transaction eccccceeeeeeeteeeetntteeeeeeeee 6 23 6 3 8 Reversing Surrender TranSa ction c cccccccccccceseeeeteeeseeeeeseeesteeeeseeesaeees 6 23 Policy Status ChanmQe 2 scssvsiesseotecadectsbecacedsiecnctebedscecodecsestseveeececnineeseteencees 7 1 GM WOU COM aes Geil a adder staked ee eee let ie dane 7 1 7 2
125. entage Adjustment Transaction No Phase In To Be Cancelled Surrender Money Payable Transaction Type Description Txn Type Desc Remarks Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Value Date FX Deal Date Input By Date Time Authorized By Date time Modification Number uate Unauthorized v You will need to enter the following information in this tab Transaction Currency Mandatory If redemption is done in a currency other than the policy base currency then you are required to specify the transaction currency If you do not then the system will default the base currency of the corresponding policy or plan from the Policy details record as the transaction currency Transaction Entry Date dd MM yyyy Date Format Mandatory The Transaction Entry Date signifies the date on which the transaction is entered into the system By default the application date is displayed in this field and it cannot be altered Currency Name Display The system displays the name of the currency oe ORACLE Policy Transaction Date dd MM yyyy Date Format Mandatory Specify the date for the transaction You can enter a backdated transaction here if backdated transactions are allowed in the corresponding product If backdated transactions are not allowed then this date must not be earlier than the application date The transaction date must be earlier than the End Date of t
126. eque Date DD MM YYYY Date Format Mandatory Enter the cheque date of the cheque draft number of the demand draft by which the payment is being made Clearing Date DD MM YYYY Date Format Optional Specify the Clearing Date of the payment When you specify that the Mode of Payment is Money Transfer and the Payment Type is Self you will have to specify the following The following bank account details will be displayed e Bank e Branch e Account Number e Account Type e Account Currency e Account Holder Name When you specify that the Mode of Payment is Money Transfer and the Payment Type is Beneficiary you will have to specify the following Product Beneficiary ID Mandatory Select the beneficiary from the option list The list contains all the beneficiaries maintained for the policy holder Mandatory Select the bank account of the beneficiary The following bank account details will be displayed e Bank e Branch e Account Number e Account Type e Account Currency e Account Holder Name When you specify that the Mode of Payment is Money Transfer and the Payment Type is Product you will have to specify the following e Enter the Product ID in the Product Beneficiary ID e Select P in the Surrender Money Payable field in the Transaction Details tab Mandatory Select the bank account of the product The list contains all the bank accounts maintained for the chosen product Th
127. ere Typically at the time of Policy creation the newly created Policy does not have a Cession ID or Cession Status and this field is blank and locked Subsequently whenever this Policy record is viewed any changes to Cession Status will be displayed in this field Funding Frequency Display The frequency at which the funded amount will be repaid to the investor which would have been set up at the time of Product definition is displayed here It cannot be changed at this stage Description_ Funding Frequency Display The system displays the description of the specified funding frequency Policy Creation Type Optional Select the Policy Creation Type from the drop down list oe ORACLE Description_ Policy Creation Type Display The system displays the description of the specified Policy Creation Type Preferred Fund for Redemption You can select or amend the redemption fund during the creation or amendment of the policy If you maintain adequate balance to recover periodic fees in Preferred Fund for Redemption system will redeem entire periodic fees from the preferred fund If you do not maintain adequate balance Preferred Fund for Redemption system will follow the present logic to recover the periodic fees Note For a CMA applicable Product system would treat CMA Fund as preferred fund for peri odic fee redemptions provided no preferred fund is selected at Product level Refer the section C
128. es for all brokers when summed up must not exceed or fall below one hundred percent 3 2 2 5 Specifying Beneficiary Details In this section you must specify the details of one or more beneficiaries if any for the Policy Holder A beneficiary could be an existing Unit Holder in the system or could be an external entity When you click Beneficiary Details link the following screen is invoked Policy Maintenance Detail i New 433 Enter Query UnitHolder Info Unit Holder Name Unit Holder ID CIF Number Si Load Override Default Load Details Policy Information Policy Details Additional Details Intermediary Details EEREENEE Constituent Details Load Override Details Beneficiary Details Existing UH x Ratio Beneficiary ID Date Of Birth Relationship Type Primary Description Beneficiary For Ownership Personal Details First Name Identification ID Middle Name Identification Type LastName Address Details Address Phone Number City Fax Number Zip Code E Mail ID State or Country Account Details Branch Name Bank Account Type Branch Account Number Bank Name Account Currency IBAN Payment Details Asset Allocation Premium Details Annuity Details Recurring Switch Details Initial Load Override Premium Load Override Annuity Load Override Recurring Switch Load Details Add Info Input by DateTime Mod No Authorized by Open DateTime
129. ession Mainte nance screen the system will allow the policies under this product for Policy Cession Maintenance Cessionary Details Section In the Cessionary Details section you will have to enter information in the following fields Cessionary Name Optional Specify the name of the cessionary policy holder ceding the policy Cessionary Ref Number 16 Characters Alphanumeric Optional Specify a unique reference number that will be used to identify the transaction in the system Contact Person 40 Character Maximum Alphanumeric Optional For corporate investors enter the name of the contact person at the cessionary office Address Lines 1 2 Each line is 255 Character Maximum Alphanumeric Specify the postal address that is to be used for correspondence with the cessionary City 40 Character Maximum Alphanumeric Optional Specify the name of the city of residence of the cessionary State Country 60 Character Maximum Alphanumeric Optional Specify the state country in which the city of residence of the investor is cessionary sa ORACLE 9 2 3 9 3 9 3 1 Zip Code 10 Characters Maximum Alphanumeric Optional Specify the zip code of the specified city of residence of the cessionary Phone Number 15 Character Maximum Alphanumeric Optional Enter the contact telephone numbers of the cessionary Fax Number 15 Character Maximum Alphanumeric Optional Enter the fax number of the cessionary E Ma
130. etneeeeenenae 9 15 5 2 11 Saving Information Entered cece eee eeeeneeeeeseeeeneeeeseeeaaaeeeteeenaaees 5 16 5 2 12 Processing Back Data Propagation for Transactions ccc1eeeee 5 16 5 3 Policy Transaction Switch Summary Screen ecececccceeeeeeeeeseeeeeeeeeeeeeeeeeeeeeeeaaees 5 17 5 3 1 Retrieving Transaction Switch in Policy Transaction SWEN SCOOT ea re EAEE O lei eee 5 17 9 3 2 Editing Transaction SWItCH aeree erar a ETEA AEE EET ARETA 5 18 9 3 3 Viewing Transaction SwWHIGh sererai nE E SA Ea 5 18 5 3 4 Deleting Transaction Switch eessrsneerrrenrsrrrrnnrerrnnnrnnrnnnnrennnnnrrnnanneeena 5 19 5 3 5 Authorizing Policy SWItCH osei srairenkieeriii aiiiar AEE E ATEN iaa 5 19 5 3 6 Amending Transaction Switch sssessissessiisseeerrnnreernnnnnenrnnnnenrnnnnneennnnt 5 19 5 3 7 Authorizing Amended Transaction Switch sseeeeeeesseeeenseeeeenneeeenrnneens 5 20 5 3 8 Reversing Transaction Switch s eeesssereserrreerrrrnnnnrerrnnurrnnnnnererrennrrnnnna 5 20 Policy Transactions Surrender ccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeenneeeneees 6 1 Gite SINtrOGUCTION 222 sun eea age ee et eg eee 6 1 6 2 Surender TraAnSACtiONS eei ane eaae EEA REEE E EEA 6 1 6 2 1 Entering Surrender Transaction eersreesesrrrnnerrrnnrrrrrnnnnrennnnnrnrnnnnenennne 6 1 6 2 2 Invoking Stoen nnaseiaeri iiiaae AiE a Ee iA AEE RE EREE EAEE ASEA E 6 2 6 2 3 Fields in Policy Transaction Surr
131. example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Unit Holder Deal You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The UNITHOLDERDEAL Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Unitholder Deal Detail screen is closed and the changes made are reflected in the Unitholder Deal Sum
132. ffective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions ORACLE 9 2 9 2 1 9 Policy Cession Maintenance Introduction Whenever a policy is marked with a Cession ID the parameters that characterize the Cession ID will affect the subsequent events in the policy such as generation of transfer transactions allowing of redemption transactions and policy closure or policy surrender Note Cession IDs can be attached to policies through the Fund Manager component only The Policy Cession Maintenance screen allows you to attach a Cession ID to a policy The next section gives you step by step instructions to do the same Attaching Cession ID to Policy The following are the steps you need to follow to define a Product Each of these steps is explained in detail in subsequent sections e Invoke the Policy Cession Maintenance screen e Enter information in the Policy Cession Maintenance screen e Save the information entered Invoking Screen You can invoke the Policy Cession Maintenance Detail screen by typing LEDPLCES in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is invoked Policy Cession Maintenance Detail New 5 Enter Query Policy Cession Maint
133. from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Interest Rate Maintenance Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Interest Rate An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Interest Rate Maintenance Summary screen 1 Invoke the Interest Rate Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Interest Rate Maintenance Detail screen is
134. h eth mel eee a ee ea 12 1 12 1 1 Entering Allocation Detalls 0 cccccccccceceeesseeeteeneeeeeeseeeeeeeetesaeeeeeeneeaneees 12 1 4254 2 INVOKING SCrOCM sc cs3s A EAEE ae eee ees 12 1 12 1 3 Fields in Allocation Details Screen ccccccceccececcccececceseseeeeeaeseseseseeneneneees 12 1 ANNEX TE iaieiiea iian assess ache toes a setae aavedel coda paana aces i aia da Sapa Apap aiuda 13 1 1321 Introduction s Aoi as eA es EA AAA a 13 1 13 2 Fund Distribution Processing cccceccecceeeeeeceeeeeeeccneeeeeeeacaeeeeeeeseeeeseneneeeeenenaes 13 1 Function ID Glossary cusiiccice Sole ite os Reece eeects otsien dada aaaea 14 1 1 1 1 2 1 3 1 4 1 About This Manual Introduction Welcome to Oracle FLEXCUBE Investor Services a comprehensive mutual funds automation software from Oracle Financial Services Software Ltd This Oracle FLEXCUBE Investor Services User Manual helps you use the system to achieve optimum automation of all your mutual fund investor services processes It contains guidelines for specific tasks descriptions of various features and processes in the system and general information Related Documents The User Manual is organized in to various parts each discussing a component of the Oracle FLEXCUBE Investor Services system Audience This Fund Manager User Manual is intended for the Fund Administrator users and system operators in the AMC Organization This volume of the Fun
135. h which the payment is made to the Policy Holder or Product The following are the options available e Cash e Cheque e Money Transfer e Demand Draft 6 12 ORACLE Note Though the above mentioned options are available for a Surrender Transaction the ac ceptable Mode of Payment is Money Transfer The system will not allow you to save a Surrender Transaction with any Mode of Payment other than Money Transfer Clearing Date DD MM YYYY Date Format Mandatory Specify the Clearing Date of the payment Beneficiary Details Payment Type Mandatory Specify the type of payment Following are the options available e Self e Beneficiary e Product e Third Party Note The payment types Beneficiary Third Party and Product are applicable only if the payment mode is chosen as Money Transfer The payment type must be set to Product if the type of transaction is Balance trans fer out Check Number Mandatory Enter the cheque number of the cheque draft number of the demand draft by which the payment is being made Ratio Numeric Specify the ratio of payment to be made in the specified payment mode If the Mode of Payment is specified as Cheque or as Demand Draft you will have to specify the following Bank Mandatory Select the Drawee Bank from the option list Branch Code Mandatory Select the Branch code from the option list ate ORACLE Ch
136. hat is displayed here If you select Yes however you need to specify the exchange rate to be used for the transaction in the Exchange Rate Applied field Select No if you wish to retain the exchange rate that is displayed by the system Exchange Rate Applied Numeric Optional The system will default the exchange rate available for the currency based on the exchange source specified If you have elected to override the exchange rate you need to enter the exchange rate to be used here If exchange rate is not available then the system will generate the transactions as incomplete ones Such transactions can be enriched later through the Policy Transaction Enrichment Screen FX Deal Date Date format Optional The system will default the start date of the policy here You can change it if required FX Value Date The system will default the start date of the policy here You can change it if required Units Specify the units ol ORACLE Ratio Specify the ratio WAC Enter the Weighted Average Cost You can click delete icon to delete any specified fund Switch Asset Allocation Details Section You can capture the funds INTO which the investment amount is being moved in the Switch Asset Allocation Details Section To Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Select funds INTO which you are moving the investment amount Fund Name Specify the
137. he Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Policy Journal Entry An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Journal Maintenance Summary screen 1 Invoke the Policy Journal Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Journal Maintenance Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record Amending Policy Journal Entry After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is
138. he Application tool bar and clicking on the adjoining arrow button The following screen is invoked Allocation Details D New 5 Enter Query Product ID Transaction Amount Policy Number Date of Allocation Transaction Type Gross Amount Policy Txn Number Switch In Gross Amount Allotted No Net Investible Amount Faich Allocation Derails Fund Transactions Allocation Details Fee Details Fund Transactions 1of1 C Transaction Number FundID ToFundiD Amount Date ofAllocation Gross Amtin FBC NetAmtin FBC Sel A Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Allocation Details Fields in Allocation Details Screen Product ID Mandatory Select the product ID from the option list 121 ORACLE Policy Number Mandatory Select the Policy Number from the option list TXNTYPE Mandatory Select the transaction type from the option list Policy Txn Number Mandatory Select the policy transaction number from the option list Alloted Mandatory If you want to allot allocation select Yes Else No Transaction Amount Optional This is amount applied for the transaction Gross Amount Optional Gross Amount is the amount inclusive of all fees Date of Allocation Optional Enter the date of allocation Net Investible Amount Optional Net Investible amount is the Gross amount of fees Switch In Gross Amount Op
139. he Policy and must not be a holiday The transaction date cannot be earlier than the first Rule Effective Date of the policy Transaction Amount Numeric Mandatory if the Transaction Mode is Amount Specify the portion of the transaction amount that is to be redeemed in each of the selected funds The sum of these amounts must not be greater than the total transaction amount specified in the transaction details tab for this transaction Typically this field is only applicable for transactions for which the mode is Amount Policy Base Currency Display When the Policy is selected the corresponding Plan or Policy Base Currency is displayed here from the policy details record This currency cannot be changed at this stage Transaction Mode Mandatory Select the mode in which the transaction must be put through from the drop down list Transactions can be put through either by amount or percentage of holdings Portfolio Surrender Optional You can select Yes to indicate the surrender is a complete or partial surrender transaction within the funds in which the investor as invested Percentage 5 Characters Maximum Numeric Mandatory if Transaction Mode is Percentage of Holdings If the specified Transaction Mode is Percentage of Holdings then specify the percentage of the Policy Holder s holdings that is to be reckoned as the transaction amount for this transaction When you specify this percentag
140. he annuity payment check the box Override Anniversary Date This field is enabled only if the Override Anniversary Date option has been checked Product Level Defaulting Section Statement Frequency Mandatory Specify the frequency at which the Policy statement must be mailed to the Policy Holder for this Policy Note This frequency overrides the frequency specified for the Product Description_ statement frequency Display The system displays the description of the specified statement frequency Policy Base Currency Mandatory Specify the base currency to be associated with the policy or select the policy base currency from the option list provided All currencies maintained in the system get displayed in the option list While saving the record the system validates whether the selected currency is supported by product and saves the record on successful validation Description_ policy base currency Display The system displays the description of the specified policy base currency Life Cover Applicable Optional This field indicates whether or not the Policy Holder has an option to opt for a life cover while subscribing to this product The option you have selected for the product will be displayed here You can change the same for the Policy oi ORACLE Life Cover Amount Display This is the amount to be paid by the Policy Holder as a fee for obtaining the life cover for any Policy held by h
141. he maximum additional investment amount that a Policy Holder should make if the option Additional Investments Allowed has been selected for the Policy Holder The amount in displayed in this field is the amount entered for the Product You may change the same for the Policy Add Investment Step Amount Numeric Optional This field indicates the step amount for an additional investment The amount in displayed in this field is the amount entered for the product You may change the same for the Policy Minimum Annual Withdrawal Numeric Optional If the withdrawals are allowed at the Product level then the minimum amount that customer needs to withdraw annually can be specified here while creating a Policy This will override the amount set at the Product level The amount set at the product level will be shown here after user selects the Product Participating Employer Optional You may specify the underlying policyholders employer The option list displays all participating employers linked to the chosen product Auto Clear Provisional Balance This field indicates whether 100 outflow transactions include provisionally allotted units The option specified for the product in the Product Maintenance screen will be defaulted However you can change the defaulted option You can specify any of the following options e Option not allowed Provisionally allotted units should not be considered while processing 100 outflow transac
142. he selected funds The sum of all such percentages must add up to 100 and not fall below or exceed it The percentages specified here must not be fractional Typically this field is only applicable for transactions for which the Transaction Mode is Percentage If there are many currencies specified as part of settlements then the system will not allow you to enter a ratio Instead you need to enter the transaction currency and transaction amount for each currency The system will compute and display the ratio based on the currency and amount details provided To calculate the ratio the transaction amounts will be converted to policy transaction currency based on the exchange rate defined in settlements If the settlements are maintained in only one currency then you can enter either the ratio or the transaction amount Note If you have specified the investment amounts in each fund the investment ratios are com puted and displayed here and this field is locked Auto Clear Provisional Balance Mandatory For a complete surrender transaction you can use this field to indicate that the outflow transaction should include units in provisional balance If the policy transaction already has an underlying UT transaction with this option checked then system throws up a warning and tracks the provisionally allotted transactions for auto clearing Auto Clear Reinvestments Mandatory Use this field to indicate that for a complete
143. icable If you have selected Yes the SI Status codes PAUSED and STOPPED are not applicable Ifyou have selected Yes the system will allow you to move the fund amount of one fund to into another or from one fund to more than one fund However movement from multiple funds to one fund or from multiple funds to multiple funds is not permitted If you have selected Yes you will not be allowed to enter more than one From fund in the Recurring Switch Asset Allocation Details screen which is invoked by clicking the Asset Allocation link During amendment of a Policy you will not be allowed to change the preference you have specified for a phase in For example If you have selected Yes in Phase In you will not be allowed to uncheck it and vice versa Type Mandatory Select the type of switch applicable No Of Annuity Occurrences Numeric Enter the number of annuity occurrences This is applicable only for accelerated annuity policies oe ORACLE Escalation Start Date DD MM YYYY Date Format Optional Specify the date from which escalation of the recurring switch will commence This date must be earlier than the End Date of the recurring switch and must be later than the Start Date of the recurring switch Escalation End Date DD MM YYYY Date Format Optional Specify the date from which the escalation must cease to be applied on the recurring switch This date mus
144. icyNumber Policy Reference Number Policy Stat Date Maturity Date Policy Enc 4 n Retrieving Policy in Policy Maintenance Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Policy Maintenance Summary screen 1 Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved 2 Select the status of the record in the open field If you choose the Blank Space option then all the records are retrieved e Policy Number e Policy Reference Number e Policy Start Date e Maturity Date e Policy End Date e Latest Rule After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 cal ORACLE 3 3 2 3 3 3 Input the Product Number Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Product Number by using the combination of and alphanumeric value as follows Search by A System will fetch all the r
145. ier than the first Rule Effective Date of the policy Portfolio Switch Optional Select Yes to indicate the switch is a complete or partial switch transaction within the funds in which the investor as invested Portfolio switch is applicable to both transaction put through by amount or by percentage of holdings Transaction Mode Mandatory Select the mode in which the transaction must be put through from the drop down list Transactions can be put through either by amount percentage and units of holdings If you select the option Units then the system defaults the following fields e Transaction Amount and Percentage of holdings field will be disabled and default amount will be zero Transaction Entry Date dd MM yyyy Date Format Mandatory The Transaction Entry Date signifies the date on which the transaction is entered into the system By default the application date is displayed in this field and it cannot be altered op ORACLE Transaction Amount Numeric Mandatory if the Transaction Mode is Amount Specify the investment amount of the transaction On saving amount based policy switch transactions the system will compute the market value of policy across all funds If the transaction amount is greater than the threshold limit of policy market value the system will display the following error message Transaction amount exceeds threshold limit of the policy market value Please use transaction mode
146. il ID 30 Characters Maximum Alphanumeric Optional Specify the Email address of the cessionary Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button Policy Cession Summary Screen You can invoke the Policy Cession Summary screen by typing LESPLCES in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Cession Summary Authorized X Open Policy Number a Cession ID Cession Date E Advanced Search Reset Records per page 15 v 1 of 4 Authorized Open Policy Number Policy Holder ID Transferee ID Cession ID Cession Date a Retrieving Policy Cession in Policy Cession Screen You can retrieve a previously entered record in the Summary screen as follows a ORACLE Specify any or all of the following details in Policy Cession Summary screen e Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved e Select the status of the record in the Open field If you choose the Blank Space option then all the records are retrieved e Product ID e Effective Date After you have spe
147. im in this product The amount you have specified for the product will be displayed Proof of Existence Certificate Display This field indicates whether or not the Policy Holder will need to produce a certificate of existence This option specified at for the product in the Product Maintenance screen will be defaulted You will not be allowed to change this Guarantee Period Optional Specify the guarantee period Take on Annuity Amount Enter the take on annuity amount here The annuity details will be calculated by the system based on the amount you enter here and not the annuity percentage till the first anniversary The annuity details will be taken into consideration after the first anniversary Number of Surrenders Allowed System will default the value from Product User can override it Retirement Age Mandatory and Enabled only if Maturity Date Basis for Product is Retirement Age Specify the age that will be considered as retirement age for Policy Holders under this product After this age the Policy Holders will become eligible for retirement benefits if any Note This field will be enabled only if for the Product in the Product Maintenance screen You have selected the option Yes against the field Retirement Features Supported You have selected the option Retirement Age against the field Maturity Date Ba sis Life Expectancy Optional User can enter life expectancy
148. in the Policy Maintenance Details screen Premium Details 1of1 E Load ID Group Id Change Type Change Value Txn Type Ref Type Sequ A Select one 1of1 Load ID ParentLoadID Change Type Change Value Txn Type Ref Type Select One Load ID Display Only The ID of the load that has been mapped to the fund is displayed here The load ID is displayed as a link To view details of the load click the ID link If a derived load has been mapped it is also displayed here and can be overridden Group ID Display Mandatory Displays the group ID Change Type Optional When you override or alter a load at the time of entering a transaction you can effect the change in any of the following ways e Discount reducing the load return value in all the slabs e Increase increasing the load return value in all slabs e Return Value assigning an altered return value that will be applicable to all the loads Change Value Numeric Optional Specify the altered return value for the allocation time load that you are overriding one ORACLE Txn Type Display Mandatory This displays the transaction type Ref Type Display Mandatory This displays the reference type 3 2 2 15 Annuity Load Override Section You can override or alter the value of load applied on annuity amount towards the Policy mapped to the selected fund You can do so in the Load Override Details screen which is invoked
149. in the name of the beneficiary The initial amount of the new policy will be the maturity amount of the old one and the entire maturity proceed will be paid out over number of occurrences and frequency maintained in the annuity tab 39 ORACLE Description Display The system displays the description of the selected policy type Dates Defaulting Section Next Anniversary Date DD MM YYYY Date Format Mandatory if the box Override Anniversary Date is checked Enter the Anniversary Date for the annuity payment This field is enabled only if the Override Anniversary Date option has been checked Previous Anniversary Value Numeric Mandatory if the box Override Anniversary Date is checked Enter the preceding anniversary amount Note Post authorization you will be allowed to amend the Anniversary Value and the Previous Anniversary Value fields provided the Override Anniversary Date option has been checked Override Anniversary Details Optional When you enter the Start Date of the Policy in the Policy Details section of this screen the system defaults the Anniversary Date to a date that is exactly one year after the Start Date Policy Administrator Display The plan administrator you have specified for the product will be displayed You will not be allowed to change this Policy Amount Numeric Optional Specify an indicative amount for which the Policy is taken in the prod
150. ini AER EREA E RAER EEVEE ERA 3 53 3 6 2 Fields in Policy Maintenance Screen eessseeesessnrreerrrrerrrrnnnneerrrnnerrenns 3 53 3 7 Interest Rate Maintenance Summary SCreen cccceeeeeeeeeeeeeeeeeeeeeenneeeeeeeenaees 3 54 3 7 1 Retrieving Interest Rate in Interest Rate Maintenance Screen 3 54 3 7 2 Editing Interest Ratos nareniseri nni eeri A a Ei 3 55 3 7 3 Viewing Interest Rate a se seerrrrserrrnnnrrrinnrerrrrnnerranannrrirnnnrnnnnnnnenrnnanenena 3 55 3 7 4 Deleting Interest Rate nsessrrresrrrsnnnrrnnnnnnrrinanrernnnnrnnnnnnerennnnnnnnannnenna 3 56 3 7 5 Authorizing Interest Rate sssseerssrrenerrrrnrnererrnnnrrrrnnnrrrrranrrennnnneerrrnnrena 3 56 3 7 6 Amending Interest Rate eesssrsrrserrrrrerrrnrrrrerrrnnrrrrnnnnnnrrnnarrrianrennrrnnrrrna 3 56 3 7 7 Authorizing Amended Interest Rate cccccccceceeeeteeeeeeeeeteeeeeeeeeneeanens 3 57 3 7 8 Checking for Duplicate TranS ctiONnS 1 cccccccccceceeeeneeteceeeeseeeeeetteeseens 3 57 4 Policy Transactions Top UP c ccccceeeeeeeeeeeeeeeeeeeeeeeneeeeeeeeeeeeeeeeeeeees 4 1 A WMMOMUCHOM es a tea sivele td hed adie lad het tena oeead baa ssetetaaas A 4 1 42 Top Up Transactions noiet a ar i a ee a a 4 1 4 2 1 Entering Top up Transaction cccccccceecceccecceeeeeeeeetessenneaaeeneeseeeeeetteetnens 4 1 422 INVOKING SCKOGN sefivcss cose cds aaea aSa EEA ecandandc vers otdiedh Eer AEE EAN
151. investment will be reinvested with the Policy Transaction Type 80 This is shown in the screen given below FCIS Subscription Transaction Detail New 9 Enter Query Transaction Information Transaction Currency Transaction Value Fund ID Reference Number Transaction Mode Amount Unit Holder ID Units Applied Transaction Date eae Amount Applied Transaction Number Description Percent Applied Payment Mode Select One Enrich Transaction RRR Transaction other Intermediary Load Override KYC amp Document Add Info Fee Payment Certificate Limit Order CIF Number ISIN No Fund Name Unit Holder Name Fund Base Currency UH Sianature Settlement Details Receipt Details Project Allocation Details Allocation Details Input By DateTime Mod No Authorized By DateTime Authorized The dividend due for a UT investment will be reinvested with the Reference Type RE and Reference Number REINV This is shown in the screen given below FCIS Subscription Transaction Detail New 3 Enter Query Transaction Information Transaction Currency Transaction Value Fund ID Reference Number Transaction Mode Amount Unit Holder ID Units Applied Transaction Date TSOR ins Amount Applied Transaction Number _ Description Percent Applied PaymentMode SeletOne Enrich Transaction H Transaction Other intermediary Load Override KYC amp Document Add info Fee Payment Certificate Limit Order CIF Number ISIN
152. ion Switch screen e Save the information entered 5 2 2 Invoking Screen You can invoke the Policy Transaction Switch Detail screen by typing LEDPLSWI in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button a ORACLE 5 2 3 5 2 3 1 The following screen is invoked Policy Transaction Switch Detail New 7 Enter Query Policy Transaction Transaction Reference Number Policy Number Policy Start Date Product Name Product ID Name Policy Holder ID Policy Maturity Date EERE 4s set Allocation Broker Details Load Override Details Transaction Details Policy Txn Number Transaction Currency Transaction Date Currency Name Transaction Entry Date Transaction Amount Policy Base Currency Transaction Mode Amount PortFolio Switch No Percentage Holding Remarks Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Value Date FX Deal Date Calculate Input By Date Time Modification Number Authorized By Date time Anani Unauthorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Transaction Switch Fields in Policy Transaction Switch Screen Policy Transaction section In the Policy Transaction section you will have to enter information in the following fields Policy Transaction Number Syste
153. is Exclusive Annuity Amount gt Minimum Annuity Percentage Latest Anniversary Value All Inclusive Net contributions made during the year Current Exclusive net top up Annuity Amount lt Maximum Annuity Percentage Latest Anniversary Value All Inclusive net contributions made during the year Current Exclusive net top up 114 ORACLE 11 3 7 11 3 8 LEP 120 Rule Support This is an EOD activity which checks all the policies that come under Endowment Products and have a Top Up Premium Transaction or a Premium Escalation on the particular day This process is carried out for each policy The 120 Rule triggers on the following events e Top Up Transactions e Premium Premium Escalation Due Date If the date happens to be less than the Policy Anniversary Date the projected premiums for the rest of the policy year will be considered for the 120 Rule validation The system will sum up all the contributions Initial Investment if any Top Ups if any Premiums both paid and projected in the current policy year Say for example the contribution amount sums up to X Rands This process will sum up the contributions Initial Investment if any Top Ups if any Premiums paid in the two policy years Note A policy year is a year between two Policy Anniversary Dates Let us say the contribution amount sums up to Y Rands in the first policy year and Z
154. isplayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 a ORACLE 5 2 5 5 2 6 Input Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Reference Number by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product ID starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Unit Holder Deal You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose
155. ist of displayed records in the lower portion of the screen The Unitholder Deal screen is opened in View mode a0 ORACLE 5 2 7 5 2 8 5 2 9 Deleting Unit Holder Deal You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Unitholder Deal Summary screen as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Unitholder Deal Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Unit Holder Deal An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Unitholder Deal Summary screen 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for authorization
156. ition level is displayed here You can override this value at this stage This must be expressed as a percentage and cannot exceed one hundred percent an ORACLE Phase In To Be Cancelled Optional You could choose to cancel all none or specific Ids of the active Phaseln setup Balance Transfer System allows you to specify the Units in Asset allocation details Interest Amount Display Can Be Changed The system computes the interest amount based on the interest calculation days and interest rate provided by you in the Interest Calculation Screen explained below You will be able to change the amount displayed if you wish to Exchange Rate Details The policy transaction currency can be different from the base currency of the policy In this section you can maintain the details related to the exchange rate to be used for currency conversion Source ID Mandatory Specify the source from which the exchange rate is obtained or select the source ID from the option list provided Exchange Rate Applied The exchange rate corresponding to the combination of policy base currency and policy transaction currency gets displayed here The exchange rate for a top up transaction will be between the transaction currency and policy base currency Amount Applied The amount calculated based on the exchange rate specified gets displayed here after the calculation Override Exchange Rate Select the option to indicate if you wish t
157. itself which is displayed here by default It cannot be changed Policy Holder ID Display The name and ID of the Policy Holder whose Policy is to be marked with a Cession ID is displayed here Product ID Mandatory Explanation needed from Dev Testing team Cession Type Mandatory Select the Cession Type that is to be applied to the specified Policy from the drop down list Note If the type chosen here is Temporary then only the Cession ID must be captured with remarks If it is Permanent then the Transferee ID must also be captured Cession ID Mandatory Select the Cession ID that is to be applied to the specified policy from the option list v2 ORACLE 9 2 2 2 Note The list will contain permanent cessions if the Cession Type specified is Permanent and temporary cessions if the Cession Type chosen is Temporary Transferee ID Mandatory if the Cession Type is Permanent Select from the option list the ID of the Policy Holder to whom the policy must be transferred when it is marked with the specified Cession ID This must be a valid Unit Holder in the system and must not have a Policy in the same Product Cession Remarks 255 Characters Maximum Alphanumeric Optional You can capture any descriptive narrative text pertaining to this Policy Cession record in this field Note If the Cession Applicable field at the Product Level is checked in the C
158. izard Detail Save Policy Financial Wizard Policy Number H Options Market Ratio Product ID Contribution Amount Policy Base Currency Compounded Contribution Product Base Currency Portfolio Amount Policy Holder ID All Policy Holder Name Details 1of1 Options NetAmount Amount In Product Currency Details 1of1 FundiD Units NAV NetAmount SplitPercentage Policy Number The Policy Financial Wizard enables a Policy Holder to know at a glance the value of his policy and the details of his holdings in the funds The product Id product base currency and the policy base currency also are displayed based on the Policy Holder ID specified Options Section The details of the holdings that can be viewed are given below e Market Ratio e Contribution Amount e Compounded Contribution e Portfolio Amount e All of the above Select one of the options the option All of the above allows you to view all details together and click View Information button The position of the Policy Holder s investment and the holding value in product base currency are thus available at a glance and will aid him when transaction amounts are specified os ORACLE 6 2 3 3 PH Deal Click Ph Deal button to view the details of all the deals set up for the unit holder The following screen is displayed Unitholder Deal Summary Authorized i Open i
159. ization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Policy Journal Maintenance screen is opened in View mode Deleting Policy Journal Entry You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Journal Maintenance Summary screen as follows 10 6 ORACLE 10 3 5 10 3 6 10 3 7 1 Invoke the Policy Journal Maintenance Summary screen from the browser 2 Select the status of the record as Unauthorized that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Journal Maintenance Detail screen is opened in View mode 5 Select Delete operation from t
160. l Date Input By Date Time Authorized By Date time Modification Number mies Unauthorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Transaction Surrender Fields in Policy Transaction Surrender Screen Policy Transaction Section In the Policy Transaction section you will have to enter information in the following fields Policy Txn Number System Generated Number This is a unique identification for the policy transaction that is effected in this Policy It is generated by the system when all details that are mandatory for the transaction profile have been successfully entered and the transaction record is saved G2 ORACLE Reference Number 16 Characters Maximum Alphanumeric Optional Specify a unique identification for this policy transaction that will be used in all subsequent references to this transaction before it is authorized Policy Number Mandatory Select the policy on which this transaction is to be effected You can use the Find Policy Options screen The policy selected must be an authorized active policy on which the underlying initial investment transaction has already been generated If a policy has been surrendered by mistake the system will allow you to re activate it On re activation the system will reverse the redemption transactions generated during policy surrender and change the status of the policy from
161. lation End Date can be amended only it is greater than the System Date Escalation Start Date and Escalation Frequency can be amended only if escalation has not been applied on the policy Start Date DD MM YYYY Date Format Mandatory Enter the date on which the switch transactions should begin End Date DD MM YYYY Date Format Mandatory Enter the date on which the switch transactions should stop oat ORACLE Value Numerical Mandatory if the box Portfolio Switch or Phase In is not checked Enter the value of the switch transaction Frequency Mandatory Select the frequency with which the switch transactions should occur Transaction Currency Specify the code of the transaction currency The adjoining option list displays all valid currency codes along with their description You can choose the appropriate one Portfolio Switch Optional Select Yes to indicate the switch will be a portfolio switch In such a case the field Transaction Value will be defaulted to 0 and locked A portfolio switch can be a complete or partial switch Phase In Optional If you select Yes the system will allow you to move the fund amount of one fund to into another and you will be able to enter the Start Date Number of Occurrences and Frequency in this screen The system will calculate the SI value based on these parameters Note Ifyou have selected Yes Escalation Details will not be appl
162. le Effective Date of the policy Top Up Inclusive Mandatory If the transaction is a top up transaction check this box to indicate that it must be an inclusive top up transaction When a top up is inclusive the top up amount is considered immediately for the next annuity payment If it is an exclusive top up the top up amount is not considered for annuity payments till after the first anniversary date Transaction Mode Mandatory The mode in this case Amount in which the transaction must be put through will be displayed a0 ORACLE Transaction Entry Date dd MM yyyy Date Format Mandatory The Transaction Entry Date signifies the date on which the transaction is entered into the system By default the application date is displayed in this field and it cannot be altered Transaction Amount Numeric Mandatory Specify the investment amount of the transaction Transaction Currency Mandatory When different currencies have been used in payment details then you are required to enter the transaction currency If you do not then the system will default the corresponding Plan or Policy base currency from the Policy details record as the default transaction currency If all the transaction currencies used in payment details are the same then the system will default the same currency You can change it to a transaction currency of your choice Policy Base Currency Display When the Policy is selected the corres
163. m Generated Number This is a unique identification for the policy transaction that is effected in this policy It is generated by the system when all details that are mandatory for the transaction profile have been successfully entered and the transaction record is saved Transaction Reference Number 16 Characters Maximum Alphanumeric Optional Specify a unique identification for this policy transaction that will be used in all subsequent references to this transaction before it is authorized Policy Number Mandatory Select the policy on which this transaction is to be effected from the option list The policy selected must be an authorized active policy on which the underlying initial investment transaction has already been generated Policy Start Date dd MM yyyy Display When you select the Policy Number the start date of the selected Policy is displayed here a ORACLE Product ID Display When the Policy is specified the ID of the Product under which the corresponding Policy has been created is displayed in this field Product Name Display When the Policy is specified the name of the Product under which the corresponding Policy has been created is displayed in this field Policy Holder ID Display When you specify the Policy Number the ID of the Policy Holder is displayed here Policy Holder Name Display When the Policy Number is selected the name of the corresponding Policy Holder is displayed here P
164. m populates the return value from the load setup If there are criteria based loads the criteria is evaluated during UT transaction generation and it will be used during allocation Asset Allocation Details The initial contribution towards the Policy can be directed into any number of mapped funds for the product and annuity is paid out to the Policy Holder from any of these funds The ratio of contributions received into the Policy to the annuity payouts for each of the mapped funds of the product as specified at the time of Policy creation are displayed here The initial contribution that you enter can be in different currencies In this case you need to mention the currency wise details here Note The asset allocation details that you specify here will be applicable to only the initial con tribution towards the policy and not the annuity and premium payments When you click Asset Allocation button the following screen is invoked Asset Allocation Asset Allocation 1of1 Fund ID Fund Name Fund Base Currency Transaction Currency Transaction Amount Excl Enter information in the following fields Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Against each of these funds you can specify the investment ratio and the annuity ratio See ORACLE Transaction Currency Alphanumeric Optional Specify the transaction currency for the initial co
165. mary screen ga ORACLE 4 2 6 4 2 7 4 2 8 Viewing Unit Holder Deal To view a Unitholder Deal you have previously entered you must retrieve the same in the Unitholder Deal Summary screen as follows 1 Invoke Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the Unitholder Deal that you want to retrieve for viewing in the Authorized field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The UNITHOLDERDEAL screen is opened in View mode Deleting Unit Holder Deal You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Unitholder Deal Summary screen as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details
166. mendment You can only amend records that are authorized ores ORACLE 6 3 7 6 3 8 5 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to amend The Policy Transaction Surrender screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record Amend the necessary information Click the Save button to save your changes Authorizing Amended Surrender Transaction An amended Surrender Transaction must be authorized for the amendment to be made effective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions Reversing Surrender Transaction You can reverse a transaction that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 2 3 6 Invoke the Policy Transaction Surrender Summary screen from the browser Select the status of the record that you want to retrieve for reversal Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displa
167. n 4 Double click the record that you wish to authorize The Policy Transaction TopUp Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record wee ORACLE 4 3 6 4 3 7 4 3 8 Amending TopUp Transaction After a record is authorized it can be modified using the Unlock operation from Action list To make changes to a record after authorization you must invoke the Unlock operation which is termed as Amend Operation 1 Invoke the Policy Transaction Topup Summary screen from the Browser 2 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to amend The Product Type screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Transaction TopUp An amended transaction top up must be authorized for
168. n Transaction Currency Display Only The system computes and displays the interest amount in terms of the transaction currency Interest Calc Days Display Only The system calculates the number of days for which interest calculation has to be done for a policy based on the policy start date and payment date Basis Days Mandatory Numeric Select the interest basis days based on which the interest will be calculated The options available are e 360 days e 365 days When you click the Clear button the interest related details will be cleared 320 ORACLE 3 2 2 10 Premium Details Section In this section enter the details of the premium payment and the frequency at which the premium payments will be made You can enter the details for more than one premium When you click on the Premium Details button the following screen is invoked Premium Details Premium Details Sequence Number Value Policy SI Number Default SI Frequency Status Transaction Currency Start Date Source ID End Date Payment Details Payment Mode SelectOne Account Type Bank Code Account Number Branch Code Account Currency Bank Name IBAN Branch Name Escalation Details Escalation Start Date Escalation Frequency Escalation End Date Description Escalation Mode SelectOne Escalation Value Cheque Details 4 10 Gal Cheque Number Cheque Date Asset Allocation 101 gt bl Gal FundID FundName U
169. nctions The following table gives you the sequence of the Batch Functions the Activity and whether the Activity is an EOD or BOD function Activity EOD BOD LEP Plan Funding Repayment EOD LEP Generate Plan Transactions EOD LEP Update Product Fiscal Year EOD LEP Update Plan Transaction Allotted Status EOD LEP Plan Financial Bucket Adjustment EOD LEP Plan Annuity 5 20 Validation Process EOD LEP 120 Rule Support EOD LEP NAV Correction EOD LEP Set Latest Rule for Product BOD LEP Set Latest Rule for Plan BOD LEP Plan Anniversary Value Computation BOD LEP Plan Annuity Escalations BOD LEP Plan Recurring Switch Escalations BOD LEP Plan Premium Escalations BOD LEP Recurring Plan Annuity Processing BOD LEP Recurring Plan Switch Processing BOD LEP Recurring Plan Premium Processing BOD LEP Plan Funding Repayment BOD LEP Generate Plan Redemption Transactions for Periodic Fees BOD LEP Process Plan Surrender BOD LEP BOD Plan Transaction Generations BOD ORACLE 11 3 11 3 1 11 3 2 11 3 3 11 3 4 Batch Functions The various Batch Functions are explained below LEP Plan Funding Repayment Funding is a feature where a part of the initial investment and subsequent top ups if any is retained by the Life Company and then paid back to the customers in equal installments The customer receives the principal
170. nd displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Maintenance Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Policy An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Maintenance Summary screen 1 Invoke the Policy Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Maintenance Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the tr
171. ndividual The ceding could be either temporary or permanent as the case may be Note Cession Maintenance can be carried out through the Fund Manager component only The Cession Maintenance screen allows you to maintain various Cession IDs These can be attached to the necessary policies The next section gives you step by step instructions to do the same Creating and Saving Cession ID The following are the steps you need to follow to maintain a Cession ID Each of these steps is explained in detail in subsequent sections e Invoke the Cession Maintenance screen e Enter information in the Cession Maintenance screen e Save the information entered Invoking Screen You can invoke the Cession Maintenance Detail screen by typing LEDCMSD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is invoked Cession Maintenance Detail New 753 Enter Query Cession Maint Cession ID Cession Type SelectOne v Cession Description _ Allow Policy Surrender No Generate Policy Transfer No J Transaction Allow Policy Closure No Input by DateTime Authorized by DateTime Mod No Open Authorized 8 1 ORACLE 8 2 2 8 2 2 1 8 2 3 Fields in Cession Maintenance Screen Cession Maintenance Section In the Cession Maintenance section you will have to enter information in the following
172. ne from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions Checking for Duplicate Transactions At the time of saving the transaction details the system checks for the Policy Number Transaction Type combination If there are any existing transactions for the same combination that has been captured in the past n days the system will display you an warning message if you try to save another transaction with the same combination within those n days You need to specify this n number of days which the system has to consider for validation The system performs the duplicate transaction validation e For unauthorized transactions e Ifa parameter code called DUPWARNINGLAG and the value for the n number of days has been maintained The validation fails if the n number of days is specified as zero Maintaining Parameter Code for Displaying Warning Messages You need to maintain the parameter code DUPWARNINGLAG and the number of days as the Parameter Value in the Parameter Setup screen Refer to the chapter Maintaining System Parameters for further details on maintaining the parameters Fa ORACLE 4 Policy Transactions Top Up 4 1 Introduction A Policyholder can initiate any of the following transactions in a Policy that Reone has purchased e Top Ups e Partial or Full Redemption Transa
173. ned an additional information head along with valid values use the Additional Information Maintenance screen in order to be able to enter additional information Add Info screen is invoked when you click on the Add Info button in the Policy Maintenance Details screen Add Info Additional Information Details 1of1 Other Info Field Field Value Other Info Field Enter the information in this field A ORACLE 3 2 3 3 2 4 3 2 5 Field Value Enter the valid value which is defined in the add info maintenance Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the following confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button Creating Future dated Rules for Policies You can create a future dated rule by copying a policy and making changes to the new rule with a Rule Effective Date in the future The rule will become active on the Rule Effective Date On this date the system will mark the new rule as the latest rule and disregard the old rules for the policy The system will allow you to create only one future dated rule for a policy and on a given date only one rule will be active You can amend future dated rule details including the Rule effective Date and also close an existing future dated rule In case you wish to re o
174. nge the premium amount the initial investment amount will not be affected 39 ORACLE Interest Amount Display Can Be Changed The system computes the interest amount based on the interest calculation days and interest rate provided by you in the Interest Calculation Screen explained below Product Defaulting section Funding Factor 5 Characters Numeric Optional The funding factor that is applicable to Policy transactions in this Product which would have been set up at product definition level is displayed here You can override this value at this stage This must be expressed as a percentage and cannot exceed one hundred percent Funding Repayment Period Optional The duration of the repayment period at the end of which the entire funded amount will be paid back to the investor which would have been specified for this product is displayed here You can change the same for the Policy Asset Allocation Mandatory The asset allocation for the Policy can be specified either by the sponsor of the product or by the Policy Holder The drop down list contains two options By Fund and By Policy Holder Select the required option Cession Status Display When Policy Holders exercise the option of ceding their policies on either a temporary or a permanent basis the ceded Policy will be designated a Cession ID and Cession Status in the system The Cession Status for this Policy is displayed h
175. nits Ratio Enter information in the following fields oat ORACLE Premium Details Sequence Number Optional You can enter the sequence number Policy SI Number Display This number is generated by the system It represents the number of premium payments between the Start Date and End Date specified for the premium payment Status Mandatory Select the status of the standing instruction for premium payment from the option list Note If you select the status STOP escalation will not be applied on the premium Transactions will not be generated for Sls on premiums whose status is STOP It is pos sible for you to change the status of such Sls to ACTIVE during amendment of the policy During amendment of a policy you can change the status of an active SI to Paused Stopped or Cancelled During amendment of an SI marked Not Started you can change all details except the status of the SI You will be allowed to delete the SI During amendment of an active SI Escalation End Date can be amended only it is greater than the System Date Escalation Start Date and Escalation Frequency can be amended only if escalation has not been applied on the policy Start Date DD MM YYYY Date Format Mandatory Specify the date beginning from which the first premium payment is to be made for this Policy Subsequent to this payment premium payments will be made acc
176. ntification type Address Details The address details are given below oe ORACLE 3 2 2 7 State or Country City Zip Code and Address Optional Enter the address of the constituent holder including details such as the city zip code and state or country E mail ID Optional Enter the E mail ID of the constituent holder Phone number Optional Enter the phone number of the constituent holder Fax Number Optional Enter the fax number of the constituent holder Account Details The account details are given below Bank Optional Specify the bank code of the constituent s bank You can select the same from the option list if the bank code is a valid code in the system Branch Display The branch of the bank is defaulted for the selected constituent bank Account Currency Account Number Account Type Display The values are defaulted for the selected constituent bank IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the constituent holder Specifying Load Override Details In this section you can override or alter the value of any load including derived loads if any mapped to the selected fund and applicable for the transaction type which is to be computed at the time of allocation The frequency of computation for such loads would be allocation 320 ORACLE Clicking on the Load Override Details link invokes the following screen
177. ntribution If many currencies have been mentioned in the settlements then you are required to enter the amount for individual currencies You can specify a transaction currency only if the transaction is amount based Transaction Amount Numeric Optional Specify the transaction amount for the currency selected If different currencies have been mentioned in settlements then you can specify only the transaction amount The system will default the ratio If all the currencies in settlements are the same then you can specify either the transaction amount or the ratio Note If you have checked the Include Interest in Investment box then the total of settlement and interest amounts for each currency needs to be equal to the asset allocation transaction amount for the currency Ifthe Include Interest in Investment box has not been checked then sum of cur rency wise settlement amount should be equal to the asset allocation transaction amount for the currency Exchange Rate Source Alphanumeric Optional The system will display the exchange source maintained at default set up in system parameters You can change it by selecting the required exchange rate source from the adjoining option list This will be used by the system to convert the transaction amount in terms of fund base currency Override Exchange Rate Optional Select Yes if you wish to change the exchange rate that is displayed here If you sel
178. number Account Number Optional Specify the account number from which the transfer of payment is being made Account Currency Optional Specify the account currency of the account number from which the transfer of payment is being made Bank Name Optional Specify the bank from which the transfer of payment is being made Account Type Optional Specify the account type from which the transfer of payment is being made Branch Code Optional Specify the branch from which the transfer of payment is being made IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of the account holder Payment Date Date Format Mandatory Specify the date on which the initial investment was done You can deposit the amount in different currencies and on different dates Payment Currency Alphanumeric Mandatory Enter the currency in which the initial investment is being done The initial amount can be deposited in multiple currencies Payment Amount Numeric Mandatory Enter the initial investment amount being paid in the particular currency Exchange Rate Details When you click the Enrich button in the Policy Information tab the system will default the following exchange rate details for each settlement e Source ID e Exchange Rate Applied e Transaction Currency Amount veo ORACLE e Override Exchange Rate e FX Deal Date e FX Value Date If exchange rate details a
179. nvestment F1 You have to maintain the rules for Prudential Investment Guidelines and Forex compliance in accordance with this asset allocation You can do so by invoking the Prudential Investment Guidelines Forex Compliance Screen from the browser and click on Detailed 3 80 ORACLE 3 5 3 5 1 Refer to the chapter Prudential Investment Guidelines and Forex compliance PIGS in LEP User Manual for further details on UM Enriching Policy Transactions The initial investment for a policy can be deposited in multiple currencies If the exchange rate is not available while saving the policy the policy is incompletely generated and hence the underlying UT transactions are also generated incompletely Till the policy is allocated it can be enriched The enrichment can be done using the Policy Transaction Exchange Rate Enrichment screen All the settlements of a policy transaction need to be enriched before the policy transaction itself can be enriched When the settlements are being enriched the system will compute the policy transaction amount and asset allocation ratio Subsequently when the policy transaction is enriched the system will convert the policy transaction amount in terms of the policy base currency To invoke the Policy Transaction Exchange Rate Enrichment screen type LEDTXNEE in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Poli
180. o maintain the effective date transaction currency details and Interest Rate of the transaction Invoking Screen You can invoke the FCIS Interest Rate Maintenance Detail screen by typing UTDINRMN n the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is invoked FCIS Interest Rate Maintenance Detail New 3 Enter Query Effective Date Interest Rate Transaction Currency Currency Name Input by DateTime Authorized by DateTime Mod No Open Authorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Interest Rate Maintenance Fields in Policy Maintenance Screen Interest Rate Maintenance Section Effective Date DD MM YYYY Numeric Mandatory Specify the date the system should consider for calculating the rate of interest Fag ORACLE 3 7 3 7 1 Interest Rate Mandatory Specify the Interest Rate for the currency you have selected Translation Currency Mandatory Select the currency of transaction from the option list Currency Name Display Displays the name of the Translation Currency selected Interest Rate Maintenance Summary Screen You can invoke the FCIS Interest Rate Maintenance Summary screen by typing UTSINRMN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow
181. o override the exchange rate that gets defaulted Select Yes to indicate that you wish to override the exchange rate and No to indicate otherwise Click Enrich button to calculate the amount using the exchange rate specified The interest amount associated with the policy transaction also gets converted to policy base currency based on the exchange rate specified ag ORACLE 4 2 9 2 Specifying Asset Allocation Policy Transaction TOPUP Detail M New 433 Enter Query Policy Transaction Transaction Reference Number Policy Start Date Product Name Policy Txn Number Policy Number Product ID Name Policy Holder ID De Policy Maturity Date Transaction Details Asset Allocation Payment Details Broker Details Load Override Details Asset Allocation 1of1 Fund ID Fund Base Currency Transaction Currency Transaction Amount Exchange Rate Source Override Exchange Rate Exchange Ri Yes Input by Date time Mod No Authorized by Date time iueties Unauthorized Capture the fund wise pattern of distribution of the investment amount in the Asset Allocation Details section of this tab If the initial contribution that you enter is in different currencies you need to mention the currency wise details here Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Select the required funds Units Ratio Numeric Mandatory Specify the portion of the units th
182. olicy Maturity Date dd MM yyyy Display The Maturity Date of the Policy is taken from the policy creation details and displayed here You will not be allowed to change the same You will also have to enter information in the fields in the following tabs in this screen e Transaction Details e Asset Allocation e Brokers Details i ORACLE 5 2 3 2 Policy Financial Wizard When you click Policy Financial Wizard button the following screen in invoked Policy Fin Wizard Detail Save Policy Financial Wizard Policy Number H Market Ratio Product ID Contribution Amount Policy Base Currency Compounded Contribution Product Base Currency Portfolio Amount Policy Holder ID AI Policy Holder Name Details 1of1 Options NetAmount AmountIn Product Currency Details 1of1 FundiD Units NAV NetAmount SplitPercentage Policy Number The Policy Financial Wizard enables a Policy Holder to know at a glance the value of his Policy and the details of his holdings in the funds The product Id product base currency and the policy base currency also are displayed based on the Policy Holder ID specified Options Section The details of the holdings that can be viewed are given below e Market Ratio e Contribution Amount e Compounded Contribution e Portfolio Amount e All of the above Select one of the options the option All of the above allows
183. on is specified by the annuitant at the outset e Type 4 The annuity is a joint life and last survivor annuity where the amount of the annuity reduces on the male death The percentage reduction is specified by the annuitant at the outset Asset Allocation Type Mandatory Select the type of asset allocation from the drop down list provided The options available are e User Input e Policy Portfolio If the option selected is User Input then you need to specify the annuity asset allocation If the option selected is Policy Portfolio then you will not be allowed to capture the ratio of funds for annuity or override the load details during policy maintenance In this case the ratio of funds will be calculated based on policy portfolio If the type of asset allocation is specified as Policy Portfolio then you will not be allowed to pass policy journal entries for such transactions Reduction Percentage 5 Characters Maximum Numeric Mandatory Specify the reduction in the annuity in the case of death of one or more of the annuitants or the primary annuitant as is applicable Note This field is only applicable for Annuity Types 3 and 4 No Of Annuity Occurrences Numeric Enter the number of annuity occurrences This is applicable only for accelerated annuity policies Payment Details Payment Mode Mandatory Select the mode of the annuity payment Bank Code Specify the bank code The adjoining op
184. on on the Allocation Details screen 2 ORACLE 6 Policy Transactions Surrender 6 1 Introduction A Policy Holder can initiate any of the following transactions in a policy that he has purchased e Top Ups e Partial or Full Redemption Transactions known as Surrender Transactions e Partial or Full Switch Transactions Note Policy transactions can be carried out through the Agency Branch component only During policy transaction system displays a warning message if there is a security cession marked against this policy Warning message would be displayed on top of the Policy Transaction Screen Warning There is a Security Cession recorded against this policy Transaction may only be executed with the agreement of both parties Policy Transactions can only be initiated into authorized policies for which the underlying initial investment transaction has already been generated The policy transaction must be authorized before it becomes effective and the underlying transactions are generated and allotted Note This chapter deals with Surrender transactions 6 2 Surrender Transactions A partial or total surrender transaction could happen in a policy in any one of the following situations e When the policy is claimed or redeemed by the Policy Holder e When the policy is closed before maturity that is prematurely for various reasons e A partial redemption or surrender is effected 6 2 1 Entering S
185. or all brokers when summed up must not exceed or fall below one hundred percent 6 2 3 8 Specifying Load Override Details You can override or alter the value of load mapped to the selected fund You can do so in the Load Override Details screen which is invoked when you click on the Load Override Details Link Policy Transaction Surrender Detail New 73 Enter Query Policy Transaction Policy Txn Number Reference Number Policy Number Policy Start Date Product ID Product Name Policy Holder ID Policy Holder Name Maturity Date Ph Deal Policy Financial Wizard Transaction Details AssetAllocation Payment Details Broker Details AOS Load Override Details Laad Override Details Details Id 4 10 Gal FundID LoadID Change Type Change Value Transaction Type SelectOne Details 1of1 ical FundID LoadID ParentLoadID ChangeType ChangeValue Transaction Type Ref Type Select One Discount Increase Return Value Input By Date Time Authorized By Date time Modification Number Authorized Bolt ORACLE 6 2 4 6 2 4 1 6 2 4 2 6 2 4 3 Refer the section Load Override Details Link in the chapter Policy for a detailed discussion of the load override details Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the confirmation message as
186. ording to the premium frequency specified for the Policy Note The Premium Start Date must not be equal to and earlier than the Policy Start Date End Date DD MM YYYY Date Format Mandatory Specify the date on which the last premium payment will be made Note The premium period of premium Sls cannot overlap oe ORACLE Value Numeric Mandatory Specify the amount paid by the Policy Holder as the premium amount for the Policy Frequency Mandatory Specify the frequency at which the premium payments will be made for this Policy by the Policy Holder Payment Mode Mandatory Select the mode of the premium payment You have the following options e Cheque e Transfer Bank Code Specify the bank code The adjoining option list displays valid bank codes maintained in the system You can choose the appropriate one Bank Name Specify the bank from which the transfer of payment is being made Branch Code Specify the branch from which the transfer of payment is being made Account Type Optional Specify the account type from which the transfer of payment is being made Account Number Optional Specify the account number from which the transfer of payment is being made Account Currency Optional Specify the account currency of the account number from which the transfer of payment is being made IBAN 36 Characters Only Alphanumeric Optional Specify the IBAN International Bank Account Number of
187. ount e All Select one of the options the option All allows you to view all details together and click View Information button The position of the Policy Holder s investment is thus available at a glance and will aid him when transaction amounts are specified Amount Contributions Section Options Display Policy Financial Info details is displayed here as per the search criteria Net Amount Display Only This displays the total policy holdings in each individual section Amount In Product Currency Display Only The net amount in product base currency converted from policy base currency get displayed here Market Ratio Section Fund Id Display Fund ID is displayed here Units Display Policy Holdings under particular fund is displayed ORACLE 4 2 3 5 4 2 4 NAV Display Net Asset Value is displayed Net Amount Display Value of the Holdings in each fund is displayed Split Percentage Display This displays the percentage of holdings in a fund from the total policy holdings PH Deal Click Ph Deal button in the Policy Transaction TOPUP Detail screen to view the details of all the deals set up for the unit holder The following screen is displayed Unitholder Deal Summary Authorized Open Unit Holder CIF Number az Apply At CIF Level Apply Deal At Not Selected v Load ID Advanced Search Records perpage 15 v 4 of 1 Authorized Open Status Deal Transaction Numbe
188. ous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affili
189. pen a future dated rule the system will allow it only if there is no other future dated rule maintained in the system for the policy Processing Back Data Propagation for Transactions You can correct erroneous transactions as well as enter those that have been missed out and compute the effect these have on the current holdings of the unit holder through the back data propagation process To facilitate this propagation process two schemas are used the business or normal schema and the report schema You are required to enter the correct data in the business schema for the required transactions and select these for propagation again from the business schema The transactions will be simulated in the report schema and the results can be viewed in the business schema ote ORACLE 3 3 3 3 1 Refer the chapter Back Data Propagation for more details on the back data propagation process Policy Maintenance Summary Screen You can invoke the Policy Maintenance Summary screen by typing LESPLAN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy Maintenance Summary Authorized Open Policy Number 7 Policy Reference Number Policy Start Date e Maturity Date es Policy End Date e Latest Rule Advanced Search Reset Records per page 15 v 1 of 1 Authorized Open Status Pol
190. ping LEDPLSTA in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button fl ORACLE 7 2 2 The following screen is invoked Policy Status Change Detail New 5 Enter Query Status Change Details Back Date Surrender Yes Policy Number Allow Surrender Yes Rule Effective Date Allow Closure Yes Present Status Code a Allow Transfer Yes New Status Code Surrender Money Payable Product SE eens Typa Average Salary Last 2 yrs G t e Y Date of death enerate Redemption Yes i Transaction er Offset Value Transaction Description Fetch Values Policy Details Product Name Policy Base Currency Policy End Date Policy Holder Payment Details Branch Account Number Account Type Account Currency Account Name Bank IBAN Input by DateTime Authorized by DateTime Mod No Open Authorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Status Change Fields in Policy Status Change Screen Status Change Details Section Policy Number Mandatory Enter the number of the Policy whose status you are changing Note You have the option of using the Policy Find Options screen to enter the Policy Number This screen is invoked when you click Fetch Values button This procedure is similar to the one for a Top Up Transaction
191. play The system displays the description of the selected product Policy Number System Generated User Input Mandatory Specify the Policy Number at the time of policy creation The system validates the value input for its uniqueness The policy number cannot however be changed during subsequent edit or amend operations When a Policy Holder subsequently contributes into this Policy that has been created the same Policy number has to be specified and the Policy must be an active valid Policy for the transactions to be accepted Reference Number 16 Characters Maximum Alphanumeric Mandatory Specify a unique initial identification for this Policy The Reference Number is the initial identification that you give to a Policy before the Policy Number is generated o ORACLE You can invoke the Policy or retrieve it through the Find Form using this Reference Number for subsequent inquiries and transactions Rule Effective Date DD MM YYYY Date Format Mandatory Specify the date from which the Policy will be effective The format will be the one that has been maintained for your user ID in the My Dash Board User setting date format Policy Status Code Mandatory By Default Policy Status will be ACT on New Mode Transaction Currency Numeric Optional Specify the transaction currency for the policy If you do not maintain this value the system will default this value at the time of saving the maintenance The transa
192. policy and the month a ORACLE 5 2 11 5 2 12 If annuity is applicable for the policy system will calculate the next annuity generation date using annuity frequency amp annuity payment lag If difference between annuity generation date amp 100 switch transaction date is greater than or equal to 6 days External switch or 4 days Internal Switch then system will check for the funds for which 100 switch is being processed are also part of the annuity asset allocation If funds are common between 100 switch transaction amp annuity asset allocation then following warning message gets displayed Annuity transaction is applicable for this policy are you sure you wish to proceed with this switch Select override for the normal annuity transaction If difference between annuity generation date amp 100 switch transaction date is less than 6 days External switch or 4 days Internal Switch then system will check for the funds for which 100 switch is being processed are also part of the annuity asset allocation If funds are common between 100 switch transaction and annuity asset allocation then following error message will be displayed Annuity is in progress this transaction can not be processed If annuity has already been generated before the switch and If funds are common between 100 switch transaction and annuity asset allocation then following error message will be displayed Annuity is in progress this transac
193. ponding Plan or Policy Base Currency is displayed here from the Policy details record This currency cannot be changed at this stage Transaction Type Optional Select the Adjustment Transaction Type The drop down includes options which can be maintained in the System Parameters Maintenance screen under the Param Code PLCYTOPUPTYPE Refer to the chapter Maintaining System Parameters for further information on the System Parameters Maintenance screen Include Interest in Investment Optional Select from the adjoining drop down list if the interest earned on the initial investment should be considered along with the initial investment for investment in the policy If you select Yes the interest amount will be included in the investment and a single transaction will be generated for both You need to manually add the interest amount calculated in the settlement details to the transaction amount of the particular currency in the asset allocation details For instance if the interest amount is USD 1000 and the transaction amount is USD 100000 then you are required to add USD 1000 to the transaction amount for the currency USD in the asset allocation details If you select No the interest amount will be generated as a separate UT transaction Funding Percentage 5 Characters Numeric Optional The funding factor that is applicable to Policy transactions in this product which would have been set up at Product defin
194. r Unit Holder CIF Number FirstName Apply At CIF Level a Retrieving Unit Holder Deal in Unitholder Deal Screen You can retrieve a previously entered record in the Summary screen as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved 3 Select the status of the record in the Open field If you choose the Blank Space option then all the records are retrieved 4 Unit Holder CIF Number ii ORACLE 4 2 5 5 Apply At CIF Level 6 Apply Deal At 7 Load ID After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input Product ID Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Reference Number by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product ID starts from Alphabet A For
195. ransaction TOPUP Detail New 53 Enter Query Policy Transaction Policy Txn Number Policy Number Product ID Policy Holder ID Policy Maturity Date Transaction Reference Number Policy Start Date Product Name Name Policy Financial Wizard ERR 4s et Allocation Payment Details Broker Details Load Override Details Details Transaction Date Transaction Entry Date Transaction Currency Currency Name Balance Transfer No Transaction Amount Transaction Mode Amount Funding Percentage Phase In To Be Cancelled Transaction Type Txn Type Desc Top up Inclusive No X Include Interest In Investment Interest Amount Exchange Rate Details Amount Applied Source ID FX Deal Date Input by Authorized by Policy Base Currency Remarks Exchange Rate Applied Override Exchange Rate FX Value Date Date time Date time No Mod No AUUE Unauthorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Policy Transaction TOPUP Fields in Policy Transaction TOPUP Screen Policy Transaction section Policy Transaction Number System Generated Number This is a unique identification for the Policy transaction that is effected in this Policy It is generated by the system when all details that are mandatory for the transaction profile have been successfully entered and the transaction record is saved
196. rd that you want to amend The Policy Cession screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 5 Amend the necessary information Click the Save button to save your changes 9 3 7 Authorizing Amended Policy Cession An amended Product With Holding Tax must be authorized for the amendment to be made effective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions a ORACLE 10 Policy Journal Maintenance 10 1 Introduction Whenever you need to make an adjustment to the annuity amount you need to post it as a policy journal entry Authorization of policy journal creates a policy transaction on par with normal annuity transaction Appropriate tax is deducted from the gross annuity amount and is posted as annuity tax transaction On authorization of the journal entry it will generate the annuity transaction with gross annuity amount The Policy Journal Maintenance screen allows you to make adjustments to the annuity amount of a policy The next section gives you step by step instructions to do the same 10 2 Maintaining Journal Entries for Policy The following are the steps you need to follow to make a journal entry for a policy Each of these steps is explained in detail in subsequent sections e Invoke th
197. re not available for any settlement when the transaction or policy is entered the system will not generate a UT transaction Once all the settlement details have been enriched in the Policy Transaction Exchange Rate Enrichment screen and the FCIS Enrich Exchange Rate Detail screen the system will compute the transaction amount and generate the UT transaction If it is not enriched then the system will pick the exchange rate during EOD and generate the UT transaction Interest Details When you click the Enrich button in the Policy Information tab if the initial investment amount has been deposited prior to the policy start date the system will calculate and display the interest on the payment amount in the Policy Information tab The interest will be calculated from the date of payment till the transaction date When you click Calculate Interest button in the Settlement Details screen the system will calculate and display the interest amount in the Interest Amount field in the same screen Interest Rate Numeric Optional Enter the rate of interest that is to be used to calculate interest amount for the particular currency Alternatively you can maintain the interest rate in the Interest Rate Maintenance screen If you do not maintain an interest rate the system will take it as null Interest Amount Display Only The system computes and displays the interest amount Interest Amount i
198. rnal number identifies the first journal entry made into a policy and all subsequent journal entries into this Policy will have system generated sequential journal transaction numbers Journal Type Mandatory Select the type of journal entry you wish to make Currently system supports only one type of journal entry that is Annuity Adjustment Policy Number Mandatory Select the Policy on which you want maintain a journal You can use the Find Policy Options screen You can invoke the same by clicking on the option list The Policy selected must be an authorized active Policy on which the underlying initial investment and Annuity transaction has already been generated Journal Currency Display When the Policy Number is selected the corresponding Plan or Policy Base Currency is displayed as the default journal currency from the Policy details record This currency cannot be changed Reference Number 16 Characters Maximum Alphanumeric Mandatory Specify a unique alphanumeric identifier for the journal entry You will use this reference number to track this entry subsequently Policy SI Number Mandatory This number is generated by the system It represents the number of annuity premium payments between the Start Date and End Date specified for the annuity premium payment Journal Txn Date Mandatory The Journal Transaction Date signifies the date on which the journal entry is made into the system You can enter a backd
199. rocess To facilitate this propagation process two schemas are used the business or normal schema and the report schema You are required to enter the correct data in the business schema for the required transactions and select these for propagation again from the business schema The transactions will be simulated in the report schema and the results can be viewed in the business schema Refer the chapter Back Data Propagation for more details on the back data propagation process Automatic Surrender of Policy The system facilitates automatic surrender of policy when the policy s market value goes below certain threshold amount This amount parameterizes at the system level This surrender is paid to the product account and not to the policy holder Process Automatic Surrender and Threshold Policy Market Value defined in the Product maintenance screen accounts for the automatic surrender of policy This can be explained as follows e The user is able to input the threshold value if Process Automatic Surrender is checked e The system automatically triggers 100 policy withdrawal transaction if Threshold Policy Market value is less than this threshold amount The System then triggers an automatic surrender transaction with the following parameters e Portfolio Surrender flag as True e Payment mode as transfer e Payment type as Product e Asset allocation with all funds having balances and percentage applie
200. rocess to trigger Automatic Surrender 11 3 21 11 3 22 The Batch Process to trigger Automatic Surrender is as follows 1 The Batch process first checks the value of Process Automatic Surrender at Product level 2 The system fetches the Threshold Policy Market Value whether Process Automatic Surrender at Product level is correct 3 The system identifies all the policies for which market values have gone below the threshold amount 4 The system then triggers an automatic surrender transaction with following parameters Asset allocation with all funds having balances and percentage applied as 100 Portfolio Surrender flag as True Payment mode as transfer Payment type as Product LEP BOD Plan Transaction Generations Same as LEP Generate Plan Transactions except this is a BOD Process LEP Cash Management Switch Process This process ensures that the Cash Management Account has sufficient balance to meet all the forthcoming annuity payments as well as the periodic fee redemptions This can be run either as part of EOD operations or be manually triggered It works as follows e The system checks the Cash Management Account Applicability and Redeem Periodic Fee from CMA Fund options maintained at the product level e f both the parameters are applicable the system computes the Projected Periodic Fee for all the policies under such products Projected
201. ry screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Policy Status Change that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Policy Status Change screen is opened in View mode Deleting Policy Status Change You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Status Change Summary screen as follows 1 Invoke the Policy Status Change Summary screen from the browser tot ORACLE 7 3 5 7 3 6 7 3 7 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lo
202. screen The Policy Transaction Switch screen is opened in view mode Deleting Transaction Switch You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Transaction Switch Summary screen as follows 1 Invoke the Policy Transaction Switch Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Transaction Switch Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Policy Switch An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Transaction Switch Summary screen 1 Invoke the Policy Transaction Switch Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list
203. seaaas 9 4 9 3 Policy Cession Summary Screen eee ee eecee eee e eet eter etaeee eee teeeeeeetneeeeeeee 9 4 9 3 1 Retrieving Policy Cession in Policy Cession Sereen csccecsttteeeeeettees 9 4 9 3 2 Editing Policy COSSION nnesrninras iiiar a ai aE Eii n i Aii ERE TEER 9 5 9 3 3 Viewing Policy Cessio ere riana an EEA AOE EE 9 6 9 3 4 Deleting Policy COSSION 1 ccccccsescccscseteseneecaneenetedenneneneneseeeeenenanecenaesnees 9 6 9 3 5 Authorizing Policy Cessio aeoe e AA EEEE AEA 9 6 9 3 6 Amending Policy COSSION nirrsisarsiiitiiiiiiraria rinnan aia iiia a a anai 9 7 9 3 7 Authorizing Amended Policy C SSION 0 cc ccscccecttteeeeeetsieeeeeeeneeeeeeeenaes 9 7 Policy Journal Maintenance ceccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeenenenennees 10 1 TOT rodicio cs 2 oo 22 E T AT A 10 1 10 2 Maintaining Journal Entries for Policy 0 cccceeeeeceeeeeeeenneeeeeeeeeaeeeeeeenaeeeeeeeeaas 10 1 10 2 1 INVOKING SCOB oere iadesi ierat auai ideia EARTE ER a E ORELE iS 10 1 10 2 2 Fields in Policy Journal Maintenance Screen esssseeeisseeeeennneeeennnee 10 2 10 3 Policy Journal Maintenance Summary Screen sssseseeereseeerresererrsssrerrrsssrrnes 10 5 10 3 1 Retrieving Policy Journal Entry in Policy Journal Maintenance Scre n seeeeerieeerrrrrrersrrrenrrrrireeeerrnssrrrnnnneeerennnt 10 5 10 3 2 Editing Policy Journal Entry ariarian ii AEAEE Er AAEE 10 6 1033 Viewing Policy Journal ENY erreseina E OT E 10 6 10
204. splayed in Amendment mode Click the Unlock operation from the Action list to amend the record ail ORACLE 5 2 9 1 5 Amend the necessary information Click the Save button to save your changes Specifying Transaction Details Policy Transaction Switch Detail New Enter Query Policy Transaction Transaction Reference Number Policy Number Policy Start Date Product Name Product ID Name Policy Holder ID Policy Maturity Date E 4s set Allocation Broker Details Load Override Details Transaction Details Policy Txn Number Transaction Currency Transaction Date Currency Name Transaction Entry Date Transaction Amount Policy Base Currency Transaction Mode Amount PortFolio Switch No Percentage Holding Remarks Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Value Date FX Deal Date Callate Input By Date Time Modification Number Authorized By Date time anani Unauthorized Transaction Date dd MM yyyy Date Format Mandatory Specify the date for the transaction You can enter a backdated transaction here if backdated transactions are allowed in the corresponding product If backdated transactions are not allowed then this date must not be earlier than the application date The Transaction Date must be earlier than the End Date of the Policy and must not be a holiday The transaction date cannot be earl
205. st be made for this Policy Mode Alphanumeric Mandatory Annuity payments can be made either as a percentage of the net investment amount or as a flat amount Accordingly select the appropriate mode in this field Note This is not applicable if the type of policy is Accelerated Annuity Transaction Currency Specify the code of the transaction currency The adjoining option list displays all valid currency codes along with their description You can choose the appropriate one Pay Incidence Mandatory The payment incidence for an annuity payment sets up the actual payout incidence within the specified frequency for the annuity payment Annuity Type Mandatory Select the desired annuity type that is to be applicable for this Policy from the options provided in the drop down list For information purposes only the annuitant has the option of specifying the type of annuity that should accrue The four types provided are as follows e Type 1 In this type the annuity is a single life annuity payable until the death of the annuitant e Type 2 In this type the annuity is a joint life and last survivor annuity and is payable until the last death of both annuity and spouse that is while at least one of the annuitant or spouse is alive Saa ORACLE e Type 3 The annuity is a joint life and last survivor annuity where the amount of the annuity reduces on the first death of annuitant or spouse The percentage reducti
206. surrender transaction the out flow transaction should include freeze held and reinvestment units Note The Auto Clear Provisional Balance and Auto Clear Reinvestments fields will be checked or unchecked based on the specification for the same in the policy maintenance aN ORACLE screen However you can change the defaulted value These options will be enabled if the Percentage of Holdings is specified as 100 6 2 3 6 Specifying Payment Details Policy Transaction Surrender Detail i New 5 Enter Query Policy Transaction Policy Txn Number Policy Number Product ID Policy Holder ID Maturity Date Reference Number Policy Start Date Product Name Policy Holder Name Policy Financial Wizard Transaction Details Asset Allocation Payment Details Broker Details Load Override Details Payment Details Payment Mode Select Mode Of Payment Clearing Date Beneficiary Details Payment Type Seif Ratio Bank Branch Code Account Type Account Number Account Currency Product Benficiary ID Input By Authorized By Modification Number Check Number Cheque Date IBAN Contact Name Address Line 1 Address Line 2 dentificationNumber Date Time Date time auwe Unauthorized v Capture the details of payments made to the Policy Holder towards processing of the transaction in this tab Payment Details Payment Mode Mandatory Select the mode throug
207. system 3 The process then performs the 5 20 validation for the new anniversary values LEP Plan Annuity Escalations This process works in much the same way as the 5 20 validation process but takes into account any changes that are made to the annuity amount either by way of amendment or escalation in the Policy Maintenance screen The 5 20 validation is also performed for this BOD process LEP Plan Recurring Switch Escalations If recurring switch escalation details are specified for a Policy this BOD Batch Process will amend the policy rule and create a new rule with the new escalated recurring switch value on the specified calculated Escalation Date for the specified funds LEP Plan Premium Escalations If premium escalation details are specified for a Policy this EOD Batch Process will amend the policy rule and create a new rule with the new escalated premium value on the specified calculated Escalation Date for the specified funds LEP Recurring Plan Annuity Processing This BOD Batch Process generates periodic annuities for the Policies for which annuity is applicable This transaction is generated using the annuity setup corresponding to the latest rule for the Policy LEP Recurring Plan Switch Processing This BOD Batch Process generates periodic recurring switch transactions for the Policies for which recurring switch is applicable This transaction is generated using the recurring switch setup
208. t be later than the Start Date If the Escalation Start Date for the recurring switch has been specified then the End Date is mandatory and must be specified Escalation Mode Mandatory Switch payments can be escalated periodically as a pre defined percentage amount or market value Select the mode from the drop down list Escalation Frequency Mandatory Select the frequency at which the escalation is to be applied from the values in the drop down list If the Start Date has been specified the frequency is mandatory and must be specified Escalation Value Mandatory Specify the escalation amount that is to be applied Asset Allocation Details Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Select funds FROM which you are moving the investment amount Units Ratio Numeric Mandatory Specify the percentage of the amount that must be invested in each of the selected funds The sum of all such percentages must add up to 100 and not fall below or exceed it The percentages specified here must not be fractional Typically this field is only applicable for transactions for which the Transaction Mode is Percentage Note If you have specified the investment amounts in each fund the investment ratios are com puted and displayed here and this field is locked The latest investment ratio applicable for the Policy is displayed here when the form is opened These
209. t mode Click the Unlock operation from the Action list to amend the record Amend the necessary information Click the Save button to save your changes Authorizing Amended Transaction Switch An amended policy must be authorized for the amendment to be made effective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions Reversing Transaction Switch You can reverse a policy that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 2 3 6 Invoke the Policy Transaction Switch Summary screen from the browser Select the status of the record that you want to retrieve for reversal Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to reverse in the list of displayed records in the lower portion of the screen The Policy Transaction Switch Detail screen is opened in View mode Select Reverse operation from the Action list The system prompts you to confirm the reversal of record Click the Save button to save your changes Refer to the chapter Allocation Details for informati
210. t of displayed records The Policy Transaction TopUp Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Policy Transaction TopUp Detail screen is closed and the changes made are reflected in the Policy Transaction TopUp Summary screen 4 21 ORACLE 4 3 3 4 3 4 4 3 5 Viewing TopUp Transaction To view a Transaction Top Up you have previously entered you must retrieve the same in the Policy Transaction Topup Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Policy Transaction Topup that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 3 Specify any or all of the details of the records in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Policy Transaction Topup screen is opened in View mode Deleting TopUp Transaction You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Poli
211. tail in subsequent sections Note Any investor who desires to invest in any of the Products by purchasing a Policy in a prod uct can invest only if he is a valid Unit Holder with an account in the system Therefore you must first set up a Unit Holder account for the Policy Holder in the system Refer to the chapter Managing Investor Accounts for further information e Invoke the Policy Maintenance screen e Enter information in the Policy Maintenance screen e Save the information entered Invoking Screen You can invoke the Policy Maintenance Detail screen by typing LEDPLAN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button I ORACLE 3 2 2 The following screen is invoked New 5 Enter Query Default Load Details Policy Maintenance Detail UnitHolder Info Unit Holder Name Unit Holder ID CIF Number ERIE Policy Details Additional Details Intermediary Details Beneficiary Details Constituent Details Load Override Details Policy Details Product Defaulting Funding Factor Product ID Funding ge ape erio Product Description Enrich a I 3 a Asset Allocation ByFund Policy Number f Reference Number Cession Status Rule Effective Date Funding Frequency Policy Status Code ACT Description Transaction Currency bata Include InterestIn No Description Investment Preferred Fund For Initi
212. tails Add Info Input by DateTime Mod No Authorized by Open DateTime Authorized Policy Dates Section Creation Date DD MM YYYY Mandatory This signifies the date on which Policy record was entered into the system By default the system displays the Application Date in this field This date cannot be altered Policy Start Date DD MM YYYY Date Format Mandatory Specify the date from which the Policy is available for transactions By default the system displays the application date in this field oe ORACLE The Policy Start Date can be a past date if backdating is allowed for the product if you have selected the option BackDating Allowed in the Product Maintenance screen but it must not be earlier than the Product Start Date Maturity Date Basis Mandatory The option you select here will decide on what basis the maturity date will be calculated You have the following two options e Retirement Age e Minimum Tenor You can select the option Retirement Age only if you have selected the option YES against the field Retirement Features Supported In such a case the maturity date will be calculated on the basis of the age of retirement you will specify at the Product level If you select the option Minimum Tenor the maturity date will be calculated on the basis of the minimum tenor you will specify at the Product level Maturity Date DD MM YYYY Date Format Mandatory When the
213. tch all the records whose Policy Number contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Policy Status Change You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Status Change Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Policy Status Change Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Policy Status Change Detail screen is closed and the changes made are reflected in the Policy Status Change Summary screen Viewing Policy Status Change To view a Policy Status Change you have previously entered you must retrieve the same in the Policy Status Change Summa
214. tered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Journal Maintenance Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Policy Journal Maintenance Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Policy Journal Maintenance Detail screen is closed and the changes made are reflected in the Policy Journal Maintenance Summary screen Viewing Policy Journal Entry To view a Policy Journal Entry you have previously entered you must retrieve the same in the Policy Journal Maintenance Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Policy Journal Maintenance that you want to retrieve for viewing in the Author
215. thdrawal Numeric Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Amount Specify the minimum amount that a Policy Holder can be withdraw from the holdings Maximum Withdrawal Numeric Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Amount Specify the maximum amount that a Policy Holder can be withdraw from the holdings Limit Percentage Numeric Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Percentage Specify the maximum withdrawal in terms of a percentage that a Policy Holder can be withdraw from the holdings Additional Investments Allowed Mandatory This option indicates whether or not the Policy Holder can make an additional investment in a Policy The option you have specified for the Product will be defaulted here 219 ORACLE Note You will be allowed to uncheck this box if it is checked You will however not be allowed to check this box if it is unchecked Minimum Additional Investment Numeric Optional This field indicates the minimum additional investment amount that a Policy Holder should make if the option Additional Investments Allowed has been selected for the Policy Holder The amount in displayed in this field is the amount entered for the Product You may change the same for the Policy Maximum Additional Investment Numeric Optional This field indicates t
216. the amendment to be made effective in the system Authorization of amended records can only be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions Reversing TopUp Transaction You can reverse a policy that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Transaction Topup Summary screen from the browser 2 Select the status of the record that you want to retrieve for reversal 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to reverse in the list of displayed records in the lower portion of the screen The Policy Transaction TOPUP Detail screen is opened in View mode 5 Select Reverse operation from the Action list The system prompts you to confirm the reversal of record 6 Click the Save button to save your changes Refer to the chapter Allocation Details of Allocation Module for information on the Allocation Details screen A ORACLE 5 Policy Transactions Switch 5 1 Introduction A Policy Holder can initiate any of the following transactions in a policy that he has purchased e Top Ups e
217. the lower portion of the screen 4 Double click the record that you want to view in the list of displayed records in the lower portion of the screen The Product With Holding Tax screen is opened in view mode 9 3 4 Deleting Policy Cession You can delete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Policy Cession Summary screen as follows 1 Invoke the Policy Cession Summary screen from the browser 2 Select the status of the record that you want to retrieve for deletion 3 Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to delete in the list of displayed records in the lower portion of the screen The Policy Cession Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database 9 3 5 Authorizing Policy Cession An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Cession Summary screen 1 Invoke the Policy Cession Summary screen from the Browser 2 Select the status of the record that you want to
218. the status of the record in the open field If you choose the Blank Space option then all the records are retrieved e Journal Txn Number e Reference Number e Journal Txn Date e From Date e To Date After you have specified the required details click Search button All records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by doing query in the following manner Press F7 Input the Journal Number Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list 103 ORACLE 10 3 2 10 3 3 10 3 4 You can also search the record by using combination of and alphanumeric value Example You can search the record for Journal Number by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Journal Number starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Journal Number ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Journal Number contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing Policy Journal Entry You can modify the details of a record that you have already en
219. tion you can maintain the details related to the exchange rate to be used for currency conversion Source ID Mandatory Specify the source from which the exchange rate is obtained or select the source ID from the option list provided a ORACLE Exchange Rate Applied The exchange rate corresponding to the combination of policy base currency and policy transaction currency gets displayed here The exchange rate for a switch transaction will be between policy base currency and transaction currency Amount Applied The amount calculated based on the exchange rate specified gets displayed here after the calculation Override Exchange Rate Select the option to indicate if you wish to override the exchange rate that gets defaulted Select Yes to indicate that you wish to override the exchange rate and No to indicate otherwise Click Calculate button to calculate and convert the amount in terms of the policy base currency using the exchange rate specified 5 2 9 2 Specifying Asset Allocation Policy Transaction Switch Detail New 7 Enter Query Policy Transaction Transaction Reference Number Policy Start Date Policy Number z Product Name Product ID Name Policy Holder ID Policy Maturity Date Transaction Details ESEEAIEEIE Broker Details Load Override Details Details Policy Txn Number 1of1 Fund ID Fund Name Transaction Amount Auto Clear Provisional Balance Au
220. tion Number Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Example You can search the record for Policy Transaction Number by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Policy Transaction Number starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Policy Transaction Number ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Policy Transaction Number contains the numeric value 17 For example GSD217 GSD172 AGC17 etc e Search by 66 System will fetch all the switch transactions Editing Transaction Switch You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke Policy Transaction Switch Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fi
221. tion Surrender Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the list of displayed records The Policy Transaction Surrender Detail screen is displayed 5 Select Unlock Operation from Action list to modify the record Modify the necessary information 6 Click Save to save your changes The Policy Transaction Surrender Detail screen is closed and the changes made are reflected in the Policy Transaction Surrender Summary screen Viewing Surrender Transaction To view a Surrender Transaction you have previously entered you must retrieve the same in the Policy Transaction Surrender Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Surrender Transaction that you want to retrieve for viewing in the Authorization Status field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option 6 21 ORACLE
222. tion can not be processed User should not be allowed to proceed with the transaction Saving Information Entered When you have entered all the mandatory information click Ok button The following message will be displayed The system displays the following confirmation message Record Successfully Saved This indicates the record has been saved Click Ok button Processing Back Data Propagation for Transactions You can correct erroneous transactions as well as enter those that have been missed out and compute the effect these have on the current holdings of the unit holder through the back data propagation process To facilitate this propagation process two schemas are used the business or normal schema and the report schema You are required to enter the correct data in the business schema for the required transactions and select these for propagation again from the business schema The transactions will be simulated in the report schema and the results can be viewed in the business schema oe ORACLE 5 3 5 3 1 Refer the chapter Back Data Propagation for more details on the back data propagation process Policy Transaction Switch Summary Screen You can invoke the Policy Transaction Switch Summary screen by typing LESPLSWT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is displayed Policy
223. tion is available only if for the product you have chosen you have selected the option Annuity Applicable in the Premium and Annuities section of the Product Maintenance Details screen oa ORACLE If for the product you have chosen annuity details are applicable the following screen is invoked when you click on the Annuity Details tab Annuity Details Annuity Details Sequence Number SI Number Status Start Date End Date Value Frequency Mode Amount Payment Details PaymentMode Transfer Bank Code Payment Branch Code Bank Name Branch Name Escalation Details Escalation Start Date Escalation End Date Transaction Currency Source ID Source Pay Incidence Annuity Type Asset Allocation Type Reduction Percentage No Of Annuity Occurrences Account Type Account Number Transfer Account Currency IBAN Escalation Frequency Description Advance at gt Escalation Value Escalation Mode SelectOne Asset Allocation 1of1 Fund ID Fund Name Units Ratio Annuity Details Sequence Number Optional You can enter the sequence number SI Number Display When you save the details of the Policy you are entering the Standing Instructions or SI Number will be generated by the system and displayed Status Mandatory Select the status of the standing instruction of the annuity payment from the option list The options are e
224. tion list displays all valid bank codes maintained in the system You can choose the appropriate one Payment Branch Code Specify the branch from which the transfer of payment is being made Account Number Optional Specify the account number from which the transfer of payment is being made oe ORACLE Bank Name Specify the bank from which the transfer of payment is being made Account Type Optional Specify the account type from which the transfer of payment is being made Account Number Specify the account number The adjoining option list displays all valid account numbers maintained in the system Transfer Account Currency Optional Specify the account currency of the account number from which the transfer of payment is being made Asset Allocation Details Enter the following asset allocation details for the annuity details Fund ID Mandatory All the funds mapped for the selected product are displayed in the option list Against each of these funds you can specify the investment ratio and the annuity ratio Fund Name Specify the fund name Units Ratio 3 Characters Maximum Mandatory wherever applicable For each fund that is displayed specify the ratio of annuity payment to be made from the fund to the total annuity payment from the Policy The sum total of the annuity ratio should add up to 100 Enter information in the following fields Escalation Start Date DD MM YYYY Date Format Optional
225. tion of and alphanumeric value Example You can search the record for Reference Number by using the combination of and alphanumeric value as follows e Search by A System will fetch all the records whose Product ID starts from Alphabet A For example AGC17 AGVO6 AGC74 etc e Search by 7 System will fetch all the records whose Product ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc e Search by 17 System will fetch all the records whose Product ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc e Search by System will fetch all the records maintained Editing TopUp Transaction You can modify the details of a record that you have already entered into the system provided it has not been subsequently authorized You can perform this operation as follows 1 Invoke the Policy Transaction TopUp Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorization Status field You can only modify records that are unauthorized Accordingly choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen to retrieve the record that is to be modified All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen 4 Double click the record that you want to modify in the lis
226. tional Switch in Gross Amount is the amount inclusive of all fees for Switch in Fund Fetch Allocation Details Section Click Fetch Allocation Details button to specify the Fund Transactions Allocation Details and Fee Details 122 ORACLE 12 1 3 1 Specifying Fund Transactions Allocation Details New 4 Enter Query Product ID Transaction Amount Policy Number Date of Allocation Transaction Type Gross Amount Policy Txn Number Switch In Gross Amount Allotted No Net Investible Amount Faich Allacation Details Fund Transactions Allocation Details Fee Details Fund Transactions 10f1 Transaction Number FundID ToFundID Amount Date ofAllocation Gross Amtin FBC NetAmtin FBC Seil Fund Transactions Section Transaction Number Mandatory Enter the transaction number Fund ID Mandatory Select the Fund ID from the option list To Fund ID Specify the To Fund ID Amount Enter the amount Date of Allocation Specify the date of allocation Gross Amount in FBC Enter the gross amount Net Amount in FBC Enter the net amount Settlement Amt Txn Ccy Display The settlement amount is displayed 128 ORACLE 12 1 3 2 Specifying Allocation Details Allocation Details New 53 Enter Query Product ID Transaction Amount Policy Number Date of Allocation Transaction Type Gross Amount Policy Txn Number Switch In Gross Amount
227. tions e Allowed Default checked Provisionally allotted units should be considered while processing 100 outflow transactions by default e Allowed Default unchecked Provisionally allotted units will not be considered while processing 100 outflow transactions by default However you can check this option while performing transactions Auto Clear Reinvestments This field indicates whether 100 outflow transactions include freeze held and reinvestment units The option specified for the product in the Product Maintenance screen will be defaulted However you can change the defaulted option ai ORACLE You can specify any of the following options e Option not allowed Freeze held reinvestment units should not be considered while processing 100 outflow transactions e Allowed Default checked Freeze held reinvestment units should be considered while processing 100 outflow transactions by default e Allowed Default unchecked Freeze held reinvestment units will not be considered while processing 100 outflow transactions by default However you can check this option while performing transactions Remarks Optional You may enter any remarks on the Policy if you wish Refer to the chapter Maintaining System Parameters for more details 3 2 2 4 Specifying Intermediary Details You will need to capture details of the intermediaries attached to the initial investment When you click Intermediary Det
228. to Clear Reinvestments Transaction Currency No gt No To Fund ID Fund Name Input By Date Time Modification Number Authorized By Date time ees Unauthorized If the transaction amount that you enter is in different currencies you need to mention the currency wise details here Asset Allocation Details section Capture the funds FROM which the investment amount is being moved in the Asset Allocation Details section of this tab r ORACLE Fund ID Mandatory All the funds mapped for the selected Product where the Policy holder has a balance are displayed in the option list Select funds FROM which you are moving the investment amount Fund Name Specify the fund name from the adjoining option list Ratio Numeric Mandatory Specify the percentage of the amount that must be invested in each of the selected funds The sum of all such percentages must add up to 100 and not fall below or exceed it The percentages specified here must not be fractional Typically this field is only applicable for transactions for which the Transaction Mode is Percentage Note If you have specified the investment amounts in each fund the investment ratios are com puted and displayed here and this field is locked The latest investment ratio applicable for the Policy is displayed here when the form is opened These values can be amended and you can specify th
229. uct The system does not perform any validation against this amount and it is used only for information purposes ROA Applicable Indicate whether a Rate of accumulation is applicable for the policy The initial administrator and broker will use the market value at policy level to derive the fee return value The fee is calculated based on the gross amount of the individual transaction value You can select the applicable ROA for policy and policy holder On selecting the Right of accumulation for Policy an accumulation rate is applied on the policy being created On selecting Unit holder the Right of Accumulation is applicable for all the policies mapped to the particular Unitholder For an ROA function to be applicable a cumulative load would have to be setup and mapped in the Load Product ae ORACLE Allow ROA at CIF Level Indicate if ROA is to be allowed at CIF level or not by choosing from the drop down list Withdrawal Counter Display This field displays the number of withdrawals taken by the policy holder It will be displayed irrespective of the product to which the policy belongs System will update the Withdrawal counter at policy level after doing a withdrawal transaction and also validates with the No of withdrawals allowed at Policy level Example If you enter the Start Date of the Policy as 3 June 2005 the Anniversary Date will be defaulted to 3 June 2006 If you wish to change the Anniversary Date of t
230. ugh for the investor This percentage must not exceed one hundred percent a6 ORACLE 4 2 9 5 4 2 10 Note If you specify more than one broker in this section the split percentages for all brokers when summed up must not exceed or fall below one hundred percent Specifying Load Override Details You can override or alter the value of load mapped to the selected fund You can do so in the Load Override Details screen which is invoked when you click on the Load Override Details Link Policy Transaction TOPUP Detail New 7 Enter Query Policy Transaction Transaction Reference Number Policy Start Date Policy Number olicy Number Product Name Product ID Name Policy Holder ID ie Policy Maturity Date Policy Txn Number Policy Financial Wizard Transaction Details Asset Allocation Payment Details Broker Details EE Load Details Load Override Details 1of1 Fund ID LoadID ChangeType Change Value Group Id Transaction Type Ref Type SelectOne v Fund ID Load ID ParentLoadID ChangeType ChangeValue Transaction Type Ref Type SelectOne Input by Date time Mod No Authorized by Date time eects Unauthorized Refer the section Load Override Details Link in the chapter Policy for a detailed discussion of the load override details Saving Information Entered When you have entered all the
231. und Name Description Policy Number Effective End Date Effective Start Date Group ID Tax Type Load Description Load ID Load Calculation Method Amount Or Percentage Default Load Details Load Details I4 4 1of1 gt DI Gal Slab Sequence No From Date To Date From Amount ToAmount From Units i a Derived Load Details 4 4 tof gt Load ID Load Percentage Override To Input by DateTime Authorized by DateTime Mod No Open Authorized Refer to the chapter Setting Up Investor Preferences in the User Manual for further information ee ORACLE 3 1 3 2 3 2 1 3 Policy Introduction After the products are defined in the system you can accept requests for creating policies in the products for Policy Holders A Policy Holder can buy policies in any of the active products defined in the system A Policy therefore essentially is an investment into the underlying portfolios of the Product and the creation of a Policy lays down the profile or guidelines of the desired pattern of investment by a Policy Holder into a Product Note Policies can be created through the Agency Branch component only The Policy Maintenance screen allows you to capture the details of a Policy The next section gives you step by step instructions to do the same Creating and Saving Policy The following are the steps you need to follow to create a Policy Each of these steps is explained in de
232. uppose the Policy Holder tops up transaction T1 his investment in the policy by 40000 currency units top up being Inclusive on 1 t April 2005 The total contribution has now increased to 100 000 currency units On 1t April 2005 EOD the 5 20 Rule batch checks the annuity amount specified as 3000 currency units against total contribution amount 100 000 currency units which amounts to less than 5 of the total contribution amount thus violating the 5 20 Rule and logs an entry into the error report with the reason for failure of the 5 20 check Subsequent to above for i ORACLE any of the other top up transactions the system considers the same NIA initial top up amount and the latest top up amount for the 5 20 validation in the policy year Case B Let us consider a Policy Holder who buys a policy in an ELLA product He initially contributes 60000 currency units net of initial charges on 15t January 2005 On 1 January 2005 EOD the 5 20 Rule batch checks the annuity amount which has been specified as 3000 currency units against the NIA 60 000 currency units which amounts to 5 of the NIA per month for a period of 5 years There is no violation of the rule here Now let us suppose the Policy Holder tops up transaction T1 his investment in the policy by 40000 currency units top up being Exclusive on 1t April 2005 The total contribution has now increased to 100 000 currency units On 1t April 2005 EOD the 5 2
233. urrender Transaction The following are the steps you need to follow to enter and save a Surrender transaction Each of these steps is explained in detail in subsequent sections e Invoke the Policy Transaction Surrender screen e Enter information in the Policy Transaction Surrender screen e Save the information entered oal ORACLE 6 2 2 6 2 3 6 2 3 1 Invoking Screen You can invoke the Policy Transaction Surrender Detail screen by typing LEDPLSUR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The following screen is invoked Policy Transaction Surrender Detail New 7 Enter Query Policy Transaction Policy Txn Number Reference Number Policy Number Policy Start Date Product ID Product Name Policy Holder ID Policy Holder Name Maturity Date Ph Deal Policy Financial Wizard GERBER Asset Alocation Payment Details Broker Details Load Override Details Details Transaction Currency Transaction Entry Date Currency Name Policy Transaction Date Transaction Amount Policy Base Currency Transaction Mode Amount Portfolio Surrender No v Percentage Adjustment Transaction No v Phase In To Be Cancelled Surrender Money Payable Transaction Type Description Txn Type Desc Remarks Exchange Rate Details Amount Applied Exchange Rate Applied Source ID Override Exchange Rate No FX Value Date FX Dea
234. wer portion of the screen The Policy Status Change Detail screen is opened in View mode 5 Select Delete operation from the Action list The system prompts you to confirm the deletion and the record is deleted physically from the system database Authorizing Policy Status Change An unauthorized record must be authorized in the system for it to be processed To authorize a record you must first retrieve the same in the Policy Status Change Summary screen 1 Invoke the Policy Status Change Summary screen from the Browser 2 Select the status of the record that you want to retrieve for authorization Typically choose the Unauthorized option from the drop down list 3 Specify any or all of the details of the record in the corresponding fields on the screen Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 4 Double click the record that you wish to authorize The Policy Status Change Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record Amending Policy Status Change After a record is authorized it can be modified using the Unlock operation from
235. when you click on the Load Override Details button in the Policy Maintenance Details screen Annuity Details Details 1of1 Load ID Group Id Change Type Change Value Txn Type Ref Type Sequ SelectOne 1of1 Load ID ParentLoadID Change Type Change Value Ref Type SelectOne Load ID Display Only The ID of the load that has been mapped to the fund is displayed here The load ID is displayed as a link To view details of the load click the ID link If a derived load has been mapped it is also displayed here and can be overridden Group ID Optional Displays the group ID Change Type Optional When you override or alter a load at the time of entering a transaction you can effect the change in any of the following ways Sa ORACLE e Discount reducing the load return value in all the slabs e Increase increasing the load return value in all slabs e Return Value assigning an altered return value that will be applicable to all the loads Change Value Numeric Optional Specify the altered return value for the allocation time load that you are overriding Txn Type Display Mandatory This displays the transaction type Ref Type Display Mandatory This displays the Reference Type 3 2 2 16 Switch Load Override Section You can override or alter the value of load applied on the load mapped to the selected fund You c
236. yed in the lower portion of the screen Double click the record that you want to reverse in the list of displayed records in the lower portion of the screen The Policy Transaction Surrender Detail screen is opened in View mode Select Reverse operation from the Action list The system prompts you to confirm the reversal of record Click the Save button to save your changes Refer to the chapter Allocation Details for information on the Allocation Details screen Ores ORACLE 7 1 7 2 7 2 1 7 Policy Status Change Introduction When a policy is created the status of the same is Active It may be required to change the status of the policy A status change may or may not have a processing impact and depending on the change in status a restriction may be placed on the policy Note The status of a policy can be changed through the Fund Manager component only The Policy Status Change screen allows you to change the status of a Policy The next section gives you step by step instructions to do the same Changing Status of Policy The following are the steps you need to follow to change the status of a policy Each of these steps is explained in detail in subsequent sections e Invoke the Policy Status Change screen e Enter information in the Policy Status Change screen e Save the information entered Invoking Screen You can invoke the Policy Status Change Detail screen by ty
237. you to view all details together and click View Information button The position of the Policy Holder s investment and the holding value in product base currency are thus available at a glance and will aid him when transaction amounts are specified a4 ORACLE 5 2 3 3 PH Deal Click Ph Deal button to view the details of all the deals set up for the unit holder The following screen is displayed Unitholder Deal Summary Authorized Open Unit Holder CIF Number az Apply At CIF Level Apply Deal At Not Selected s Load ID Advanced Search Records perpage 15 v 1 of 1 Authorized Open Status DealTransactionNumber Unit Holder CIF Number FirstName Apply At CIF Level a 5 2 4 Retrieving Unit Holder Deal in Unitholder Deal Screen You can retrieve a previously entered record in the Summary screen as follows 1 Invoke the Unitholder Deal Summary screen by clicking Ph Deal button 2 Select the status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved 3 Select the status of the record in the Record Status field If you choose the Blank Space option then all the records are retrieved 4 Unit Holder CIF Number 5 Apply At CIF Level 6 Apply Deal At 7 Load ID After you have specified the required details click Search button All records with the specified details are retrieved and d

LEP Transactions User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents