Vital Signs Internal Tables
Contents
Overview
The definitions of the Tables and Fields available in Vital Signs
Tables
MBR SH LN LNADDM LNAPP LNTERMS DLRINFO VEHCINFO
MBR Fields
SH Fields
LN Fields
LN_AVAIL_CREDIT
The amount of available credit for the loan
LN_NBR_LATE_PMTS_LAST_3MTHS
The number of late payments over the past 3 months
LN_ACCOUNT
The account number of the loan
LN_ACTION
The action for this loan : "O","D","3"
LN_ACTION_DATE
The date the action was changed on the loan
LN_AMOUNT
The original amount of the loan
LN_APP_LT_NUMBER
LN_APP_NUMBER
The 3 digit loan application number
LN_APP_SSN
The loan application social security number
LN_APPLY_DATE
The date the loan was applied for
LN_APR
The loan APR
LN_BALANCE
The current loan balance
LN_BALLOON_PYMT_DT
The balloon payment date of the loan
LN_BRANCH
The current branch where the loan is serviced
LN_CF_CREDIT_CARD_LOAN
Flag indicating the loan is a credit card
LN_CF_LOC_LOAN
Flag indicating the loan is a line of credit
LN_CF_NO_LATE_NOTICES
LN_CF_OFFLINE_LOAN
LN_CF_OPEN_END_FLAG
LN_CF_REAL_ESTATE_LOAN
Flag indicating the loan is for Real Estate
LN_CF_STUDENT_INFO
LN_CHAR_OFF_REASON
The reason the loan was charged off
LN_CHARGE_OFF_AMT
The amount charged off for the loan
LN_CHARGE_OFF_DATE
The date the loan was charged off
LN_CLOSE_DATE
The date the loan was closed
LN_COLL_AGENCY_CODE
LN_COLLATERAL
The 3 digit collateral number for the loan
LN_COLLATERAL_DESC
The description of the collateral for the loan
LN_COLLECTOR
The name of the collector on file for the loan
LN_COUNT
LN_CREDIT_LIM
The credit limit for the loan
LN_CREDIT_SCORE
The last beacon/credit score available for the loan
LN_CREDIT_SSN
LN_CURE_DATE
LN_CYCLE_DATE
LN_DEALER_CODE
The dealer code on file for the loan
LN_DEBT_RATIO
The last Debt to Income ratio for the member
LN_DECISION_TELLER
The teller who approved the loan
LN_DECISION_TELLER_NAME
The name of the teller who approved the loan
LN_DECISION_TELLER_NAME_INTL
The initials of the teller who approved the loan
LN_DENIAL_NOTICE
LN_DENIAL_REASON
LN_DESCRIPTION
The description of the loan
LN_DISB_CHECK
LN_DUE_DATE
The date the next loan payment is due
LN_ENTRY_AMOUNT
The amount of the loan when it was dispursed
LN_ENTRY_DATE
The date the loan was opened
LN_FIRST_PAY_DATE
The date of the first loan payment
LN_FREQUENCY
The frequency for loan payments
LN_GROUP
LN_HIGH_BALANCE
LN_HIGHEST_DELQ_AMT
The highest amount of delinquent payments for the loan
LN_HIGHEST_DELQ_DT
LN_INSUR_CODES
LN_INSUR_TERM
LN_KTFR_ACCOUNT
LN_KTFR_SUFFIX
LN_LAST_ACCT_STATUS
LN_LAST_AMOUNT
The last amount of the loan balance
LN_LAST_APR
The last APR for the loan
LN_LAST_CHG_DATE
The last date the loan was modified
LN_LAST_CODE
LN_LAST_DATE
The date of the last monetary transaction
LN_LAST_INT_DATE
The date the last interest amount was calculated
LN_LAST_MONTHS_INT
The amount of interest calculated for last month
LN_LAST_PYMT_AMT
The amount of the last loan payment
LN_LAST_PYMT_DATE
The date of the last payment
LN_LAST_RATE_CHG_DT
The date the loan rate was changed
LN_MATURITY_DATE
The maturity date of the loan
LN_METHOD
LN_MICR_NUMBER
The micr number for the loan
LN_NAME
The member name on file for the loan
LN_NEXT_YEARS_INT
The amount of interest calculated for next year
LN_OCCUR_DATE
LN_OFFICER
The loan officer assigned to the loan
LN_OFFICER_NAME
The name of the loan officer assigned to the loan
LN_OFFICER_NAME_INTL
The initials of the loan officer assigned to the loan
LN_OFFLINE_SERVICER
LN_OLC_ENTRY_DATE
LN_ORIG_BRANCH
The original branch where the loan was opened
LN_ORIGINAL_APR
The original APR of the loan
LN_OVERLIMIT_DATE
The date the credit limit was overdrawn
LN_OVRD_OFFICER
LN_PAID_OFF_DATE
The date the loan was paid off
LN_PARTIAL_PAYMENT
The last partial payment for the loan
LN_PLEDGE_AMOUNT
LN_PLEDGE_CODE
LN_PMT_HISTORY
A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history
LN_PREV_COLLAT_CODE
The previous collateral code of the loan
LN_PREV_CYCLE_DATE
LN_PREV_INT_RATE
The previous interest rate of the loan
LN_PREV_MICR_NUM
The previous micr number of the loan
LN_PRIN_PMT_AMT
LN_PRIOR_YTD_INT
The prior year to date interest paid
LN_PURPOSE
The loan purpose code
LN_PYMT_AMOUNT1
LN_PYMT_CHANGE_DT1
LN_RECORDER
The loan officer who recorded the loan
LN_RECORDER_NAME
The name of the loan officer who recorded the loan
LN_RECORDER_NAME_INTL
The initials of the loan officer who recorded the loan
LN_REST_FLAG_11
The rest-flag-11 field for the loan
LN_REST_FLAG_12
The rest-flag-12 field for the loan
LN_REVIEW_DATE
The date the loan was reviewed
LN_SECURE_UNSECURE_FLAG
Flag indicating that the loan is secured by collateral or not
LN_SELLER
The teller who sold the loan
LN_SELLER_NAME
The name of the teller who sold the loan
LN_SELLER_NAME_INTL
The initials of the teller who sold the loan
LN_STATUS
The status of the loan : (N)ew or (R)efinanced
LN_SUFFIX
The suffix of the loan
LN_TERM
The term of the loan
LN_THIRD_PARTY_KEY
LN_VAR_RATE_CODE
LN_VEHICLE_INFO_KEY
The key to link into vehicle-info
LN_VRL_INDEX
LN_VRL_MARGIN
LN_YTD_INT
The year to date interest paid on the loan
LN_NBR_LATE_PMTS
The number of late payment made on the loan
LNADDM Fields
LNAPP Fields
LNTERMS Fields
DLRINFO Fields
DLR_ADDR1
The dealer's address lines 1
DLR_ADDR2
The dealer's address lines 2
DLR_ADDR3
The dealer's address lines 3
DLR_CHECK_MIN
DLR_CITY
The city the dealer is located in
DLR_COUNTRY_CODE
The dealer's 2 digit country code
DLR_DEALER_GRADE
The grade associated with the dealer
DLR_FEE_CODE
DLR_FEE_FIXED
DLR_FEE_FLAG
DLR_FEE_MAXIMUM
DLR_NAME
The name of the dealer
DLR_PHONE
The phone number for the dealer
DLR_PTD_COUNT
DLR_PTD_FEE_AMOUNT
DLR_PTD_LOAN_AMOUNT
DLR_PY_COUNT
DLR_PY_FEE_AMOUNT
DLR_PY_LOAN_AMOUNT
DLR_RESERVE_AMT
DLR_STATE
The state the dealership is located in
DLR_TTD_COUNT
DLR_TTD_FEE_AMOUNT
DLR_TTD_LOAN_AMOUNT
DLR_YTD_COUNT
DLR_YTD_FEE_AMOUNT
DLR_YTD_LOAN_AMOUNT
DLR_ZIP
