Difference between revisions of "Membership Analysis Fields"
>Jeremyb (→Mbr Select) |
>Jeremyb (→Mbr Select) |
||
| Line 1: | Line 1: | ||
== The fields available for use in Document Distribution from the Membership Analysis Application == | == The fields available for use in Document Distribution from the Membership Analysis Application == | ||
| − | == | + | == Member Level== |
'''MBR ZIP+4''' | '''MBR ZIP+4''' | ||
| Line 40: | Line 40: | ||
'''MBR_AFFINITY_CODE''' | '''MBR_AFFINITY_CODE''' | ||
| − | |||
'''MBR_AGE''' | '''MBR_AGE''' | ||
The age of the member | The age of the member | ||
| Line 254: | Line 253: | ||
''Note: not available by default'' | ''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 | + | |
| − | MBR_PROFESSION_YEARS | + | '''MBR_PRIOR_YTD_INT''' |
| − | MBR_RECORDER | + | ''Note: not available by default'' |
| − | MBR_RECORDER_NAME | + | |
| − | MBR_RECORDER_NAME_INTL | + | '''MBR_PROFESSION_YEARS''' |
| − | MBR_REF | + | The years the member has been working in their line of work |
| − | MBR_REF2 | + | |
| − | MBR_REF3 | + | '''MBR_RECORDER''' |
| − | MBR_REF4 | + | The teller who opened the member's account |
| − | MBR_REFER | + | |
| − | MBR_RELATE_FLAG | + | '''MBR_RECORDER_NAME''' |
| − | MBR_RESIDENCE_CODE | + | The name of the teller who opened the member's account |
| − | MBR_REST_FLAG_11 | + | |
| − | MBR_REST_FLAG_12 | + | '''MBR_RECORDER_NAME_INTL''' |
| − | MBR_SELF_EMPLOYED | + | The initials of the teller who opened the member's account |
| − | MBR_SELLER | + | ''Note: not available by default'' |
| − | MBR_SELLER_NAME | + | |
| − | MBR_SELLER_NAME_INTL | + | '''MBR_REF''' |
| − | MBR_SEX | + | The ref field from the member-file record on a Spectrum core |
| − | MBR_SSN_NUM | + | |
| − | MBR_STATE | + | '''MBR_REF2''' |
| − | MBR_TOTAL_LN_BAL | + | The ref2 field from the member-file record on a Spectrum core |
| − | MBR_TOTAL_LN_CNT | + | |
| − | MBR_TOTAL_SH_BAL | + | '''MBR_REF3''' |
| − | MBR_TOTAL_SH_CNT | + | The ref3 field from the member-file record on a Spectrum core |
| − | MBR_UNIQUE_ID | + | |
| − | MBR_WORK_PHONE | + | '''MBR_REF4''' |
| − | MBR_YTD_INT | + | The ref4 field from the member-file record on a Spectrum core |
| − | MBR_ZIP | + | |
| + | '''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 Select == | == Share Select == | ||
Revision as of 00:24, 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
