Difference between revisions of "Membership Analysis Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Share Level)
>Jeremyb
(Loan Level)
Line 624: Line 624:
 
== Loan Level ==
 
== Loan Level ==
  
LN_AVAIL_CREDIT
+
'''LN_AVAIL_CREDIT'''
LN_NBR_LATE_PMTS_LAST_3MTHS
 
LN_ACCOUNT
 
LN_ACTION
 
LN_ACTION_DATE
 
LN_AMOUNT
 
LN_APP_LT_NUMBER
 
LN_APP_NUMBER
 
LN_APP_SSN
 
LN_APPLY_DATE
 
LN_APR
 
LN_BALANCE
 
LN_BALLOON_PYMT_DT
 
LN_BRANCH
 
LN_CF_CREDIT_CARD_LOAN
 
LN_CF_LOC_LOAN
 
LN_CF_NO_LATE_NOTICES
 
LN_CF_OFFLINE_LOAN
 
LN_CF_OPEN_END_FLAG
 
LN_CF_REAL_ESTATE_LOAN
 
LN_CF_STUDENT_INFO
 
LN_CHAR_OFF_REASON
 
LN_CHARGE_OFF_AMT
 
LN_CHARGE_OFF_DATE
 
LN_CLOSE_DATE
 
LN_COLL_AGENCY_CODE
 
LN_COLLATERAL
 
LN_COLLATERAL_DESC
 
LN_COLLECTOR
 
LN_COUNT
 
LN_CREDIT_LIM
 
LN_CREDIT_SCORE
 
LN_CREDIT_SSN
 
LN_CURE_DATE
 
LN_CYCLE_DATE
 
LN_DEALER_CODE
 
LN_DEBT_RATIO
 
LN_DECISION_TELLER
 
LN_DECISION_TELLER_NAME
 
LN_DECISION_TELLER_NAME_INTL
 
LN_DENIAL_NOTICE
 
LN_DENIAL_REASON
 
LN_DESCRIPTION
 
LN_DISB_CHECK
 
LN_DUE_DATE
 
LN_ENTRY_AMOUNT
 
LN_ENTRY_DATE
 
LN_FIRST_PAY_DATE
 
LN_FREQUENCY
 
LN_GROUP
 
LN_HIGH_BALANCE
 
LN_HIGHEST_DELQ_AMT
 
LN_HIGHEST_DELQ_DT
 
LN_INSUR_CODES
 
LN_INSUR_TERM
 
LN_KTFR_ACCOUNT
 
LN_KTFR_SUFFIX
 
LN_LAST_ACCT_STATUS
 
LN_LAST_AMOUNT
 
LN_LAST_APR
 
LN_LAST_CHG_DATE
 
LN_LAST_CODE
 
LN_LAST_DATE
 
LN_LAST_INT_DATE
 
LN_LAST_MONTHS_INT
 
LN_LAST_PYMT_AMT
 
LN_LAST_PYMT_DATE
 
LN_LAST_RATE_CHG_DT
 
LN_MATURITY_DATE
 
LN_METHOD
 
LN_MICR_NUMBER
 
LN_NAME
 
LN_NEXT_YEARS_INT
 
LN_OCCUR_DATE
 
LN_OFFICER
 
LN_OFFICER_NAME
 
LN_OFFICER_NAME_INTL
 
LN_OFFLINE_SERVICER
 
LN_OLC_ENTRY_DATE
 
LN_ORIG_BRANCH
 
LN_ORIGINAL_APR
 
LN_OVERLIMIT_DATE
 
LN_OVRD_OFFICER
 
LN_PAID_OFF_DATE
 
LN_PARTIAL_PAYMENT
 
LN_PLEDGE_AMOUNT
 
LN_PLEDGE_CODE
 
LN_PMT_HISTORY
 
LN_PREV_COLLAT_CODE
 
LN_PREV_CYCLE_DATE
 
LN_PREV_INT_RATE
 
LN_PREV_MICR_NUM
 
LN_PRIN_PMT_AMT
 
LN_PRIOR_YTD_INT
 
LN_PURPOSE
 
LN_PYMT_AMOUNT1
 
LN_PYMT_CHANGE_DT1
 
LN_RECORDER
 
LN_RECORDER_NAME
 
LN_RECORDER_NAME_INTL
 
LN_REST_FLAG_11
 
LN_REST_FLAG_12
 
LN_REVIEW_DATE
 
LN_SECURE_UNSECURE_FLAG
 
LN_SELLER
 
LN_SELLER_NAME
 
LN_SELLER_NAME_INTL
 
LN_STATUS
 
LN_SUFFIX
 
LN_TERM
 
LN_THIRD_PARTY_KEY
 
LN_VAR_RATE_CODE
 
LN_VEHICLE_INFO_KEY
 
LN_VRL_INDEX
 
LN_VRL_MARGIN
 
LN_YTD_INT
 
LN_NBR_LATE_PMTS
 
  
 +
'''LN_NBR_LATE_PMTS_LAST_3MTHS'''
 +
'''LN_ACCOUNT'''
 +
'''LN_ACTION'''
 +
'''LN_ACTION_DATE'''
 +
'''LN_AMOUNT'''
 +
'''LN_APP_LT_NUMBER'''
 +
'''LN_APP_NUMBER'''
 +
'''LN_APP_SSN'''
 +
'''LN_APPLY_DATE'''
 +
'''LN_APR'''
 +
'''LN_BALANCE'''
 +
'''LN_BALLOON_PYMT_DT'''
 +
'''LN_BRANCH'''
 +
'''LN_CF_CREDIT_CARD_LOAN'''
 +
'''LN_CF_LOC_LOAN'''
 +
'''LN_CF_NO_LATE_NOTICES'''
 +
'''LN_CF_OFFLINE_LOAN'''
 +
'''LN_CF_OPEN_END_FLAG'''
 +
'''LN_CF_REAL_ESTATE_LOAN'''
 +
'''LN_CF_STUDENT_INFO'''
 +
'''LN_CHAR_OFF_REASON'''
 +
'''LN_CHARGE_OFF_AMT'''
 +
'''LN_CHARGE_OFF_DATE'''
 +
'''LN_CLOSE_DATE'''
 +
'''LN_COLL_AGENCY_CODE'''
 +
'''LN_COLLATERAL'''
 +
'''LN_COLLATERAL_DESC'''
 +
'''LN_COLLECTOR'''
 +
'''LN_COUNT'''
 +
'''LN_CREDIT_LIM'''
 +
'''LN_CREDIT_SCORE'''
 +
'''LN_CREDIT_SSN'''
 +
'''LN_CURE_DATE'''
 +
'''LN_CYCLE_DATE'''
 +
'''LN_DEALER_CODE'''
 +
'''LN_DEBT_RATIO'''
 +
'''LN_DECISION_TELLER'''
 +
'''LN_DECISION_TELLER_NAME'''
 +
'''LN_DECISION_TELLER_NAME_INTL'''
 +
'''LN_DENIAL_NOTICE'''
 +
'''LN_DENIAL_REASON'''
 +
'''LN_DESCRIPTION'''
 +
'''LN_DISB_CHECK'''
 +
'''LN_DUE_DATE'''
 +
'''LN_ENTRY_AMOUNT'''
 +
'''LN_ENTRY_DATE'''
 +
'''LN_FIRST_PAY_DATE'''
 +
'''LN_FREQUENCY'''
 +
'''LN_GROUP'''
 +
'''LN_HIGH_BALANCE'''
 +
'''LN_HIGHEST_DELQ_AMT'''
 +
'''LN_HIGHEST_DELQ_DT'''
 +
'''LN_INSUR_CODES'''
 +
'''LN_INSUR_TERM'''
 +
'''LN_KTFR_ACCOUNT'''
 +
'''LN_KTFR_SUFFIX'''
 +
'''LN_LAST_ACCT_STATUS'''
 +
'''LN_LAST_AMOUNT'''
 +
'''LN_LAST_APR'''
 +
'''LN_LAST_CHG_DATE'''
 +
'''LN_LAST_CODE'''
 +
'''LN_LAST_DATE'''
 +
'''LN_LAST_INT_DATE'''
 +
'''LN_LAST_MONTHS_INT'''
 +
'''LN_LAST_PYMT_AMT'''
 +
'''LN_LAST_PYMT_DATE'''
 +
'''LN_LAST_RATE_CHG_DT'''
 +
'''LN_MATURITY_DATE'''
 +
'''LN_METHOD'''
 +
'''LN_MICR_NUMBER'''
 +
'''LN_NAME'''
 +
'''LN_NEXT_YEARS_INT'''
 +
'''LN_OCCUR_DATE'''
 +
'''LN_OFFICER'''
 +
'''LN_OFFICER_NAME'''
 +
'''LN_OFFICER_NAME_INTL'''
 +
'''LN_OFFLINE_SERVICER'''
 +
'''LN_OLC_ENTRY_DATE'''
 +
'''LN_ORIG_BRANCH'''
 +
'''LN_ORIGINAL_APR'''
 +
'''LN_OVERLIMIT_DATE'''
 +
'''LN_OVRD_OFFICER'''
 +
'''LN_PAID_OFF_DATE'''
 +
'''LN_PARTIAL_PAYMENT'''
 +
'''LN_PLEDGE_AMOUNT'''
 +
'''LN_PLEDGE_CODE'''
 +
'''LN_PMT_HISTORY'''
 +
'''LN_PREV_COLLAT_CODE'''
 +
'''LN_PREV_CYCLE_DATE'''
 +
'''LN_PREV_INT_RATE'''
 +
'''LN_PREV_MICR_NUM'''
 +
'''LN_PRIN_PMT_AMT'''
 +
'''LN_PRIOR_YTD_INT'''
 +
'''LN_PURPOSE'''
 +
'''LN_PYMT_AMOUNT1'''
 +
'''LN_PYMT_CHANGE_DT1'''
 +
'''LN_RECORDER'''
 +
'''LN_RECORDER_NAME'''
 +
'''LN_RECORDER_NAME_INTL'''
 +
'''LN_REST_FLAG_11'''
 +
'''LN_REST_FLAG_12'''
 +
'''LN_REVIEW_DATE'''
 +
'''LN_SECURE_UNSECURE_FLAG'''
 +
'''LN_SELLER'''
 +
'''LN_SELLER_NAME'''
 +
'''LN_SELLER_NAME_INTL'''
 +
'''LN_STATUS'''
 +
'''LN_SUFFIX'''
 +
'''LN_TERM'''
 +
'''LN_THIRD_PARTY_KEY'''
 +
'''LN_VAR_RATE_CODE'''
 +
'''LN_VEHICLE_INFO_KEY'''
 +
'''LN_VRL_INDEX'''
 +
'''LN_VRL_MARGIN'''
 +
'''LN_YTD_INT'''
 +
'''LN_NBR_LATE_PMTS'''
  
 
==Loan Addendum==
 
==Loan Addendum==

Revision as of 15:33, 28 August 2012

The fields available for use in Document Distribution from the Membership Analysis Application

Member Level

MBR ZIP+4

   The member's 4 digit zipcode

MBR_ACCOUNT

   The member's account number

MBR_ACCT_AGE

   The age of the member account

MBR_ACTIVE_LN_BAL

   Count of active loans belonging to the member
   Note : not available by default

MBR_ACTIVE_LN_CNT

   Count of active loans belonging to the member
   Note: not available by default

MBR_ACTIVE_SH_BAL

   Balance of active shares belonging to the member
   Note: not available by default

MBR_ACTIVE_SH_CNT

   Count of active shares belonging to the member
   Note: not available by default

MBR_ADDR1

   Member's first address line

MBR_ADDR2

   Member's second address line

MBR_ADDR3

   Member's third address line
   Note: not available by default

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's birth date

MBR_BRANCH

   The current branch for the member account
   Note: not available by default

MBR_CELL_PHONE

   The member's cell phone number

MBR_CF_ACCT_IN_COLLECT

   Yes/No flag indicating the member has a loan in collections
   Note: not available by default

MBR_CF_ATM_FLAG

   Yes/No flag indicating the member has an ATM card
   Note: not available by default

MBR_CF_BAD_ADDR

   Yes/No flag indicating the member has a bad address
   Note: not available by default

MBR_CF_CAPTURE_ATM_CARD

   Yes/No flag indicating the member ATM card should be captured
   Note: not available by default

MBR_CF_CC_ACCT

   Yes/No flag indicating the member owns a credit card
   Note: not available by default

MBR_CF_CHGOFF_LOAN

   Yes/No flag indicating the member has a charged off loan
   Note: not available by default

MBR_CF_CHGOFF_SHARE

   Yes/No flag indicating the member has a charged off share
   Note: not available by default

MBR_CF_DECEASED

   Yes/No flag indicating the member is deceased
   Note: not available by default

MBR_CF_NO_LABELS

   Note: not available by default

MBR_CF_NO_MAIL

   Yes/No flag indicating the member does not wish to receive mail
   Note: not available by default

MBR_CF_SEND_MTHLY_STMT

   Yes/No flag indicating the member receives monthly statements
   Note: not available by default

MBR_CF_STMTS_TO_CU

   Note: not available by default

MBR_CHG_LN_BAL

   Note: not available by default

MBR_CHG_LN_CNT

   Note: not available by default

MBR_CHG_SH_BAL

   Note: not available by default

MBR_CHG_SH_CNT

   Note: not available by default

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
   Note: not available by default

MBR_COUNT

   Note: not available by default

MBR_COUNTRY_CODE

   The country 2 digit code for the member account

MBR_CREDIT_SCORE

   The credit score associated with the member account
   Note: not available by default

MBR_CURE_DATE

   Note: not available by default

MBR_DEPARTMENT

MBR_DRIVER_LIC_NUM

   The member's 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

MBR_EMPLOYER_NAME

   The name of the member's employer

MBR_ESCHEAT_DATE

   The escheat date for the member account

MBR_FAX_NUMBER

   Note: not available by default

MBR_FINAL_CLOSE_DATE

   The final date the member account was closed
   Note: not available by default

MBR_FINAL_CLOSE_MTH

   The month the member account was closed

MBR_FIRST_NAME

   The member's first name

MBR_FULL_NAME

   The member's full name
   Note: not available by default

MBR_GROUP

MBR_HOUSEHOLD

   Note: not available by default

MBR_HOUSEHOLD_CODE

MBR_LAST_CHG_DATE

   The date of the last change made to the member's account
   Note: not available by default

MBR_LAST_NAME

   The member's last name

MBR_LTD_BRANCH

   Note: not available by default

MBR_LTD_COLLATERAL

   Note: not available by default

MBR_LTD_DATE

   Note: not available by default

MBR_LTD_OFFICER

   Note: not available by default

MBR_MAIDEN_NAME

   The member's maiden name

MBR_MARITAL_STATUS

   The member's marital status

MBR_MIDDLE_NAME

   The member's middle name

MBR_MONTHLY_ADB1

   The monthly average daily balance
   Note: not available by default

MBR_MONTHLY_ADB2

   Note: not available by default

MBR_MONTHLY_ADB3

   Note: not available by default

MBR_NAME_CHG_DATE

   The date when the member changed their name
   Note: not available by default

MBR_OLC_COUNT

   Note: not available by default

MBR_OLC_ENTRY_DATE

   Note: not available by default

MBR_OPEN_DATE

   The date the member account was opened
   Note: not available by default

MBR_ORIG_BRANCH

   The original branch where the member opened their account
   Note: not available by default

MBR_ORIG_OPEN_DATE

   The original date the member opened their account
   Note: not available by default

MBR_ORIG_OPEN_MTH

   The original month the member opened their account

MBR_PAGER_PHONE

   The pager number for the member account
   Note: not available by default
  

MBR_PHONE

   The member's phone number

MBR_PRIOR_YTD_DIV

   Note: not available by default

MBR_PRIOR_YTD_INT

   Note: not available by default

MBR_PROFESSION_YEARS

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

MBR_RECORDER

   The teller who opened the member's account

MBR_RECORDER_NAME

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

MBR_RECORDER_NAME_INTL

   The initials of the teller who opened the member's account
   Note: not available by default

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's account to indicate joint ownership

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
   Note: not available by default

MBR_SELF_EMPLOYED

   The member's self employed status

MBR_SELLER

MBR_SELLER_NAME

MBR_SELLER_NAME_INTL

   Note: not available by default

MBR_SEX

   The member's sex
   Note: not available by default

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
   Note: not available by default

MBR_TOTAL_LN_CNT

   The count of all loans for a member account
   Note: not available by default

MBR_TOTAL_SH_BAL

   The balance of all shares for a member account
   Note: not available by default

MBR_TOTAL_SH_CNT

   The count of all shares for a member account
   Note: not available by default

MBR_UNIQUE_ID

   The unique id for each member in Vital Signs
   Note: not available by default

MBR_WORK_PHONE

   The member's work phone

MBR_YTD_INT

   The year to date interest for the member account
   Note: not available by default

MBR_ZIP

   The zip code on file for the member account

MBR_SSN_FMT

   The member's formatted SSN xxx-xx-xxxx

Share Level

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 used to calculate average daily balance

SH_BALANCE

   The share balance

SH_BRANCH

   The current branch of the share

SH_CD_FLAG

   Yes/no 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

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 abreviation

SH_DESC_ABRV_LONGDESC

   The long form of the share description abreviation

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

Loan Level

LN_AVAIL_CREDIT

LN_NBR_LATE_PMTS_LAST_3MTHS LN_ACCOUNT LN_ACTION LN_ACTION_DATE LN_AMOUNT LN_APP_LT_NUMBER LN_APP_NUMBER LN_APP_SSN LN_APPLY_DATE LN_APR LN_BALANCE LN_BALLOON_PYMT_DT LN_BRANCH LN_CF_CREDIT_CARD_LOAN LN_CF_LOC_LOAN LN_CF_NO_LATE_NOTICES LN_CF_OFFLINE_LOAN LN_CF_OPEN_END_FLAG LN_CF_REAL_ESTATE_LOAN LN_CF_STUDENT_INFO LN_CHAR_OFF_REASON LN_CHARGE_OFF_AMT LN_CHARGE_OFF_DATE LN_CLOSE_DATE LN_COLL_AGENCY_CODE LN_COLLATERAL LN_COLLATERAL_DESC LN_COLLECTOR LN_COUNT LN_CREDIT_LIM LN_CREDIT_SCORE LN_CREDIT_SSN LN_CURE_DATE LN_CYCLE_DATE LN_DEALER_CODE LN_DEBT_RATIO LN_DECISION_TELLER LN_DECISION_TELLER_NAME LN_DECISION_TELLER_NAME_INTL LN_DENIAL_NOTICE LN_DENIAL_REASON LN_DESCRIPTION LN_DISB_CHECK LN_DUE_DATE LN_ENTRY_AMOUNT LN_ENTRY_DATE LN_FIRST_PAY_DATE LN_FREQUENCY LN_GROUP LN_HIGH_BALANCE LN_HIGHEST_DELQ_AMT LN_HIGHEST_DELQ_DT LN_INSUR_CODES LN_INSUR_TERM LN_KTFR_ACCOUNT LN_KTFR_SUFFIX LN_LAST_ACCT_STATUS LN_LAST_AMOUNT LN_LAST_APR LN_LAST_CHG_DATE LN_LAST_CODE LN_LAST_DATE LN_LAST_INT_DATE LN_LAST_MONTHS_INT LN_LAST_PYMT_AMT LN_LAST_PYMT_DATE LN_LAST_RATE_CHG_DT LN_MATURITY_DATE LN_METHOD LN_MICR_NUMBER LN_NAME LN_NEXT_YEARS_INT LN_OCCUR_DATE LN_OFFICER LN_OFFICER_NAME LN_OFFICER_NAME_INTL LN_OFFLINE_SERVICER LN_OLC_ENTRY_DATE LN_ORIG_BRANCH LN_ORIGINAL_APR LN_OVERLIMIT_DATE LN_OVRD_OFFICER LN_PAID_OFF_DATE LN_PARTIAL_PAYMENT LN_PLEDGE_AMOUNT LN_PLEDGE_CODE LN_PMT_HISTORY LN_PREV_COLLAT_CODE LN_PREV_CYCLE_DATE LN_PREV_INT_RATE LN_PREV_MICR_NUM LN_PRIN_PMT_AMT LN_PRIOR_YTD_INT LN_PURPOSE LN_PYMT_AMOUNT1 LN_PYMT_CHANGE_DT1 LN_RECORDER LN_RECORDER_NAME LN_RECORDER_NAME_INTL LN_REST_FLAG_11 LN_REST_FLAG_12 LN_REVIEW_DATE LN_SECURE_UNSECURE_FLAG LN_SELLER LN_SELLER_NAME LN_SELLER_NAME_INTL LN_STATUS LN_SUFFIX LN_TERM LN_THIRD_PARTY_KEY LN_VAR_RATE_CODE LN_VEHICLE_INFO_KEY LN_VRL_INDEX LN_VRL_MARGIN LN_YTD_INT LN_NBR_LATE_PMTS

Loan Addendum

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 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


Loan Terms

LNTERMS_ACCOUNT LNTERMS_ACTION LNTERMS_ALT_AMOUNT LNTERMS_ALT_NUMBER LNTERMS_ALT_START_DATE LNTERMS_AMOUNT LNTERMS_APP_KEY LNTERMS_APR LNTERMS_AUTO_CALC_INT LNTERMS_BALLOON_PYMT_DATE LNTERMS_CASH_APR LNTERMS_CENSUS_TRACT LNTERMS_COLLATERAL LNTERMS_DESCRIPTION LNTERMS_DIS_INSUR_AMT LNTERMS_DISBURSAL_DATE LNTERMS_DISCLOSURE_CODE LNTERMS_DRAFT_ACCT LNTERMS_DUE_DATE LNTERMS_ENTRY_DATE LNTERMS_FINAL_ADV_DATE LNTERMS_FIRST_RT_CHG_DATE 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 LNTERMS_MARGIN_SECURITY LNTERMS_METHOD LNTERMS_MICR_NUMBER LNTERMS_NONDISCNT_APR LNTERMS_NOTE LNTERMS_NUMBER LNTERMS_OLD_CREDIT_LIM LNTERMS_PLEDGE_AMOUNT LNTERMS_PLEDGE_CODE LNTERMS_PMT_AMOUNT LNTERMS_PRCNT_DOWN LNTERMS_PRODUCT_CODE LNTERMS_PURPOSE LNTERMS_RECORDER LNTERMS_REF_SUFFIX_1 LNTERMS_REF_SUFFIX_2 LNTERMS_REF_SUFFIX_3 LNTERMS_REQUEST_AMOUNT LNTERMS_REVIEW_DATE LNTERMS_SELLER LNTERMS_SKIP_CODE LNTERMS_SMSA LNTERMS_SUBS_CHANGE LNTERMS_SUFFIX LNTERMS_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


Loan Vehicle Info

LN_VI_AMOUNT_FINANCED LN_VI_DEALER LN_VI_DEALER_CODE LN_VI_LICENSE_NUM LN_VI_PAID_FEE_AMOUNT LN_VI_PURCHASE_ORDER LN_VI_SEQUENCE_NBR LN_VI_STATE 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 LN_VI_VEHL_MODEL LN_VI_VEHL_RETAIL LN_VI_VEHL_VALUE LN_VI_VEHL_YEAR LN_VI_VI_APP_KEY LN_VI_VIN_NUMBER LN_VI_VIN_SUB_NUMBER

Attributes