Difference between revisions of "Loan App Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Member Level)
>Jeremyb
(Share Level)
 
Line 166: Line 166:
  
 
==Share Level==
 
==Share Level==
 +
   
 +
'''SH_ACCOUNT'''
 +
    The 9 digit share account number
  
SH_CERT_MAT_DT_LS4
+
'''SH_BALANCE'''
SH_DESC_ABRV_LONGDESC
+
    The current branch of the share
SH_SELLER_NAME
+
 
SH_ACCOUNT
+
'''SH_CF_SHARE_DRAFT_ACCT'''
SH_BALANCE
+
    Flag indicating the share is a checking account
SH_CF_SHARE_DRAFT_ACCT
+
 
SH_CHAR_OFF_REASON
+
'''SH_CHAR_OFF_REASON'''
SH_CHARGE_OFF_AMT
+
    The reason the share was charged off
SH_CHARGE_OFF_DATE
+
 
SH_CLOSE_DATE
+
'''SH_CHARGE_OFF_AMT'''
SH_COUNT
+
    The amount the share was charged off
SH_DESC_ABRV
+
 
SH_DIV_RATE
+
'''SH_CHARGE_OFF_DATE'''
SH_ENTRY_AMOUNT
+
    The date the share became charged off
SH_ENTRY_DATE
+
 
SH_OPEN_DATE
+
'''SH_CLOSE_DATE'''
SH_ORIG_BRANCH
+
    The date the share was closed
SH_SELLER_NAME_INTL
+
 
SH_SSN
+
'''SH_COUNT'''
SH_SUFFIX
+
 
SH_YTD_DIV
+
'''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