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
MBR_ACCOUNT
The member account number
MBR_ACCT_AGE
The age of the member account
MBR_ACTIVE_LN_BAL
Count of active loans belonging to the member
MBR_ACTIVE_LN_CNT
Count of active loans belonging to the member
MBR_ACTIVE_SH_BAL
Balance of active shares belonging to the member
MBR_ACTIVE_SH_CNT
Count of active shares belonging to the member
MBR_ADDR1
The first address line
MBR_ADDR2
The second address line
MBR_ADDR3
The third address line
MBR_AFFINITY_CODE
MBR_AGE
The age of the member
MBR_AGE_AS_DECIMAL
The age of the member in decimal form
MBR_BIRTH_DATE
The member birth date
MBR_BRANCH
The current branch for the member account
MBR_CELL_PHONE
The member cell phone number
MBR_CF_ACCT_IN_COLLECT
Flag indicating the member has a loan in collections
MBR_CF_ATM_FLAG
Flag indicating the member has an ATM card
MBR_CF_BAD_ADDR
Flag indicating the member has a bad address
MBR_CF_CAPTURE_ATM_CARD
Flag indicating the member ATM card should be captured
MBR_CF_CC_ACCT
Flag indicating the member owns a credit card
MBR_CF_CHGOFF_LOAN
Flag indicating the member has a charged off loan
MBR_CF_CHGOFF_SHARE
Flag indicating the member has a charged off share
MBR_CF_DECEASED
Flag indicating the member is deceased
MBR_CF_NO_LABELS
MBR_CF_NO_MAIL
Flag indicating the member does not wish to receive mail
MBR_CF_SEND_MTHLY_STMT
Flag indicating the member receives monthly statements
MBR_CF_STMTS_TO_CU
MBR_CHG_LN_BAL
MBR_CHG_LN_CNT
MBR_CHG_SH_BAL
MBR_CHG_SH_CNT
MBR_CITIZENSHIP
The Country of Citenzenship for the member
MBR_CITY
The city of the member's account
MBR_CLASS_CODE
MBR_CLOSE_DATE
The date the member account was closed
MBR_COUNT
MBR_COUNTRY_CODE
The country 2 digit code for the member account
MBR_CREDIT_SCORE
The credit score associated with the member account
MBR_CURE_DATE
MBR_DEPARTMENT
The department associated with this member
MBR_DRIVER_LIC_NUM
The member drivers license number
MBR_DRIVER_LIC_STATE
The state where the member's drivers license was issued
MBR_E_MAIL
The member's e-mail address
MBR_ELIGIBILITY
MBR_EMPL_NUM
MBR_EMPL_STATUS
The employment status of the member
MBR_EMPLOYER_NAME
The name on file for the member employer
MBR_ESCHEAT_DATE
The escheat date for the member account
MBR_FAX_NUMBER
MBR_FINAL_CLOSE_DATE
The final date the member account was closed
MBR_FINAL_CLOSE_MTH
The month the member account was closed
MBR_FIRST_NAME
The first name of the member
MBR_FULL_NAME
The full name of the member
MBR_GROUP
MBR_HOUSEHOLD
MBR_HOUSEHOLD_CODE
MBR_LAST_CHG_DATE
The date of the last change made to the member's account
MBR_LAST_NAME
The last name of the member
MBR_LTD_BRANCH
MBR_LTD_COLLATERAL
MBR_LTD_DATE
MBR_LTD_OFFICER
MBR_MAIDEN_NAME
The maiden name of the member
MBR_MARITAL_STATUS
The marital status of the member
MBR_MIDDLE_NAME
The middle name of the member
MBR_MONTHLY_ADB1
The average daily balance for the past 1 month
MBR_MONTHLY_ADB2
The average daily balance for 2 months prior
MBR_MONTHLY_ADB3
The average daily balance for 2 months prior
MBR_NAME_CHG_DATE
The date when the member changed their name
MBR_OLC_COUNT
MBR_OLC_ENTRY_DATE
MBR_OPEN_DATE
The date the member account was opened
MBR_ORIG_BRANCH
The original branch where the member opened their account
MBR_ORIG_OPEN_DATE
The original date the member opened their account
MBR_ORIG_OPEN_MTH
The original month the member opened their account
MBR_PAGER_PHONE
The pager number for the member account
MBR_PHONE
The member's phone number
MBR_PRIOR_YTD_DIV
MBR_PRIOR_YTD_INT
MBR_PROFESSION_YEARS
The number of years the member has been in their line of work
MBR_RECORDER
The teller who opened the member account
MBR_RECORDER_NAME
The name of the teller who opened the member account
MBR_RECORDER_NAME_INTL
The initials of the teller who opened the member's account
MBR_REF
The ref field from the member-file record on a Spectrum core
MBR_REF2
The ref2 field from the member-file record on a Spectrum core
MBR_REF3
The ref3 field from the member-file record on a Spectrum core
MBR_REF4
The ref4 field from the member-file record on a Spectrum core
MBR_REFER
MBR_RELATE_FLAG
The relate flag for the member account
MBR_RESIDENCE_CODE
MBR_REST_FLAG_11
The rest-flag-11 field on a Spectrum core
MBR_REST_FLAG_12
The rest-flag-12 field on a Spectrum core
MBR_SELF_EMPLOYED
The member's self employed status
MBR_SELLER
The teller who opened the member account
MBR_SELLER_NAME
The name of the teller who opened the member account
MBR_SELLER_NAME_INTL
The initials of the teller who opened the member account
MBR_SEX
The sex of the member
MBR_SSN_NUM
The member's Social Security Number
MBR_STATE
The state on file for the member account
MBR_TOTAL_LN_BAL
The balance of all loans for a member account
MBR_TOTAL_LN_CNT
The count of all loans for a member account
MBR_TOTAL_SH_BAL
The balance of all shares for a member account
MBR_TOTAL_SH_CNT
The count of all shares for a member account
MBR_UNIQUE_ID
The unique id for each member in Vital Signs
MBR_WORK_PHONE
The member's work phone
MBR_YTD_INT
The year to date interest for the member account
MBR_ZIP
The zip code on file for the member account
MBR ZIP+4
The member's full zipcode including the last 4 digits
MBR_SSN_FMT
The member's formatted SSN xxx-xx-xxxx
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
