Vital Signs Internal Tables

From Vital Soft Wiki
Revision as of 20:37, 4 September 2012 by >Jeremyb
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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