Difference between revisions of "Vital Signs Internal Tables"
>Jeremyb (→LNTERMS Fields) |
>Jeremyb (→VEHCINFO Fields) |
||
| Line 821: | Line 821: | ||
== VEHCINFO Fields == | == VEHCINFO Fields == | ||
| + | |||
| + | '''LN_VI_AMOUNT_FINANCED''' | ||
| + | The amount financed for the vehicle | ||
| + | |||
| + | '''LN_VI_DEALER''' | ||
| + | The dealer where the vehicle was purchased | ||
| + | |||
| + | '''LN_VI_DEALER_CODE''' | ||
| + | The dealer's code | ||
| + | |||
| + | '''LN_VI_LICENSE_NUM''' | ||
| + | The vehicle license number | ||
| + | |||
| + | '''LN_VI_PAID_FEE_AMOUNT''' | ||
| + | |||
| + | '''LN_VI_PURCHASE_ORDER''' | ||
| + | |||
| + | '''LN_VI_SEQUENCE_NBR''' | ||
| + | The sequence number | ||
| + | |||
| + | '''LN_VI_STATE''' | ||
| + | The State that the vehicle is registered in | ||
| + | |||
| + | '''LN_VI_TITLE_NUM''' | ||
| + | |||
| + | '''LN_VI_TITLE_RECIP''' | ||
| + | |||
| + | '''LN_VI_TTL_EXPECT_DATE''' | ||
| + | |||
| + | '''LN_VI_TTL_RECVD_DATE''' | ||
| + | |||
| + | '''LN_VI_TTL_RELSD_DATE''' | ||
| + | |||
| + | '''LN_VI_VEHL_MAKE''' | ||
| + | The make of the vehicle | ||
| + | |||
| + | '''LN_VI_VEHL_MODEL''' | ||
| + | The model of the vehicle | ||
| + | |||
| + | '''LN_VI_VEHL_RETAIL''' | ||
| + | The retail value of the vehicle | ||
| + | |||
| + | '''LN_VI_VEHL_VALUE''' | ||
| + | The value of the vehicle | ||
| + | |||
| + | '''LN_VI_VEHL_YEAR''' | ||
| + | |||
| + | '''LN_VI_VI_APP_KEY''' | ||
| + | |||
| + | '''LN_VI_VIN_NUMBER''' | ||
| + | The vehicle identification number | ||
| + | |||
| + | '''LN_VI_VIN_SUB_NUMBER''' | ||
Revision as of 20:26, 4 September 2012
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
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
LNTERMS_ACCOUNT
The loan account number
LNTERMS_ACTION
The loan action
LNTERMS_ALT_AMOUNT
LNTERMS_ALT_NUMBER
LNTERMS_ALT_START_DATE
LNTERMS_AMOUNT
The loan amount
LNTERMS_APP_KEY
The loan application key
LNTERMS_APR
The loan apr
LNTERMS_AUTO_CALC_INT
LNTERMS_BALLOON_PYMT_DATE
The loan balloon payment date
LNTERMS_CASH_APR
LNTERMS_CENSUS_TRACT
LNTERMS_COLLATERAL
The loan collateral
LNTERMS_DESCRIPTION
The loan description
LNTERMS_DIS_INSUR_AMT
LNTERMS_DISBURSAL_DATE
LNTERMS_DISCLOSURE_CODE
LNTERMS_DRAFT_ACCT
LNTERMS_DUE_DATE
LNTERMS_ENTRY_DATE
The loan open date
LNTERMS_FINAL_ADV_DATE
LNTERMS_FIRST_RT_CHG_DATE
The date of the first rate change for the loan
LNTERMS_FREQUENCY
LNTERMS_FULLY_INDEXED_RATE
LNTERMS_GROUP
LNTERMS_HOLDER
LNTERMS_INSUR_CODES
LNTERMS_ITEMIZATION
LNTERMS_KTFR_ACCT
LNTERMS_KTFR_SUFFIX
LNTERMS_LAST_LT_NUMBER
LNTERMS_LAST_NUMBER
LNTERMS_LAST_SSN
LNTERMS_LIFE_INSUR_AMT
LNTERMS_LOAN_TYPE
The loan type
LNTERMS_MARGIN_SECURITY
LNTERMS_METHOD
LNTERMS_MICR_NUMBER
LNTERMS_NONDISCNT_APR
LNTERMS_NOTE
LNTERMS_NUMBER
LNTERMS_OLD_CREDIT_LIM
The old credit limit for the loan
LNTERMS_PLEDGE_AMOUNT
LNTERMS_PLEDGE_CODE
LNTERMS_PMT_AMOUNT
LNTERMS_PRCNT_DOWN
LNTERMS_PRODUCT_CODE
The loan product code
LNTERMS_PURPOSE
LNTERMS_RECORDER
The loan recorder
LNTERMS_REF_SUFFIX_1
LNTERMS_REF_SUFFIX_2
LNTERMS_REF_SUFFIX_3
LNTERMS_REQUEST_AMOUNT
LNTERMS_REVIEW_DATE
LNTERMS_SELLER
The seller of the loan
LNTERMS_SKIP_CODE
LNTERMS_SMSA
LNTERMS_SUBS_CHANGE
LNTERMS_SUFFIX
The loan suffix
LNTERMS_TERM
The loan term
LNTERMS_TOT_FIN_CHARGE
LNTERMS_TOT_OF_PAYMENTS
LNTERMS_TRANSACTION_TYPE
LNTERMS_VRL_CODE
LNTERMS_VRL_FREQ
LNTERMS_VRL_INDEX
LNTERMS_VRL_MARGIN
LNTERMS_X_PLDGE_ACCT
LNTERMS_X_PLDGE_SUFFIX
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
LN_VI_AMOUNT_FINANCED
The amount financed for the vehicle
LN_VI_DEALER
The dealer where the vehicle was purchased
LN_VI_DEALER_CODE
The dealer's code
LN_VI_LICENSE_NUM
The vehicle license number
LN_VI_PAID_FEE_AMOUNT
LN_VI_PURCHASE_ORDER
LN_VI_SEQUENCE_NBR
The sequence number
LN_VI_STATE
The State that the vehicle is registered in
LN_VI_TITLE_NUM
LN_VI_TITLE_RECIP
LN_VI_TTL_EXPECT_DATE
LN_VI_TTL_RECVD_DATE
LN_VI_TTL_RELSD_DATE
LN_VI_VEHL_MAKE
The make of the vehicle
LN_VI_VEHL_MODEL
The model of the vehicle
LN_VI_VEHL_RETAIL
The retail value of the vehicle
LN_VI_VEHL_VALUE
The value of the vehicle
LN_VI_VEHL_YEAR
LN_VI_VI_APP_KEY
LN_VI_VIN_NUMBER
The vehicle identification number
LN_VI_VIN_SUB_NUMBER
