VIEW: LNS.LNS_TERMS#

Source

View Text - Preformatted

select TERM_ID TERM_ID, LOAN_ID LOAN_ID, DAY_COUNT_METHOD DAY_COUNT_METHOD, BASED_ON_BALANCE BASED_ON_BALANCE, FIRST_RATE_CHANGE_DATE FIRST_RATE_CHANGE_DATE, NEXT_RATE_CHANGE_DATE NEXT_RATE_CHANGE_DATE, PERCENT_INCREASE PERCENT_INCREASE, PERCENT_INCREASE_TERM PERCENT_INCREASE_TERM, PERCENT_INCREASE_LIFE PERCENT_INCREASE_LIFE, FIRST_PERCENT_INCREASE FIRST_PERCENT_INCREASE, OPEN_PERCENT_INCREASE OPEN_PERCENT_INCREASE, OPEN_PERCENT_INCREASE_LIFE OPEN_PERCENT_INCREASE_LIFE, OPEN_FIRST_PERCENT_INCREASE OPEN_FIRST_PERCENT_INCREASE, PAYMENT_APPLICATION_ORDER PAYMENT_APPLICATION_ORDER, PMT_APPL_ORDER_SCOPE PMT_APPL_ORDER_SCOPE, PREPAY_PENALTY_FLAG PREPAY_PENALTY_FLAG, PREPAY_PENALTY_DATE PREPAY_PENALTY_DATE, DELINQUENCY_THRESHOLD_NUMBER DELINQUENCY_THRESHOLD_NUMBER, DELINQUENCY_THRESHOLD_AMOUNT DELINQUENCY_THRESHOLD_AMOUNT, CALCULATION_METHOD CALCULATION_METHOD, REAMORTIZE_OVER_PAYMENT REAMORTIZE_OVER_PAYMENT, REAMORTIZE_UNDER_PAYMENT REAMORTIZE_UNDER_PAYMENT, REAMORTIZE_WITH_INTEREST REAMORTIZE_WITH_INTEREST, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY, NUMBER_GRACE_DAYS NUMBER_GRACE_DAYS, RATE_TYPE RATE_TYPE, CEILING_RATE CEILING_RATE, FLOOR_RATE FLOOR_RATE, OPEN_CEILING_RATE OPEN_CEILING_RATE, OPEN_FLOOR_RATE OPEN_FLOOR_RATE, INDEX_RATE_ID INDEX_RATE_ID, INDEX_NAME INDEX_NAME, LOAN_PAYMENT_FREQUENCY LOAN_PAYMENT_FREQUENCY, ADJUSTMENT_FREQUENCY ADJUSTMENT_FREQUENCY, ADJUSTMENT_FREQUENCY_TYPE ADJUSTMENT_FREQUENCY_TYPE, FIXED_RATE_PERIOD FIXED_RATE_PERIOD, FIXED_RATE_PERIOD_TYPE FIXED_RATE_PERIOD_TYPE, FIRST_PAYMENT_DATE FIRST_PAYMENT_DATE, NEXT_PAYMENT_DUE_DATE NEXT_PAYMENT_DUE_DATE, OPEN_FIRST_PAYMENT_DATE OPEN_FIRST_PAYMENT_DATE, OPEN_PAYMENT_FREQUENCY OPEN_PAYMENT_FREQUENCY, OPEN_NEXT_PAYMENT_DATE OPEN_NEXT_PAYMENT_DATE, LOCK_IN_DATE LOCK_IN_DATE, LOCK_TO_DATE LOCK_TO_DATE, RATE_CHANGE_FREQUENCY RATE_CHANGE_FREQUENCY, OPEN_INDEX_DATE OPEN_INDEX_DATE, TERM_INDEX_DATE TERM_INDEX_DATE, OPEN_PROJECTED_RATE OPEN_PROJECTED_RATE, TERM_PROJECTED_RATE TERM_PROJECTED_RATE, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD, ORIG_PAY_CALC_METHOD ORIG_PAY_CALC_METHOD, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD, PRIN_FIRST_PAY_DATE PRIN_FIRST_PAY_DATE, PRIN_PAYMENT_FREQUENCY PRIN_PAYMENT_FREQUENCY, PENAL_INT_RATE PENAL_INT_RATE, PENAL_INT_GRACE_DAYS PENAL_INT_GRACE_DAYS, CALC_ADD_INT_UNPAID_PRIN CALC_ADD_INT_UNPAID_PRIN, CALC_ADD_INT_UNPAID_INT CALC_ADD_INT_UNPAID_INT, REAMORTIZE_ON_FUNDING REAMORTIZE_ON_FUNDING, DEFAULT_THRESHOLD_AMOUNT DEFAULT_THRESHOLD_AMOUNT, CUSTOM_SCHED_DESC CUSTOM_SCHED_DESC, CAPITALIZE_INT CAPITALIZE_INT, CALC_EARLY_PAY_CR CALC_EARLY_PAY_CR, FLUCTUATE_EQ_PAY_AMOUNT FLUCTUATE_EQ_PAY_AMOUNT from "LNS"."LNS_TERMS"

View Text - HTML Formatted

SELECT TERM_ID TERM_ID
, LOAN_ID LOAN_ID
, DAY_COUNT_METHOD DAY_COUNT_METHOD
, BASED_ON_BALANCE BASED_ON_BALANCE
, FIRST_RATE_CHANGE_DATE FIRST_RATE_CHANGE_DATE
, NEXT_RATE_CHANGE_DATE NEXT_RATE_CHANGE_DATE
, PERCENT_INCREASE PERCENT_INCREASE
, PERCENT_INCREASE_TERM PERCENT_INCREASE_TERM
, PERCENT_INCREASE_LIFE PERCENT_INCREASE_LIFE
, FIRST_PERCENT_INCREASE FIRST_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE OPEN_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE_LIFE OPEN_PERCENT_INCREASE_LIFE
, OPEN_FIRST_PERCENT_INCREASE OPEN_FIRST_PERCENT_INCREASE
, PAYMENT_APPLICATION_ORDER PAYMENT_APPLICATION_ORDER
, PMT_APPL_ORDER_SCOPE PMT_APPL_ORDER_SCOPE
, PREPAY_PENALTY_FLAG PREPAY_PENALTY_FLAG
, PREPAY_PENALTY_DATE PREPAY_PENALTY_DATE
, DELINQUENCY_THRESHOLD_NUMBER DELINQUENCY_THRESHOLD_NUMBER
, DELINQUENCY_THRESHOLD_AMOUNT DELINQUENCY_THRESHOLD_AMOUNT
, CALCULATION_METHOD CALCULATION_METHOD
, REAMORTIZE_OVER_PAYMENT REAMORTIZE_OVER_PAYMENT
, REAMORTIZE_UNDER_PAYMENT REAMORTIZE_UNDER_PAYMENT
, REAMORTIZE_WITH_INTEREST REAMORTIZE_WITH_INTEREST
, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY
, NUMBER_GRACE_DAYS NUMBER_GRACE_DAYS
, RATE_TYPE RATE_TYPE
, CEILING_RATE CEILING_RATE
, FLOOR_RATE FLOOR_RATE
, OPEN_CEILING_RATE OPEN_CEILING_RATE
, OPEN_FLOOR_RATE OPEN_FLOOR_RATE
, INDEX_RATE_ID INDEX_RATE_ID
, INDEX_NAME INDEX_NAME
, LOAN_PAYMENT_FREQUENCY LOAN_PAYMENT_FREQUENCY
, ADJUSTMENT_FREQUENCY ADJUSTMENT_FREQUENCY
, ADJUSTMENT_FREQUENCY_TYPE ADJUSTMENT_FREQUENCY_TYPE
, FIXED_RATE_PERIOD FIXED_RATE_PERIOD
, FIXED_RATE_PERIOD_TYPE FIXED_RATE_PERIOD_TYPE
, FIRST_PAYMENT_DATE FIRST_PAYMENT_DATE
, NEXT_PAYMENT_DUE_DATE NEXT_PAYMENT_DUE_DATE
, OPEN_FIRST_PAYMENT_DATE OPEN_FIRST_PAYMENT_DATE
, OPEN_PAYMENT_FREQUENCY OPEN_PAYMENT_FREQUENCY
, OPEN_NEXT_PAYMENT_DATE OPEN_NEXT_PAYMENT_DATE
, LOCK_IN_DATE LOCK_IN_DATE
, LOCK_TO_DATE LOCK_TO_DATE
, RATE_CHANGE_FREQUENCY RATE_CHANGE_FREQUENCY
, OPEN_INDEX_DATE OPEN_INDEX_DATE
, TERM_INDEX_DATE TERM_INDEX_DATE
, OPEN_PROJECTED_RATE OPEN_PROJECTED_RATE
, TERM_PROJECTED_RATE TERM_PROJECTED_RATE
, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD
, ORIG_PAY_CALC_METHOD ORIG_PAY_CALC_METHOD
, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD
, PRIN_FIRST_PAY_DATE PRIN_FIRST_PAY_DATE
, PRIN_PAYMENT_FREQUENCY PRIN_PAYMENT_FREQUENCY
, PENAL_INT_RATE PENAL_INT_RATE
, PENAL_INT_GRACE_DAYS PENAL_INT_GRACE_DAYS
, CALC_ADD_INT_UNPAID_PRIN CALC_ADD_INT_UNPAID_PRIN
, CALC_ADD_INT_UNPAID_INT CALC_ADD_INT_UNPAID_INT
, REAMORTIZE_ON_FUNDING REAMORTIZE_ON_FUNDING
, DEFAULT_THRESHOLD_AMOUNT DEFAULT_THRESHOLD_AMOUNT
, CUSTOM_SCHED_DESC CUSTOM_SCHED_DESC
, CAPITALIZE_INT CAPITALIZE_INT
, CALC_EARLY_PAY_CR CALC_EARLY_PAY_CR
, FLUCTUATE_EQ_PAY_AMOUNT FLUCTUATE_EQ_PAY_AMOUNT
FROM "LNS"."LNS_TERMS"