Vital Signs Internal Tables - Revision history

>Jeremyb at 20:37, 4 September 2012

2012-09-04T20:37:55Z

>Jeremyb: /* LNAPP Fields */

2012-09-04T20:34:50Z

‎LNAPP Fields

>Jeremyb: /* SH Fields */

2012-09-04T20:34:07Z

‎SH Fields

Show changes

>Jeremyb: /* MBR Fields */

2012-09-04T20:30:20Z

‎MBR Fields

Show changes

>Jeremyb: /* VEHCINFO Fields */

2012-09-04T20:26:06Z

‎VEHCINFO Fields

>Jeremyb: /* LNTERMS Fields */

2012-09-04T20:24:50Z

‎LNTERMS Fields

>Jeremyb: /* LNADDM Fields */

2012-09-04T20:21:55Z

‎LNADDM Fields

Show changes

>Jeremyb: /* LN Fields */

2012-09-04T20:16:10Z

‎LN Fields

Show changes

>Jeremyb: /* DLRINFO Fields */

2012-09-04T20:11:02Z

‎DLRINFO Fields

>Jeremyb: Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' '''SH''' '''LN''' '''LNADDM''' '''LNAPP''' '''LNTERMS''' '''DLRINFO''..."

2012-09-04T19:58:38Z

Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' '''SH''' '''LN''' '''LNADDM''' '''LNAPP''' '''LNTERMS''' '''DLRINFO''..."

New page

== Overview ==

The definitions of the Tables and Fields available in Vital Signs

== Tables ==
'''MBR'''
'''SH'''
'''LN'''
'''LNADDM'''
'''LNAPP'''
'''LNTERMS'''
'''DLRINFO'''
'''VEHCINFO'''

== MBR Fields ==

== SH Fields ==

== LN Fields ==

== LNADDM Fields ==

== LNAPP Fields ==

== LNTERMS Fields ==

== DLRINFO Fields ==

== VEHCINFO Fields ==

← Older revision		Revision as of 20:34, 4 September 2012
Line 1,166:		Line 1,166:

	== LNAPP Fields ==		== LNAPP Fields ==
		+
		+	'''LNAPP_ACTION'''
		+	Action on Loan Application
		+
		+	'''LNAPP_ACTION_DATE'''
		+	Date loan application action was modified
		+
		+	'''LNAPP_APP_KEY'''
		+	The loan application key (9 digit ssn + 3 digit loan app number)
		+
		+	'''LNAPP_LOAN_TYPE'''
		+	Loan Type
		+
		+	'''LNAPP_ORIG_BRANCH'''
		+	Original branch of loan application

	== LNTERMS Fields ==		== LNTERMS Fields ==

← Older revision		Revision as of 20:26, 4 September 2012
Line 821:		Line 821:

	== VEHCINFO Fields ==		== VEHCINFO Fields ==
		+
		+	'''LN_VI_AMOUNT_FINANCED'''
		+	The amount financed for the vehicle
		+
		+	'''LN_VI_DEALER'''
		+	The dealer where the vehicle was purchased
		+
		+	'''LN_VI_DEALER_CODE'''
		+	The dealer's code
		+
		+	'''LN_VI_LICENSE_NUM'''
		+	The vehicle license number
		+
		+	'''LN_VI_PAID_FEE_AMOUNT'''
		+
		+	'''LN_VI_PURCHASE_ORDER'''
		+
		+	'''LN_VI_SEQUENCE_NBR'''
		+	The sequence number
		+
		+	'''LN_VI_STATE'''
		+	The State that the vehicle is registered in
		+
		+	'''LN_VI_TITLE_NUM'''
		+
		+	'''LN_VI_TITLE_RECIP'''
		+
		+	'''LN_VI_TTL_EXPECT_DATE'''
		+
		+	'''LN_VI_TTL_RECVD_DATE'''
		+
		+	'''LN_VI_TTL_RELSD_DATE'''
		+
		+	'''LN_VI_VEHL_MAKE'''
		+	The make of the vehicle
		+
		+	'''LN_VI_VEHL_MODEL'''
		+	The model of the vehicle
		+
		+	'''LN_VI_VEHL_RETAIL'''
		+	The retail value of the vehicle
		+
		+	'''LN_VI_VEHL_VALUE'''
		+	The value of the vehicle
		+
		+	'''LN_VI_VEHL_YEAR'''
		+
		+	'''LN_VI_VI_APP_KEY'''
		+
		+	'''LN_VI_VIN_NUMBER'''
		+	The vehicle identification number
		+
		+	'''LN_VI_VIN_SUB_NUMBER'''

← Older revision		Revision as of 20:24, 4 September 2012
Line 597:		Line 597:

	== LNTERMS Fields ==		== LNTERMS Fields ==
		+
		+	'''LNTERMS_ACCOUNT'''
		+	The loan account number
		+
		+	'''LNTERMS_ACTION'''
		+	The loan action
		+
		+	'''LNTERMS_ALT_AMOUNT'''
		+
		+	'''LNTERMS_ALT_NUMBER'''
		+
		+	'''LNTERMS_ALT_START_DATE'''
		+
		+	'''LNTERMS_AMOUNT'''
		+	The loan amount
		+
		+	'''LNTERMS_APP_KEY'''
		+	The loan application key
		+
		+	'''LNTERMS_APR'''
		+	The loan apr
		+
		+	'''LNTERMS_AUTO_CALC_INT'''
		+
		+	'''LNTERMS_BALLOON_PYMT_DATE'''
		+	The loan balloon payment date
		+
		+	'''LNTERMS_CASH_APR'''
		+
		+	'''LNTERMS_CENSUS_TRACT'''
		+
		+	'''LNTERMS_COLLATERAL'''
		+	The loan collateral
		+
		+	'''LNTERMS_DESCRIPTION'''
		+	The loan description
		+
		+	'''LNTERMS_DIS_INSUR_AMT'''
		+
		+	'''LNTERMS_DISBURSAL_DATE'''
		+
		+	'''LNTERMS_DISCLOSURE_CODE'''
		+
		+	'''LNTERMS_DRAFT_ACCT'''
		+
		+	'''LNTERMS_DUE_DATE'''
		+
		+	'''LNTERMS_ENTRY_DATE'''
		+	The loan open date
		+
		+	'''LNTERMS_FINAL_ADV_DATE'''
		+
		+	'''LNTERMS_FIRST_RT_CHG_DATE'''
		+	The date of the first rate change for the loan
		+
		+	'''LNTERMS_FREQUENCY'''
		+
		+	'''LNTERMS_FULLY_INDEXED_RATE'''
		+
		+	'''LNTERMS_GROUP'''
		+
		+	'''LNTERMS_HOLDER'''
		+
		+	'''LNTERMS_INSUR_CODES'''
		+
		+	'''LNTERMS_ITEMIZATION'''
		+
		+	'''LNTERMS_KTFR_ACCT'''
		+
		+	'''LNTERMS_KTFR_SUFFIX'''
		+
		+	'''LNTERMS_LAST_LT_NUMBER'''
		+
		+	'''LNTERMS_LAST_NUMBER'''
		+
		+	'''LNTERMS_LAST_SSN'''
		+
		+	'''LNTERMS_LIFE_INSUR_AMT'''
		+
		+	'''LNTERMS_LOAN_TYPE'''
		+	The loan type
		+
		+	'''LNTERMS_MARGIN_SECURITY'''
		+
		+	'''LNTERMS_METHOD'''
		+
		+	'''LNTERMS_MICR_NUMBER'''
		+
		+	'''LNTERMS_NONDISCNT_APR'''
		+
		+	'''LNTERMS_NOTE'''
		+
		+	'''LNTERMS_NUMBER'''
		+
		+	'''LNTERMS_OLD_CREDIT_LIM'''
		+	The old credit limit for the loan
		+
		+	'''LNTERMS_PLEDGE_AMOUNT'''
		+
		+	'''LNTERMS_PLEDGE_CODE'''
		+
		+	'''LNTERMS_PMT_AMOUNT'''
		+
		+	'''LNTERMS_PRCNT_DOWN'''
		+
		+	'''LNTERMS_PRODUCT_CODE'''
		+	The loan product code
		+
		+	'''LNTERMS_PURPOSE'''
		+
		+	'''LNTERMS_RECORDER'''
		+	The loan recorder
		+
		+	'''LNTERMS_REF_SUFFIX_1'''
		+
		+	'''LNTERMS_REF_SUFFIX_2'''
		+
		+	'''LNTERMS_REF_SUFFIX_3'''
		+
		+	'''LNTERMS_REQUEST_AMOUNT'''
		+
		+	'''LNTERMS_REVIEW_DATE'''
		+
		+	'''LNTERMS_SELLER'''
		+	The seller of the loan
		+
		+	'''LNTERMS_SKIP_CODE'''
		+
		+	'''LNTERMS_SMSA'''
		+
		+	'''LNTERMS_SUBS_CHANGE'''
		+
		+	'''LNTERMS_SUFFIX'''
		+	The loan suffix
		+
		+	'''LNTERMS_TERM'''
		+	The loan term
		+
		+	'''LNTERMS_TOT_FIN_CHARGE'''
		+
		+	'''LNTERMS_TOT_OF_PAYMENTS'''
		+
		+	'''LNTERMS_TRANSACTION_TYPE'''
		+
		+	'''LNTERMS_VRL_CODE'''
		+
		+	'''LNTERMS_VRL_FREQ'''
		+
		+	'''LNTERMS_VRL_INDEX'''
		+
		+	'''LNTERMS_VRL_MARGIN'''
		+
		+	'''LNTERMS_X_PLDGE_ACCT'''
		+
		+	'''LNTERMS_X_PLDGE_SUFFIX'''

	== DLRINFO Fields ==		== DLRINFO Fields ==

← Older revision		Revision as of 20:11, 4 September 2012
Line 26:		Line 26:

	== DLRINFO Fields ==		== DLRINFO Fields ==
		+
		+	'''DLR_ADDR1'''
		+	The dealer's address lines 1
		+
		+	'''DLR_ADDR2'''
		+	The dealer's address lines 2
		+
		+	'''DLR_ADDR3'''
		+	The dealer's address lines 3
		+
		+	'''DLR_CHECK_MIN'''
		+
		+	'''DLR_CITY'''
		+	The city the dealer is located in
		+
		+	'''DLR_COUNTRY_CODE'''
		+	The dealer's 2 digit country code
		+
		+	'''DLR_DEALER_GRADE'''
		+	The grade associated with the dealer
		+
		+	'''DLR_FEE_CODE'''
		+
		+	'''DLR_FEE_FIXED'''
		+
		+	'''DLR_FEE_FLAG'''
		+
		+	'''DLR_FEE_MAXIMUM'''
		+
		+	'''DLR_NAME'''
		+	The name of the dealer
		+
		+	'''DLR_PHONE'''
		+	The phone number for the dealer
		+
		+	'''DLR_PTD_COUNT'''
		+
		+	'''DLR_PTD_FEE_AMOUNT'''
		+
		+	'''DLR_PTD_LOAN_AMOUNT'''
		+
		+	'''DLR_PY_COUNT'''
		+
		+	'''DLR_PY_FEE_AMOUNT'''
		+
		+	'''DLR_PY_LOAN_AMOUNT'''
		+
		+	'''DLR_RESERVE_AMT'''
		+
		+	'''DLR_STATE'''
		+	The state the dealership is located in
		+
		+	'''DLR_TTD_COUNT'''
		+
		+	'''DLR_TTD_FEE_AMOUNT'''
		+
		+	'''DLR_TTD_LOAN_AMOUNT'''
		+
		+	'''DLR_YTD_COUNT'''
		+
		+	'''DLR_YTD_FEE_AMOUNT'''
		+
		+	'''DLR_YTD_LOAN_AMOUNT'''
		+
		+	'''DLR_ZIP'''

	== VEHCINFO Fields ==		== VEHCINFO Fields ==

@@ Line 5: / Line 5: @@
 == Tables ==
 '''MBR'''
 '''SH'''
 '''LN'''
 '''LNADDM'''
 '''LNAPP'''
 '''LNTERMS'''
 '''DLRINFO'''
 '''VEHCINFO'''
 == MBR Fields ==