Cash Flow Edits Process Errors

4.7.1.2 Cash Flow Edits Process Errors

Note:

Error: Engine does not process, however sometimes default value can get used for calculations.
Warning: Engine may use the default value or given wrong data for calculation, results may be incorrect.
Info: Does not impact any processing but results may not be as expected.

Rule ID: 1

Error Condition	(AMRT_TYPE_CD <> 700 OR ( amrt_type_cd = 700 AND amrt_term <> 0 ) ) AND (CASE amrt_term_mult WHEN 'Y' THEN amrt_term * 365 WHEN 'M' THEN amrt_term * 30.41667 ELSE amrt_term END) < (CASE org_term_mult WHEN 'Y' THEN org_term * 365 WHEN 'M' THEN org_term * 30.41667 ELSE org_term END) THEN 'P' ELSE 'F' END
Error Description	Amortization term can only be equal to zero on Non-Amortizing instruments
Assignment	AMRT_TERM = ORG_TERM and AMRT_TERM_MULT = ORG_TERM_MULT
Warning	Original Term > Amortization Term
Error Level	Warning

Rule ID: 2

Error Condition	(ORIGINATION_DATE < AS_OF_DATE and CUR_PAR_BAL is not NULL and ORG_PAR_BAL is not NULL and CUR_PAR_BAL = ORG_PAR_BAL)
Error Description	Instrument has originated in past but Current Par Balance and Original Par Balance are equal
Assignment
Warning	Current Par Balance = Original Par Balance
Error Level	Warning

Rule ID: 3

Error Condition	(ORIGINATION_DATE < AS_OF_DATE and DEFERRED_CUR_BAL is not NULL and DEFERRED_ORG_BAL is not NULL and DEFERRED_CUR_BAL = DEFERRED_ORG_BAL)
Error Description	Instrument has originated in past but Deferred Current Balance and Deferred Original Balance are equal
Assignment
Warning	Deferred Current Balance = Deferred Original Balance
Error Level	Warning

Rule ID: 4

Error Condition	(CUR_GROSS_RATE is NULL or CUR_GROSS_RATE < 0)
Error Description	Current gross rate is negative
Assignment
Warning	Current Gross Rate < 0
Error Level	Info

Rule ID: 5

Error Condition	(CUR_NET_RATE is NULL or CUR_NET_RATE < 0)
Error Description	Current net rate is negative
Assignment
Warning	Current Net Rate < 0
Error Level	Info

Rule ID: 6

Error Condition	(ACCRUAL_BASIS_CD is NULL or ACCRUAL_BASIS_CD <1 or ACCRUAL_BASIS_CD >7)
Error Description	Accrual basis code must be between 1 and 7 inclusively
Assignment	ACCRUAL_BASIS_CD = 3
Warning	Invalid Accrual Basis
Error Level	Warning

Rule ID: 7

Error Condition	(AMRT_TYPE_CD is NULL or AMRT_TYPE_CD not in (100, 400, 600, 700, 710, 800, 801, 802, 820, 840, 850, 10, 20))
Error Description	Amortization type must be a valid OFSAA code
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Amortization Type
Error Level	Warning

Rule ID: 8

Error Condition	(AMRT_TYPE_CD = 20 and (PMT_PATTERN_CD is null or PMT_PATTERN_CD <= 0))
Error Description	Amortization type is Payment Pattern but Payment Pattern Code is invalid
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Payment Pattern
Error Level	Warning

Rule ID: 9

Error Condition	(AMRT_TYPE_CD = 20 and PMT_PATTERN_CD is not null and PMT_PATTERN_CD > 0 and PMT_PATTERN_CD not in (select AMRT_TYPE_CD from fsi_payment_pattern))
Error Description	Amortization type is Payment Pattern but Payment Pattern definition does not exist
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Payment Pattern
Error Level	Warning

Rule ID: 10

Error Condition	(AMRT_TYPE_CD = 10 and (BEHAVIOUR_PATTERN_CD is null or BEHAVIOUR_PATTERN_CD <= 0))
Error Description	Amortization type is Behaviour Pattern but Behaviour Pattern Code is invalid
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Behaviour Pattern
Error Level	Warning

Rule ID: 11

Error Condition	(AMRT_TYPE_CD = 10 and BEHAVIOUR_PATTERN_CD is not NULL and BEHAVIOUR_PATTERN_CD > 0 and BEHAVIOUR_PATTERN_CD not in (select PATTERN_CD from fsi_behaviour_pattern_master))
Error Description	Amortization type is Behaviour Pattern but Behaviour Pattern definition does not exist
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Behaviour Pattern
Error Level	Warning

Rule ID: 12

Error Condition	(AMRT_TYPE_CD in (800, 801, 802) and NOT EXISTS (select 1 from FSI_D_Payment_Schedule WHERE FSI_D_Payment_Schedule.ID_NUMBER=SOURCE_TABLE.ID_NUMBER AND FSI_D_Payment_Schedule.IDENTITY_CODE = SOURCE_TABLE.IDENTITY_CODE AND FSI_D_Payment_Schedule.INSTRUMENT_TYPE_CD = SOURCE_TABLE.INSTRUMENT_TYPE_CD))
Error Description	Cannot find record with matching ID Number, Identity Code and Instrument Type Code in Payment Schedule table
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Payment schedule data
Error Level	Warning

Rule ID: 13

Error Condition	(AMRT_TYPE_CD in (800, 801, 802) and ORIGINATION_DATE > (select max(PAYMENT_DATE) from FSI_D_Payment_Schedule WHERE FSI_D_Payment_Schedule.ID_NUMBER=SOURCE_TABLE.ID_NUMBER AND FSI_D_Payment_Schedule.IDENTITY_CODE = SOURCE_TABLE.IDENTITY_CODE AND FSI_D_Payment_Schedule.INSTRUMENT_TYPE_CD = SOURCE_TABLE.INSTRUMENT_TYPE_CD))
Error Description	Origination Date is greater than highest date in Payment Schedule
Assignment	AMRT_TYPE_CD = 700
Warning	Invalid Payment schedule data
Error Level	Warning

Rule ID: 14

Error Condition	(AMRT_TERM_MULT is NULL or AMRT_TERM_MULT not in ('D', 'M', 'Y'))
Error Description	Amortization term multiplier must be D, M, or Y
Assignment	AMRT_TERM_MULT = M
Warning	Invalid Amortization Term Multiplier
Error Level	Warning

Rule ID: 15

Error Condition	(AMRT_TYPE_CD = 600 AND (NEG_AMRT_EQ_MULT is NULL or NEG_AMRT_EQ_MULT not in ('D', 'M', 'Y')))
Error Description	Negative Amortization Equalization Frequency multiplier must be D, M, or Y
Assignment	NEG_AMRT_EQ_MULT = M
Warning	Invalid Negative Amortization Equalization Frequency Multiplier
Error Level	Warning

Rule ID: 16

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_LIMIT is NULL or NEG_AMRT_LIMIT >=200 or NEG_AMRT_LIMIT < 0))
Error Description	Negative Amortization limit value does not fall in a valid range (0 to 200), Applicable to Negative amortization instruments only
Assignment	NEG_AMRT_LIMIT = 0
Warning	Invalid Negative Amortization Limit
Error Level	Warning

Rule ID: 17

Error Condition	(ORG_TERM_MULT is NULL or ORG_TERM_MULT not in ('D', 'M', 'Y'))
Error Description	Original term multiplier must be D, M, or Y
Assignment	ORG_TERM_MULT= M
Warning	Invalid Original Term Multiplier
Error Level	Warning

Rule ID: 18

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_CHG_FREQ is NULL or NEG_AMRT_PMT_CHG_FREQ < 0))
Error Description	Payment Change Frequency cannot be negative, Applicable to Negative amortization instruments only
Assignment	NEG_AMRT_PMT_CHG_FREQ = 0
Warning	Invalid Negative Amortization Payment Change Frequency
Error Level	Warning

Rule ID: 19

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_CHG_FREQ_MULT is NULL or NEG_AMRT_PMT_CHG_FREQ_MULT not in ('D', 'M', 'Y')))
Error Description	Negative Amortization Payment Change Frequency Multiplier must be D, M, or Y
Assignment	NEG_AMRT_PMT_CHG_FREQ_MULT = M
Warning	Invalid Negative Amortization Payment Change Frequency Multiplier
Error Level	Warning

Rule ID: 20

Error Condition	(INT_PMT_FREQ_MULT is NULL or INT_PMT_FREQ_MULT not in ('D', 'M', 'Y'))
Error Description	Interest Payment frequency multiplier must be D, M, or Y
Assignment	INT_PMT_FREQ_MULT = M
Warning	Invalid Interest Payment Frequency Multiplier
Error Level	Warning

Rule ID: 21

Error Condition	(PRIN_PMT_FREQ_MULT is NULL or PRIN_PMT_FREQ_MULT not in ('D', 'M', 'Y'))
Error Description	Principal Payment frequency multiplier must be D, M, or Y
Assignment	PRIN_PMT_FREQ_MULT = M
Warning	Invalid Principal Payment Frequency Multiplier
Error Level	Warning

Rule ID: 22

Error Condition	(RATE_CHG_RND_CD is NULL or RATE_CHG_RND_CD < 0 or RATE_CHG_RND_CD > 4)
Error Description	Rate change round code must be between 0 and 4
Assignment	RATE_CHG_RND_CD = 0
Warning	Invalid Rate Change Rounding Code
Error Level	Warning

Rule ID: 23

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and (RATE_SET_LAG_MULT is NULL or RATE_SET_LAG_MULT not in ('D', 'M', 'Y')))
Error Description	Rate Set Lag Multiplier must be D, M, or Y
Assignment	RATE_SET_LAG_MULT = M
Warning	Invalid Rate Set Lag Multiplier
Error Level	Warning

Rule ID: 24

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and (REPRICE_FREQ_MULT is NULL or REPRICE_FREQ_MULT not in ('D', 'M', 'Y')))
Error Description	Repricing Frequency Multiplier must be D, M, or Y
Assignment	REPRICE_FREQ_MULT = M
Warning	Invalid Repricing Frequency Multiplier
Error Level	Warning

Rule ID: 25

Error Condition	(RATE_CHG_RND_FAC is NULL or RATE_CHG_RND_FAC < 0 or RATE_CHG_RND_FAC > 1)
Error Description	Rate change round factor must be between 0 and 1
Assignment	RATE_CHG_RND_FAC = 0
Warning	Invalid Rate Change Rounding Factor
Error Level	Warning

Rule ID: 26

Error Condition	(MATURITY_DATE < NEXT_INT_PAYMENT_DATE)
Error Description	Maturity date cannot be before the next interest payment date
Assignment	MATURITY_DATE = (CASE PRIN_PMT_FREQ_MULT WHEN 'Y' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ * 12)) WHEN 'M' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ)) ELSE NEXT_PRIN_PAYMENT_DATE + ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ) END)
Warning	Maturity Date < Next Interest Payment Date
Error Level	Warning

Rule ID: 27

Error Condition	(MATURITY_DATE < NEXT_PRIN_PAYMENT_DATE)
Error Description	Maturity date cannot be before the next principal payment date
Assignment	MATURITY_DATE = (CASE PRIN_PMT_FREQ_MULT WHEN 'Y' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ * 12)) WHEN 'M' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ)) ELSE NEXT_PRIN_PAYMENT_DATE + ((REMAIN_NO_PMTS -1)* PRIN_PMT_FREQ) END)
Warning	Maturity Date < Next Principal Payment Date
Error Level	Warning

Rule ID: 28

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_EQ_FREQ is NULL or NEG_AMRT_EQ_FREQ < 0))
Error Description	Negative amortization equalization frequency cannot be negative, Applicable to Negative amortization instruments only
Assignment	NEG_AMRT_EQ_FREQ = 0
Warning	Negative Amortization Equalization Frequency < 0
Error Level	Warning

Rule ID: 29

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_EQ_FREQ is not null and NEG_AMRT_EQ_FREQ > 0 and NEG_AMRT_EQ_DATE <= greatest(ORIGINATION_DATE, AS_OF_DATE))
Error Description	Negative Amortization equalization date is less than origination date (future origination) or less than the as-of-date (past origination), Applicable to Negative Amortization instruments only
Assignment	NEG_AMRT_EQ_DATE = NEXT_REPRICE_DATE
Warning	Negative Amortization Equalization Date < Origination Date or As of Date
Error Level	Warning

Rule ID: 30

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_EQ_FREQ is not NULL and NEG_AMRT_EQ_FREQ > 0 and NEG_AMRT_EQ_DATE > MATURITY_DATE)
Error Description	Next interest payment date is less than as-of-date (past origination case), As of Date cannot be greater than the origination date and greater than the next payment date.
Assignment	NEG_AMRT_EQ_DATE = NEXT_REPRICE_DATE
Warning	Negative Amortization Equalization Date > Maturity Date
Error Level	Warning

Rule ID: 31

Error Condition	(AS_OF_DATE > ORIGINATION_DATE and AS_OF_DATE >= NEXT_INT_PAYMENT_DATE)
Error Description	Negative Amortization equalization date is after Maturity Date, Applicable to Negative Amortization instruments only
Assignment	NEXT_INT_PAYMENT_DATE = AS_OF_DATE + 1
Warning	Next Interest Payment Date < As of Date
Error Level	Warning

Rule ID: 32

Error Condition	(AS_OF_DATE > ORIGINATION_DATE and AS_OF_DATE >= NEXT_PRIN_PAYMENT_DATE)
Error Description	Next principal payment date is less than as-of-date (past origination case), As of Date cannot be greater than the origination date and greater than the next payment date.
Assignment	NEXT_PRIN_PAYMENT_DATE= AS_OF_DATE + 1
Warning	Next Principal Payment Date < As of Date
Error Level	Warning

Rule ID: 33

Error Condition	(ORIGINATION_DATE >= AS_OF_DATE and ORIGINATION_DATE >= NEXT_INT_PAYMENT_DATE)
Error Description	Next interest payment date is less than origination date (future origination case)
Assignment	NEXT_INT_PAYMENT_DATE = ORIGINATION_DATE + 1
Warning	Next Interest Payment Date < Origination Date
Error Level	Warning

Rule ID: 34

Error Condition	(ORIGINATION_DATE >= AS_OF_DATE and ORIGINATION_DATE >= NEXT_PRIN_PAYMENT_DATE)
Error Description	Next principal payment date is less than origination date (future origination case)
Assignment	NEXT_PRIN_PAYMENT_DATE= ORIGINATION_DATE + 1
Warning	Next Principal Payment Date < Origination Date
Error Level	Warning

Rule ID: 35

Error Condition	(ORIGINATION_DATE <= AS_OF_DATE and NEXT_REPRICE_DATE <= AS_OF_DATE and REPRICE_FREQ > 0)
Error Description	Next repricing date is less than as-of-date (past origination case)
Assignment	NEXT_REPRICE_DATE = AS_OF_DATE + 1
Warning	Next Reprice Date < As of Date
Error Level	Warning

Rule ID: 36

Error Condition	(ORIGINATION_DATE > AS_OF_DATE and NEXT_REPRICE_DATE < ORIGINATION_DATE and REPRICE_FREQ > 0)
Error Description	Next repricing date is less than the origination date (future origination case)
Assignment	NEXT_REPRICE_DATE = ORIGINATION_DATE + 1
Warning	Next Reprice Date < Origination Date
Error Level	Warning

Rule ID: 37

Error Condition	(AMRT_TYPE_CD = 600 and (ORG_PAYMENT_AMT is NULL or ORG_PAYMENT_AMT = 0) and NEG_AMRT_PMT_DECR_LIFE > 0)
Error Description	Payment decrease life is expressed as a percent of a original payment, Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_DECR_LIFE = 0
Warning	Original Payment Amount = 0 and Negative Amortization Payment Decrease Limit (Life) <> 0
Error Level	Warning

Rule ID: 38

Error Condition	(AMRT_TYPE_CD = 600 and (ORG_PAYMENT_AMT is NULL or ORG_PAYMENT_AMT = 0) and NEG_AMRT_PMT_INCR_LIFE > 0)
Error Description	Payment increase life is expressed as a percent of a original payment, Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_INCR_LIFE = 0
Warning	Original Payment Amount = 0 and Negative Amortization Payment Increase Limit (Life) <> 0
Error Level	Warning

Rule ID: 39

Error Condition	(ORG_TERM = 0 OR ORG_TERM <> (CASE ORG_TERM_MULT WHEN 'Y' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE)*12 WHEN 'M' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) ELSE (MATURITY_DATE - ORIGINATION_DATE) END))
Error Description	Original term should equal the time between the origination date and the maturity date
Assignment	ORG_TERM#ORG_TERM_MULT = MONTHS_BETWEEN(MATURITY_DATE, RIGINATION_DATE)#
Warning	Original Term <> Maturity Date - Orgination Date
Error Level	Warning

Rule ID: 40

Error Condition	(ORIGINATION_DATE is NULL or ORIGINATION_DATE < '1-Aug-1950' or ORIGINATION_DATE > '1-Aug-2099')
Error Description	Origination date must be acceptable
Assignment	ORIGINATION_DATE = 1-Jan-50
Warning	Origination date < 01/01/1950
Error Level	Warning

Rule ID: 41

Error Condition	(INT_PMT_FREQ > (CASE INT_PMT_FREQ_MULT WHEN 'Y' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE)*12 WHEN 'M' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) ELSE (MATURITY_DATE - ORIGINATION_DATE) END))
Error Description	Interest Payment frequency cannot be greater than original term
Assignment	INT_PMT_FREQ#INT_PMT_FREQ_MULT = MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE)#
Warning	Interest Payment Freq > Original Term
Error Level	Warning

Rule ID: 42

Error Condition	(PRIN_PMT_FREQ >(CASE PRIN_PMT_FREQ_MULT WHEN 'Y' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE)*12 WHEN 'M' THEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) ELSE (MATURITY_DATE - ORIGINATION_DATE) END))
Error Description	Principal Payment frequency cannot be greater than original term
Assignment	PRIN_PMT_FREQ#PRIN_PMT_FREQ_MULT= MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE)#
Warning	Principal Payment Freq > Original Term
Error Level	Warning

Rule ID: 43

Error Condition	((CUR_PAYMENT is NULL or CUR_PAYMENT < 0 and CUR_PAR_BAL > 0) or (CUR_PAYMENT > 0 and CUR_PAR_BAL < 0))
Error Description	Current payment and current par balance cannot have opposite signs
Assignment	CUR_PAYMENT = 0
Warning	Current Payment and Current Par Balance have opposite signs
Error Level	Warning

Rule ID: 44

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_PMT_CHG_FREQ > 0 and AS_OF_DATE > NEG_AMRT_PMT_ADJUST_DATE)
Error Description	Negative Amortization Payment Adjustment Date is less than the as-of-date (past origination), Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_ADJUST_DATE=NEXT_REPRICE_DATE
Warning	Negative Amortization Payment Adjustment Date < As of Date
Error Level	Warning

Rule ID: 45

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_PMT_CHG_FREQ > 0 and AS_OF_DATE < NEG_AMRT_PMT_ADJUST_DATE and NEG_AMRT_PMT_ADJUST_DATE < ORIGINATION_DATE)
Error Description	Negative Amortization Payment adjustment date is less than origination date (future origination), Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_ADJUST_DATE=NEXT_REPRICE_DATE
Warning	Negative Amortization Payment Adjustment Date < Origination Date
Error Level	Warning

Rule ID: 46

Error Condition	((INT_PMT_FREQ is NULL or INT_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE > AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE and MATURITY_DATE > ORIGINATION_DATE)))
Error Description	Interest Payment frequency is less than or equal to zero, and both maturity date and origination date are valid dates and can be used to calculate payment frequency.
Assignment	NEXT_INT_PAYMENT_DATE#ORG_TERM#ORG_TERM_MULT#INT_PMT_FREQ#INT_PMT_FREQ_MULT#REMAIN_NO_PMTS=MATURITY_DATE#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Interest Payment Frequency <= 0
Error Level	Warning

Rule ID: 47

Error Condition	((PRIN_PMT_FREQ is NULL or PRIN_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE > AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE and MATURITY_DATE > ORIGINATION_DATE)))
Error Description	Principal Payment frequency is less than or equal to zero, and both maturity date and origination date are valid dates and can be used to calculate payment frequency.
Assignment	NEXT_PRIN_PAYMENT_DATE#ORG_TERM#ORG_TERM_MULT#PRIN_PMT_FREQ#PRIN_PMT_FREQ_MULT#REMAIN_NO_PMTS=MATURITY_DATE#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Principal Payment Frequency <= 0
Error Level	Warning

Rule ID: 48

Error Condition	((INT_PMT_FREQ is NULL or INT_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE <= AS_OF_DATE and NEXT_INT_PAYMENT_DATE > AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE AND MATURITY_DATE < ORIGINATION_DATE and NEXT_INT_PAYMENT_DATE > ORIGINATION_DATE)))
Error Description	Interest payment frequency is less than or equal to zero and maturity date is invalid, but next interest payment date can be used to calculate a valid payment frequency
Assignment	MATURITY_DATE#ORG_TERM#ORG_TERM_MULT#INT_PMT_FREQ#INT_PMT_FREQ_MULT#REMAIN_NO_PMTS=NEXT_INT_PAYMENT_DATE#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Interest Payment Frequency <= 0
Error Level	Warning

Rule ID: 49

Error Condition	((PRIN_PMT_FREQ is NULL or PRIN_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE <= AS_OF_DATE and NEXT_PRIN_PAYMENT_DATE > AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE AND MATURITY_DATE < ORIGINATION_DATE and NEXT_PRIN_PAYMENT_DATE > ORIGINATION_DATE)))
Error Description	Principal payment frequency is less than or equal to zero and maturity date is invalid, but next interest payment date can be used to calculate a valid payment frequency
Assignment	MATURITY_DATE#ORG_TERM#ORG_TERM_MULT#PRIN_PMT_FREQ#PRIN_PMT_FREQ_MULT#REMAIN_NO_PMTS=NEXT_PRIN_PAYMENT_DATE#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Principal Payment Frequency <= 0
Error Level	Warning

Rule ID: 50

Error Condition	((INT_PMT_FREQ is NULL or INT_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE <= AS_OF_DATE and NEXT_INT_PAYMENT_DATE <= AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE AND MATURITY_DATE < ORIGINATION_DATE and NEXT_INT_PAYMENT_DATE < ORIGINATION_DATE)))
Error Description	Interest payment frequency is less than or equal to zero and all dates which can be used to calculate payment frequency are in the past
Assignment	MATURITY_DATE#NEXT_INT_PAYMENT_DATE#ORG_TERM#ORG_TERM_MULT#INT_PMT_FREQ#INT_PMT_FREQ_MULT#REMAIN_NO_PMTS=AS_OF_DATE + 1#AS_OF_DATE + 1#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Interest Payment Frequency <= 0
Error Level	Warning

Rule ID: 51

Error Condition	((PRIN_PMT_FREQ is NULL or PRIN_PMT_FREQ <= 0) and ((ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE <= AS_OF_DATE and NEXT_PRIN_PAYMENT_DATE <= AS_OF_DATE) or (ORIGINATION_DATE > AS_OF_DATE AND MATURITY_DATE < ORIGINATION_DATE and NEXT_PRIN_PAYMENT_DATE < ORIGINATION_DATE)))
Error Description	Principal payment frequency is less than or equal to zero and all dates which can be used to calculate payment frequency are in the past
Assignment	MATURITY_DATE#NEXT_PRIN_PAYMENT_DATE#ORG_TERM#ORG_TERM_MULT#PRIN_PMT_FREQ#PRIN_PMT_FREQ_MULT#REMAIN_NO_PMTS=AS_OF_DATE + 1#AS_OF_DATE + 1#CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##CASE WHEN MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) < 1 THEN 1 ELSE MONTHS_BETWEEN(MATURITY_DATE, ORIGINATION_DATE) END##
Warning	Principal Payment Frequency <= 0
Error Level	Warning

Rule ID: 52

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_INCR_CYCLE is NULL or NEG_AMRT_PMT_INCR_CYCLE < 0))
Error Description	Negative Amortization Payment increase limit (cycle) cannot be less than zero, Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_INCR_CYCLE=0
Warning	Negative Amortization Payment Increase Limit (Cycle) < 0
Error Level	Warning

Rule ID: 53

Error Condition	(RATE_CAP_LIFE < CUR_GROSS_RATE and RATE_CAP_LIFE <> 0 and CUR_GROSS_RATE <> 0 and TEASER_END_DATE < AS_OF_DATE)
Error Description	Current gross rate is greater than the rate cap life
Assignment	RATE_CAP_LIFE=CUR_GROSS_RATE
Warning	Rate Cap Life < Current Gross Interest Rate
Error Level	Info

Rule ID: 54

Error Condition	(RATE_CAP_LIFE < CUR_NET_RATE and RATE_CAP_LIFE <> 0)
Error Description	Current net rate is greater than the rate cap
Assignment
Warning	Rate Cap Life < Current Net Interest Rate
Error Level	Info

Rule ID: 55

Error Condition	(RATE_CHG_MIN is NULL or RATE_CHG_MIN < 0)
Error Description	Minimum rate change cannot be negative
Assignment	RATE_CHG_MIN=0
Warning	Rate Change Minimum < 0
Error Level	Warning

Rule ID: 56

Error Condition	(RATE_DECR_CYCLE is NULL or RATE_DECR_CYCLE < 0)
Error Description	Rate decrease limit (cycle) must not be negative
Assignment	RATE_DECR_CYCLE=0
Warning	Rate Decrease Limit (Cycle) < 0
Error Level	Warning

Rule ID: 57

Error Condition	(RATE_FLOOR_LIFE > CUR_GROSS_RATE and CUR_GROSS_RATE <> 0 and TEASER_END_DATE < AS_OF_DATE)
Error Description	Current gross rate is less than the rate floor
Assignment
Warning	Rate Floor Life > Currrent Gross Interest Rate
Error Level	Info

Rule ID: 58

Error Condition	(RATE_FLOOR_LIFE > CUR_NET_RATE)
Error Description	Rate floor life must not be greater than the current net rate
Assignment	RATE_FLOOR_LIFE=CUR_GROSS_RATE
Warning	Rate Floor Life > Currrent Net Interest Rate
Error Level	Info

Rule ID: 59

Error Condition	(RATE_INCR_CYCLE is NULL or RATE_INCR_CYCLE < 0)
Error Description	Rate increase limit (cycle) cannot be less than 0
Assignment	RATE_INCR_CYCLE=0
Warning	Rate Increase Limit (Cycle) < 0
Error Level	Warning

Rule ID: 60

Error Condition	(REMAIN_NO_PMTS is NULL or REMAIN_NO_PMTS < 1)
Error Description	There has to be at least 1 payment left
Assignment	REMAIN_NO_PMTS=1
Warning	Remaining Number of Payments < 1
Error Level	Warning

Rule ID: 61

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and (RATE_SET_LAG is NULL or RATE_SET_LAG < 0))
Error Description	Rate set lag cannot be negative
Assignment	RATE_SET_LAG=0
Warning	Rate Set Lag < 0
Error Level	Warning

Rule ID: 62

Error Condition	(TEASER_END_DATE < ORIGINATION_DATE)
Error Description	Teaser End Date cannot be before Origination Date
Assignment	TEASER_END_DATE=ORIGINATION_DATE
Warning	Teaser End Date < Origination Date
Error Level	Warning

Rule ID: 63

Error Condition	(TEASER_END_DATE > MATURITY_DATE)
Error Description	Teaser End Date cannot be after Maturity Date
Assignment	TEASER_END_DATE=MATURITY_DATE
Warning	Teaser End Date > Maturity Date
Error Level	Warning

Rule ID: 64

Error Condition	(AMRT_TYPE_CD = 710 and ORG_PAR_BAL < CUR_PAR_BAL)
Error Description	Original balance on Rule of 78's instruments should be greater than current balance
Assignment
Warning	Orginal Par Balance < Current Par Balance
Error Level	Info

Rule ID: 65

Error Condition	(AMRT_TYPE_CD = 600 and (REPRICE_FREQ is NULL or REPRICE_FREQ = 0))
Error Description	Reprice Frequency cannot be zero for Adjustable Negative Amortization instrument
Assignment
Warning	Adjustable Negative Amortization instrument has Reprice Frequency = 0
Error Level	Info

Rule ID: 66

Error Condition	(REPRICE_FREQ <> 0 and LAST_REPRICE_DATE > NEXT_REPRICE_DATE)
Error Description	Last repricing date is greater than next repricing date
Assignment	LAST_REPRICE_DATE=(CASE REPRICE_FREQ_MULT WHEN 'Y' THEN ADD_MONTHS(NEXT_REPRICE_DATE, -REPRICE_FREQ*12) WHEN 'M' THEN ADD_MONTHS(NEXT_REPRICE_DATE, -REPRICE_FREQ) ELSE NEXT_REPRICE_DATE - REPRICE_FREQ END)
Warning	Last Reprice Date > Next Reprice Date
Error Level	Warning

Rule ID: 67

Error Condition	(ADJUSTABLE_TYPE_CD in (50, 250) and (INTEREST_RATE_CD is NULL or INTEREST_RATE_CD <= 0))
Error Description	Interest rate code must be valid for adjustable rate instruments
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Adjustable Rate instrument has invalid Interest Rate Code
Error Level	Warning

Rule ID: 68

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and INTEREST_RATE_CD > 0 and exists (select 1 from fsi_ircs where fsi_ircs.interest_rate_cd = SOURCE_TABLE.interest_rate_cd and fsi_ircs.volatility_curve_flg > 0))
Error Description	Interest rate code of instrument is not an yield curve. Repricing attributes will be ignored and processed as fixed interest rate;
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Invalid Interest Rate Code. Curve Type is not Interest Rate Curve
Error Level	Warning

Rule ID: 69

Error Condition	(NET_MARGIN_CD is NULL or NET_MARGIN_CD not in (0, 1))
Error Description	Valid net margin codes are 0 or 1.
Assignment	NET_MARGIN_CD=0
Warning	Invalid Net Margin Code
Error Level	Warning

Rule ID: 70

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_DECR_CYCLE is NULL or NEG_AMRT_PMT_DECR_CYCLE < 0))
Error Description	Payment Decrease Limit (Cycle) cannot be less than zero. Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_DECR_CYCLE=0
Warning	Negative Amortization Payment Decrease Limit (Cycle) = 0
Error Level	Warning

Rule ID: 71

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_DECR_LIFE is NULL or NEG_AMRT_PMT_DECR_LIFE < 0))
Error Description	Payment Decrease Limit (Life) cannot be less than zero. Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_DECR_LIFE=0
Warning	Negative Amortization Payment Decrease Limit (Life) = 0
Error Level	Warning

Rule ID: 72

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_PMT_DECR_LIFE <> 0 and CUR_PAYMENT < ORG_PAYMENT_AMT * (1 - NEG_AMRT_PMT_DECR_LIFE/100))
Error Description	Current payment is less than the minimum payment amount. Applicable to negative amortization instruments only
Assignment
Warning	Current Payment is less than Life Pay Floor
Error Level	Info

Rule ID: 73

Error Condition	(AMRT_TYPE_CD = 600 and (NEG_AMRT_PMT_INCR_LIFE is NULL or NEG_AMRT_PMT_INCR_LIFE < 0))
Error Description	Payment Increase Limit (Life) cannot be less than zero. Applicable to negative amortization instruments only
Assignment	NEG_AMRT_PMT_INCR_LIFE=0
Warning	Negative Amortization Payment Increase Limit (Life) = 0
Error Level	Warning

Rule ID: 74

Error Condition	(AMRT_TYPE_CD = 600 and NEG_AMRT_PMT_INCR_LIFE <> 0 and CUR_PAYMENT > ORG_PAYMENT_AMT * (1 + NEG_AMRT_PMT_INCR_LIFE/100))
Error Description	Current payment is greater than the maximum payment amount. Applicable to negative amortization instruments only
Assignment
Warning	Current Payment is greater than Life Pay Cap
Error Level	Info

Rule ID: 75

Error Condition	(ISSUE_DATE > ORIGINATION_DATE)
Error Description	Issue date cannot be greater than origination date
Assignment	ISSUE_DATE=ORIGINATION_DATE
Warning	Issue Date > Origination Date
Error Level	Warning

Rule ID: 76

Error Condition	(REPRICE_FREQ is NULL or REPRICE_FREQ < 0)
Error Description	Repricing frequency must not be negative
Assignment	REPRICE_FREQ=0
Warning	Reprice Frequency < 0
Error Level	Warning

Rule ID: 77

Error Condition	(AMRT_TYPE_CD = 710 and REPRICE_FREQ <> 0)
Error Description	Rule of 78's instruments are implicitly fixed rate.
Assignment	REPRICE_FREQ=0
Warning	Amortization type is Rule of 78's but Reprice Frequency is not 0
Error Level	Warning

Rule ID: 78

Error Condition	(ORG_PAR_BAL = 0 and (REPRICE_FREQ is NULL or REPRICE_FREQ = 0))
Error Description	For transfer pricing of fixed rate instruments, the original balance should be populated.
Assignment
Warning	Original Par Balance is 0 for a fixed rate instrument
Error Level	Info

Rule ID: 79

Error Condition	(REPRICE_FREQ <> 0 and TEASER_END_DATE > ORIGINATION_DATE and TEASER_END_DATE > AS_OF_DATE and NEXT_REPRICE_DATE > TEASER_END_DATE)
Error Description	Next repricing date is greater than teaser end date.
Assignment	NEXT_REPRICE_DATE=TEASER_END_DATE
Warning	Next Reprice Date > Teaser End Date
Error Level	Warning

Rule ID: 80

Error Condition	(ADJUSTABLE_TYPE_CD <> 0 and (LRD_BALANCE is NULL or LRD_BALANCE = 0))
Error Description	The balance as of the last repricing date cannot be equal to 0
Assignment	LRD_BALANCE=CUR_PAR_BAL
Warning	Balance on Last Reprice Date = 0
Error Level	Warning

Rule ID: 81

Error Condition	(ADJUSTABLE_TYPE_CD <> 0 and (LAST_REPRICE_DATE < ISSUE_DATE or LAST_REPRICE_DATE < ORIGINATION_DATE))
Error Description	Transfer pricing will not occur when the last repricing date is less than the issue date and origination date
Assignment	LAST_REPRICE_DATE=ORIGINATION_DATE
Warning	Last Reprice Date < Issue/Origination Date
Error Level	Info

Rule ID: 82

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and REPRICE_FREQ > 0)
Error Description	Repricing frequency and adjustable type code are inconsistent
Assignment	REPRICE_FREQ=0
Warning	Reprice Frequency > 0 for fixed rate instrument
Error Level	Info

Rule ID: 83

Error Condition	(ADJUSTABLE_TYPE_CD <> 0 and (REPRICE_FREQ is NULL or REPRICE_FREQ = 0))
Error Description	Repricing frequency and adjustable type code are inconsistent
Assignment
Warning	Adjustable Type is not fixed but Reprice Frequency is 0
Error Level	Info

Rule ID: 84

Error Condition	(AMRT_TYPE_CD = 710 and ADJUSTABLE_TYPE_CD <> 0)
Error Description	Rule of 78's instrument should only have a Fixed adjustable type code.
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Amortization type is Rule of 78's but Adjustable Type is not fixed
Error Level	Warning

Rule ID: 85

Error Condition	(AMRT_TYPE_CD = 600 and ADJUSTABLE_TYPE_CD = 0)
Error Description	Negative amortization instruments cannot have fixed adjustable type code
Assignment	AMRT_TYPE_CD=100
Warning	Adjustable Type is fixed rate for Negative amortization instrument
Error Level	Info

Rule ID: 86

Error Condition	(LAST_INT_PAYMENT_DATE > NEXT_INT_PAYMENT_DATE and INT_PMT_FREQ > 0)
Error Description	Last interest payment date is greater than next interest payment date and can be calculated using interest payment frequency
Assignment	LAST_INT_PAYMENT_DATE=(CASE INT_PMT_FREQ_MULT WHEN 'Y' THEN ADD_MONTHS(NEXT_INT_PAYMENT_DATE, -INT_PMT_FREQ*12) WHEN 'M' THEN ADD_MONTHS(NEXT_INT_PAYMENT_DATE, -INT_PMT_FREQ) ELSE NEXT_INT_PAYMENT_DATE - INT_PMT_FREQ END)
Warning
Error Level	Warning

Rule ID: 87

Error Condition	(LAST_INT_PAYMENT_DATE > NEXT_INT_PAYMENT_DATE and (INT_PMT_FREQ is NULL or INT_PMT_FREQ <= 0))
Error Description	Last interest payment date is greater than next interest payment date, but cannot be calculated using interest payment frequency.
Assignment	LAST_INT_PAYMENT_DATE=ORIGINATION_DATE
Warning
Error Level	Warning

Rule ID: 88

Error Condition	(LAST_PRIN_PAYMENT_DATE > NEXT_PRIN_PAYMENT_DATE and PRIN_PMT_FREQ > 0)
Error Description	Last principal payment date is greater than next principal payment date and can be calculated using principal payment frequency
Assignment	LAST_PRIN_PAYMENT_DATE=(CASE PRIN_PMT_FREQ_MULT WHEN 'Y' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, -PRIN_PMT_FREQ*12) WHEN 'M' THEN ADD_MONTHS(NEXT_PRIN_PAYMENT_DATE, -PRIN_PMT_FREQ) ELSE NEXT_PRIN_PAYMENT_DATE - PRIN_PMT_FREQ END)
Warning
Error Level	Warning

Rule ID: 89

Error Condition	(LAST_PRIN_PAYMENT_DATE > NEXT_PRIN_PAYMENT_DATE and (PRIN_PMT_FREQ is NULL or PRIN_PMT_FREQ <= 0))
Error Description	Last principal payment date is greater than next principal payment date, but cannot be calculated using principal payment frequency.
Assignment	LAST_PRIN_PAYMENT_DATE=ORIGINATION_DATE
Warning	Last principal payment date > Next principal payment date
Error Level	Warning

Rule ID: 90

Error Condition	(LAST_INT_PAYMENT_DATE < ORIGINATION_DATE)
Error Description	Last interest payment date cannot be less than the origination date
Assignment	LAST_INT_PAYMENT_DATE=ORIGINATION_DATE
Warning	Last Interest Payment Date < Origination Date
Error Level	Warning

Rule ID: 91

Error Condition	(LAST_PRIN_PAYMENT_DATE < ORIGINATION_DATE)
Error Description	Last principal payment date cannot be less than the origination date
Assignment	LAST_PRIN_PAYMENT_DATE=ORIGINATION_DATE
Warning	Last Principal Payment Date < Origination Date
Error Level	Warning

Rule ID: 92

Error Condition	(LAST_INT_PAYMENT_DATE > AS_OF_DATE and ORIGINATION_DATE <= AS_OF_DATE)
Error Description	Last interest payment date cannot be greater than the as-of-date if the instrument originated in the past.
Assignment	LAST_INT_PAYMENT_DATE=AS_OF_DATE
Warning	Last interest payment date > As of Date
Error Level	Warning

Rule ID: 93

Error Condition	(LAST_PRIN_PAYMENT_DATE > AS_OF_DATE and ORIGINATION_DATE <= AS_OF_DATE)
Error Description	Last principal payment date cannot be greater than the as-of-date if the instrument originated in the past.
Assignment	LAST_PRIN_PAYMENT_DATE=AS_OF_DATE
Warning	Last principal payment date > As of Date
Error Level	Warning

Rule ID: 94

Error Condition	(INTEREST_TIMING_TYPE_CD = 2 and AMRT_TYPE_CD in (100, 400, 600, 710, 800, 840, 850))
Error Description	Interest type can only be arrears for conventionally amortizing instruments.
Assignment	INTEREST_TIMING_TYPE_CD=1
Warning	Amortization Type is conventional but interest timing is Advance
Error Level	Warning

Rule ID: 95

Error Condition	(INTEREST_TIMING_TYPE_CD is NULL or INTEREST_TIMING_TYPE_CD not in (1, 2, 3))
Error Description	Interest type must be a valid OFSAA code.
Assignment	INTEREST_TIMING_TYPE_CD=1
Warning	Invalid interest timing type
Error Level	Warning

Rule ID: 96

Error Condition	(COMPOUND_BASIS_CD is NULL or COMPOUND_BASIS_CD not in (110, 120, 130, 140, 150, 160, 170))
Error Description	Compounding basis code must be a valid OFSAA code
Assignment	COMPOUND_BASIS_CD=160
Warning	Invalid Compounding Basis Code
Error Level	Warning

Rule ID: 97

Error Condition	(ACCRUAL_BASIS_CD IN (1, 4, 5) and (INT_PMT_FREQ_MULT = 'D' or AMRT_TYPE_CD in (800,801, 802)))
Error Description	Accrual basis code cannot have a 30 day month assumption on instruments defined by a payment schedule
Assignment	ACCRUAL_BASIS_CD=3
Warning	Amortization Type / Accrual Basis Error
Error Level	Warning

Rule ID: 98

Error Condition	(ACCRUAL_BASIS_CD = 7 and (HOLIDAY_CALENDAR_CODE is NULL or HOLIDAY_CALENDAR_CODE <=0 or HOLIDAY_CALC_OPTION_CD is NULL or HOLIDAY_CALC_OPTION_CD not in (1, 2) or HOLIDAY_ROLLING_CONVENTION_CD is NULL or HOLIDAY_ROLLING_CONVENTION_CD not in (2,3,4,5)))
Error Description	Holiday calendar must be give when using Business/252 accrual basis
Assignment
Warning	Holiday calendar not given for B/252 accrual basis
Error Level	Info

Rule ID: 99

Error Condition	(AMRT_TYPE_CD = 10 and BEHAVIOUR_TYPE_CD is NULL)
Error Description	Behaviour Type Code is Null, defaulted to 1 (Non-Maturity)
Assignment	BEHAVIOUR_TYPE_CD=1
Warning	Behaviour Type Code is Null
Error Level	Warning

Rule ID: 100

Error Condition	(AMRT_TYPE_CD = 10 and BEHAVIOUR_TYPE_CD not in (1,2,3))
Error Description	Behaviour Type Code is invalid, defaulted to 1 (Non-Maturity)
Assignment	BEHAVIOUR_TYPE_CD=1
Warning	Invalid Behaviour Type Code
Error Level	Warning

Rule ID: 101

Error Condition	(AMRT_TYPE_CD = 10 and BEHAVIOUR_TYPE_CD = 2 and (BEHAVIOUR_SUB_TYPE_CD is NULL or BEHAVIOUR_SUB_TYPE_CD not in (201, 202, 203)))
Error Description	Behaviour Sub Type should be 201 or 202 or 203 when Behaviour Type is Non-Performing
Assignment	BEHAVIOUR_SUB_TYPE_CD=201
Warning	Invalid Behavior Sub Type Code
Error Level	Warning

Rule ID: 102

Error Condition	(AMRT_TYPE_CD = 10 and BEHAVIOUR_TYPE_CD = 3 and (BEHAVIOUR_SUB_TYPE_CD is NULL or BEHAVIOUR_SUB_TYPE_CD not in (305, 306)))
Error Description	Behaviour Sub Type should be 305 or 306 when Behaviour Type is Devolvement and Recovery
Assignment	BEHAVIOUR_SUB_TYPE_CD=305
Warning	Invalid Behavior Sub Type Code
Error Level	Warning

Rule ID: 103

Error Condition	(AMRT_TYPE_CD = 840 and RESIDUAL_AMOUNT < 0)
Error Description	Residual Amount cannot be less than 0 for Lease instrument
Assignment	RESIDUAL_AMOUNT=0
Warning	Invalid Residual Amount for Lease instrument
Error Level	Warning

Rule ID: 104

Error Condition	(AMRT_TYPE_CD = 840 and RESIDUAL_AMOUNT > CUR_PAR_BAL)
Error Description	Residual Amount cannot be higher than Current Par Balance for Lease instrument
Assignment	RESIDUAL_AMOUNT=0
Warning	Invalid Residual Amount for Lease instrument
Error Level	Warning

Rule ID: 105

Error Condition	(AMRT_TYPE_CD = 850 and MATURITY_AMOUNT > 0 and ADJUSTABLE_TYPE_CD > 0)
Error Description	Annuity instrument with maturity amount must have fixed interest rate
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Invalid Adjustable Type for Annuity with Maturity Amount
Error Level	Warning

Rule ID: 106

Error Condition	(MOA_EXPECTED_BAL > 0 and (MOA_OFFSET_PERCENT is NULL or MOA_OFFSET_PERCENT < 0))
Error Description	Expected balance is greater than 0 but offset percentage is less than 0
Assignment	MOA_OFFSET_PERCENT=0
Warning	Invalid offset percent
Error Level	Warning

Rule ID: 107

Error Condition	((MOA_EXPECTED_BAL * MOA_OFFSET_PERCENT/100) > CUR_PAR_BAL)
Error Description	Calculated Offset Balance is higher than Current Par Balance
Assignment
Warning	Calculated Offset Balance > Current Par Balance
Error Level	Info

Rule ID: 108

Error Condition	(ADJUSTABLE_TYPE_CD = 10 and (REPRICE_PATTERN_CD is NULL or REPRICE_PATTERN_CD <= 0))
Error Description	Invalid reprice pattern code given for instrument
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Invalid reprice pattern code
Error Level	Warning

Rule ID: 109

Error Condition	(ADJUSTABLE_TYPE_CD = 10 and REPRICE_PATTERN_CD > 0 and REPRICE_PATTERN_CD not in (select ADJUSTABLE_TYPE_CD from fsi_reprice_pattern))
Error Description	Invalid reprice pattern code given for instrument
Assignment	ADJUSTABLE_TYPE_CD=0
Warning	Invalid reprice pattern code
Error Level	Warning

Rule ID: 110

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and (ORG_PAYMENT_AMT is NULL or ORG_PAYMENT_AMT <= 0))
Error Description	Original payment amount is required for fixed-rate instruments
Assignment	ORG_PAYMENT_AMT=CUR_PAYMENT
Warning	Invalid Original Payment Amount
Error Level	Warning

Rule ID: 111

Error Condition	(PERCENT_SOLD < 0 or PERCENT_SOLD > 99)
Error Description	Percent Sold must be greater than or equal to zero and less than 100
Assignment	PERCENT_SOLD=0
Warning	Invalid Percent Sold
Error Level	Warning

Rule ID: 112

Error Condition	(CUR_PAR_BAL is NULL or CUR_PAR_BAL = 0)
Error Description	Instruments with Current Par Balance zero are not processed.
Assignment
Warning	Current Par Balance = 0
Error Level	Warning

Rule ID: 113

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and AMRT_TYPE_CD <> 700)
Error Description	Embedded option is supported only for non-amortizing instrument
Assignment	EMBEDDED_OPTIONS_FLG=0
Warning	Invalid embedded options flag
Error Level	Warning

Rule ID: 114

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and TP_EFFECTIVE_DATE > ORIGINATION_DATE)
Error Description	TP Effective Date must not be after Origination Date for fixed rate instrument
Assignment
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 115

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and TP_EFFECTIVE_DATE < ORIGINATION_DATE)
Error Description	TP Effective Date must not be before Origination Date for fixed rate instrument
Assignment
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 116

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and TP_EFFECTIVE_DATE > LAST_REPRICE_DATE)
Error Description	TP Effective Date must not be after Last Reprice Date for non-fixed rate instrument
Assignment
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 117

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and TP_EFFECTIVE_DATE <= NEXT_REPRICE_DATE)
Error Description	TP Effective Date must not equal to Next Reprice Date for non-fixed rate instrument
Assignment
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 118

Error Condition	(TP_EFFECTIVE_DATE is not NULL and TP_EFFECTIVE_DATE < '01-JAN-1970')
Error Description	TP Effective Date is before '01-JAN-1970'
Assignment	TP_EFFECTIVE_DATE=ORIGINATION_DATE
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 119

Error Condition	(TP_EFFECTIVE_DATE > MATURITY_DATE)
Error Description	TP Effective Date is after maturity date
Assignment	TP_EFFECTIVE_DATE=ORIGINATION_DATE
Warning	Invalid TP Effective Date
Error Level	Info

Rule ID: 120

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and ADJ_EFFECTIVE_DATE > ORIGINATION_DATE)
Error Description	Adjustment Effective Date must not be after Origination Date for fixed rate instrument
Assignment
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 121

Error Condition	(ADJUSTABLE_TYPE_CD = 0 and ADJ_EFFECTIVE_DATE < ORIGINATION_DATE)
Error Description	Adjustment Effective Date must not be before Origination Date for fixed rate instrument
Assignment
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 122

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and ADJ_EFFECTIVE_DATE > LAST_REPRICE_DATE)
Error Description	Adjustment Effective Date must not be after Last Reprice Date for non-fixed rate instrument
Assignment
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 123

Error Condition	(ADJUSTABLE_TYPE_CD > 0 and ADJ_EFFECTIVE_DATE <= NEXT_REPRICE_DATE)
Error Description	Adjustment Effective Date must not equal to Next Reprice Date for non-fixed rate instrument
Assignment
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 124

Error Condition	(ADJ_EFFECTIVE_DATE is not NULL and ADJ_EFFECTIVE_DATE < '01-JAN-1970')
Error Description	Adjustment Effective Date is before '01-JAN-1970'
Assignment	ADJ_EFFECTIVE_DATE=ORIGINATION_DATE
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 125

Error Condition	(ADJ_EFFECTIVE_DATE > MATURITY_DATE)
Error Description	Adjustment Effective Date is after maturity date
Assignment	ADJ_EFFECTIVE_DATE=ORIGINATION_DATE
Warning	Invalid Adjustment Effective Date
Error Level	Info

Rule ID: 10001

Error Condition	(OPTION_RFR_IRC_CD > 0 and exists (select 1 from fsi_ircs where fsi_ircs.RISK_FREE_RATE_FLG is null or fsi_ircs.RISK_FREE_RATE_FLG = 0 and fsi_ircs.INTEREST_RATE_CD=SOURCE_TABLE.OPTION_RFR_IRC_CD))
Error Description	Risk Free Interest Rate Curve is not defined as Risk-Free.
Assignment
Warning	Invalid Risk Free Interest Rate Curve
Error Level	Error

Rule ID: 10002

Error Condition	(OPTION_RFR_IRC_CD > 0 and exists (select 1 from fsi_ircs where fsi_ircs.ISO_CURRENCY_CD != SOURCE_TABLE.ISO_CURRENCY_CD and fsi_ircs.INTEREST_RATE_CD=SOURCE_TABLE.OPTION_RFR_IRC_CD))
Error Description	Currency of risk free Interest Rate Curve is different from currency of instrument record.
Assignment
Warning	Invalid Risk Free Interest Rate Curve
Error Level	Error

Rule ID: 10003

Error Condition	(OPTION_VOL_IRC_CD > 0 and exists (select 1 from FSI_VOL_SURFACE_MASTER where FSI_VOL_SURFACE_MASTER.ISO_CURRENCY_CD != SOURCE_TABLE.ISO_CURRENCY_CD and FSI_VOL_SURFACE_MASTER.VOL_SURFACE_SYS_ID=SOURCE_TABLE.OPTION_VOL_IRC_CD))
Error Description	Currency of Volatility Surface is different from currency of instrument record.
Assignment
Warning	Invalid Volatility Surface
Error Level	Error

Rule ID: 10004

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and STRIKE_TYPE_CD not in (1,2))
Error Description	Strike Type must be Rate or Price for instruments with embedded options.
Assignment
Warning	Invalid Strike Type for Embedded Option
Error Level	Error

Rule ID: 10005

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and EXERCISE_TYPE_CD not in (1,2,3))
Error Description	Exercise type for instrument with embedded options must be American, Bermudan or European.
Assignment
Warning	Invalid Exercise Type for Embedded Option
Error Level	Error

Rule ID: 10006

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and EXERCISE_TYPE_CD = 1 and OPTION_START_DATE <= AS_OF_DATE)
Error Description	Option Start Date for an American option must be after As of Date.
Assignment
Warning	Invalid Option Start Date for American Option
Error Level	Info

Rule ID: 10007

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and OPTION_TYPE_CD not in (1,2))
Error Description	Option Type must be Call or Put for instrument with Embedded Option.
Assignment
Warning	Invalid Option Type for Embedded Option
Error Level	Error

Rule ID: 10008

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and STRIKE_TYPE_CD = 2 and nvl(STRIKE_IRC_CD,0) < 1)
Error Description	Strike type is Rate for instrument with Embedded Option but Strike Interest Rate Curve is not available.
Assignment
Warning	Invalid Strike Interest Rate Curve for Embedded Option
Error Level	Error

Rule ID: 10009

Error Condition	(EMBEDDED_OPTIONS_FLG = 1 and STRIKE_TYPE_CD = 2 and nvl(RATE_LOOKUP_CD,0) not in (1,2,3,4))
Error Description	Strike type is Rate for instrument with Embedded Option but Rate Lookup Code is not available.
Assignment
Warning	Invalid Rate Lookup Code for Embedded Option
Error Level	Error

Rule ID: 10010

Error Condition	(EXCHG_OF_PRINCIPAL is NULL OR EXCHG_OF_PRINCIPAL not in (0,1))
Error Description	Invalid Exchange of Principal flag
Assignment
Warning	Invalid Exchange of Principal flag.
Error Level	Warning

Rule ID: 10011

Error Condition	(ACCOUNT_TYPE in (150, 200, 350, 400, 610, 620) and AMRT_TYPE_CD not in (10, 820, 801, 700, 802))
Error Description	Invalid Amortization Type.
Assignment
Warning	Invalid Amortization Type for non earning assets and liabilities
Error Level	Warning

Rule ID: 10012

Error Condition	(ACCOUNT_TYPE in (150, 200, 350, 400, 610, 620) and (CUR_NET_RATE <> 0 or CUR_GROSS_RATE <> 0))
Error Description	Interest Rate of non earning assets and liabilities must be 0.
Assignment
Warning	Invalid Interest Rate for non earning assets and liabilities
Error Level	Warning

Rule ID: 10013

Error Condition	(ACCOUNT_TYPE in (150, 200, 350, 400, 610, 620) and ADJUSTABLE_TYPE_CD <> 0)
Error Description	Adjustable Type of non earning assets and liabilities must be 0.
Assignment
Warning	Invalid Adjustable Type for non earning assets and liabilities
Error Level	Warning

Rule ID: 10014

Error Condition	(ACCOUNT_TYPE in (150, 200, 350, 400, 610, 620) and INTEREST_TIMING_TYPE_CD <> 1)
Error Description	Interest timing type of non earning assets and liabilities must be Arrears.
Assignment
Warning	Invalid Interest timing type for non earning assets and liabilities
Error Level	Warning

Rule ID: 10015

Error Condition	(ADJUSTABLE_TYPE_CD in (50, 250) and not exists (select 1 from fsi_ircs where fsi_ircs.interest_rate_cd = SOURCE_TABLE.interest_rate_cd and nvl(fsi_ircs.volatility_curve_flg,0) = 0))
Error Description	Interest rate code of instrument does not exist. Repricing attributes will be ignored and processed as fixed interest rate.
Assignment
Warning	Wrong Interest Rate Code for adjustable rate instrument
Error Level	Warning

Rule ID: 10016

Error Condition	(ORG_INT_PAYMENT_DATE is NULL OR ORG_INT_PAYMENT_DATE < ORIGINATION_DATE)
Error Description	Invalid Original Interest Payment Date
Assignment
Warning	Invalid Original Interest Payment Date
Error Level	Warning

Rule ID: 10017

Error Condition	(ORG_PRIN_PAYMENT_DATE is NULL OR ORG_INT_PAYMENT_DATE < ORIGINATION_DATE)
Error Description	Invalid Original Principal Payment Date
Assignment
Warning	Invalid Original Principal Payment Date
Error Level	Warning