Difference between revisions of "Data Change Fields"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
Line 4: Line 4:
  
 
'''LN_NBR_LATE_PMTS_LAST_3MTHS'''
 
'''LN_NBR_LATE_PMTS_LAST_3MTHS'''
 +
    The number of late payments over the past 3 months
 +
 
'''LN_ACTION_DATE'''
 
'''LN_ACTION_DATE'''
 +
    The date the action was changed on the loan
 +
 
'''LN_AMOUNT'''
 
'''LN_AMOUNT'''
 +
    The original amount of the loan
 +
 
'''LN_APP_NUMBER'''
 
'''LN_APP_NUMBER'''
 +
    The 3 digit loan application number
 +
 
'''LN_APP_SSN'''
 
'''LN_APP_SSN'''
 +
    The loan application social security number
 +
 
'''LN_APPLY_DATE'''
 
'''LN_APPLY_DATE'''
 +
    The date the loan was applied for
 +
 
'''LN_BALLOON_PYMT_DT'''
 
'''LN_BALLOON_PYMT_DT'''
 +
    The balloon payment date of the loan
 +
 
'''LN_CF_CREDIT_CARD_LOAN'''
 
'''LN_CF_CREDIT_CARD_LOAN'''
 +
    Flag indicating the loan is a credit card
 +
 
'''LN_CF_LOC_LOAN'''
 
'''LN_CF_LOC_LOAN'''
 +
    Flag indicating the loan is a line of credit
 +
 
'''LN_CF_OFFLINE_LOAN'''
 
'''LN_CF_OFFLINE_LOAN'''
'''LN_CF_OPEN_END_FLAG'''
+
   
 +
'''LN_CF_OPEN_END_FLAG'''  
 +
 
 
'''LN_CF_REAL_ESTATE_LOAN'''
 
'''LN_CF_REAL_ESTATE_LOAN'''
 +
    Flag indicating the loan is for Real Estate
 +
 
'''LN_CF_STUDENT_INFO'''
 
'''LN_CF_STUDENT_INFO'''
 +
 
'''LN_COLLATERAL_DESC'''
 
'''LN_COLLATERAL_DESC'''
 +
    The description of the collateral for the loan
 +
 
'''LN_COLLECTOR'''
 
'''LN_COLLECTOR'''
 +
    The name of the collector on file for the loan
 +
 
'''LN_CREDIT_SSN'''
 
'''LN_CREDIT_SSN'''
 +
 
'''LN_DECISION_TELLER_NAME'''
 
'''LN_DECISION_TELLER_NAME'''
 +
    The teller who approved the loan
 +
 
'''LN_DENIAL_NOTICE'''
 
'''LN_DENIAL_NOTICE'''
 +
 
'''LN_DENIAL_REASON'''
 
'''LN_DENIAL_REASON'''
 +
 
'''LN_DESCRIPTION'''
 
'''LN_DESCRIPTION'''
 +
    The description of the loan
 +
 
'''LN_FIRST_PAY_DATE'''
 
'''LN_FIRST_PAY_DATE'''
 +
    The date of the first loan payment
 +
 
'''LN_FREQUENCY'''
 
'''LN_FREQUENCY'''
 +
    The frequency for loan payments
 +
 
'''LN_HIGH_BALANCE'''
 
'''LN_HIGH_BALANCE'''
 +
 
'''LN_HIGHEST_DELQ_AMT'''
 
'''LN_HIGHEST_DELQ_AMT'''
 +
    The highest amount of delinquent payments for the loan
 +
 
'''LN_HIGHEST_DELQ_DT'''
 
'''LN_HIGHEST_DELQ_DT'''
 +
 
'''LN_LAST_AMOUNT'''
 
'''LN_LAST_AMOUNT'''
 +
    The last amount of the loan balance
 +
 
'''LN_LAST_CODE'''
 
'''LN_LAST_CODE'''
 +
 
'''LN_LAST_DATE'''
 
'''LN_LAST_DATE'''
 +
 
'''LN_LAST_PYMT_AMT'''
 
'''LN_LAST_PYMT_AMT'''
 +
    The amount of the last loan payment
 +
 
'''LN_LAST_PYMT_DATE'''
 
'''LN_LAST_PYMT_DATE'''
 +
    The date of the last payment
 +
 
'''LN_MATURITY_DATE'''
 
'''LN_MATURITY_DATE'''
 +
    The maturity date of the loan
 +
 
'''LN_METHOD'''
 
'''LN_METHOD'''
 +
   
 
'''LN_OFFICER_NAME'''
 
'''LN_OFFICER_NAME'''
 +
    The loan officer assigned to the loan
 +
 
'''LN_ORIGINAL_APR'''
 
'''LN_ORIGINAL_APR'''
 +
    The original APR of the loan
 +
 
'''LN_PAID_OFF_DATE'''
 
'''LN_PAID_OFF_DATE'''
 +
    The date the loan was paid off
 +
 
'''LN_PARTIAL_PAYMENT'''
 
'''LN_PARTIAL_PAYMENT'''
 +
    The last partial payment for the loan
 +
 
'''LN_PLEDGE_AMOUNT'''
 
'''LN_PLEDGE_AMOUNT'''
 +
 
'''LN_PLEDGE_CODE'''
 
'''LN_PLEDGE_CODE'''
 +
 
'''LN_PMT_HISTORY'''
 
'''LN_PMT_HISTORY'''
 +
    A field containing 30 characters (0-9) which represent the delinquency of the past 30 months of payment history
 +
 
'''LN_PURPOSE'''
 
'''LN_PURPOSE'''
 +
    The loan purpose code
 +
 
'''LN_RECORDER_NAME'''
 
'''LN_RECORDER_NAME'''
 +
    The name of the loan officer who recorded the loan
 +
 
'''LN_REVIEW_DATE'''
 
'''LN_REVIEW_DATE'''
 +
    The date the loan was reviewed
 +
 
'''LN_SECURE_UNSECURE_FLAG'''
 
'''LN_SECURE_UNSECURE_FLAG'''
 +
    Field indicating that the loan is secured by collateral or not
 +
 
'''LN_SELLER_NAME'''
 
'''LN_SELLER_NAME'''
 +
    The name of the teller who sold the loan
 +
 
'''LN_TERM'''
 
'''LN_TERM'''
 +
    The term of the loan
 +
 
'''LN_VAR_RATE_CODE'''
 
'''LN_VAR_RATE_CODE'''
 +
   
 
'''LN_VEHICLE_INFO_KEY'''
 
'''LN_VEHICLE_INFO_KEY'''
 +
    The key to link into vehicle-info
 +
 
'''LN_NBR_LATE_PMTS'''
 
'''LN_NBR_LATE_PMTS'''
 +
    The number of late payment made on the loan
  
  

Revision as of 22:49, 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 MBR_ADDR2 MBR_AFFINITY_CODE MBR_AGE_AS_DECIMAL MBR_BIRTH_DATE MBR_CELL_PHONE MBR_CITIZENSHIP MBR_CITY MBR_CLASS_CODE MBR_COUNTRY_CODE MBR_DEPARTMENT MBR_DRIVER_LIC_NUM MBR_DRIVER_LIC_STATE MBR_E_MAIL MBR_ELIGIBILITY MBR_EMPL_NUM MBR_EMPL_STATUS MBR_EMPLOYER_NAME MBR_ESCHEAT_DATE MBR_FINAL_CLOSE_MTH MBR_FIRST_NAME MBR_GROUP MBR_HOUSEHOLD_CODE MBR_LAST_NAME MBR_MAIDEN_NAME MBR_MARITAL_STATUS MBR_MIDDLE_NAME MBR_ORIG_OPEN_MTH MBR_PHONE MBR_PROFESSION_YEARS MBR_RECORDER MBR_RECORDER_NAME MBR_REF MBR_REF2 MBR_REF3 MBR_REF4 MBR_REFER MBR_RELATE_FLAG MBR_RESIDENCE_CODE MBR_REST_FLAG_11 MBR_SELF_EMPLOYED MBR_SELLER MBR_SELLER_NAME MBR_SSN_NUM MBR_STATE MBR_WORK_PHONE MBR_ZIP MBR_ZIP+4

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