Difference between revisions of "Loan App Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
(→‎Share Level)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
''The fields available in the Loanap application''
+
'''The fields available in the Loanapp Application'''
  
−
==Loanapp==
+
==Loanap==
  
−
LNAPP_ACCESS_CODE
+
'''LNAPP_ACTION'''
−
LNAPP_ACTION
+
    Action on Loan Application
−
LNAPP_ACTION_DATE
+
 
−
LNAPP_ACTIVE_FLAG
+
'''LNAPP_ACTION_DATE'''
−
LNAPP_APP_KEY
+
    Date loan application action was modified
−
LNAPP_APP_TOT_INCOME
+
 
−
LNAPP_APP_TOT_PAYMENTS
+
'''LNAPP_APP_KEY'''
−
LNAPP_APP_TYPE
+
    The loan application key (9 digit ssn + 3 digit loan app number)
−
LNAPP_APPLY_DATE
+
 
−
LNAPP_APPROVE_CODE
+
'''LNAPP_LOAN_TYPE'''
−
LNAPP_ASSIGN_DATE
+
    Loan Type
−
LNAPP_COND_TYPE_CODE
+
 
−
LNAPP_CREDIT_REQUEST
+
'''LNAPP_ORIG_BRANCH'''
−
LNAPP_CURR_BRANCH
+
    Original branch of loan application
−
LNAPP_CURR_TELLER
+
 
−
LNAPP_DECISION_TELLER
+
 
−
LNAPP_DENIAL_NOTICE
+
==Loan Level==
−
LNAPP_DENIAL_REASON
+
 
−
LNAPP_EXPIRE_DATE
+
'''LN_ACCOUNT'''
−
LNAPP_FIRST_APPRVD
+
    The account number of the loan
−
LNAPP_GUAR_APP
+
 
−
LNAPP_LAST_DATE
+
'''LN_ACTION'''
−
LNAPP_LOAN_OFFICER
+
    The action for this loan : "O","D","3"
−
LNAPP_LOAN_TYPE
+
 
−
LNAPP_MAKER_APP
+
'''LN_BALANCE'''
−
LNAPP_ORIG_BRANCH
+
    The current loan balance
−
LNAPP_PREV_TELLER
+
 
−
LNAPP_REQUEST_METHOD
+
'''LN_BRANCH'''
−
LNAPP_SECOND_APPRVD
+
    The current branch where the loan is serviced
−
LNAPP_SEQUENCE_CODE
+
 
−
LNAPP_SUBS_CHANGE
+
'''LN_CHAR_OFF_REASON'''
−
LNAPP_TELLER_ALERT
+
    The reason the loan was charged off
−
LNAPP_TOT_UNS_CREDIT
+
 
 +
'''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

Latest revision as of 23:54, 28 August 2012

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
Retrieved from "https://wiki.vital-soft.com/index.php?title=Loan_App_Fields&oldid=498"