Difference between revisions of "Membership Analysis Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
(Member Level)
>Johno
(Member Level)
Line 1,239: Line 1,239:
  
 
'''MBR_BRANCH_SORT'''
 
'''MBR_BRANCH_SORT'''
     The current branch sort order for the member account (See VS_BRANCH_INFO.xls)
+
     The current branch sort order for the member account (See [Vs_branch_info.xls])
  
 
'''MBR_CELL_PHONE'''
 
'''MBR_CELL_PHONE'''

Revision as of 17:51, 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