25.1 List of Cash Flow Edit Error Messages

Table 25-1 List of Cash Flow Edit Error Messages

Error Code Error Condition Assignment Error Level Warning Description/Purpose Edit Priority

9100

If ((AMRT_TYPE_CD <> 700 or (AMRT_TYPE_CD = 700 and AMRT_TERM <> 0)) and AMRT_TERM (in days) < ORG_TERM (in days)

Set AMRT_TERM equal to ORG_TERM, AMRT_TERM_MULT = ORG_TERM_MULT

2

Org Term > Amrt Term

Amortization term can only be equal to zero on Non/Amortizing instruments

9102

CUR_GROSS_RATE < 0

message only: Current Gross Rate < 0

1

Current Gross Rate < 0

Current gross rate must not be negative

9103

CUR_NET_RATE < 0

message only: Current Net Rate < 0

1

Current Net Rate < 0

Current net rate must not be negative

9104

ACCRUAL_BASIS_CD <1 or >7

ACCRUAL_BASIS_CD equal to '3'.

2

Invalid Accrual Basis Cd

Accrual basis code must be between 1 and 7 inclusively

9105

AMRT_TYPE_CD (<= 999 and not equal to 100, 200, 400, 500,600, 700, 710, 800, 801, 802, 820,830,840,850 or 999) or >99999

Set AMRT_TYPE_CD equal to '700'.

2

Invalid Amortization Type defaulted to 700

Checks that amortization type codes are either in the user-defined range or that they are a valid OFSA code.

9106

AMRT_TERM_MULT not equal to D, M, or Y

AMRT_TERM_MULT = 'M'

2

Invalid AMRT_TERM_MULT

Checks for valid amortization term multipliers

9107

NEG_AMRT_EQ_MULT not equal to D, M, or Y

NEG_AMRT_EQ_MULT = 'M'.

2

Invalid NEG_AMRT_EQ_MULT

Checks for valid Neg.Amortization Eq.Multipliers

9108

(NEG_AMRT_LIMIT >=200)or(NEG_AMRT_LIMIT < 0) and AMRT_TYPE_CD = 600

Set NEG_AMRT_LIMIT equal to 0.

2

Invalid NgAm Limit

Neg Am limit value does not fall in a valid range. (Neg Am instruments only)

9109

ORG_TERM_MULT not equal to D, M, or Y

ORG_TERM_MULT = 'M'

2

Invalid ORG_TERM_MULT

Checks for valid Original term multipliers

9110

If AMRT_TYPE_CD = 600 and PMT_CHG_FREQ < 0

PMT_CHG_FREQ equal to 0

2

Invalid Pmt Chg Frq

frequency cannot be negative (Neg Am instrument only)

9111

PMT_CHG_FREQ_MULT not equal to D, M, or Y

PMT_CHG_FREQ_MULT equal to 'M'.

2

Invalid PMT_CHG_FREQ_MULT

Checks for valid payment change frequency multipliers

9112

PMT_FREQ_MULT not equal to D, M, or Y

PMT_FREQ_MULT = 'M'

2

Invalid PMT_FREQ_MULT

Checks for valid payment frequency multipliers

9114

RATE_CHG_RND_CD <0 or >4

RATE_CHG_RND_CD equal to '0'.

2

Invalid Rate Chg Rnd Cd

Rate change round code must be between 0 and 4

9115

RATE_SET_LAG_MULT not equal to D, M, or Y

RATE_SET_LAG_MULT equal to 'M'.

2

Invalid RATE_SET_LAG_MULT

Checks for valid rate set lag multipliers

9117

REPRICE_FREQ_MULT not equal to D, M, or Y

REPRICE_FREQ_MULT = 'M'.

2

Invalid REPRICE_FREQ_MULT

Checks for valid reprice frequency multipliers

9118

RATE_CHG_RND_FAC < 0 or RATE_CHG_RND_FAC > 1

Set RATE_CHG_RND_FAC equal to 0.

2

Invalid Rt Chg Rnd Fact

Rate change round factor must be a percentage

9119

MATURITY_DATE < NEXT_PAYMENT_DATE

MATURITY_DATE = NEXT_PAYMENT_DATE + ((REMAIN_NO_PMTS_C -1)*PMT_FREQ)

2

Mat Dt < Next Pmt Dt

The maturity date can not be before the next payment date

9120

NEG_AMRT_EQ_FREQ < 0 and AMRT_TYPE_CD = 600

NEG_AMRT_EQ_FREQ equal to 0.

2

NegAmEqFrq < 0

Neg Am Equalization frequency cannot be negative (Neg Am instruments only)

9121

If AMRT_TYPE_CD = 600 and NEG_AMRT_EQ_FREQ > 0 and NEG_AMRT_EQ_DATE <= MAX(ORIGINATION_DATE,AS_OF_DATE)

Set NEG_AMRT_EQ_DATE equal to NEXT_REPRICE_DATE

2

NgAm Eq Dt < Org Dt

Neg Am equalization date is less than origination date (future origination) or less than the as-of-date (past origination) (Neg am instrumented only)

9123

AS_OF_DATE > ORIGINATION_DATE and AS_OF_DATE >= NEXT_PAYMENT_DATE

NEXT_PAYMENT_DATE equal to AS_OF_DATE + 1 day.

2

Next Pmt Dt < As of Dt

The next payment date is less than as-of-date (past origination case) As of Date can not be greater than the origination date and greater than the next payment date.

9124

ORIGINATION_DATE >= AS_OF_DATE and ORIGINATION_DATE >= NEXT_PAYMENT_DATE

NEXT_PAYMENT_DATE = ORIGINATION_DATE + 1 day

2

Next Pmt Dt < Org Dt

Next payment date is less than origination date (future origination case)

9125

ORIGINATION_DATE <= AS_OF_DATE and NEXT_REPRICE_DATE <= AS_OF_DATE and REPRICE_FREQ > 0

NEXT_REPRICE_DATE equal to AS_OF_DATE + 1 day.

2

Next Repr Dt < As of Dt

Next reprice date is less than as-of-date (past origination case)

9126

ORIGINATION_DATE > AS_OF_DATE and NEXT_REPRICE_DATE < ORIGINATION_DATE and REPRICE_FREQ > 0

Set NEXT_REPRICE_DATE equal to ORIGINATION_DATE + 1 day

2

Next Repr Dt < Org Dt

Next reprice date is less than the origination date (future origination case)

9127

ORG_PAYMENT_AMT = 0 and PMT_DECR_LIFE > 0

Set PMT_DECR_LIFE equal to 0.

2

Org Pmt=0, Pmt Dec Lf<>0

Payment decrease life is expressed as a percent of a zero original payment. (Neg Am instruments only)

9128

ORG_PAYMENT_AMT = 0 and PMT_INCR_LIFE > 0

Set PMT_INCR_LIFE equal to 0.

2

Org Pmt=0, Pmt Incr Lf<>0

Payment increase life is expressed as a percent of a zero original payment. (Neg Am instruments only)

9129

ORG_TERM <> calculated original term within 45 days or ORG_TERM = 0

Set ORG_TRM = calculated original term

2

Org Term<>Mat Dt - Org Dt

The original term should equal the time between the origination date and the maturity date.

9130

(ORIGINATION_DATE < 01/01/1950) or (ORIGINATION_DATE > 01/01/2099)

Set ORIGINATION_DATE = 01/01/1950.

2

Orig. Dt < 01/01/1950

Origination date must be acceptable

9131

PMT_FREQ > calculated original term

PMT_FREQ equal to calculated original term

2

Payment Freq > Org Term

Payment frequency cannot be greater than the original term.

9132

(CUR_PAYMENT < 0 and CUR_PAR_BAL > 0) or (CUR_PAYMENT > 0 and CUR_PAR_BAL < 0)

Set CUR_PAYMENT equal to 0.

2

Pmt, bal opposite signs

Current payment and current balance can not have opposite signs

9133

If AMRT_TYPE_CD = 600 and PMT_CHG_FREQ > 0 and AS_OF_DATE > PMT_ADJUST_DATE

PMT_ADJUST_DATE = NEXT_REPRICE_DATE

2

Pmt Adj Dt < As of Dt

Neg Am equalization date is less than the as-of-date (past origination) (Neg am instrumented only

9134

If AMRT_TYPE_CD = 600 and PMT_CHG_FREQ > 0 and AS_OF_DATE < PMT_ADJUST_DATE and PMT_ADJUST_DATE < ORIGINATION_DATE

PMT_ADJUST_DATE = NEXT_REPRICE_DATE

2

Pmt Adj Dt < Org Dt

The payment adjustment date is less than origination date (future origination) (Neg am instrumented only)

9135

PMT_FREQ <= 0 and ORIGINATION_DATE <= AS_OF_DATE and MATURITY_DATE > AS_OF_DATE and ORIGINATION_DATE > AS_OF_DATE and MATURITY_DATE > ORIGINATION_DATE

NEXT_PAYMENT_DATE = MATURITY_DATE and ORG_TERM = calculated original term and PMT_FREQ = calculated original term and REMAIN_NO_PMTS_C = 1

2

Pmt Freq <= 0, Trm Assumed

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.

9135

PMT_FREQ <= 0 and ORIGINATION_DATE <= AS_OF_DATE, MATURITY_DATE <= AS_OF_DATE but NEXT_PAYMENT_DATE > AS_OF_DATE or ORIGINATION_DATE > AS_OF_DATE, MATURITY_DATE < ORIGINATION_DATE,but NEXT_PAYMENT_DATE > ORIGINATION_DATE

MATURITY_DATE = NEXT_PAYMENT_DATE and ORG_TERM = calculated original term and PMT_FREQ = calculated original term and REMAIN_NO_PMTS_C = 1

2

Pmt Freq <= 0 ,Trm Assumed

Payment frequency is less than or equal to zero and maturity date is invalid, but next payment date can be used to calculate a valid payment frequency

9135

PMT_FREQ <= 0 and ORIGINATION_DATE <= AS_OF_DATE, MATURITY_DATE <= AS_OF_DATE, and NEXT_PAYMENT_DATE <= AS_OF_DATE or ORIGINATION_DATE > AS_OF_DATE, and both MATURITY_DATE and NEXT_PAYMENT_DATE less than ORIGINATION_DATE

MATURITY DATE = AS OF DATE + 1 day and NEXT PAYMENT DATE = AS OF DATE + 1 day and ORG TERM = calculated original term and PMT_FREQ = calculated original term and REMAIN_NO_PMTS_C = 1.

2

Pmt Freq <= 0, Trm Assumed

Payment frequency less than or equal to zero and all dates which can be used to calculate payment frequency is in the past

9136

PMT_INCR_CYCLE < 0

Set PMT_INCR_CYCLE equal to 0.

2

Pmt Incr Cycle < 0

Payment increase cycle cannot be less than zero (Neg Am instruments only)

9138

RATE_CAP_LIFE < CUR_GROSS_RATE and RATE_CAP_LIFE <> 0 and CUR_GROSS_RATE <> 0 and TEASER_END_DATE < AS_OF_DATE

Set RATE_CAP_LIFE equal to CUR_GROSS_RATE.

1

Rt Cap Lf < Cur Gross Rt

Current gross rate is greater than the rate cap life

9139

RATE_CAP_LIFE < CUR_NET_RATE and RATE_CAP_LIFE <> 0

message only: Rt Cap Life < Cur Net Rt

1

Rt Cap Life < Cur Net Rt

Current net rate is greater than the rate cap

9140

RATE_CHG_MIN < 0

Set RATE_CHG_MIN equal to 0.

2

Rate Chg Min < 0

Minimum rate change can not be negative

9141

RATE_DECR_CYCLE < 0

RATE_DECR_CYCLE equal to 0.

2

Rate Decr Cycle < 0

Rate decrease cycle must not be negative

9143

RATE_FLOOR_LIFE > CUR_GROSS_RATE and CUR_GROSS_RATE <> 0 and TEASER_END_DATE < AS_OF_DATE

Set RATE_FLOOR_LIFE equal to CUR_GROSS_RATE.

1

Rt Floor Lf > Cur Grss Rt

Current gross rate is less than the rate floor

9144

RATE_FLOOR_LIFE > CUR_NET_RATE

message only: Rt Floor Lf > Cur Net Rt

1

Rt Floor Lf > Cur Net Rt

Rate floor life must not be greater than the current net rate

9145

RATE_INCR_CYCLE < 0

RATE_INCR_CYCLE equal to 0.

2

Rate Incr Cycle < 0

Rate increase cycle can not be less than 0

9147

REMAIN_NO_PMTS_C < 1

REMAIN_NO_PMTS_C = 1

2

Rem No Pmts < 1

There has to be at least 1 payment left

9148

RATE_SET_LAG < 0

RATE_SET_LAG = 0

2

Set Lag < 0

Rate set lag can not be negative

9152

ORG_PAR_BAL < CUR_PAR_BAL and AMRT_TYPE_CD =710

message only: OrgParBal < CurParBal

1

Org Par Bal < Cur Par Bal

The original balance on the rule of 78's instruments should not be greater than the current balance

9153

REPRICE_FREQ = 0 and (AMRT_TYPE_CD = 500 or AMRT_TYPE_CD = 600)

message only: AdjAmrtType, ReprFrq=0

1

AdjAmrtType, ReprFrq=0

Reprice frequency denotes fixed on adjustable amortization types (Conventional Adjustable and Adjustable Neg Am)

9154

REPRICE_FREQ <> 0 and LAST_REPRICE_DATE > NEXT_REPRICE_DATE

LAST_REPRICE_DATE = NEXT_REPRICE_DATE minus REPRICE_FREQ

2

LastReprDt>NextReprDt

Last reprice date is greater than the next reprice date

9155

IF INTEREST_RATE_CD < 0 or INTEREST_RATE_CD > 99999

INTEREST_RATE_CD = 0

2

Int Rt Code out of range

Interest rate code must be within a valid range

9157

T_RATE_INT_RATE_CD < 0 or T_RATE_INT_RATE_CD > 99999

T_RATE_INT_RATE_CD = 99999

2

T_ Rt Int Rt Cd out of rng

T rate interest rate code must be within a valid range.

9158

If CUR_BOOK_BAL <> (CUR_PAR_BAL + DEFERRED_CUR_BAL)

Warning Only

1

CurBkBl <> ParBl + Def Bl

Current book balance should equal the current par balance plus the deferred current balance

9159

CUR_NET_PAR_BAL_C - CUR_PAR_BAL * ( 1 - PERCENT_SOLD/100) >.001

Warning

1

NetParBl<>Com ptd NetParBl

Current net par balance should reflect the bank-owned portion of the current gross balance

9160

If AMRT_TYPE_CD = 600 and PMT_DECR_CY < 0

PMT_DECR_CY = 0

2

Payment Decrease Cycle =0

Payment decrease cycle cannot be less than zero (Neg Am instruments only)

9161

If AMRT_TYPE_CD = 600 and PMT_DECR_LF < 0

Set PMT_DECR_LIFE equal to 0.

2

PmtDecrLf<0 for Adj NegAm

Payment decrease life cannot be less than zero (Neg Am instruments only)

9162

If AMRT_TYPE_CD = 600 and PMT_DECR_LF <> 0 and CUR_PAYMENT < ORG_PAYMENT_AMT * (1 - PMT_DECR_LF/100)

Warning Only

1

Cur Pmt < Life Pay Floor

The current payment is less than the minimum payment amount (Neg Am instruments only)

9163

If AMRT_TYPE_CD = 600 and PMT_INCR_LF < 0

Set PMT_INCR_LIFE equal to 0.

2

PmtIncrLf<0 for Adj NegAm

Payment increase life cannot be less than zero (Neg Am instruments only)

9164 If AMRT_TYPE_ CD = 600 and PMT_INCR_LF <> 0 and CUR_ PAYMENT > ORG_PAYMENT_ AMT * (1 + PMT_ INCR_LF/100) Warning Only 1 Cur Pmt > Life Pay Cap Current payment is greater than the maximum payment amount (Neg Aminstrum ents only)  
9165 If ISSUE_DATE > ORIGINATION_ DATE Set ISSUE_ DATE = ORIGINATIO N_DATE 2 Issue Date > Orig Date Issue date can not be greater than origination date  
9166 If REPRICE_FREQ < 0 REPRICE_ FREQ = 0 2 Reprice_ Freq < 0 Reprice frequencies must not be negative  
9167 If AMRT_TYPE_ CD = 710 and REPRICE_FREQ < > 0 REPRICE_ FREQ = 0 2 Rule of 78s Reprice_ Freq<>0 Rule of 78's instruments are implicitly fixed.  
9168 ORG_PAR_BAL = 0 and REPRICE_ FREQ = 0 Warning 1 OrgParBal= 0! Fixed Rate For transfer pricing of fixed rate instruments , the original balance should be populated,  
9169 If REPRICE_FREQ <> 0 and TEASER_ END_DATE > ORIGINATION_ DATE and TEASER_END_ DATE > AS_OF_ DATE and NEXT_ REPRICE_DATE > TEASER_END_ DATE Set NEXT_ REPRICE_ DATE equal to TEASER_ END_DATE 2 Next Repr Dt > Ts End Dt Next reprice date is greater than tease end date.  
9170 If REMAIN_NO_ PMTS_C + (REMAIN_TERM_ C (in days) / REPRICE_FREQ (in days)) > 2000 Warning 1 >2000 Events for Record The maximum number of events that can be modeled has been exceeded.  
9171 LRD_BALANCE=0 LRD_ BALANCE = CUR_PAR_ BAL 2 LRDBalanc e=0 The balance as of the last reprice date cannot be equal to 0 Note: If Cur_Par_ Bal = 0, then it would not be processed by the cash flow engine as error.  
9172 ADJUSTABLE_ TYPE_CD <> 0 and LAST_REPRICE_ DATE < ISSUE_ DATE Message Only 1 LastReprice Date < Issue Date When the last reprice date is less than the issue date, transfer pricing will not occur.  
9174 REPRICE_FREQ > 0 and ADJUSTABLE_ TYPE_CD = 0 Message Only 1 AdjType=0 & ReprFreq>0 Reprice frequency and adjustable type code are inconsistent  
9175 REPRICE_FREQ = 0 and ADJUSTABLE_ TYPE_CD <> 0 Message Only 1 AdjType<> 0 & ReprFreq=0 Reprice frequency and adjustable type code are inconsistent  
9176 AMRT_TYPE_CD = 100 and ADJUSTABLE_ TYPE_CD <> 0 Message Only 1 AdjType<> 0 & AmrtType= 100 Variable adjustable type on Convention al Fixed instrument.  
9177 AMRT_TYPE_CD = 710 and ADJUSTABLE_ TYPE_CD <> 0 ADJUSTABLE _TYPE_CD =0 2 AdjType<> 0 & AmrtType= 710 Rule of 78's instrumnet should only have a fixed adjustable type code.  
9178 (AMRT_TYPE_CD = 500 or AMRT_ TYPE_CD = 600) and ADJUSTABLE_ TYPE_CD = 0 Message Only 1 AdjType=0 & Amrt(500,6 00) Fixed adjustable type code on adjustable amortizatio n codes (Conventio nal Adjustable and Adjustable Neg Am)  
9179 LAST_PAYMENT_ DATE > NEXT_ PAYMENT_DATE and PAYMENT_ FREQ > 0 LAST_ PAYMENT_ DATE =NEXT_ PAYMENT_ DATE -PMT_ FREQ 2 LastPayDat e>=N extPayDate Last payment date is greater than next payment date and can be calculated using payment frequency  
9179 LAST_PAYMENT_ DATE > NEXT_ PAYMENT_DATE and PAYMENT_ FREQ <= 0 LAST_ PAYMENT_ DATE =ORIGINATI ON_DATE 2 LAST_ PAYMENT_ DATE =ORIGINATI ON_DATE Last payment date is greater than next payment date, but cannot be calculated using payment frequency.  
9180 LAST_PAYMENT_ DATE < ORIGINATION_ DATE LAST_ PAYMENT_ DATE =ORIGINATI ON_DATE 2 LastPayDat e < OrigDate Last payment date cannot be less than the origination date  
9181 LAST_PAYMENT_ DATE > AS_OF_ DATE and ORIGINATION_ DATE <= AS_OF_ DATE LAST_ PAYMENT_ DATE =AS_ OF_DATE 2 LastPayDat e>AsOfDat e Last payment date cannot be greater than the as-of-date if the instrument originated in the past.  
9182 INT_TYPE = 2 and AMRT_TYPE CD = 100, 400, 500, 600 or 800 INT_TYPE = 1 2 IntType<>1 ,2 /Amrt Type Interest type can only be arrears for convention ally amortizing instruments  
9182 INT_TYPE <> 1 or 2 INT_TYPE = 1 2 IntType<>1 ,2 /Amrt Type Interest type must be a valid OFSA code.  
9183 COMPOUND_ BASIS_CD <> 110, 120, 130, 140, 150, 160, 170 or 200 COMPOUND_ BASIS_CD = 160 2 Invalid CompBasis Code Compoundi ng basis code must be a valid OFSA code  
9184 (ACCRUAL_ BASIS_CD = 1, 4 or 5) and (PMT_ FREQ_MULT = D or AMRT_TYPE_ CD = 800,801, or 802) ACCRUAL_ BASIS_CD = 3 2 AmrtType/ AccrlBasis Error Accrual basis code cannot have a 30 day month assumption on instruments defined by a payment schedule  
9187 If Error Codes 9185 and 9186 are not qualified, then execute this Error code 9187   1 The behavior type (and/or sub-type, based on other attribute values) will be automatically defaulted during the engine processing. The behavior type (and/or sub-type, based on other attribute values) will be automatically defaulted during the engine processing.