Difference between revisions of "Membership Analysis Fields"
>Jeremyb (→Loan Level) |
>Jeremyb (→Loan Level) |
||
| Line 754: | Line 754: | ||
'''LN_APP_LT_NUMBER''' | '''LN_APP_LT_NUMBER''' | ||
| − | + | ''Note: not available by default'' | |
| + | |||
'''LN_APP_NUMBER''' | '''LN_APP_NUMBER''' | ||
The 3 digit loan application number | The 3 digit loan application number | ||
| Line 818: | Line 819: | ||
'''LN_COLL_AGENCY_CODE''' | '''LN_COLL_AGENCY_CODE''' | ||
| + | ''Note: not available by default'' | ||
'''LN_COLLATERAL''' | '''LN_COLLATERAL''' | ||
| Line 841: | Line 843: | ||
'''LN_CURE_DATE''' | '''LN_CURE_DATE''' | ||
| + | ''Note: not available by default'' | ||
'''LN_CYCLE_DATE''' | '''LN_CYCLE_DATE''' | ||
| Line 863: | Line 866: | ||
'''LN_DECISION_TELLER_NAME_INTL''' | '''LN_DECISION_TELLER_NAME_INTL''' | ||
The initials of the teller who approved the loan | The initials of the teller who approved the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_DENIAL_NOTICE''' | '''LN_DENIAL_NOTICE''' | ||
| Line 909: | Line 913: | ||
'''LN_INSUR_CODES''' | '''LN_INSUR_CODES''' | ||
''Note: not available by default'' | ''Note: not available by default'' | ||
| + | |||
'''LN_INSUR_TERM''' | '''LN_INSUR_TERM''' | ||
| + | ''Note: not available by default'' | ||
'''LN_KTFR_ACCOUNT''' | '''LN_KTFR_ACCOUNT''' | ||
| + | ''Note: not available by default'' | ||
'''LN_KTFR_SUFFIX''' | '''LN_KTFR_SUFFIX''' | ||
| + | ''Note: not available by default'' | ||
'''LN_LAST_ACCT_STATUS''' | '''LN_LAST_ACCT_STATUS''' | ||
| + | ''Note: not available by default'' | ||
'''LN_LAST_AMOUNT''' | '''LN_LAST_AMOUNT''' | ||
The last amount of the loan balance | The last amount of the loan balance | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_LAST_APR''' | '''LN_LAST_APR''' | ||
| Line 927: | Line 937: | ||
'''LN_LAST_CODE''' | '''LN_LAST_CODE''' | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_LAST_DATE''' | '''LN_LAST_DATE''' | ||
| Line 933: | Line 944: | ||
'''LN_LAST_INT_DATE''' | '''LN_LAST_INT_DATE''' | ||
The date the last interest amount was calculated | The date the last interest amount was calculated | ||
| + | ''Note: not available by default'' | ||
'''LN_LAST_MONTHS_INT''' | '''LN_LAST_MONTHS_INT''' | ||
The amount of interest calculated for last month | The amount of interest calculated for last month | ||
| + | ''Note: not available by default'' | ||
'''LN_LAST_PYMT_AMT''' | '''LN_LAST_PYMT_AMT''' | ||
The amount of the last loan payment | The amount of the last loan payment | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_LAST_PYMT_DATE''' | '''LN_LAST_PYMT_DATE''' | ||
The date of the last payment | The date of the last payment | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_LAST_RATE_CHG_DT''' | '''LN_LAST_RATE_CHG_DT''' | ||
The date the loan rate was changed | The date the loan rate was changed | ||
| + | ''Note: not available by default'' | ||
'''LN_MATURITY_DATE''' | '''LN_MATURITY_DATE''' | ||
The maturity date of the loan | The maturity date of the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_METHOD''' | '''LN_METHOD''' | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_MICR_NUMBER''' | '''LN_MICR_NUMBER''' | ||
The micr number for the loan | The micr number for the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_NAME''' | '''LN_NAME''' | ||
The member name on file for the loan | The member name on file for the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_NEXT_YEARS_INT''' | '''LN_NEXT_YEARS_INT''' | ||
The amount of interest calculated for next year | The amount of interest calculated for next year | ||
| + | ''Note: not available by default'' | ||
'''LN_OCCUR_DATE''' | '''LN_OCCUR_DATE''' | ||
| + | ''Note: not available by default'' | ||
'''LN_OFFICER''' | '''LN_OFFICER''' | ||
The loan officer assigned to the loan | The loan officer assigned to the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_OFFICER_NAME''' | '''LN_OFFICER_NAME''' | ||
| Line 970: | Line 993: | ||
'''LN_OFFICER_NAME_INTL''' | '''LN_OFFICER_NAME_INTL''' | ||
The initials of the loan officer assigned to the loan | The initials of the loan officer assigned to the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_OFFLINE_SERVICER''' | '''LN_OFFLINE_SERVICER''' | ||
| + | ''Note: not available by default'' | ||
'''LN_OLC_ENTRY_DATE''' | '''LN_OLC_ENTRY_DATE''' | ||
| + | ''Note: not available by default'' | ||
'''LN_ORIG_BRANCH''' | '''LN_ORIG_BRANCH''' | ||
| Line 980: | Line 1,006: | ||
'''LN_ORIGINAL_APR''' | '''LN_ORIGINAL_APR''' | ||
The original APR of the loan | The original APR of the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_OVERLIMIT_DATE''' | '''LN_OVERLIMIT_DATE''' | ||
The date the credit limit was overdrawn | The date the credit limit was overdrawn | ||
| + | ''Note: not available by default'' | ||
'''LN_OVRD_OFFICER''' | '''LN_OVRD_OFFICER''' | ||
| + | ''Note: not available by default'' | ||
'''LN_PAID_OFF_DATE''' | '''LN_PAID_OFF_DATE''' | ||
The date the loan was paid off | The date the loan was paid off | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_PARTIAL_PAYMENT''' | '''LN_PARTIAL_PAYMENT''' | ||
The last partial payment for the loan | The last partial payment for the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_PLEDGE_AMOUNT''' | '''LN_PLEDGE_AMOUNT''' | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_PLEDGE_CODE''' | '''LN_PLEDGE_CODE''' | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_PMT_HISTORY''' | '''LN_PMT_HISTORY''' | ||
A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment 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''' | '''LN_PREV_COLLAT_CODE''' | ||
The previous collateral code of the loan | The previous collateral code of the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_PREV_CYCLE_DATE''' | '''LN_PREV_CYCLE_DATE''' | ||
| + | ''Note: not available by default'' | ||
'''LN_PREV_INT_RATE''' | '''LN_PREV_INT_RATE''' | ||
The previous interest rate of the loan | The previous interest rate of the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_PREV_MICR_NUM''' | '''LN_PREV_MICR_NUM''' | ||
The previous micr number of the loan | The previous micr number of the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_PRIN_PMT_AMT''' | '''LN_PRIN_PMT_AMT''' | ||
| + | ''Note: not available by default'' | ||
'''LN_PRIOR_YTD_INT''' | '''LN_PRIOR_YTD_INT''' | ||
The prior year to date interest paid | The prior year to date interest paid | ||
| + | ''Note: not available by default'' | ||
'''LN_PURPOSE''' | '''LN_PURPOSE''' | ||
The loan purpose code | The loan purpose code | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_PYMT_AMOUNT1''' | '''LN_PYMT_AMOUNT1''' | ||
| + | ''Note: not available by default'' | ||
'''LN_PYMT_CHANGE_DT1''' | '''LN_PYMT_CHANGE_DT1''' | ||
| + | ''Note: not available by default'' | ||
'''LN_RECORDER''' | '''LN_RECORDER''' | ||
The loan officer who recorded the loan | The loan officer who recorded the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_RECORDER_NAME''' | '''LN_RECORDER_NAME''' | ||
| Line 1,030: | Line 1,074: | ||
'''LN_RECORDER_NAME_INTL''' | '''LN_RECORDER_NAME_INTL''' | ||
The initials of the loan officer who recorded the loan | The initials of the loan officer who recorded the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_REST_FLAG_11''' | '''LN_REST_FLAG_11''' | ||
The rest-flag-11 field for the loan | The rest-flag-11 field for the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_REST_FLAG_12''' | '''LN_REST_FLAG_12''' | ||
The rest-flag-12 field for the loan | The rest-flag-12 field for the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_REVIEW_DATE''' | '''LN_REVIEW_DATE''' | ||
The date the loan was reviewed | The date the loan was reviewed | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_SECURE_UNSECURE_FLAG''' | '''LN_SECURE_UNSECURE_FLAG''' | ||
Flag indicating that the loan is secured by collateral or not | Flag indicating that the loan is secured by collateral or not | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_SELLER''' | '''LN_SELLER''' | ||
The teller who sold the loan | The teller who sold the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_SELLER_NAME''' | '''LN_SELLER_NAME''' | ||
| Line 1,051: | Line 1,101: | ||
'''LN_SELLER_NAME_INTL''' | '''LN_SELLER_NAME_INTL''' | ||
The initials of the teller who sold the loan | The initials of the teller who sold the loan | ||
| + | ''Note: not available by default'' | ||
'''LN_STATUS''' | '''LN_STATUS''' | ||
The status of the loan : (N)ew or (R)efinanced | The status of the loan : (N)ew or (R)efinanced | ||
| + | ''Note: not available by default'' | ||
'''LN_SUFFIX''' | '''LN_SUFFIX''' | ||
| Line 1,060: | Line 1,112: | ||
'''LN_TERM''' | '''LN_TERM''' | ||
The term of the loan | The term of the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_THIRD_PARTY_KEY''' | '''LN_THIRD_PARTY_KEY''' | ||
| + | ''Note: not available by default'' | ||
'''LN_VAR_RATE_CODE''' | '''LN_VAR_RATE_CODE''' | ||
| + | ''Note: not available in Membership Summary by default'' | ||
'''LN_VEHICLE_INFO_KEY''' | '''LN_VEHICLE_INFO_KEY''' | ||
| Line 1,069: | Line 1,124: | ||
'''LN_VRL_INDEX''' | '''LN_VRL_INDEX''' | ||
| + | ''Note: not available by default'' | ||
'''LN_VRL_MARGIN''' | '''LN_VRL_MARGIN''' | ||
| + | ''Note: not available by default'' | ||
'''LN_YTD_INT''' | '''LN_YTD_INT''' | ||
| Line 1,077: | Line 1,134: | ||
'''LN_NBR_LATE_PMTS''' | '''LN_NBR_LATE_PMTS''' | ||
The number of late payment made on the loan | The number of late payment made on the loan | ||
| + | ''Note: not available in Membership Summary by default'' | ||
==Loan Addendum== | ==Loan Addendum== | ||
Revision as of 17:39, 28 August 2012
The fields available for use in Document Distribution from the Membership Analysis Application
Contents
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 for the member account
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'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 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's account to indicate joint ownership 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 4 digit zipcode
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 used to calculate average daily balance 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
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 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
