Difference between revisions of "Vital Signs Internal Tables"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(→‎DLRINFO Fields)
>Jeremyb
(→‎LN Fields)
Line 18: Line 18:
  
 
== LN Fields ==
 
== LN Fields ==
 +
 +
'''LN_AVAIL_CREDIT'''
 +
    The amount of available credit for the loan
 +
 +
'''LN_NBR_LATE_PMTS_LAST_3MTHS'''
 +
    The number of late payments over the past 3 months
 +
 +
'''LN_ACCOUNT'''
 +
    The account number of the loan
 +
 +
'''LN_ACTION'''
 +
    The action for this loan : "O","D","3"
 +
 +
'''LN_ACTION_DATE'''
 +
    The date the action was changed on the loan
 +
 +
'''LN_AMOUNT'''
 +
    The original amount of the loan
 +
 +
'''LN_APP_LT_NUMBER'''
 +
 +
'''LN_APP_NUMBER'''
 +
    The 3 digit loan application number
 +
 +
'''LN_APP_SSN'''
 +
    The loan application social security number
 +
 +
'''LN_APPLY_DATE'''
 +
    The date the loan was applied for
 +
 +
'''LN_APR'''
 +
    The loan APR
 +
 +
'''LN_BALANCE'''
 +
    The current loan balance
 +
 +
'''LN_BALLOON_PYMT_DT'''
 +
    The balloon payment date of the loan
 +
 +
'''LN_BRANCH'''
 +
    The current branch where the loan is serviced
 +
 +
'''LN_CF_CREDIT_CARD_LOAN'''
 +
    Flag indicating the loan is a credit card
 +
 +
'''LN_CF_LOC_LOAN'''
 +
    Flag indicating the loan is a line of credit
 +
 +
'''LN_CF_NO_LATE_NOTICES'''
 +
 +
'''LN_CF_OFFLINE_LOAN'''
 +
 +
'''LN_CF_OPEN_END_FLAG'''
 +
 +
'''LN_CF_REAL_ESTATE_LOAN'''
 +
    Flag indicating the loan is for Real Estate
 +
 +
'''LN_CF_STUDENT_INFO'''
 +
 +
'''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_COLL_AGENCY_CODE'''
 +
 +
'''LN_COLLATERAL'''
 +
    The 3 digit collateral number for the loan
 +
 +
'''LN_COLLATERAL_DESC'''
 +
    The description of the collateral for the loan
 +
 +
'''LN_COLLECTOR'''
 +
    The name of the collector on file 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_CREDIT_SSN'''
 +
   
 +
'''LN_CURE_DATE'''
 +
 +
'''LN_CYCLE_DATE'''
 +
 +
'''LN_DEALER_CODE'''
 +
    The dealer code on file for the loan
 +
 +
'''LN_DEBT_RATIO'''
 +
    The last Debt to Income ratio for the member
 +
 +
'''LN_DECISION_TELLER'''
 +
    The teller who approved the loan
 +
 +
'''LN_DECISION_TELLER_NAME'''
 +
    The name of the teller who approved the loan
 +
 +
'''LN_DECISION_TELLER_NAME_INTL'''
 +
    The initials of the teller who approved the loan
 +
 +
'''LN_DENIAL_NOTICE'''
 +
 +
'''LN_DENIAL_REASON'''
 +
 +
'''LN_DESCRIPTION'''
 +
    The description of the loan
 +
 +
'''LN_DISB_CHECK'''
 +
 +
'''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_FIRST_PAY_DATE'''
 +
    The date of the first loan payment
 +
 +
'''LN_FREQUENCY'''
 +
    The frequency for loan payments
 +
 +
'''LN_GROUP'''
 +
 +
'''LN_HIGH_BALANCE'''
 +
 +
'''LN_HIGHEST_DELQ_AMT'''
 +
    The highest amount of delinquent payments for the loan
 +
 +
'''LN_HIGHEST_DELQ_DT'''
 +
 +
'''LN_INSUR_CODES'''
 +
 +
'''LN_INSUR_TERM'''
 +
 +
'''LN_KTFR_ACCOUNT'''
 +
 +
'''LN_KTFR_SUFFIX'''
 +
 +
'''LN_LAST_ACCT_STATUS'''
 +
 +
'''LN_LAST_AMOUNT'''
 +
    The last amount of the loan balance
 +
 +
'''LN_LAST_APR'''
 +
    The last APR for the loan
 +
 +
'''LN_LAST_CHG_DATE'''
 +
    The last date the loan was modified
 +
 +
'''LN_LAST_CODE'''
 +
 +
'''LN_LAST_DATE'''
 +
    The date of the last monetary transaction
 +
 +
'''LN_LAST_INT_DATE'''
 +
    The date the last interest amount was calculated
 +
 +
'''LN_LAST_MONTHS_INT'''
 +
    The amount of interest calculated for last month
 +
 +
'''LN_LAST_PYMT_AMT'''
 +
    The amount of the last loan payment
 +
 +
'''LN_LAST_PYMT_DATE'''
 +
    The date of the last payment
 +
 +
'''LN_LAST_RATE_CHG_DT'''
 +
    The date the loan rate was changed
 +
 +
'''LN_MATURITY_DATE'''
 +
    The maturity date of the loan
 +
 +
'''LN_METHOD'''
 +
 +
'''LN_MICR_NUMBER'''
 +
    The micr number for the loan
 +
 +
'''LN_NAME'''
 +
    The member name on file for the loan
 +
 +
'''LN_NEXT_YEARS_INT'''
 +
    The amount of interest calculated for next year
 +
 +
'''LN_OCCUR_DATE'''
 +
 +
'''LN_OFFICER'''
 +
    The loan officer assigned to the loan
 +
 +
'''LN_OFFICER_NAME'''
 +
    The name of the loan officer assigned to the loan
 +
 +
'''LN_OFFICER_NAME_INTL'''
 +
    The initials of the loan officer assigned to the loan
 +
 +
'''LN_OFFLINE_SERVICER'''
 +
 +
'''LN_OLC_ENTRY_DATE'''
 +
 +
'''LN_ORIG_BRANCH'''
 +
    The original branch where the loan was opened
 +
 +
'''LN_ORIGINAL_APR'''
 +
    The original APR of the loan
 +
 +
'''LN_OVERLIMIT_DATE'''
 +
    The date the credit limit was overdrawn
 +
 +
'''LN_OVRD_OFFICER'''
 +
 +
'''LN_PAID_OFF_DATE'''
 +
    The date the loan was paid off
 +
 +
'''LN_PARTIAL_PAYMENT'''
 +
    The last partial payment for the loan
 +
 +
'''LN_PLEDGE_AMOUNT'''
 +
 +
'''LN_PLEDGE_CODE'''
 +
 +
'''LN_PMT_HISTORY'''
 +
    A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history
 +
 +
'''LN_PREV_COLLAT_CODE'''
 +
    The previous collateral code of the loan
 +
 +
'''LN_PREV_CYCLE_DATE'''
 +
 +
'''LN_PREV_INT_RATE'''
 +
    The previous interest rate of the loan
 +
 +
'''LN_PREV_MICR_NUM'''
 +
    The previous micr number of the loan
 +
 +
'''LN_PRIN_PMT_AMT'''
 +
 +
'''LN_PRIOR_YTD_INT'''
 +
    The prior year to date interest paid
 +
 +
'''LN_PURPOSE'''
 +
    The loan purpose code
 +
 +
'''LN_PYMT_AMOUNT1'''
 +
 +
'''LN_PYMT_CHANGE_DT1'''
 +
 +
'''LN_RECORDER'''
 +
    The loan officer who recorded the loan
 +
 +
'''LN_RECORDER_NAME'''
 +
    The name of the loan officer who recorded the loan
 +
 +
'''LN_RECORDER_NAME_INTL'''
 +
    The initials of the loan officer who recorded the loan
 +
 +
'''LN_REST_FLAG_11'''
 +
    The rest-flag-11 field for the loan
 +
 +
'''LN_REST_FLAG_12'''
 +
    The rest-flag-12 field for the loan
 +
 +
'''LN_REVIEW_DATE'''
 +
    The date the loan was reviewed
 +
 +
'''LN_SECURE_UNSECURE_FLAG'''
 +
    Flag indicating that the loan is secured by collateral or not
 +
 +
'''LN_SELLER'''
 +
    The teller who sold the loan
 +
 +
'''LN_SELLER_NAME'''
 +
    The name of the teller who sold the loan
 +
 +
'''LN_SELLER_NAME_INTL'''
 +
    The initials of the teller who sold the loan
 +
 +
'''LN_STATUS'''
 +
    The status of the loan : (N)ew or (R)efinanced
 +
 +
'''LN_SUFFIX'''
 +
    The suffix of the loan
 +
 +
'''LN_TERM'''
 +
    The term of the loan
 +
 +
'''LN_THIRD_PARTY_KEY'''
 +
 +
'''LN_VAR_RATE_CODE'''
 +
 +
'''LN_VEHICLE_INFO_KEY'''
 +
    The key to link into vehicle-info
 +
 +
'''LN_VRL_INDEX'''
 +
 +
'''LN_VRL_MARGIN'''
 +
 +
'''LN_YTD_INT'''
 +
    The year to date interest paid on the loan
 +
 +
'''LN_NBR_LATE_PMTS'''
 +
    The number of late payment made on the loan
  
 
== LNADDM Fields ==
 
== LNADDM Fields ==

Revision as of 20:16, 4 September 2012

Overview

The definitions of the Tables and Fields available in Vital Signs

Tables

MBR SH LN LNADDM LNAPP LNTERMS DLRINFO VEHCINFO

MBR Fields

SH Fields

LN Fields

LN_AVAIL_CREDIT 

   The amount of available credit for the loan

LN_NBR_LATE_PMTS_LAST_3MTHS 

   The number of late payments over the past 3 months

LN_ACCOUNT 

   The account number of the loan

LN_ACTION 

   The action for this loan : "O","D","3"

LN_ACTION_DATE 

   The date the action was changed on the loan

LN_AMOUNT 

   The original amount of the loan

LN_APP_LT_NUMBER

LN_APP_NUMBER 

   The 3 digit loan application number

LN_APP_SSN 

   The loan application social security number

LN_APPLY_DATE 

   The date the loan was applied for

LN_APR 

   The loan APR

LN_BALANCE 

   The current loan balance

LN_BALLOON_PYMT_DT 

   The balloon payment date of the loan

LN_BRANCH 

   The current branch where the loan is serviced

LN_CF_CREDIT_CARD_LOAN 

   Flag indicating the loan is a credit card

LN_CF_LOC_LOAN 

   Flag indicating the loan is a line of credit

LN_CF_NO_LATE_NOTICES

LN_CF_OFFLINE_LOAN

LN_CF_OPEN_END_FLAG

LN_CF_REAL_ESTATE_LOAN 

   Flag indicating the loan is for Real Estate

LN_CF_STUDENT_INFO

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_COLL_AGENCY_CODE

LN_COLLATERAL 

   The 3 digit collateral number for the loan

LN_COLLATERAL_DESC 

   The description of the collateral for the loan

LN_COLLECTOR 

   The name of the collector on file 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_CREDIT_SSN

LN_CURE_DATE

LN_CYCLE_DATE

LN_DEALER_CODE 

   The dealer code on file for the loan

LN_DEBT_RATIO 

   The last Debt to Income ratio for the member

LN_DECISION_TELLER 

   The teller who approved the loan

LN_DECISION_TELLER_NAME 

   The name of the teller who approved the loan

LN_DECISION_TELLER_NAME_INTL 

   The initials of the teller who approved the loan

LN_DENIAL_NOTICE

LN_DENIAL_REASON

LN_DESCRIPTION 

   The description of the loan

LN_DISB_CHECK

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_FIRST_PAY_DATE 

   The date of the first loan payment

LN_FREQUENCY 

   The frequency for loan payments

LN_GROUP

LN_HIGH_BALANCE

LN_HIGHEST_DELQ_AMT 

   The highest amount of delinquent payments for the loan

LN_HIGHEST_DELQ_DT

LN_INSUR_CODES

LN_INSUR_TERM

LN_KTFR_ACCOUNT

LN_KTFR_SUFFIX

LN_LAST_ACCT_STATUS

LN_LAST_AMOUNT 

   The last amount of the loan balance

LN_LAST_APR 

   The last APR for the loan

LN_LAST_CHG_DATE 

   The last date the loan was modified

LN_LAST_CODE

LN_LAST_DATE 

   The date of the last monetary transaction

LN_LAST_INT_DATE 

   The date the last interest amount was calculated

LN_LAST_MONTHS_INT 

   The amount of interest calculated for last month

LN_LAST_PYMT_AMT 

   The amount of the last loan payment

LN_LAST_PYMT_DATE 

   The date of the last payment

LN_LAST_RATE_CHG_DT 

   The date the loan rate was changed

LN_MATURITY_DATE 

   The maturity date of the loan

LN_METHOD

LN_MICR_NUMBER 

   The micr number for the loan

LN_NAME 

   The member name on file for the loan

LN_NEXT_YEARS_INT 

   The amount of interest calculated for next year

LN_OCCUR_DATE

LN_OFFICER 

   The loan officer assigned to the loan

LN_OFFICER_NAME 

   The name of the loan officer assigned to the loan

LN_OFFICER_NAME_INTL 

   The initials of the loan officer assigned to the loan

LN_OFFLINE_SERVICER

LN_OLC_ENTRY_DATE

LN_ORIG_BRANCH 

   The original branch where the loan was opened

LN_ORIGINAL_APR 

   The original APR of the loan

LN_OVERLIMIT_DATE 

   The date the credit limit was overdrawn

LN_OVRD_OFFICER

LN_PAID_OFF_DATE 

   The date the loan was paid off

LN_PARTIAL_PAYMENT 

   The last partial payment for the loan

LN_PLEDGE_AMOUNT

LN_PLEDGE_CODE

LN_PMT_HISTORY 

   A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history

LN_PREV_COLLAT_CODE 

   The previous collateral code of the loan

LN_PREV_CYCLE_DATE

LN_PREV_INT_RATE 

   The previous interest rate of the loan

LN_PREV_MICR_NUM 

   The previous micr number of the loan

LN_PRIN_PMT_AMT

LN_PRIOR_YTD_INT 

   The prior year to date interest paid

LN_PURPOSE 

   The loan purpose code

LN_PYMT_AMOUNT1

LN_PYMT_CHANGE_DT1

LN_RECORDER 

   The loan officer who recorded the loan

LN_RECORDER_NAME 

   The name of the loan officer who recorded the loan

LN_RECORDER_NAME_INTL 

   The initials of the loan officer who recorded the loan

LN_REST_FLAG_11 

   The rest-flag-11 field for the loan

LN_REST_FLAG_12 

   The rest-flag-12 field for the loan

LN_REVIEW_DATE 

   The date the loan was reviewed

LN_SECURE_UNSECURE_FLAG 

   Flag indicating that the loan is secured by collateral or not

LN_SELLER 

   The teller who sold the loan

LN_SELLER_NAME 

   The name of the teller who sold the loan

LN_SELLER_NAME_INTL 

   The initials of the teller who sold the loan

LN_STATUS 

   The status of the loan : (N)ew or (R)efinanced

LN_SUFFIX 

   The suffix of the loan

LN_TERM 

   The term of the loan

LN_THIRD_PARTY_KEY

LN_VAR_RATE_CODE

LN_VEHICLE_INFO_KEY 

   The key to link into vehicle-info

LN_VRL_INDEX

LN_VRL_MARGIN

LN_YTD_INT 

   The year to date interest paid on the loan

LN_NBR_LATE_PMTS 

   The number of late payment made on the loan

LNADDM Fields

LNAPP Fields

LNTERMS Fields

DLRINFO Fields

DLR_ADDR1 

   The dealer's address lines 1

DLR_ADDR2 

   The dealer's address lines 2

DLR_ADDR3 

   The dealer's address lines 3

DLR_CHECK_MIN

DLR_CITY 

   The city the dealer is located in

DLR_COUNTRY_CODE 

   The dealer's 2 digit country code

DLR_DEALER_GRADE 

  The grade associated with the dealer

DLR_FEE_CODE

DLR_FEE_FIXED

DLR_FEE_FLAG

DLR_FEE_MAXIMUM

DLR_NAME 

   The name of the dealer

DLR_PHONE 

   The phone number for the dealer

DLR_PTD_COUNT

DLR_PTD_FEE_AMOUNT

DLR_PTD_LOAN_AMOUNT

DLR_PY_COUNT

DLR_PY_FEE_AMOUNT

DLR_PY_LOAN_AMOUNT

DLR_RESERVE_AMT

DLR_STATE 

   The state the dealership is located in

DLR_TTD_COUNT

DLR_TTD_FEE_AMOUNT

DLR_TTD_LOAN_AMOUNT

DLR_YTD_COUNT

DLR_YTD_FEE_AMOUNT

DLR_YTD_LOAN_AMOUNT

DLR_ZIP

VEHCINFO Fields

Retrieved from "https://wiki.vital-soft.com/index.php?title=Vital_Signs_Internal_Tables&oldid=643"