Loan Types & Products

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