Difference between revisions of "Loan App Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(→‎Loanapp)
>Jeremyb
(→‎Share Level)
 
(3 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'''
 
'''The fields available in the Loanapp Application'''
  
Line 19: Line 17:
 
'''LNAPP_ORIG_BRANCH'''
 
'''LNAPP_ORIG_BRANCH'''
 
     Original branch of loan application
 
     Original branch of loan application
 +
  
 
==Loan Level==
 
==Loan Level==
  
−
LN_COLLATERAL_DESC
+
'''LN_ACCOUNT'''
−
LN_DECISION_TELLER_NAME
+
    The account number of the loan
−
LN_OFFICER_NAME
+
 
−
LN_ACCOUNT
+
'''LN_ACTION'''
−
LN_ACTION
+
    The action for this loan : "O","D","3"
−
LN_BALANCE
+
 
−
LN_BRANCH
+
'''LN_BALANCE'''
−
LN_CHAR_OFF_REASON
+
    The current loan balance
−
LN_CHARGE_OFF_AMT
+
 
−
LN_CHARGE_OFF_DATE
+
'''LN_BRANCH'''
−
LN_CLOSE_DATE
+
    The current branch where the loan is serviced
−
LN_COLLATERAL
+
 
−
LN_COUNT
+
'''LN_CHAR_OFF_REASON'''
−
LN_CREDIT_LIM
+
    The reason the loan was charged off
−
LN_CREDIT_SCORE
+
 
−
LN_DUE_DATE
+
'''LN_CHARGE_OFF_AMT'''
−
LN_ENTRY_AMOUNT
+
    The amount charged off for the loan
−
LN_ENTRY_DATE
+
 
−
LN_ORIG_BRANCH
+
'''LN_CHARGE_OFF_DATE'''
−
LN_PREV_COLLAT_CODE
+
    The date the loan was charged off
−
LN_SUFFIX
+
 
−
LN_YTD_INT
+
'''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==
 
==Loan Terms==
  
−
LNTERMS_ACCOUNT
+
'''LNTERMS_ACCOUNT'''
−
LNTERMS_AMOUNT
+
    The loan account number
−
LNTERMS_APP_KEY
+
 
−
LNTERMS_COLLATERAL
+
'''LNTERMS_AMOUNT'''
−
LNTERMS_LOAN_TYPE
+
    The loan amount
−
LNTERMS_PRODUCT_CODE
+
 
−
LNTERMS_RECORDER
+
'''LNTERMS_APP_KEY'''
−
LNTERMS_SUFFIX
+
    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==
 
==Member Level==
  
−
MBR_ACCOUNT
+
'''MBR_ACCOUNT'''
−
MBR_ACCT_AGE
+
    The member account number
−
MBR_AGE
+
 
−
MBR_CLOSE_DATE
+
'''MBR_ACCT_AGE'''
−
MBR_COUNT
+
    The age of the member account
−
MBR_CREDIT_SCORE
+
 
−
MBR_FINAL_CLOSE_DATE
+
'''MBR_AGE'''
−
MBR_FULL_NAME
+
    The age of the member
−
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
+
'''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==
 
==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_CERT_MAT_DT_LS4
+
'''SH_YTD_DIV'''
−
SH_DESC_ABRV_LONGDESC
+
    The year to date dividends paid out
−
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
 

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"