Difference between revisions of "Data Change Fields"
>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
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
