Difference between revisions of "Data Change Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Member Level)
>Jeremyb
(Share Level)
 
Line 275: Line 275:
  
 
'''SH_CERT_MAT_DATE'''
 
'''SH_CERT_MAT_DATE'''
 +
    The certificate maturity date
 +
 
'''SH_CERT_MAT_DATE_MTH'''
 
'''SH_CERT_MAT_DATE_MTH'''
 +
    The certificate maturity month
 +
 
'''SH_ACC'''
 
'''SH_ACC'''
 +
    The Share ACC Code
 +
 
'''SH_ADB_DAYS'''
 
'''SH_ADB_DAYS'''
 +
    The Average Daily Balance Days
 +
 
'''SH_CD_FLAG'''
 
'''SH_CD_FLAG'''
 +
    Flag indicating if the share is a Certificate of Deposit
 +
 
'''SH_CERT_MAT_DT_LS4'''
 
'''SH_CERT_MAT_DT_LS4'''
 +
    The certificate maturity date
 +
 
'''SH_DESC_ABRV_LONGDESC'''
 
'''SH_DESC_ABRV_LONGDESC'''
 +
    The long form of the share description abbreviation
 +
 
'''SH_DRAFT_ACCT'''
 
'''SH_DRAFT_ACCT'''
 +
   
 
'''SH_IRA_FLAG'''
 
'''SH_IRA_FLAG'''
 +
    A flag indicating the share is an IRA
 +
 
'''SH_IRA_TYPE'''
 
'''SH_IRA_TYPE'''
 +
    A description of the type of IRA the share is
 +
 
'''SH_LAST_AMOUNT'''
 
'''SH_LAST_AMOUNT'''
 +
   
 
'''SH_LAST_DATE'''
 
'''SH_LAST_DATE'''
 +
   
 
'''SH_LAST_STMT_DATE'''
 
'''SH_LAST_STMT_DATE'''
 +
 
'''SH_MONTHLY_ADB1'''
 
'''SH_MONTHLY_ADB1'''
 +
    The share average daily balance for the past month
 +
 
'''SH_OWNER'''
 
'''SH_OWNER'''
 +
    The name of the owner of the share
 +
 
'''SH_PLEDGE_AMOUNT'''
 
'''SH_PLEDGE_AMOUNT'''
 +
   
 
'''SH_PREV_DESC_ABRV'''
 
'''SH_PREV_DESC_ABRV'''
 +
    The share previous description abreviation
 +
 
'''SH_PRIOR_DIV_RATE'''
 
'''SH_PRIOR_DIV_RATE'''
 +
    The share prior dividend rate
 +
 
'''SH_PRIOR_YTD_DIV'''
 
'''SH_PRIOR_YTD_DIV'''
 +
    The share prior year to date total dividends
 +
 
'''SH_RECORDER_NAME'''
 
'''SH_RECORDER_NAME'''
 +
    The name of the teller who recorded the share
 +
 
'''SH_REGD_WTHDRAWLS'''
 
'''SH_REGD_WTHDRAWLS'''
 +
    The number of Regd transaction this month
 +
 
'''SH_SELLER_NAME'''
 
'''SH_SELLER_NAME'''
 +
    The name of the teller who opened the share with the member

Latest revision as of 23:09, 28 August 2012

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

   The certificate maturity date

SH_CERT_MAT_DATE_MTH

   The certificate maturity month

SH_ACC

   The Share ACC Code

SH_ADB_DAYS

   The Average Daily Balance Days

SH_CD_FLAG

   Flag indicating if the share is a Certificate of Deposit

SH_CERT_MAT_DT_LS4

   The certificate maturity date

SH_DESC_ABRV_LONGDESC

   The long form of the share description abbreviation 

SH_DRAFT_ACCT

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_LAST_AMOUNT

SH_LAST_DATE

SH_LAST_STMT_DATE

SH_MONTHLY_ADB1

   The share average daily balance for the past month

SH_OWNER

   The name of the owner of the share

SH_PLEDGE_AMOUNT

SH_PREV_DESC_ABRV

   The share previous description abreviation

SH_PRIOR_DIV_RATE

   The share prior dividend rate

SH_PRIOR_YTD_DIV

   The share prior year to date total dividends

SH_RECORDER_NAME

   The name of the teller who recorded the share

SH_REGD_WTHDRAWLS

   The number of Regd transaction this month

SH_SELLER_NAME

   The name of the teller who opened the share with the member