Difference between revisions of "Membership Analysis Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
(Share Level)
Line 353: Line 353:
  
 
== Share Level==
 
== Share Level==
 +
 +
'''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 ==
 
== Loan Level ==
  
 
== Attributes ==
 
== Attributes ==

Revision as of 00:28, 28 August 2012

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

Share Level

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

Attributes