Untitled
unknown
plain_text
12 days ago
30 kB
2
Indexable
Never
BEGIN TRANSACTION DELETE FROM RISK_RATING_CRITERIA GO INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(1,'CL','DWJ','Name match in Dow Jones',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(2,'CL','LWL','Name match in Local Watchlist',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(3,'CL','PEP','Politically Exposed Person/Relative of PEP',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(4,'CL','PBLI','Profession/Business is Politician',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(5,'CL','PBL','Profession/Business deemed to be high risk (see Local Watchlist)',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(6,'CL','PLC','Listed Company',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','I') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(7,'CL','GAL','Government Entities/Offices, including GOCCs',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(8,'CL','OTH','Others',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(9,'CL','PLC','Publicly Listed Company',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Geography */ /*==============================================================*/ /* Citizenship =>CTZN*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(10,'GE','CTZN-H','Citizen of High Risk Country',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(11,'GE','CTZN-R','Citizen of Restricted Country',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(12,'GE','CTZN-E','Citizen of Elevated Risk Country',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Legal Residence => LGLR */ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(14,'GE','LGLR-H','Country of Legal Residence is High Risk',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(15,'GE','LGLR-R','Country of Legal Residence is Restricted',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(16,'GE','LGLR-E','Country of Legal Residence is Elevated Risk',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Permanent Address = PERA */ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(17,'GE','PERA-H','Country of Permanent Address is High Risk',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(18,'GE','PERA-R','Country of Permanent Address is Restricted',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(19,'GE','PERA-E','Country of Permanent Address is Elevated Risk',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Present Address =>PREA */ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(20,'GE','PREA-H','Country of Present Address is High Risk',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(21,'GE','PREA-R','Country of Present Address is Restricted',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(22,'GE','PREA-E','Country of Present Address is Elevated Risk',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Business Address => BUSA*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(23,'GE','BUSA-H','Country of Business Address is High Risk',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(24,'GE','BUSA-R','Country of Business Address is Restricted',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(25,'GE','BUSA-E','Country of Business Address is Elevated Risk',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Birth => BIRTH */ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(26,'GE','BIRTH-H','Country of Birth is High Risk',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(27,'GE','BIRTH-R','Country of Birth is Restricted',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(28,'GE','BIRTH-E','Country of Birth is Elevated Risk',10,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Product */ /*==============================================================*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(29,'PR','VS','VUL Single Pay',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(30,'PR','VR','VUL Regular Pay',15,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(31,'PR','TL','Traditional Policy',15,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(32,'PR',NULL,'Others',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(33,'PR','MF','VUL Single Pay / Mutual Fund',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Amount */ /*==============================================================*/ /* Premium of VUL (Single/Regular Pay)*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(34,'AM',NULL,'PHP30M and above / USD600K and above]',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(35,'AM',NULL,'PHP20M to PHP29.99M / USD400K to USD599K',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(36,'AM',NULL,'PHP15M to PHP19.99M / USD300K to USD399K',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(37,'AM',NULL,'PHP10M to PHP14.99M / USD200K to USD299K',15,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(38,'AM',NULL,'PHP5M to PHP9.99M / USD100K to USD199K',10,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(39,'AM',NULL,'PHP2M to PHP4.99M / USD40K to USD99K',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(40,'AM',NULL,'PHP1.99M and below / USD39K and below',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /* Premium of Traditional Policy*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(41,'AM',NULL,'PHP5M and above / USD100K and above',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(42,'AM',NULL,'PHP3M to PHP4.99M / USD60K to USD99K',15,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(43,'AM',NULL,'PHP1M to PHP2.99M / USD20K to USD59K',10,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(44,'AM',NULL,'PHP500K to PHP999K / USD10K to USD19K',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(45,'AM',NULL,'PHP499K and below / USD9.9 and below',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*Investment of Mutual Fund*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(46,'AM',NULL,'PHP15M and above / USD300K and above',30,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(47,'AM',NULL,'PHP10M to PHP14.99M / USD200K to USD299K',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(48,'AM',NULL,'PHP5M to PHP9.99M / USD100K to USD199K',10,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(49,'AM',NULL,'PHP2M to PHP4.99M / USD40K to USD99K',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(50,'AM',NULL,'PHP1.99M and below / USD39K and below',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Delivery Channel */ /*==============================================================*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(51,'DC','ONL','Online',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(52,'DC','FTF','Face-to-face',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(93,'SF','1100','Sale of Assets',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(94,'SF','1000','Time Deposits/Mutual Funds/ Other Investments',4,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(95,'SF','0100','Allowance/Donation/Regular Remittances/Gift',3,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(96,'SF','0200','Business',2,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(97,'SF','0700','Rentals',2,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(98,'SF','0300','Commission/Professional Fees',2,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(99,'SF','0500','Inheritance',1,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(100,'SF','0900','Salaries/Bonus from Employment',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(101,'SF','0800','Retirement Fund/Pension',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(102,'SF','1200','Matured Pre-Need Plan/Insurance Policy',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(103,'SF','OTH','Other Sources',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Purpose of Transactions */ /*==============================================================*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(72,'PT','WAI','Wealth Accumulation/Investment Diversification',3,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(73,'PT','LFE','Large Future Expense',3,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(74,'PT','INC','Income continuation',2,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(75,'PT','CRP','Credit Protection',2,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(76,'PT','SGF','Savings for Family',1,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(77,'PT','KPI','Key person insurance',1,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(78,'PT','DRE','Death Related Expenses',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(79,'PT','HCO','Health Coverage',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(80,'PT','CHE','Children''s Education',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(81,'PT','FFR','Funds for Retirement',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(82,'PT','ESC','Estate Creation',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(83,'PT','ESP','Estate Preservation',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(84,'PT','OTH','Others',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(85,'PT','INV','Investment',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') /*==============================================================*/ /* Category: Regularity of Transactions */ /*==============================================================*/ INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(86,'RT',NULL,'PHP30M and above / USD600K and above',70,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(87,'RT',NULL,'PHP20M to PHP29.99M / USD400K to USD599K',40,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(88,'RT',NULL,'PHP15M to PHP19.99M / USD300K to USD399K',20,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(89,'RT',NULL,'PHP10M to PHP14.99M / USD200K to USD299K',15,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(90,'RT',NULL,'PHP5M to PHP9.99M / USD100K to USD199K',10,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(91,'RT',NULL,'PHP2M to PHP4.99M / USD40K to USD99K',5,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') INSERT INTO [RISK_RATING_CRITERIA] ([RISK_CRITERIA_ID],[RISK_RATING_CATEGORY_CD],[RISK_PARTY_CATEGORY_CD],[CRITERIA_DESC],[RATE],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY],[STATUS_CD]) VALUES(92,'RT',NULL,'PHP1.99M and below / USD39K and below',0,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH','A') GO COMMIT GO
Leave a Comment