2.2 Set up of Country / Client Specific Changes
This topic provides information about the set up of Country / Client Specific Changes.
Set up of Country / Client Specific Changes
There
exist certain features in the system which are classified as country or client
specific. Thus a feature specific to a country will be used by a client in another
country. During any implementation the team should set up these features as either
applicable or not. The information is stored in a table called
CLIENTCTRYTBL and it contains the following fields:
- FUNCTIONCODE which is a code list of functions which are in the nature of country/client specific.
- CTRYCLIENTCODE which is a list of either the country or client where this feature is applicable. The entry here is compared by the system with the Country code/Client code available in the Defaults Table.
- FUNCTIONAPPLICABLE which is an indicator on whether the feature is applicable (-1) or not applicable (0).
Table 2-1 Illustration table on CLIENTCTRYTBL
| FUNCTION CODE | FUNCTION APPLICABLE | DESCRIPTION |
|---|---|---|
| ABSASPECIFIC | FALSE | ABSA client specific code execution |
| ACBDO | FALSE | ACB extract for SI settlement (DO) |
| ACCHIERINTER | TRUE | Populating the extract for Hierarchy intermediary |
| ACCPOLINTER | TRUE | Populating the extract for Policy intermediary |
| ACCTXNINTER | TRUE | Populating the extract for TXN intermediary |
| ACCUHINTER | TRUE | Populating the extract for UH intermediary |
| ADDBPCTOTXNBP | TRUE | Add Base Price Constant to Transaction Base Price. If it is set to 0, Base Price Constant gets added to (Price Basis Value-TBP). If it is set to - 1, Base Price Constant gets added to TBP during Fund Price save |
| ADMINTAX | TRUE | Admin Tax Facility |
| AFSBACKOFFICE | FALSE | This parameter is set for AFSBACKOFFICE specific features |
| AFSSPECIFIC | TRUE | AJF specific features |
| AFSTRADING | FALSE | This flag will enable AFS trading box functionality |
| AGCGT | TRUE | This parameter is set for AGCGT specific features |
| AGPAYMENT | FALSE | AG Payment for raise broker comm |
| AGSPECIFIC | TRUE | This parameter is set for AGSPECIFIC specific features |
| AGTRAILCOMM | TRUE | This parameter is set for AGTRAILCOMM specific features |
| AJFSPECIFIC | FALSE | This parameter is set for AJFSPECIFIC specific features |
| ALLOCDTFORSWTFX | FALSE | This parameter is set for ALLOCDTFORSWTFX specific feature |
| ALLOWFUNDAMEND | FALSE | If set to TRUE fund created in AMC can be amended in distributor |
| ANNUITYPAYLAG | FALSE | For Handling Annuity Payment Lag |
| AOSCGT | TRUE |
|
| AOSLLEP | FALSE | Certain LEP validations are enabled based on this parameter |
| AOSTRAILCOMM | FALSE | This parameter is set for AOSTRAILCOMM specific features |
| ATYTAXAGEFISCAL | FALSE | For Handling Annuity Payment Lag |
| AUTOGENASR | TRUE | For enabling auto generation of ASR message |
| AUTOGENAUTHREP | TRUE | This parameter is set for AUTOGENAUTHREP specific feature |
| AUTOGENCIF | TRUE | Automatic generation of CIF ID from unit-holder save, specific to JFAM |
| AUTOGENOSR | TRUE | For enabling generation of dummy OSR message |
| AUTOGENTXNREF | TRUE | If set to -1, reference number is system generated, if not entered by user. If the reference number is entered by user, the same is stored |
| AUTOGENUHREF | TRUE | AJF specific feature |
| AUTOREDATCIF | TRUE | This parameter is set for AUTOREDATCIF specific features |
| AUTOUPDIDSSI | TRUE | Auto Update IDS and SI Bank Details when Unitholder Bank Details are amended |
| BANKCHARGES | TRUE | For Enabling bank charges field in settlement screen |
| BANKINTEGRITY | TRUE | JFAM Specific |
| BKCLSOPTIONAL | TRUE | Book Closing Optional |
| BLKMATDATE | TRUE | Allows user to capture maturity date for block transaction. System will auto generate un-block transaction on the maturity date |
| BLOCKFUNDS | TRUE | This parameter is set for BLOCKFUNDS specific features |
| BRKCOMMBYPRTXN | FALSE | PR Broker commission sharing |
| BULKDEKA | TRUE | If set to -1, dot is changed to comma during upload of Transaction-Limit order price. Transaction values are defaulted based on this parameter. For e.g. for ZOP funds, transaction currency is defaulted to Entity base currency |
| BYPASSCIF | TRUE | If set to -1, CIF is created as a part of unit holder account opening, based on CIF id entered. Else, CIF needs to be created before unit holder account opening |
| CALCDLOADDEP | TRUE | ASF Specific |
| CANCSPECIFICSI | TRUE | This parameter will enable the system to cancel the specific standing instruction |
| CAPITALPAYALLOC | TRUE | Capital payout process will fail if allocation of CP transaction fails |
| CHECKFOLIONO | FALSE | This parameter is set for CHECKFOLIONO specific features |
| CHECKMINORAGE | TRUE | If set to -1, Unitholders Whose Age is greater than Funds Minor Age (as defined in Fund Investment Account Setup) are only allowed to invest |
| CHKBRKPARENT | FALSE | Check Parent in Broker fund mapping |
| CIFFORJOINTACC | TRUE | If set to -1, the Joint AC Holder specified should be a valid CIF in the system |
| CIFFORLINKENT | FALSE | Flag to switch on or switch of for CIF as Linked Entity |
| CIFFROMEXTSYS | FALSE | If set to -1, CIF is created as a part of unit holder account opening, based on unit holder reference number entered. Else, CIF needs to be created before unit holder account opening |
| CIFIDNTFCCHK | FALSE | If set to -1, Unitholders belonging to the same CIF must have the same Identification details |
| CIFUHUSERACCESS | FALSE | This Parameter will enable User Level SMS Cross Branching |
| CMAADJREQUIRED | TRUE | CMA Adjustment Required |
| COMPUTESINPD | TRUE | Auto compute SI Next Processing Date during Amend |
| CONFCHRGDETAILS | TRUE | For Populating Charge details in messages-swift |
| CONFCOMMDETAILS | TRUE | For Populating Commission details in messages-swift |
| CPFINST | FALSE | If set to -1, UH account type cannot be amended if it was created as CPF account type |
| CREATESWITCHIN | FALSE | This parameter will generate Switch In Txn on Save Of Switch Out Txn |
| DEALFIRST | TRUE | Enabling this ,system will check for the deal first even if campaign is attached, else existing flow |
| DEDUPCHKFORCIF | FALSE | If set to -1, each CIF can have only one unit holder per Account type |
| DEDUPCHKFORNRIC | FALSE | If set to -1, only One CPF Account Type can be maintained for a NRIC Number |
| DEFAULTCIF | TRUE | If this Parameter is Set to True System Allows the User either to enter a Valid CIF Number or Auto Generates a CIF Number(In UH-New A/C and Info Change Screens) |
| DEFAULTPAYMENT | TRUE | When this parameter is set system Defaults the payment details based on the payment mode. Also Bank Charges and Payment Charges will not be displayed under payment details. Also payment details will be defaulted as of transaction details |
| DEFSUBTYPUNPROC | FALSE | This parameter will default the transaction subtype and check for Unprocessed transactions |
| DEKAFUNDISIN | TRUE | If set to -1, certain fund elements needs to be mandatorily be captured. For e.g. FundIdentificationNumber, Custodian etc. are mandatory for a fund |
| DEKAGL | TRUE | If set to -1, AM Interface data stores are populated with Deka specific loads |
| DEKAINTERFACE | TRUE | If set to -1, Ready file gets generated during Interface definition export/import |
| DEKAREPORT | TRUE | If set to -1, Deka specific reports gets generated, instead of Core FCIS reports |
| DEKASPECIFIC | FALSE | This is used for Deka specific validations |
| DEKATRADE | TRUE | If set to -1, availability of creation/liquidation price as of the price date is not checked |
| DELIVERYAC | TRUE | If set to -1, certificate delivery preferences are captured for a unit holder |
| DIRECTDEBIT | TRUE | If set to -1, SubPaymentMode Direct Debit can be given for IPO and Subscription Transactions |
| DMSINSTALLED | TRUE | DMS is installed |
| ENFORCETPBANK | FALSE | Verify TP Bank Account |
| EXTRACTDTTM | TRUE | Consider Dealing Date as Swift Confirmation Trade Date |
| FATCAAPPLICABLE | TRUE | Flag to switch on or switch of FATCA compliance functionality |
| FCCINTERFACE | FALSE | FCC FCIS Interface Specific |
| HDFCSPECIFIC | FALSE | This parameter will make Min/Max Validations For the Switch In Fund |
| FNDMRGREXCLCGT | TRUE | In Fund Merger the Gain should be carried over from Transferee Fund to Transferor Fund. |
| FORBACKDATA | FALSE | This code should always be switched off in LOB schema |
| FORM6061ATTXN | FALSE | For Enabling form6061 validation at transaction level if investment amount crosses min tax amount |
| FORMULA | TRUE | Client country for usage of Fund formula |
| FORWARD_FX_RATE | FALSE | If this parameter is set then system would support spot and forward FX rate else only spot rate will be supported. |
| FPONALLOCLAG | TRUE | Deferred price entry based on allocation lag -- check present during price upload & price entry |
| FUNDAMEND | TRUE | Amendment of fund such that new rule effective date is today's date |
| GLPROFITORLOSS | TRUE | This Parameter will enable system to calculate P/L due to reversals and pass a GL entry |
| GTAENABLED | FALSE | This parameter is set in Global Transfer Agency Setup |
| HBGTRAILCOMM | TRUE | HBG method of trailer commission, using quarterly averages (for 5 quarters) |
| HDFCINTERFACES | FALSE | This parameter is set for HDFCINTERFACES specific feature |
| HEDGEFUND | FALSE | Hedge Funds Feature Enabled |
| HIERARCHYTRAILC | FALSE | Replaced AFSSPECIFIC parameter with this. If set to TRUE trail commission functionality will be similar to AFS trail comm |
| HSBCSPECIFIC | FALSE | When this parameter is set System calculates the Settlement Due date as Dealing Date + Payment Lag for the Fund and Transaction Type |
| IMAFUND | FALSE | PBCom specific. Not applicable |
| INITTXNEXSI | TRUE | INITTXNEXSI is a check that is used during transaction save. This indicates that if SI is the only transaction for UH + Fund combination, the transaction should still be considered as initial subscription. i.e., holdings due to SI are not to be considered for initial subscription check |
| INTERFACEMAPREQ | FALSE | This client country determines whether Interface mapping is required or not |
| INTIME | FALSE | Intime specific broker commission cheque amount calculation |
| INT_FCUBS | TRUE | Integration Enabled |
| INVRISKCHECK | TRUE | For Investor Risk check on SI generation |
| JOINTCIFDETAILS | TRUE | This Parameter is Used for Capturing Free Format Address Details For Joint Holders |
| KYCAML | TRUE | If set to TRUE, Know Your Customer and Anti Money Laundering functionality will be enabled |
| LIMITAPPLICABLE | FALSE | Shinsei Maruyu enabling (Non-tax limit applicable) |
| LNAMEMAND | TRUE | Last Name is Mandatory |
| LOAD1000FIRST | FALSE | JFAM method of computation for load 0 |
| LOCKVALUEDATE | TRUE | This parameter is set for LOCKVALUEDATE specific features |
| MANDNRIADD | TRUE | This parameter is set for MANDNRIADD specific features |
| MATDATE | FALSE | To enable Transaction Maturity functionality |
| MBSPECIFIC | FALSE | MASHREQ specific. If MPSPECIFIC is true, blocked units are checked from BLOCKMAPPINGTBL |
| MINORCONV | FALSE | MASHREQ specific. If TRUE, EOD process of updating minor status would temporarily stop the account (Stop account as 1) |
| MINREDSWCHBAL | TRUE | This parameter will indicate the minimum balance for Redemption and switch transactions |
| MONOCCY | FALSE | If MONCCY is true, processing does not check for exchange rates etc |
| MULTIPLEAMCDIST | TRUE | This Parameter is Set For Multiple Country Installation |
| NEGATIVEEPU | TRUE | DEKA specific -- if TRUE, EPU value can be -ve |
| NETUNALLOTEDAMT | TRUE | Unalloted minimum holding will be considered for minimum holding check |
| NEWGL | TRUE | FCIS GL -- New GL added this release |
| NOTRADINGAGE | TRUE | Trading box ageing not required |
| OASISSPECIFIC | TRUE | For Oasis Specific Requirements |
| OMIA120RULE | FALSE | For Online Enabling 120 Rule Validation |
| OUTFLOWCHECK | TRUE | Transaction Validation specific to CBQ |
| OVERRIDEMSG_SUB | TRUE | Provide an Overridable message during subscription save, if regular withdrawals are present |
| PASTAS | FALSE | This flag if enabled indicates that this FMG module is integrated with PAS module |
| PAYHELDBRK | TRUE | Process broker payments for hold back brokers |
| PLCOMPUTE | TRUE | Calculating the average cost in allocation |
| POLICYUTGENIN | TRUE | Will Generate the UT transaction as Incomplete for Policy Transaction if the Client Country Switched on |
| PREEODTXN | TRUE | Used during bulk upload to indicate if transactions can be uploaded when the system is offline |
| PRICEADDIN | FALSE | Price add in as method of computation to be used or not |
| PROPAGATION | FALSE | Used for Back Data Propagation |
| PSALLOWSAMEAMC | TRUE | For Enabling Same AMC for PS Txn |
| PTBCCUSTTITLE | TRUE | In PTBC title will be derived from defaultstbl |
| RECOVERFEE | FALSE | RECOVERFEE OMIA |
| RECT | TRUE | Transaction receipts |
| REDCONFCCYCHECK | FALSE | Enabling or disabling RedemptionConfirmation Ccy Check functionality. |
| REINVFORSTOPAC | TRUE | Reinvestments will be allowed for accounts marked with unit-holder status codes, specific to JFAM |
| REINVFORUHRST | TRUE | Reinvestment generation for restricted UH - Fund entity restriction |
| REINVINTMEDIARY | TRUE | If this flag is enabled, Reinvestment will happen based on the txn level intermediary else UH level intermediary |
| RETIREMENTCHK | TRUE | Retirement Funds check |
| REVFUTURETXN | TRUE | This flag decides future dated transaction can be reversed or not |
| ROIALLOC | FALSE | Computation of base price considering ROI (during allocations) |
| ROICOMP | FALSE | Fund family input enables ROI calculation checkbox based on this client country |
| RPONOIMPACT | FALSE | No Impact for the RPO Code Selected at UH (OMSTA) |
| HSBCGTASPFC | TRUE | This Parameter will enable HSBC’s Specific SMS Cross Branching |
| SHINSEISPECIFIC | FALSE | Transaction validations specific to Shinsei |
| SHOWPANINFO | FALSE | Indicate ‘Tax Id’ as ‘PAN/GIR Number’ |
| SICREDISPECIFIC | TRUE | In order to divert the flow of Amount Block Maintenance |
| SIRULEATFREQ | FALSE | This parameter will make SI Rule Based on Frequency |
| SKIPGLFORREV | TRUE | This Parameter will skip GL for Txn's getting reversed on the same day |
| STRUCTADDRESS | TRUE | This parameter is set for STRUCTADDRESS specific feature |
| SUBMATDATE | TRUE | Automatic Redemption with respect to Subscriptions Maturity Date |
| SWIFTAPPLICABLE | TRUE | If true then First name in unit-holder will allow more than 35 characters to be captured |
| SWIFTTXNAGENT | FALSE | Swift Transaction Agent - If turned ON module level agent will be used and If Turned OFF Unitholder level Agent will be used |
| SWITCHBYIDSCHG | FALSE | This parameter is used For Modify IDS option |
| SWITCHINVAL | TRUE | This parameter will make Min/Max Validations For the Switch In Fund |
| SWITCHTOFUND | TRUE | This parameter is used For Switch to fund option |
| SWITCHTOIPOFUND | TRUE | This parameter is used For Switch to IPO fund option |
| SYSGENPOLNUM | TRUE | Generate policy number |
| TEMPALLOCPOLSAV | TRUE | Check Annuity Income percentage for net investible amount |
| TPAFQ | TRUE | This function allows third party cheque in the system |
| TPAFX | TRUE | This function allows third party money transfers in the system |
| TXNAUTHREKEYREQ | TRUE | This flag will decide whether rekey is required during authorisation |
| TXNBROKERS | FALSE | If this function is applicable brokers can be entered as intermediaries in the transactions |
| TXNCOUNTERAPP | TRUE | To keep track of Fund Txn Counter |
| UHCOUNTERSAPP | TRUE | Performance tuning requirement |
| UHFORLINKENTITY | TRUE | Flag to switch on or switch of for Unitholder as Linked Entity |
| UHFUNDRESTRICT | FALSE | Fund should belong to unitholder AMC |
| UHTXNBRKSAME | FALSE | This flag will decide whether UH intermediary should be transaction intermediary |
| UPLDFILEMODULE | TRUE | This parameter is set in order to reinitialize the global to module id present in the file |
| USERTFORLOAD | FALSE | Rounding rules pickup related |
| USSTATECODES | FALSE | This parameter will display the list of US State codes for address input |
| VALIDFUNDPRICE | TRUE | This parameter decides whether all or valid Fund Price has to be listed in LOV |
| VAT | TRUE | VAT specific |
| VATONPRTBRK | FALSE | VAT on parent broker code |
| VERIFYBANKACC | TRUE | Verify UH Bank Details |
| WACCOMPLETETXN | FALSE | For Enabling Compute WAC On Settlement |
| WOLFDBCHECK | TRUE | Wolf DB Validation is required or not |
| TRHAUTHREKEYREQ | FALSE | Tranche Authorization Rekey Feature |
A feature under the second column would be applicable when the entry in the third column matches with either the Country code or client code in the Defaults table and the values in the fourth column is set to 1.
If the matching is on the Country Code in the Defaults table, the feature will be applicable to all clients in that country.
For example: for the function LOADIN ( S.No 8 ), if the CTRYCLIENTCODE ‘SA’ has a match in the Country code column in Defaults table it will be applicable to all clients in the country ‘SA’ as the FUNCTIONAPPLICABLE value is 1. Alternatively, if the FUNCTIONAPPLICABLE value is 0, then the feature will not be applicable.
There could be another situation where a feature is applicable to all clients in a country except one client. Let the country code be ‘SA’ and the client code be ‘AOS’ in the Defaults table. If the feature LOADIN ( S.No 8 ) is applicable to all clients in SA except AOS, then the entry in the above table for the feature LOADIN ( S.No 8 ) will have values ‘AOS’ in the third column and 0 in the fourth column respectively.
The implementation team will have to modify the values of the table according to the requirements of the implementation. This will have to be done through the backend.
Parent topic: Implementation Tasks