Home

3.3 Transaction Sub Type Maintenance Summary

Contents

1. W Policy Tax Class Load ID For Tax Class v C h E Input by DateTime Mod No Open Authorized by DateTime Authorized cancel You can specify the following details Policy Tax Class Alphanumeric 8 Characters Mandatory Specify the policy tax class details Alternatively you can select policy tax class from the option list The list displays all the valid policy tax class details maintained in the system Load ID for Tax Class Alphanumeric 8 Characters Mandatory Specify the load ID for tax class details Alternatively you can select load ID for tax class from the option list The list displays all the valid load ID for tax class details maintained in the system Tax class load mapping will be allowed only if Applicable for CGT field is selected as Yes Saving information Entered When you have entered all the mandatory information click Ok button The system displays the confirmation message as Record Successfully Saved This indicates the record has been saved Click Ok button Product With Holding Tax Summary Screen This section contains the following topics e Section 6 2 1 Invoking Product With Holding Tax Summary Screen os ORACLE 6 2 1 6 2 2 e Section 6 2 2 Retrieving Product With Holding Tax in Product With Holding Tax Screen e Section 6 2 3 Editing Product With Holding Tax e Section 6 2 4 Viewing Product With H
2. Fund ID Fund Name 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 Product Load Product ID Mandatory Select the product for which the Product Load mapping is being set up The option list displays all the authorized products maintained in the system Product Name Display Upon selection of the product id the system displays the name of the selected product Rule Effective Date Mandatory Specify the date from when the Product Load mapping that is currently being set up should become effective ae ORACLE The Rule Effective Date should be later than or same as the Fund Start Date and it should also be later than or same as the current application date of the system Latest Rule Mandatory If you want latest rule to be applied select Yes else No Product Load Details Section Sequence Number Mandatory Enter the sequence number Transaction Type Mandatory This is to indicate the transaction type for which the loads are being defined Select the Transaction Type from the list given in the drop down menu Transaction Name Display Upon selection of the transaction type the name of the selected transaction gets populated automatically Load ID Mandatory Select the ID of the load that must be applied for the selected product Load
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 For 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 and so forth e Search by 7 System will fetch all the records whose Product Type ends by numeric value 7 For example AGC17 GSD267 AGC77 and so forth e Search by 17 System will fetch all the records whose Product Type contains the numeric value 17 For example GSD217 GSD172 AGC17 and so forth Editing Product With Holding Tax 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 Product With Holding Tax 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
4. 0 000 4 38 4 5 2 Invoking Product Annual Annuity Limit Detail Screen 0 cccsscceetreeeeee 4 39 4 6 Product Annual Annuity Limit Summary 000 cee tener eee ette eee eetetaeeeeeetnaeeeeeenee 4 40 4 6 1 Retrieving a Record in Product Annual Annuity Limit Summary Screen 4 40 4 6 2 Editing Product Annual Annuity Limit R COIO cccccecceceeenttteeeeeeennneees 4 42 4 6 3 Viewing Product Annual Annuity Limit Record cccccceccceeeteteeeeeeenneeees 4 42 4 6 4 Deleting Product Annual Annuity Limit R COI ccccccccccenteeeeeeeneieee 4 42 4 6 5 Authorizing Product Annual Annuity Limit R COIO 1 cccccceseceeeeenneeeees 4 43 4 6 6 Amending Product Annual Annuity Limit R COMO 0 ccccccceeseeeeeeennneees 4 43 4 6 7 Authorizing Amended Product Annual Annuity Limit Record 00 4 43 5 Product Activities 2c csten ca fete ets cast icieeeeitetet re tients a cona de 5 1 S1 Produet LOA inasnan EA penasicctenas E ERa E EEA RRA ARE aR 5 1 5 1 1 Setting up Product Load 1ssccccecceceeseeceeneeecsneeceeeeteseaeecsentecseaeseenseetssaees 5 1 SA2 INVOKING S eA sss fos Adele a oh Se eae ade ete 5 2 5 2 Product Load Summary Screen cece ceeneeeeeeeeneeeeeeseeeeeeeeeeeeeeeeeeeeeeaeeeeeeeaaeees 5 7 5 2 1 Invoking the Product Load Summary SCI N ccccecceesttecesteseteneeetsnnnees 5 7 5 2 2 Retrieving Product Load in Product Load Screen ccccccssssceeessssteseeeeees 5 7 Sear
5. e Specify any or all of the details of the record in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to view in the list of displayed records The Product Annual Annuity Limit Detail screen is displayed in View mode Deleting Product Annual Annuity Limit Record You can delete only unauthorized records in the system To delete a record that you have previously entered e Invoke the Product Annual Annuity Limit Summary screen from the Browser e Select the status of the record that you want to retrieve for deletion e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen ante ORACLE 4 6 5 4 6 6 4 6 7 e Double click the record that you want to delete in the list of displayed records The Product Annual Annuity Limit Detail screen is displayed e Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database Authorizing Product Annual Annuity Limit Record e An unauthorized Product Annual Annuity Limit record must be authorized in the system for it to be processed To authorize a record e Invoke the Product Ann
6. 100 000 500 000 1 5 500 000 1 000 000 L2 Initial Broker Fee Slab in ZAR Rate in 0 999 999 999 2 0 Operating CMA Generate Switch Transaction Batch You can run this batch either on a periodic basis or manually You can invoke CMA Generate Switch Transaction screen by typing UTDCMABP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button CMA Generate Switch transaction Process If you wish to run this batch on a periodic basis during EOD you can do so by defining the following System Parameters CMA Switch Date You can specify the date on which you would want the batch run for the first time For example you may choose to run it on 2nd January CMA Switch Freq You need to specify the frequency at which you would like the batch to be run The system uses this information to run the batch from the second time on For example if you have specified a monthly frequency the system checks every day to see if the current date matches the date defined by the CMA Switch Date and Freq It then runs the batch when the date is 2 February 10 3 ORACLE You can execute the CMA Generate Switch txn Batch manually when ever you choose The manual execution is independent of the parameters you may have specified above Note During a top up or switch transaction for a policy having funds in different
7. e The status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved e The status of the record in the Record Status field If you choose the Blank Space option then all records are retrieved e Policy Administrator e AUM Date For Next Batch Run e Next Batch Run Date Click Search button to view the records All the 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 querying in the following manner Press F7 Input the Policy Administrator Press F8 tite ORACLE 11 4 2 11 4 3 11 4 4 You can perform Edit Delete Amend Authorize Reverse Confirm operations by selecting the operation from the Action list You can also search a record by using a combination of and alphanumeric value Editing PIGS Batch Maintenance Record You can modify the details of PIGS Batch Maintenance record that you have already entered into the system provided it has not subsequently authorized You can perform this operation as follows e Invoke the PIGS Batch Maintenance Summary screen from the Browser e 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
8. Mandatory Specify the transaction type for which the Transaction sub type is mapped or linked from the transaction sub type maintenance screen Product Name The Product name of the product for which transaction sub type is mapped is defaulted once the Product ld is selected Product Short Name The short name attributed to the Product is defaulted once you have selected the Product ID Sub Type Mapping Section Sub Type If you have activated Product Transaction sub type mapping then the sub types applicable for particular transaction types are defaulted populated from available for the transaction sub types maintained as part of Product Transaction sub type screen Otherwise the sub types are populated from Transaction sub type screen os ORACLE For system generated transaction sub types FLEXCUBE defaults the values entered 4 4 Product Transaction Sub Type Mapping Summary This section contains the following topics e Section 4 4 1 Invoking Product Transaction Sub Type Mapping Summary e Section 4 4 2 Retrieving Product Transaction Sub Type Mapping e Section 4 4 3 Editing Product Transaction Sub Type Mapping e Section 4 4 4 Viewing Product Transaction Sub Type Mapping e Section 4 4 5 Deleting Product Transaction Sub Type Mapping e Section 4 4 6 Authorizing Product Transaction Sub Type Mapping e Section 4 4 7 Amending Product Transaction Sub Type Mapping e Section 4 4 8 Authorizing Amended Product Tr
9. a ORACLE 3 3 2 3 3 3 e Sub Type Click Search button to view the records All the 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 querying in the following manner Press F7 Input the Sub Type Press F8 You can perform Edit Delete Amend Authorize operations by selecting the operation from the Action list You can also search a record by using a combination of and alphanumeric value Editing Transaction Sub Type Maintenance Record You can modify the details of Transaction Sub Type Maintenance record that you have already entered into the system provided it has not subsequently authorized You can perform this operation as follows e Invoke the Transaction Sub Type Maintenance Summary screen from the Browser e 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 e Specify any or all of the details in the corresponding fields to retrieve the record that is to be modified e Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen e Double click the record that you want to modify in the list of displayed records The Tran
10. e Section 10 1 1 Cash Management Account Description e Section 10 1 2 CMA Operations e Section 10 1 3 Operating CMA Generate Switch Transaction Batch Cash Management Account Description The following constitute the balance in a CMA e The market value of the CMA fund e The Income Distributions of the CMA fund e Proportionate investments from other funds which form part of the portfolio at the time of initial investment for the projected ongoing fees e Proportionate investments from other funds during top ups when the balance in the CMA is insufficient to meet the projected ongoing fees for the transaction e Proportionate switches from other funds when the balance in the CMA is insufficient for a forthcoming annuities or fees The projected ongoing fees are calculated on the basis of the loads and load levels specified in the Product Load Maintenance and invested in the CMA The investment into the CMA becomes available for recovery of fees only during top up investments and not at the time of initial investment since the CMA fund becomes operational only after the initial investment You need to keep in mind the following for loads for CMA e Typically the distribution fees like admin and broker fees are maintained as Level 1 loads and first deducted from the investment The UT fee maintained as Level 2 is applied only on the net amount e You should map two product level loads which are the exact copy of the loa
11. if CGT is applicable Constituent Details Mandatory Mandatory If you select Yes it is mandatory to specify constituent details in the Policy Maintenance screen sa ORACLE Auto Clear Prov Bal Indicate whether 100 outflow transactions based on the product should include provisionally allotted units You can specify any of the following options e Option not allowed Provisionally allotted units should not be considered while processing 100 outflow transactions 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 Generate Redemption for CGT Mandatory Select Yes to generate redemption for CGT KYC Applicable Mandatory If you select Yes the transaction limit will be checked at the time of capture of Policy Transactions Note System level existing workflow of KYC would still be applicable irrespective of the status selected WAC Method Optional Select WAC method from the drop down list Select the WAC method from the drop down list The list display the following values e Regular WAC e Life WAC If you select Life WAC and Base Cost is not provided while capturing a transaction then the system
12. 1 cccscceessseeeeeneeetees 3 10 3 4 3 Editing Product Type saene EE EE EAO EE EROT 3 11 3 4 4 Viewing Product TYP ceeeeeceeeeeeeenneeeeeeenneeeeeeeneaeeeeeetinneeeseetnneneesentnnnneees 3 11 3 4 5 Deleting Product TYP saen senata iee a a a a 3 12 3 4 6 Authorizing Product TYPO iccitat aa i 3 12 3 4 7 Amending Product TYPE zasai r A E E 3 12 3 4 8 Authorizing Amended Product Type eeeessseeeesseesesrirnesrrrrnnesrrnrneernnnee 3 13 3 5 Product Nature of Fund Mapping cccccceeeeeeeeeeecneceeceeeeeeeeeesesensnenueeeseeeeeeeess 3 13 3 5 1 Invoking Product Nature of Fund Mapping SCree n ccccecceeseeesssees 3 13 3 6 Product Nature of Fund Mapping Summary cecccceeeeeeeeeeeeeeetteeeeeeettateeeeeeaees 3 14 3 6 1 Retrieving Product Nature of Fund Mapping cccccccecceceeststeeeeeeeenneeees 3 15 3 6 2 Editing Product Nature of Fund Mapping R COmd ccccccsseceeeesnnneeees 3 15 3 6 3 Viewing Product Nature of Fund Mapping Record cccccccscccsenseees 3 16 3 6 4 Deleting Product Nature of Fund Mapping R COMd ccccccssecceceeesseees 3 16 3 6 5 Authorizing Product Nature of Fund Mapping Record scccccesseeees 3 16 3 6 6 Amending Product Nature of Fund Mapping Record ccccsesccceestnieee 3 17 3 6 7 Authorizing Amended Product Nature of Fund Mapping Record 3 17 3 7 Product Tax Class Maintenance cccccceceeeeneeeeeeeenneeeeeeenaeeeeee
13. E Effective End Date E Min Ratio az Max Ratio jaz Records per page Gs 1 of 1 Lock Columns ox Authorized Open Product Rule ID No Min Age Max Age Effective Start Date Effective End Date Min Ratio Max Ratio The status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved The status of the record in the Record Status field If you choose the Blank Space option then all records are retrieved Product Minimum Age Effective Start Date Minimum Ratio Rule ID Number Maximum Age Effective End Date Maximum Ratio Click Search button to view the records All the 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 querying in the following manner Press F7 Aa ORACLE 4 6 2 4 6 3 4 6 4 Input the Product Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operations by selecting the operation from the Action list You can also search a record by using a combination of and alphanumeric value Editing Product Annual Annuity Limit Record You can modify the details of Product Annual Annuity Limit record that you have already entered into the system provided it has not subsequently authorized You can perform this operation as follows
14. Invoke the Product Entity 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 Product Entity 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 Product Entity 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 Product Summary screen 1 Invoke the Product Entity 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 Product Entity Detail screen is opened in
15. Minimum Withdrawal Maximum Withdrawal Amount Amount Withdrawal LimitMode SelectOne Automatic Surrender Process Automatic No Threshold Policy Market Surrender Value Adjustment Transaction Sub Types 1of1 Applicable AdjTxn Type Applicable AdjTxn Description x Input by DateTime Mod No Authorized by Open DateTime Authorized EJ Withdraw Section No of Withdrawals Allowed Optional Specify the number of partial surrender transactions that can be performed by the Policy Holder during the tenor of the policy You have to mention the number above zero to select the applicable transaction sub types Withdrawal Limit Mode Optional Select the option Percentage to indicate the withdrawal details will be specified in terms of the percentage of holdings Select the option Amount to indicate the withdrawal details will be specified in terms of the withdrawal amount Withdrawal Limit Percentage Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Percentage Specify the maximum percentage of holdings that the Policy Holder is allowed to withdraw 4 16 ORACLE Withdrawal Limit Basis Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Percentage Specify the applicability of the withdrawal percentage The percentage you have specified might apply to the Contribution Amount Compounded Contribution or Marke
16. The process of authorization is subsequently the same as that for normal transactions Product Annual Annuity Limit Mapping This section contains the following topics e Section 4 5 1 Maintaining Product Annual Annuity Limit Mapping Details e Section 4 5 2 Invoking Product Annual Annuity Limit Detail Screen Maintaining Product Annual Annuity Limit Mapping Details You can define different lower and upper annual annuity income percentage boundary of a client request per product based on the following criteria e Client Age The upper and lower boundaries can be different based on the client s age e Client Health Status If age is a parameter for the given product and Policy Start date and if a client suffers from ill health the same rules apply as if the client was in the highest age bracket Ifclient is healthy then system will apply the appropriate between minimum and maximum age range post deriving the bracket in which client s age falls into However the minimum cannot be higher than his her previous requested Ifclientis ILL then system will apply the appropriate between minimum and maximum age range post deriving the bracket as if the client was in the highest age bracket However the minimum cannot be higher than his her previous requested e Policy Start Date The original boundaries that were in place at the time of the creation of the Policy apply even if the boundaries have since
17. oe ORACLE Rule ID Display The system displays the rule ID for the maintenance Health Status Optional Select the health status from the adjoining drop down list Following are the options available e Healthy e Ill 4 6 Product Annual Annuity Limit Summary This section contains the following topics e Section 4 6 1 Retrieving a Record in Product Annual Annuity Limit Summary Screen e Section 4 6 2 Editing Product Annual Annuity Limit Record e Section 4 6 3 Viewing Product Annual Annuity Limit Record e Section 4 6 4 Deleting Product Annual Annuity Limit Record e Section 4 6 5 Authorizing Product Annual Annuity Limit Record e Section 4 6 6 Amending Product Annual Annuity Limit Record e Section 4 6 7 Authorizing Amended Product Annual Annuity Limit Record 4 6 1 Retrieving a Record in Product Annual Annuity Limit Summary Screen You can retrieve a previously entered record in the Summary Screen as follows Aao ORACLE Invoke the Product Annual Annuity Limit Summary screen by typing LESPAALM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button and specify any or all of the following details in the corresponding details Product Annual Annuity Limit Summary X E gt search Ct Advanced Search Reset K Clear Al Search Is Case Sensitive Authorized O H Open O E Product az Rule ID No Min Age aZ Max Age aE Effective Start Date
18. provided it has not subsequently authorized You can perform this operation as follows e Invoke the Product Nature of Fund Mapping Summary screen from the Browser ORACLE 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 Specify any or all of the details in the corresponding fields 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 Double click the record that you want to modify in the list of displayed records The Product Nature of Fund Mapping Detail screen is displayed Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The Product Nature of Fund Mapping Detail screen is closed and the changes made are reflected in the Product Nature of Fund Mapping Summary screen 3 6 3 Viewing Product Nature of Fund Mapping Record To view a record that you have previously input you must retrieve the same in the Product Nature of Fund Mapping Summary screen as follows Invoke the Product Nature of Fund Mapping Summary screen from the Browser Select the status of the record that you want to retrieve for viewing in the Authorization Status field You can also
19. 3 Invoking PIGS FOREX Compliance SCre n ccccceccscestecsstestesseeetsnaes 11 3 11 1 4 Components BUTON cccececceceeeenseeeceeeeeseneeeceeeesseaeeceneessenaeecsdnstseseeetsaees 11 4 11 1 5 Related Components Button 0 cceccccceeccceestecceseeceeeeeceneeeseeaeecseaestsesenessaees 11 4 11 2 PIGSFOREX Compliance Summary Screen sseeesssseeeeesererrrsseerrrsssrrerrssseernse 11 4 11 2 1 Invoking the PIGSFOREX Compliance Summary Screen ccccceee 11 5 11 2 2 Retrieving PIGSFOREX Compliance in PIGSFOREX Compliance Screen 11 5 11 2 3 Editing PIGSFOREX COmpliane ccccccccessccseceeessseecesesetstissesenenetsaees 11 6 11 2 4 Viewing PIGSFOREX Compliance 1 2 ccccecccccceceeteneeeeseneeeestnestseeecenaees 11 6 11 2 5 Deleting PIGSFOREX Compliance cccccccsccecceeeeetsseeceseetecstesesseeetsaees 11 7 11 2 6 Authorizing PIGSFOREX COmplianCe 1 cccccccccccccessescseneetsssseteeseeetsaees 11 7 11 2 7 Amending PIGSFOREX Compliance u 1 ccccccccececseseseeceeeeeeteteneeessneetsaees 11 7 11 2 8 Authorizing Amended PIGSFOREX Compliance ccccccccseesessteessseees 11 8 11 3 PIGS Batch Maintenances ccccccseccesecceeeeedecnecceeedeeneneesedeneceeneseateceneseaceneeeedees 11 8 11 3 1 Invoking PIGS Batch Maintenance Screen 2 cccccecccsssesecssessteeseeetsees 11 8 11 4 PIGS Batch Maintenance SUMMALY cece eee etteeee eee teteee eee taeeeeeetaeeeeereeee 11 9 11 4 1 Retrieving a Re
20. 6 Authorizing Product With HOICING TAXx ccccesssceeeeesseeeesestneeeeeneneeereenee 6 7 6 2 7 Amending Product With HOldinG Tax cccccccescccecesenteeeesssiteeeeeseeseeerennes 6 7 6 2 8 Authorizing Amended Product With Holding TaX ccccccescccceetttteeeeeeniees 6 8 Pri iG LOA occ c cece E E E hee ach cadence cetecet Hcaeecacatecibenseeneats 7 1 T 14 Periodic Load Maintenance c cccccceeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeesennaeeeeeneeaeees 7 1 7 1 1 Invoking the Periodic Load Maintenance Screen ccccccccccccssseecesseeteies 7 1 Management Fee r ri e aaae ea ee eee 8 1 8 1 Management Fone naa E E E AAR 8 1 8 1 1 Applying Management FeO cccceessecceeeenteeeeceeenieeeeesenieeeesseesieeeesseesineeeess 8 1 8 1 2 INVOKING Sormenean aaiae enia iian i s e SEAE ates 8 2 8 1 3 Saving Information Entered 2 cccccccccccceceseeeeneececeeeeseeececeesstsnseeeseneessnaes 8 3 8 2 Management Fee Applicability Summary SCreeN eee eeeeeeeeeeteeeneeeeeeeeneaeeees 8 3 8 2 1 Invoking the Management Fee Applicability Summary Screen 00 8 3 8 2 2 Retrieving Management Fee Applicability ccccsccceeesseeeecesnteeeeeetnneees 8 3 8 2 3 Editing Management Fee Applicability 0 ccccccccesseeeeceensneeeeeesntieeeeeetnnenees 8 4 8 2 4 Viewing Management Fee Applicability cccccccessecceceetseeeeeeeensieeeeeesnnenees 8 5 8 2 5 Deleting Management Fee Applicability cccccccceseeeeceesteee
21. All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Product Nature of Fund Mapping Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes Authorizing Amended Product Nature of Fund Mapping Record An amended Product Nature of Fund Mapping record must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Agency Branch module The subsequent process of authorization is the same as that for normal transactions Product Tax Class Maintenance This section contains the following topics e Section 3 7 1 Maintaining Product Tax Class e Section 3 7 2 Invoking Product Tax Class Maintenance Detail Screen Maintaining Product Tax Class As part of the endowment products regulatory requirements the taxes are deducted by the Life Company where as in Life Insurance business taxes are the policy holder s responsibility Therefore the Life Company is responsible for payment of such tax to the SARS Regulatory Authority so that the investment returns are tax free at the policy holder s hand The tax varies among the policy holder depending upon the policy holder s category w
22. Mandatory Specify the date on which the fiscal year begins Fiscal End Date Mandatory Specify the date on which the fiscal year ends o ORACLE Type of Retirement Plan Optional Select the type of IRA Note This field will be applicable to those Product Types for which you have selected the option Yes against the field IRA Applicable Retirement Age at which Surrender required Optional Specify the age at which the Policy Holder must surrender the policy Prod Remarks Optional You may enter remarks on the Product if necessary Reinvest IRA Income Optional Select the option Yes to indicate the income from IRA Plan is to be reinvested in the same plan Select the option No to indicate the income is to be paid out to the Policy Holder Note This field will be applicable to those Product Types for which you have selected the option Yes against the field IRA Applicable Beneficiary Details Mandatory Mandatory This field will by default be checked During product amendment system checks if there are any policies associated to the product in which case you will not be allowed to uncheck this option Note If this option is checked it is mandatory to specify beneficiary details in the policy mainte nance screen Pay Broker Commission to product Optional Select Yes if pay broker commission is set to the product CGT Applicable Mandatory Select Yes
23. Product Mnemonic Product Country Product Type Product Country Product Type Description Description Product Class Plan Administration By Product Class Plan Administration By Description Description Plan Administrator Plan Administrator Description WHT Applicable P Reinvestment x Product Details Additional Inv Bank Det Withdrawals PortFolio Mapping Premium And Annuity Loan And Funding AARE Transaction Currency Income Distribution Rule 1of1 Slab Sequence No FromAge ToAge Def Dis Mode Override Allow p Reinvest Into Same Fund Yes Input by DateTime Mod No Authorized by Open DateTime Authorized Slab Sequence No Mandatory Specify the sequence of the age slab From Age and To Age Mandatory Specify the ages between which the distribution mode you select will be applicable Def Dis Mode Mandatory Specify whether the dividend income distributed will be reinvested or paid out The option you select will be valid between the From Age and To Age you have specified Override Allow Mandatory If you select the option Yes you will be allowed to override the distribution mode that you have specified for the Policy Holder through the Income Distribution SetUp screen Transaction Currency Tab An LEP product can support multiple currencies The base currency of the policy can be any of the currencies supported by the product If the pro
24. Round off Truncate Mandatory Indicate the rounding options for the load amount for the selected transaction type for the product e Choose Round Up to indicate rounding the value at the precision decimal place to the next higher numeral e Choose Round Off to indicate normal rounding at the precision decimal e Choose Round Down to indicate truncation of the value at the precision decimal place VAT Applicable Mandatory Select Yes in this field to indicate that the Load to Price is applicable Therefore VAT Load to Price is dependent on Load to Price Slab Basis Optional Indicate the basis on which the slabs will be reckoned for an amount based load that you are designating as applicable for the product You can indicate that the slabs must be reckoned on either a gross amount or a net amount Price Add In Mandatory Select this option to indicate that the add in factor is to be applicable for computing the return value for the load for the selected transaction type The add in factor is used to arrive at the return value for a load at the time of allocation Level ID Optional Indicate the order in which the load is to be applied Load is computed based on the policy transaction amount and applied in the order of level id specified Note Level ID is not applicable for LTP loads Dependent Level Optional Indicate the dependent level for the selected load if any In case the load has a dep
25. Section 3 3 1 Retrieving a Record in Transaction Sub Type Maintenance Summary Screen Section 3 3 2 Editing Transaction Sub Type Maintenance Record Section 3 3 3 Viewing Transaction Sub Type Maintenance Record Section 3 3 4 Deleting Transaction Sub Type Maintenance Record Section 3 3 5 Authorizing Transaction Sub Type Maintenance Record Section 3 3 6 Amending Transaction Sub Type Maintenance Record Section 3 3 7 Authorizing Amended Transaction Sub Type Maintenance Record Retrieving a Record in Transaction Sub Type Maintenance Summary Screen You can retrieve a previously entered record in the Summary Screen as follows Invoke the Transaction Sub Type Maintenance Summary screen by typing LESSUBTP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button and specify any or all of the following details in the corresponding details Transaction Sub Type Summary amp Search Advanced Search fJ Reset 3 Clear All Search Is Case Sensitive Sub Type az Records per page 1 of 1 50 Lock Columns Ofe Authorized Open Ref Type Transaction Type Sub Type Sub Type Description The status of the record in the Authorization Status field If you choose the Blank Space option then all the records are retrieved The status of the record in the Record Status field If you choose the Blank Space option then all records are retrieved
26. Tax Class Maintenance Summary screen Viewing Product Tax Class Record To view a record that you have previously input you must retrieve the same in the Product Tax Class Maintenance Summary screen as follows e Invoke the Product Tax Class Maintenance Summary screen from the Browser e 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 e Specify any or all of the details of the record in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to view in the list of displayed records The Product Tax Class Maintenance Detail screen is displayed in View mode Deleting Product Tax Class Record You can delete those records with Once_Auth is set as N For instance if Record is Created and Authorized Later and amended then you cannot delete the amended record if tanking is NOT enabled If Tanking is enabled you can delete the amended record To delete a record that you have previously entered e Invoke the Product Tax Class Maintenance Summary screen from the Browser 20 ORACLE e Select the status of the record that you want to retrieve for deletion e Specify any or all of the details in the
27. 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 Product Entity 1 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 2 Invoke the Product Entity Summary screen from the Browser os ORACLE 3 Select the status of the record that you wish to retrieve for amendment You can only amend records that are authorized 4 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 5 Double click the record that you want to amend The Product Entity screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record 6 Amend the necessary information Click the Save button to save your changes 5 4 8 Authorizing Amended Product Entity An amended Product Entity 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 Modul
28. be done from Fund Manager Module and Agency branch Module The process of authorization is subsequently the same as that for normal transactions id ORACLE 9 General Ledger Set Up Oracle FLEXCUBE Investor Servicing provides the facility to set up a General Ledger for the purpose of generating accounting entries that would be passed at each event in the life cycle of a transaction For Life and Endowment Products you can set up a GL template for the following Business Events e New Investment e Monthly Charges Periodic Fees e Income Distribution e Withdrawals e Top Up e Premium e Annuity e Policy Transfer e Policy Switch e Policy Switch SI This chapter contains the following sections e Section 9 1 General Ledger Template Setup 9 1 General Ledger Template Setup This section contains the following topics e Section 9 1 1 Invoking the General Ledger Template Setup Screen l ORACLE 9 1 1 Invoking the General Ledger Template Setup Screen Given below is the General Ledger Template SetUp screen You can invoke the GL Template Detail screen by typing UTDGLTMP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button GL Template Detail i New 4 Enter Query Template Details Template ID Template Description Business Event Trigger Event Theoretical Entries GL Currency Product Level Apply Com
29. corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to delete in the list of displayed records The Product Tax Class Maintenance screen is displayed e Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database 3 8 5 Authorizing Product Tax Class Record e An unauthorized Product Tax Class Maintenance record must be authorized in the system for it to be processed To authorize a record e Invoke the Product Tax Class Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Product Tax Class Maintenance Detail screen is displayed Select Authorize operation from the Action List When a checker authorizes a record details of validation 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
30. currencies the load amounts for the individual funds are converted to policy base currency before the CMA transaction 10 4 ORACLE 11 1 11 1 1 11 Prudential Investment Guidelines The Prudential investment Guidelines allow for the allocation of the fund asset to a set of components This is to provision a facility to the client to select whether the underlying fund allocation should be compliant with the Prudential Investment Guidelines or should follow the standard defined by the Foreign Exchange This chapter contains the following sections e Section 11 1 Prudential Investment Guidelines e Section 11 2 PIGSFOREX Compliance Summary Screen e Section 11 3 PIGS Batch Maintenance e Section 11 4 PIGS Batch Maintenance Summary Prudential Investment Guidelines This section contains the following topics e Section 11 1 1 Prudential Investment Guidelines Description e Section 11 1 2 Maintaining Prudential Investment Guidelines e Section 11 1 3 Invoking PIGS FOREX Compliance Screen Prudential Investment Guidelines Description Prudential Investment guidelines define the standards for total Onshore cash of the client PIGS Forex compliance is applicable for Initial Investment Policy Top Up Policy Surrender and Switch Transactions For example let us consider a product mapped to the funds F1 and F2 The asset allocation for fund F1 is e Onshore Cash 25 e Onshore Equity 40 e Onsho
31. e Invoke the Product Annual Annuity Limit Summary screen from the Browser e 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 e Specify any or all of the details in the corresponding fields to retrieve the record that is to be modified e Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen e Double click the record that you want to modify in the list of displayed records The Product Annual Annuity Limit Detail screen is displayed e Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The Product Annual Annuity Limit Detail screen is closed and the changes made are reflected in the Product Annual Annuity Limit Summary screen Viewing Product Annual Annuity Limit Record To view a record that you have previously input you must retrieve the same in the Product Annual Annuity Limit Summary screen as follows e Invoke the Product Annual Annuity Limit Summary screen from the Browser e 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
32. e Specify any or all of the details in the corresponding fields to retrieve the record that is to be modified e Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen e Double click the record that you want to modify in the list of displayed records The PIGS Batch Maintenance Detail screen is displayed e Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The PIGS Batch Maintenance Detail screen is closed and the changes made are reflected in the PIGS Batch Maintenance Summary screen Viewing PIGS Batch Maintenance Record To view a record that you have previously input you must retrieve the same in the PIGS Batch Maintenance Summary screen as follows e __ Invoke the PIGS Batch Maintenance Summary screen from the Browser e 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 e Specify any or all of the details of the record in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to view in the list of displayed records The PI
33. in the corresponding fields on the screen and click Search button All transactions 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 Product Type screen is opened in view mode Deleting Product Type 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 Product Type Summary screen as follows 1 Invoke the Product Type 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 Product Type 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 Product Type 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 Product Type Summary screen
34. its affiliates 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 cesccsics cas cececccecdacee te tesscceccncscsucvaneapecndcenscanecentcapseceeceeedet 1 1 LIS Produch aea a aR EEEE eden TAAT I eee eee at 1 1 12 Related DOCUMOMUS 2c cece cecceceeeced eevee cneeeeesdhcenedessuhecaseceddheeseeeddensnedendddheeeededvnees 1 1 WS SAUGIONCO gs ciecte cits E eee inte EE tients iaat ben Tale 1 1 Tt OrGaniZzatlons er sie ded AE eased ena A Gate Gh ga Rane 1 1 1 5 Conventions Used in this Manual cccccceeeeeeeeeeeeeecneeeeeeeaeeeeeeenaaeeeeeeenaeeeenenaaes 1 2 1 5 1 General CONVENTIONS 1scccccscceceeeetenseececneeeseneececeetessaaeecseeeeeseaeesseneeesenaseees 1 2 1 5 2 Keyboard CONVENTIONS ceccceceseececeneeeceneeceneeeeseneeeceeseseneeetedanetsnseeeenenetees 1 2 WOS lt Glossary OL ICONS raai iini EE AAAI ARERR died 1 2 1 7 Abbreviations and ACronys ccccccceeeeeeeeeeeeceeeeeeeenaaeeeeeeeaaeeeeeeecaeeeeeseeneeteeeeeaas 1 3 tS Gating Ham on E E EA 1 4 Product GlASS a a e e a a a a aa Ar aan ra eaaa aaa iosop poop p aaiae aa Eae 2 1 241 Product Ulass nean aAA ENSE VEE AA EEA E EAEE 2 1 2 1 1 Maintaining Product ClASS 2 ccccecccccectcecseseececeeeecenaneseneeecedenseteenetsnnteteas 2 1 Product Type s sala A ete tl oleae en Stole a end 3 1 Sell Produet Typ nina a a E NEEE sandtag
35. 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 Product With Holding Tax 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 Product With Holding Tax Detail screen is closed and the changes made are reflected in the Product With Holding Tax Summary screen Viewing Product With Holding Tax To view a Product With Holding Tax you have previously entered you must retrieve the same in the Product With Holding Tax Summary screen as follows 1 Invoke the Product With Holding Tax 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 66 ORACLE 6 2 5 6 2 6 6 2 7 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
36. must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Agency Branch module The subsequent process of authorization is the same as that for normal transactions Ve ORACLE 12 Function ID Glossary L LEDMGMAP 0 ee 8 2 LEDPAALM 0 4 39 LEDPIGB siiiiiwicetneutes 11 8 LEDPNFM 0 ee 3 13 LEDPRDEN 5 11 EEDPRED ststitccsstandeniaticaes 5 2 LEDPROD sireci iandae 4 2 LEDPRSUB siisii uisi 4 34 LEDPRTAX noiiire 3 18 LEDPRTYP nsession 3 2 LEDPWHTD nosies 6 2 LEDSUBTP sisirin 3 6 LESMGMAP osise 8 3 LESPAALM onnie 4 41 LE SPIGB siiiu 11 10 LESPNEM sriuiirissraisigineiiss 3 15 LESPRDEN 0 5 12 LESPRUD sosida 5 7 LESPROD ee 4 30 LESPRSUB visited 4 35 LESPRTAX eee 3 19 LESPRINP scsstsacctecsttccaeds 3 10 LESPWHTD 0 ee 6 5 LESSUBTP ee 3 7 U UTDCMABBP ee 10 3 UTDGLTMP ee 9 2 UTDPERLM ieusi 7 1 UTDPIGSC ou 11 3 UTSPIGSC oe 11 5 12 1 ORACLE
37. obtaining the life cover for any policy held by him in this Product Note This field is enabled only if you have selected the option Life Cover Applicable Annuity Tax Computation Basis Optional If the Withholding Tax Applicable for Annuity is selected you can select the annuity tax computation basis from the drop down list as Policy or Policy Holder If the maintenance for Annuity Tax Basis at the product level is at policy holder the gross annualized amount for all policies pertains to the Policy Holder gets added up for a Product If it is at Policy level gross annualized amount of the Policy level would be taken Loan and Funding Details Tab You will be able to see this link only if for the product you have selected the option Yes against the field Funding Features Supported in the Product Type Maintenance screen The funding rules that you specify in this screen are valid only till the maturity date of the product wee ORACLE Click Loan amp Funding tab to enter the details New 5 Enter Query Product Information Product ID Product Name Product Short Name Product Mnemonic Product Type Product Type Description Product Class Product Class Description Fatch Product Tyne Info Product Maintenance Detail Existing Product No Rule Effective Date Product Base Currency Currency Name Product Country Product Country Descript
38. of units Allocation time loads cannot be designated for any transaction types other than IPO subscription redemption and switch e Post Allocation This frequency is applicable typically to the Capital Gains Tax which may be applied after allocation on the gross amount If indexation is applicable to capital gains tax computation based on this load then you must select this frequency Apply To Product Optional You can apply the load at the product level by selecting Yes If load is applied at the product level then the load is computed based on the policy transaction amount If you select No the load will be computed based on the fund transaction amount Note Apply to Product is applicable only for NLTP loads This optional is not applicable for Switch In transactions and LEP interest transactions To set up the other load maintenance details for a product use the Product Load Maintenance Other Details screen You can invoke this screen by clicking Show Details button from the Product Load Maintenance screen Rule Effective Date Specify the rule effective date from the adjoining calendar 4 ORACLE Latest Rule Choose one of the following from the drop down list to indicate if it is latest rule e Yes e No No of Decimals 1 Character Maximum Numeric Mandatory Indicate the maximum number of decimals that would be reckoned for rounding precision for the load amount
39. 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 Management Fee Applicability 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 Management Fee Applicability 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 Management Fee Applicability Summary screen 1 Invoke the Management Fee Applicability 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 Management Fee Applicability Detail screen is opened in View mode
40. 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 Deleting Product With Holding Tax 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 Product With Holding Tax Summary screen as follows 1 Invoke the Product With Holding Tax 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 Product With Holding Tax 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 Product With Holding Tax 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 Product With Holding Tax Summary screen 1 Invoke the Product With Holding Tax Summary screen from the Browser 2 Select the status of the record that you wa
41. specified criteria The status of the records in the Open field If you choose the blank space then all the records are retrieved e Click Search button to view the records All records with the specified details are retrieved and displayed in the lower portion of the screen Editing Product Tax Class Record You can modify the details of Product Tax Class record that you have already entered into the system provided it has not subsequently authorized You can perform this operation as follows e Invoke the Product Tax Class Maintenance Summary screen from the Browser e 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 e Specify any or all of the details in the corresponding fields to retrieve the record that is to be modified e Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen e Double click the record that you want to modify in the list of displayed records The Product Tax Class Maintenance Detail screen is displayed e Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The Product Tax Class Maintenance Detail screen is closed and the changes made are reflected in the Product
42. the Product Type 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 Product Type 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 Product Type Detail screen is closed and the changes made are reflected in the Product Type Summary screen Viewing Product Type To view a Product Type you have previously entered you must retrieve the same in the Product Summary screen as follows 1 Invoke the Product Type Summary Screen from the Browser 2 Select the status of the Product Type 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 oi ORACLE 3 4 5 3 4 6 3 4 7 3 Specify any or all of the details of the records
43. the chosen investment component specified as an allocation of the investment Components Button Components Alphanumeric 8 Characters Optional Specify the number of components allocated to the fund investment you can select more than one component To incorporate the Investment components click Components button You will be linked to the Investment Components screen You can select the combination of Investment components with their corresponding percentage Refer to the chapter Fund Investment Components for more information on specifying fund components for an investment Related Components Button Related Components Alphanumeric 8 Characters Optional Specify the number of related components allocated to the fund investment you can select more than one related component Once you have specified the entire mandatory details click Ok button to save the record You will receive a prompt that the record has been saved in the system s archive Validating PIGS and FOREX The system will validate PIGS and FOREX for Outflow policy transactions along with inflow transactions the such as surrender and switch out If system fails to comply these two outflow transactions it will log the failure as an override message while saving the policy transaction PIGSFOREX Compliance Summary Screen This section contains the following topics e Section 11 2 1 Invoking the PIGSFOREX Compliance Summary Sc
44. to be processed To authorize a record Invoke the Product Nature of Fund Mapping Summary screen from the Browser Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option Specify any or all of the details in the corresponding fields on the screen i ORACLE 3 6 6 3 6 7 3 7 3 7 1 e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Product Nature of Fund Mapping Detail screen is displayed Select Authorize operation from the Action List When a checker authorizes a record details of validation 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 Product Nature of Fund Mapping Record After a Product Nature of Fund Mapping record is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the Product Nature of Fund Mapping Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details in the corresponding fields on the screen e Click Search button
45. 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 record in the corresponding fields on the screen Click Search button All records with the specified fields 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 The Product Nature of Fund Mapping Detail screen is displayed in View mode 3 6 4 Deleting Product Nature of Fund Mapping Record You can delete only unauthorized records in the system To delete a record that you have previously entered Invoke the Product Nature of Fund Mapping Summary screen from the Browser Select the status of the record that you want to retrieve for deletion Specify any or all of the details in the corresponding fields on the screen Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen Double click the record that you want to delete in the list of displayed records The Product Nature of Fund Mapping screen is displayed Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database 3 6 5 Authorizing Product Nature of Fund Mapping Record An unauthorized Product Nature of Fund Mapping record must be authorized in the system for it
46. will calculate Weighted Average Cost WAC as follows LIFE WAC No of units in the fund before inflow WAC before inflow No of units in the inflow for fund Unit Price of inflow Total Units in Fund Where Unit price Net investment amount number of units purchased Net Investment amount Gross investment amount all Fee except the ones which are paid to AMC The net investment amount will not exclude any Fee for which To Entity is AMC The system will deduct any other fee apart from those where To Entity is AMC from the gross investment amount to arrive at the net investment amount Total units in Fund No of units in the fund No of units in the inflow for the fund If you select a product with WAC method as LIFE WAC and if a Switch transaction is done within the same Fund Family and Base Cost is not provided while capturing the transaction then the system will calculate WAC as follows 7 ORACLE Life WAC No of units rolling over WAC in From Fund No of units in the To fund WAC in To Fund Total Units in To Fund Where Total units in To Fund No of units rolling over into To Fund No of units in the To fund The system will calculate Capital Gain or Loss as follows Gain Loss Units surrendered redeemed from Fund Price of fund on the date of Redemption Surrender WAC for fund If there is a gain then Capital Gain Tax ha
47. 1 Invoke the Product Type 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 Product Type 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 Product Type 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 Product Type 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 oz ORACLE 3 4 8 3 5 3 5 1 3 Specify any or all of the details of the record in the corresponding fields on the screen All records with the specified detail
48. 2014 amp AUM Date For Next Batch Run 05 27 2014 amp 1011 vi Product Name Description DEDER x la UCITS PRODUCTI You can specify the following details Product Administrator Alphanumeric 8 Characters Mandatory Specify product administrator details The adjoining option list displays all valid AMC accounts maintained in the system You can choose the appropriate one PIGS Compliance Batch Next Run Date Date Format Mandatory Specify date for running PIGS compliance batch This date cannot be lesser than the application date The system will track the execution date to check if the contracts are compliant or not If the contract is not compliant then the system will increment the failure value by 1 Once the maximum number of count is reached and if it fails again then it just updates the date without its ORACLE incrementing the count The failure count for the policy will be reset to 0 once the contract is successful While doing this computation system needs to consider rounding rules maintained at product level The system will store the failed policies with the failure details like which rule failed and by how much amount failure date portfolio value each component value and asset split in a separate data store for reporting interfacing purposes AUM Date to be considered Date Format Optional Specify the date to be considered for policy AUM computation This date cannot be lesser than the ap
49. 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 a ORACLE 8 2 7 Amending Management Fee Applicability 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 Management Fee Applicability 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 Management Fee Applicability 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 8 2 8 Authorizing Amended Management Fee Applicability An amended Management Fee Applicability must be authorized for the amendment to be made effective in the system Authorization of amended records can only
50. 5 4 8 Authorizing Amended Product Entity 5 4 1 Invoking the Product Entity Summary Screen You can invoke the Product Entity Maintenance Summary screen by typing LESPRDEN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Entity Maintenance Summary Authorized Open Product ID a Entity ID a Entity Type ad Advanced Search Records per page 15 v Authorized Product ID Entity ID Entity Type 5 4 2 Retrieving Product Entity in Product Entity Screen You can retrieve a previously entered record in the Summary screen as follows 1 Invoke the Product Entity Summary Screen from the Browser 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 e Product ID e Entity Type e Entity ID ale ORACLE 5 4 3 5 4 4 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 Type Press F8 You can perform Edit Delete Amend Authorize Re
51. Alternatively you can select the Adjustment Transaction Type from the option list The list displays all valid Adjustment Transaction Type maintained in the system aaa ORACLE Description Display The system displays the description for the selected Adjustment Transaction Type 4 2 Product Summary Screen This section contains the following topics e Section 4 2 1 Invoking the Product Summary Screen e Section 4 2 2 Retrieving Product in Product Screen e Section 4 2 3 Editing Product e Section 4 2 4 Viewing Product e Section 4 2 5 Deleting Product e Section 4 2 6 Authorizing Product e Section 4 2 7 Amending Product e Section 4 2 8 Authorizing Amended Product 4 2 1 Invoking the Product Summary Screen You can invoke the Product Summary screen by typing LESPROD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Summary ER amp search Ct advanced Search Reset 3 clear All Search Is Case Sensitive Authorized W Open E Product ID a5 Product Name az LatestRule r Records per page 13i 1 of 1 Go Lock Columns Ol Authorized Open ProductID ProductName Latest Rule View Changes aran ORACLE 4 2 2 Retrieving Product in Product Screen You can retrieve a previously entered record in the Summary screen as follows 1 Specify any or all of the following details in the Product Summar
52. Description Upon selection of the load id the description of the selected load gets populated automatically From Entity Type Mandatory Specify the entity that bears this load Select the Entity Type from the option list Following list are provided in the option list e AMC e Agent e Broker e Distributor e Fund e Registrar e Trustee e Unit Holder Description Upon selection of the From Entity Type the description of the selected From Entity Type gets populated automatically To Entity Type Mandatory Specify the entity that will be recipients of the load Select the Entity Type from the option ae ORACLE Following list are provided in the option list e AMC e Agent e Broker e Distributor e Fund e Registrar e Trustee e Unit Holder e Cash Management Account Description Upon selection of the To Entity Type the description of the selected To Entity Type gets populated automatically Refer the chapter Policy of this LEP User Manual for more information on the how the Cash Management Account is used in the recovery of fees and annuity Load To Price Mandatory Indicate whether this load is to be loaded to the base price Processing Frequency Mandatory Specify the frequency at which this load is to be applied Loads can be applied at any of two possible frequencies e Allocation This will mean that you will be charging the investor a fee or giving an incentive at the time of allocation
53. EQHING Frout LOAD oor aana obs Gina epee vaaces E ets sbiveae oo R 5 8 2 4 Viewing Product Loa se seen eee es eis 5 8 5 2 5 Deleting Product load ors ruse arer S E EE EO 5 9 5 2 6 Authorizing Product Load 1 cccceceesseceeeeenteeeecesenieeeeceeenieeeesesenineeessenineeees 5 9 5 2 7 Amending Proquct LOG ccccccssseceeeceenneeeeeeeeenieeeeeseneeeesesenieeeesseenineeees 5 9 5 2 8 Authorizing Amended Product LOG ceseececeeneneeeeeeenneeeeeeeenneeeeenennnnees 5 10 5 3 Entities with Products Association cece ceeneeeeeeeeneeeeeeeeenaeeeeeeeaaeeeeeeenaaeeeeeeeaaes 5 10 5 3 1 Associating Entities with Products csccccceesesneeeeeeenneeeeeeetnnnneeeeetnnnneees 5 10 5 3 2 Product Entity Mapping SCr N cccccccceessecceeeeecesseeceeneeeteseeeteneeetsnetens 5 10 5 3 3 INVOKING Sereen or emin ete ted tere pelea ae wel aA A Taaa 5 11 5 4 Product Entity Summary Screen 00 0 0 eeccceeeeceeee eee eecneeeeeeenaeeeeeeeeaeeeeeeenaeeeeeeenaaes 5 12 5 4 1 Invoking the Product Entity Summary SCI CN ccccccccseecesteeeesteeetsnetes 5 12 5 4 2 Retrieving Product Entity in Product Entity Screen 1 cccsccccesseeseneeees 5 12 5 4 3 Editing ProQuct Entity eeri E E E 5 13 5 4 4 Viewing Proguct Entity oio Tenoor ER T 5 13 5 4 5 Deleting Product Entity cecsecccecsessnceeeeenseeeeeeeseneneeeeesnnnneeeesnnnneeeensennneees 5 14 5 4 6 Authorizing Product Entity c cccccccsecceceeeeeneeeee
54. Fund Mapping Hl save Refresh Reset KY Clear an f lpetails Search Is Case Sensitive Authorized Open Product ID Nature Of Fund Records per page 15 1 of 1 Lock Columns ow a Authorized Open Product ID Nature Of Fund PIGS FOREX F Unauthorized Open LEPPRD1 PEN No Yes E Authorized Open LEPPRD1 RA No No F Authorized Open LEPPRD1 PRO Yes Yes F Authorized Open PRDR1 RA No No E Authorized Open PRDR1 PEN Yes Yes F Authorized Open CA PRO Yes No F Unauthorized Open LEPPRD1 APP Yes Yes Unauthorized Open PRDR1 PRO Yes Yes E Authorized Open PRDR1 APP Yes Yes You can retrieve previously entered Product Nature of Fund Mapping Details as follows e Invoke the Product Nature of Fund Mapping screen from the Browser e Specify any or all of the following details in the screen The status of the transaction in the Authorized field If you choose the blank space then both the authorized and the unauthorized status records will be retrieved for the specified criteria The status of the records in the Open field If you choose the blank space then all the records are retrieved Product ID Nature of Fund e Click Search button to view the records All records with the specified details are retrieved and displayed in the lower portion of the screen 3 6 2 Editing Product Nature of Fund Mapping Record You can modify the details of Product Nature of Fund Mapping record that you have already entered into the system
55. GS Batch Maintenance Detail screen is displayed in View mode Deleting PIGS Batch Maintenance Record You can delete only unauthorized records in the system To delete a record that you have previously entered e Invoke the PIGS Batch Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for deletion e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to delete in the list of displayed records The PIGS Batch Maintenance Detail screen is displayed 11 11 ORACLE 11 4 5 11 4 6 11 4 7 e Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database Authorizing PIGS Batch Maintenance Record e Anunauthorized PIGS Batch Maintenance record must be authorized in the system for it to be processed To authorize a record e Invoke the PIGS Batch Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are
56. HT Applicable Reinvestment Product Details Additional inv Bank Det Withdrawals PortFolio Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency Additional Investments Additional Investments Yes Allowed Step Amount Product InvLimit 1of1 A Fund Type Input by Authorized by Minimum Amount Maximum Amount Investment Limit DateTime DateTime 4 12 Mod No Open Authorized ORACLE Additional Investments Section Additional Investments Allowed Mandatory Select this option to indicate the Policy Holder can make an additional investment in a policy in this product Note The other fields in this screen will be enabled only if you select this option Minimum Amount Mandatory Specify the minimum additional investment amount Maximum Amount Mandatory Specify the maximum amount to which an additional investment can be made Step Amount Numeric Optional Enter a value that indicates the steps of initial investment amount in which a Policy Holder can invest to subscribe to a policy in this Product For example it could be that some products support only steps of 500 currency units while some other will support steps of 100 currency units Product InvLimit Section Product InvLimit 1of1 Fund Type Description Investment Limit In the Investment Limit section you can enter information in the following fields Fun
57. LEP Product Setup User Guide Oracle FLEXCUBE Investor Servicing Release 12 1 0 0 0 Part Number E67272 01 October 2015 ORACLE LEP Product Setup User Guide October 2015 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 2015 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 inhere
58. No Product ID Rule Effective Date Product Name Product Base Currency Product Short Name Currency Name Product Mnemonic Product Country Product Type Product Country Product Type Description Description Product Class Plan Administration By Product Class Plan Administration By Description Description Plan Administrator Plan Administrator Description WHT Applicable Reinvestment M Product Details Additional inv BERME Withdrawals PortFolio Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency Bank Details 1of1 Bank Branch Account Type Description Account Currency Currency Name Account Number Input by DateTime Mod No Authorized by Open DateTime Authorized Bank Details Section Bank Mandatory Select the name of the bank where the Product account resides from the option list ate ORACLE Branch Mandatory Select the name of the branch of the bank where the Product account resides from the option list Account Type Mandatory Select the type of the Product account from the option list Account Currency Mandatory Select the currency of the Product account from the option list Account Number Mandatory Specify the account number of the Product account Default Bank Mandatory Select this option to indicate this is the default bank account You will need to specify one default bank account f
59. actor that is applicable to policy transactions in this Product This must be expressed as a percentage and cannot exceed one hundred percent Note You will be allowed to change this at the policy creation level for the initial contribution and then at the transaction level for top ups Loans Section Loan Applicable Select Yes if Loan is applicable else No Geared Loan Factor Enter the geared loan factor No of Loan Allowed Enter the number of loans allowed Minimum Loan Amount Enter the minimum loan amount Maximum Loan Amount Enter the maximum loan amount Loan Interest Percent Enter the loan interest percent Redeem Loan Interest from holdings Enter the redeem loan interest from holdings Income Distribution Rule Tab You will be able to see this link only if for the product you have selected the option No against the field Reinvest IRA Income As you have specified that the IRA income should not be reinvested you will need to specify the income distribution You are allowed to specify different distribution modes depending on the age of the Policy Holder 4 24 ORACLE 4 1 11 i New 7 Enter Query Product Information Product Maintenance Detail Click Income Distribution Rule tab to enter the details Existing Product No Product ID Rule Effective Date Product Name Product Base Currency Product Short Name Currency Name
60. ad A reference has been made to a chap ter in the Fund Manager User Manual where Periodic Load has been Chapter explained There is a difference in the way periodic load is maintained for UT transactions and Policies This chapter highlights the same Chapters LEP Product Setup Management Fee Applicability may be referred to p only if a Management Fee is to be applied to a Product LEP Product Setup GL Set Up A reference has been made to a chapter Chapter 10 in the Fund Manager User Manual where the General Ledger Set Up has been explained Chapter 11 LEP Product Setup CMA explains more about CMA Chapter 12 LEP Product Setup PIGS explains in detail Prudential Investment Guide lines and Forex Compliance 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 keys are contained in brackets For example keys lt ALT SHIFT gt Glossary of Ico
61. ail Screen You can invoke the Product With holding Tax Detail screen by typing LEDPWHTD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product With holding Tax Detail les Save Product Withhold Tax Product ID Z Load ID Product Name Load Description Effective Date Age Limit Applicable for Rebates Yesim Applicable for CGT E aiciceeLiciey Tax Class Details Details 1 of 1 Age From Age To Rebate Amount x Input by DateTime Mod No Open Authorized by DateTime Authorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Product WHT Setup You can enter the following details in this screen WHT Product Load Mapping Section In the WHT Product Load Mapping section you will have to enter information in the following fields Product ID Mandatory Select the Product for which the tax on annuity details needs to be captured from the drop down list Load ID Mandatory Select the load corresponding to with holding tax from the drop down list Effective Date Mandatory Specify the date from which the tax details captured in this screen are effective 2 ORACLE Age Limit Applicable for Rebates Mandatory Select Yes to indicate an age limit constraint is applicable for eligibility for rebates on the tax Note If y
62. al Investments Select Yes if you wish to restrict initial investments for the CMA Fund Else select No Redeem Periodic Fee from CMA Fund Select Yes if you want the system to treat the specified CMA fund as the preferred fund for periodic fee redemptions Else select No If you have chosen this option then system would treat CMA Fund as preferred fund for periodic fee redemptions provided no preferred fund is selected at Policy Level Refer the section Annexure for CMA in the chapter Policy in this User Manual for details on the operation of Cash Management Account Calculating Capital Gain Tax Capital Gain Tax CGT calculations are applicable only for Funds Since the fund prices are declared gross of CGT the system will deduct CGT by the Life Company when a CGT event occurs that is when sale of units happens which can be due to surrender disinvestments or switches The system will calculate CGT as follows Capital Gain Tax Gains or Profit Proportionate Loss from other Funds Tax Rate Where Gain or Profit Units Sold Price as of Disinvestment Date WAC WAC Weighted Average Cost Post Unitiation CGT fee will be computed and deducted for all outflows based on the CGT load mapping If there is any loss CGT will be zero and losses will be carry forwarded to offset against any future profit gain Transaction level losses will be added to the Carry Forwarded losses at policy le
63. anges The Management Fee Applicability Detail screen is closed and the changes made are reflected in the Management Fee Applicability Summary screen es ORACLE 8 2 4 8 2 5 8 2 6 Viewing Management Fee Applicability To view a Management Fee Applicability you have previously entered you must retrieve the same in the Management Fee Applicability Summary screen as follows 1 Invoke the Management Fee Applicability 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 Management Fee Applicability screen is opened in view mode Deleting Management Fee Applicability 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 Management Fee Applicability Summary screen as follows 1 Invoke the Management Fee Applicability Summary screen from the browser 2 Select the status of the
64. ansaction Sub Type Mapping 4 4 1 Invoking Product Transaction Sub Type Mapping Summary Invoke the Product Sub Type Mapping Summary screen by typing LESPRSUB in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Sub Type Mapping Summary Authorized Open Product ID aJ Ref Type Advanced Search Reset Records per page 15 v 1 of 1 Authorized Open Product ID Ref Type Product Name Product Short Name 4 4 2 Retrieving Product Transaction Sub Type Mapping You can retrieve a previously entered record in the Summary screen as follows 1 Invoke the Product Transaction Sub Type Mapping Summary screen from the Browser 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 Product ID 5 Ref 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 aa ORACLE 4 4 3 4 4 4 4 4 5 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 A
65. arch 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 Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping Summary screen 1 Invoke the Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping Detail screen is opened in View mode 5 Select Authorize operation from Action list When the checker authorizes a record details of validations if a
66. as that for normal transactions oe ORACLE 4 Product Each of the Life and Endowment Products that the Life and Endowment Company provides to the Policy Holders must be defined in the Oracle FLEXCUBE Investor Servicing FCIS system The Policy Holders buy policies in any of these products depending upon their need and requirements Note Products can be defined through the Fund Manager component only The Product Maintenance screen allows you to capture the generic characteristics of the Product you wish to maintain The next section gives you step by step instructions to do the same This chapter contains the following sections e Section 4 1 Product Definition e Section 4 2 Product Summary Screen e Section 4 3 Product and Transaction Sub Type e Section 4 4 Product Transaction Sub Type Mapping Summary e Section 4 5 Product Annual Annuity Limit Mapping e Section 4 6 Product Annual Annuity Limit Summary 4 1 Product Definition This section contains the following topics e Section 4 1 1 Creating and Saving Product e Section 4 1 2 Invoking Screen e Section 4 1 3 Product Details Tab e Section 4 1 4 Additional Investments Tab e Section 4 1 5 Bank Details Tab e Section 4 1 6 Withdrawal Tab e Section 4 1 7 Portfolio Mapping Tab e Section 4 1 8 Premium and Annuity Details Tab e Section 4 1 9 Loan and Funding Details Tab e Section 4 1 10 Income Distribution Rule Tab e Sectio
67. ation click Ok button The system displays the confirmation message as Record Successfully Saved This indicates the record has been saved Click Ok button 26 ORACLE 4 1 12 FATCA Information Tab In this section you can capture the details regarding Foreign Account Tax Compliance Act Click on FATCA Information tab to maintain the details Product Maintenance Detail X sve Product Information powt Eising Prout Ny Product Name Product Base Currency i i Rule Effective Date B Currency Name Product Shot Name Y Q Product County W Product Mnemonic Product County Description Q Product Type ins Plan Administration By as Product Type Description Q Plan Administration By Description Product Class H Plan Administrator H Product Class Descrgtion p Plan Administrator Description g Fetch Product Type Info Product Details Additional Investments Bank Details Withdrawals Portfolio Mapping Premiurn And Annuty Loan And Funding Income Distribution Rule Transaction Currency A0 tuite Regulation 28 parameters FATCA Aicatie NO EnplyerOvunbereny FATCA Classification Description FATCA Reason FATCA Effective Date E DateTime Modo Open DateTime Authorized You can specify the following information FATCA Applicable Alphanumeric Optional Select Yes or No to indicate whether FATCA is applicable Howe
68. ation top up withdrawal status change and premium annuities to create a localized field to capture the relevant data This screen is designed to include an input list of transaction sub types applicable for a variety of transactions You can specify the relevant details according to the type of action you choose to proceed with on this screen 39 ORACLE 3 2 2 Invoking Screen You can invoke the Transaction Sub Type Maintenance Detail screen by typing LEDSUBTP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Transaction Sub Type Maintenance Detail ransaction Sub Type Maintenance Ref Type Transaction Type Description Transaction Name some SubType Description A Input by DateTime Mod No Open Authorized by DateTime Authorized The following fields require input Reference Type Mandatory Select the type of Policy transaction for which the sub type is applicable Transaction Type Display The type of Unit Trust UT transaction is defaulted by the system based on the current transaction under processing Sub Type Mandatory Specify the sub type code after entering the transaction type for which the Sub type transaction is processed Sub Type Description Mandatory Specify the description of the sub type selected oe ORACLE 3 3 3 3 1 Transaction Sub Type Maintenance Summary This section contains the following topics
69. changed except for when the client elects to move to a lower percentage than the initial lower bound Hence the client s Policy Start date stipulates the allowable lower and upper boundaries For instance if a client has taken out a Policy on 1 Jan 2000 when the range was 5 to 20 and the range has changed on 1 Mar 2007 to 2 5 to 12 the client may still choose a percentage between 5 and 20 today except for the case shown below Ifa new upper and lower boundary is declared and the new lower boundary is lower than the lower boundary for the Policy Start date product and age the client may elect to select a percentage in the new range that is lower than the original lower boundary but then the client may not revert back to the higher percentages associated with the earlier Policy start date For instance if a client has taken out a Policy on 1 Jan 2000 when the range was 5 to 20 and the range has changed on 1 Mar 2007 to 2 5 to 12 and the client elects a percentage of 3 on 1 April 2007 the client may not revert back to a percentage greater than 12 and less than 20 on the next anniversary date say on 20 on 1 April 2008 To drive annuity ranges the system will compare Effective Start Date and End Date with rule effective date of the policy if annuity is already generated Also policy start date should be less than the effective end date If the annuity is not generated till date then the system will compare Eff
70. checker must reject the record 3 8 6 Amending Product Tax Class Record After a Product Tax Class record is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the Product Tax Class Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Product Tax Class Maintenance Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes Note Product Tax Class Maintenance will be not be allowed to be amended if there exists a Pol icy with this tax class combination of UH category and product ID 3 8 7 Authorizing Amended Product Tax Class Record An amended Product Tax Class record must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Agency Branch module oe ORACLE The subsequent process of authorization is the same
71. cify the maximum age after which a customer cannot take a policy under a product of this Product Type Minimum Age for Exit Mandatory Specify the minimum age before which a customer cannot close a policy under a product of this Product Type Maximum Age for Exit Mandatory Specify the maximum age after which a Policy Holder is not allowed to have holdings in the product Allow Unit Based Transactions Select Yes if you want to allow unit based transactions Specifying 120 Rule Mandatory 120 rule is made available at Product level to select list of transaction types that are applicable for 120 rule validation The rule also validates the Top Up Debit order function of an application that needs to be processed This tab is applicable only if you set Apply 120 Rule as Yes Included Transaction Sub Types section Tununig i cowie Cuppuncu Included Transaction Sub Types 1of1 Transaction Sub Type Description ORACLE 3 2 3 2 1 The inflow transactions sub types are selected from the available list You can click add icon to add Transaction Sub Type The type of transactions can be selected from the option list The description for the selected transaction is provided in the Description field Note Ifyou do not select any of the available transaction sub types for 120 Rule then system will consider all transactions subtypes for 120 Rule validation Ift
72. cord in PIGS Batch Maintenance Summary Screen 11 9 11 4 2 Editing PIGS Batch Maintenance R COLMO cccccccscccceteeeesseeeneeseeeaes 11 11 11 4 3 Viewing PIGS Batch Maintenance R COIC cccccccsscessnseesteeeeeseeetees 11 11 11 4 4 Deleting PIGS Batch Maintenance Record 2 cccccecesenteeteteeteeeeeetnaes 11 11 11 4 5 Authorizing PIGS Batch Maintenance R COIGC ccccccccsssseseeteeteees 11 12 11 4 6 Amending PIGS Batch Maintenance Record ccccccccceceesteeeesteetses 11 12 11 4 7 Authorizing Amended PIGS Batch Maintenance Record 0cc0 11 12 12 Function ID Glossary cissec lec cosscecsecececcadeds tele seciccdlenidetacecacettecccecedectiateiecce 12 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 an
73. d Type Mandatory Select the funds from the option list in which the Policy Holder can make an additional investment You can specify the details of more than one fund by clicking add icon which adds a field wherein you can choose another fund Investment Limit Mandatory For each fund specify the ratio in which the additional investment is allowed to be made ats ORACLE 4 1 5 Note The sum total of the ratio you enter should add up to 100 When a Policy Holder makes an additional investment in a policy the system will calculate the holding in the funds belonging to the fund type for which you have specified an investment limit If the current holdings plus the new investment exceed the investment limit you have specified the system will not allow the Policy Holder to make an additional investment in funds belonging to this fund type Bank Details Tab In certain cases the proceeds of payments such as collection of management fees surrender at a policy level to handle exceptional situations like death and so on may need to be made to a default product bank account and not to the Policy Holder bank account Several bank accounts can be associated with a product Note This section is mandatory You will have to enter information in all fields Click Bank Det tab to enter the details Product Maintenance Detail New Enter Query Product Information Existing Product
74. d in the system for it to be processed To authorize a record you must first retrieve the same in the PIGSFOREX Compliance Summary screen 1 Invoke the PIGSFOREX Compliance 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 PIGSFOREX Compliance 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 PIGSFOREX Compliance 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 PIGSFOREX Compliance 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 author
75. d mapped as part of the product periodic load mapping for ongoing admin and broker fees Both fees should be defined as Level 1 loads e The load mapped above enables the system to project the ongoing fees for the year deduct the same proportionately from the investment and invest it in the CMA This ensures that the balance in the CMA fully meets the ongoing fees requirement e You can choose whether or not loads should be applicable for transactions in the Cash Management Account fund If you choose not to maintain any you need to have criteria based loads to indicate to the system that the CMA should be excluded from ongoing and initial fee calculations for both admin and broker fee 10 1 ORACLE The loads for a CMA transaction will be ROA applicable and be chosen on the basis of the value of the transaction in case of an initial investment or on the basis of the market value of an investor in case of an existing investor doing a top up The system will not consider VAT for a Unit holder for CMA type of loads The system considers all policies on which the ongoing fees have been calculated as part of allocations on a certain date 10 1 2 CMA Operations The various operations in a CMA are as follows When an initial investment in a policy takes place the ongoing fees for the investment are calculated as part of the allocation process These are deducted proportionately from the investment made for each fund and invested into
76. d system operators in the AMC Organization This volume of the Fund Manager User manual is organized under the following chapter sequence Chapter Description About This Manual explains the structure audience organization and Chapter 1 related documents of this manual LEP Product Setup An Overview enables you learn about the LEP Prod Chapterz uct Setup LEP Product Setup Product Class deals with the first step in the work Chapter 3 flow A reference has been made to a chapter in the Fund Manager User Manual where the process has been explained LEP Product Setup Product Type explains the second step in the work Chapter 4 flow Once you have maintained Product Classes the next step is to define various Products Types LEP Product Setup Product explains how to maintain Products under Chapters which a customer would buy a Policy LEP Product Setup Other Product Activities explains the process of set Chapter 6 ting up applicable fee or incentives for a product which in turn impacts the processing of transactions in the product It also deals with mapping enti ties to a product LEP Product Setup Product With Holding Tax You may refer to this chap Chapter 7 ter if for a Product you want to capture the details of tax applicability on annuity payments 1 1 1 5 1 5 1 1 5 2 1 6 Chapter Description LEP Product Setup Periodic Lo
77. 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 Type 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 and so forth 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 Product Load 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 Product Load 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 opti
78. duct and policy base currencies are different and if the load is maintained at product level the policy transaction amount in product base currency is used to derive the load slab You also need to maintain product base currency in the transaction currency list aes ORACLE You can maintain the list of currencies supported by the product in Transaction Currency tab Product Maintenance Detail el Save Product Information Product O Product Name Bising Prout Ny a a Rule Effective Date Currency Name Product Short Name Product ooty BB Product Mnemonic Product County Description 9 Prd ie i a a E Product Type Description p Plan Administration By Description 9 Plan Administrator Plan Administrator Deseripti as f ok Product Deals Atonelnvesiments Bark Details Wiha Portola Mapping PremiumAndAnnuty Loan And Funding Income Dishibution Rule WAERSEMMIMaMcs FATCA Information Regulation 28 parameters Transaction Currency dioi 3 in Cunenty Code Cuneny Name 7 H Input by Mod No Authorized by You can specify the following details in this screen Currency Code Mandatory Specify the currency supported by the LEP product or select the currency from the option list provided Currency Name The name corresponding to the currency code selected previously gets displayed here Saving the information entered When you have entered all the mandatory inform
79. e The process of authorization is subsequently the same as that for normal transactions Fy ORACLE 6 1 6 Product With Holding Tax The system provides the facility of capturing the details of tax applicability on annuity payments Note With Holding Tax Products can be defined through the Fund Manager component only The With Holding Tax Product Load Mapping screen allows you to capture the characteristics of the With Holding Tax Product you wish to maintain The next section gives you step by step instructions to do the same This chapter contains the following sections e Section 6 1 With Holding Tax Product e Section 6 2 Product With Holding Tax Summary Screen With Holding Tax Product This section contains the following topics e Section 6 1 1 Creating and Saving With Holding Tax Product e Section 6 1 2 Invoking Product With holding Tax Detail Screen e Section 6 1 3 Rebate Details Tab e Section 6 1 4 Tax Class Details Tab e Section 6 1 5 Saving information Entered Creating and Saving With Holding Tax Product The following are the steps you need to follow to define a With Holding Tax Product Each of these steps is explained in detail in subsequent sections e Invoke the With Holding Tax Product Load Mapping screen e Enter information in the With Holding Tax Product Load Mapping screen e Save the information entered 6 1 ORACLE Invoking Product With holding Tax Det
80. e Actions menu in the Application tool bar or click new icon to enter the details of the Product Entity mapping Product ID 10 Characters Maximum Alphanumeric Mandatory Select the product for which you want to map entities from the options provided If you specify the product the description of the selected product is displayed in the Description field Entity Type Alphanumeric Mandatory You can use this field to indicate the type of entity that is to be associated with the selected product You can associate any of the following entities from the option list e Agent e Participating Employer Entity ID Mandatory Select the code of the entity that is to be allowed to operate this product from the options provided It could be an agent or a participating employer Entity Name Display Only On selection of the Entity Code the system automatically displays the name of the entity PH ORACLE When you enter a product entity mapping in this screen you can save it by clicking Ok button 5 4 Product Entity Summary Screen This section contains the following topics e Section 5 4 1 Invoking the Product Entity Summary Screen e Section 5 4 2 Retrieving Product Entity in Product Entity Screen e Section 5 4 3 Editing Product Entity e Section 5 4 4 Viewing Product Entity e Section 5 4 5 Deleting Product Entity e Section 5 4 6 Authorizing Product Entity e Section 5 4 7 Amending Product Entity e Section
81. ecker authorizes a record details of validation 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 3 3 6 Amending Transaction Sub Type Maintenance Record After a Transaction Sub Type Maintenance record is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the Transaction Sub Type Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Transaction Sub Type Maintenance Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes 3 3 7 Authorizing Amended Transaction Sub Type Maintenance Record An amended Transaction Sub Type Maintenance record must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Age
82. ecord 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended Product Load An amended product 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 Entities with Products Association This section contains the following topics e Section 5 3 1 Associating Entities with Products e Section 5 3 2 Product Entity Mapping Screen e Section 5 3 3 Invoking Screen Associating Entities with Products To associate entities with a product use the Product Entity Maintenance Detail screen You can restrict access to entities based on the product Product Entity Mapping Screen To map entities to a product use the Product Entity Maintenance Detail screen a ORACLE 5 3 3 Invoking Screen You can invoke the Product Entity Maintenance Detail screen by typing LEDPRDEN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Entity Maintenance Detail New 5 Enter Query Product Entity Maintenance Product ID Product Name Entity Type Description Entity ID Entity Name Input by DateTime Authorized by DateTime Mod No Open Authorized Select New from th
83. ecord 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 Product Load 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 Product Load 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 Product Load Summary screen from the Browser a ORACLE 5 2 8 5 3 5 3 1 5 3 2 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 Load screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the r
84. ection 5 2 3 Editing Product Load Section 5 2 4 Viewing Product Load Section 5 2 5 Deleting Product Load Section 5 2 6 Authorizing Product Load Section 5 2 7 Amending Product Load Section 5 2 8 Authorizing Amended Product Load Invoking the Product Load Summary Screen Invoke the Product Load Maintenance Summary screen by typing LESPRLD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Load Maintenance Summary Authorized Open Product ID B Rule Effective Date Latest Rule Advanced Search Reset Records per page 15 v 1 of 1 Authorized Open Product ID Rule Effective Date Latest Rule Retrieving Product Load in Product Load Screen You can retrieve a previously entered record in the Summary screen as follows You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Product Load Summary screen Select the status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved Select the status of the record in the Open field If you choose the Blank Space option then all the records are retrieved Product ID Rule Effective Date a ORACLE 5 2 3 5 2 4 After you have specified the required details click Search button All records with the specified
85. ective Start date and End Date with policy start date oe ORACLE 4 5 2 Invoking Product Annual Annuity Limit Detail Screen You can define lower and upper annuity income percentage using Product Annual Annuity Limit Detail screen You can invoke this screen by typing LEDPAALM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Annual Annuity Limit Detail a Save Product Annual Annuity Limit Mapping Effective Start Date rs Rule ID No Effective End Date E3 Product az Min Ratio Min Age Max Ratio Max Age You can specify the following details Product Annual Annuity Limit Mapping Product Alphanumeric 8 Characters Mandatory Specify the product ID The adjoining option list displays all valid product ID maintained in the system You can choose the appropriate one Min Age Numeric 3 Characters Mandatory Specify the minimum age for the unit holder Max Age Numeric 3 Characters Mandatory Specify the maximum age for the unit holder Effective Start Date Date Format Mandatory Specify the effective start date for the maintenance Effective End Date Date Format Optional Specify the effective end date for the maintenance Min Ratio Numeric 8 Characters Mandatory Specify the minimum ratio for the maintenance Max Ratio Numeric 8 Characters Mandatory Specify the maximum ratio for the maintenance
86. ective 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 Product and Transaction Sub Type This section contains the following topics e Section 4 3 1 Mapping Product and Transaction Sub Type e Section 4 3 2 Invoking Screen Mapping Product and Transaction Sub Type The Product Transaction Sub Type Mapping Detail screen as shown in the screenshot allows you to link available sub type codes maintained under transaction sub type maintenance to a particular product such as Redemption Subscription aa ORACLE 4 3 2 4 3 2 1 Invoking Screen Invoke the Product Transaction Sub Type Mapping Detail screen by typing LEDPRSUB in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Transaction Sub Type Mapping Detail New 53 Enter Query Product Ref Type Details Ref Type Product ID Product Short Name Product Name Sub Type Details 1of1 Sub Type 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 Product Transaction Sub Type Mapping Product ID Mandatory Specify the product identity number Transaction Type
87. ed records in the lower portion of the screen The Product Load screen is opened in view mode Deleting Product Load 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 Product Load Summary screen as follows 1 Invoke the Product Load 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 Product Load 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 Product Load 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 Product Load Summary screen 1 Invoke the Product Load 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 r
88. edions 3 1 3 1 1 Creating and Saving Product TyP 1 ccccccccsssceseeectsseseseneeecsnsneseeeeetsaees 3 1 3 1 2 INVOKING SCrOCN sioen oiana iaa ena eaaa e 3 2 3 1 3 Saving Information Entered 2 cccccccccscceceseeseeneeceneeeeseneecsenesetsnseecseneessnaes 3 5 3 2 Transaction SUB Type aa E TE R ATE 3 5 3 2 1 Maintaining Transaction Sub TYP cccccccccessceeeneecteseecseneeessneeeseseeessaees 3 5 3 2 2 INVOKING SCOCN cccccceeencccnscecesnnsesececsssnnsnanaeecassnsesaaessssnnessnanenaennsesnass 3 6 3 3 Transaction Sub Type Maintenance Summary cece eeeeeee eee tntteeeeeettteeeere 3 7 3 3 1 Retrieving a Record in Transaction Sub Type Maintenance Summary Screen 3 7 3 3 2 Editing Transaction Sub Type Maintenance Record 1 ccccccssceeseteteees 3 8 3 3 3 Viewing Transaction Sub Type Maintenance R COIG 1 cccccsccesseeeeees 3 8 3 3 4 Deleting Transaction Sub Type Maintenance Record cccccecceesteeeeees 3 9 3 3 5 Authorizing Transaction Sub Type Maintenance Record 11ccceeeee 3 9 3 3 6 Amending Transaction Sub Type Maintenance R COIrC ccccccceeceiee 3 9 3 3 7 Authorizing Amended Transaction Sub Type Maintenance Record 3 9 3 4 Product Type Summary Screen 00 0 eee eee eeee eee eeetnee eee eeeaaeeeeeeeaeeeeeetenaeeeeeeeaaes 3 10 3 4 1 Invoking the Product Type Maintenance Summary Screen ccccceeeee 3 10 3 4 2 Retrieving Product Type in Product Type Screen
89. eeaeeeeeetenaeeeeeeenaaes 3 17 3 7 1 Maintaining Product Tax ClaSS csscccccececeeseececeeeecenaeseeseeecteneeeseseeetsnetess 3 17 3 7 2 Invoking Product Tax Class Maintenance Detail SCr N cccccceeeees 3 18 3 8 Product Tax Class Maintenance Summary 0 eecceeeeeeteeeeeeeeteeeeeeeentaeeeeeeeaees 3 19 3 8 1 Retrieving Product Tax Class Record sssccccscceccseeeesenececenesetenseeeesnneess 3 19 3 8 2 Editing Product Tax Class ROCOIO csccccssscceceececsnseeeseseectsneesteneeessnetees 3 20 3 8 3 Viewing Product Tax Class Record ccccccccssscecesesesenneessnesstseeesennnseees 3 20 3 8 4 Deleting Product Tax Class Record scccccccceceeceeeneeeeeeeeecteseteseeetenntees 3 20 3 8 5 Authorizing Product Tax Class Record 0 1s1ccccsececeseeeseneeeesneeetsnseetenentees 3 21 3 8 6 Amending Product Tax Class Record ccccsccccssceceeseeeeeneeeceneeetseeeetsnetess 3 21 3 8 7 Authorizing Amended Product Tax Class Record ss ccccscsesseeceesesteees 3 21 PO o O Iei ee ce crepes aces ee tres sa epee cence cna E 4 1 4 1 Product Detinition rensa tensed ce aaeee A A tia deta Ae L e eea 4 1 4 1 1 Creating and Saving PLOQUCE cccccccccceseecetseeeseeeectesaeeseneeessneesecseeeteaness 4 1 4 1 2 INVOKING SCIOCN 1 cccscccceenecsnscecennesessaeecenenessnaeececeenessaasecsensestiatsesennnesnaes 4 2 4 1 3 Product Details Tap x reesen ei bs E peluston sible pastel tahoe 4 4 4 1 4 Additional Investme
90. eeeetntneeeeeeenneeees 8 5 8 2 6 Authorizing Management Fee Applicability cssccecceesseeeeeettteeeeeenseeees 8 5 8 2 7 Amending Management Fee Applicability ccccescccecstsseeeecesstneeeeesnnneees 8 6 8 2 8 Authorizing Amended Management Fee Applicability ccccccceesseeees 8 6 General Ledger Set Up ccccccscccceeeeeeeeeeeeeeeeeeneeeseeeceneeeeeeeeeeeeeeeeeeeeens 9 1 9 1 General Ledger Template Setup ececceeceeceeceeeeeeeeeteeeeceeeaaeaaeeeeeeeeeeeeteeeteees 9 1 9 1 1 Invoking the General Ledger Template Setup Screen ccccseeceeereeeees 9 2 Cash Management Account cccceeeetceteeeeeeeeeeeeeeeeeeeeeeseeeeeeeeeneeeeeeeeeeees 10 1 10 1 Cash Management Account 0 0 0 cece etter eee ettne eee eetaaeeeeeeteeeeeeetieeeeestiaeeeeeenea 10 1 10 1 1 Cash Management Account Description 11 ccccccccceeteeeenteetsntetteeseeetsaees 10 1 10 1 2 GMA OperaliOns siii eisien iriga ianooii eatae i aia iaaiiai ii en sees 10 2 10 1 3 Operating CMA Generate Switch Transaction Batch cccsccseseeeeeees 10 3 Prudential Investment Guidelines cccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeneees 11 1 11 1 Prudential Investment Guidelines ec ecceeee ee eeeee nese eeieeeeeeeteeeeeeennaeeeeeeeea 11 1 11 1 1 Prudential Investment Guidelines D SCIIDUION cccccccccectetttteeeeteeeetees 11 1 11 1 2 Maintaining Prudential Investment Guidelines 2 1 ccceeeeceeeeeeteeneeestees 11 2 11 1
91. endent level then load will be applied on the difference between the transaction amount and the sum of all dependent level load amounts without considering all recursive levels oF ORACLE Note The dependent level Id must be less than the Level Id The dependent level Id is not ap plicable for LTP loads Other Details Section Other Details 1of1 Ref Type Description Ref Type Mandatory To designate a load as being applicable for a reference transaction type for the selected product select the reference type from the option list Note It must be remembered that while mapping a load to a reference transaction type the sys tem does not support the mapping of Switch In and LEP Interest transaction types Description Display Upon selection of Ref Type the description of the selected reference type gets populated automatically Fund Details Section Fund Details 1of1 Fund ID Fund Name Fund ID Specify the fund id The adjoining option list displays all valid fund ids maintained in the system You can chose the appropriate one Fund Name Upon selection of Fund ID the description of the selected fund id gets populated automatically sg ORACLE 5 2 5 2 1 5 2 2 Product Load Summary Screen This section contains the following topics Section 5 2 1 Invoking the Product Load Summary Screen Section 5 2 2 Retrieving Product Load in Product Load Screen S
92. escription ROA Computation Method az WAC Method Regular WAC v Restrict CMA For Initial No Description Investment Include Current TXN For ROA N Redeem Periodic Fee From Noe ETN EROA E CMA Fund Include Re Investment For Nof CGT Applicable No ROA rea itch Im Generate Redemption For Noly Switctimpaci ROA Nofi Input by Authorized by Mod No Open Authorized Product Start Date dd MM yyyy Date Format Mandatory Specify the date on and beyond which the Product is available for transactions by the Policy Holders t ORACLE Note This date must not be earlier than the Application Date except if the Product is an existing one Product End Date dd MM yyyy Date Format Mandatory Specify the date on and beyond which the Product is not available for transactions by the Policy Holders Note This date must not be earlier than the Application Date and the Maturity Date of a policy Prod Min Tenor Mandatory and Enabled only if Maturity Date Basis for Product Type is Minimum Tenor Specify the minimum age for policies in this Product in terms of number of years The age in number of years is referred to as the term of the Product and is considered from the Start Date of the Product Note This field will be enabled only if you have selected the option Minimum Tenor against the field Maturity Date Basis for the Product Type in the Produc
93. esie aaa E eaa aaa 4 32 tar Amending Product presene ae doa ha eee es 4 32 4 2 8 Authorizing Amended PrOCUCE cseceeceeeeeneeeeeeneneeeeesnneneeeeetninneeeeeenneees 4 33 4 3 Product and Transaction SUD Type ceceeeeceeceeeeeeeeeeeeneeeeeseeeeeeeeeeeeeaeeeeseeaeeees 4 33 4 3 1 Mapping Product and Transaction SUD Type 2 ccccseeceesneeessteeeeseeesens 4 33 4 3 2 INVOKING SCION 1 5 cecccssocssesseenees vee les oasinessavade cients supaes oat cuvbuse ed a iaia stoves 4 34 4 4 Product Transaction Sub Type Mapping SUMMALY eeeeeeeteeeeeeeeeeeeeeeneeeees 4 35 4 4 1 Invoking Product Transaction Sub Type Mapping Summary 0 0 4 35 4 4 2 Retrieving Product Transaction Sub Type Mapping 2 ccscccceseeeeeeees 4 35 4 4 3 Editing Product Transaction Sub Type Mapping 1 c1sccccesteeesteeeeenetees 4 36 4 4 4 Viewing Product Transaction Sub Type M pping ccccccccecssseeeceereees 4 36 4 4 5 Deleting Product Transaction Sub Type Mapping 2 cccccecesetseeeeseeees 4 36 4 4 6 Authorizing Product Transaction Sub Type Mapping ccccccccsceseeeees 4 37 4 4 7 Amending Product Transaction Sub Type Mapping 2 cccccccessteeeeeeees 4 37 4 4 8 Authorizing Amended Product Transaction Sub Type Mapping 4 38 4 5 Product Annual Annuity Limit Mapping ceeeeeceeeeeeeeeeeeeeeeeecaeeeeeeetnaeeeeeeenaaes 4 38 4 5 1 Maintaining Product Annual Annuity Limit Mapping Details
94. estment amp Divident amp Annuity 4 1 3 Product Details Tab Click Product Details tab to enter the details Product Maintenance Detail e H sae Product Information Product ID Existing Product Nof Product Name Product Base Currency laz Rule Effective Date k Currency Name Product Short Name z Poatcony a Product Mnemonic Product Country Description P Product Type E Plan Administration By a Product Type Description 2 Plan Administration By z Produtciass ee Plan Administrator H Product Class Description o se Plan Administrator Description ic Fetch Product Type Info gt Product Details m Product Start Date ler Minimum Age For Entry Beneficiary Details Mandatory Nd v Product End Date 5 Maximum Age For Entry Constituent Details Mandatory No x Fiscal Start Date E Minimum Age For Exit Pay Broker Commissionto No x Fiscal End Date le Maximum Age For Exit Product Prod Min Tenor Retirement Age poe eines Nd f Policy Statement Frequency 25 Retirement Age at which Foreign Exchange Compliance Nol v q Dasciiption 2 Surrender required Coston latest i ETE ei Early Termination Allowed Yes ession Applicability Nofe i e H i Minimum Initial Investment AKG ANDRE herean Maximum Initial Investment Renars i iti im Cash Management Account Nol lid Applicability Maximum Annual Contribution E CMA Fund ae ROA Applicable N D
95. ete only unauthorized records in the system To delete a record that you have previously entered you must retrieve the same in the Product Summary screen as follows 1 Invoke the Product 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 Product 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 Product 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 Product Summary screen 1 Invoke the Product 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 dis
96. fective To Date E Product ID Product Description ie Group ID Group Description P ISIN Code Fund Name Load 5 Load ID Load Description From Entity Type From Entity Type Description To Entity Type To Entity Type Description Nature of Load Nature of Load Description o Action For Load a3 Action Name i Management Fee Load ID az Load Description ol Intermediary A Intermediary Details P Last Processed Date Load Details E Processing Frequency Processing Frequency No of Decimals whi peat i a ext Date To Process 2 Round OffTruncate Round Offe n TN M Minimum Holding Period aymentLag Frequency M ae DAEN Payment Lag Frequency AccrualFrequency __ aa Description Last Accrual Date Accrual Frequency Description Next Accrual Date Last Accrual Application Date FDAP income No v Payment Lag FirstLoad To Be Computed Trailer Commission Netted AUM For Second Load No v Reversal Reversal Date Basis a Reversal Date Basis o s Input by DateTime Mod No Open Authorized by DateTime Authorized If the periodic fee is maintained at the product level then during periodic load accrual the amount in fund base currency gets converted to product base currency to derive the load slab The computation will happen in fund base currency fl ORACLE On Authorization of Periodic Load Maintenance the system will support quarterly average holding method with yearly payment frequency only Refer to
97. fy any or all of the details of the records in the corresponding fields on the screen and click Search button All transactions 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 PIGSFOREX Compliance screen is opened in View mode 11 ORACLE 11 2 5 11 2 6 11 2 7 Deleting PIGSFOREX Compliance 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 PIGSFOREX Compliance Summary screen as follows 1 Invoke the PIGSFOREX Compliance 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 PLIGSFOREX Compliance 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 PIGSFOREX Compliance An unauthorized record must be authorize
98. he current policy top up transaction violates 120 rule then system shows an error as The amount of the top up will result in this policy being in breach of the 120 Rule by Rnnn nn Where Rnnn nn is the amount by which top up transaction is violating 120 Rule If current premium transaction breaches 120 Rule system will register the error message amp transaction will not be generated If Top up transaction has been done with other than selected transaction sub types system will not consider the transaction for 120 rule validation System will calculate total gross amount of the previously processed transactions in the current policy year amp current transaction amount for exercise 120 rule Dividend reinvestments are excluded from 120 rule validations Refer to the chapter Batch Functions of LEP User Manual for further information on the 120 Rule Saving Information Entered When you have entered all the mandatory information click Ok button The system displays the following confirmation message as Record Successfully Saved This indicates the record has been saved Click Ok button Transaction Sub Type This section contains the following topics e Section 3 2 1 Maintaining Transaction Sub Type e Section 3 2 2 Invoking Screen Maintaining Transaction Sub Type The transaction sub type maintenance screen is added to combine the sub type transactions for policy cre
99. he reference currency for all the fields identified as part of the Product Existing Product Mandatory Select Yes to indicate that the product is an existing product For an existing product the Product Start Date is earlier than the application date If any existing business products need to be entered into the system this field facilitates easy conversion of the same Plan Administration By Mandatory Select the entity that will administer the plan The option list includes all the options that you have maintained in the System Parameters Maintenance screen for the Parameter Code POLICYCODE Refer to the chapter Maintaining System Parameters in the Security User Manual for further information on the System Parameters Maintenance Plan Administrator Mandatory Select the administrator for the entity that you have chosen The option list includes all the entities that you have maintained in the Single Entity Maintenance screen Ea ORACLE Refer to the chapter Maintaining Reference Information in the Reference Information User Manual for further information on the Single Entity Maintenance screen WHT Applicable Mandatory Select the option to indicate withholding tax needs to be calculated on the reinvested income from the policies in this Product The options in the drop down are as follows e Relnvestment e Divident Payout e Relnv amp Divid e Relnv amp Annuity e Annuity amp Divid e Relnv
100. hich is one among the following These are called as Four Fund Tax Classes e Individual Fund IPF e Corporate Fund CPF e Retirement Fund RPF e Untaxed Fund UPF The system supports Four Funds Tax Class functionality in the following manner ou ORACLE 3 7 2 e First the system derives the Tax class of the policy based on the Product and UH Category using Product Tax Class Maintenance screen LEDPRTAX e At the fund level the funds are grouped using Fund Rule Maintenance UTDFNDRL for Tax Class Switch e Then four different funds are created for each Fund Tax Class under one Fund Group e Fund Rule Maintenance UTDFNDRL Fund level indicator is used to specify Fund Tax Class Individual Fund IPF Corporate Fund CPF Retirement Fund RPF Untaxed Fund UPF Client Responsible Tax CRT Policy Tax Class will get defaulted from Product Tax Class maintenance And if UH Category gets modified upon its authorization system automatically changes at EOD all the underlying policy Tax Class to new policy tax class based on the new UH Category and Product combinations and update the Sl s with new tax class fund id s and generates 100 switch transactions form the old policy tax class funds Invoking Product Tax Class Maintenance Detail Screen You can create four different funds for each Fund Tax Class under one Fund Group You can maintain the fund tax classes using Product Tax Class Maintenance scree
101. hore Offshore 115 000 ZAR lt 100 e Cash Offshore 22 500 ZAR lt 15 e Equity Onshore Offshore 167 500 ZAR lt 75 e Equity Offshore 17 500 ZAR lt 15 e Property Onshore Offshore 67 500 ZAR lt 25 e Property Offshore 12 500 ZAR lt 10 e Property Equity 235 000 ZAR lt 90 e Total Offshore Cash Equity Property 52 500 ZAR lt 15 The transaction can be processed as it follows the Prudential Investment Guidelines The Prudential investment guidelines screen provides you with ability to define rules for allocation of a fund asset Maintaining Prudential Investment Guidelines The rules for maintaining the Prudential Investment guidelines are validated in the following manner e Total the Amount invested in selected components for the rule e Calculation of threshold amount using the following formula Threshold Amount Threshold percentage total investment value across Funds e Ascertain if the amount derived in the first step is less than or equal to the Threshold Amount calculated in the succeeding step Repeat this process for all the rules defined in Product maintenance for Prudential Investment Guidelines If any of the threshold amount limits violate the maintained guidelines then the system displays an error along with the erring rule ID and the amount corresponding to the rule identity number In this instance this particular investment transaction should not be proce
102. ields 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 Product 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 Product Detail screen is closed and the changes made are reflected in the Product Summary screen 4 2 4 Viewing Product To view a Product you have previously entered you must retrieve the same in the Product Summary screen as follows oat ORACLE 4 2 5 4 2 6 4 2 7 1 Invoke the Product Summary Screen from the Browser 2 Select the status of the Product Type 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 transactions 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 Product screen is opened in view mode Deleting Product You can del
103. ing Feature Supported Mandatory Select this option to indicate the Product Type supports funding features If you select this option you will have to specify Funding details such as the frequency period and percentage in the Product Maintenance screen 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 ORACLE IRA Applicable Mandatory Select the option Yes to indicate the Product Type supports IRA features Apply 120 Rule Mandatory 120 rule is made available at Product level to select list of transaction types that are applicable for 120 rule validation The rule also validates the Top Up Debit order function of an application that needs to be processed Minimum Age for Entry Mandatory Specify the minimum age before which a customer cannot subscribe to a policy under a product of this Product Type Maximum Age for Entry Mandatory Spe
104. ins the following sections e Section 8 1 Management Fee e Section 8 2 Management Fee Applicability Summary Screen Management Fee This section contains the following topics e Section 8 1 1 Applying Management Fee e Section 8 1 2 Invoking Screen e Section 8 1 3 Saving Information Entered Applying Management Fee The following are the steps you need to follow to apply a Management Fee to funds in a product Each of these steps is explained in detail in subsequent sections e Enter information in the Management Fee Applicability Detail screen e Save the information entered a ORACLE Invoking Screen You can invoke the Management Fee Applicability Detail screen by typing LEDMGMAP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Management Fee Applicability Detail New 753 Enter Query Product Details Product ID Product Name Gat Funds 1of1 Fund ID Management Fee Applicable YES Input by DateTime Authorized by DateTime Mod No Open Authorized You can enter following details in the Management Fee Applicability Screen Product Details Section In the Product Details section you will have to enter information in the following fields Product ID Mandatory Select the ID of the product the funds for which you are applying a management fee The option list includes all authorized p
105. ion Plan Administration By Plan Administration By Description Plan Administrator Plan Administrator Description WHT Applicable Reinvestment vj Product Details Additional Inv Bank Det Withdrawals PortFolio Mapping Premium And Annuity Loan And Funging Income Distribution Rule Transaction Currency Funding Details Funded Product No Funding Factor Funding Frequency Funding Period Frequency Desc Loans Loan Applicable No Geared Loan Factor No of Loan Allowed Maximum Loan Amount Loan Interest Percent Redeem Loan Interest from holdings Minimum Loan Amount Input by DateTime Mod No Authorized by Open DateTime Authorized Funding Details Section Funding Frequency Mandatory if Funded Product is Yes Specify the frequency at which the funded amount will be repaid to the investor Note You cannot change the funding frequency for a policy Funding Period Months Mandatory if Funded Product is Yes Specify the duration of the repayment period at the end of which the entire funded amount will be paid back to the investor Note You can change the same for a policy Funded Product Optional Specify whether the Product is a funded product wherein a portion of the initial investment and subsequent top ups if any will be retained a ORACLE 4 1 10 Funding Factor Mandatory if Funded Product is Yes Specify the funding f
106. ized 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 PIGSFOREX Compliance screen will be displayed in Amendment mode Click the Unlock operation from the Action list to amend the record Met ORACLE 11 2 8 11 3 11 3 1 5 Amend the necessary information Click the Save button to save your changes Authorizing Amended PIGSFOREX Compliance An amended PIGSFOREX Compliance 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 PIGS Batch Maintenance This section contains the following topic e Section 11 3 1 Invoking PIGS Batch Maintenance Screen Invoking PIGS Batch Maintenance Screen You can maintain PIGS compliance check related parameters using PIGS Batch Maintenance screen You can invoke this screen by typing LEDPIGB in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button PIGS Batch Maintenance A save PIGS Maintenance Screen Policy Administrator INDIVIDUAL 1 2 Next Batch Run Date 05 27
107. ke the PIGSFOREX Compliance 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 PIGSFOREX Compliance 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 PIGSFOREX Compliance Detail screen is closed and the changes made are reflected in the PLIGSFOREX Compliance Summary screen Viewing PIGSFOREX Compliance To view a PIGSFOREX Compliance you have previously entered you must retrieve the same in the PIGSFOREX Compliance Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the PIGSFOREX Compliance 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 Speci
108. lank Space option then all the records are retrieved e PIGS or FOREX e Rule ID e Operation e Threshold Percentage 0 100 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 Rule ID 1s ORACLE 11 2 3 11 2 4 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 Rule ID by using the combination of and alphanumeric value as follows Search by A System will fetch all the records whose Product ID starts from Alphabet A For example AGC17 AGVO6 AGC74 etc Search by 7 System will fetch all the records whose Rule ID ends by numeric value 7 For example AGC17 GSD267 AGC77 etc Search by 17 System will fetch all the records whose Rule ID contains the numeric value 17 For example GSD217 GSD172 AGC17 etc Editing PIGSFOREX Compliance 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 Invo
109. ll not allow you to select a UCITS fund The system will display an error message as The product does not allow UCITS funds Once the product is authorised UCITS Fund field is non amendable Available Sponsor Section You can add the Sponsor ID by selecting the values from the option list Product Port Folio Section Fund ID Alphanumeric 8 Characters Mandatory You can add the Fund ID and Reinvestment Fund ID by selecting the values from the option list Fund Name Display The Fund Name of the selected Fund ID is displayed in the Fund Name field Exclude from Auto Switch Optional Check this box to exclude the portfolio from auto switch Reinvestment Fund ID Alphanumeric 8 Characters Mandatory Specify the reinvestment fund ID Alternatively you can select the reinvestment fund ID from the option list The list displays all valid reinvestment fund ID maintained in the system Fund Name Short Display The system displays the fund name for the selected reinvestment fund ID Premium and Annuity Details Tab You will be able to see this link only if you have chosen a product type for which the option Premium and Annuity Applicable is set to Yes ae ORACLE Click Premium amp Annuity tab to enter the details Product Maintenance Detail New tS Enter Query Product Information Existing Product No Product ID Rule Effecti
110. n You can invoke this screen by typing LEDPRTAX in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Tax Class Maintenance Detail UH Category H Tax Class Product ID Input by DateTime Mod No Open Authorized by DateTime Authorized You can specify the following details UH Category Specify the Unit Holder category details Alternatively you can select the UH Category from the option list The list displays all valid UH Category details maintained in the system Product ID Specify the product ID Alternatively you can select the Product ID from the option list The list displays all valid Product ID maintained in the system Tax Class Specify tax class details Alternatively you can select tax class details from the option list The list displays all valid Tax Class details maintained in the system oe ORACLE 3 8 Product Tax Class Maintenance Summary This section contains the following topics e Section 3 8 1 Retrieving Product Tax Class Record e Section 3 8 2 Editing Product Tax Class Record e Section 3 8 3 Viewing Product Tax Class Record e Section 3 8 4 Deleting Product Tax Class Record e Section 3 8 5 Authorizing Product Tax Class Record e Section 3 8 6 Amending Product Tax Class Record e Section 3 8 7 Authorizing Amended Product Tax Class Record 3 8 1 Retrieving Product Tax Class Record You can view the p
111. n 4 1 11 Transaction Currency Tab e Section 4 1 12 FATCA Information Tab e Section 4 1 13 Regulation 28 Parameters Tab 4 1 1 Creating and Saving Product 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 Product Maintenance screen e Enter information in the Product Maintenance screen e Save the information entered 4 ORACLE 4 1 2 Invoking Screen Invoke the Product Maintenance Detail screen by typing _EDPROD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Maintenance Detail X H sae Product Information Product ID Existing Product Noj Product Name m Product Base Currency Aoa Rule Effective Date z Currency Name Product Short Name a Product Country ag Product Mnemonic Product Country Description o Product Type az Plan Administration By i Product Type Description P Plan Administration By P Product Class a Description Product Class Description P inna A C E Plan Administrator Description 2 J Additional Investments Bank Details Withdrawals Portfolio Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency FATCA Information Regulation 28 parameters Product Details a Product Start Date B Minimum Age For Entr
112. nal Specify the PIGS complaint product ID The adjoining option list displays all valid product ID maintained in the system You can choose the appropriate one 18 ORACLE 3 6 Nature of Fund Alphanumeric 8 Characters Optional Specify the nature of fund based on param maintenance The adjoining option list displays all valid product ID maintained in the system You can choose the appropriate one PIGS Display The system defaults PIGS value as per product level FOREX Display The system defaults FOREX value as per product level Product Nature of Fund Mapping Summary This section contains the following topics Section 3 6 1 Retrieving Product Nature of Fund Mapping Section 3 6 2 Editing Product Nature of Fund Mapping Record Section 3 6 3 Viewing Product Nature of Fund Mapping Record Section 3 6 4 Deleting Product Nature of Fund Mapping Record Section 3 6 5 Authorizing Product Nature of Fund Mapping Record Section 3 6 6 Amending Product Nature of Fund Mapping Record Section 3 6 7 Authorizing Amended Product Nature of Fund Mapping Record aN ORACLE 3 6 1 Retrieving Product Nature of Fund Mapping You can view the status of a product nature of fund mapping using Product Nature of Fund Mapping screen To invoke this screen type LESPNFM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Nature Of
113. ncy Branch module 39 ORACLE The subsequent process of authorization is the same as that for normal transactions 3 4 Product Type Summary Screen This section contains the following topics e Section 3 4 1 Invoking the Product Type Maintenance Summary Screen e Section 3 4 2 Retrieving Product Type in Product Type Screen e Section 3 4 3 Editing Product Type e Section 3 4 4 Viewing Product Type e Section 3 4 5 Deleting Product Type e Section 3 4 6 Authorizing Product Type e Section 3 4 7 Amending Product Type e Section 3 4 8 Authorizing Amended Product Type 3 4 1 Invoking the Product Type Maintenance Summary Screen Invoke the Product Type Maintenance Summary screen by typing LESPRTYP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Type Maintenance Summary Authorized Open Product Type ag Description a Advanced Search Records per page 15 v 104 Authorized Open Product Type Description 3 4 2 Retrieving Product Type in Product Type Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Product Type 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 Stat
114. ns This User Manual may refer to all or some of the following icons Icons Function Exit 1 K L Add Row Icons Function Delete Row aa Option List 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 SI Standing Instructions SMS Security Management System Abbreviation z Meaning Acronym URL Uniform Resource Locator VAT Value Added Tax WAUC Weighted Average Unit Cost 1 8 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 2 1 2 Pr
115. nt that has stopped becomes Active again e Premium payments are not made the status of the same is marked PUP by the AMC Once the premium payment is made the AMC changes the status to Active If you select No then no pending premium transactions are generated Minimum Premium Amount Mandatory Specify the minimum premium amount that the Policy Holder needs to pay Maximum Premium Amount Mandatory Specify the maximum premium amount that the Policy Holder needs to pay 4 20 ORACLE Premium Step Amount Mandatory Specify the step amount for payment of premium The premium amount will be a multiple of the step amount Annuity Applicable Mandatory An annuity is a deferred payment made to the Policy Holder over a period for lump sum payments or premium payments received from the Policy Holder You can select Yes if annuities are applicable to this product Note The next few fields Minimum Annuity Amount Maximum Annuity Amount Minimum Annu ity Ratio and Maximum Annuity Ratio are enabled only if you have selected the option An nuity Applicable Minimum Annuity Amount Mandatory Specify the minimum amount to be paid out as annuity to the Policy Holder for any policy in the Product Maximum Annuity Amount Mandatory Specify the maximum amount allowed to be paid out as annuity to the Policy Holder for any policy in this Product Minimum Annuity Ratio Mandatory Specify the ra
116. nt 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 Product With Holding Tax 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 Product With Holding Tax 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 Product With Holding Tax 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 oF ORACLE 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 reco
117. ntly dangerous 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
118. nts Tab ccccccceeececceeeeneceeeeenneeeeeeeensnneeceetnineeeenennnees 4 12 415 Bank Details Tab oriei En S ET pueda fag een oe Saget bee as 4 14 4 1 6 Withdrawal Tab sss iets i nia e aaeei AAEE eae be sient ivi neers 4 15 4 1 7 Portfolio Mapping TAD Aroana a o EAE E Aa 4 18 4 1 8 Premium and Annuity Details Tab oi ccccecccccceseeeeeeeenseeeeeeeenieeeeesennneees 4 19 4 1 9 Loan and Funding Details Tab eeeeeeeeeeeeeeeeeenneerirrneerrinrreerinrrerrrenneeees 4 22 4 1 10 Income Distribution Rule Tab wo eee eeeseteceeeneeeeeeeenneeeeeeeenneneecesenineeeeseninnees 4 24 4 1 11 Transaction Currency Tab csccccecescccescecesteseseneeecenecetsaeecesentesnsaeesenenetins 4 25 4 1 12 FATCA Information Tab ccccccccccccccecsseececeneececeeceeececseeeseceetessnaeeseeneneteas 4 27 4 1 13 Regulation 28 Parameters TAb cccccccssscceccsesteeecesessneeeeessnneeeesessnnnneees 4 28 4 2 Product SUMMAary SCIEN sssrinin a i aa F iea a a eiaa 4 30 4 2 1 Invoking the Product Summary SCICCN 1scccccsceceeeeeeeneeceneseeteeeetstetens 4 30 4 2 2 Retrieving Product in Product Screen 1scccccssceceeeeeseneecenesetseseeetsneeees 4 31 42 3 Edning Products os Ee aA OD 4 31 424 Viewing Product sccnesriiiariiie creari anes eet ANAA eben dei tes 4 31 4 2 5 Deleting PrOCUCE c ccccccececnenseeeeeenneeerenenenneenenannnnesnenaannnesesensnnnesenenenees 4 32 4 2 6 Authorizing Product i 0 cessussiciidaees stevie siteeieesbiiv
119. ny 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 Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping 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 Transaction Sub Type Mapping 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 oat ORACLE 4 4 8 4 5 4 5 1 Authorizing Amended Product Transaction Sub Type Mapping An amended Product Transaction Sub Type Mapping 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
120. o Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency FATCA Information Regulation 28 parameters Reg28 Auto Switch Fund Cs Counter for Auto Switches f Rounding Option Round Off x No of Decimals Rule Type for Regulation 28 ONLINEJ 7 Txn Types For Online Reg28 lnclude Txn Types for Material Change lnclude Validation Exclude Exclude Adjustment Txn Types for Material Change Adjustment Txn Types for Online Reg28 validation 1of1 FE 1of1 A V Adjustment Transaction Type Description E p3 Description Adjustment Transaction Type E DateTime Mod No Open input by Authorized by DateTime Authorized You can specify the following details Reg28 Auto Switch Fund Alphanumeric 8 Characters Mandatory if Product is PIGS compliant Specify the Regulation 28 Auto Switch Fund details to map specific fund switch in for Auto re balancing of client portfolio to enable policy to be PIGS compliant Alternatively you can select Reg28 Auto Switch Fund from the option list The list displays all valid Reg28 Auto Switch Fund details maintained in the system Rounding Option Mandatory Select the rounding option from the drop down list The list displays the following values e Round Off e Round Up e Round Down 4 28 ORACLE Rule Type for Regulation 28 Mandatory Select the Rule Type for Regulation 28 from the dro
121. ocation load with 0 return value to the product to compute gain loss If the policy transaction under consideration is a 100 surrender then the system will recover the tax from settlement amount The system should reduce the system derived settlement amount to the extent of tax recovered The above process will consider the gain loss computed carried forward up to and including the current 100 surrender in consideration The system will recover the tax amount from the settlement amount of funds which resulted in gain only If the settlement of such funds is insufficient then the system will recover proportionately from all funds involved in 100 surrender If all the UT transactions are in loss then the system will recover proportionately from the portfolio funds If the CGT redemption transaction is reversed then the gain will not be reversed Additional Investments Tab Click Additional Inv tab to enter the details Product Maintenance Detail New 53 Enter Query Product Information Product ID Product Name Product Short Name Product Mnemonic Product Type Product Type Description Product Class Product Class Description Fatch Product Tyne Info Existing Product Rule Effective Date Product Base Currency Currency Name Product Country Product Country Description Plan Administration By Plan Administration By Description Plan Administrator Plan Administrator Description W
122. oduct Class The first step in the workflow is to define various Product Classes A Product Class describes the underlying investment philosophy of the Life and Endowment Product Note Product Classes can be defined through the Fund Manager component only You can maintain details for a Product Class in the System Parameters screen The next section gives you step by step instructions to do the same This chapter contains the following sections e Section 2 1 Product Class Product Class This section contains the following topics e Section 2 1 1 Maintaining Product Class Maintaining Product Class The following are the steps you need to follow to define a Product Class Each of these steps is explained in detail in subsequent sections e Invoke the System Parameter Codes Maintenance screen e Choose a language in the System Parameter Codes Maintenance screen e Define a Product Class in the System Params Value Maintenance screen The Parameter Code is PRODUCTCLASS e Save the information entered Refer to the chapter Maintaining System Parameters in Volume 1 of the Fund Manager User Manual for further information 2 1 3 1 3 1 1 3 Product Type You would have maintained various Product Classes The next step is to maintain various Product Types You can maintain different types of products in the system The Product Type is typically an indication of the investment type that the produc
123. olding Tax e Section 6 2 5 Deleting Product With Holding Tax e Section 6 2 6 Authorizing Product With Holding Tax e Section 6 2 7 Amending Product With Holding Tax e Section 6 2 8 Authorizing Amended Product With Holding Tax Invoking Product With Holding Tax Summary Screen You can invoke the Product With holding Tax Summary screen by typing LESPWHTD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product With holding Tax Summary Authorized Open Product ID a Effective Date e Advanced Search Reset Records perpage 15 v 1 of 1 Authorized Open Product ID Effective Date Load ID Retrieving Product With Holding Tax in Product With Holding Tax Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Product With Holding Tax 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 Record Status field If you choose the Blank Space option then all the records are retrieved e Product ID e Effective 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 os ORACLE 6 2 3 6 2 4
124. on 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 Product Load 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 Product Load Detail screen is closed and the changes made are reflected in the Product Load Summary screen Viewing Product Load To view a Product Load you have previously entered you must retrieve the same in the Product Load Summary screen as follows 1 Invoke the Product Load Summary Screen from the Browser op ORACLE 5 2 5 5 2 6 5 2 7 2 Select the status of the Product Load 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 transactions 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 display
125. on of the screen e Double click the record that you wish to authorize The Product Annual Annuity Limit Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes Authorizing Amended Product Annual Annuity Limit Record An amended Product Annual Annuity Limit record must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Agency Branch module The subsequent process of authorization is the same as that for normal transactions a ORACLE 5 1 5 Product Activities In Oracle FLEXCUBE Investor Servicing FCIS for each of the Life and Endowment Product defined in the system you can maintain a set of guidelines that govern the way in which transactions based on that product will be processed Product load setup governs the ways in which an applicable fee or incentive will impact the processing of transactions in the product Similarly you can associate entities with a product Only such entities that are mapped to the product will be allowed to transact in the product The following sections give you step by step instructions to do the same This chapter contains the following sections e Section 5 1 Product Load e Section 5 2 Product Load Summary Screen e Section 5 3 Entities with Products As
126. or every currency Note You can specify the details of more than one bank by clicking add icon which adds a field wherein you can choose another bank IBAN 36 Characters Only Alohanumeric Optional Specify the IBAN International Bank Account Number of the account holder Withdrawal Tab The information you enter in this screen will be applicable only for the minimum tenor that you have specified in the Product Maintenance screen Once the policy has matured these details will not be valid sa ORACLE Click WithDrawals tab to enter the details Product Maintenance Detail New 53 Enter Query Product Information Existing Product No Rule Effective Date Product Base Currency Currency Name Product Country Product ID Product Name Product Short Name Product Mnemonic Product Type Product Country Product Type Description Description Product Class Plan Administration By Product Class Plan Administration By Description Description Plan Administrator Plan Administrator Description WHT Applicable Reinvestment Faich Produc Tyna Info Product Details Additional inv Bank Det JRE PorFolio Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency Withdraw No of Withdrawals Allowed Withdrawal Limit Basis wed Description Withdrawal Limit Withdrawal Money Percentage Payable Compounding Factor Description
127. ou select Yes the Rebate Details section is displayed as shown below Applicable for CGT Mandatory Select Yes if applicable for CGT Else No Rebate Details Tab Note This section will be displayed only if have checked the box Age Limit Applicable for Re bates You will have to enter information in the following fields in this section Age From Mandatory Specify the age from which the rebates are applicable Age To Mandatory Specify the age up to which the rebates are applicable Rebate Amount Mandatory Specify the amount of rebate that is applicable You can click add icon to add the tax details Note The year end tax is computed in product base currency hence the tax amount in product currency is converted to policy base currency before redemption as redemption happens in policy base currency If annuity tax computation happens at policy holder level the annuity amount gets converted in terms of product base currency to derive the load slab for WHT com putation ca ORACLE 6 2 Tax Class Details Tab Click on Tax Class Details tab to enter tax class details Product With holding Tax Detail lea Save Product Withhold Tax Product ID DIVO1 be Load ID B ProductName RDR Dividend Produc Load Description Effective Date E Age Limit Applicable for Rebates Yesi Applicable for CGT Yes v Rebate Details RELA EEAS 4 of 4
128. p down list The list displays the following values e Online If this option is maintained the system will use AML batch rule for validating Reg 28 compliance e Batch If this option is maintained the system will use IML online rule for validating Reg 28 compliance Counter for Auto Switches Numeric 8 Characters Mandatory if Product is PIGS compliant Specify the number of unsuccessful Regulation 28 compliance check to run a contract before auto switch is initiated No of Decimals Numeric 8 Characters Mandatory Specify the number of decimal places allowed Txn Types For Online Reg28 Validation Optional Select the transaction types for online Reg28 validation The options are as follows e Include e Exclude Txn Types for Material Change Optional Select the transaction types for material change The options are as follows e Include e Exclude Adjustment Txn Types for Online Reg28 validation Adjustment Transaction Type Alphanumeric 8 Characters Optional Specify the Adjustment Transaction Type Alternatively you can select the Adjustment Transaction Type from the option list The list displays all valid Adjustment Transaction Type maintained in the system Description Display The system displays the description for the selected Adjustment Transaction Type Adjustment Txn Types for Material Change Adjustment Transaction Type Alphanumeric 8 Characters Optional Specify the Adjustment Transaction Type
129. pe Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for deletion e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to delete in the list of displayed records The Transaction Sub Type Maintenance Detail screen is displayed e Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database 3 3 5 Authorizing Transaction Sub Type Maintenance Record e An unauthorized Transaction Sub Type Maintenance record must be authorized in the system for it to be processed To authorize a record e Invoke the Transaction Sub Type Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Transaction Sub Type Maintenance Detail screen is displayed Select Authorize operation from the Action List When a ch
130. played in the lower portion of the screen 4 Double click the record that you wish to authorize The Product 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 Product 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 Product Summary screen from the Browser arte ORACLE 4 2 8 4 3 4 3 1 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 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 Product An amended product must be authorized for the amendment to be made eff
131. plication date The system will deliver Policy Level AUM as of price date based on Allotted Transactions at Policy Transaction Level 11 4 PIGS Batch Maintenance Summary This section contains the following topics e Section 11 4 1 Retrieving a Record in PIGS Batch Maintenance Summary Screen e Section 11 4 2 Editing PIGS Batch Maintenance Record e Section 11 4 3 Viewing PIGS Batch Maintenance Record e Section 11 4 4 Deleting PIGS Batch Maintenance Record e Section 11 4 5 Authorizing PIGS Batch Maintenance Record e Section 11 4 6 Amending PIGS Batch Maintenance Record e Section 11 4 7 Authorizing Amended PIGS Batch Maintenance Record 11 4 1 Retrieving a Record in PIGS Batch Maintenance Summary Screen You can retrieve a previously entered record in the Summary Screen as follows 119 ORACLE Invoke the PIGS Batch Maintenance Summary screen by typing LESPIGB in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button and specify any or all of the following details in the corresponding details PIGS Batch Maintenance X amp Search Advanced Search J Reset Clear All Search Is Case Sensitive Authorized Open z Policy Administrator a Next Batch Run Date E AUM Date For Next Batch Run amp Records per page 15 14 of 1 Lock Columns 0 Authorized Open Policy Administrator Next Batch Run Date AUM Date For Next Batch Run
132. ponent amp Primary Account Details Component ID Component Description Debit Credit SelectOne Primary Account Details Entity Unitholder ID GL Setup For Accounting Currency Fund Base Currency v Account Number Bank Branch UH AC Info a Transaction Currency UH A C Info x Direct Debit UH A C Info v Contra Account Details Contra Entity UnitholderID GL Setup For CASA Contra Accounting Currency Fund Base Currency v Contra Account Number Contra Bank Branch UH AIC Info Contra Transaction Currency UH A C Info ad Direct Debit Applicable UH A C Info v Input by DateTime Authorized by DateTime Mod No Open Authorized Refer to the chapter Interfaces with External Systems in Interface User Manual for further information a ORACLE 10 1 10 1 1 10 Cash Management Account Cash Management Account is a money market fund in a portfolio of funds that is used for recovering ongoing fees and annuity payments related to the funds in the portfolio When the CMA is used for ongoing fee payments it is called as an Expense Management Account EPA and for Annuity as an Income Management Account IMA The system calculates the ongoing fees as well as the annuity payments for a period of one year This chapter contains the following sections e Section 10 1 Cash Management Account Cash Management Account This section contains the following topics
133. r a 100 policy withdrawal transaction Adjustment Transaction Sub Types Section _ Adjustment Transaction Sub Types 1of1 Applicable AdjTxn Type Applicable AdjTxn Description Specify the applicable transaction sub types for the adjustment withdrawal If you do not specify it then all outflow transactions would affect withdrawal counter at policy level Aa ORACLE 4 1 7 Available Transaction Sub Types Mandatory The transaction sub types in the column Applicable AdjTxn Type are the transactions that can be mapped to this withdrawal You can add the transaction sub types by clicking add icon Portfolio Mapping Tab You will need to maintain the Product Portfolio details A Product Portfolio contains the funds that are mapped to the Product and available to customers for investing when they take a policy in that Product Note This section is mandatory You will have to enter information in all fields Click PortFolio Mapping tab to enter the details Product Maintenance Detail A B Save Product Information Product ID Existing Product Ni Product Name Product Base Currency Fl Rule Effective Date E Currency Name Product Short Name P Product Country _ H Product Mnemonic Product Country Description i Product Type a Plan Administration By dS Product Type Description ie Plan Administration By i 5 Plan Administrator ae Product Class Description ie Plan Admini
134. r a rule for a rule sequence 1 you can define two components with a threshold percentage within 0 100 Rule a Components Operator Threshold ID Description selected for the iat a NE percentage rule 9755S 0 _ 100 Rule1 PIG Compliance Total CA1 CA2 lt 100 Cash Rule2 FOREXCOMPLI CA2 EQ2 PR2 lt 15 ANCE ea ORACLE Cession Applicability Optional Indicate whether you want to allow policies associated with this product for policy cession maintenance Refer to the chapter Policy Cession Maintenance in the LEP User Manual for details ROA Applicable Optional Indicate whether a Rate of accumulation is applicable for a product 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 For an ROA function to be applicable a cumulative load would be setup and mapped in the Load Product Tax Aggregation Allowed Optional Check if tax aggregation is applicable for the product CGT Reporting Currency Optional Specify the currency in which the capital gains and capital gains tax amount should be reported The capital gains and capital gains tax amount which is computed at the fund level in the fund base currency will be converted in terms of the reporting currency using the default exchange rate If you do not maintain a reporting currency the s
135. rd that you want to amend The Product With Holding Tax 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 6 2 8 Authorizing Amended Product With Holding Tax An amended Product With Holding Tax must be authorized for the amendment to be made effective in the system ORACLE 7 1 7 1 1 7 Periodic Load For a Unit Trust UT transaction periodic loads are maintained at the Fund level For a Life and Endowment Product the periodic load is maintained at the Product level You can apply a periodic load to a Product and also to the underlying fund This chapter contains the following sections e Section 7 1 Periodic Load Maintenance Periodic Load Maintenance This section contains the following topics e Section 7 1 1 Invoking the Periodic Load Maintenance Screen Invoking the Periodic Load Maintenance Screen The Periodic Load Maintenance screen shown below facilitates the same You can invoke the Periodic Load Maintenance Detail screen by typing UTDPERLM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Periodic Load Maintenance Detail H save a Reference Number az eal Periodic Load Maintenance Fund ProductGroup Fund x Fund ID a Rule Effective From Date Rule Ef
136. re Property 20 e Offshore Cash 05 e Offshore Equity 05 e Offshore Property 05 The asset allocation for fund F2 is e Onshore Cash 30 e Onshore Equity 50 e Onshore Property 05 e Offshore Cash 10 e Offshore Equity 05 e Offshore Property 0 Assuming that an investor chooses to invest in the product with an initial investment of 100 000 ZAR the various components of F1 and F2 have the corresponding values F1 e Onshore Cash 25 of 150 000 100 000 62 500 ZAR 14 1 ORACLE 11 1 2 e Onshore Equity 40 of 150 000 100 000 100 000 ZAR e Onshore Property 20 of 150 000 100 000 50 000 ZAR e Offshore Cash 05 of 150 000 100 000 12 500 ZAR e Offshore Equity 05 of 150 000 100 000 12 500 ZAR e Offshore Property 05 of 150 000 100 000 12 500 ZAR i Onshore Cash 30 100 000 30 000 ZAR e Onshore Equity 50 100 000 50 000 ZAR e Onshore Property 05 100 000 5 000 ZAR e Offshore Cash 10 100 000 10 000 ZAR e Offshore Equity 05 100 000 5 000 ZAR e Offshore Property 0 100 000 0 ZAR Calculating we get e Total Cash across F1 amp F2 62 500 12 500 30 000 10 000 115 000 ZAR e Total Equity across F1 amp F2 100 000 12 500 50 000 5 000 167 500 ZAR e Total Property across F1 amp F2 50 000 12 500 5 000 0 67 500 ZAR Hence we can deduce the percentage allocation for each of the components to be e Cash Ons
137. reen e Section 11 2 2 Retrieving PIGSFOREX Compliance in PIGSFOREX Compliance Screen e Section 11 2 3 Editing PIGSFOREX Compliance e Section 11 2 4 Viewing PIGSFOREX Compliance e Section 11 2 5 Deleting PIGSFOREX Compliance e Section 11 2 6 Authorizing PIGSFOREX Compliance 114 ORACLE 11 2 1 e Section 11 2 7 Amending PIGSFOREX Compliance e Section 11 2 8 Authorizing Amended PIGSFOREX Compliance Invoking the PIGSFOREX Compliance Summary Screen You can invoke the PIGSFOREX Compliance Summary screen by typing UTSPIGSC in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button PIGSFOREX Compliance Detail Authorized PIGS Or FOREX Operation Open RulelD Threshold Percentage 0 100 a cm Em Advanced Search Records per page 15 v Authorized Open Status PIGS Or FOREX RulelD Operation Threshold Percentage 0 100 Description 4 11 2 2 Retrieving PIGSFOREX Compliance in PIGSFOREX Compliance Screen You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the PIGSFOREX Compliance 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 B
138. retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The PIGS Batch Maintenance Detail screen is displayed Select Authorize operation from the Action List When a checker authorizes a record details of validation 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 PIGS Batch Maintenance Record After a PIGS Batch Maintenance record is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the PIGS Batch Maintenance Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The PIGS Batch Maintenance Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes Authorizing Amended PIGS Batch Maintenance Record An amended PIGS Batch Maintenance record
139. rner of the Application tool bar and clicking on the adjoining arrow button Product Type Maintenance Detail New 3 Enter Query Product Type Maturity Date Basis Retirement Age v Description IRA Applicable No Life Insurance Feature Suppoded Apply 120 Rule Yes Premium and Annuity Minimum Age For Entry Applicable Maximum Age For Entry Retirement Feature Minimum Age For Exit Supported Maximum Age For Exit Allow Investment Into Money Allow Unit Based No Market Funds Transactions Override Age Limit Funding Feature Supported Included Transaction Sub Types 1of1 Transaction Sub Type Description m Input by DateTime Authorized by DateTime Mod No Open Authorized You will have to enter information in the following fields Product Type 4 Characters Maximum Alphanumeric Mandatory Specify a unique identification for the Product Type that is being defined through this screen This identification will be used whenever subsequent reference is made to this Product Type in the system Description Mandatory Give the Product Type a description which will help you identify the same easily Life Insurance Feature Supported Mandatory Select this option to indicate the Product Type supports Life Insurance features If you select this option you will have to specify the life cover amount at the policy level During the initial investment the specified amount will be
140. roduct tax class records using Product Tax Class Maintenance Summary screen To invoke this screen type LESPRTA in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Tax Class Maintenance Summary H save W Refresh Reset P Clear All l Details Search Is Case Sensitive Authorized Records per page 15 1 of 2P EE Lock columns ofe Authorized Open UH Category TaxClass ProductID Authorized Open DI UPF PRDR1 Authorized Open PA IPF DIV01 Authorized Open PA IPF PRDR1 Unauthorized Open LP RPF DIV01 Unauthorized Open DI RPF DEDER Authorized Open LP IPF UPRD1 Authorized Open PA RPF UPRD1 Authorized Open LP IPF PRDR1 Unauthorized Open CO RPF DIvo1 Unauthorized Open DI UPF DIV01 Unauthorized Open DI UPF UPRD1 Authorized Open A12 CA Unauthorized Open UPF LEPPRD1 Unauthorized Open IPF TAPRODOS Unauthorized Open UPF LEPPRD1 You can retrieve previously entered Product Tax Class Maintenance Details as follows e Invoke the Product Tax Class Maintenance screen from the Browser oar ORACLE 3 8 2 3 8 3 3 8 4 e Specify any or all of the following details in the screen The status of the transaction in the Authorized field If you choose the blank space then both the authorized and the unauthorized status records will be retrieved for the
141. roducts that you have maintained When you select the Product ID and click Get Funds button the funds mapped to it will be displayed in the Fund ID section For each fund that you want to apply the management fee to select the corresponding box Details 4 100 i FundiD Management Fee Applicable a YES v E Input by DateTime oA ORACLE 8 2 8 2 1 8 2 2 Saving Information Entered When you have entered all the mandatory information click Ok button The system displays the confirmation message as Record Successfully Saved This indicates the record has been saved Click Ok button Management Fee Applicability Summary Screen This section contains the following topics e Section 8 2 1 Invoking the Management Fee Applicability Summary Screen e Section 8 2 2 Retrieving Management Fee Applicability e Section 8 2 3 Editing Management Fee Applicability e Section 8 2 4 Viewing Management Fee Applicability e Section 8 2 5 Deleting Management Fee Applicability e Section 8 2 6 Authorizing Management Fee Applicability e Section 8 2 7 Amending Management Fee Applicability e Section 8 2 8 Authorizing Amended Management Fee Applicability Invoking the Management Fee Applicability Summary Screen You can invoke the Management Fee Applicability Summary screen by typing LESMGMAP in the field at the top right corner of
142. s 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 Product Type An amended product 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 Product Nature of Fund Mapping This section contains the following topics e Section 3 5 1 Invoking Product Nature of Fund Mapping Screen Invoking Product Nature of Fund Mapping Screen You can map nature of fund to specific products You can map only those products which are marked as PIGS compliant at product level You can invoke the Product Nature of Fund Mapping screen by typing LEDPNFM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Nature Of Fund Mapping k B Save ProductiD Nature OfFund a Pics Yesi FOREX Yesi Input by DateTime Mod No Open Authorized by DateTime Authorized ox cancel You can specify the following details Product ID Alphanumeric 8 Characters Optio
143. s to be deducted To deduct the capital Gain Tax a separate Load will be mapped under Product load mapping as post allocation load If the Slab basis is selected as weighted average then this load will be applied on the Gain portion and tax will be deducted and only the net amount will be paid to the customer Auto Clear Reinvestments Mandatory Indicate whether 100 outflow transactions based on the product should include freeze held and reinvestment units 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 Foreign Exchange Compliance Optional Indicate if you are defining rules for Foreign exchange compliance You can define rules by selecting either Prudential Investment Guidelines or Foreign Exchange Compliance The rules are defined on the number of investment components available or also a combination of these investment components There is no restriction placed on the number of components which can be selected to define a rule For example you can specify two components fo
144. saction Sub Type Maintenance Detail screen is displayed e Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The Transaction Sub Type Maintenance Detail screen is closed and the changes made are reflected in the Transaction Sub Type Maintenance Summary screen Viewing Transaction Sub Type Maintenance Record To view a record that you have previously input you must retrieve the same in the Transaction Sub Type Maintenance Summary screen as follows e __ Invoke the Transaction Sub Type Maintenance Summary screen from the Browser e 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 e Specify any or all of the details of the record in the corresponding fields on the screen e Click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen e Double click the record that you want to view in the list of displayed records The Transaction Sub Type Maintenance Detail screen is displayed in View mode oe ORACLE 3 3 4 Deleting Transaction Sub Type Maintenance Record You can delete only unauthorized records in the system To delete a record that you have previously entered e Invoke the Transaction Sub Ty
145. seeeeeseesnneeeeeessnnnneeeneennnnees 5 14 5 4 7 Amending Product Entity cccccccccecceceeeeeeneeeesenneeeeeesesneeeeeesnnnneeeeesnnnneees 5 14 5 4 8 Authorizing Amended Product Entity 00 ececcccceceesneeeeeesneeeeeeeenneeeeeneennneees 5 15 6 Product With Holding Tax ccccseeeeeeeeneeeeeeeeeeeeeeeeeneeeeeeeeeseeeneeeeeeeees 6 1 6 1 With Holding Tax Product eniinn aeii edea eia A a 6 1 6 1 1 Creating and Saving With Holding Tax PrOQUCE cccscecceeeteeeteeeesneetees 6 1 6 1 2 Invoking Product With holding Tax Detail Screen 1 ccccccccscttessteetsseeeees 6 2 61a Rebate Details TaD pienie aa es to ee ee se 6 3 6 1 4 Tax Class Details Tab ccccccccccssceeccessecseneeecenaeecseneecseasssseneeetsenssteneeessnneees 6 4 6 1 5 Saving information Entered ccccccccccccseccecssseecseeeessneeeseneeesseseseeseetsnaness 6 4 6 2 Product With Holding Tax Summary Screen 0 0 0 eee eeeeeeeeeeeeeeeeeeeeseeeeeeeeenaaeees 6 4 6 2 1 Invoking Product With Holding Tax Summary Screen cccccccsseceseeeees 6 5 6 2 2 Retrieving Product With Holding Tax in Product With Holding Tax Screen 6 5 6 2 3 Editing Product With HOldinG TAXx ccccecscceeceessceeeeeeenceeeeteeeeeeetnnnneeeennees 6 6 6 2 4 Viewing Product With Holding TAX ccscscccceeescteeteeeneeeeesenneeeeetneeaeeerennee 6 6 6 2 5 Deleting Product With Holding Tax cs sccccceesseeceeeseneeeeesseieeereseenaeerennes 6 7 10 11 6 2
146. set aside for Life Insurance and the remaining amount will be invested in the policy oe ORACLE Premium and Annuity Applicable Mandatory Select this option to indicate the Product Type supports Premium and Annuity If you select this option you will have to specify Premium and Annuity details in the Product Maintenance screen The same is explained in the chapter Product If you do not select this option you will not have to specify Premium and Annuity details Retirement Feature Supported Mandatory If you select the option Yes you will be allowed to capture details such as the retirement age based on which the maturity date will be calculated Also the field Retirement Age in the Product Maintenance screen will be enabled only if you select the option Yes Allow Investment Into Money Market Funds Mandatory Select the option Yes to indicate the Product Type allows investment into Money Market Funds Override Age Limit Optional Select this box to indicate the age limits entered in this screen can be changed for a Product under this Product Type through the Product Maintenance screen Note The value you enter in the field Minimum Age for Exit should be greater than the value you enter in the field Minimum Age for Entry The value you enter in the field Maximum Age for Exit should be greater than the value you enter in the field Minimum Age for Entry Fund
147. sociation e Section 5 4 Product Entity Summary Screen Product Load This section contains the following topics e Section 5 1 1 Setting up Product Load e Section 5 1 2 Invoking Screen Setting up Product Load You can designate different fees or incentives that are levied during the processing of transactions as applicable for transactions in specific products Fees or incentives called loads in the system may be mapped as applicable to the appropriate transaction types for the appropriate products The load details maintained will be attached to the products using this maintenance screen a ORACLE 5 1 2 Invoking Screen You can invoke the Product Load Maintenance Detail screen by typing LEDPRLD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Load Maintenence Detail New 75 Enter Query Product ID Rule Effective Date Product Name LatestRule No Product Load Details Seq No No of Decimals Transaction Type Round OfffTruncate Round Off X Transaction Name VAT Applicable No Load ID Load Description From Entity Type Description Level ID To Entity Type Dependent Level Description LoadToPrice Yes Slab Basis Gross Amount Price Addin Yes Processing Frequency Allocation Apply To Product No Other Details 1of1 Ref Type Description Fund Details 1of1
148. ssed Tia ORACLE 11 1 3 Invoking PIGS FOREX Compliance Screen You can invoke the PIGSFOREX Compliance Detail screen by typing UTDPIGSC in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button PIGSFOREX Compliance Detail 4 Save PIGS FOREX Compliance Rule Type Batch PIGS iy Operation Select One w RulelD Threshold Percentage 0 100 Rule Description a Related Components Input by DateTime Open Authorized by DateTime Authorized Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the PIGSFOREX Compliance PIGS FOREX Compliance Section Rule Type Mandatory Select the rule type from the drop down list The list displays the following values e Batch PIGS e Online PIGS e Batch FOREX e Online FOREX e Related Components Rule ID Alphanumeric 8 Characters Mandatory Specify an identifier for the rule applied to the component Rule Description Alphanumeric 8 Characters Mandatory Specify a brief description of the component allocated to the fund investment Tig ORACLE 11 1 4 11 1 5 11 1 5 1 11 2 Operation Select that the components are to considered as equivalent to the percentage of the fund investment allocation The list displays the following values e lt e gt e lt e gt Threshold percentage 0 100 The ratio or percentage attributed to
149. stem 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 Management Fee Applicability 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 Management Fee Applicability 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 Management Fee Applicability 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 ch
150. strator a Description Fetch Product Type Info Product Details Additional Investments Bank Details Withdrawals FAULO Elsie Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency FATCA Information Regulation 28 parameters Back Dating Details Back Dating Allowed Yes Back Dating Period UCITS Fund Allowed Nol Product Portfolio Available Sponsor 10f1 HEI 1of1 HHE al Fund ID Fund Name Exclude from Auto Switch ReinvestmentFundID Fund Name Short 7 Sponsor ID Description l a3 ia pz aH pl Input by DateTime Mod No Open Authorized by DateTime Authorized BackDating Details Section BackDating Allowed Mandatory Select this option to indicate back dating is allowed for transactions carried out for policies under this product You will be allowed to change this option for a fund under the product aN ORACLE BackDating Period Optional This field will be enabled if you have specified that back dating is allowed for transactions under this product Specify the number of days by which the transaction can be back dated UCITS Allowed Select if UCITS is allowed or not from the adjoining drop down list Following are the options available e Yes e No If you select Yes during the portfolio mapping you can select UCITS funds as part of portfolio If you select No then during portfolio mapping the system wi
151. t Type Maintenance screen Retirement Age Mandatory and Enabled only if Maturity Date Basis for Product Type 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 with policies in this Product will become eligible for retirement benefits if any This field will be enabled only if for the Product Type in the Product Type Maintenance screen e You have selected the option Yes against the field Retirement Features Supported e You have selected the option Retirement Age against the field Maturity Date Basis Minimum Age for Entry Numeric Optional The minimum age before which a Policy Holder cannot subscribe to a policy under a Product of this Product Type will be displayed Maximum Age for Entry Numeric Optional Specify the maximum age after which a Policy Holder cannot subscribe to a policy under a Product of this Product Type Minimum Age for Exit Numeric Optional Specify the minimum age before which a Policy Holder cannot close a policy under a Product of this Product Type ORACLE Maximum Age for Exit Numeric Optional Specify the maximum age after which a Policy Holder is not allowed to have holdings in the Product Note The age limits that you have specified for the Product Type through the Product Type Maintenance screen will be displayed in the above fields You will be allo
152. t Value Minimum Withdrawal Amount 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 Amount 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 Compounding Factor Optional This field will be enabled if you have specified the Withdrawal Limit Mode as Percentage and the Withdrawal Limit Basis as Compounded Contribution Specify the compounding factor to be used in calculations Withdrawal Money Payable Optional Specify whether the withdrawal money is payable to the customer administrator or product account Automatic Surrender Section Process Automatic Surrender Indicate whether a policy should be automatically surrendered if the market value of the policy goes below a threshold amount Consequently when you do surrender by default the money will be transferred to the unitholder s bank account But here the money will be transferred to the bank account of the product and not to the unitholder Threshold Policy Market Value You will be allowed to enter the threshold policy market value if you have selected Yes for Automatic Surrender If the policy market value reaches less than the amount that you specify here the system will automatically trigge
153. t typifies such as endowment annuity and so on Note Product Types can be defined through the Fund Manager component only The Product Type Maintenance screen allows you to capture the generic characteristics of the Product Type you wish to maintain The next section gives you step by step instructions to do the same This chapter contains the following sections e Section 3 1 Product Type e Section 3 2 Transaction Sub Type e Section 3 3 Transaction Sub Type Maintenance Summary e Section 3 4 Product Type Summary Screen e Section 3 5 Product Nature of Fund Mapping e Section 3 6 Product Nature of Fund Mapping Summary e Section 3 7 Product Tax Class Maintenance e Section 3 8 Product Tax Class Maintenance Summary Product Type This section contains the following topics e Section 3 1 1 Creating and Saving Product Type e Section 3 1 2 Invoking Screen e Section 3 1 3 Saving Information Entered Creating and Saving Product Type The following are the steps you need to follow to define a Product Type Each of these steps is explained in detail in subsequent sections e Invoke the Product Type Maintenance Detail screen e Enter information in the Product Type Maintenance Detail screen e Save the information entered I ORACLE 3 1 2 Invoking Screen You can invoke the Product Type Maintenance Detail screen by typing LEDPRTYP in the field at the top right co
154. the Application tool bar and clicking on the adjoining arrow button Management Fee Applicability Summary Authorized Product ID Advanced Search Reset Records per page 15 v Authorized Open Product ID Retrieving Management Fee Applicability You can retrieve a previously entered record in the Summary screen as follows Specify any or all of the following details in the Management Fee Applicability Summary screen ee ORACLE 8 2 3 1 Select the status of the record in the Authorization 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 Product 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 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 Sy
155. the CMA When a top up transaction in a policy takes place the system calculates the projected ongoing fee payable for a year and compares this with the balance in the CMA Fund If the projected fee is greater than the CMA fund value the difference is deducted from the investment proportionately The system does this by overriding the ongoing fee record with the updated return value The updated return value is calculated as follows Updated Return Value Projected Amount CMA fund market value Projected amount Original Return Value The system carries out monthly checks for sufficient funds in the CMA to cover the ongoing fee for a full year In case of a deficit the system proportionately switches the deficit amount from other funds into the CMA The system also carries out monthly checks for sufficient funds in the CMA to cover the annuity for a full year In case of a deficit the system proportionately switches the deficit from other funds into the CMA Let us consider the following examples The fee set up in an AMC is defined below Rate L4 Ongoing Admin Fee per annum Slab in ZAR Rate in 0 100 000 0 5 100 000 500 000 0 25 L5 Ongoing Broker Fee per annum Slab in ZAR Rate in 0 100 000 0 5 100 000 500 000 0 25 L1 Initial Admin Fee Slab in ZAR Rate in 0 100 000 2 5 10 2 ORACLE 10 1 3
156. the chapter Setting Up Loads in Volume of the Fund Setup User Manual for further information on applying periodic load tee ORACLE 8 1 8 1 1 8 Management Fee Management fee is the periodic load charged by the AMC from the customer This fee that the policyholder is charged will be used to pay the brokers their commissions Management fee is calculated for the total holding in the policy across all the funds and the amount is deducted from the customer s holdings through a redemption policy transaction An AMC however might not want to apply a fee on some funds The Management Fee Applicability screen allows you to apply a management fee to the funds you wish While generating a redemption transaction for the management fee the system first checks if you have selected a fund against the field Preferred Fund For Redemption in the Unit Holder Maintenance screen for further information on the Unit Holder Maintenance screen refer to the chapter Managing Investor Accounts in Volume 1 of the Agency Branch User Manual e lf you have a redemption transaction will be generated for the fund you have selected e If you have not a redemption transaction will be generated for funds you have marked as being applicable for Management Fee Note You can apply a Management Fee to funds through the Fund Manager component only The next section gives you step by step instructions to do the same This chapter conta
157. tio of annuity to the net investment amount This will determine the lower limit of annuity amount payable in a policy Note This will be used for the 5 20 validation during Batch functions Refer to the chapter Batch Functions in this User Manual for further information on the 5 20 validation Maximum Annuity Ratio Mandatory Specify the ratio of annuity to the net investment amount This will determine the upper limit of annuity amount payable in a policy Note This will be used for the 5 20 validation during Batch functions 4 21 ORACLE Refer to the chapter Batch Functions in this User Manual for further information on the 5 20 validation Others Section Certificate of Existence Applicable Optional You can select Yes to indicate the Policy Holder needs to produce a certificate of existence Guaranteed Annuity Optional Select Yes to indicate annuity is guaranteed on a policy in this Product Annuity By Fund Optional Specify whether annuities are paid out for on the basis of the funds in the Product Bonus Applicable Optional Select Yes to indicate this Product declares a bonus Life Cover Applicable Mandatory Select Yes to indicate whether the Policy Holder has an option to opt for a life cover while subscribing to this Product Life Cover Amount Mandatory if Life Cover Applicable box is checked Specify the amount to be paid by the Policy Holder as a fee for
158. to modify in the list of displayed records The Product Entity 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 Product Entity Detail screen is closed and the changes made are reflected in the Product Entity Summary screen Viewing Product Entity To view a Product Entity you have previously entered you must retrieve the same in the Product Entity Summary screen as follows 1 Invoke the Product Entity Summary Screen from the Browser oe ORACLE 5 4 5 5 4 6 5 4 7 2 Select the status of the Product Entity 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 transactions 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 Product Entity screen is opened in view mode Deleting Product Entity 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 Product Entity Summary screen as follows 1
159. ual Annuity Limit Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Product Annual Annuity Limit Detail screen is displayed Select Authorize operation from the Action List When a checker authorizes a record details of validation 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 Product Annual Annuity Limit Record After a Product Annual Annuity Limit record is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the Product Annual Annuity Limit Summary screen from the Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details in the corresponding fields on the screen e Click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower porti
160. us field If you choose the Blank Space option then all the records are retrieved e Product Type e Description 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 a ORACLE 3 4 3 3 4 4 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 Type 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 Editing Product Type 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
161. uthorize Reverse Confirm operation by selecting from the Action list You can also search the record by using combination of and alphanumeric value Editing Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping 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 Product Transaction Sub Type Mapping Detail screen is closed and the changes made are reflected in the Product Transaction Sub Type Mapping Summary screen Viewing Product Transaction Sub Type Mapping To vie
162. ve Date Product Name Product Base Currency Product Short Name Currency Name Product Mnemonic Product Country Product Type Product Country Product Type Description Description Product Class Plan Administration By Product Class Plan Administration By Description Description Plan Administrator Plan Administrator Description WHT Applicable Reinvestment Product Details Additional Inv Bank Det Withdrawals PortFolio Mapping Premium And Annuity Loan And Funding Income Distribution Rule Transaction Currency Premiums and Annuities Multiple Premiums Yes Annuity Applicable Yes wes me ra Minimum Annuity Amount TE le Maximum Annuity Amount Maximum Premium EEE Am Amount Maximum Annuity Ratio Premium Step Amt Auto Premium Recovery Yes Others Annuity By Fund No Bonus Applicable No Certificate of Existence No Guaranteed Annuity No Applicable i T Life Cover Amount Life Cover Applicable No Annuity Tax Computation Policy Basis Input by DateTime Mod No Authorized by Open exit DateTime Authorized Premiums and Annuities Section Multiple Premiums Allowed Mandatory You can select Yes if multiple premiums are allowed on the Product Auto Premium Recovery Mandatory If you select Yes the system will automatically generate all pending premium transactions if one of the following cases is applicable e The premium payme
163. vel if any and proportionately deducted from the profit Gain of the other funds The system will run a batch at EOD to compute the total gain on a policy outflow post unitization and generate a follow on CGT redemption transaction to the extent of capital gains Tax due to a Policy holder Losses will get logged in Policy Gain Loss table Follow on transaction will deduct units to recover any gains tax calculated at the Policy Level The system will use the preferred fund of the Unitholder for withdrawal of units to deduct the CGT If there is no sufficient balance in that fund for that unitholder then the system will use the latest portfolio percentage and generate a policy withdrawal on pro rata basis Note Follow on transaction to deduct CGT is applicable only for LEP transactions For UT the system will limit only to calculate the capital gains am ORACLE 4 1 4 The system will record the CGT amount that is due for outflow transactions Even if CGT transaction generation fails the system will calculate and log the CGT amount due on the outflow transaction which can then be used for further processing manually In case of 100 surrenders the capital gains amount due by the policy holder will be netted off from the settlement amount of underlying UT transactions If surrender amount is less than the capital gains tax amount then system will block EFT and carry forward the capital gains The system will map standard post all
164. ver the system defaults the value No FATCA Classification Alphanumeric Select the classification of FATCA from the adjoining option list FATCA Classification is mandatory if FATCA Applicable is Yes FATCA Reason Alphanumeric Optional Specify the reason for FATCA classification Employer ID Number Alphanumeric Specify the employer ID number The Employer ID Number is mandatory if the FATCA Applicable is Yes AI ORACLE 4 1 13 FATCA Effective Date Date Format Specify the FATCA Effective Date if FATCA is applicable FATCA Effective Date cannot be lesser than the product rule effective date Regulation 28 Parameters Tab In this section you can capture the details regarding regulation 28 parameters Click on Regulation 28 Parameters tab to maintain the details This tab is enabled only if product is PIGS compliant product Product Maintenance Detail H save Product Information Product ID Product Name Rule Effective Date E Product Short Name Product Mnemonic Existing Product Product Base Currency Currency Name Product Country Product Country Description No i Product Type LH Plan Administration By az Product Type Description 2 Plan Administration By ie I Plan Administrator Product Class Description P 5 Plan Administrator 2 Description Fetch Product Type Info Product Details Additional Investments Bank Details Withdrawals Portfoli
165. verse 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 Product Entity 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 Product Entity Summary screen from the Browser 2 Select the status of the record that you want to retrieve for modification in the Authorized 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
166. w a Product Transaction Sub Type Mapping you have previously entered you must retrieve the same in the Product Transaction Sub Type Mapping Summary screen as follows 1 Invoke the Summary Screen from the Browser 2 Select the status of the Product Transaction Sub Type Mapping 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 transactions 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 Product Transaction Sub Type Mapping screen is opened in view mode Deleting Product Transaction Sub Type Mapping You can delete only unauthorized records in the system a0 ORACLE 4 4 6 4 4 7 To delete a record that you have previously entered you must retrieve the same in the Product Transaction Sub Type Mapping Summary screen as follows 1 Invoke the Product Transaction Sub Type Mapping 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 Se
167. wed to change the same for a Product if for the Product Type you have selected the option Override Age Limit Minimum Initial Investment Numeric Optional Specify the minimum amount that a Policy Holder has to contribute to hold a policy in this Product at the time of policy creation Maximum Initial Investment Numeric Optional Specify the maximum amount that a Policy Holder can invest while making an initial investment in a policy in this Product Note The Policy Holder can top up the policy later if additional investment is allowed for the Product The same can be indicated through the screen that is invoked when you click on the Additional Investments link The same is explained in subsequent sections Tax Deductible Contributions Allowed Mandatory This field will be enabled only if for the Product you have selected the option IRA Enabled Select Yes to indicate tax deductible contributions are allowed for the IRA Product Maximum Annual Contribution This field is locked for non retirement products Early Termination Allowed Optional A policy in a Product can be terminated earlier than the Maturity Date of the Product Select Yes if such a termination is desired to be applied to policies in this Product Policy Statement Frequency Mandatory Specify the frequency at which policy statements must be generated for a Policy Holder who has subscribed to a policy in this Product Fiscal Start Date
168. y Beneficiary Details Mandatory Noe Product End Date B Maximum Age For Entry Constituent Details Mandatory Nde Fiscal Start Date 5 Minimum Age For Exit Pay Broker Commission to Nof Fiscal End Date E Maximum Age For Exit Product Prod Min Tenor Retirement Age Poder Noy t Policy Statement Frequeng f wg eet Sai Foreign Exchange Compliance Nof lI i ll Ul Description Minimum Initial Investment vai Cash Management Account Nol Masima ini ineat Applicability Maximum Annual Contribution CMA Fund LH ROA Applicable No j 7 Description ROA Computation Method 7 WAC Method Regular WAGI Restrict CMA For Initial Nog Description Redeem aare rem Noj IAN GWENAN EORPA Nd CMA Fund Include Re Investment For Nox CGT Applicable No ROA Generate Redemption For i PATE Ndz Input by DateTime Mod No Open Authorized Authorized by DateTime Select New from the Actions menu in the Application tool bar or click new icon to enter the details of the Product Product Information Section Product ID 10 Characters Maximum Alphanumeric Mandatory Specify a unique identification for the product that is being defined through this screen This identification will be used whenever subsequent reference is made to this product in the system The ID you enter can contain a maximum of 4 characters Product Name 60 Characters Maximum Alphanumeric Mandatory Give the Product ID a description which will help you identif
169. y 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 Product Name e Rule Effective 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 Product Type 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 4 2 3 Editing Product 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 Product 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 f
170. y the same easily Product Short Name 20 Characters Maximum Alphanumeric Mandatory Specify a short name for the product 2 ORACLE Product Mnemonic 10 Characters Maximum Alphanumeric Mandatory Specify a mnemonic for the product The mnemonic is typically used as an identifier to run queries or to generate reports regarding the product Product Type Mandatory The various Product Types you have already maintained through the Product Type Maintenance screen will be available for selection in the option list Select the Product Type that is applicable to the Product Product Class Mandatory The Product Classes that you have specified through the System Parameters screen will be available for selection in the option list Rule Effective Date dd MM yyyy Mandatory Specify the date from which the Product profile definition will become effective for all transactions in this product By default this date is displayed as the next working day in the system Product Country Mandatory Select the country where the product will operate from the options provided in the option list When the system computes the withholding tax applicable on annuity payments in this Product the base country information that is specified here is taken into consideration Product Base Currency Mandatory Select the currency that the Product will use from the options provided in the option list The currency that you choose for the product will be t
171. ystem will convert the capital gains and capital gains tax amount only in terms of the product and policy base currency Prudential Investment Guidelines Indicate if you need to define the rules for Prudential Investment guidelines You can either select Prudential Investment Guidelines or Foreign Exchange compliance Include Current TXN for ROA Specify whether the current transaction should be considered for calculating ROA Include Switches for ROA Indicate whether switch transactions affect ROA computation ROA Computation Method Select the appropriate method to calculate the right of accumulation from the option list The ROA may be calculated on the basis of e Amount invested in the policy by the policy holder e Holdings of the customer as on that date e Holdings subscription price as on that date e The current days transaction value Include Reinvestments for ROA Indicate whether the reinvestments affect the ROA calculation Cash Management Account Applicability Select Yes if you want to make the Cash Management Account feature available in this product else select No asto ORACLE 4 1 3 1 If you have chosen this option you need to also specify your choices for CMA Fund Restrict CMA for Initial Investments and Redeem Periodic Fee from CMA Fund This lays the rules for the operation of the CMA Fund CMA Fund Specify a fund to be the CMA fund You can select from the option list Restrict CMA for Initi

Download Pdf Manuals

Related Search

Related Contents

HCL-57E  取扱説明書ダウンロード  STAGE BAR 16 USER MANUAL  HP Removable Hard Drive Enclosures  SuperMicro P3TDDE Motherboard  Gladiator GAWB06MTZG Instructions / Assembly  LaoWord 4.1 User`s Manual  Wideband Air/Fuel Meter User Manual  A software application for calculating loads and actions in  Digital Projector X30  

Copyright © All rights reserved. Failed to retrieve file