Difference between revisions of "Vital Signs Internal Tables"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(→‎LN Fields)
>Jeremyb
 
(6 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
== Tables ==
 
== Tables ==
 
'''MBR'''
 
'''MBR'''
 +
    Member Level Fields
 +
 
'''SH'''
 
'''SH'''
 +
    Share Level Fields
 +
 
'''LN'''
 
'''LN'''
 +
    Loan Level Fields
 +
 
'''LNADDM'''
 
'''LNADDM'''
 +
    Loan Addendum Fields
 +
 
'''LNAPP'''
 
'''LNAPP'''
 +
    Loanapp Fields (Spectrum Core Lender)
 +
 
'''LNTERMS'''
 
'''LNTERMS'''
 +
    Loan Terms Fields
 +
 
'''DLRINFO'''
 
'''DLRINFO'''
 +
    Dealer Info Fields
 +
 
'''VEHCINFO'''
 
'''VEHCINFO'''
 +
    Vehicle Info Fields
 +
  
 
== MBR Fields ==
 
== MBR Fields ==
 +
 +
'''MBR_ACCOUNT'''
 +
    The member account number
 +
 +
'''MBR_ACCT_AGE'''
 +
    The age of the member account
 +
 +
'''MBR_ACTIVE_LN_BAL'''
 +
    Count of active loans belonging to the member
 +
 +
'''MBR_ACTIVE_LN_CNT'''
 +
    Count of active loans belonging to the member
 +
 +
'''MBR_ACTIVE_SH_BAL'''
 +
    Balance of active shares belonging to the member
 +
 +
'''MBR_ACTIVE_SH_CNT'''
 +
    Count of active shares belonging to the member
 +
 +
'''MBR_ADDR1'''
 +
    The first address line
 +
 +
'''MBR_ADDR2'''
 +
    The second address line
 +
 +
'''MBR_ADDR3'''
 +
    The third address line
 +
 +
'''MBR_AFFINITY_CODE'''
 +
 +
'''MBR_AGE'''
 +
    The age of the member
 +
 +
'''MBR_AGE_AS_DECIMAL'''
 +
    The age of the member in decimal form
 +
 +
'''MBR_BIRTH_DATE'''
 +
    The member birth date
 +
 +
'''MBR_BRANCH'''
 +
    The current branch for the member account
 +
 +
'''MBR_CELL_PHONE'''
 +
    The member cell phone number
 +
 +
'''MBR_CF_ACCT_IN_COLLECT'''
 +
    Flag indicating the member has a loan in collections
 +
 +
'''MBR_CF_ATM_FLAG'''
 +
    Flag indicating the member has an ATM card
 +
 +
'''MBR_CF_BAD_ADDR'''
 +
    Flag indicating the member has a bad address
 +
 +
'''MBR_CF_CAPTURE_ATM_CARD'''
 +
    Flag indicating the member ATM card should be captured
 +
 +
'''MBR_CF_CC_ACCT'''
 +
    Flag indicating the member owns a credit card
 +
 +
'''MBR_CF_CHGOFF_LOAN'''
 +
    Flag indicating the member has a charged off loan
 +
 +
'''MBR_CF_CHGOFF_SHARE'''
 +
    Flag indicating the member has a charged off share
 +
 +
'''MBR_CF_DECEASED'''
 +
    Flag indicating the member is deceased
 +
 +
'''MBR_CF_NO_LABELS'''
 +
 +
'''MBR_CF_NO_MAIL'''
 +
    Flag indicating the member does not wish to receive mail
 +
 +
'''MBR_CF_SEND_MTHLY_STMT'''
 +
    Flag indicating the member receives monthly statements
 +
 +
'''MBR_CF_STMTS_TO_CU'''
 +
 +
'''MBR_CHG_LN_BAL'''
 +
 +
'''MBR_CHG_LN_CNT'''
 +
 +
'''MBR_CHG_SH_BAL'''
 +
 +
'''MBR_CHG_SH_CNT'''
 +
 +
'''MBR_CITIZENSHIP'''
 +
    The Country of Citenzenship for the member
 +
 +
'''MBR_CITY'''
 +
    The city of the member's account
 +
 +
'''MBR_CLASS_CODE'''
 +
   
 +
'''MBR_CLOSE_DATE'''
 +
    The date the member account was closed
 +
 +
'''MBR_COUNT'''
 +
 +
'''MBR_COUNTRY_CODE'''
 +
    The country 2 digit code for the member account
 +
 +
'''MBR_CREDIT_SCORE'''
 +
    The credit score associated with the member account
 +
 +
'''MBR_CURE_DATE'''
 +
 +
'''MBR_DEPARTMENT'''
 +
    The department associated with this member
 +
   
 +
'''MBR_DRIVER_LIC_NUM'''
 +
    The member drivers license number
 +
 +
'''MBR_DRIVER_LIC_STATE'''
 +
    The state where the member's drivers license was issued
 +
 +
'''MBR_E_MAIL'''
 +
    The member's e-mail address
 +
 +
'''MBR_ELIGIBILITY'''
 +
 +
'''MBR_EMPL_NUM'''
 +
 +
'''MBR_EMPL_STATUS'''
 +
    The employment status of the member
 +
 +
'''MBR_EMPLOYER_NAME'''
 +
    The name on file for the member employer
 +
 +
'''MBR_ESCHEAT_DATE'''
 +
    The escheat date for the member account
 +
 +
'''MBR_FAX_NUMBER'''
 +
 +
'''MBR_FINAL_CLOSE_DATE'''
 +
    The final date the member account was closed
 +
 +
'''MBR_FINAL_CLOSE_MTH'''
 +
    The month the member account was closed
 +
 +
'''MBR_FIRST_NAME'''
 +
    The first name of the member
 +
 +
'''MBR_FULL_NAME'''
 +
    The full name of the member
 +
 +
'''MBR_GROUP'''
 +
 +
'''MBR_HOUSEHOLD'''
 +
 +
'''MBR_HOUSEHOLD_CODE'''
 +
 +
'''MBR_LAST_CHG_DATE'''
 +
    The date of the last change made to the member's account
 +
 +
'''MBR_LAST_NAME'''
 +
    The last name of the member
 +
 +
'''MBR_LTD_BRANCH'''
 +
 +
'''MBR_LTD_COLLATERAL'''
 +
 +
'''MBR_LTD_DATE'''
 +
 +
'''MBR_LTD_OFFICER'''
 +
 +
'''MBR_MAIDEN_NAME'''
 +
    The maiden name of the member
 +
 +
'''MBR_MARITAL_STATUS'''
 +
    The marital status of the member
 +
 +
'''MBR_MIDDLE_NAME'''
 +
    The middle name of the member
 +
 +
'''MBR_MONTHLY_ADB1'''
 +
    The average daily balance for the past 1 month
 +
 +
'''MBR_MONTHLY_ADB2'''
 +
    The average daily balance for 2 months prior
 +
 +
'''MBR_MONTHLY_ADB3'''
 +
    The average daily balance for 2 months prior
 +
 +
'''MBR_NAME_CHG_DATE'''
 +
    The date when the member changed their name
 +
 +
'''MBR_OLC_COUNT'''
 +
 +
'''MBR_OLC_ENTRY_DATE'''
 +
 +
'''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_ORIG_OPEN_MTH'''
 +
    The original month the member opened their account
 +
 +
'''MBR_PAGER_PHONE'''
 +
    The pager number for the member account
 +
 
 +
'''MBR_PHONE'''
 +
    The member's phone number
 +
 +
'''MBR_PRIOR_YTD_DIV'''
 +
 +
'''MBR_PRIOR_YTD_INT'''
 +
 +
'''MBR_PROFESSION_YEARS'''
 +
    The number of years the member has been in their line of work
 +
 +
'''MBR_RECORDER'''
 +
    The teller who opened the member account
 +
 +
'''MBR_RECORDER_NAME'''
 +
    The name of the teller who opened the member account
 +
 +
'''MBR_RECORDER_NAME_INTL'''
 +
    The initials of the teller who opened the member's account
 +
 +
'''MBR_REF'''
 +
    The ref field from the member-file record on a Spectrum core
 +
 +
'''MBR_REF2'''
 +
    The ref2 field from the member-file record on a Spectrum core
 +
 +
'''MBR_REF3'''
 +
    The ref3 field from the member-file record on a Spectrum core
 +
 +
'''MBR_REF4'''
 +
    The ref4 field from the member-file record on a Spectrum core
 +
 +
'''MBR_REFER'''
 +
 +
'''MBR_RELATE_FLAG'''
 +
    The relate flag for the member account
 +
 +
'''MBR_RESIDENCE_CODE'''
 +
 +
'''MBR_REST_FLAG_11'''
 +
    The rest-flag-11 field on a Spectrum core
 +
 +
'''MBR_REST_FLAG_12'''
 +
    The rest-flag-12 field on a Spectrum core
 +
 +
'''MBR_SELF_EMPLOYED'''
 +
    The member's self employed status
 +
 +
'''MBR_SELLER'''
 +
    The teller who opened the member account
 +
 +
'''MBR_SELLER_NAME'''
 +
    The name of the teller who opened the member account
 +
 +
'''MBR_SELLER_NAME_INTL'''
 +
    The initials of the teller who opened the member account
 +
 +
'''MBR_SEX'''
 +
    The sex of the member
 +
 +
'''MBR_SSN_NUM'''
 +
    The member's Social Security Number
 +
 +
'''MBR_STATE'''
 +
    The state on file for the member 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_WORK_PHONE'''
 +
    The member's work phone
 +
 +
'''MBR_YTD_INT'''
 +
    The year to date interest for the member account
 +
 +
'''MBR_ZIP'''
 +
    The zip code on file for the member account
 +
 +
'''MBR ZIP+4'''
 +
    The member's full zipcode including the last 4 digits
 +
 +
'''MBR_SSN_FMT'''
 +
    The member's formatted SSN xxx-xx-xxxx
  
 
== SH Fields ==
 
== SH Fields ==
 +
 +
'''SH_CERT_MAT_DATE'''
 +
    The certificate maturity date
 +
 +
'''SH_CERT_MAT_DATE_MTH'''
 +
    The certificate maturity month
 +
 +
'''SH_ACC'''
 +
    The Share ACC Code
 +
 +
'''SH_ACCOUNT'''
 +
    The 9 digit share account number
 +
 +
'''SH_ACCRUED_DIV'''
 +
    The accrued dividends for the share
 +
 +
'''SH_ACCUM_DIVIDEND'''
 +
    The accumulated dividends for the share
 +
 +
'''SH_ADB_DAYS'''
 +
    The Average Daily Balance Days
 +
 +
'''SH_BALANCE'''
 +
    The share balance
 +
 +
'''SH_BRANCH'''
 +
    The current branch of the share
 +
 +
'''SH_CD_FLAG'''
 +
    Flag indicating if the share is a Certificate of Deposit
 +
 +
'''SH_CERT_ADJ_VAL_LS1'''
 +
 +
'''SH_CERT_DIV_REG_LS2'''
 +
 +
'''SH_CERT_DIV_TOT_LS3'''
 +
 +
'''SH_CERT_FOR_AMT_LS5'''
 +
 +
'''SH_CERT_MAT_DT_LS4'''
 +
    The certificate maturity date
 +
 +
'''SH_CERT_NUMBER_LS6'''
 +
 +
'''SH_CERT_ROLLOVER_DATE'''
 +
    The date the certificate rolled over to a new certificate
 +
 +
'''SH_CF_ADDON_CERT'''
 +
 +
'''SH_CF_ALL_SAVERS_CERT'''
 +
 +
'''SH_CF_ATM_REGD'''
 +
 +
'''SH_CF_AUTO_XFER'''
 +
 +
'''SH_CF_CERT_FLAG'''
 +
    Flag indicating the share is a certificate
 +
 +
'''SH_CF_DEBIT_CARD'''
 +
    Flag indicating the share has a debit card
 +
 +
'''SH_CF_IRA_ACCT'''
 +
    Flag indicating the share is an IRA
 +
 +
'''SH_CF_NO_ACTIVITY_FLAG'''
 +
    Flag indicating the share has no activity
 +
 +
'''SH_CF_SHARE_DRAFT_ACCT'''
 +
    Flag indicating the share is a checking account
 +
 +
'''SH_CF_SSN_VERIF_REQD'''
 +
    Flag indicating that a SSN number must be verified
 +
 +
'''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_COLLECTOR'''
 +
    The name of the collector on this share
 +
 +
'''SH_COUNT'''
 +
 +
'''SH_DESC_ABRV'''
 +
    The share description abbreviation
 +
 +
'''SH_DESC_ABRV_LONGDESC'''
 +
    The long form of the share description abbreviation
 +
 +
'''SH_DESCRIPTION'''
 +
    The share description
 +
 +
'''SH_DIV_PAID_DATE'''
 +
    The last date dividends were posted to the share
 +
 +
'''SH_DIV_PERIOD_DAYS'''
 +
    The number of days that dividends were calculated and paid out to the share
 +
 +
'''SH_DIV_RATE'''
 +
    The dividend rate for the share
 +
 +
'''SH_DIV_WHH_AMT'''
 +
    The amount of dividends to be withheld
 +
 +
'''SH_DOLLAR_DAYS'''
 +
 +
'''SH_DRAFT_ACCT'''
 +
 +
'''SH_ENTRY_AMOUNT'''
 +
    The balance of the share when it was opened
 +
 +
'''SH_ENTRY_DATE'''
 +
    The date the share was opened
 +
 +
'''SH_HI_NEG_AMT'''
 +
    The largest amount negative the share has been
 +
 +
'''SH_INSUR_CODES'''
 +
 +
'''SH_IRA_FLAG'''
 +
    A flag indicating the share is an IRA
 +
 +
'''SH_IRA_TYPE'''
 +
    A description of the type of IRA the share is
 +
 +
'''SH_KITE_RESET_DATE'''
 +
 +
'''SH_LAST_AMOUNT'''
 +
 +
'''SH_LAST_CHG_DATE'''
 +
 +
'''SH_LAST_CODE'''
 +
 +
'''SH_LAST_DATE'''
 +
 +
'''SH_LAST_DIV_CALC'''
 +
 +
'''SH_LAST_DIV_PAID'''
 +
    The last dividend amount paid to the share
 +
 +
'''SH_LAST_NSF_DATE'''
 +
    The date the share last posted a NSF fee
 +
 +
'''SH_LAST_PAID_NSF'''
 +
    The date of the last paid NSF fee
 +
 +
'''SH_LAST_PBF_AMOUNT'''
 +
 +
'''SH_LAST_PBF_DATE'''
 +
 +
'''SH_LAST_STMT_DATE'''
 +
 +
'''SH_LTD_NSF_COUNTER'''
 +
 +
'''SH_MAT_DISP'''
 +
 +
'''SH_MICR_NUMBER'''
 +
    The MICR number for the share
 +
 +
'''SH_MONTHLY_ADB1'''
 +
    The share average daily balance for the past month
 +
 +
'''SH_MTD_NSF_COUNTER'''
 +
    The number of NSF fee given month to date
 +
 +
'''SH_MTD_PAID_NSF'''
 +
    The number of paid NSF fees month to date
 +
 +
'''SH_NAME'''
 +
    The member name on file for the share
 +
 +
'''SH_NEG_DATE'''
 +
    The date the share balance became negative
 +
 +
'''SH_OPEN_DATE'''
 +
    The open date of the share
 +
 +
'''SH_ORIG_BRANCH'''
 +
    The original branch where the share was opened
 +
 +
'''SH_ORIG_TERM'''
 +
 +
'''SH_ORIG_TERM_TYPE'''
 +
 +
'''SH_OWNER'''
 +
    The name of the owner of the share
 +
 +
'''SH_PERIOD_LOW_BAL'''
 +
 +
'''SH_PLEDGE_AMOUNT'''
 +
 +
'''SH_PREV_DESC_ABRV'''
 +
    The share previous description abreviation
 +
 +
'''SH_PREV_DIV_CDAYS'''
 +
 +
'''SH_PRIOR_DIV_RATE'''
 +
    The share prior dividend rate
 +
 +
'''SH_PRIOR_YTD_DIV'''
 +
    The share prior year to date total dividends
 +
 +
'''SH_PRIOR_YTD_FOR'''
 +
 +
'''SH_PTD_WTHDRAWLS'''
 +
 +
'''SH_PV_DIV_WHH_AMT'''
 +
 +
'''SH_RECORDER'''
 +
    The teller who recorded the share
 +
 +
'''SH_RECORDER_NAME'''
 +
    The name of the teller who recorded the share
 +
 +
'''SH_RECORDER_NAME_INTL'''
 +
    The initials of the teller who recorded the share
 +
 +
'''SH_REGD_CHECKS'''
 +
 +
'''SH_REGD_WTHDRAWLS'''
 +
    The number of Regd transaction this month
 +
 +
'''SH_RESET_DIV_DATE'''
 +
 +
'''SH_ROLL_ACC'''
 +
 +
'''SH_ROLL_AMOUNT_CHG'''
 +
 +
'''SH_ROLL_SDA'''
 +
 +
'''SH_ROLL_TERM'''
 +
 +
'''SH_ROLL_TERM_TYPE'''
 +
 +
'''SH_SELLER'''
 +
    The teller who opened the share with the member
 +
 +
'''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_TARGET_AMOUNT'''
 +
 +
'''SH_TD_PAID_NSF'''
 +
 +
'''SH_TIN_TYPE'''
 +
 +
'''SH_YTD_DIV'''
 +
    The year to date dividends paid out
 +
 +
'''SH_YTD_NSF_COUNTER'''
 +
    The year to date NSFs for this share
 +
 +
'''SH_YTD_PAID_NSF'''
 +
    The year to date paid NSF fees for this share
  
 
== LN Fields ==
 
== LN Fields ==
Line 334: Line 921:
  
 
== LNADDM Fields ==
 
== LNADDM Fields ==
 +
 +
'''LNADDM_ACC'''
 +
 +
'''LNADDM_ACCOUNT'''
 +
 +
'''LNADDM_ACCRUED_DIV'''
 +
 +
'''LNADDM_ACCUM_DIVIDEND'''
 +
 +
'''LNADDM_AMORT_TERM'''
 +
 +
'''LNADDM_AMORT_TYPE'''
 +
 +
'''LNADDM_AMOUNT_LAST_TRAN'''
 +
 +
'''LNADDM_APPRAISAL_AMOUNT'''
 +
 +
'''LNADDM_APPRAISAL_DATE'''
 +
 +
'''LNADDM_APR_LOCK_DATE'''
 +
 +
'''LNADDM_BUILDER'''
 +
 +
'''LNADDM_CO_HMDA_ETHNIC'''
 +
 +
'''LNADDM_CO_HMDA_RACES'''
 +
 +
'''LNADDM_CO_HMDA_SEX'''
 +
 +
'''LNADDM_COMMENT'''
 +
 +
'''LNADDM_COMMIT_DATE'''
 +
 +
'''LNADDM_CONDO_PUD_NAME'''
 +
 +
'''LNADDM_CONTRACTOR'''
 +
 +
'''LNADDM_COUNTY_CODE'''
 +
 +
'''LNADDM_CURR_LATE_CRG'''
 +
 +
'''LNADDM_CUSHION_AMOUNT'''
 +
 +
'''LNADDM_CUSHION_RATE'''
 +
 +
'''LNADDM_DEFICIENCY'''
 +
 +
'''LNADDM_DELQ_ADJUST_AMOUNT'''
 +
 +
'''LNADDM_DELQ_DATE'''
 +
 +
'''LNADDM_DESC_ABRV'''
 +
 +
'''LNADDM_DIV_PAID_DATE'''
 +
 +
'''LNADDM_DIV_WHH_AMT'''
 +
 +
'''LNADDM_DRAW_COUNT'''
 +
 +
'''LNADDM_DRAW_LIMIT'''
 +
 +
'''LNADDM_DWELLING_TYPE'''
 +
 +
'''LNADDM_EDA_FLAG'''
 +
 +
'''LNADDM_EFF_DATE_LAST_TRAN'''
 +
 +
'''LNADDM_ESCROW_AMT_CHG_DATE'''
 +
 +
'''LNADDM_ESCROW_BALANCE'''
 +
    The Escrow balance
 +
 +
'''LNADDM_ESCROW_CENTS_DAYS'''
 +
 +
'''LNADDM_ESCROW_DUE_DATE'''
 +
 +
'''LNADDM_ESCROW_ENTRY_DATE'''
 +
 +
'''LNADDM_ESCROW_LAST_CHG_DATE'''
 +
 +
'''LNADDM_ESCROW_PMT_AMOUNT'''
 +
 +
'''LNADDM_ESCROW_PRIOR_AMOUNT'''
 +
 +
'''LNADDM_FED_MAX_CUSHION'''
 +
 +
'''LNADDM_FIN_INST_FTB_FLD'''
 +
 +
'''LNADDM_FIRST_RT_CHG_DATE'''
 +
 +
'''LNADDM_FORCLS_MIADJ_FLD'''
 +
 +
'''LNADDM_GROSS_ANNUAL_INCOME'''
 +
 +
'''LNADDM_HMDA_ETHNIC'''
 +
 +
'''LNADDM_HMDA_OCCUP_CODE'''
 +
 +
'''LNADDM_HMDA_RACES'''
 +
 +
'''LNADDM_HMDA_SEX'''
 +
 +
'''LNADDM_HOEPA_STATUS'''
 +
 +
'''LNADDM_IMPROVE_AMOUNT'''
 +
 +
'''LNADDM_INSPECTION_DATE'''
 +
 +
'''LNADDM_INT_ONLY_END_DATE'''
 +
 +
'''LNADDM_INVESTOR_ACTION_CODE'''
 +
 +
'''LNADDM_INVESTOR_ACTION_DATE'''
 +
 +
'''LNADDM_INVESTOR_LOAN_NUMBER'''
 +
 +
'''LNADDM_INVESTOR_PKG_KEY'''
 +
 +
'''LNADDM_INVESTOR_PTD_FEES'''
 +
 +
'''LNADDM_INVESTOR_PTD_INT'''
 +
 +
'''LNADDM_INVESTOR_PTD_PRINCIPAL'''
 +
 +
'''LNADDM_INVESTOR_PTD_PYMNTS'''
 +
 +
'''LNADDM_INVESTOR_STATUS'''
 +
 +
'''LNADDM_LAST_ANLY_DATE'''
 +
 +
'''LNADDM_LAST_DIV_CALC'''
 +
 +
'''LNADDM_LAST_DIV_PAID'''
 +
 +
'''LNADDM_LAST_MONETARY_AMOUNT'''
 +
 +
'''LNADDM_LAST_MONETARY_CODE'''
 +
 +
'''LNADDM_LAST_MONETARY_DATE'''
 +
 +
'''LNADDM_LAST_RUN_DATE'''
 +
 +
'''LNADDM_LIEN_STATUS'''
 +
 +
'''LNADDM_LOAN_FEATURE'''
 +
 +
'''LNADDM_MERS_NUMBER'''
 +
 +
'''LNADDM_MI_CERT_NUMBER'''
 +
 +
'''LNADDM_MI_PERCENT'''
 +
 +
'''LNADDM_MIN_PAYMENT'''
 +
 +
'''LNADDM_MISC_INSUR_AMOUNT'''
 +
 +
'''LNADDM_MONTH_DEBT_EXP'''
 +
 +
'''LNADDM_MONTH_HOUSE_EXP'''
 +
 +
'''LNADDM_MORT_INS_CODE'''
 +
 +
'''LNADDM_MORTGAGE_MARGIN'''
 +
 +
'''LNADDM_MORTGAGE_TYPE'''
 +
 +
'''LNADDM_NEXT_ANLY_DATE'''
 +
 +
'''LNADDM_NUMB_BORROWERS'''
 +
 +
'''LNADDM_NUMBER_OF_UNITS'''
 +
 +
'''LNADDM_ORIG_MONTHLY_PI'''
 +
 +
'''LNADDM_ORIGINAL_LTV'''
 +
 +
'''LNADDM_OTHER_FINANCING'''
 +
 +
'''LNADDM_OWNER_OCCUPIED'''
 +
 +
'''LNADDM_PAYMENT_ADJUST'''
 +
 +
'''LNADDM_PERCENT_DONE'''
 +
 +
'''LNADDM_PERIOD_LOW_BAL'''
 +
 +
'''LNADDM_POINTS'''
 +
 +
'''LNADDM_PORTION_PAID'''
 +
 +
'''LNADDM_PRE_APRVL_REQ'''
 +
 +
'''LNADDM_PREPAID_ACCRUAL'''
 +
 +
'''LNADDM_PREV_YEAR_INSURANCE'''
 +
 +
'''LNADDM_PREV_YEAR_OTHER'''
 +
 +
'''LNADDM_PRIOR_YTD_DIV'''
 +
 +
'''LNADDM_PRIOR_YTD_PMI'''
 +
 +
'''LNADDM_PRIOR_YTD_TAX'''
 +
 +
'''LNADDM_PROJECT_CLASS'''
 +
 +
'''LNADDM_PROJECT_DUE'''
 +
 +
'''LNADDM_PROPERTY_ADDR'''
 +
 +
'''LNADDM_PROPERTY_CITY'''
 +
 +
'''LNADDM_PROPERTY_STATE'''
 +
 +
'''LNADDM_PROPERTY_TYPE'''
 +
 +
'''LNADDM_PROPERTY_ZIP'''
 +
 +
'''LNADDM_PURCHASE_DOC'''
 +
 +
'''LNADDM_PURCHASER_TYPE'''
 +
 +
'''LNADDM_PV_DIV_WHH_AMT'''
 +
 +
'''LNADDM_RATE_SPREAD'''
 +
 +
'''LNADDM_REFUND_DATE'''
 +
 +
'''LNADDM_REFUND_METHOD'''
 +
 +
'''LNADDM_SALES_PRICE'''
 +
 +
'''LNADDM_SECND_LIEN_HLDR'''
 +
 +
'''LNADDM_SECTION_ACT'''
 +
 +
'''LNADDM_SHORTAGE'''
 +
 +
'''LNADDM_ST_CUSHION_AMT'''
 +
 +
'''LNADDM_ST_CUSHION_RATE'''
 +
 +
'''LNADDM_SUBSIDY_PMT_AMOUNT'''
 +
 +
'''LNADDM_SUFFIX'''
 +
 +
'''LNADDM_SURPLUS'''
 +
 +
'''LNADDM_UNDISTR_BALANCE'''
 +
 +
'''LNADDM_YTD_DIV'''
 +
 +
'''LNADDM_YTD_INSURANCE'''
 +
 +
'''LNADDM_YTD_OTHER'''
 +
 +
'''LNADDM_YTD_PMI'''
 +
 +
'''LNADDM_YTD_TAX'''
  
 
== LNAPP Fields ==
 
== LNAPP Fields ==
 +
 +
'''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
  
 
== LNTERMS Fields ==
 
== LNTERMS Fields ==
 +
 +
'''LNTERMS_ACCOUNT'''
 +
    The loan account number
 +
 +
'''LNTERMS_ACTION'''
 +
    The loan action
 +
 +
'''LNTERMS_ALT_AMOUNT'''
 +
 +
'''LNTERMS_ALT_NUMBER'''
 +
 +
'''LNTERMS_ALT_START_DATE'''
 +
 +
'''LNTERMS_AMOUNT'''
 +
    The loan amount
 +
 +
'''LNTERMS_APP_KEY'''
 +
    The loan application key
 +
 +
'''LNTERMS_APR'''
 +
    The loan apr
 +
 +
'''LNTERMS_AUTO_CALC_INT'''
 +
 +
'''LNTERMS_BALLOON_PYMT_DATE'''
 +
    The loan balloon payment date
 +
 +
'''LNTERMS_CASH_APR'''
 +
 +
'''LNTERMS_CENSUS_TRACT'''
 +
 +
'''LNTERMS_COLLATERAL'''
 +
    The loan collateral
 +
 +
'''LNTERMS_DESCRIPTION'''
 +
    The loan description
 +
 +
'''LNTERMS_DIS_INSUR_AMT'''
 +
 +
'''LNTERMS_DISBURSAL_DATE'''
 +
 +
'''LNTERMS_DISCLOSURE_CODE'''
 +
 +
'''LNTERMS_DRAFT_ACCT'''
 +
 +
'''LNTERMS_DUE_DATE'''
 +
 +
'''LNTERMS_ENTRY_DATE'''
 +
    The loan open date
 +
 +
'''LNTERMS_FINAL_ADV_DATE'''
 +
 +
'''LNTERMS_FIRST_RT_CHG_DATE'''
 +
    The date of the first rate change for the loan
 +
 +
'''LNTERMS_FREQUENCY'''
 +
 +
'''LNTERMS_FULLY_INDEXED_RATE'''
 +
 +
'''LNTERMS_GROUP'''
 +
 +
'''LNTERMS_HOLDER'''
 +
 +
'''LNTERMS_INSUR_CODES'''
 +
 +
'''LNTERMS_ITEMIZATION'''
 +
 +
'''LNTERMS_KTFR_ACCT'''
 +
 +
'''LNTERMS_KTFR_SUFFIX'''
 +
 +
'''LNTERMS_LAST_LT_NUMBER'''
 +
 +
'''LNTERMS_LAST_NUMBER'''
 +
 +
'''LNTERMS_LAST_SSN'''
 +
 +
'''LNTERMS_LIFE_INSUR_AMT'''
 +
 +
'''LNTERMS_LOAN_TYPE'''
 +
    The loan type
 +
 +
'''LNTERMS_MARGIN_SECURITY'''
 +
 +
'''LNTERMS_METHOD'''
 +
 +
'''LNTERMS_MICR_NUMBER'''
 +
 +
'''LNTERMS_NONDISCNT_APR'''
 +
 +
'''LNTERMS_NOTE'''
 +
 +
'''LNTERMS_NUMBER'''
 +
 +
'''LNTERMS_OLD_CREDIT_LIM'''
 +
    The old credit limit for the loan
 +
 +
'''LNTERMS_PLEDGE_AMOUNT'''
 +
 +
'''LNTERMS_PLEDGE_CODE'''
 +
 +
'''LNTERMS_PMT_AMOUNT'''
 +
 +
'''LNTERMS_PRCNT_DOWN'''
 +
 +
'''LNTERMS_PRODUCT_CODE'''
 +
    The loan product code
 +
 +
'''LNTERMS_PURPOSE'''
 +
 +
'''LNTERMS_RECORDER'''
 +
    The loan recorder
 +
 +
'''LNTERMS_REF_SUFFIX_1'''
 +
 +
'''LNTERMS_REF_SUFFIX_2'''
 +
 +
'''LNTERMS_REF_SUFFIX_3'''
 +
 +
'''LNTERMS_REQUEST_AMOUNT'''
 +
 +
'''LNTERMS_REVIEW_DATE'''
 +
 +
'''LNTERMS_SELLER'''
 +
    The seller of the loan
 +
 +
'''LNTERMS_SKIP_CODE'''
 +
 +
'''LNTERMS_SMSA'''
 +
 +
'''LNTERMS_SUBS_CHANGE'''
 +
 +
'''LNTERMS_SUFFIX'''
 +
    The loan suffix
 +
 +
'''LNTERMS_TERM'''
 +
    The loan term
 +
 +
'''LNTERMS_TOT_FIN_CHARGE'''
 +
 +
'''LNTERMS_TOT_OF_PAYMENTS'''
 +
 +
'''LNTERMS_TRANSACTION_TYPE'''
 +
 +
'''LNTERMS_VRL_CODE'''
 +
 +
'''LNTERMS_VRL_FREQ'''
 +
 +
'''LNTERMS_VRL_INDEX'''
 +
 +
'''LNTERMS_VRL_MARGIN'''
 +
 +
'''LNTERMS_X_PLDGE_ACCT'''
 +
 +
'''LNTERMS_X_PLDGE_SUFFIX'''
  
 
== DLRINFO Fields ==
 
== DLRINFO Fields ==
Line 407: Line 1,423:
  
 
== VEHCINFO Fields ==
 
== VEHCINFO Fields ==
 +
 +
'''LN_VI_AMOUNT_FINANCED'''
 +
    The amount financed for the vehicle
 +
 +
'''LN_VI_DEALER'''
 +
    The dealer where the vehicle was purchased
 +
 +
'''LN_VI_DEALER_CODE'''
 +
    The dealer's code
 +
 +
'''LN_VI_LICENSE_NUM'''
 +
    The vehicle license number
 +
 +
'''LN_VI_PAID_FEE_AMOUNT'''
 +
 +
'''LN_VI_PURCHASE_ORDER'''
 +
 +
'''LN_VI_SEQUENCE_NBR'''
 +
    The sequence number
 +
 +
'''LN_VI_STATE'''
 +
    The State that the vehicle is registered in
 +
 +
'''LN_VI_TITLE_NUM'''
 +
 +
'''LN_VI_TITLE_RECIP'''
 +
 +
'''LN_VI_TTL_EXPECT_DATE'''
 +
 +
'''LN_VI_TTL_RECVD_DATE'''
 +
 +
'''LN_VI_TTL_RELSD_DATE'''
 +
 +
'''LN_VI_VEHL_MAKE'''
 +
    The make of the vehicle
 +
 +
'''LN_VI_VEHL_MODEL'''
 +
    The model of the vehicle
 +
 +
'''LN_VI_VEHL_RETAIL'''
 +
    The retail value of the vehicle
 +
 +
'''LN_VI_VEHL_VALUE'''
 +
    The value of the vehicle
 +
 +
'''LN_VI_VEHL_YEAR'''
 +
 +
'''LN_VI_VI_APP_KEY'''
 +
 +
'''LN_VI_VIN_NUMBER'''
 +
    The vehicle identification number
 +
 +
'''LN_VI_VIN_SUB_NUMBER'''

Latest revision as of 20:37, 4 September 2012

Overview

The definitions of the Tables and Fields available in Vital Signs

Tables

MBR 

   Member Level Fields

SH 

   Share Level Fields

LN 

   Loan Level Fields

LNADDM 

   Loan Addendum Fields

LNAPP 

   Loanapp Fields (Spectrum Core Lender)

LNTERMS 

   Loan Terms Fields

DLRINFO 

   Dealer Info Fields

VEHCINFO 

   Vehicle Info Fields


MBR Fields

MBR_ACCOUNT 

   The member account number

MBR_ACCT_AGE 

   The age of the member account

MBR_ACTIVE_LN_BAL 

   Count of active loans belonging to the member

MBR_ACTIVE_LN_CNT 

   Count of active loans belonging to the member

MBR_ACTIVE_SH_BAL 

   Balance of active shares belonging to the member

MBR_ACTIVE_SH_CNT 

   Count of active shares belonging to the member

MBR_ADDR1 

   The first address line

MBR_ADDR2 

   The second address line

MBR_ADDR3 

   The third address line

MBR_AFFINITY_CODE

MBR_AGE 

   The age of the member

MBR_AGE_AS_DECIMAL 

   The age of the member in decimal form

MBR_BIRTH_DATE 

   The member birth date

MBR_BRANCH 

   The current branch for the member account

MBR_CELL_PHONE 

   The member cell phone number

MBR_CF_ACCT_IN_COLLECT 

   Flag indicating the member has a loan in collections

MBR_CF_ATM_FLAG 

   Flag indicating the member has an ATM card

MBR_CF_BAD_ADDR 

   Flag indicating the member has a bad address

MBR_CF_CAPTURE_ATM_CARD 

   Flag indicating the member ATM card should be captured

MBR_CF_CC_ACCT 

   Flag indicating the member owns a credit card

MBR_CF_CHGOFF_LOAN 

   Flag indicating the member has a charged off loan

MBR_CF_CHGOFF_SHARE 

   Flag indicating the member has a charged off share

MBR_CF_DECEASED 

   Flag indicating the member is deceased

MBR_CF_NO_LABELS

MBR_CF_NO_MAIL 

   Flag indicating the member does not wish to receive mail

MBR_CF_SEND_MTHLY_STMT 

   Flag indicating the member receives monthly statements

MBR_CF_STMTS_TO_CU

MBR_CHG_LN_BAL

MBR_CHG_LN_CNT

MBR_CHG_SH_BAL

MBR_CHG_SH_CNT

MBR_CITIZENSHIP 

   The Country of Citenzenship for the member

MBR_CITY 

   The city of the member's account

MBR_CLASS_CODE

MBR_CLOSE_DATE 

   The date the member account was closed

MBR_COUNT

MBR_COUNTRY_CODE 

   The country 2 digit code for the member account

MBR_CREDIT_SCORE 

   The credit score associated with the member account

MBR_CURE_DATE

MBR_DEPARTMENT 

   The department associated with this member

MBR_DRIVER_LIC_NUM 

   The member drivers license number

MBR_DRIVER_LIC_STATE 

   The state where the member's drivers license was issued

MBR_E_MAIL 

   The member's e-mail address

MBR_ELIGIBILITY

MBR_EMPL_NUM

MBR_EMPL_STATUS 

   The employment status of the member

MBR_EMPLOYER_NAME 

   The name on file for the member employer

MBR_ESCHEAT_DATE 

   The escheat date for the member account

MBR_FAX_NUMBER

MBR_FINAL_CLOSE_DATE 

   The final date the member account was closed

MBR_FINAL_CLOSE_MTH 

   The month the member account was closed

MBR_FIRST_NAME 

   The first name of the member

MBR_FULL_NAME 

   The full name of the member

MBR_GROUP

MBR_HOUSEHOLD

MBR_HOUSEHOLD_CODE

MBR_LAST_CHG_DATE 

   The date of the last change made to the member's account

MBR_LAST_NAME 

   The last name of the member

MBR_LTD_BRANCH

MBR_LTD_COLLATERAL

MBR_LTD_DATE

MBR_LTD_OFFICER

MBR_MAIDEN_NAME 

   The maiden name of the member

MBR_MARITAL_STATUS 

   The marital status of the member

MBR_MIDDLE_NAME 

   The middle name of the member

MBR_MONTHLY_ADB1 

   The average daily balance for the past 1 month

MBR_MONTHLY_ADB2 

   The average daily balance for 2 months prior

MBR_MONTHLY_ADB3 

   The average daily balance for 2 months prior

MBR_NAME_CHG_DATE 

   The date when the member changed their name

MBR_OLC_COUNT

MBR_OLC_ENTRY_DATE

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_ORIG_OPEN_MTH 

   The original month the member opened their account

MBR_PAGER_PHONE 

   The pager number for the member account

MBR_PHONE 

   The member's phone number

MBR_PRIOR_YTD_DIV

MBR_PRIOR_YTD_INT

MBR_PROFESSION_YEARS 

   The number of years the member has been in their line of work

MBR_RECORDER 

   The teller who opened the member account

MBR_RECORDER_NAME 

   The name of the teller who opened the member account

MBR_RECORDER_NAME_INTL 

   The initials of the teller who opened the member's account

MBR_REF 

   The ref field from the member-file record on a Spectrum core

MBR_REF2 

   The ref2 field from the member-file record on a Spectrum core

MBR_REF3 

   The ref3 field from the member-file record on a Spectrum core

MBR_REF4 

   The ref4 field from the member-file record on a Spectrum core

MBR_REFER

MBR_RELATE_FLAG 

   The relate flag for the member account

MBR_RESIDENCE_CODE

MBR_REST_FLAG_11 

   The rest-flag-11 field on a Spectrum core

MBR_REST_FLAG_12 

   The rest-flag-12 field on a Spectrum core

MBR_SELF_EMPLOYED 

   The member's self employed status

MBR_SELLER 

   The teller who opened the member account

MBR_SELLER_NAME 

   The name of the teller who opened the member account

MBR_SELLER_NAME_INTL 

   The initials of the teller who opened the member account

MBR_SEX 

   The sex of the member

MBR_SSN_NUM 

   The member's Social Security Number

MBR_STATE 

   The state on file for the member 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_WORK_PHONE 

   The member's work phone

MBR_YTD_INT 

   The year to date interest for the member account

MBR_ZIP 

   The zip code on file for the member account

MBR ZIP+4 

   The member's full zipcode including the last 4 digits

MBR_SSN_FMT 

   The member's formatted SSN xxx-xx-xxxx

SH Fields

SH_CERT_MAT_DATE 

   The certificate maturity date

SH_CERT_MAT_DATE_MTH 

   The certificate maturity month

SH_ACC 

   The Share ACC Code

SH_ACCOUNT 

   The 9 digit share account number

SH_ACCRUED_DIV 

   The accrued dividends for the share

SH_ACCUM_DIVIDEND 

   The accumulated dividends for the share

SH_ADB_DAYS 

   The Average Daily Balance Days

SH_BALANCE 

   The share balance

SH_BRANCH 

   The current branch of the share

SH_CD_FLAG 

   Flag indicating if the share is a Certificate of Deposit

SH_CERT_ADJ_VAL_LS1

SH_CERT_DIV_REG_LS2

SH_CERT_DIV_TOT_LS3

SH_CERT_FOR_AMT_LS5

SH_CERT_MAT_DT_LS4 

   The certificate maturity date

SH_CERT_NUMBER_LS6

SH_CERT_ROLLOVER_DATE 

   The date the certificate rolled over to a new certificate

SH_CF_ADDON_CERT

SH_CF_ALL_SAVERS_CERT

SH_CF_ATM_REGD

SH_CF_AUTO_XFER

SH_CF_CERT_FLAG 

   Flag indicating the share is a certificate

SH_CF_DEBIT_CARD 

   Flag indicating the share has a debit card

SH_CF_IRA_ACCT 

   Flag indicating the share is an IRA

SH_CF_NO_ACTIVITY_FLAG 

   Flag indicating the share has no activity

SH_CF_SHARE_DRAFT_ACCT 

   Flag indicating the share is a checking account

SH_CF_SSN_VERIF_REQD 

   Flag indicating that a SSN number must be verified

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_COLLECTOR 

   The name of the collector on this share

SH_COUNT

SH_DESC_ABRV 

   The share description abbreviation

SH_DESC_ABRV_LONGDESC 

   The long form of the share description abbreviation

SH_DESCRIPTION 

   The share description

SH_DIV_PAID_DATE 

   The last date dividends were posted to the share

SH_DIV_PERIOD_DAYS 

   The number of days that dividends were calculated and paid out to the share

SH_DIV_RATE 

   The dividend rate for the share

SH_DIV_WHH_AMT 

   The amount of dividends to be withheld

SH_DOLLAR_DAYS

SH_DRAFT_ACCT

SH_ENTRY_AMOUNT 

   The balance of the share when it was opened

SH_ENTRY_DATE 

   The date the share was opened

SH_HI_NEG_AMT 

   The largest amount negative the share has been

SH_INSUR_CODES

SH_IRA_FLAG 

   A flag indicating the share is an IRA

SH_IRA_TYPE 

   A description of the type of IRA the share is

SH_KITE_RESET_DATE

SH_LAST_AMOUNT

SH_LAST_CHG_DATE

SH_LAST_CODE

SH_LAST_DATE

SH_LAST_DIV_CALC

SH_LAST_DIV_PAID 

   The last dividend amount paid to the share

SH_LAST_NSF_DATE 

   The date the share last posted a NSF fee

SH_LAST_PAID_NSF 

   The date of the last paid NSF fee

SH_LAST_PBF_AMOUNT

SH_LAST_PBF_DATE

SH_LAST_STMT_DATE

SH_LTD_NSF_COUNTER

SH_MAT_DISP

SH_MICR_NUMBER 

   The MICR number for the share

SH_MONTHLY_ADB1 

   The share average daily balance for the past month

SH_MTD_NSF_COUNTER 

   The number of NSF fee given month to date

SH_MTD_PAID_NSF 

   The number of paid NSF fees month to date

SH_NAME 

   The member name on file for the share

SH_NEG_DATE 

   The date the share balance became negative

SH_OPEN_DATE 

   The open date of the share

SH_ORIG_BRANCH 

   The original branch where the share was opened

SH_ORIG_TERM

SH_ORIG_TERM_TYPE

SH_OWNER 

   The name of the owner of the share

SH_PERIOD_LOW_BAL

SH_PLEDGE_AMOUNT

SH_PREV_DESC_ABRV 

   The share previous description abreviation

SH_PREV_DIV_CDAYS

SH_PRIOR_DIV_RATE 

   The share prior dividend rate

SH_PRIOR_YTD_DIV 

   The share prior year to date total dividends

SH_PRIOR_YTD_FOR

SH_PTD_WTHDRAWLS

SH_PV_DIV_WHH_AMT

SH_RECORDER 

   The teller who recorded the share

SH_RECORDER_NAME 

   The name of the teller who recorded the share

SH_RECORDER_NAME_INTL 

   The initials of the teller who recorded the share

SH_REGD_CHECKS

SH_REGD_WTHDRAWLS 

   The number of Regd transaction this month

SH_RESET_DIV_DATE

SH_ROLL_ACC

SH_ROLL_AMOUNT_CHG

SH_ROLL_SDA

SH_ROLL_TERM

SH_ROLL_TERM_TYPE

SH_SELLER 

   The teller who opened the share with the member

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_TARGET_AMOUNT

SH_TD_PAID_NSF

SH_TIN_TYPE

SH_YTD_DIV 

   The year to date dividends paid out

SH_YTD_NSF_COUNTER 

   The year to date NSFs for this share

SH_YTD_PAID_NSF 

   The year to date paid NSF fees for this share

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_ACC

LNADDM_ACCOUNT

LNADDM_ACCRUED_DIV

LNADDM_ACCUM_DIVIDEND

LNADDM_AMORT_TERM

LNADDM_AMORT_TYPE

LNADDM_AMOUNT_LAST_TRAN

LNADDM_APPRAISAL_AMOUNT

LNADDM_APPRAISAL_DATE

LNADDM_APR_LOCK_DATE

LNADDM_BUILDER

LNADDM_CO_HMDA_ETHNIC

LNADDM_CO_HMDA_RACES

LNADDM_CO_HMDA_SEX

LNADDM_COMMENT

LNADDM_COMMIT_DATE

LNADDM_CONDO_PUD_NAME

LNADDM_CONTRACTOR

LNADDM_COUNTY_CODE

LNADDM_CURR_LATE_CRG

LNADDM_CUSHION_AMOUNT

LNADDM_CUSHION_RATE

LNADDM_DEFICIENCY

LNADDM_DELQ_ADJUST_AMOUNT

LNADDM_DELQ_DATE

LNADDM_DESC_ABRV

LNADDM_DIV_PAID_DATE

LNADDM_DIV_WHH_AMT

LNADDM_DRAW_COUNT

LNADDM_DRAW_LIMIT

LNADDM_DWELLING_TYPE

LNADDM_EDA_FLAG

LNADDM_EFF_DATE_LAST_TRAN

LNADDM_ESCROW_AMT_CHG_DATE

LNADDM_ESCROW_BALANCE 

   The Escrow balance

LNADDM_ESCROW_CENTS_DAYS

LNADDM_ESCROW_DUE_DATE

LNADDM_ESCROW_ENTRY_DATE

LNADDM_ESCROW_LAST_CHG_DATE

LNADDM_ESCROW_PMT_AMOUNT

LNADDM_ESCROW_PRIOR_AMOUNT

LNADDM_FED_MAX_CUSHION

LNADDM_FIN_INST_FTB_FLD

LNADDM_FIRST_RT_CHG_DATE

LNADDM_FORCLS_MIADJ_FLD

LNADDM_GROSS_ANNUAL_INCOME

LNADDM_HMDA_ETHNIC

LNADDM_HMDA_OCCUP_CODE

LNADDM_HMDA_RACES

LNADDM_HMDA_SEX

LNADDM_HOEPA_STATUS

LNADDM_IMPROVE_AMOUNT

LNADDM_INSPECTION_DATE

LNADDM_INT_ONLY_END_DATE

LNADDM_INVESTOR_ACTION_CODE

LNADDM_INVESTOR_ACTION_DATE

LNADDM_INVESTOR_LOAN_NUMBER

LNADDM_INVESTOR_PKG_KEY

LNADDM_INVESTOR_PTD_FEES

LNADDM_INVESTOR_PTD_INT

LNADDM_INVESTOR_PTD_PRINCIPAL

LNADDM_INVESTOR_PTD_PYMNTS

LNADDM_INVESTOR_STATUS

LNADDM_LAST_ANLY_DATE

LNADDM_LAST_DIV_CALC

LNADDM_LAST_DIV_PAID

LNADDM_LAST_MONETARY_AMOUNT

LNADDM_LAST_MONETARY_CODE

LNADDM_LAST_MONETARY_DATE

LNADDM_LAST_RUN_DATE

LNADDM_LIEN_STATUS

LNADDM_LOAN_FEATURE

LNADDM_MERS_NUMBER

LNADDM_MI_CERT_NUMBER

LNADDM_MI_PERCENT

LNADDM_MIN_PAYMENT

LNADDM_MISC_INSUR_AMOUNT

LNADDM_MONTH_DEBT_EXP

LNADDM_MONTH_HOUSE_EXP

LNADDM_MORT_INS_CODE

LNADDM_MORTGAGE_MARGIN

LNADDM_MORTGAGE_TYPE

LNADDM_NEXT_ANLY_DATE

LNADDM_NUMB_BORROWERS

LNADDM_NUMBER_OF_UNITS

LNADDM_ORIG_MONTHLY_PI

LNADDM_ORIGINAL_LTV

LNADDM_OTHER_FINANCING

LNADDM_OWNER_OCCUPIED

LNADDM_PAYMENT_ADJUST

LNADDM_PERCENT_DONE

LNADDM_PERIOD_LOW_BAL

LNADDM_POINTS

LNADDM_PORTION_PAID

LNADDM_PRE_APRVL_REQ

LNADDM_PREPAID_ACCRUAL

LNADDM_PREV_YEAR_INSURANCE

LNADDM_PREV_YEAR_OTHER

LNADDM_PRIOR_YTD_DIV

LNADDM_PRIOR_YTD_PMI

LNADDM_PRIOR_YTD_TAX

LNADDM_PROJECT_CLASS

LNADDM_PROJECT_DUE

LNADDM_PROPERTY_ADDR

LNADDM_PROPERTY_CITY

LNADDM_PROPERTY_STATE

LNADDM_PROPERTY_TYPE

LNADDM_PROPERTY_ZIP

LNADDM_PURCHASE_DOC

LNADDM_PURCHASER_TYPE

LNADDM_PV_DIV_WHH_AMT

LNADDM_RATE_SPREAD

LNADDM_REFUND_DATE

LNADDM_REFUND_METHOD

LNADDM_SALES_PRICE

LNADDM_SECND_LIEN_HLDR

LNADDM_SECTION_ACT

LNADDM_SHORTAGE

LNADDM_ST_CUSHION_AMT

LNADDM_ST_CUSHION_RATE

LNADDM_SUBSIDY_PMT_AMOUNT

LNADDM_SUFFIX

LNADDM_SURPLUS

LNADDM_UNDISTR_BALANCE

LNADDM_YTD_DIV

LNADDM_YTD_INSURANCE

LNADDM_YTD_OTHER

LNADDM_YTD_PMI

LNADDM_YTD_TAX

LNAPP Fields

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

LNTERMS Fields

LNTERMS_ACCOUNT 

   The loan account number

LNTERMS_ACTION 

   The loan action

LNTERMS_ALT_AMOUNT

LNTERMS_ALT_NUMBER

LNTERMS_ALT_START_DATE

LNTERMS_AMOUNT 

   The loan amount

LNTERMS_APP_KEY 

   The loan application key

LNTERMS_APR 

   The loan apr

LNTERMS_AUTO_CALC_INT

LNTERMS_BALLOON_PYMT_DATE 

   The loan balloon payment date

LNTERMS_CASH_APR

LNTERMS_CENSUS_TRACT

LNTERMS_COLLATERAL 

   The loan collateral

LNTERMS_DESCRIPTION 

   The loan description

LNTERMS_DIS_INSUR_AMT

LNTERMS_DISBURSAL_DATE

LNTERMS_DISCLOSURE_CODE

LNTERMS_DRAFT_ACCT

LNTERMS_DUE_DATE

LNTERMS_ENTRY_DATE 

   The loan open date

LNTERMS_FINAL_ADV_DATE

LNTERMS_FIRST_RT_CHG_DATE 

   The date of the first rate change for the loan

LNTERMS_FREQUENCY

LNTERMS_FULLY_INDEXED_RATE

LNTERMS_GROUP

LNTERMS_HOLDER

LNTERMS_INSUR_CODES

LNTERMS_ITEMIZATION

LNTERMS_KTFR_ACCT

LNTERMS_KTFR_SUFFIX

LNTERMS_LAST_LT_NUMBER

LNTERMS_LAST_NUMBER

LNTERMS_LAST_SSN

LNTERMS_LIFE_INSUR_AMT

LNTERMS_LOAN_TYPE 

   The loan type

LNTERMS_MARGIN_SECURITY

LNTERMS_METHOD

LNTERMS_MICR_NUMBER

LNTERMS_NONDISCNT_APR

LNTERMS_NOTE

LNTERMS_NUMBER

LNTERMS_OLD_CREDIT_LIM 

   The old credit limit for the loan

LNTERMS_PLEDGE_AMOUNT

LNTERMS_PLEDGE_CODE

LNTERMS_PMT_AMOUNT

LNTERMS_PRCNT_DOWN

LNTERMS_PRODUCT_CODE 

   The loan product code

LNTERMS_PURPOSE

LNTERMS_RECORDER 

   The loan recorder

LNTERMS_REF_SUFFIX_1

LNTERMS_REF_SUFFIX_2

LNTERMS_REF_SUFFIX_3

LNTERMS_REQUEST_AMOUNT

LNTERMS_REVIEW_DATE

LNTERMS_SELLER 

   The seller of the loan

LNTERMS_SKIP_CODE

LNTERMS_SMSA

LNTERMS_SUBS_CHANGE

LNTERMS_SUFFIX 

   The loan suffix

LNTERMS_TERM 

   The loan term

LNTERMS_TOT_FIN_CHARGE

LNTERMS_TOT_OF_PAYMENTS

LNTERMS_TRANSACTION_TYPE

LNTERMS_VRL_CODE

LNTERMS_VRL_FREQ

LNTERMS_VRL_INDEX

LNTERMS_VRL_MARGIN

LNTERMS_X_PLDGE_ACCT

LNTERMS_X_PLDGE_SUFFIX

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

LN_VI_AMOUNT_FINANCED 

   The amount financed for the vehicle

LN_VI_DEALER 

   The dealer where the vehicle was purchased

LN_VI_DEALER_CODE 

   The dealer's code

LN_VI_LICENSE_NUM 

   The vehicle license number

LN_VI_PAID_FEE_AMOUNT

LN_VI_PURCHASE_ORDER

LN_VI_SEQUENCE_NBR 

   The sequence number

LN_VI_STATE 

   The State that the vehicle is registered in

LN_VI_TITLE_NUM

LN_VI_TITLE_RECIP

LN_VI_TTL_EXPECT_DATE

LN_VI_TTL_RECVD_DATE

LN_VI_TTL_RELSD_DATE

LN_VI_VEHL_MAKE 

   The make of the vehicle

LN_VI_VEHL_MODEL 

   The model of the vehicle

LN_VI_VEHL_RETAIL 

   The retail value of the vehicle

LN_VI_VEHL_VALUE 

   The value of the vehicle

LN_VI_VEHL_YEAR

LN_VI_VI_APP_KEY

LN_VI_VIN_NUMBER 

   The vehicle identification number

LN_VI_VIN_SUB_NUMBER

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