Difference between revisions of "Data Change Fields"
>Jeremyb (Created page with "'''The fields available in the Data Change application''' ==Loan Level== '''LN_NBR_LATE_PMTS_LAST_3MTHS''' LN_ACTION_DATE LN_AMOUNT LN_APP_NUMBER LN_APP_SSN LN_APPLY_DATE LN...") |
>Jeremyb |
||
| Line 4: | Line 4: | ||
'''LN_NBR_LATE_PMTS_LAST_3MTHS''' | '''LN_NBR_LATE_PMTS_LAST_3MTHS''' | ||
| − | LN_ACTION_DATE | + | '''LN_ACTION_DATE''' |
| − | LN_AMOUNT | + | '''LN_AMOUNT''' |
| − | LN_APP_NUMBER | + | '''LN_APP_NUMBER''' |
| − | LN_APP_SSN | + | '''LN_APP_SSN''' |
| − | LN_APPLY_DATE | + | '''LN_APPLY_DATE''' |
| − | LN_BALLOON_PYMT_DT | + | '''LN_BALLOON_PYMT_DT''' |
| − | LN_CF_CREDIT_CARD_LOAN | + | '''LN_CF_CREDIT_CARD_LOAN''' |
| − | LN_CF_LOC_LOAN | + | '''LN_CF_LOC_LOAN''' |
| − | 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''' |
| − | LN_CF_STUDENT_INFO | + | '''LN_CF_STUDENT_INFO''' |
| − | LN_COLLATERAL_DESC | + | '''LN_COLLATERAL_DESC''' |
| − | LN_COLLECTOR | + | '''LN_COLLECTOR''' |
| − | LN_CREDIT_SSN | + | '''LN_CREDIT_SSN''' |
| − | LN_DECISION_TELLER_NAME | + | '''LN_DECISION_TELLER_NAME''' |
| − | LN_DENIAL_NOTICE | + | '''LN_DENIAL_NOTICE''' |
| − | LN_DENIAL_REASON | + | '''LN_DENIAL_REASON''' |
| − | LN_DESCRIPTION | + | '''LN_DESCRIPTION''' |
| − | LN_FIRST_PAY_DATE | + | '''LN_FIRST_PAY_DATE''' |
| − | LN_FREQUENCY | + | '''LN_FREQUENCY''' |
| − | LN_HIGH_BALANCE | + | '''LN_HIGH_BALANCE''' |
| − | LN_HIGHEST_DELQ_AMT | + | '''LN_HIGHEST_DELQ_AMT''' |
| − | LN_HIGHEST_DELQ_DT | + | '''LN_HIGHEST_DELQ_DT''' |
| − | LN_LAST_AMOUNT | + | '''LN_LAST_AMOUNT''' |
| − | LN_LAST_CODE | + | '''LN_LAST_CODE''' |
| − | LN_LAST_DATE | + | '''LN_LAST_DATE''' |
| − | LN_LAST_PYMT_AMT | + | '''LN_LAST_PYMT_AMT''' |
| − | LN_LAST_PYMT_DATE | + | '''LN_LAST_PYMT_DATE''' |
| − | LN_MATURITY_DATE | + | '''LN_MATURITY_DATE''' |
| − | LN_METHOD | + | '''LN_METHOD''' |
| − | LN_OFFICER_NAME | + | '''LN_OFFICER_NAME''' |
| − | LN_ORIGINAL_APR | + | '''LN_ORIGINAL_APR''' |
| − | LN_PAID_OFF_DATE | + | '''LN_PAID_OFF_DATE''' |
| − | LN_PARTIAL_PAYMENT | + | '''LN_PARTIAL_PAYMENT''' |
| − | LN_PLEDGE_AMOUNT | + | '''LN_PLEDGE_AMOUNT''' |
| − | LN_PLEDGE_CODE | + | '''LN_PLEDGE_CODE''' |
| − | LN_PMT_HISTORY | + | '''LN_PMT_HISTORY''' |
| − | LN_PURPOSE | + | '''LN_PURPOSE''' |
| − | LN_RECORDER_NAME | + | '''LN_RECORDER_NAME''' |
| − | LN_REVIEW_DATE | + | '''LN_REVIEW_DATE''' |
| − | LN_SECURE_UNSECURE_FLAG | + | '''LN_SECURE_UNSECURE_FLAG''' |
| − | LN_SELLER_NAME | + | '''LN_SELLER_NAME''' |
| − | LN_TERM | + | '''LN_TERM''' |
| − | LN_VAR_RATE_CODE | + | '''LN_VAR_RATE_CODE''' |
| − | LN_VEHICLE_INFO_KEY | + | '''LN_VEHICLE_INFO_KEY''' |
| − | LN_NBR_LATE_PMTS | + | '''LN_NBR_LATE_PMTS''' |
| + | |||
==Member Level== | ==Member Level== | ||
| − | + | '''MBR_ADDR1''' | |
| − | + | '''MBR_ADDR2''' | |
| − | MBR_ADDR1 | + | '''MBR_AFFINITY_CODE''' |
| − | MBR_ADDR2 | + | '''MBR_AGE_AS_DECIMAL''' |
| − | MBR_AFFINITY_CODE | + | '''MBR_BIRTH_DATE''' |
| − | MBR_AGE_AS_DECIMAL | + | '''MBR_CELL_PHONE''' |
| − | MBR_BIRTH_DATE | + | '''MBR_CITIZENSHIP''' |
| − | MBR_CELL_PHONE | + | '''MBR_CITY''' |
| − | MBR_CITIZENSHIP | + | '''MBR_CLASS_CODE''' |
| − | MBR_CITY | + | '''MBR_COUNTRY_CODE''' |
| − | MBR_CLASS_CODE | + | '''MBR_DEPARTMENT''' |
| − | MBR_COUNTRY_CODE | + | '''MBR_DRIVER_LIC_NUM''' |
| − | MBR_DEPARTMENT | + | '''MBR_DRIVER_LIC_STATE''' |
| − | MBR_DRIVER_LIC_NUM | + | '''MBR_E_MAIL''' |
| − | MBR_DRIVER_LIC_STATE | + | '''MBR_ELIGIBILITY''' |
| − | MBR_E_MAIL | + | '''MBR_EMPL_NUM''' |
| − | MBR_ELIGIBILITY | + | '''MBR_EMPL_STATUS''' |
| − | MBR_EMPL_NUM | + | '''MBR_EMPLOYER_NAME''' |
| − | MBR_EMPL_STATUS | + | '''MBR_ESCHEAT_DATE''' |
| − | MBR_EMPLOYER_NAME | + | '''MBR_FINAL_CLOSE_MTH''' |
| − | MBR_ESCHEAT_DATE | + | '''MBR_FIRST_NAME''' |
| − | MBR_FINAL_CLOSE_MTH | + | '''MBR_GROUP''' |
| − | MBR_FIRST_NAME | + | '''MBR_HOUSEHOLD_CODE''' |
| − | MBR_GROUP | + | '''MBR_LAST_NAME''' |
| − | MBR_HOUSEHOLD_CODE | + | '''MBR_MAIDEN_NAME''' |
| − | MBR_LAST_NAME | + | '''MBR_MARITAL_STATUS''' |
| − | MBR_MAIDEN_NAME | + | '''MBR_MIDDLE_NAME''' |
| − | MBR_MARITAL_STATUS | + | '''MBR_ORIG_OPEN_MTH''' |
| − | MBR_MIDDLE_NAME | + | '''MBR_PHONE''' |
| − | MBR_ORIG_OPEN_MTH | + | '''MBR_PROFESSION_YEARS''' |
| − | MBR_PHONE | + | '''MBR_RECORDER''' |
| − | MBR_PROFESSION_YEARS | + | '''MBR_RECORDER_NAME''' |
| − | MBR_RECORDER | + | '''MBR_REF''' |
| − | MBR_RECORDER_NAME | + | '''MBR_REF2''' |
| − | MBR_REF | + | '''MBR_REF3''' |
| − | MBR_REF2 | + | '''MBR_REF4''' |
| − | MBR_REF3 | + | '''MBR_REFER''' |
| − | MBR_REF4 | + | '''MBR_RELATE_FLAG''' |
| − | MBR_REFER | + | '''MBR_RESIDENCE_CODE''' |
| − | MBR_RELATE_FLAG | + | '''MBR_REST_FLAG_11''' |
| − | MBR_RESIDENCE_CODE | + | '''MBR_SELF_EMPLOYED''' |
| − | MBR_REST_FLAG_11 | + | '''MBR_SELLER''' |
| − | MBR_SELF_EMPLOYED | + | '''MBR_SELLER_NAME''' |
| − | MBR_SELLER | + | '''MBR_SSN_NUM''' |
| − | MBR_SELLER_NAME | + | '''MBR_STATE''' |
| − | MBR_SSN_NUM | + | '''MBR_WORK_PHONE''' |
| − | MBR_STATE | + | '''MBR_ZIP''' |
| − | MBR_WORK_PHONE | + | '''MBR_ZIP+4''' |
| − | MBR_ZIP | ||
| − | |||
== Share Level == | == Share Level == | ||
| − | SH_CERT_MAT_DATE | + | '''SH_CERT_MAT_DATE''' |
| − | SH_CERT_MAT_DATE_MTH | + | '''SH_CERT_MAT_DATE_MTH''' |
| − | + | '''SH_ACC''' | |
| − | SH_ACC | + | '''SH_ADB_DAYS''' |
| − | SH_ADB_DAYS | + | '''SH_CD_FLAG''' |
| − | SH_CD_FLAG | + | '''SH_CERT_MAT_DT_LS4''' |
| − | SH_CERT_MAT_DT_LS4 | + | '''SH_DESC_ABRV_LONGDESC''' |
| − | SH_DESC_ABRV_LONGDESC | + | '''SH_DRAFT_ACCT''' |
| − | SH_DRAFT_ACCT | + | '''SH_IRA_FLAG''' |
| − | SH_IRA_FLAG | + | '''SH_IRA_TYPE''' |
| − | SH_IRA_TYPE | + | '''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 | + | '''SH_OWNER''' |
| − | SH_OWNER | + | '''SH_PLEDGE_AMOUNT''' |
| − | SH_PLEDGE_AMOUNT | + | '''SH_PREV_DESC_ABRV''' |
| − | SH_PREV_DESC_ABRV | + | '''SH_PRIOR_DIV_RATE''' |
| − | SH_PRIOR_DIV_RATE | + | '''SH_PRIOR_YTD_DIV''' |
| − | SH_PRIOR_YTD_DIV | + | '''SH_RECORDER_NAME''' |
| − | SH_RECORDER_NAME | + | '''SH_REGD_WTHDRAWLS''' |
| − | SH_REGD_WTHDRAWLS | + | '''SH_SELLER_NAME''' |
| − | SH_SELLER_NAME | ||
Revision as of 22:40, 28 August 2012
The fields available in the Data Change application
Loan Level
LN_NBR_LATE_PMTS_LAST_3MTHS LN_ACTION_DATE LN_AMOUNT LN_APP_NUMBER LN_APP_SSN LN_APPLY_DATE LN_BALLOON_PYMT_DT LN_CF_CREDIT_CARD_LOAN LN_CF_LOC_LOAN LN_CF_OFFLINE_LOAN LN_CF_OPEN_END_FLAG LN_CF_REAL_ESTATE_LOAN LN_CF_STUDENT_INFO LN_COLLATERAL_DESC LN_COLLECTOR LN_CREDIT_SSN LN_DECISION_TELLER_NAME LN_DENIAL_NOTICE LN_DENIAL_REASON LN_DESCRIPTION LN_FIRST_PAY_DATE LN_FREQUENCY LN_HIGH_BALANCE LN_HIGHEST_DELQ_AMT LN_HIGHEST_DELQ_DT LN_LAST_AMOUNT LN_LAST_CODE LN_LAST_DATE LN_LAST_PYMT_AMT LN_LAST_PYMT_DATE LN_MATURITY_DATE LN_METHOD LN_OFFICER_NAME LN_ORIGINAL_APR LN_PAID_OFF_DATE LN_PARTIAL_PAYMENT LN_PLEDGE_AMOUNT LN_PLEDGE_CODE LN_PMT_HISTORY LN_PURPOSE LN_RECORDER_NAME LN_REVIEW_DATE LN_SECURE_UNSECURE_FLAG LN_SELLER_NAME LN_TERM LN_VAR_RATE_CODE LN_VEHICLE_INFO_KEY LN_NBR_LATE_PMTS
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
