Difference between revisions of "Vital Signs Internal Tables"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(→‎MBR Fields)
>Jeremyb
(→‎SH Fields)
Line 317: Line 317:
  
 
== 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 ==

Revision as of 20:34, 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

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

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=648"