>Jeremyb: Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' Member Level Fields '''SH''' Share Level Fields '''LN''' ..."

2012-09-04T20:39:56Z

Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' Member Level Fields '''SH''' Share Level Fields '''LN''' ..."

New page

== Overview ==

The definitions of the Tables and Fields available in Vital Signs

== Tables ==
'''MBR'''
Member Level Fields

'''SH'''
Share Level Fields

'''LN'''
Loan Level Fields

'''LNADDM'''
Loan Addendum Fields

'''LNAPP'''
Loanapp Fields (Spectrum Core Lender)

'''LNTERMS'''
Loan Terms Fields

'''DLRINFO'''
Dealer Info Fields

'''VEHCINFO'''
Vehicle Info Fields

== 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 ==

'''SH_CERT_MAT_DATE'''
The certificate maturity date

'''SH_CERT_MAT_DATE_MTH'''
The certificate maturity month

'''SH_ACC'''
The Share ACC Code

'''SH_ACCOUNT'''
The 9 digit share account number

'''SH_ACCRUED_DIV'''
The accrued dividends for the share

'''SH_ACCUM_DIVIDEND'''
The accumulated dividends for the share

'''SH_ADB_DAYS'''
The Average Daily Balance Days

'''SH_BALANCE'''
The share balance

'''SH_BRANCH'''
The current branch of the share

'''SH_CD_FLAG'''
Flag indicating if the share is a Certificate of Deposit

'''SH_CERT_ADJ_VAL_LS1'''

'''SH_CERT_DIV_REG_LS2'''

'''SH_CERT_DIV_TOT_LS3'''

'''SH_CERT_FOR_AMT_LS5'''

'''SH_CERT_MAT_DT_LS4'''
The certificate maturity date

'''SH_CERT_NUMBER_LS6'''

'''SH_CERT_ROLLOVER_DATE'''
The date the certificate rolled over to a new certificate

'''SH_CF_ADDON_CERT'''

'''SH_CF_ALL_SAVERS_CERT'''

'''SH_CF_ATM_REGD'''

'''SH_CF_AUTO_XFER'''

'''SH_CF_CERT_FLAG'''
Flag indicating the share is a certificate

'''SH_CF_DEBIT_CARD'''
Flag indicating the share has a debit card

'''SH_CF_IRA_ACCT'''
Flag indicating the share is an IRA

'''SH_CF_NO_ACTIVITY_FLAG'''
Flag indicating the share has no activity

'''SH_CF_SHARE_DRAFT_ACCT'''
Flag indicating the share is a checking account

'''SH_CF_SSN_VERIF_REQD'''
Flag indicating that a SSN number must be verified

'''SH_CHAR_OFF_REASON'''
The reason the share was charged off

'''SH_CHARGE_OFF_AMT'''
The amount the share was charged off

'''SH_CHARGE_OFF_DATE'''
The date the share became charged off

'''SH_CLOSE_DATE'''
The date the share was closed

'''SH_COLLECTOR'''
The name of the collector on this share

'''SH_COUNT'''

'''SH_DESC_ABRV'''
The share description abbreviation

'''SH_DESC_ABRV_LONGDESC'''
The long form of the share description abbreviation

'''SH_DESCRIPTION'''
The share description

'''SH_DIV_PAID_DATE'''
The last date dividends were posted to the share

'''SH_DIV_PERIOD_DAYS'''
The number of days that dividends were calculated and paid out to the share

'''SH_DIV_RATE'''
The dividend rate for the share

'''SH_DIV_WHH_AMT'''
The amount of dividends to be withheld

'''SH_DOLLAR_DAYS'''

'''SH_DRAFT_ACCT'''

'''SH_ENTRY_AMOUNT'''
The balance of the share when it was opened

'''SH_ENTRY_DATE'''
The date the share was opened

'''SH_HI_NEG_AMT'''
The largest amount negative the share has been

'''SH_INSUR_CODES'''

'''SH_IRA_FLAG'''
A flag indicating the share is an IRA

'''SH_IRA_TYPE'''
A description of the type of IRA the share is

'''SH_KITE_RESET_DATE'''

'''SH_LAST_AMOUNT'''

'''SH_LAST_CHG_DATE'''

'''SH_LAST_CODE'''

'''SH_LAST_DATE'''

'''SH_LAST_DIV_CALC'''

'''SH_LAST_DIV_PAID'''
The last dividend amount paid to the share

'''SH_LAST_NSF_DATE'''
The date the share last posted a NSF fee

'''SH_LAST_PAID_NSF'''
The date of the last paid NSF fee

'''SH_LAST_PBF_AMOUNT'''

'''SH_LAST_PBF_DATE'''

'''SH_LAST_STMT_DATE'''

'''SH_LTD_NSF_COUNTER'''

'''SH_MAT_DISP'''

'''SH_MICR_NUMBER'''
The MICR number for the share

'''SH_MONTHLY_ADB1'''
The share average daily balance for the past month

'''SH_MTD_NSF_COUNTER'''
The number of NSF fee given month to date

'''SH_MTD_PAID_NSF'''
The number of paid NSF fees month to date

'''SH_NAME'''
The member name on file for the share

'''SH_NEG_DATE'''
The date the share balance became negative

'''SH_OPEN_DATE'''
The open date of the share

'''SH_ORIG_BRANCH'''
The original branch where the share was opened

'''SH_ORIG_TERM'''

'''SH_ORIG_TERM_TYPE'''

'''SH_OWNER'''
The name of the owner of the share

'''SH_PERIOD_LOW_BAL'''

'''SH_PLEDGE_AMOUNT'''

'''SH_PREV_DESC_ABRV'''
The share previous description abreviation

'''SH_PREV_DIV_CDAYS'''

'''SH_PRIOR_DIV_RATE'''
The share prior dividend rate

'''SH_PRIOR_YTD_DIV'''
The share prior year to date total dividends

'''SH_PRIOR_YTD_FOR'''

'''SH_PTD_WTHDRAWLS'''

'''SH_PV_DIV_WHH_AMT'''

'''SH_RECORDER'''
The teller who recorded the share

'''SH_RECORDER_NAME'''
The name of the teller who recorded the share

'''SH_RECORDER_NAME_INTL'''
The initials of the teller who recorded the share

'''SH_REGD_CHECKS'''

'''SH_REGD_WTHDRAWLS'''
The number of Regd transaction this month

'''SH_RESET_DIV_DATE'''

'''SH_ROLL_ACC'''

'''SH_ROLL_AMOUNT_CHG'''

'''SH_ROLL_SDA'''

'''SH_ROLL_TERM'''

'''SH_ROLL_TERM_TYPE'''

'''SH_SELLER'''
The teller who opened the share with the member

'''SH_SELLER_NAME'''
The name of the teller who opened the share with the member

'''SH_SELLER_NAME_INTL'''
The initials of the teller who opened the share with the member

'''SH_SSN'''
The member ssn on file for the share

'''SH_SUFFIX'''
The suffix of the share

'''SH_TARGET_AMOUNT'''

'''SH_TD_PAID_NSF'''

'''SH_TIN_TYPE'''

'''SH_YTD_DIV'''
The year to date dividends paid out

'''SH_YTD_NSF_COUNTER'''
The year to date NSFs for this share

'''SH_YTD_PAID_NSF'''
The year to date paid NSF fees for this share

== 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 ==

'''LNAPP_ACTION'''
Action on Loan Application

'''LNAPP_ACTION_DATE'''
Date loan application action was modified

'''LNAPP_APP_KEY'''
The loan application key (9 digit ssn + 3 digit loan app number)

'''LNAPP_LOAN_TYPE'''
Loan Type

'''LNAPP_ORIG_BRANCH'''
Original branch of loan application

== 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'''

Vital Signs Tables and Fields - Revision history

>Jeremyb: Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' Member Level Fields '''SH''' Share Level Fields '''LN''' ..."