Loan App Fields

From Vital Soft Wiki
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

   The loan account number

LNTERMS_AMOUNT

   The loan amount

LNTERMS_APP_KEY

   The loan application key

LNTERMS_COLLATERAL

   The loan collateral

LNTERMS_LOAN_TYPE

   The loan type

LNTERMS_PRODUCT_CODE

   The loan product code

LNTERMS_RECORDER

   The loan recorder

LNTERMS_SUFFIX

   The loan suffix

Member Level

MBR_ACCOUNT

   The member account number

MBR_ACCT_AGE

   The age of the member account

MBR_AGE

   The age of the member

MBR_CLOSE_DATE

   The date the member account was closed

MBR_COUNT

MBR_CREDIT_SCORE

   The credit score associated with the member account

MBR_FINAL_CLOSE_DATE

   The final date the member account was closed

MBR_FULL_NAME

   The full name of the member

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_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_SSN_FMT

   The member's formatted SSN xxx-xx-xxxx

Share Level

SH_ACCOUNT

   The 9 digit share account number

SH_BALANCE

   The current branch of the share

SH_CF_SHARE_DRAFT_ACCT

   Flag indicating the share is a checking account

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_COUNT

SH_CERT_MAT_DT_LS4

   The certificate maturity date

SH_DESC_ABRV

   The share description abbreviation

SH_DESC_ABRV_LONGDESC

   The long form of the share description abbreviation

SH_DIV_RATE

   The dividend rate for the share

SH_ENTRY_AMOUNT

   The balance of the share when it was opened

SH_ENTRY_DATE

   The date the share was opened

SH_OPEN_DATE

   The open date of the share

SH_ORIG_BRANCH

   The original branch where the share was opened

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_YTD_DIV

   The year to date dividends paid out