Prepayments (Prepayment Model)

8.7.86.7 Prepayments (Prepayment Model)

Table 8-69 Prepayments (Prepayment Model)

Report Name	Assumptions - Prepayments (Prepayment Model)
Report Criteria	"Prepayment"."Calc Method", Case when "Prepayment"."Cash Flow Treatment Type" null then 'Not Applicable' else "Prepayment"."Cash Flow Treatment Type" end, "Prepayment"."Start Date (User Prepayments Date)", "Prepayment"."End Date (User Prepayments Date)", "Prepayment"."Prepayment Model Coefficient", case when "Prepayment"."Prepayment Model category Cd" is null then 'Not applicable' else "Prepayment"."Prepayment Model Category" end, case when "Prepayment"."Prepayment Model Sys Id" in (0) then 'Not Applicable' else "Prepayment"."Prepayment Model Name" end, '['\|\|"Prepayment"."Currency Code (IRCS)"\|\|']'\|\|' '\|\|"Prepayment"."IRC Name"\|\|' '\|\|'('\|\|cast("Prepayment"."IRC Code" as char)\|\|')', "Prepayment"."Rate Spread", "Prepayment"."Rate Term", Case when "Prepayment"."Seasonality Flg" in (0) then 'No' when "Prepayment"."Seasonality Flg" in (1) then 'Yes' else 'Not applicable' end, "Prepayment"."January Coefficient", "Prepayment"."Febuary Coefficient", "Prepayment"."March Coefficient", "Prepayment"."April Coefficient", "Prepayment"."May Coefficient", "Prepayment"."June Coefficient", "Prepayment"."July Coefficient", "Prepayment"."August Coefficient", "Prepayment"."September Coefficient", "Prepayment"."October Coefficient", "Prepayment"."November Coefficient", "Prepayment"."December Coefficient", "Prepayment"."Prepayment Desc Short", "Prepayment"."Ccy Cd", "Product - Assumptions"."Product Id", "Product - Assumptions"."Product Name", "Prepayment"."Ppmt Sys Id"

Report Name

Assumptions - Prepayments (Prepayment Model)

Report Criteria

"Prepayment"."Calc Method", Case when "Prepayment"."Cash Flow Treatment Type" null then 'Not Applicable' else "Prepayment"."Cash Flow Treatment Type" end, "Prepayment"."Start Date (User Prepayments Date)", "Prepayment"."End Date (User Prepayments Date)", "Prepayment"."Prepayment Model Coefficient", case when "Prepayment"."Prepayment Model category Cd" is null then 'Not applicable' else "Prepayment"."Prepayment Model Category" end, case when "Prepayment"."Prepayment Model Sys Id" in (0) then 'Not Applicable' else "Prepayment"."Prepayment Model Name" end, '['||"Prepayment"."Currency Code (IRCS)"||']'||' '||"Prepayment"."IRC Name"||' '||'('||cast("Prepayment"."IRC Code" as char)||')', "Prepayment"."Rate Spread", "Prepayment"."Rate Term", Case when "Prepayment"."Seasonality Flg" in (0) then 'No' when "Prepayment"."Seasonality Flg" in (1) then 'Yes' else 'Not applicable' end, "Prepayment"."January Coefficient", "Prepayment"."Febuary Coefficient", "Prepayment"."March Coefficient", "Prepayment"."April Coefficient", "Prepayment"."May Coefficient", "Prepayment"."June Coefficient", "Prepayment"."July Coefficient", "Prepayment"."August Coefficient", "Prepayment"."September Coefficient", "Prepayment"."October Coefficient", "Prepayment"."November Coefficient", "Prepayment"."December Coefficient", "Prepayment"."Prepayment Desc Short", "Prepayment"."Ccy Cd", "Product - Assumptions"."Product Id", "Product - Assumptions"."Product Name", "Prepayment"."Ppmt Sys Id"