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