<LOANINTERESTRATERECORD> - Sub Element of <LOAN>

Attribute Type Size REQ Default Comments
InterestType Numeric 1 Yes None 0 = Normal Interest Type
1 = Post Maturity Interest Type
2 = Default Interest while in default
3 = Default Interest until Maturity
7 = Introductory Rate
DefaultInterestPeriod String 2 No NA This is the default interest period if the InterestType is set to 2 or 3.
NA = Not Applicable
DA = Days
WE = Weekly
BW = Bi-Weekly
SM = Semi-Monthly
S4 = Semi-Monthly (14-day)
MO = Monthly
BM = Bi-Monthly
QU = Quarterly
SA = Semi-Annually
AN = Annual
DefaultInterestDays Numeric 5 No   Number of days of grace from the due date of the oldest payment or number of periods.
StepType Numeric 1 No   0 = N/A
1 = Step by Days
2 = Step by Amount
StepDaysFrom Numeric 5 No   Valid if StepType = 1. This is the day that the step is activated from the origination date of the loan.
MIN VALUE = 1
MAX VALUE = 99,999
StepDaysTo Numeric 5 No   Valid if StepType = 1.
MIN VALUE = 1
MAX VALUE = 99,999
Must be greater than StepDaysFrom
StepAmountFrom Numeric 16,2 No   Valid if StepType = 2
StepAmountTo Numeric 16,2 No   Valid if StepType = 2. Must be greater than StepAmountFrom
IntroRateExpireDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
Only applicable if InterestType = 7
BaseRateName String 25 No   If empty, no base rate will be used. Otherwise, must be a valid BaseRateName
SpreadNo
SpreadName 		Numeric
String		   No    
BaseRateAdjuster or Spread Numeric 13,8 No   Valid only if this is a Variable Rate (Variable Rate is when BaseRateName is not empty).
Use AdditionalAdjustments when making adjustments to the base interest rate when a base rate spread is not used.
SpreadBasis Numeric 1 No   0 = Current Principal
1 = Loan Amount
2 = Credit Line
AdditionalAdjustments Numeric 13,8 No   Used to make ± adjustment to the base interest rate.
InterestRate Numeric 13,8 No   This is the interest rate if this particular step is fixed interest or we are in a default or post maturity interest period.
MIN VALUE = 0.00000
MAX VALUE = 9999.99999
InitialRateChangeType Numeric 1 No 0 0 = No Change
1 = Relative From Origination Date
4 = Fixed Date
InitialRateChangePeriod String 2 No   DA = Days
WE = Weekly
BW = Bi-Weekly
SM = Semi-Monthly
S4 = Semi-Monthly (14-day)
28 = 28 Day
MO = Monthly
BM = Bi-Monthly
QU = Quarterly
SA = Semi-Annually
AN = Annual
InitialRateChangeNumberofPeriods Numeric   No    
InitialRateChangeDayValue Numeric   No    
InitialRateChangeDayValueFlag Numeric 1 No 0 0 = N/A
1 = Force Negative
2 = Force Positive
3 = Force Neutral
InitialRateChangeDate Date 10 No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
Valid only if InitialRateChangeType = 4
SubsequentRateChangeType Numeric 1 No 0 0 = No Change
1 = Relative From Origination Date
4 = Fixed Date
5 = Relative From Initial Rate Change
SubsequentRateChangePeriod String 2 No   DA = Days
WE = Weekly
BW = Bi-Weekly
SM = Semi-Monthly
S4 = Semi-Monthly (14-day)
28 = 28 Day
MO = Monthly
BM = Bi-Monthly
QU = Quarterly
SA = Semi-Annually
AN = Annual
SubsequentRateChangeNumberofPeriods Numeric   No    
SubsequentRateChangeDayValue Numeric   No    
SubsequentRateChangeDayValueFlag Numeric 1 No 0 0 = N/A
1 = Force Negative
2 = Force Positive
3 = Force Neutral
SubsequentRateChangeDate Date 10 No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
PegInterestType Numeric   No   Valid only if Variable Rate
0 = N/A
1 = Days
2 = Expression
PegInterestDays Numeric   No   Valid only if Variable Rate and PegInterestType = 1. Days Prior to change to peg interest rate. If value = 0, this assumes that interest pegging is disabled as far as interest days is concerned.
PegInterestExpression1 Numeric   No   Valid only if Variable Rate and PegInterestType = 2
0 = N/A
1 = First
2 = Second
3 = Third
4 = Fourth
5 = Last
If this value = 0, then PegInterestExpression2 & PegInterestExpression3 should be 0
PegInterestExpression2 Numeric   No   Valid only if Variable Rate and PegInterestType = 2
0 = N/A
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday
PegInterestExpression3 Numeric   No   Valid only if Variable Rate and PegInterestType = 2
0 = N/A
1 = Previous Month
2 = Previous Period
3 = Previous Calendar Quarter
RateChangeNotice Numeric   No   The ID number of the document template to be used as configured in Setup > System > Document Templates in NLS. Use 0 when no document is to be generated.
RateChangeNoticeCutoff Numeric   No   This is the number of days prior to the change date that the notice will be sent. This value must be a negative number. If the value in this field is set to 0, the notice is sent the day the change happens.
RoundFactor5.35+
Numeric 13,8 No 0 Valid only if this is a Variable Rate (Variable Rate is when BaseRateName is not empty).
MIN VALUE = 0.00000
MAX VALUE = 1.00000
RoundMethod5.35+
Numeric 1 No 0 Valid only if this is a Variable Rate (Variable Rate is when BaseRateName is not empty).
0 = <NONE>
1 = Up
2 = Down
3 = Nearest Factor
FloorRate Numeric 13,8 No   This is the floor rate. The interest can never go below this rate. FloorRate must always be lower than CapRate.
MIN VALUE = 0.00
MAX VALUE = 9999.99999
CapRate Numeric 13,8 No   This is the cap rate. The interest can never go above this rate. This field must always be greater than FloorRate.
MIN VALUE = 0
MAX VALUE = 9999.99999
MaximumChangePerAdjustment Numeric 13,8 No   MIN VALUE = 0
MAX VALUE = 9999.99999
MaximumChangePerYear Numeric 13,8 No   MIN VALUE = 0
MAX VALUE = 9999.99999
MaximumChangePerLife Numeric 13,8 No   MIN VALUE = 0
MAX VALUE = 9999.99999
MinimumChange Numeric 13,8 No   This is the minimum change in rate before the loan is changed. If this change is not covered, the rate will remain as is until the base rate change is greater than the minimum change.
MIN VALUE = 0
MAX VALUE = 9999.999999
MinimumInterestChargeMethod Numeric   No   This is the method of charging a minimum interest amount.
0 = N/A
1 = Number of days
2 = Fixed Amount
3 = Percentage of Principal

If value = 0
Min_interest_charge_days = 0
Min_interest_charge_dollar = 0
Min_interest_charge_percent = 0

If value = 1
Min_interest_charge_dollar = 0
Min_interest_charge_percent = 0

If value = 2
Min_interest_charge_days = 0
Min_interest_charge_percent = 0

If value = 3
Min_interest_charge_days = 0
Min_interest_charge_dollar = 0
MinimumInterestChargeDays Numeric   No   Number of days interest to charge as a minimum.
MIN VALUE = 0
MAX VALUE = 99,999
MinimumInterestChargeDollar Numeric 16,2 No    
MinimumInterestChargePercent Numeric   No   MIN VALUE = 0
MAX VALUE = 9999.99999
StreamNumber Numeric   No   0 = Default
1 = This Interest Rate belongs to deferred interest
StreamDestination Numeric   No   Valid only if StreamNumber = 1
0 = Current Interest
1 = Deferred Interest
CompoundType Numeric 1 No   0 = None
1 = Periodic Compounding
2 = Compounding When Past Due
3 = Compounding Past Due
CompoundPeriod String   No   DA = Days
WE = Weekly
BW = Bi-Weekly
SM = Semi-Monthly
S4 = Semi-Monthly (14-day)
28 = 28 Day
MO = Monthly
BM = Bi-Monthly
QU = Quarterly
SA = Semi-Annually
AN = Annual
CompoundNumberOfPeriods Numeric   No   Valid only if CompoundType = 1
CompoundFirstDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
Valid only if CompoundType = 1
CompoundFirstDateDayValue Numeric   No   Valid only if CompoundType = 1
EffectiveDate Date   No   MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
This effective date attribute is used during update operations and is ignored during an add operation.
Operation String     ADD ADD - All rows belonging to the same InterestType will be replaced with the new record
UPDATE - InterestType is required and is used to find the matching record
DELETE - InterestType is required and is used to find the matching record
TierRateName String 25 No   If empty, no tiered rate will be used. Otherwise, must be a valid TierRateName