Difference between revisions of "Loan App Fields"
>Jeremyb (→Member Level) |
>Jeremyb (→Share Level) |
||
| Line 166: | Line 166: | ||
==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 | + | '''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
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
