Untitled

mail@pastecode.io avatar
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