Loan Types & Products
Revision as of 21:39, 31 August 2012 by >Jeremyb
Summary
The loan cross reference spreadsheet enables Vital Signs to group and order the products for simpler selection. The CCYYMMDD appended to the LNXREF filename should represent the most recent date that the file was modified
Columns
LN_COLLATERAL
The loan collateral code from the core
LN_ATTR_NBR
If an attribute has been created in the ATTRFILE based on a member having this loan, that attribute number should be placed in this column
LN_PROD_NBR
If an attribute is also a countable product such as a vehicle loan, the Product Number from the ATTRFILE should be placed in this column
DESCRIPTION
The description of the loan that is displayed in Vital Signs
LN_SECURED
A yes/no entry to signify if the Loan is Secured or Not Note: for future development
LN_TYPE
The Loan Type is the master hierarchical grouping of loans, example : Mortgage
LN_TYPE_SORT
The Loan Type Sort is the sequential order that the Unique Loan Type groups will be displayed in Vital Signs
LN_PRODUCT
The Loan Product Sub group of the Loan Type grouping, example : First Mortgage
LN_PRODUCT_SORT
The Loan Product Sort is the sequential order that the Unique Share Product groups will be displayed in Vital Signs