Vital Signs Internal Tables

From Vital Soft Wiki
Revision as of 20:21, 4 September 2012 by >Jeremyb (LNADDM Fields)
Jump to: navigation, search

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

LNADDM_ACC

LNADDM_ACCOUNT

LNADDM_ACCRUED_DIV

LNADDM_ACCUM_DIVIDEND

LNADDM_AMORT_TERM

LNADDM_AMORT_TYPE

LNADDM_AMOUNT_LAST_TRAN

LNADDM_APPRAISAL_AMOUNT

LNADDM_APPRAISAL_DATE

LNADDM_APR_LOCK_DATE

LNADDM_BUILDER

LNADDM_CO_HMDA_ETHNIC

LNADDM_CO_HMDA_RACES

LNADDM_CO_HMDA_SEX

LNADDM_COMMENT

LNADDM_COMMIT_DATE

LNADDM_CONDO_PUD_NAME

LNADDM_CONTRACTOR

LNADDM_COUNTY_CODE

LNADDM_CURR_LATE_CRG

LNADDM_CUSHION_AMOUNT

LNADDM_CUSHION_RATE

LNADDM_DEFICIENCY

LNADDM_DELQ_ADJUST_AMOUNT

LNADDM_DELQ_DATE

LNADDM_DESC_ABRV

LNADDM_DIV_PAID_DATE

LNADDM_DIV_WHH_AMT

LNADDM_DRAW_COUNT

LNADDM_DRAW_LIMIT

LNADDM_DWELLING_TYPE

LNADDM_EDA_FLAG

LNADDM_EFF_DATE_LAST_TRAN

LNADDM_ESCROW_AMT_CHG_DATE

LNADDM_ESCROW_BALANCE

   The Escrow balance

LNADDM_ESCROW_CENTS_DAYS

LNADDM_ESCROW_DUE_DATE

LNADDM_ESCROW_ENTRY_DATE

LNADDM_ESCROW_LAST_CHG_DATE

LNADDM_ESCROW_PMT_AMOUNT

LNADDM_ESCROW_PRIOR_AMOUNT

LNADDM_FED_MAX_CUSHION

LNADDM_FIN_INST_FTB_FLD

LNADDM_FIRST_RT_CHG_DATE

LNADDM_FORCLS_MIADJ_FLD

LNADDM_GROSS_ANNUAL_INCOME

LNADDM_HMDA_ETHNIC

LNADDM_HMDA_OCCUP_CODE

LNADDM_HMDA_RACES

LNADDM_HMDA_SEX

LNADDM_HOEPA_STATUS

LNADDM_IMPROVE_AMOUNT

LNADDM_INSPECTION_DATE

LNADDM_INT_ONLY_END_DATE

LNADDM_INVESTOR_ACTION_CODE

LNADDM_INVESTOR_ACTION_DATE

LNADDM_INVESTOR_LOAN_NUMBER

LNADDM_INVESTOR_PKG_KEY

LNADDM_INVESTOR_PTD_FEES

LNADDM_INVESTOR_PTD_INT

LNADDM_INVESTOR_PTD_PRINCIPAL

LNADDM_INVESTOR_PTD_PYMNTS

LNADDM_INVESTOR_STATUS

LNADDM_LAST_ANLY_DATE

LNADDM_LAST_DIV_CALC

LNADDM_LAST_DIV_PAID

LNADDM_LAST_MONETARY_AMOUNT

LNADDM_LAST_MONETARY_CODE

LNADDM_LAST_MONETARY_DATE

LNADDM_LAST_RUN_DATE

LNADDM_LIEN_STATUS

LNADDM_LOAN_FEATURE

LNADDM_MERS_NUMBER

LNADDM_MI_CERT_NUMBER

LNADDM_MI_PERCENT

LNADDM_MIN_PAYMENT

LNADDM_MISC_INSUR_AMOUNT

LNADDM_MONTH_DEBT_EXP

LNADDM_MONTH_HOUSE_EXP

LNADDM_MORT_INS_CODE

LNADDM_MORTGAGE_MARGIN

LNADDM_MORTGAGE_TYPE

LNADDM_NEXT_ANLY_DATE

LNADDM_NUMB_BORROWERS

LNADDM_NUMBER_OF_UNITS

LNADDM_ORIG_MONTHLY_PI

LNADDM_ORIGINAL_LTV

LNADDM_OTHER_FINANCING

LNADDM_OWNER_OCCUPIED

LNADDM_PAYMENT_ADJUST

LNADDM_PERCENT_DONE

LNADDM_PERIOD_LOW_BAL

LNADDM_POINTS

LNADDM_PORTION_PAID

LNADDM_PRE_APRVL_REQ

LNADDM_PREPAID_ACCRUAL

LNADDM_PREV_YEAR_INSURANCE

LNADDM_PREV_YEAR_OTHER

LNADDM_PRIOR_YTD_DIV

LNADDM_PRIOR_YTD_PMI

LNADDM_PRIOR_YTD_TAX

LNADDM_PROJECT_CLASS

LNADDM_PROJECT_DUE

LNADDM_PROPERTY_ADDR

LNADDM_PROPERTY_CITY

LNADDM_PROPERTY_STATE

LNADDM_PROPERTY_TYPE

LNADDM_PROPERTY_ZIP

LNADDM_PURCHASE_DOC

LNADDM_PURCHASER_TYPE

LNADDM_PV_DIV_WHH_AMT

LNADDM_RATE_SPREAD

LNADDM_REFUND_DATE

LNADDM_REFUND_METHOD

LNADDM_SALES_PRICE

LNADDM_SECND_LIEN_HLDR

LNADDM_SECTION_ACT

LNADDM_SHORTAGE

LNADDM_ST_CUSHION_AMT

LNADDM_ST_CUSHION_RATE

LNADDM_SUBSIDY_PMT_AMOUNT

LNADDM_SUFFIX

LNADDM_SURPLUS

LNADDM_UNDISTR_BALANCE

LNADDM_YTD_DIV

LNADDM_YTD_INSURANCE

LNADDM_YTD_OTHER

LNADDM_YTD_PMI

LNADDM_YTD_TAX

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

VEHCINFO Fields