Difference between revisions of "Membership Analysis Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(→‎Share Level)
>Johno
(→‎Member Level)
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
'''The fields available for use in Document Distribution from the Membership Analysis Application'''
 
'''The fields available for use in Document Distribution from the Membership Analysis Application'''
 +
 +
== Dealer Info ==
 +
 +
'''DLR_ADDR1'''
 +
    The dealer's address lines 1
 +
    ''Note : not available by default''
 +
 +
'''DLR_ADDR2'''
 +
    The dealer's address lines 2
 +
    ''Note : not available by default''
 +
 +
'''DLR_ADDR3'''
 +
    The dealer's address lines 3
 +
    ''Note : not available by default''
 +
 +
'''DLR_CHECK_MIN'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_CITY'''
 +
    The city the dealer is located in
 +
    ''Note : not available by default''
 +
 +
'''DLR_COUNTRY_CODE'''
 +
    The dealer's 2 digit country code
 +
    ''Note : not available by default''
 +
 +
'''DLR_DEALER_GRADE'''
 +
  The grade associated with the dealer
 +
 +
'''DLR_FEE_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_FEE_FIXED'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_FEE_FLAG'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_FEE_MAXIMUM'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_NAME'''
 +
    The name of the dealer
 +
 +
'''DLR_PHONE'''
 +
    The phone number for the dealer
 +
    ''Note : not available by default''
 +
 +
'''DLR_PTD_COUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_PTD_FEE_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_PTD_LOAN_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_PY_COUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_PY_FEE_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_PY_LOAN_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_RESERVE_AMT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_STATE'''
 +
    The state the dealership is located in
 +
    ''Note : not available by default''
 +
 +
'''DLR_TTD_COUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_TTD_FEE_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_TTD_LOAN_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_YTD_COUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_YTD_FEE_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_YTD_LOAN_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''DLR_ZIP'''
 +
    ''Note : not available by default''
 +
 +
 +
== Loan Level ==
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_AMOUNT'''
 +
    The original amount of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_APP_LT_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LN_APP_NUMBER'''
 +
    The 3 digit loan application number
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_APP_SSN'''
 +
    The loan application social security number
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_APPLY_DATE'''
 +
    The date the loan was applied for
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_APR'''
 +
    The loan APR
 +
 +
'''LN_BALANCE'''
 +
    The current loan balance
 +
 +
'''LN_BALLOON_PYMT_DT'''
 +
    The balloon payment date of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_BRANCH'''
 +
    The current branch where the loan is serviced
 +
 +
'''LN_CF_CREDIT_CARD_LOAN'''
 +
    Flag indicating the loan is a credit card
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_CF_LOC_LOAN'''
 +
    Flag indicating the loan is a line of credit
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_CF_NO_LATE_NOTICES'''
 +
    ''Note: not available by default''
 +
 +
'''LN_CF_OFFLINE_LOAN'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_CF_OPEN_END_FLAG'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_CF_REAL_ESTATE_LOAN'''
 +
    Flag indicating the loan is for Real Estate
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_CF_STUDENT_INFO'''
 +
    ''Note: not available in Membership Summary by default''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''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'''
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''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'''
 +
    ''Note: not available in Membership Summary by default''
 +
   
 +
'''LN_CURE_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LN_CYCLE_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LN_DEALER_CODE'''
 +
    The dealer code on file for the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_DEBT_RATIO'''
 +
    The last Debt to Income ratio for the member
 +
    ''Note: not available by default''
 +
 +
'''LN_DECISION_TELLER'''
 +
    The teller who approved the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_DECISION_TELLER_NAME'''
 +
    The name of the teller who approved the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_DECISION_TELLER_NAME_INTL'''
 +
    The initials of the teller who approved the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_DENIAL_NOTICE'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_DENIAL_REASON'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_DESCRIPTION'''
 +
    The description of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_DISB_CHECK'''
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_FREQUENCY'''
 +
    The frequency for loan payments
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_GROUP'''
 +
    ''Note: not available by default''
 +
 +
'''LN_HIGH_BALANCE'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_HIGHEST_DELQ_AMT'''
 +
    The highest amount of delinquent payments for the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_HIGHEST_DELQ_DT'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_INSUR_CODES'''
 +
    ''Note: not available by default''
 +
 +
'''LN_INSUR_TERM'''
 +
    ''Note: not available by default''
 +
 +
'''LN_KTFR_ACCOUNT'''
 +
    ''Note: not available by default''
 +
 +
'''LN_KTFR_SUFFIX'''
 +
    ''Note: not available by default''
 +
 +
'''LN_LAST_ACCT_STATUS'''
 +
    ''Note: not available by default''
 +
 +
'''LN_LAST_AMOUNT'''
 +
    The last amount of the loan balance
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_LAST_APR'''
 +
    The last APR for the loan
 +
 +
'''LN_LAST_CHG_DATE'''
 +
    The last date the loan was modified
 +
 +
'''LN_LAST_CODE'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_LAST_DATE'''
 +
    The date of the last monetary transaction
 +
 +
'''LN_LAST_INT_DATE'''
 +
    The date the last interest amount was calculated
 +
    ''Note: not available by default''
 +
 +
'''LN_LAST_MONTHS_INT'''
 +
    The amount of interest calculated for last month
 +
    ''Note: not available by default''
 +
 +
'''LN_LAST_PYMT_AMT'''
 +
    The amount of the last loan payment
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_LAST_PYMT_DATE'''
 +
    The date of the last payment
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_LAST_RATE_CHG_DT'''
 +
    The date the loan rate was changed
 +
    ''Note: not available by default''
 +
 +
'''LN_MATURITY_DATE'''
 +
    The maturity date of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_METHOD'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_MICR_NUMBER'''
 +
    The micr number for the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_NAME'''
 +
    The member name on file for the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_NEXT_YEARS_INT'''
 +
    The amount of interest calculated for next year
 +
    ''Note: not available by default''
 +
 +
'''LN_OCCUR_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LN_OFFICER'''
 +
    The loan officer assigned to the loan
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available by default''
 +
 +
'''LN_OFFLINE_SERVICER'''
 +
    ''Note: not available by default''
 +
 +
'''LN_OLC_ENTRY_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LN_ORIG_BRANCH'''
 +
    The original branch where the loan was opened
 +
 +
'''LN_ORIGINAL_APR'''
 +
    The original APR of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_OVERLIMIT_DATE'''
 +
    The date the credit limit was overdrawn
 +
    ''Note: not available by default''
 +
 +
'''LN_OVRD_OFFICER'''
 +
    ''Note: not available by default''
 +
 +
'''LN_PAID_OFF_DATE'''
 +
    The date the loan was paid off
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PARTIAL_PAYMENT'''
 +
    The last partial payment for the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PLEDGE_AMOUNT'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PLEDGE_CODE'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PMT_HISTORY'''
 +
    A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PREV_COLLAT_CODE'''
 +
    The previous collateral code of the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_PREV_CYCLE_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LN_PREV_INT_RATE'''
 +
    The previous interest rate of the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_PREV_MICR_NUM'''
 +
    The previous micr number of the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_PRIN_PMT_AMT'''
 +
    ''Note: not available by default''
 +
 +
'''LN_PRIOR_YTD_INT'''
 +
    The prior year to date interest paid
 +
    ''Note: not available by default''
 +
 +
'''LN_PURPOSE'''
 +
    The loan purpose code
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_PYMT_AMOUNT1'''
 +
    ''Note: not available by default''
 +
 +
'''LN_PYMT_CHANGE_DT1'''
 +
    ''Note: not available by default''
 +
 +
'''LN_RECORDER'''
 +
    The loan officer who recorded the loan
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_REST_FLAG_11'''
 +
    The rest-flag-11 field for the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_REST_FLAG_12'''
 +
    The rest-flag-12 field for the loan
 +
    ''Note: not available by default''
 +
 +
'''LN_REVIEW_DATE'''
 +
    The date the loan was reviewed
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_SECURE_UNSECURE_FLAG'''
 +
    Flag indicating that the loan is secured by collateral or not
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_SELLER'''
 +
    The teller who sold the loan
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available by default''
 +
 +
'''LN_STATUS'''
 +
    The status of the loan : (N)ew or (R)efinanced
 +
    ''Note: not available by default''
 +
 +
'''LN_SUFFIX'''
 +
    The suffix of the loan
 +
 +
'''LN_TERM'''
 +
    The term of the loan
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_THIRD_PARTY_KEY'''
 +
    ''Note: not available by default''
 +
 +
'''LN_VAR_RATE_CODE'''
 +
    ''Note: not available in Membership Summary by default''
 +
 +
'''LN_VEHICLE_INFO_KEY'''
 +
    The key to link into vehicle-info
 +
 +
'''LN_VRL_INDEX'''
 +
    ''Note: not available by default''
 +
 +
'''LN_VRL_MARGIN'''
 +
    ''Note: not available by default''
 +
 +
'''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
 +
    ''Note: not available in Membership Summary by default''
 +
 +
==Loan Addendum==
 +
 +
'''LNADDM_ACC'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ACCOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ACCRUED_DIV'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ACCUM_DIVIDEND'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_AMORT_TERM'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_AMORT_TYPE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_AMOUNT_LAST_TRAN'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_APPRAISAL_AMOUNT'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_APPRAISAL_DATE'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_APR_LOCK_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_BUILDER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CO_HMDA_ETHNIC'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CO_HMDA_RACES'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CO_HMDA_SEX'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_COMMENT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_COMMIT_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CONDO_PUD_NAME'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CONTRACTOR'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_COUNTY_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CURR_LATE_CRG'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CUSHION_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_CUSHION_RATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DEFICIENCY'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DELQ_ADJUST_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DELQ_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DESC_ABRV'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DIV_PAID_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DIV_WHH_AMT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DRAW_COUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DRAW_LIMIT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_DWELLING_TYPE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_EDA_FLAG'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_EFF_DATE_LAST_TRAN'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_AMT_CHG_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_BALANCE'''
 +
    The Escrow balance
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_ESCROW_CENTS_DAYS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_DUE_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_ENTRY_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_LAST_CHG_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_PMT_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ESCROW_PRIOR_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_FED_MAX_CUSHION'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_FIN_INST_FTB_FLD'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_FIRST_RT_CHG_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_FORCLS_MIADJ_FLD'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_GROSS_ANNUAL_INCOME'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_HMDA_ETHNIC'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_HMDA_OCCUP_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_HMDA_RACES'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_HMDA_SEX'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_HOEPA_STATUS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_IMPROVE_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INSPECTION_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INT_ONLY_END_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_ACTION_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_ACTION_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_LOAN_NUMBER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_PKG_KEY'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_PTD_FEES'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_PTD_INT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_PTD_PRINCIPAL'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_PTD_PYMNTS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_INVESTOR_STATUS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_ANLY_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_DIV_CALC'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_DIV_PAID'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_MONETARY_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_MONETARY_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_MONETARY_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LAST_RUN_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LIEN_STATUS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_LOAN_FEATURE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MERS_NUMBER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MI_CERT_NUMBER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MI_PERCENT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MIN_PAYMENT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MISC_INSUR_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MONTH_DEBT_EXP'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MONTH_HOUSE_EXP'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MORT_INS_CODE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MORTGAGE_MARGIN'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_MORTGAGE_TYPE'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_NEXT_ANLY_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_NUMB_BORROWERS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_NUMBER_OF_UNITS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ORIG_MONTHLY_PI'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ORIGINAL_LTV'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_OTHER_FINANCING'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_OWNER_OCCUPIED'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PAYMENT_ADJUST'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PERCENT_DONE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PERIOD_LOW_BAL'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_POINTS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PORTION_PAID'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PRE_APRVL_REQ'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PREPAID_ACCRUAL'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PREV_YEAR_INSURANCE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PREV_YEAR_OTHER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PRIOR_YTD_DIV'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PRIOR_YTD_PMI'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PRIOR_YTD_TAX'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PROJECT_CLASS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PROJECT_DUE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PROPERTY_ADDR'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_PROPERTY_CITY'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_PROPERTY_STATE'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_PROPERTY_TYPE'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_PROPERTY_ZIP'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LNADDM_PURCHASE_DOC'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PURCHASER_TYPE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_PV_DIV_WHH_AMT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_RATE_SPREAD'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_REFUND_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_REFUND_METHOD'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SALES_PRICE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SECND_LIEN_HLDR'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SECTION_ACT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SHORTAGE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ST_CUSHION_AMT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_ST_CUSHION_RATE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SUBSIDY_PMT_AMOUNT'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SUFFIX'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_SURPLUS'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_UNDISTR_BALANCE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_YTD_DIV'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_YTD_INSURANCE'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_YTD_OTHER'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_YTD_PMI'''
 +
    ''Note : not available by default''
 +
 +
'''LNADDM_YTD_TAX'''
 +
    ''Note : not available by default''
 +
 +
==Loan Terms==
 +
 +
'''LNTERMS_ACCOUNT'''
 +
    The loan account number
 +
 +
'''LNTERMS_ACTION'''
 +
    The loan action
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_ALT_AMOUNT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_ALT_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_ALT_START_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_AMOUNT'''
 +
    The loan amount
 +
 +
'''LNTERMS_APP_KEY'''
 +
    The loan application key
 +
 +
'''LNTERMS_APR'''
 +
    The loan apr
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_AUTO_CALC_INT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_BALLOON_PYMT_DATE'''
 +
    The loan balloon payment date
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_CASH_APR'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_CENSUS_TRACT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_COLLATERAL'''
 +
    The loan collateral
 +
 +
'''LNTERMS_DESCRIPTION'''
 +
    The loan description
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_DIS_INSUR_AMT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_DISBURSAL_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_DISCLOSURE_CODE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_DRAFT_ACCT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_DUE_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_ENTRY_DATE'''
 +
    The loan open date
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_FINAL_ADV_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_FIRST_RT_CHG_DATE'''
 +
    The date of the first rate change for the loan
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_FREQUENCY'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_FULLY_INDEXED_RATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_GROUP'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_HOLDER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_INSUR_CODES'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_ITEMIZATION'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_KTFR_ACCT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_KTFR_SUFFIX'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_LAST_LT_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_LAST_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_LAST_SSN'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_LIFE_INSUR_AMT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_LOAN_TYPE'''
 +
    The loan type
 +
 +
'''LNTERMS_MARGIN_SECURITY'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_METHOD'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_MICR_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_NONDISCNT_APR'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_NOTE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_NUMBER'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_OLD_CREDIT_LIM'''
 +
    The old credit limit for the loan
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_PLEDGE_AMOUNT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_PLEDGE_CODE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_PMT_AMOUNT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_PRCNT_DOWN'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_PRODUCT_CODE'''
 +
    The loan product code
 +
 +
'''LNTERMS_PURPOSE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_RECORDER'''
 +
    The loan recorder
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_REF_SUFFIX_1'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_REF_SUFFIX_2'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_REF_SUFFIX_3'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_REQUEST_AMOUNT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_REVIEW_DATE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_SELLER'''
 +
    The seller of the loan
 +
 +
'''LNTERMS_SKIP_CODE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_SMSA'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_SUBS_CHANGE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_SUFFIX'''
 +
    The loan suffix
 +
 +
'''LNTERMS_TERM'''
 +
    The loan term
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_TOT_FIN_CHARGE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_TOT_OF_PAYMENTS'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_TRANSACTION_TYPE'''
 +
    ''Note: not available by default''
 +
'''LNTERMS_VRL_CODE'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_VRL_FREQ'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_VRL_INDEX'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_VRL_MARGIN'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_X_PLDGE_ACCT'''
 +
    ''Note: not available by default''
 +
 +
'''LNTERMS_X_PLDGE_SUFFIX'''
 +
    ''Note: not available by default''
 +
 +
== Loan Vehicle Info ==
 +
 +
'''LN_VI_AMOUNT_FINANCED'''
 +
    The amount financed for the vehicle
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''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
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_PAID_FEE_AMOUNT'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LN_VI_PURCHASE_ORDER'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_SEQUENCE_NBR'''
 +
    The sequence number
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_STATE'''
 +
    The State that the vehicle is registered in
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_TITLE_NUM'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_TITLE_RECIP'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_TTL_EXPECT_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_TTL_RECVD_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_TTL_RELSD_DATE'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_VEHL_MAKE'''
 +
    The make of the vehicle
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LN_VI_VEHL_MODEL'''
 +
    The model of the vehicle
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LN_VI_VEHL_RETAIL'''
 +
    The retail value of the vehicle
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_VEHL_VALUE'''
 +
    The value of the vehicle
 +
 +
'''LN_VI_VEHL_YEAR'''
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LN_VI_VI_APP_KEY'''
 +
    ''Note : not available by default''
 +
 +
'''LN_VI_VIN_NUMBER'''
 +
    The vehicle identification number
 +
    ''Note : not available in the Membership Summary by default''
 +
 +
'''LN_VI_VIN_SUB_NUMBER'''
 +
    ''Note : not available by default''
 +
  
 
== Member Level==
 
== Member Level==
Line 27: Line 1,208:
 
'''MBR_ADDR1'''
 
'''MBR_ADDR1'''
 
     The first address line
 
     The first address line
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_ADDR2'''
 
'''MBR_ADDR2'''
 
     The second address line
 
     The second address line
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_ADDR3'''
 
'''MBR_ADDR3'''
Line 36: Line 1,219:
  
 
'''MBR_AFFINITY_CODE'''
 
'''MBR_AFFINITY_CODE'''
−
 
+
      ''Note: not available in Membership Summary by default''
 +
 
 
'''MBR_AGE'''
 
'''MBR_AGE'''
 
     The age of the member
 
     The age of the member
Line 42: Line 1,226:
 
'''MBR_AGE_AS_DECIMAL'''
 
'''MBR_AGE_AS_DECIMAL'''
 
     The age of the member in decimal form
 
     The age of the member in decimal form
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_BIRTH_DATE'''
 
'''MBR_BIRTH_DATE'''
 
     The member birth date
 
     The member birth date
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_BRANCH'''
 
'''MBR_BRANCH'''
−
     The current branch for the member account
+
     The current branch number for the member account
 +
 
 +
'''MBR_BRANCH_NAME'''
 +
    The current branch name for the member account
 +
 
 +
'''MBR_BRANCH_SORT'''
 +
    The current branch sort order for the member account (See [[Vs_branch_info.xls]])
  
 
'''MBR_CELL_PHONE'''
 
'''MBR_CELL_PHONE'''
 
     The member cell phone number
 
     The member cell phone number
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_CF_ACCT_IN_COLLECT'''
 
'''MBR_CF_ACCT_IN_COLLECT'''
−
     lag indicating the member has a loan in collections
+
     Flag indicating the member has a loan in collections
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_ATM_FLAG'''
 
'''MBR_CF_ATM_FLAG'''
−
     Yes/No flag indicating the member has an ATM card
+
     Flag indicating the member has an ATM card
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_BAD_ADDR'''
 
'''MBR_CF_BAD_ADDR'''
−
     Yes/No flag indicating the member has a bad address
+
     Flag indicating the member has a bad address
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_CAPTURE_ATM_CARD'''
 
'''MBR_CF_CAPTURE_ATM_CARD'''
−
     Yes/No flag indicating the member ATM card should be captured
+
     Flag indicating the member ATM card should be captured
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_CC_ACCT'''
 
'''MBR_CF_CC_ACCT'''
−
     Yes/No flag indicating the member owns a credit card
+
     Flag indicating the member owns a credit card
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_CHGOFF_LOAN'''
 
'''MBR_CF_CHGOFF_LOAN'''
−
     Yes/No flag indicating the member has a charged off loan
+
     Flag indicating the member has a charged off loan
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_CHGOFF_SHARE'''
 
'''MBR_CF_CHGOFF_SHARE'''
−
     Yes/No flag indicating the member has a charged off share
+
     Flag indicating the member has a charged off share
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_DECEASED'''
 
'''MBR_CF_DECEASED'''
−
     Yes/No flag indicating the member is deceased
+
     Flag indicating the member is deceased
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
Line 88: Line 1,281:
  
 
'''MBR_CF_NO_MAIL'''
 
'''MBR_CF_NO_MAIL'''
−
     Yes/No flag indicating the member does not wish to receive mail
+
     Flag indicating the member does not wish to receive mail
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
 
'''MBR_CF_SEND_MTHLY_STMT'''
 
'''MBR_CF_SEND_MTHLY_STMT'''
−
     Yes/No flag indicating the member receives monthly statements
+
     Flag indicating the member receives monthly statements
 
     ''Note: not available by default''
 
     ''Note: not available by default''
  
Line 112: Line 1,305:
 
'''MBR_CITIZENSHIP'''
 
'''MBR_CITIZENSHIP'''
 
     The Country of Citenzenship for the member
 
     The Country of Citenzenship for the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_CITY'''
 
'''MBR_CITY'''
Line 117: Line 1,311:
  
 
'''MBR_CLASS_CODE'''
 
'''MBR_CLASS_CODE'''
 +
    ''Note: not available in Membership Summary by default''
 
      
 
      
 
'''MBR_CLOSE_DATE'''
 
'''MBR_CLOSE_DATE'''
Line 125: Line 1,320:
 
'''MBR_COUNTRY_CODE'''
 
'''MBR_COUNTRY_CODE'''
 
     The country 2 digit code for the member account
 
     The country 2 digit code for the member account
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_CREDIT_SCORE'''
 
'''MBR_CREDIT_SCORE'''
Line 137: Line 1,333:
 
'''MBR_DRIVER_LIC_NUM'''
 
'''MBR_DRIVER_LIC_NUM'''
 
     The member drivers license number
 
     The member drivers license number
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_DRIVER_LIC_STATE'''
 
'''MBR_DRIVER_LIC_STATE'''
 
     The state where the member's drivers license was issued
 
     The state where the member's drivers license was issued
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_E_MAIL'''
 
'''MBR_E_MAIL'''
 
     The member's e-mail address
 
     The member's e-mail address
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_ELIGIBILITY'''
 
'''MBR_ELIGIBILITY'''
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_EMPL_NUM'''
 
'''MBR_EMPL_NUM'''
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_EMPL_STATUS'''
 
'''MBR_EMPL_STATUS'''
 
     The employment status of the member
 
     The employment status of the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_EMPLOYER_NAME'''
 
'''MBR_EMPLOYER_NAME'''
 
     The name on file for the member employer
 
     The name on file for the member employer
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_ESCHEAT_DATE'''
 
'''MBR_ESCHEAT_DATE'''
Line 173: Line 1,376:
  
 
'''MBR_GROUP'''
 
'''MBR_GROUP'''
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_HOUSEHOLD'''
 
'''MBR_HOUSEHOLD'''
  
 
'''MBR_HOUSEHOLD_CODE'''
 
'''MBR_HOUSEHOLD_CODE'''
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_LAST_CHG_DATE'''
 
'''MBR_LAST_CHG_DATE'''
Line 184: Line 1,389:
 
'''MBR_LAST_NAME'''
 
'''MBR_LAST_NAME'''
 
     The last name of the member
 
     The last name of the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_LTD_BRANCH'''
 
'''MBR_LTD_BRANCH'''
Line 199: Line 1,405:
 
'''MBR_MAIDEN_NAME'''
 
'''MBR_MAIDEN_NAME'''
 
     The maiden name of the member
 
     The maiden name of the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_MARITAL_STATUS'''
 
'''MBR_MARITAL_STATUS'''
 
     The marital status of the member
 
     The marital status of the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_MIDDLE_NAME'''
 
'''MBR_MIDDLE_NAME'''
 
     The middle name of the member
 
     The middle name of the member
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_MONTHLY_ADB1'''
 
'''MBR_MONTHLY_ADB1'''
Line 246: Line 1,455:
 
'''MBR_PHONE'''
 
'''MBR_PHONE'''
 
     The member's phone number
 
     The member's phone number
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_PRIOR_YTD_DIV'''
 
'''MBR_PRIOR_YTD_DIV'''
Line 255: Line 1,465:
 
'''MBR_PROFESSION_YEARS'''
 
'''MBR_PROFESSION_YEARS'''
 
     The number of years the member has been in their line of work
 
     The number of years the member has been in their line of work
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_RECORDER'''
 
'''MBR_RECORDER'''
 
     The teller who opened the member account
 
     The teller who opened the member account
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_RECORDER_NAME'''
 
'''MBR_RECORDER_NAME'''
−
     The name of the teller who opened the member's account
+
     The name of the teller who opened the member account
  
 
'''MBR_RECORDER_NAME_INTL'''
 
'''MBR_RECORDER_NAME_INTL'''
Line 268: Line 1,480:
 
'''MBR_REF'''
 
'''MBR_REF'''
 
     The ref field from the member-file record on a Spectrum core
 
     The ref field from the member-file record on a Spectrum core
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_REF2'''
 
'''MBR_REF2'''
 
     The ref2 field from the member-file record on a Spectrum core
 
     The ref2 field from the member-file record on a Spectrum core
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_REF3'''
 
'''MBR_REF3'''
 
     The ref3 field from the member-file record on a Spectrum core
 
     The ref3 field from the member-file record on a Spectrum core
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_REF4'''
 
'''MBR_REF4'''
 
     The ref4 field from the member-file record on a Spectrum core
 
     The ref4 field from the member-file record on a Spectrum core
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_REFER'''
 
'''MBR_REFER'''
−
      
+
     ''Note: not available in Membership Summary by default''   
  
 
'''MBR_RELATE_FLAG'''
 
'''MBR_RELATE_FLAG'''
−
     The relate flag for the member's account to indicate joint ownership
+
     The relate flag for the member account
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_RESIDENCE_CODE'''
 
'''MBR_RESIDENCE_CODE'''
 +
    ''Note: not available in Membership Summary by default''
  
−
'''MBR_REST_FLAG_11''
+
'''MBR_REST_FLAG_11'''
 
     The rest-flag-11 field on a Spectrum core
 
     The rest-flag-11 field on a Spectrum core
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_REST_FLAG_12'''
 
'''MBR_REST_FLAG_12'''
Line 295: Line 1,514:
 
'''MBR_SELF_EMPLOYED'''
 
'''MBR_SELF_EMPLOYED'''
 
     The member's self employed status
 
     The member's self employed status
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_SELLER'''
 
'''MBR_SELLER'''
 
     The teller who opened the member account
 
     The teller who opened the member account
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_SELLER_NAME'''
 
'''MBR_SELLER_NAME'''
Line 312: Line 1,533:
 
'''MBR_SSN_NUM'''
 
'''MBR_SSN_NUM'''
 
     The member's Social Security Number
 
     The member's Social Security Number
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_STATE'''
 
'''MBR_STATE'''
Line 333: Line 1,555:
 
'''MBR_WORK_PHONE'''
 
'''MBR_WORK_PHONE'''
 
     The member's work phone
 
     The member's work phone
 +
    ''Note: not available in Membership Summary by default''
  
 
'''MBR_YTD_INT'''
 
'''MBR_YTD_INT'''
Line 342: Line 1,565:
  
 
'''MBR ZIP+4'''
 
'''MBR ZIP+4'''
−
     The member's 4 digit zipcode
+
     The member's full zipcode including the last 4 digits
  
 
'''MBR_SSN_FMT'''
 
'''MBR_SSN_FMT'''
 
     The member's formatted SSN xxx-xx-xxxx
 
     The member's formatted SSN xxx-xx-xxxx
 +
    ''Note: not available in Membership Summary by default''
  
 
== Share Level==
 
== Share Level==
Line 373: Line 1,597:
  
 
'''SH_ADB_DAYS'''
 
'''SH_ADB_DAYS'''
−
     The average daily balance days used to calculate average daily balance
+
     The Average Daily Balance Days
 
     ''Note: not available in Membership Summary by default''
 
     ''Note: not available in Membership Summary by default''
  
Line 692: Line 1,916:
 
'''SH_YTD_PAID_NSF'''
 
'''SH_YTD_PAID_NSF'''
 
     The year to date paid NSF fees for this share
 
     The year to date paid NSF fees for this share
−
 
−
== Loan Level ==
 
−
 
−
'''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
 
−
 
−
==Loan Addendum==
 
−
 
−
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
 
−
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
 
−
 
−
 
−
==Loan Terms==
 
−
 
−
LNTERMS_ACCOUNT
 
−
LNTERMS_ACTION
 
−
LNTERMS_ALT_AMOUNT
 
−
LNTERMS_ALT_NUMBER
 
−
LNTERMS_ALT_START_DATE
 
−
LNTERMS_AMOUNT
 
−
LNTERMS_APP_KEY
 
−
LNTERMS_APR
 
−
LNTERMS_AUTO_CALC_INT
 
−
LNTERMS_BALLOON_PYMT_DATE
 
−
LNTERMS_CASH_APR
 
−
LNTERMS_CENSUS_TRACT
 
−
LNTERMS_COLLATERAL
 
−
LNTERMS_DESCRIPTION
 
−
LNTERMS_DIS_INSUR_AMT
 
−
LNTERMS_DISBURSAL_DATE
 
−
LNTERMS_DISCLOSURE_CODE
 
−
LNTERMS_DRAFT_ACCT
 
−
LNTERMS_DUE_DATE
 
−
LNTERMS_ENTRY_DATE
 
−
LNTERMS_FINAL_ADV_DATE
 
−
LNTERMS_FIRST_RT_CHG_DATE
 
−
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
 
−
LNTERMS_MARGIN_SECURITY
 
−
LNTERMS_METHOD
 
−
LNTERMS_MICR_NUMBER
 
−
LNTERMS_NONDISCNT_APR
 
−
LNTERMS_NOTE
 
−
LNTERMS_NUMBER
 
−
LNTERMS_OLD_CREDIT_LIM
 
−
LNTERMS_PLEDGE_AMOUNT
 
−
LNTERMS_PLEDGE_CODE
 
−
LNTERMS_PMT_AMOUNT
 
−
LNTERMS_PRCNT_DOWN
 
−
LNTERMS_PRODUCT_CODE
 
−
LNTERMS_PURPOSE
 
−
LNTERMS_RECORDER
 
−
LNTERMS_REF_SUFFIX_1
 
−
LNTERMS_REF_SUFFIX_2
 
−
LNTERMS_REF_SUFFIX_3
 
−
LNTERMS_REQUEST_AMOUNT
 
−
LNTERMS_REVIEW_DATE
 
−
LNTERMS_SELLER
 
−
LNTERMS_SKIP_CODE
 
−
LNTERMS_SMSA
 
−
LNTERMS_SUBS_CHANGE
 
−
LNTERMS_SUFFIX
 
−
LNTERMS_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
 
−
 
−
 
−
== Loan Vehicle Info ==
 
−
 
−
LN_VI_AMOUNT_FINANCED
 
−
LN_VI_DEALER
 
−
LN_VI_DEALER_CODE
 
−
LN_VI_LICENSE_NUM
 
−
LN_VI_PAID_FEE_AMOUNT
 
−
LN_VI_PURCHASE_ORDER
 
−
LN_VI_SEQUENCE_NBR
 
−
LN_VI_STATE
 
−
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
 
−
LN_VI_VEHL_MODEL
 
−
LN_VI_VEHL_RETAIL
 
−
LN_VI_VEHL_VALUE
 
−
LN_VI_VEHL_YEAR
 
−
LN_VI_VI_APP_KEY
 
−
LN_VI_VIN_NUMBER
 
−
LN_VI_VIN_SUB_NUMBER
 
  
 
== Attributes ==
 
== Attributes ==

Latest revision as of 17:52, 13 June 2013

The fields available for use in Document Distribution from the Membership Analysis Application

Dealer Info

DLR_ADDR1 

   The dealer's address lines 1
   Note : not available by default

DLR_ADDR2 

   The dealer's address lines 2
   Note : not available by default

DLR_ADDR3 

   The dealer's address lines 3
   Note : not available by default

DLR_CHECK_MIN 

   Note : not available by default

DLR_CITY 

   The city the dealer is located in
   Note : not available by default

DLR_COUNTRY_CODE 

   The dealer's 2 digit country code
   Note : not available by default

DLR_DEALER_GRADE 

  The grade associated with the dealer

DLR_FEE_CODE 

   Note : not available by default

DLR_FEE_FIXED 

   Note : not available by default

DLR_FEE_FLAG 

   Note : not available by default

DLR_FEE_MAXIMUM 

   Note : not available by default

DLR_NAME 

   The name of the dealer

DLR_PHONE 

   The phone number for the dealer
   Note : not available by default

DLR_PTD_COUNT 

   Note : not available by default

DLR_PTD_FEE_AMOUNT 

   Note : not available by default

DLR_PTD_LOAN_AMOUNT 

   Note : not available by default

DLR_PY_COUNT 

   Note : not available by default

DLR_PY_FEE_AMOUNT 

   Note : not available by default

DLR_PY_LOAN_AMOUNT 

   Note : not available by default

DLR_RESERVE_AMT 

   Note : not available by default

DLR_STATE 

   The state the dealership is located in
   Note : not available by default

DLR_TTD_COUNT 

   Note : not available by default

DLR_TTD_FEE_AMOUNT 

   Note : not available by default

DLR_TTD_LOAN_AMOUNT 

   Note : not available by default

DLR_YTD_COUNT 

   Note : not available by default

DLR_YTD_FEE_AMOUNT 

   Note : not available by default

DLR_YTD_LOAN_AMOUNT 

   Note : not available by default

DLR_ZIP 

   Note : not available by default


Loan Level

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
   Note: not available in Membership Summary by default

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
   Note: not available in Membership Summary by default

LN_AMOUNT 

   The original amount of the loan
   Note: not available in Membership Summary by default

LN_APP_LT_NUMBER 

   Note: not available by default

LN_APP_NUMBER 

   The 3 digit loan application number 
   Note: not available in Membership Summary by default

LN_APP_SSN 

   The loan application social security number
   Note: not available in Membership Summary by default

LN_APPLY_DATE 

   The date the loan was applied for
   Note: not available in Membership Summary by default

LN_APR 

   The loan APR

LN_BALANCE 

   The current loan balance

LN_BALLOON_PYMT_DT 

   The balloon payment date of the loan
   Note: not available in Membership Summary by default

LN_BRANCH 

   The current branch where the loan is serviced

LN_CF_CREDIT_CARD_LOAN 

   Flag indicating the loan is a credit card
   Note: not available in Membership Summary by default

LN_CF_LOC_LOAN 

   Flag indicating the loan is a line of credit
   Note: not available in Membership Summary by default

LN_CF_NO_LATE_NOTICES 

   Note: not available by default

LN_CF_OFFLINE_LOAN 

   Note: not available in Membership Summary by default

LN_CF_OPEN_END_FLAG 

   Note: not available in Membership Summary by default

LN_CF_REAL_ESTATE_LOAN 

   Flag indicating the loan is for Real Estate
   Note: not available in Membership Summary by default

LN_CF_STUDENT_INFO 

   Note: not available in Membership Summary by default
   Note: not available in Membership Summary by default

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 

   Note: not available by default

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
   Note: not available in Membership Summary by default

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 

   Note: not available in Membership Summary by default

LN_CURE_DATE 

   Note: not available by default

LN_CYCLE_DATE 

   Note: not available by default

LN_DEALER_CODE 

   The dealer code on file for the loan
   Note: not available by default

LN_DEBT_RATIO 

   The last Debt to Income ratio for the member
   Note: not available by default

LN_DECISION_TELLER 

   The teller who approved the loan
   Note: not available by default

LN_DECISION_TELLER_NAME 

   The name of the teller who approved the loan
   Note: not available in Membership Summary by default

LN_DECISION_TELLER_NAME_INTL 

   The initials of the teller who approved the loan
   Note: not available by default

LN_DENIAL_NOTICE 

   Note: not available in Membership Summary by default

LN_DENIAL_REASON 

   Note: not available in Membership Summary by default

LN_DESCRIPTION 

   The description of the loan
   Note: not available in Membership Summary by default

LN_DISB_CHECK 

   Note: not available by default

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
   Note: not available in Membership Summary by default

LN_FREQUENCY 

   The frequency for loan payments
   Note: not available in Membership Summary by default

LN_GROUP 

   Note: not available by default

LN_HIGH_BALANCE 

   Note: not available in Membership Summary by default

LN_HIGHEST_DELQ_AMT 

   The highest amount of delinquent payments for the loan
   Note: not available in Membership Summary by default

LN_HIGHEST_DELQ_DT 

   Note: not available in Membership Summary by default

LN_INSUR_CODES 

   Note: not available by default

LN_INSUR_TERM 

   Note: not available by default

LN_KTFR_ACCOUNT 

   Note: not available by default

LN_KTFR_SUFFIX 

   Note: not available by default

LN_LAST_ACCT_STATUS 

   Note: not available by default

LN_LAST_AMOUNT 

   The last amount of the loan balance
   Note: not available in Membership Summary by default

LN_LAST_APR 

   The last APR for the loan

LN_LAST_CHG_DATE 

   The last date the loan was modified

LN_LAST_CODE 

   Note: not available in Membership Summary by default

LN_LAST_DATE 

   The date of the last monetary transaction

LN_LAST_INT_DATE 

   The date the last interest amount was calculated
   Note: not available by default

LN_LAST_MONTHS_INT 

   The amount of interest calculated for last month
   Note: not available by default

LN_LAST_PYMT_AMT 

   The amount of the last loan payment
   Note: not available in Membership Summary by default

LN_LAST_PYMT_DATE 

   The date of the last payment
   Note: not available in Membership Summary by default

LN_LAST_RATE_CHG_DT 

   The date the loan rate was changed
   Note: not available by default

LN_MATURITY_DATE 

   The maturity date of the loan
   Note: not available in Membership Summary by default

LN_METHOD 

   Note: not available in Membership Summary by default

LN_MICR_NUMBER 

   The micr number for the loan
   Note: not available by default

LN_NAME 

   The member name on file for the loan
   Note: not available by default

LN_NEXT_YEARS_INT 

   The amount of interest calculated for next year
   Note: not available by default

LN_OCCUR_DATE 

   Note: not available by default

LN_OFFICER 

   The loan officer assigned to the loan
   Note: not available by default

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
   Note: not available by default

LN_OFFLINE_SERVICER 

   Note: not available by default

LN_OLC_ENTRY_DATE 

   Note: not available by default

LN_ORIG_BRANCH 

   The original branch where the loan was opened

LN_ORIGINAL_APR 

   The original APR of the loan
   Note: not available in Membership Summary by default

LN_OVERLIMIT_DATE 

   The date the credit limit was overdrawn
   Note: not available by default

LN_OVRD_OFFICER 

   Note: not available by default

LN_PAID_OFF_DATE 

   The date the loan was paid off
   Note: not available in Membership Summary by default

LN_PARTIAL_PAYMENT 

   The last partial payment for the loan
   Note: not available in Membership Summary by default

LN_PLEDGE_AMOUNT 

   Note: not available in Membership Summary by default

LN_PLEDGE_CODE 

   Note: not available in Membership Summary by default

LN_PMT_HISTORY 

   A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history
   Note: not available in Membership Summary by default

LN_PREV_COLLAT_CODE 

   The previous collateral code of the loan
   Note: not available by default

LN_PREV_CYCLE_DATE 

   Note: not available by default

LN_PREV_INT_RATE 

   The previous interest rate of the loan
   Note: not available by default

LN_PREV_MICR_NUM 

   The previous micr number of the loan
   Note: not available by default

LN_PRIN_PMT_AMT 

   Note: not available by default

LN_PRIOR_YTD_INT 

   The prior year to date interest paid
   Note: not available by default

LN_PURPOSE 

   The loan purpose code
   Note: not available in Membership Summary by default

LN_PYMT_AMOUNT1 

   Note: not available by default

LN_PYMT_CHANGE_DT1 

   Note: not available by default

LN_RECORDER 

   The loan officer who recorded the loan
   Note: not available by default

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
   Note: not available in Membership Summary by default

LN_REST_FLAG_11 

   The rest-flag-11 field for the loan
   Note: not available by default

LN_REST_FLAG_12 

   The rest-flag-12 field for the loan
   Note: not available by default

LN_REVIEW_DATE 

   The date the loan was reviewed
   Note: not available in Membership Summary by default

LN_SECURE_UNSECURE_FLAG 

   Flag indicating that the loan is secured by collateral or not
   Note: not available in Membership Summary by default

LN_SELLER 

   The teller who sold the loan
   Note: not available by default

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
   Note: not available by default

LN_STATUS 

   The status of the loan : (N)ew or (R)efinanced
   Note: not available by default

LN_SUFFIX 

   The suffix of the loan

LN_TERM 

   The term of the loan
   Note: not available in Membership Summary by default

LN_THIRD_PARTY_KEY 

   Note: not available by default

LN_VAR_RATE_CODE 

   Note: not available in Membership Summary by default

LN_VEHICLE_INFO_KEY 

   The key to link into vehicle-info

LN_VRL_INDEX 

   Note: not available by default

LN_VRL_MARGIN 

   Note: not available by default

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
   Note: not available in Membership Summary by default

Loan Addendum

LNADDM_ACC 

   Note : not available by default

LNADDM_ACCOUNT 

   Note : not available by default

LNADDM_ACCRUED_DIV 

   Note : not available by default

LNADDM_ACCUM_DIVIDEND 

   Note : not available by default

LNADDM_AMORT_TERM 

   Note : not available by default

LNADDM_AMORT_TYPE 

   Note : not available by default

LNADDM_AMOUNT_LAST_TRAN 

   Note : not available by default

LNADDM_APPRAISAL_AMOUNT 

   Note : not available in the Membership Summary by default

LNADDM_APPRAISAL_DATE 

   Note : not available in the Membership Summary by default

LNADDM_APR_LOCK_DATE 

   Note : not available by default

LNADDM_BUILDER 

   Note : not available by default

LNADDM_CO_HMDA_ETHNIC 

   Note : not available by default

LNADDM_CO_HMDA_RACES 

   Note : not available by default

LNADDM_CO_HMDA_SEX 

   Note : not available by default

LNADDM_COMMENT 

   Note : not available by default

LNADDM_COMMIT_DATE 

   Note : not available by default

LNADDM_CONDO_PUD_NAME 

   Note : not available by default

LNADDM_CONTRACTOR 

   Note : not available by default

LNADDM_COUNTY_CODE 

   Note : not available by default

LNADDM_CURR_LATE_CRG 

   Note : not available by default

LNADDM_CUSHION_AMOUNT 

   Note : not available by default

LNADDM_CUSHION_RATE 

   Note : not available by default

LNADDM_DEFICIENCY 

   Note : not available by default

LNADDM_DELQ_ADJUST_AMOUNT 

   Note : not available by default

LNADDM_DELQ_DATE 

   Note : not available by default

LNADDM_DESC_ABRV 

   Note : not available by default

LNADDM_DIV_PAID_DATE 

   Note : not available by default

LNADDM_DIV_WHH_AMT 

   Note : not available by default

LNADDM_DRAW_COUNT 

   Note : not available by default

LNADDM_DRAW_LIMIT 

   Note : not available by default

LNADDM_DWELLING_TYPE 

   Note : not available by default

LNADDM_EDA_FLAG 

   Note : not available by default

LNADDM_EFF_DATE_LAST_TRAN 

   Note : not available by default

LNADDM_ESCROW_AMT_CHG_DATE 

   Note : not available by default

LNADDM_ESCROW_BALANCE 

   The Escrow balance
   Note : not available in the Membership Summary by default

LNADDM_ESCROW_CENTS_DAYS 

   Note : not available by default

LNADDM_ESCROW_DUE_DATE 

   Note : not available by default

LNADDM_ESCROW_ENTRY_DATE 

   Note : not available by default

LNADDM_ESCROW_LAST_CHG_DATE 

   Note : not available by default

LNADDM_ESCROW_PMT_AMOUNT 

   Note : not available by default

LNADDM_ESCROW_PRIOR_AMOUNT 

   Note : not available by default

LNADDM_FED_MAX_CUSHION 

   Note : not available by default

LNADDM_FIN_INST_FTB_FLD 

   Note : not available by default

LNADDM_FIRST_RT_CHG_DATE 

   Note : not available by default

LNADDM_FORCLS_MIADJ_FLD 

   Note : not available by default

LNADDM_GROSS_ANNUAL_INCOME 

   Note : not available by default

LNADDM_HMDA_ETHNIC 

   Note : not available by default

LNADDM_HMDA_OCCUP_CODE 

   Note : not available by default

LNADDM_HMDA_RACES 

   Note : not available by default

LNADDM_HMDA_SEX 

   Note : not available by default

LNADDM_HOEPA_STATUS 

   Note : not available by default

LNADDM_IMPROVE_AMOUNT 

   Note : not available by default

LNADDM_INSPECTION_DATE 

   Note : not available by default

LNADDM_INT_ONLY_END_DATE 

   Note : not available by default

LNADDM_INVESTOR_ACTION_CODE 

   Note : not available by default

LNADDM_INVESTOR_ACTION_DATE 

   Note : not available by default

LNADDM_INVESTOR_LOAN_NUMBER 

   Note : not available by default

LNADDM_INVESTOR_PKG_KEY 

   Note : not available by default

LNADDM_INVESTOR_PTD_FEES 

   Note : not available by default

LNADDM_INVESTOR_PTD_INT 

   Note : not available by default

LNADDM_INVESTOR_PTD_PRINCIPAL 

   Note : not available by default

LNADDM_INVESTOR_PTD_PYMNTS 

   Note : not available by default

LNADDM_INVESTOR_STATUS 

   Note : not available by default

LNADDM_LAST_ANLY_DATE 

   Note : not available by default

LNADDM_LAST_DIV_CALC 

   Note : not available by default

LNADDM_LAST_DIV_PAID 

   Note : not available by default

LNADDM_LAST_MONETARY_AMOUNT 

   Note : not available by default

LNADDM_LAST_MONETARY_CODE 

   Note : not available by default

LNADDM_LAST_MONETARY_DATE 

   Note : not available by default

LNADDM_LAST_RUN_DATE 

   Note : not available by default

LNADDM_LIEN_STATUS 

   Note : not available by default

LNADDM_LOAN_FEATURE 

   Note : not available by default

LNADDM_MERS_NUMBER 

   Note : not available by default

LNADDM_MI_CERT_NUMBER 

   Note : not available by default

LNADDM_MI_PERCENT 

   Note : not available by default

LNADDM_MIN_PAYMENT 

   Note : not available by default

LNADDM_MISC_INSUR_AMOUNT 

   Note : not available by default

LNADDM_MONTH_DEBT_EXP 

   Note : not available by default

LNADDM_MONTH_HOUSE_EXP 

   Note : not available by default

LNADDM_MORT_INS_CODE 

   Note : not available by default

LNADDM_MORTGAGE_MARGIN 

   Note : not available by default

LNADDM_MORTGAGE_TYPE 

   Note : not available in the Membership Summary by default

LNADDM_NEXT_ANLY_DATE 

   Note : not available by default

LNADDM_NUMB_BORROWERS 

   Note : not available by default

LNADDM_NUMBER_OF_UNITS 

   Note : not available by default

LNADDM_ORIG_MONTHLY_PI 

   Note : not available by default

LNADDM_ORIGINAL_LTV 

   Note : not available in the Membership Summary by default

LNADDM_OTHER_FINANCING 

   Note : not available by default

LNADDM_OWNER_OCCUPIED 

   Note : not available by default

LNADDM_PAYMENT_ADJUST 

   Note : not available by default

LNADDM_PERCENT_DONE 

   Note : not available by default

LNADDM_PERIOD_LOW_BAL 

   Note : not available by default

LNADDM_POINTS 

   Note : not available by default

LNADDM_PORTION_PAID 

   Note : not available by default

LNADDM_PRE_APRVL_REQ 

   Note : not available by default

LNADDM_PREPAID_ACCRUAL 

   Note : not available by default

LNADDM_PREV_YEAR_INSURANCE 

   Note : not available by default

LNADDM_PREV_YEAR_OTHER 

   Note : not available by default

LNADDM_PRIOR_YTD_DIV 

   Note : not available by default

LNADDM_PRIOR_YTD_PMI 

   Note : not available by default

LNADDM_PRIOR_YTD_TAX 

   Note : not available by default

LNADDM_PROJECT_CLASS 

   Note : not available by default

LNADDM_PROJECT_DUE 

   Note : not available by default

LNADDM_PROPERTY_ADDR 

   Note : not available in the Membership Summary by default

LNADDM_PROPERTY_CITY 

   Note : not available in the Membership Summary by default

LNADDM_PROPERTY_STATE 

   Note : not available in the Membership Summary by default

LNADDM_PROPERTY_TYPE 

   Note : not available in the Membership Summary by default

LNADDM_PROPERTY_ZIP 

   Note : not available in the Membership Summary by default

LNADDM_PURCHASE_DOC 

   Note : not available by default

LNADDM_PURCHASER_TYPE 

   Note : not available by default

LNADDM_PV_DIV_WHH_AMT 

   Note : not available by default

LNADDM_RATE_SPREAD 

   Note : not available by default

LNADDM_REFUND_DATE 

   Note : not available by default

LNADDM_REFUND_METHOD 

   Note : not available by default

LNADDM_SALES_PRICE 

   Note : not available by default

LNADDM_SECND_LIEN_HLDR 

   Note : not available by default

LNADDM_SECTION_ACT 

   Note : not available by default

LNADDM_SHORTAGE 

   Note : not available by default

LNADDM_ST_CUSHION_AMT 

   Note : not available by default

LNADDM_ST_CUSHION_RATE 

   Note : not available by default

LNADDM_SUBSIDY_PMT_AMOUNT 

   Note : not available by default

LNADDM_SUFFIX 

   Note : not available by default

LNADDM_SURPLUS 

   Note : not available by default

LNADDM_UNDISTR_BALANCE 

   Note : not available by default

LNADDM_YTD_DIV 

   Note : not available by default

LNADDM_YTD_INSURANCE 

   Note : not available by default

LNADDM_YTD_OTHER 

   Note : not available by default

LNADDM_YTD_PMI 

   Note : not available by default

LNADDM_YTD_TAX 

   Note : not available by default

Loan Terms

LNTERMS_ACCOUNT 

   The loan account number

LNTERMS_ACTION 

   The loan action
   Note: not available by default

LNTERMS_ALT_AMOUNT 

   Note: not available by default

LNTERMS_ALT_NUMBER 

   Note: not available by default

LNTERMS_ALT_START_DATE 

   Note: not available by default

LNTERMS_AMOUNT 

   The loan amount

LNTERMS_APP_KEY 

   The loan application key

LNTERMS_APR 

   The loan apr
   Note: not available by default

LNTERMS_AUTO_CALC_INT 

   Note: not available by default

LNTERMS_BALLOON_PYMT_DATE 

   The loan balloon payment date
   Note: not available by default

LNTERMS_CASH_APR 

   Note: not available by default

LNTERMS_CENSUS_TRACT 

   Note: not available by default

LNTERMS_COLLATERAL 

   The loan collateral

LNTERMS_DESCRIPTION 

   The loan description
   Note: not available by default

LNTERMS_DIS_INSUR_AMT 

   Note: not available by default

LNTERMS_DISBURSAL_DATE 

   Note: not available by default

LNTERMS_DISCLOSURE_CODE 

   Note: not available by default

LNTERMS_DRAFT_ACCT 

   Note: not available by default

LNTERMS_DUE_DATE 

   Note: not available by default

LNTERMS_ENTRY_DATE 

   The loan open date
   Note: not available by default

LNTERMS_FINAL_ADV_DATE 

   Note: not available by default

LNTERMS_FIRST_RT_CHG_DATE 

   The date of the first rate change for the loan
   Note: not available by default

LNTERMS_FREQUENCY 

   Note: not available by default

LNTERMS_FULLY_INDEXED_RATE 

   Note: not available by default

LNTERMS_GROUP 

   Note: not available by default

LNTERMS_HOLDER 

   Note: not available by default

LNTERMS_INSUR_CODES 

   Note: not available by default

LNTERMS_ITEMIZATION 

   Note: not available by default

LNTERMS_KTFR_ACCT 

   Note: not available by default

LNTERMS_KTFR_SUFFIX 

   Note: not available by default

LNTERMS_LAST_LT_NUMBER 

   Note: not available by default

LNTERMS_LAST_NUMBER 

   Note: not available by default

LNTERMS_LAST_SSN 

   Note: not available by default

LNTERMS_LIFE_INSUR_AMT 

   Note: not available by default

LNTERMS_LOAN_TYPE 

   The loan type

LNTERMS_MARGIN_SECURITY 

   Note: not available by default

LNTERMS_METHOD 

   Note: not available by default

LNTERMS_MICR_NUMBER 

   Note: not available by default

LNTERMS_NONDISCNT_APR 

   Note: not available by default

LNTERMS_NOTE 

   Note: not available by default

LNTERMS_NUMBER 

   Note: not available by default

LNTERMS_OLD_CREDIT_LIM 

   The old credit limit for the loan
   Note: not available by default

LNTERMS_PLEDGE_AMOUNT 

   Note: not available by default

LNTERMS_PLEDGE_CODE 

   Note: not available by default

LNTERMS_PMT_AMOUNT 

   Note: not available by default

LNTERMS_PRCNT_DOWN 

   Note: not available by default

LNTERMS_PRODUCT_CODE 

   The loan product code

LNTERMS_PURPOSE 

   Note: not available by default

LNTERMS_RECORDER 

   The loan recorder
   Note: not available by default

LNTERMS_REF_SUFFIX_1 

   Note: not available by default

LNTERMS_REF_SUFFIX_2 

   Note: not available by default

LNTERMS_REF_SUFFIX_3 

   Note: not available by default

LNTERMS_REQUEST_AMOUNT 

   Note: not available by default

LNTERMS_REVIEW_DATE 

   Note: not available by default

LNTERMS_SELLER 

   The seller of the loan

LNTERMS_SKIP_CODE 

   Note: not available by default

LNTERMS_SMSA 

   Note: not available by default

LNTERMS_SUBS_CHANGE 

   Note: not available by default

LNTERMS_SUFFIX 

   The loan suffix

LNTERMS_TERM 

   The loan term
   Note: not available by default

LNTERMS_TOT_FIN_CHARGE 

   Note: not available by default

LNTERMS_TOT_OF_PAYMENTS 

   Note: not available by default

LNTERMS_TRANSACTION_TYPE 

   Note: not available by default

LNTERMS_VRL_CODE 

   Note: not available by default

LNTERMS_VRL_FREQ 

   Note: not available by default

LNTERMS_VRL_INDEX 

   Note: not available by default

LNTERMS_VRL_MARGIN 

   Note: not available by default

LNTERMS_X_PLDGE_ACCT 

   Note: not available by default

LNTERMS_X_PLDGE_SUFFIX 

   Note: not available by default

Loan Vehicle Info

LN_VI_AMOUNT_FINANCED 

   The amount financed for the vehicle
   Note : not available in the Membership Summary by default

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
   Note : not available by default

LN_VI_PAID_FEE_AMOUNT 

   Note : not available in the Membership Summary by default

LN_VI_PURCHASE_ORDER 

   Note : not available by default

LN_VI_SEQUENCE_NBR 

   The sequence number
   Note : not available by default

LN_VI_STATE 

   The State that the vehicle is registered in
   Note : not available by default

LN_VI_TITLE_NUM 

   Note : not available by default

LN_VI_TITLE_RECIP 

   Note : not available by default

LN_VI_TTL_EXPECT_DATE 

   Note : not available by default

LN_VI_TTL_RECVD_DATE 

   Note : not available by default

LN_VI_TTL_RELSD_DATE 

   Note : not available by default

LN_VI_VEHL_MAKE 

   The make of the vehicle
   Note : not available in the Membership Summary by default

LN_VI_VEHL_MODEL 

   The model of the vehicle
   Note : not available in the Membership Summary by default

LN_VI_VEHL_RETAIL 

   The retail value of the vehicle
   Note : not available by default

LN_VI_VEHL_VALUE 

   The value of the vehicle

LN_VI_VEHL_YEAR 

   Note : not available in the Membership Summary by default

LN_VI_VI_APP_KEY 

   Note : not available by default

LN_VI_VIN_NUMBER 

   The vehicle identification number
   Note : not available in the Membership Summary by default

LN_VI_VIN_SUB_NUMBER 

   Note : not available by default


Member Level

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
   Note : not available by default

MBR_ACTIVE_LN_CNT 

   Count of active loans belonging to the member
   Note: not available by default

MBR_ACTIVE_SH_BAL 

   Balance of active shares belonging to the member
   Note: not available by default

MBR_ACTIVE_SH_CNT 

   Count of active shares belonging to the member
   Note: not available by default

MBR_ADDR1 

   The first address line
   Note: not available in Membership Summary by default

MBR_ADDR2 

   The second address line
   Note: not available in Membership Summary by default

MBR_ADDR3 

   The third address line
   Note: not available by default

MBR_AFFINITY_CODE 

      Note: not available in Membership Summary by default

MBR_AGE 

   The age of the member

MBR_AGE_AS_DECIMAL 

   The age of the member in decimal form
   Note: not available in Membership Summary by default

MBR_BIRTH_DATE 

   The member birth date
   Note: not available in Membership Summary by default

MBR_BRANCH 

   The current branch number for the member account

MBR_BRANCH_NAME 

   The current branch name for the member account

MBR_BRANCH_SORT 

   The current branch sort order for the member account (See Vs_branch_info.xls)

MBR_CELL_PHONE 

   The member cell phone number
   Note: not available in Membership Summary by default

MBR_CF_ACCT_IN_COLLECT 

   Flag indicating the member has a loan in collections
   Note: not available by default

MBR_CF_ATM_FLAG 

   Flag indicating the member has an ATM card
   Note: not available by default

MBR_CF_BAD_ADDR 

   Flag indicating the member has a bad address
   Note: not available by default

MBR_CF_CAPTURE_ATM_CARD 

   Flag indicating the member ATM card should be captured
   Note: not available by default

MBR_CF_CC_ACCT 

   Flag indicating the member owns a credit card
   Note: not available by default

MBR_CF_CHGOFF_LOAN 

   Flag indicating the member has a charged off loan
   Note: not available by default

MBR_CF_CHGOFF_SHARE 

   Flag indicating the member has a charged off share
   Note: not available by default

MBR_CF_DECEASED 

   Flag indicating the member is deceased
   Note: not available by default

MBR_CF_NO_LABELS 

   Note: not available by default

MBR_CF_NO_MAIL 

   Flag indicating the member does not wish to receive mail
   Note: not available by default

MBR_CF_SEND_MTHLY_STMT 

   Flag indicating the member receives monthly statements
   Note: not available by default

MBR_CF_STMTS_TO_CU 

   Note: not available by default

MBR_CHG_LN_BAL 

   Note: not available by default

MBR_CHG_LN_CNT 

   Note: not available by default

MBR_CHG_SH_BAL 

   Note: not available by default

MBR_CHG_SH_CNT 

   Note: not available by default

MBR_CITIZENSHIP 

   The Country of Citenzenship for the member
   Note: not available in Membership Summary by default

MBR_CITY 

   The city of the member's account

MBR_CLASS_CODE 

   Note: not available in Membership Summary by default

MBR_CLOSE_DATE 

   The date the member account was closed

MBR_COUNT

MBR_COUNTRY_CODE 

   The country 2 digit code for the member account
   Note: not available in Membership Summary by default

MBR_CREDIT_SCORE 

   The credit score associated with the member account

MBR_CURE_DATE 

   Note: not available by default

MBR_DEPARTMENT 

   The department associated with this member

MBR_DRIVER_LIC_NUM 

   The member drivers license number
   Note: not available in Membership Summary by default

MBR_DRIVER_LIC_STATE 

   The state where the member's drivers license was issued
   Note: not available in Membership Summary by default

MBR_E_MAIL 

   The member's e-mail address
   Note: not available in Membership Summary by default

MBR_ELIGIBILITY 

   Note: not available in Membership Summary by default

MBR_EMPL_NUM 

   Note: not available in Membership Summary by default

MBR_EMPL_STATUS 

   The employment status of the member
   Note: not available in Membership Summary by default

MBR_EMPLOYER_NAME 

   The name on file for the member employer
   Note: not available in Membership Summary by default

MBR_ESCHEAT_DATE 

   The escheat date for the member account

MBR_FAX_NUMBER 

   Note: not available by default

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 

   Note: not available in Membership Summary by default

MBR_HOUSEHOLD

MBR_HOUSEHOLD_CODE 

   Note: not available in Membership Summary by default

MBR_LAST_CHG_DATE 

   The date of the last change made to the member's account
   Note: not available by default

MBR_LAST_NAME 

   The last name of the member
   Note: not available in Membership Summary by default

MBR_LTD_BRANCH 

   Note: not available by default

MBR_LTD_COLLATERAL 

   Note: not available by default

MBR_LTD_DATE 

   Note: not available by default

MBR_LTD_OFFICER 

   Note: not available by default

MBR_MAIDEN_NAME 

   The maiden name of the member
   Note: not available in Membership Summary by default

MBR_MARITAL_STATUS 

   The marital status of the member
   Note: not available in Membership Summary by default

MBR_MIDDLE_NAME 

   The middle name of the member
   Note: not available in Membership Summary by default

MBR_MONTHLY_ADB1 

   The average daily balance for the past 1 month
   Note: not available by default

MBR_MONTHLY_ADB2 

   The average daily balance for 2 months prior
   Note: not available by default

MBR_MONTHLY_ADB3 

   The average daily balance for 2 months prior
   Note: not available by default

MBR_NAME_CHG_DATE 

   The date when the member changed their name
   Note: not available by default

MBR_OLC_COUNT 

   Note: not available by default

MBR_OLC_ENTRY_DATE 

   Note: not available by default

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
   Note: not available by default

MBR_PHONE 

   The member's phone number
   Note: not available in Membership Summary by default

MBR_PRIOR_YTD_DIV 

   Note: not available by default

MBR_PRIOR_YTD_INT 

   Note: not available by default

MBR_PROFESSION_YEARS 

   The number of years the member has been in their line of work
   Note: not available in Membership Summary by default

MBR_RECORDER 

   The teller who opened the member account
   Note: not available in Membership Summary by default

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
   Note: not available by default

MBR_REF 

   The ref field from the member-file record on a Spectrum core
   Note: not available in Membership Summary by default

MBR_REF2 

   The ref2 field from the member-file record on a Spectrum core
   Note: not available in Membership Summary by default

MBR_REF3 

   The ref3 field from the member-file record on a Spectrum core
   Note: not available in Membership Summary by default

MBR_REF4 

   The ref4 field from the member-file record on a Spectrum core
   Note: not available in Membership Summary by default

MBR_REFER 

   Note: not available in Membership Summary by default

MBR_RELATE_FLAG 

   The relate flag for the member account
   Note: not available in Membership Summary by default

MBR_RESIDENCE_CODE 

   Note: not available in Membership Summary by default

MBR_REST_FLAG_11 

   The rest-flag-11 field on a Spectrum core
   Note: not available in Membership Summary by default

MBR_REST_FLAG_12 

   The rest-flag-12 field on a Spectrum core
   Note: not available by default

MBR_SELF_EMPLOYED 

   The member's self employed status
   Note: not available in Membership Summary by default

MBR_SELLER 

   The teller who opened the member account
   Note: not available in Membership Summary by default

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
   Note: not available by default

MBR_SEX 

   The sex of the member
   Note: not available by default

MBR_SSN_NUM 

   The member's Social Security Number
   Note: not available in Membership Summary by default

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
   Note: not available in Membership Summary by default

MBR_YTD_INT 

   The year to date interest for the member account
   Note: not available by default

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
   Note: not available in Membership Summary by default

Share Level

SH_CERT_MAT_DATE 

   The certificate maturity date
   Note: not available in Membership Summary by default

SH_CERT_MAT_DATE_MTH 

   The certificate maturity month
   Note: not available in Membership Summary by default

SH_ACC 

   The Share ACC Code
   Note: not available in Membership Summary by default

SH_ACCOUNT 

   The 9 digit share account number

SH_ACCRUED_DIV 

   The accrued dividends for the share
   Note: not available by default

SH_ACCUM_DIVIDEND 

   The accumulated dividends for the share
   Note: not available by default

SH_ADB_DAYS 

   The Average Daily Balance Days
   Note: not available in Membership Summary by default

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
   Note: not available in Membership Summary by default

SH_CERT_ADJ_VAL_LS1 

   Note: not available by default

SH_CERT_DIV_REG_LS2 

   Note: not available by default

SH_CERT_DIV_TOT_LS3 

   Note: not available by default

SH_CERT_FOR_AMT_LS5 

   Note: not available by default

SH_CERT_MAT_DT_LS4 

   The certificate maturity date
   Note: not available in Membership Summary by default

SH_CERT_NUMBER_LS6 

   Note: not available by default

SH_CERT_ROLLOVER_DATE 

   The date the certificate rolled over to a new certificate
   Note: not available by default

SH_CF_ADDON_CERT 

   Note: not available by default

SH_CF_ALL_SAVERS_CERT 

   Note: not available by default

SH_CF_ATM_REGD 

   Note: not available by default

SH_CF_AUTO_XFER 

   Note: not available by default

SH_CF_CERT_FLAG 

   Flag indicating the share is a certificate
   Note: not available by default

SH_CF_DEBIT_CARD 

   Flag indicating the share has a debit card
   Note: not available by default

SH_CF_IRA_ACCT 

   Flag indicating the share is an IRA
   Note: not available by default

SH_CF_NO_ACTIVITY_FLAG 

   Flag indicating the share has no activity
   Note: not available by default

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
   Note: not available by default

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
   Note: not available by default

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
   Note: not available by default

SH_DIV_PAID_DATE 

   The last date dividends were posted to the share
   Note: not available by default

SH_DIV_PERIOD_DAYS 

   The number of days that dividends were calculated and paid out to the share
   Note: not available by default

SH_DIV_RATE 

   The dividend rate for the share

SH_DIV_WHH_AMT 

   The amount of dividends to be withheld
   Note: not available by default

SH_DOLLAR_DAYS 

   Note: not available by default

SH_DRAFT_ACCT 

   Note: not available in Membership Summary by default

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
   Note: not available by default

SH_INSUR_CODES 

   Note: not available by default

SH_IRA_FLAG 

   A flag indicating the share is an IRA
   Note: not available in Membership Summary by default

SH_IRA_TYPE 

   A description of the type of IRA the share is
   Note: not available in Membership Summary by default

SH_KITE_RESET_DATE 

   Note: not available by default

SH_LAST_AMOUNT

SH_LAST_CHG_DATE 

   Note: not available by default

SH_LAST_CODE 

   Note: not available by default

SH_LAST_DATE

SH_LAST_DIV_CALC 

   Note: not available by default

SH_LAST_DIV_PAID 

   The last dividend amount paid to the share
   Note: not available by default

SH_LAST_NSF_DATE 

   The date the share last posted a NSF fee
   Note: not available by default

SH_LAST_PAID_NSF 

   The date of the last paid NSF fee
   Note: not available by default

SH_LAST_PBF_AMOUNT 

   Note: not available by default

SH_LAST_PBF_DATE 

   Note: not available by default

SH_LAST_STMT_DATE 

   Note: not available in Membership Summary by default

SH_LTD_NSF_COUNTER 

   Note: not available by default

SH_MAT_DISP 

   Note: not available by default

SH_MICR_NUMBER 

   The MICR number for the share
   Note: not available by default

SH_MONTHLY_ADB1 

   The share average daily balance for the past month
   Note: not available in Membership Summary by default

SH_MTD_NSF_COUNTER 

   The number of NSF fee given month to date
   Note: not available by default

SH_MTD_PAID_NSF 

   The number of paid NSF fees month to date
   Note: not available by default

SH_NAME 

   The member name on file for the share
   Note: not available by default

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 

   Note: not available by default

SH_ORIG_TERM_TYPE 

   Note: not available by default

SH_OWNER 

   The name of the owner of the share
   Note: not available in Membership Summary by default

SH_PERIOD_LOW_BAL 

   Note: not available by default

SH_PLEDGE_AMOUNT 

   Note: not available in Membership Summary by default

SH_PREV_DESC_ABRV 

   The share previous description abreviation
   Note: not available in Membership Summary by default

SH_PREV_DIV_CDAYS 

   Note: not available by default

SH_PRIOR_DIV_RATE 

   The share prior dividend rate
   Note: not available in Membership Summary by default

SH_PRIOR_YTD_DIV 

   The share prior year to date total dividends
   Note: not available in Membership Summary by default

SH_PRIOR_YTD_FOR 

   Note: not available by default

SH_PTD_WTHDRAWLS 

   Note: not available by default

SH_PV_DIV_WHH_AMT 

   Note: not available by default

SH_RECORDER 

   The teller who recorded the share
   Note: not available by default

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
   Note: not available by default

SH_REGD_CHECKS 

   Note: not available by default

SH_REGD_WTHDRAWLS 

   The number of Regd transaction this month
   Note: not available in Membership Summary by default

SH_RESET_DIV_DATE 

   Note: not available by default

SH_ROLL_ACC 

   Note: not available by default

SH_ROLL_AMOUNT_CHG 

   Note: not available by default

SH_ROLL_SDA 

   Note: not available by default

SH_ROLL_TERM 

   Note: not available by default

SH_ROLL_TERM_TYPE 

   Note: not available by default

SH_SELLER 

   The teller who opened the share with the member
   Note: not available by default

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

Attributes

Retrieved from "https://wiki.vital-soft.com/index.php?title=Membership_Analysis_Fields&oldid=490"