Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: LNS.LNS_TERMS#

Object Details
Object Name: LNS_TERMS#
Object Type: VIEW
Owner: LNS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TERM_ID NUMBER (15) Yes
LOAN_ID NUMBER (15) Yes
DAY_COUNT_METHOD VARCHAR2 (50) Yes
BASED_ON_BALANCE VARCHAR2 (30) Yes
FIRST_RATE_CHANGE_DATE DATE

NEXT_RATE_CHANGE_DATE DATE

PERCENT_INCREASE NUMBER

PERCENT_INCREASE_TERM VARCHAR2 (30)
PERCENT_INCREASE_LIFE NUMBER

FIRST_PERCENT_INCREASE NUMBER

OPEN_PERCENT_INCREASE NUMBER

OPEN_PERCENT_INCREASE_LIFE NUMBER

OPEN_FIRST_PERCENT_INCREASE NUMBER

PAYMENT_APPLICATION_ORDER VARCHAR2 (30)
PMT_APPL_ORDER_SCOPE VARCHAR2 (30)
PREPAY_PENALTY_FLAG VARCHAR2 (1)
PREPAY_PENALTY_DATE DATE

DELINQUENCY_THRESHOLD_NUMBER NUMBER

DELINQUENCY_THRESHOLD_AMOUNT NUMBER

CALCULATION_METHOD VARCHAR2 (30) Yes
REAMORTIZE_OVER_PAYMENT VARCHAR2 (1)
REAMORTIZE_UNDER_PAYMENT VARCHAR2 (1)
REAMORTIZE_WITH_INTEREST VARCHAR2 (1)
INTEREST_COMPOUNDING_FREQ VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER
Yes
AMORTIZATION_FREQUENCY VARCHAR2 (30) Yes
NUMBER_GRACE_DAYS NUMBER

RATE_TYPE VARCHAR2 (30)
CEILING_RATE NUMBER

FLOOR_RATE NUMBER

OPEN_CEILING_RATE NUMBER

OPEN_FLOOR_RATE NUMBER

INDEX_RATE_ID NUMBER (15)
INDEX_NAME VARCHAR2 (50)
LOAN_PAYMENT_FREQUENCY VARCHAR2 (30)
ADJUSTMENT_FREQUENCY NUMBER

ADJUSTMENT_FREQUENCY_TYPE VARCHAR2 (30)
FIXED_RATE_PERIOD NUMBER

FIXED_RATE_PERIOD_TYPE VARCHAR2 (30)
FIRST_PAYMENT_DATE DATE

NEXT_PAYMENT_DUE_DATE DATE

OPEN_FIRST_PAYMENT_DATE DATE

OPEN_PAYMENT_FREQUENCY VARCHAR2 (30)
OPEN_NEXT_PAYMENT_DATE DATE

LOCK_IN_DATE DATE

LOCK_TO_DATE DATE

RATE_CHANGE_FREQUENCY VARCHAR2 (30)
OPEN_INDEX_DATE DATE

TERM_INDEX_DATE DATE

OPEN_PROJECTED_RATE NUMBER

TERM_PROJECTED_RATE NUMBER

PAYMENT_CALC_METHOD VARCHAR2 (30)
ORIG_PAY_CALC_METHOD VARCHAR2 (30)
CUSTOM_CALC_METHOD VARCHAR2 (30)
PRIN_FIRST_PAY_DATE DATE

PRIN_PAYMENT_FREQUENCY VARCHAR2 (30)
PENAL_INT_RATE NUMBER

PENAL_INT_GRACE_DAYS NUMBER

CALC_ADD_INT_UNPAID_PRIN VARCHAR2 (1)
CALC_ADD_INT_UNPAID_INT VARCHAR2 (1)
REAMORTIZE_ON_FUNDING VARCHAR2 (30)
DEFAULT_THRESHOLD_AMOUNT NUMBER

CUSTOM_SCHED_DESC VARCHAR2 (100)
CAPITALIZE_INT VARCHAR2 (1)
CALC_EARLY_PAY_CR VARCHAR2 (1)
FLUCTUATE_EQ_PAY_AMOUNT VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

LNS.LNS_TERMS# references the following:

SchemaLNS
TableLNS_TERMS
LNS.LNS_TERMS# is referenced by following:

SchemaAPPS
SynonymLNS_TERMS