Loan App Fields

From Vital Soft Wiki
Revision as of 23:44, 28 August 2012 by >Jeremyb
Jump to: navigation, search

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_ACCOUNT

   The account number of the loan

LN_ACTION

   The action for this loan : "O","D","3"

LN_BALANCE

   The current loan balance

LN_BRANCH

   The current branch where the loan is serviced

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_COLLATERAL

   The 3 digit collateral number for the loan

LN_COLLATERAL_DESC

   The description of the collateral for the loan

LN_COUNT

LN_CREDIT_LIM

   The credit limit for the loan

LN_CREDIT_SCORE

   The last beacon/credit score available for the loan

LN_DECISION_TELLER_NAME

   The name of the teller who approved the loan

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_OFFICER_NAME

   The name of the loan officer assigned to the loan

LN_ORIG_BRANCH

   The original branch where the loan was opened

LN_PREV_COLLAT_CODE

   The previous collateral code of the loan

LN_SUFFIX

   The suffix of the loan

LN_YTD_INT

   The year to date interest paid on the loan


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