Loan App Fields

The fields available in the Loanap application

The fields available in the Loanapp Application

Loanap

LNAPP_ACTION

   Action on Loan Application

LNAPP_ACTION_DATE

   Date loan application action was modified

LNAPP_APP_KEY

   The loan application key (9 digit ssn + 3 digit loan app number)

LNAPP_LOAN_TYPE

   Loan Type

LNAPP_ORIG_BRANCH

   Original branch of loan application

Loan Level

LN_COLLATERAL_DESC LN_DECISION_TELLER_NAME LN_OFFICER_NAME LN_ACCOUNT LN_ACTION LN_BALANCE LN_BRANCH LN_CHAR_OFF_REASON LN_CHARGE_OFF_AMT LN_CHARGE_OFF_DATE LN_CLOSE_DATE LN_COLLATERAL LN_COUNT LN_CREDIT_LIM LN_CREDIT_SCORE LN_DUE_DATE LN_ENTRY_AMOUNT LN_ENTRY_DATE LN_ORIG_BRANCH LN_PREV_COLLAT_CODE LN_SUFFIX LN_YTD_INT

Loan Terms

LNTERMS_ACCOUNT LNTERMS_AMOUNT LNTERMS_APP_KEY LNTERMS_COLLATERAL LNTERMS_LOAN_TYPE LNTERMS_PRODUCT_CODE LNTERMS_RECORDER LNTERMS_SUFFIX

Member Level

MBR_ACCOUNT MBR_ACCT_AGE MBR_AGE MBR_CLOSE_DATE MBR_COUNT MBR_CREDIT_SCORE MBR_FINAL_CLOSE_DATE MBR_FULL_NAME MBR_OPEN_DATE MBR_ORIG_BRANCH MBR_ORIG_OPEN_DATE MBR_TOTAL_LN_BAL MBR_TOTAL_LN_CNT MBR_TOTAL_SH_BAL MBR_TOTAL_SH_CNT MBR_UNIQUE_ID

MBR_SSN_FMT

Share Level

SH_CERT_MAT_DT_LS4 SH_DESC_ABRV_LONGDESC SH_SELLER_NAME SH_ACCOUNT SH_BALANCE SH_CF_SHARE_DRAFT_ACCT SH_CHAR_OFF_REASON SH_CHARGE_OFF_AMT SH_CHARGE_OFF_DATE SH_CLOSE_DATE SH_COUNT SH_DESC_ABRV SH_DIV_RATE SH_ENTRY_AMOUNT SH_ENTRY_DATE SH_OPEN_DATE SH_ORIG_BRANCH SH_SELLER_NAME_INTL SH_SSN SH_SUFFIX SH_YTD_DIV