Difference between revisions of "Membership Analysis Fields"
>Jeremyb (→Loan Level) |
>Jeremyb |
||
| Line 709: | Line 709: | ||
LNADDM_YTD_PMI | LNADDM_YTD_PMI | ||
LNADDM_YTD_TAX | LNADDM_YTD_TAX | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 00:40, 28 August 2012
Contents
The fields available for use in Document Distribution from the Membership Analysis Application
Member Level
MBR ZIP+4
The member's 4 digit zipcode
MBR_ACCOUNT
The member's 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
Member's first address line
MBR_ADDR2
Member's second address line
MBR_ADDR3
Member's third address line Note: not available by default
MBR_AFFINITY_CODE
MBR_AGE
The age of the member
MBR_AGE_AS_DECIMAL
The age of the member in decimal form
MBR_BIRTH_DATE
The member's birth date
MBR_BRANCH
The current branch for the member account Note: not available by default
MBR_CELL_PHONE
The member's cell phone number
MBR_CF_ACCT_IN_COLLECT
Yes/No flag indicating the member has a loan in collections Note: not available by default
MBR_CF_ATM_FLAG
Yes/No flag indicating the member has an ATM card Note: not available by default
MBR_CF_BAD_ADDR
Yes/No flag indicating the member has a bad address Note: not available by default
MBR_CF_CAPTURE_ATM_CARD
Yes/No flag indicating the member ATM card should be captured Note: not available by default
MBR_CF_CC_ACCT
Yes/No flag indicating the member owns a credit card Note: not available by default
MBR_CF_CHGOFF_LOAN
Yes/No flag indicating the member has a charged off loan Note: not available by default
MBR_CF_CHGOFF_SHARE
Yes/No flag indicating the member has a charged off share Note: not available by default
MBR_CF_DECEASED
Yes/No flag indicating the member is deceased Note: not available by default
MBR_CF_NO_LABELS
Note: not available by default
MBR_CF_NO_MAIL
Yes/No flag indicating the member does not wish to receive mail Note: not available by default
MBR_CF_SEND_MTHLY_STMT
Yes/No 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
MBR_CITY
The city of the member's account
MBR_CLASS_CODE
MBR_CLOSE_DATE
The date the member account was closed Note: not available by default
MBR_COUNT
Note: not available by default
MBR_COUNTRY_CODE
The country 2 digit code for the member account
MBR_CREDIT_SCORE
The credit score associated with the member account Note: not available by default
MBR_CURE_DATE
Note: not available by default
MBR_DEPARTMENT
MBR_DRIVER_LIC_NUM
The member's drivers license number
MBR_DRIVER_LIC_STATE
The state where the member's drivers license was issued
MBR_E_MAIL
The member's e-mail address
MBR_ELIGIBILITY
MBR_EMPL_NUM
MBR_EMPL_STATUS
MBR_EMPLOYER_NAME
The name of the member's employer
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 Note: not available by default
MBR_FINAL_CLOSE_MTH
The month the member account was closed
MBR_FIRST_NAME
The member's first name
MBR_FULL_NAME
The member's full name Note: not available by default
MBR_GROUP
MBR_HOUSEHOLD
Note: not available by default
MBR_HOUSEHOLD_CODE
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 member's last name
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 member's maiden name
MBR_MARITAL_STATUS
The member's marital status
MBR_MIDDLE_NAME
The member's middle name
MBR_MONTHLY_ADB1
The monthly average daily balance Note: not available by default
MBR_MONTHLY_ADB2
Note: not available by default
MBR_MONTHLY_ADB3
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 Note: not available by default
MBR_ORIG_BRANCH
The original branch where the member opened their account Note: not available by default
MBR_ORIG_OPEN_DATE
The original date the member opened their account Note: not available by default
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
MBR_PRIOR_YTD_DIV
Note: not available by default
MBR_PRIOR_YTD_INT
Note: not available by default
MBR_PROFESSION_YEARS
The years the member has been working in their line of work
MBR_RECORDER
The teller who opened the member's account
MBR_RECORDER_NAME
The name of the teller who opened the member's 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
MBR_REF2
The ref2 field from the member-file record on a Spectrum core
MBR_REF3
The ref3 field from the member-file record on a Spectrum core
MBR_REF4
The ref4 field from the member-file record on a Spectrum core
MBR_REFER
MBR_RELATE_FLAG
The relate flag for the member's account to indicate joint ownership
MBR_RESIDENCE_CODE
'MBR_REST_FLAG_11
The rest-flag-11 field on a Spectrum core
MBR_REST_FLAG_12
The rest-flag-12 field on a Spectrum core Note: not available by default
MBR_SELF_EMPLOYED
The member's self employed status
MBR_SELLER
MBR_SELLER_NAME
MBR_SELLER_NAME_INTL
Note: not available by default
MBR_SEX
The member's sex Note: not available by default
MBR_SSN_NUM
The member's Social Security Number
MBR_STATE
The state on file for the member account
MBR_TOTAL_LN_BAL
The balance of all loans for a member account Note: not available by default
MBR_TOTAL_LN_CNT
The count of all loans for a member account Note: not available by default
MBR_TOTAL_SH_BAL
The balance of all shares for a member account Note: not available by default
MBR_TOTAL_SH_CNT
The count of all shares for a member account Note: not available by default
MBR_UNIQUE_ID
The unique id for each member in Vital Signs Note: not available by default
MBR_WORK_PHONE
The member's work phone
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
SH_ACC SH_ACCOUNT SH_ACCRUED_DIV SH_ACCUM_DIVIDEND SH_ADB_DAYS SH_BALANCE SH_BRANCH SH_CD_FLAG SH_CERT_ADJ_VAL_LS1 SH_CERT_DIV_REG_LS2 SH_CERT_DIV_TOT_LS3 SH_CERT_FOR_AMT_LS5 SH_CERT_MAT_DT_LS4 SH_CERT_NUMBER_LS6 SH_CERT_ROLLOVER_DATE SH_CF_ADDON_CERT SH_CF_ALL_SAVERS_CERT SH_CF_ATM_REGD SH_CF_AUTO_XFER SH_CF_CERT_FLAG SH_CF_DEBIT_CARD SH_CF_IRA_ACCT SH_CF_NO_ACTIVITY_FLAG SH_CF_SHARE_DRAFT_ACCT SH_CF_SSN_VERIF_REQD SH_CHAR_OFF_REASON SH_CHARGE_OFF_AMT SH_CHARGE_OFF_DATE SH_CLOSE_DATE SH_COLLECTOR SH_COUNT SH_DESC_ABRV SH_DESC_ABRV_LONGDESC SH_DESCRIPTION SH_DIV_PAID_DATE SH_DIV_PERIOD_DAYS SH_DIV_RATE SH_DIV_WHH_AMT SH_DOLLAR_DAYS SH_DRAFT_ACCT SH_ENTRY_AMOUNT SH_ENTRY_DATE SH_HI_NEG_AMT SH_INSUR_CODES SH_IRA_FLAG SH_IRA_TYPE SH_KITE_RESET_DATE SH_LAST_AMOUNT SH_LAST_CHG_DATE SH_LAST_CODE SH_LAST_DATE SH_LAST_DIV_CALC SH_LAST_DIV_PAID SH_LAST_NSF_DATE SH_LAST_PAID_NSF SH_LAST_PBF_AMOUNT SH_LAST_PBF_DATE SH_LAST_STMT_DATE SH_LTD_NSF_COUNTER SH_MAT_DISP SH_MICR_NUMBER SH_MONTHLY_ADB1 SH_MTD_NSF_COUNTER SH_MTD_PAID_NSF SH_NAME SH_NEG_DATE SH_OPEN_DATE SH_ORIG_BRANCH SH_ORIG_TERM SH_ORIG_TERM_TYPE SH_OWNER SH_PERIOD_LOW_BAL SH_PLEDGE_AMOUNT SH_PREV_DESC_ABRV SH_PREV_DIV_CDAYS SH_PRIOR_DIV_RATE SH_PRIOR_YTD_DIV SH_PRIOR_YTD_FOR SH_PTD_WTHDRAWLS SH_PV_DIV_WHH_AMT SH_RECORDER SH_RECORDER_NAME SH_RECORDER_NAME_INTL SH_REGD_CHECKS SH_REGD_WTHDRAWLS SH_RESET_DIV_DATE SH_ROLL_ACC SH_ROLL_AMOUNT_CHG SH_ROLL_SDA SH_ROLL_TERM SH_ROLL_TERM_TYPE SH_SELLER SH_SELLER_NAME SH_SELLER_NAME_INTL SH_SSN SH_SUFFIX SH_TARGET_AMOUNT SH_TD_PAID_NSF SH_TIN_TYPE SH_YTD_DIV SH_YTD_NSF_COUNTER SH_YTD_PAID_NSF
Loan Level
LN_AVAIL_CREDIT LN_NBR_LATE_PMTS_LAST_3MTHS LN_ACCOUNT LN_ACTION LN_ACTION_DATE LN_AMOUNT LN_APP_LT_NUMBER LN_APP_NUMBER LN_APP_SSN LN_APPLY_DATE LN_APR LN_BALANCE LN_BALLOON_PYMT_DT LN_BRANCH LN_CF_CREDIT_CARD_LOAN LN_CF_LOC_LOAN LN_CF_NO_LATE_NOTICES LN_CF_OFFLINE_LOAN LN_CF_OPEN_END_FLAG LN_CF_REAL_ESTATE_LOAN LN_CF_STUDENT_INFO LN_CHAR_OFF_REASON LN_CHARGE_OFF_AMT LN_CHARGE_OFF_DATE LN_CLOSE_DATE LN_COLL_AGENCY_CODE LN_COLLATERAL LN_COLLATERAL_DESC LN_COLLECTOR LN_COUNT LN_CREDIT_LIM LN_CREDIT_SCORE LN_CREDIT_SSN LN_CURE_DATE LN_CYCLE_DATE LN_DEALER_CODE LN_DEBT_RATIO LN_DECISION_TELLER LN_DECISION_TELLER_NAME LN_DECISION_TELLER_NAME_INTL LN_DENIAL_NOTICE LN_DENIAL_REASON LN_DESCRIPTION LN_DISB_CHECK LN_DUE_DATE LN_ENTRY_AMOUNT LN_ENTRY_DATE LN_FIRST_PAY_DATE LN_FREQUENCY LN_GROUP LN_HIGH_BALANCE LN_HIGHEST_DELQ_AMT LN_HIGHEST_DELQ_DT LN_INSUR_CODES LN_INSUR_TERM LN_KTFR_ACCOUNT LN_KTFR_SUFFIX LN_LAST_ACCT_STATUS LN_LAST_AMOUNT LN_LAST_APR LN_LAST_CHG_DATE LN_LAST_CODE LN_LAST_DATE LN_LAST_INT_DATE LN_LAST_MONTHS_INT LN_LAST_PYMT_AMT LN_LAST_PYMT_DATE LN_LAST_RATE_CHG_DT LN_MATURITY_DATE LN_METHOD LN_MICR_NUMBER LN_NAME LN_NEXT_YEARS_INT LN_OCCUR_DATE LN_OFFICER LN_OFFICER_NAME LN_OFFICER_NAME_INTL LN_OFFLINE_SERVICER LN_OLC_ENTRY_DATE LN_ORIG_BRANCH LN_ORIGINAL_APR LN_OVERLIMIT_DATE LN_OVRD_OFFICER LN_PAID_OFF_DATE LN_PARTIAL_PAYMENT LN_PLEDGE_AMOUNT LN_PLEDGE_CODE LN_PMT_HISTORY LN_PREV_COLLAT_CODE LN_PREV_CYCLE_DATE LN_PREV_INT_RATE LN_PREV_MICR_NUM LN_PRIN_PMT_AMT LN_PRIOR_YTD_INT LN_PURPOSE LN_PYMT_AMOUNT1 LN_PYMT_CHANGE_DT1 LN_RECORDER LN_RECORDER_NAME LN_RECORDER_NAME_INTL LN_REST_FLAG_11 LN_REST_FLAG_12 LN_REVIEW_DATE LN_SECURE_UNSECURE_FLAG LN_SELLER LN_SELLER_NAME LN_SELLER_NAME_INTL LN_STATUS LN_SUFFIX LN_TERM LN_THIRD_PARTY_KEY LN_VAR_RATE_CODE LN_VEHICLE_INFO_KEY LN_VRL_INDEX LN_VRL_MARGIN LN_YTD_INT LN_NBR_LATE_PMTS
Loan Addendum
LNADDM_ACC LNADDM_ACCOUNT LNADDM_ACCRUED_DIV LNADDM_ACCUM_DIVIDEND LNADDM_AMORT_TERM LNADDM_AMORT_TYPE LNADDM_AMOUNT_LAST_TRAN LNADDM_APPRAISAL_AMOUNT LNADDM_APPRAISAL_DATE LNADDM_APR_LOCK_DATE LNADDM_BUILDER LNADDM_CO_HMDA_ETHNIC LNADDM_CO_HMDA_RACES LNADDM_CO_HMDA_SEX LNADDM_COMMENT LNADDM_COMMIT_DATE LNADDM_CONDO_PUD_NAME LNADDM_CONTRACTOR LNADDM_COUNTY_CODE LNADDM_CURR_LATE_CRG LNADDM_CUSHION_AMOUNT LNADDM_CUSHION_RATE LNADDM_DEFICIENCY LNADDM_DELQ_ADJUST_AMOUNT LNADDM_DELQ_DATE LNADDM_DESC_ABRV LNADDM_DIV_PAID_DATE LNADDM_DIV_WHH_AMT LNADDM_DRAW_COUNT LNADDM_DRAW_LIMIT LNADDM_DWELLING_TYPE LNADDM_EDA_FLAG LNADDM_EFF_DATE_LAST_TRAN LNADDM_ESCROW_AMT_CHG_DATE LNADDM_ESCROW_BALANCE LNADDM_ESCROW_CENTS_DAYS LNADDM_ESCROW_DUE_DATE LNADDM_ESCROW_ENTRY_DATE LNADDM_ESCROW_LAST_CHG_DATE LNADDM_ESCROW_PMT_AMOUNT LNADDM_ESCROW_PRIOR_AMOUNT LNADDM_FED_MAX_CUSHION LNADDM_FIN_INST_FTB_FLD LNADDM_FIRST_RT_CHG_DATE LNADDM_FORCLS_MIADJ_FLD LNADDM_GROSS_ANNUAL_INCOME LNADDM_HMDA_ETHNIC LNADDM_HMDA_OCCUP_CODE LNADDM_HMDA_RACES LNADDM_HMDA_SEX LNADDM_HOEPA_STATUS LNADDM_IMPROVE_AMOUNT LNADDM_INSPECTION_DATE LNADDM_INT_ONLY_END_DATE LNADDM_INVESTOR_ACTION_CODE LNADDM_INVESTOR_ACTION_DATE LNADDM_INVESTOR_LOAN_NUMBER LNADDM_INVESTOR_PKG_KEY LNADDM_INVESTOR_PTD_FEES LNADDM_INVESTOR_PTD_INT LNADDM_INVESTOR_PTD_PRINCIPAL LNADDM_INVESTOR_PTD_PYMNTS LNADDM_INVESTOR_STATUS LNADDM_LAST_ANLY_DATE LNADDM_LAST_DIV_CALC LNADDM_LAST_DIV_PAID LNADDM_LAST_MONETARY_AMOUNT LNADDM_LAST_MONETARY_CODE LNADDM_LAST_MONETARY_DATE LNADDM_LAST_RUN_DATE LNADDM_LIEN_STATUS LNADDM_LOAN_FEATURE LNADDM_MERS_NUMBER LNADDM_MI_CERT_NUMBER LNADDM_MI_PERCENT LNADDM_MIN_PAYMENT LNADDM_MISC_INSUR_AMOUNT LNADDM_MONTH_DEBT_EXP LNADDM_MONTH_HOUSE_EXP LNADDM_MORT_INS_CODE LNADDM_MORTGAGE_MARGIN LNADDM_MORTGAGE_TYPE LNADDM_NEXT_ANLY_DATE LNADDM_NUMB_BORROWERS LNADDM_NUMBER_OF_UNITS LNADDM_ORIG_MONTHLY_PI LNADDM_ORIGINAL_LTV LNADDM_OTHER_FINANCING LNADDM_OWNER_OCCUPIED LNADDM_PAYMENT_ADJUST LNADDM_PERCENT_DONE LNADDM_PERIOD_LOW_BAL LNADDM_POINTS LNADDM_PORTION_PAID LNADDM_PRE_APRVL_REQ LNADDM_PREPAID_ACCRUAL LNADDM_PREV_YEAR_INSURANCE LNADDM_PREV_YEAR_OTHER LNADDM_PRIOR_YTD_DIV LNADDM_PRIOR_YTD_PMI LNADDM_PRIOR_YTD_TAX LNADDM_PROJECT_CLASS LNADDM_PROJECT_DUE LNADDM_PROPERTY_ADDR LNADDM_PROPERTY_CITY LNADDM_PROPERTY_STATE LNADDM_PROPERTY_TYPE LNADDM_PROPERTY_ZIP LNADDM_PURCHASE_DOC LNADDM_PURCHASER_TYPE LNADDM_PV_DIV_WHH_AMT LNADDM_RATE_SPREAD LNADDM_REFUND_DATE LNADDM_REFUND_METHOD LNADDM_SALES_PRICE LNADDM_SECND_LIEN_HLDR LNADDM_SECTION_ACT LNADDM_SHORTAGE LNADDM_ST_CUSHION_AMT LNADDM_ST_CUSHION_RATE LNADDM_SUBSIDY_PMT_AMOUNT LNADDM_SUFFIX LNADDM_SURPLUS LNADDM_UNDISTR_BALANCE LNADDM_YTD_DIV LNADDM_YTD_INSURANCE LNADDM_YTD_OTHER LNADDM_YTD_PMI LNADDM_YTD_TAX
Loan Terms
LNTERMS_ACCOUNT LNTERMS_ACTION LNTERMS_ALT_AMOUNT LNTERMS_ALT_NUMBER LNTERMS_ALT_START_DATE LNTERMS_AMOUNT LNTERMS_APP_KEY LNTERMS_APR LNTERMS_AUTO_CALC_INT LNTERMS_BALLOON_PYMT_DATE LNTERMS_CASH_APR LNTERMS_CENSUS_TRACT LNTERMS_COLLATERAL LNTERMS_DESCRIPTION LNTERMS_DIS_INSUR_AMT LNTERMS_DISBURSAL_DATE LNTERMS_DISCLOSURE_CODE LNTERMS_DRAFT_ACCT LNTERMS_DUE_DATE LNTERMS_ENTRY_DATE LNTERMS_FINAL_ADV_DATE LNTERMS_FIRST_RT_CHG_DATE LNTERMS_FREQUENCY LNTERMS_FULLY_INDEXED_RATE LNTERMS_GROUP LNTERMS_HOLDER LNTERMS_INSUR_CODES LNTERMS_ITEMIZATION LNTERMS_KTFR_ACCT LNTERMS_KTFR_SUFFIX LNTERMS_LAST_LT_NUMBER LNTERMS_LAST_NUMBER LNTERMS_LAST_SSN LNTERMS_LIFE_INSUR_AMT LNTERMS_LOAN_TYPE LNTERMS_MARGIN_SECURITY LNTERMS_METHOD LNTERMS_MICR_NUMBER LNTERMS_NONDISCNT_APR LNTERMS_NOTE LNTERMS_NUMBER LNTERMS_OLD_CREDIT_LIM LNTERMS_PLEDGE_AMOUNT LNTERMS_PLEDGE_CODE LNTERMS_PMT_AMOUNT LNTERMS_PRCNT_DOWN LNTERMS_PRODUCT_CODE LNTERMS_PURPOSE LNTERMS_RECORDER LNTERMS_REF_SUFFIX_1 LNTERMS_REF_SUFFIX_2 LNTERMS_REF_SUFFIX_3 LNTERMS_REQUEST_AMOUNT LNTERMS_REVIEW_DATE LNTERMS_SELLER LNTERMS_SKIP_CODE LNTERMS_SMSA LNTERMS_SUBS_CHANGE LNTERMS_SUFFIX LNTERMS_TERM LNTERMS_TOT_FIN_CHARGE LNTERMS_TOT_OF_PAYMENTS LNTERMS_TRANSACTION_TYPE LNTERMS_VRL_CODE LNTERMS_VRL_FREQ LNTERMS_VRL_INDEX LNTERMS_VRL_MARGIN LNTERMS_X_PLDGE_ACCT LNTERMS_X_PLDGE_SUFFIX
Loan Vehicle Info
LN_VI_AMOUNT_FINANCED LN_VI_DEALER LN_VI_DEALER_CODE LN_VI_LICENSE_NUM LN_VI_PAID_FEE_AMOUNT LN_VI_PURCHASE_ORDER LN_VI_SEQUENCE_NBR LN_VI_STATE LN_VI_TITLE_NUM LN_VI_TITLE_RECIP LN_VI_TTL_EXPECT_DATE LN_VI_TTL_RECVD_DATE LN_VI_TTL_RELSD_DATE LN_VI_VEHL_MAKE LN_VI_VEHL_MODEL LN_VI_VEHL_RETAIL LN_VI_VEHL_VALUE LN_VI_VEHL_YEAR LN_VI_VI_APP_KEY LN_VI_VIN_NUMBER LN_VI_VIN_SUB_NUMBER
