Difference between revisions of "Loan App Fields"
>Jeremyb |
>Jeremyb (→Loanapp) |
||
| Line 1: | Line 1: | ||
'''The fields available in the Loanap application''' | '''The fields available in the Loanap application''' | ||
| − | + | '''The fields available in the Loanapp Application''' | |
| − | + | ==Loanap== | |
| − | LNAPP_ACTION | + | |
| − | LNAPP_ACTION_DATE | + | '''LNAPP_ACTION''' |
| − | + | Action on Loan Application | |
| − | LNAPP_APP_KEY | + | |
| − | + | '''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_COLLATERAL_DESC | |
| − | + | LN_DECISION_TELLER_NAME | |
| − | + | LN_OFFICER_NAME | |
| − | + | LN_ACCOUNT | |
| − | + | LN_ACTION | |
| − | + | LN_BALANCE | |
| − | + | LN_BRANCH | |
| − | + | LN_CHAR_OFF_REASON | |
| − | + | LN_CHARGE_OFF_AMT | |
| − | + | LN_CHARGE_OFF_DATE | |
| − | + | LN_CLOSE_DATE | |
| − | + | LN_COLLATERAL | |
| − | + | LN_COUNT | |
| − | + | LN_CREDIT_LIM | |
| + | LN_CREDIT_SCORE | ||
| + | LN_DUE_DATE | ||
| + | LN_ENTRY_AMOUNT | ||
| + | LN_ENTRY_DATE | ||
| + | LN_ORIG_BRANCH | ||
| + | LN_PREV_COLLAT_CODE | ||
| + | LN_SUFFIX | ||
| + | LN_YTD_INT | ||
| + | |||
| + | |||
| + | ==Loan Terms== | ||
| + | |||
| + | LNTERMS_ACCOUNT | ||
| + | LNTERMS_AMOUNT | ||
| + | LNTERMS_APP_KEY | ||
| + | LNTERMS_COLLATERAL | ||
| + | LNTERMS_LOAN_TYPE | ||
| + | LNTERMS_PRODUCT_CODE | ||
| + | LNTERMS_RECORDER | ||
| + | LNTERMS_SUFFIX | ||
| + | |||
| + | |||
| + | ==Member Level== | ||
| + | |||
| + | MBR_ACCOUNT | ||
| + | MBR_ACCT_AGE | ||
| + | MBR_AGE | ||
| + | MBR_CLOSE_DATE | ||
| + | MBR_COUNT | ||
| + | MBR_CREDIT_SCORE | ||
| + | MBR_FINAL_CLOSE_DATE | ||
| + | MBR_FULL_NAME | ||
| + | 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 | ||
| + | |||
| + | ==Share Level== | ||
| + | |||
| + | SH_CERT_MAT_DT_LS4 | ||
| + | SH_DESC_ABRV_LONGDESC | ||
| + | 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 | ||
Revision as of 23:37, 28 August 2012
The fields available in the Loanap application
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_COLLATERAL_DESC LN_DECISION_TELLER_NAME LN_OFFICER_NAME LN_ACCOUNT LN_ACTION LN_BALANCE LN_BRANCH LN_CHAR_OFF_REASON LN_CHARGE_OFF_AMT LN_CHARGE_OFF_DATE LN_CLOSE_DATE LN_COLLATERAL LN_COUNT LN_CREDIT_LIM LN_CREDIT_SCORE LN_DUE_DATE LN_ENTRY_AMOUNT LN_ENTRY_DATE LN_ORIG_BRANCH LN_PREV_COLLAT_CODE LN_SUFFIX LN_YTD_INT
Loan Terms
LNTERMS_ACCOUNT LNTERMS_AMOUNT LNTERMS_APP_KEY LNTERMS_COLLATERAL LNTERMS_LOAN_TYPE LNTERMS_PRODUCT_CODE LNTERMS_RECORDER LNTERMS_SUFFIX
Member Level
MBR_ACCOUNT MBR_ACCT_AGE MBR_AGE MBR_CLOSE_DATE MBR_COUNT MBR_CREDIT_SCORE MBR_FINAL_CLOSE_DATE MBR_FULL_NAME 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
SH_CERT_MAT_DT_LS4 SH_DESC_ABRV_LONGDESC 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
