UPDATE COLUMN IRRBB

mail@pastecode.io avatar
unknown
plain_text
a month ago
3.5 kB
2
Indexable
Never
ALTER TABLE [bsi].[mrms].[irrbb_eveBase]
ALTER COLUMN averageRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_eveBase]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_eveBase]
ALTER COLUMN Floor numeric(5, 2);


ALTER TABLE [bsi].[mrms].[irrbb_eveSensitivity]
ALTER COLUMN averageRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_eveSensitivity]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_eveSensitivity]
ALTER COLUMN Floor numeric(5, 2);



ALTER TABLE [bsi].[mrms].[irrbb_niiSensitivity]
ALTER COLUMN portfolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_niiSensitivity]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_niiSensitivity]
ALTER COLUMN Floor numeric(5, 2);



ALTER TABLE [bsi].[mrms].[irrbb_prepaymentRedemption]
ALTER COLUMN portofolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_repricingGap]
ALTER COLUMN portofolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_repricingGap]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_repricingGap]
ALTER COLUMN Floor numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_prepaymentRedemption]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_RepricingGap]
ALTER COLUMN prepaymentRedemptionRate numeric(23, 16);

-----------------------------------------------------------------
ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveBase]
ALTER COLUMN averageRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveBase]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveBase]
ALTER COLUMN Floor numeric(5, 2);



ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveSensitivity]
ALTER COLUMN averageRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveSensitivity]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_eveSensitivity]
ALTER COLUMN Floor numeric(5, 2);



ALTER TABLE [bsi].[mrms].[irrbb_simulation_niiSensitivity]
ALTER COLUMN portfolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_niiSensitivity]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_niiSensitivity]
ALTER COLUMN Floor numeric(5, 2);


ALTER TABLE [bsi].[mrms].[irrbb_simulation_prepaymentRedemption]
ALTER COLUMN portofolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_repricingGap]
ALTER COLUMN portofolioRate numeric(21, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_repricingGap]
ALTER COLUMN Cap numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_repricingGap]
ALTER COLUMN Floor numeric(5, 2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_prepaymentRedemption]
ALTER COLUMN percentile numeric(23, 16);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_RepricingGap]
ALTER COLUMN prepaymentRedemptionRate numeric(23, 16);
Leave a Comment