Difference between revisions of "Membership Analysis Fields"
>Jeremyb (→Loan Vehicle Info) |
>Johno (→Member Level) |
||
(9 intermediate revisions by 2 users not shown) | |||
Line 95: | Line 95: | ||
− | == | + | == Loan Level == |
− | ''' | + | '''LN_AVAIL_CREDIT''' |
− | The | + | The amount of available credit for the loan |
− | ''' | + | '''LN_NBR_LATE_PMTS_LAST_3MTHS''' |
− | The | + | 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 by default'' | + | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_APP_NUMBER''' |
− | The | + | The 3 digit loan application number |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_APP_SSN''' |
− | The | + | The loan application social security number |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_APPLY_DATE''' |
− | The | + | The date the loan was applied for |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''LN_APR''' |
− | + | The loan APR | |
− | ''' | + | '''LN_BALANCE''' |
− | The | + | The current loan balance |
− | ''' | + | '''LN_BALLOON_PYMT_DT''' |
− | The | + | The balloon payment date of the loan |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_BRANCH''' |
− | The | + | 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'' | ''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'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_CF_NO_LATE_NOTICES''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_CF_OFFLINE_LOAN''' |
− | + | ''Note: not available in Membership Summary by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LN_CF_OPEN_END_FLAG''' |
− | + | ''Note: not available in Membership Summary by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LN_CF_REAL_ESTATE_LOAN''' |
− | Flag indicating the | + | Flag indicating the loan is for Real Estate |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''LN_CF_STUDENT_INFO''' |
− | + | ''Note: not available in Membership Summary by default'' | |
− | ''Note: not available 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'' | ''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''' |
− | ''Note: not available by default'' | + | 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'' | ''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''' |
− | ''Note: not available | + | 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 | + | 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'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_DECISION_TELLER_NAME_INTL''' |
− | The | + | The initials of the teller who approved the loan |
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_DENIAL_NOTICE''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_DENIAL_REASON''' |
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_DESCRIPTION''' |
− | The | + | The description of the loan |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_DISB_CHECK''' |
− | ''Note: not available | + | ''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 | + | The date of the first loan payment |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_FREQUENCY''' |
− | The | + | The frequency for loan payments |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_GROUP''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LN_HIGH_BALANCE''' |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''LN_HIGHEST_DELQ_AMT''' |
− | The | + | The highest amount of delinquent payments for the loan |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_HIGHEST_DELQ_DT''' |
− | |||
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_INSUR_CODES''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_INSUR_TERM''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_KTFR_ACCOUNT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_KTFR_SUFFIX''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_LAST_ACCT_STATUS''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_LAST_AMOUNT''' |
− | The | + | The last amount of the loan balance |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_LAST_APR''' |
− | The | + | 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'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_LAST_DATE''' |
− | The | + | The date of the last monetary transaction |
− | |||
− | ''' | + | '''LN_LAST_INT_DATE''' |
− | The | + | The date the last interest amount was calculated |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_LAST_MONTHS_INT''' |
− | The | + | The amount of interest calculated for last month |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_LAST_PYMT_AMT''' |
− | The | + | The amount of the last loan payment |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''LN_LAST_PYMT_DATE''' |
− | The date | + | The date of the last payment |
− | ''Note: not available by default'' | + | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_MATURITY_DATE''' |
− | ''Note: not available by default'' | + | 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 | + | The micr number for the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LN_NAME''' |
− | The | + | The member name on file for the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LN_NEXT_YEARS_INT''' |
− | The | + | The amount of interest calculated for next year |
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | |||
− | |||
− | |||
− | |||
− | ''' | + | '''LN_OCCUR_DATE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_OFFICER''' |
+ | The loan officer assigned to the loan | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_OFFICER_NAME''' |
− | The | + | The name of the loan officer assigned to the loan |
− | |||
− | ''' | + | '''LN_OFFICER_NAME_INTL''' |
− | The | + | The initials of the loan officer assigned to the loan |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LN_OFFLINE_SERVICER''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LN_OLC_ENTRY_DATE''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_ORIG_BRANCH''' |
− | The | + | The original branch where the loan was opened |
− | |||
− | ''' | + | '''LN_ORIGINAL_APR''' |
− | The | + | The original APR of the loan |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_OVERLIMIT_DATE''' |
− | The | + | 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'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_PARTIAL_PAYMENT''' |
− | The | + | The last partial payment for the loan |
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_PLEDGE_AMOUNT''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_PLEDGE_CODE''' |
''Note: not available in Membership Summary by default'' | ''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'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_PREV_COLLAT_CODE''' |
− | The | + | The previous collateral code of the loan |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_PREV_CYCLE_DATE''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LN_PREV_INT_RATE''' |
− | The | + | The previous interest rate of the loan |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LN_PREV_MICR_NUM''' |
− | The | + | The previous micr number of the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LN_PRIN_PMT_AMT''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_PRIOR_YTD_INT''' |
− | The | + | The prior year to date interest paid |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_PURPOSE''' |
− | The | + | The loan purpose code |
''Note: not available in Membership Summary by default'' | ''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 | + | The loan officer who recorded the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LN_RECORDER_NAME''' |
− | The | + | The name of the loan officer who recorded the loan |
− | ''' | + | '''LN_RECORDER_NAME_INTL''' |
− | The | + | The initials of the loan officer who recorded the loan |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_REST_FLAG_11''' |
− | The | + | The rest-flag-11 field for the loan |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_REST_FLAG_12''' |
− | The | + | The rest-flag-12 field for the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LN_REVIEW_DATE''' |
− | The | + | 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'' | ''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 | + | The name of the teller who sold the loan |
− | |||
− | ''' | + | '''LN_SELLER_NAME_INTL''' |
− | The | + | The initials of the teller who sold the loan |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LN_STATUS''' |
− | The | + | The status of the loan : (N)ew or (R)efinanced |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LN_SUFFIX''' |
− | The | + | The suffix of the loan |
− | ''' | + | '''LN_TERM''' |
− | The | + | The term of the loan |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''LN_THIRD_PARTY_KEY''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_VAR_RATE_CODE''' |
− | |||
''Note: not available in Membership Summary by default'' | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LN_VEHICLE_INFO_KEY''' |
− | The | + | The key to link into vehicle-info |
− | ''' | + | '''LN_VRL_INDEX''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LN_VRL_MARGIN''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LN_YTD_INT''' |
− | + | The year to date interest paid on the loan | |
− | ''' | + | '''LN_NBR_LATE_PMTS''' |
− | ''Note: not available by default'' | + | 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'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_ACCOUNT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_ACCRUED_DIV''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_ACCUM_DIVIDEND''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_AMORT_TERM''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_AMORT_TYPE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_AMOUNT_LAST_TRAN''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_APPRAISAL_AMOUNT''' |
− | + | ''Note : not available in the Membership Summary by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_APPRAISAL_DATE''' |
− | + | ''Note : not available in the Membership Summary by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_APR_LOCK_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_BUILDER''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_CO_HMDA_ETHNIC''' |
− | + | ''Note : not available by default'' | |
− | ''' | + | '''LNADDM_CO_HMDA_RACES''' |
− | + | ''Note : not available by default'' | |
− | ''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'' | |
− | ''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'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_DEFICIENCY''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_DELQ_ADJUST_AMOUNT''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_DELQ_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''' | + | '''LNADDM_DESC_ABRV''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_DIV_PAID_DATE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_DIV_WHH_AMT''' |
− | ''Note: not available | + | ''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'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_EDA_FLAG''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_EFF_DATE_LAST_TRAN''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_ESCROW_AMT_CHG_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_ESCROW_BALANCE''' |
− | ''Note: not available by default'' | + | 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'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_ESCROW_ENTRY_DATE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_ESCROW_LAST_CHG_DATE''' |
+ | ''Note : not available by default'' | ||
− | ''' | + | '''LNADDM_ESCROW_PMT_AMOUNT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_ESCROW_PRIOR_AMOUNT''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_FED_MAX_CUSHION''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_FIN_INST_FTB_FLD''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_FIRST_RT_CHG_DATE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_FORCLS_MIADJ_FLD''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_GROSS_ANNUAL_INCOME''' |
− | ''Note: not available | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_HMDA_ETHNIC''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_HMDA_OCCUP_CODE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_HMDA_RACES''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_HMDA_SEX''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_HOEPA_STATUS''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_IMPROVE_AMOUNT''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_INSPECTION_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''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'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_INVESTOR_PKG_KEY''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_INVESTOR_PTD_FEES''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_INVESTOR_PTD_INT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_INVESTOR_PTD_PRINCIPAL''' |
− | ''Note: not available | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_INVESTOR_PTD_PYMNTS''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_INVESTOR_STATUS''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_LAST_ANLY_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_LAST_DIV_CALC''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_LAST_DIV_PAID''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_LAST_MONETARY_AMOUNT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_LAST_MONETARY_CODE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_LAST_MONETARY_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_LAST_RUN_DATE''' |
− | + | ''Note : not available by default'' | |
− | ''' | + | '''LNADDM_LIEN_STATUS''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_LOAN_FEATURE''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MERS_NUMBER''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_MI_CERT_NUMBER''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MI_PERCENT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MIN_PAYMENT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MISC_INSUR_AMOUNT''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MONTH_DEBT_EXP''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MONTH_HOUSE_EXP''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_MORT_INS_CODE''' |
− | + | ''Note : not available by default'' | |
− | ''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'' | |
− | ''Note: not available | ||
− | ''' | + | '''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'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_PREV_YEAR_INSURANCE''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_PREV_YEAR_OTHER''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_PRIOR_YTD_DIV''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_PRIOR_YTD_PMI''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_PRIOR_YTD_TAX''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''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'' | |
− | ''Note: not available in 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'' | |
− | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LNADDM_PROPERTY_TYPE''' |
− | + | ''Note : not available in the Membership Summary by default'' | |
− | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''LNADDM_PROPERTY_ZIP''' |
− | ''Note: not available by default'' | + | ''Note : not available in the Membership Summary by default'' |
− | ''' | + | '''LNADDM_PURCHASE_DOC''' |
− | ''Note: not available | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_PURCHASER_TYPE''' |
− | ''Note: not available | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_PV_DIV_WHH_AMT''' |
− | + | ''Note : not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNADDM_RATE_SPREAD''' |
− | ''Note: not available | + | ''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'' | + | ''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'' | |
− | ''Note: not available | ||
− | ''' | + | '''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'' | |
− | |||
− | |||
− | ''Note: not available by default'' | ||
− | ''' | + | '''LNADDM_YTD_DIV''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LNADDM_YTD_INSURANCE''' |
− | + | ''Note : not available by default'' | |
− | ''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'' | |
− | ''Note: not available by default'' | ||
− | + | ==Loan Terms== | |
− | |||
− | |||
− | ''' | + | '''LNTERMS_ACCOUNT''' |
− | The | + | The loan account number |
− | |||
− | ''' | + | '''LNTERMS_ACTION''' |
− | The | + | The loan action |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_ALT_AMOUNT''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_ALT_NUMBER''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_ALT_START_DATE''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_AMOUNT''' |
− | The | + | The loan amount |
− | ''' | + | '''LNTERMS_APP_KEY''' |
− | The | + | The loan application key |
− | ''' | + | '''LNTERMS_APR''' |
− | The | + | The loan apr |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_AUTO_CALC_INT''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_BALLOON_PYMT_DATE''' |
− | The | + | The loan balloon payment date |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_CASH_APR''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_CENSUS_TRACT''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_COLLATERAL''' |
− | The | + | The loan collateral |
− | |||
− | ''' | + | '''LNTERMS_DESCRIPTION''' |
− | ''Note: not available | + | The loan description |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_DIS_INSUR_AMT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_DISBURSAL_DATE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_DISCLOSURE_CODE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_DRAFT_ACCT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_DUE_DATE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_ENTRY_DATE''' |
− | The | + | The loan open date |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_FINAL_ADV_DATE''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LNTERMS_FIRST_RT_CHG_DATE''' |
− | The | + | The date of the first rate change for the loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_FREQUENCY''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_FULLY_INDEXED_RATE''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LNTERMS_GROUP''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_HOLDER''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_INSUR_CODES''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_ITEMIZATION''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_KTFR_ACCT''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_KTFR_SUFFIX''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_LAST_LT_NUMBER''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_LAST_NUMBER''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_LAST_SSN''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_LIFE_INSUR_AMT''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_LOAN_TYPE''' |
+ | The loan type | ||
+ | |||
+ | '''LNTERMS_MARGIN_SECURITY''' | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_METHOD''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_MICR_NUMBER''' |
− | |||
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_NONDISCNT_APR''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_NOTE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_NUMBER''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LNTERMS_OLD_CREDIT_LIM''' |
− | The | + | The old credit limit for the loan |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_PLEDGE_AMOUNT''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_PLEDGE_CODE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_PMT_AMOUNT''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_PRCNT_DOWN''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_PRODUCT_CODE''' |
− | + | The loan product code | |
− | ''' | + | '''LNTERMS_PURPOSE''' |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_RECORDER''' |
− | + | The loan recorder | |
− | |||
− | |||
− | |||
− | The | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_REF_SUFFIX_1''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_REF_SUFFIX_2''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_REF_SUFFIX_3''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_REQUEST_AMOUNT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_REVIEW_DATE''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_SELLER''' |
− | The loan | + | The seller of the loan |
− | |||
− | ''' | + | '''LNTERMS_SKIP_CODE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_SMSA''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_SUBS_CHANGE''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_SUFFIX''' |
− | The | + | The loan suffix |
− | ''' | + | '''LNTERMS_TERM''' |
− | The | + | The loan term |
− | ''Note: not available | + | ''Note: not available by default'' |
− | ''' | + | '''LNTERMS_TOT_FIN_CHARGE''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_TOT_OF_PAYMENTS''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_TRANSACTION_TYPE''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | + | '''LNTERMS_VRL_CODE''' |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_VRL_FREQ''' |
− | + | ''Note: not available by default'' | |
− | ''Note: not available | ||
− | ''' | + | '''LNTERMS_VRL_INDEX''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_VRL_MARGIN''' |
− | + | ''Note: not available by default'' | |
− | ''' | + | '''LNTERMS_X_PLDGE_ACCT''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''LNTERMS_X_PLDGE_SUFFIX''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | + | == Loan Vehicle Info == | |
− | |||
− | ''' | + | '''LN_VI_AMOUNT_FINANCED''' |
− | The | + | The amount financed for the vehicle |
− | ''Note: not available in Membership Summary by default'' | + | ''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 | + | The vehicle license number |
+ | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_PAID_FEE_AMOUNT''' |
− | ''Note: not available by default'' | + | ''Note : not available in the Membership Summary by default'' |
− | ''' | + | '''LN_VI_PURCHASE_ORDER''' |
− | ''Note: not available by default'' | + | ''Note : not available by default'' |
− | ''' | + | '''LN_VI_SEQUENCE_NBR''' |
− | The | + | The sequence number |
+ | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_STATE''' |
− | The | + | The State that the vehicle is registered in |
− | ''Note: not available | + | ''Note : not available by default'' |
− | + | '''LN_VI_TITLE_NUM''' | |
− | |||
− | ''' | ||
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_TITLE_RECIP''' |
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_TTL_EXPECT_DATE''' |
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_TTL_RECVD_DATE''' |
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_TTL_RELSD_DATE''' |
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_VEHL_MAKE''' |
− | + | The make of the vehicle | |
− | |||
− | |||
− | |||
− | |||
− | |||
''Note : not available in the Membership Summary by default'' | ''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'' | ''Note : not available in the Membership Summary by default'' | ||
− | ''' | + | '''LN_VI_VEHL_RETAIL''' |
+ | The retail value of the vehicle | ||
''Note : not available by default'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_VEHL_VALUE''' |
− | ''Note : not available by default'' | + | 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'' | ''Note : not available by default'' | ||
− | ''' | + | '''LN_VI_VIN_NUMBER''' |
− | ''Note : not available by default'' | + | The vehicle identification number |
+ | ''Note : not available in the Membership Summary by default'' | ||
− | ''' | + | '''LN_VI_VIN_SUB_NUMBER''' |
''Note : not available by default'' | ''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'' | ''Note : not available by default'' | ||
− | ''' | + | '''MBR_ACTIVE_LN_CNT''' |
− | ''Note : not available by default'' | + | Count of active loans belonging to the member |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_ACTIVE_SH_BAL''' |
− | ''Note : not available by default'' | + | Balance of active shares belonging to the member |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_ACTIVE_SH_CNT''' |
− | ''Note : not available by default'' | + | Count of active shares belonging to the member |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_ADDR1''' |
− | ''Note : not available by default'' | + | The first address line |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_ADDR2''' |
− | ''Note : not available by default'' | + | The second address line |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_ADDR3''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The age of the member in decimal form |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_BIRTH_DATE''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The member cell phone number |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_CF_ACCT_IN_COLLECT''' |
− | ''Note : not available by default'' | + | 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 | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CF_BAD_ADDR''' |
− | ''Note : not available by default'' | + | Flag indicating the member has a bad address |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_CAPTURE_ATM_CARD''' |
− | ''Note : not available by default'' | + | Flag indicating the member ATM card should be captured |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_CC_ACCT''' |
− | ''Note : not available by default'' | + | Flag indicating the member owns a credit card |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_CHGOFF_LOAN''' |
− | ''Note : not available by default'' | + | Flag indicating the member has a charged off loan |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_CHGOFF_SHARE''' |
− | ''Note : not available by default'' | + | Flag indicating the member has a charged off share |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_DECEASED''' |
− | ''Note : not available by default'' | + | Flag indicating the member is deceased |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_NO_LABELS''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CF_NO_MAIL''' |
− | ''Note : not available by default'' | + | Flag indicating the member does not wish to receive mail |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_SEND_MTHLY_STMT''' |
− | ''Note : not available by default'' | + | Flag indicating the member receives monthly statements |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_CF_STMTS_TO_CU''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CHG_LN_BAL''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CHG_LN_CNT''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CHG_SH_BAL''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CHG_SH_CNT''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_CITIZENSHIP''' |
− | ''Note : not available by default'' | + | 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 by default'' | + | ''Note: not available in Membership Summary by default'' |
+ | |||
+ | '''MBR_CLOSE_DATE''' | ||
+ | The date the member account was closed | ||
− | ''' | + | '''MBR_COUNT''' |
− | |||
− | ''' | + | '''MBR_COUNTRY_CODE''' |
− | ''Note : not available by default'' | + | 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'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_DEPARTMENT''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The state where the member's drivers license was issued |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_E_MAIL''' |
− | ''Note : not available by default'' | + | The member's e-mail address |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_ELIGIBILITY''' |
− | ''Note : not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_EMPL_NUM''' |
− | ''Note : not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_EMPL_STATUS''' |
− | ''Note : not available by default'' | + | The employment status of the member |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_EMPLOYER_NAME''' |
− | ''Note : not available by default'' | + | 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'' | + | ''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 by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_HOUSEHOLD''' |
− | |||
− | ''' | + | '''MBR_HOUSEHOLD_CODE''' |
− | ''Note : not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_LAST_CHG_DATE''' |
− | ''Note : not available by default'' | + | The date of the last change made to the member's account |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_LAST_NAME''' |
− | ''Note : not available by default'' | + | The last name of the member |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_LTD_BRANCH''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_LTD_COLLATERAL''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_LTD_DATE''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_LTD_OFFICER''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_MAIDEN_NAME''' |
− | ''Note : not available by default'' | + | The maiden name of the member |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_MARITAL_STATUS''' |
− | ''Note : not available by default'' | + | The marital status of the member |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_MIDDLE_NAME''' |
− | ''Note : not available by default'' | + | The middle name of the member |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_MONTHLY_ADB1''' |
− | ''Note : not available | + | The average daily balance for the past 1 month |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_MONTHLY_ADB2''' |
− | ''Note : not available by default'' | + | The average daily balance for 2 months prior |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_MONTHLY_ADB3''' |
− | ''Note : not available by default'' | + | The average daily balance for 2 months prior |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_NAME_CHG_DATE''' |
− | ''Note : not available by default'' | + | The date when the member changed their name |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_OLC_COUNT''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_OLC_ENTRY_DATE''' |
− | ''Note : not available | + | ''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''' |
− | ''Note : not available by default'' | + | 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'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_PRIOR_YTD_INT''' |
− | ''Note : not available by default'' | + | ''Note: not available by default'' |
− | ''' | + | '''MBR_PROFESSION_YEARS''' |
− | ''Note : not available by default'' | + | The number of years the member has been in their line of work |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_RECORDER''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The initials of the teller who opened the member's account |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_REF''' |
− | ''Note : not available by default'' | + | The ref field from the member-file record on a Spectrum core |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_REF2''' |
− | ''Note : not available by default'' | + | The ref2 field from the member-file record on a Spectrum core |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_REF3''' |
− | ''Note : not available by default'' | + | The ref3 field from the member-file record on a Spectrum core |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_REF4''' |
− | ''Note : not available by default'' | + | 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 by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_RELATE_FLAG''' |
− | ''Note : not available in | + | The relate flag for the member account |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_RESIDENCE_CODE''' |
− | ''Note : not available in | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''MBR_REST_FLAG_11''' |
− | ''Note : not available in | + | The rest-flag-11 field on a Spectrum core |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_REST_FLAG_12''' |
− | ''Note : not available | + | The rest-flag-12 field on a Spectrum core |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_SELF_EMPLOYED''' |
− | ''Note : not available in | + | The member's self employed status |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_SELLER''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The initials of the teller who opened the member account |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_SEX''' |
− | ''Note : not available by default'' | + | The sex of the member |
+ | ''Note: not available by default'' | ||
− | ''' | + | '''MBR_SSN_NUM''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The member's work phone |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''MBR_YTD_INT''' |
− | ''Note : not available by default'' | + | 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''' |
− | ''Note : not available by default'' | + | The member's formatted SSN xxx-xx-xxxx |
+ | ''Note: not available in Membership Summary by default'' | ||
− | + | == Share Level== | |
− | |||
− | ''' | + | '''SH_CERT_MAT_DATE''' |
− | ''Note : not available by default'' | + | The certificate maturity date |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''SH_CERT_MAT_DATE_MTH''' |
− | ''Note : not available by default'' | + | The certificate maturity month |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''SH_ACC''' |
− | ''Note : not available by default'' | + | 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 | |
− | |||
− | |||
− | |||
− | ''' | ||
− | The | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_ACCUM_DIVIDEND''' |
+ | The accumulated dividends for the share | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_ADB_DAYS''' |
− | ''Note: not available by default'' | + | The Average Daily Balance Days |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''SH_BALANCE''' |
− | + | The share balance | |
− | ''' | + | '''SH_BRANCH''' |
− | The | + | 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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CERT_DIV_REG_LS2''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CERT_DIV_TOT_LS3''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CERT_FOR_AMT_LS5''' |
''Note: not available by default'' | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CERT_ROLLOVER_DATE''' |
− | The | + | The date the certificate rolled over to a new certificate |
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_ADDON_CERT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_ALL_SAVERS_CERT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_ATM_REGD''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_AUTO_XFER''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_CERT_FLAG''' |
+ | Flag indicating the share is a certificate | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_DEBIT_CARD''' |
− | + | Flag indicating the share has a debit card | |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_IRA_ACCT''' |
+ | Flag indicating the share is an IRA | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_CF_NO_ACTIVITY_FLAG''' |
− | + | Flag indicating the share has no activity | |
''Note: not available by default'' | ''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'' | ''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'' | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_DIV_PAID_DATE''' |
+ | The last date dividends were posted to the share | ||
''Note: not available by default'' | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_DIV_RATE''' |
− | The | + | The dividend rate for the share |
− | ''' | + | '''SH_DIV_WHH_AMT''' |
+ | The amount of dividends to be withheld | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_DOLLAR_DAYS''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_DRAFT_ACCT''' |
− | ''Note: not available by default'' | + | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_INSUR_CODES''' |
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_IRA_FLAG''' |
− | ''Note: not available by default'' | + | 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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_AMOUNT''' |
+ | |||
+ | '''SH_LAST_CHG_DATE''' | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_CODE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_DATE''' |
− | |||
− | ''' | + | '''SH_LAST_DIV_CALC''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_DIV_PAID''' |
− | The | + | The last dividend amount paid to the share |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_NSF_DATE''' |
+ | The date the share last posted a NSF fee | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_PAID_NSF''' |
+ | The date of the last paid NSF fee | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_PBF_AMOUNT''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_PBF_DATE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_LAST_STMT_DATE''' |
− | ''Note: not available by default'' | + | ''Note: not available in Membership Summary by default'' |
− | ''' | + | '''SH_LTD_NSF_COUNTER''' |
− | |||
− | |||
− | |||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_MAT_DISP''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_MICR_NUMBER''' |
+ | The MICR number for the share | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_MONTHLY_ADB1''' |
− | The | + | The share average daily balance for the past month |
+ | ''Note: not available in Membership Summary by default'' | ||
− | ''' | + | '''SH_MTD_NSF_COUNTER''' |
− | The | + | The number of NSF fee given month to date |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_MTD_PAID_NSF''' |
+ | The number of paid NSF fees month to date | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_NAME''' |
+ | The member name on file for the share | ||
''Note: not available by default'' | ''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'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_ORIG_TERM_TYPE''' |
''Note: not available by default'' | ''Note: not available by default'' | ||
− | ''' | + | '''SH_OWNER''' |
− | ''Note: not available by default'' | + | 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'' | ''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 == | == Attributes == |
Latest revision as of 17:52, 13 June 2013
The fields available for use in Document Distribution from the Membership Analysis Application
Contents
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
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