Data Change Fields

From Vital Soft Wiki
Revision as of 23:02, 28 August 2012 by >Jeremyb (Member Level)
Jump to: navigation, search

The fields available in the Data Change application

Loan Level

LN_NBR_LATE_PMTS_LAST_3MTHS

   The number of late payments over the past 3 months

LN_ACTION_DATE

   The date the action was changed on the loan

LN_AMOUNT

   The original amount of the loan

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_BALLOON_PYMT_DT

   The balloon payment date of the loan

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

   The description of the collateral for the loan

LN_COLLECTOR

   The name of the collector on file for the loan

LN_CREDIT_SSN

LN_DECISION_TELLER_NAME

   The teller who approved the loan

LN_DENIAL_NOTICE

LN_DENIAL_REASON

LN_DESCRIPTION

   The description of the loan

LN_FIRST_PAY_DATE

   The date of the first loan payment

LN_FREQUENCY

   The frequency for loan payments

LN_HIGH_BALANCE

LN_HIGHEST_DELQ_AMT

   The highest amount of delinquent payments for the loan

LN_HIGHEST_DELQ_DT

LN_LAST_AMOUNT

   The last amount of the loan balance

LN_LAST_CODE

LN_LAST_DATE

LN_LAST_PYMT_AMT

   The amount of the last loan payment

LN_LAST_PYMT_DATE

   The date of the last payment

LN_MATURITY_DATE

   The maturity date of the loan

LN_METHOD

LN_OFFICER_NAME

   The loan officer assigned to the loan

LN_ORIGINAL_APR

   The original APR of the loan

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_PURPOSE

   The loan purpose code

LN_RECORDER_NAME

   The name of the loan officer who recorded the loan

LN_REVIEW_DATE

   The date the loan was reviewed

LN_SECURE_UNSECURE_FLAG

   Field indicating that the loan is secured by collateral or not

LN_SELLER_NAME

   The name of the teller who sold the loan

LN_TERM

   The term of the loan

LN_VAR_RATE_CODE

LN_VEHICLE_INFO_KEY

   The key to link into vehicle-info

LN_NBR_LATE_PMTS

   The number of late payment made on the loan


Member Level

MBR_ADDR1

   The first address line

MBR_ADDR2

   The second address line

MBR_AFFINITY_CODE

MBR_AGE_AS_DECIMAL

   The age of the member in decimal form

MBR_BIRTH_DATE

   The member birth date

MBR_CELL_PHONE

   The member cell phone number

MBR_CITIZENSHIP

   The Country of Citenzenship for the member

MBR_CITY

   The city of the member's account

MBR_CLASS_CODE

MBR_COUNTRY_CODE

   The country 2 digit code for the member account

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_FINAL_CLOSE_MTH

   The month the member account was closed

MBR_FIRST_NAME

   The first name of the member

MBR_GROUP

MBR_HOUSEHOLD_CODE

MBR_LAST_NAME

   The last name of the member

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_ORIG_OPEN_MTH

   The original month the member opened their account

MBR_PHONE

   The member phone number

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

   The member's Social Security Number

MBR_STATE

   The state on file for the member account

MBR_WORK_PHONE

   The member's work phone

MBR_ZIP

   The zip code on file for the member account

MBR_ZIP+4

   The member's full zipcode including the last 4 digits

Share Level

SH_CERT_MAT_DATE SH_CERT_MAT_DATE_MTH SH_ACC SH_ADB_DAYS SH_CD_FLAG SH_CERT_MAT_DT_LS4 SH_DESC_ABRV_LONGDESC SH_DRAFT_ACCT SH_IRA_FLAG SH_IRA_TYPE SH_LAST_AMOUNT SH_LAST_DATE SH_LAST_STMT_DATE SH_MONTHLY_ADB1 SH_OWNER SH_PLEDGE_AMOUNT SH_PREV_DESC_ABRV SH_PRIOR_DIV_RATE SH_PRIOR_YTD_DIV SH_RECORDER_NAME SH_REGD_WTHDRAWLS SH_SELLER_NAME