Operator Types

The operators available are of three types:

• Arithmetic
• Comparison
• Other

The following table describes the Operator Type with an example.

Table 8-22 Operator Types

Type	Operator	Example
Arithmetic	+	CUR_BOOK_BAL = CUR_PAR_BAL + DEFERRED_CUR_BAL
	-	AS_OF_DATE = MATURITY_DATE – REMAIN_TERM_C
	*	Remaining Balance after Offset = Opening balance – (Expected balance on every payment date * Mortgage offset %)
	/	CUR_PAYMENT = ORG_BOOK_BAL/ (ORG_TERM/ PMT_FREQ [in months])
Comparison	=	CUR_PAYMENT = principal + interest
	<>	If ADJUSTABLE_TYPE_CD <> 0, INTEREST_RATE_CD = 001 to 99999.
	>	If ORIGINATION_DATE > AS_OF_DATE, LAST_PAYMENT_DATE = ORIGINATION_DATE.
	>=	AS_OF_DATE >= ORIGINATION_DATE
	<	AS_OF_DATE < NEXT_REPRICE_DATE
	<=	If ORIGINATION_DATE <= AS_OF_DATE, LAST_PAYMENT_DATE >= ORIGINATION_DATE
Other	(	Parentheses group segments of an expression to make logical sense.
	)	MATURITY_DATE <= NEXT_PAYMENT_DATE + (REMAIN_NO_PMTS_C * PMT_FREQ)
	,	The comma separates statements of a function.