CollatTrackItem

ODI Extracts > Core Director > CollatTrackItem

Extract to provide collateral information by loan per institution

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length	Decimal Places
Core Director	Dlt	Delete record flag			String	1
Core Director	SrcKey	Account Key	MASTER.ISM	COM_MASTER_PRIMARY_KEY	String	20
Core Director	FornKey	Unique record key of Loan	MASTER.ISM	COM_MASTER_PRIMARY_KEY of Loan	String	18
Core Director	AcctId	Account Number	MASTER.ISM	3	String	16
Core Director	AcctType	Account Type	MASTER.ISM	2	String	2
Core Director	CusipId	CUSIP Number	MASTER.ISM	115	String	10
Core Director	CollatValAmt	Unit Value	MASTER.ISM	111	Decimal	16	2
Core Director	CollatUnit	Units Pledged	MASTER.ISM	112	Int32	5
Core Director	CollatValDt	Appraisal Date	MASTER.ISM	138	DateTime	8
Core Director	CollatRecId	Collateral Item ID	MASTER.ISM	147	String	40
Core Director	PropStreet1	Physical Address1	MASTER.ISM	186	String	40
Core Director	PropStreet2	Physical Address2	MASTER.ISM	187	String	40
Core Director	PropCity	Physical Addr City	MASTER.ISM	188	String	25
Core Director	PropState	Physical Address State	MASTER.ISM	189	String	2
Core Director	PropPostalCode	Physical Address Zip	MASTER.ISM	190	String	13
Core Director	CollatCode	Security Type Code	MASTER.ISM	116	String	3
Core Director	CollatDesc	Security Type Code Description	USERCOD.ISM	USER_DESCRIPTION	String	40

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Fri Feb 21 2025