CollatTrackItem
Operational Data Integration (ODI)
>
ODI Extracts
>
Core Director
>
CollatTrackItem
Extract to provide collateral information by loan per institution
Core Director
Dlt
Delete record flag
String
1
SrcKey
Account Key
MASTER.ISM
COM_MASTER_PRIMARY_KEY
20
FornKey
Unique record key of Loan
COM_MASTER_PRIMARY_KEY of Loan
18
AcctId
Account Number
3
16
AcctType
Account Type
2
CusipId
CUSIP Number
115
10
CollatValAmt
Unit Value
111
Decimal
CollatUnit
Units Pledged
112
Int32
5
CollatValDt
Appraisal Date
138
DateTime
8
CollatRecId
Collateral Item ID
147
40
PropStreet1
Physical Address1
186
PropStreet2
Physical Address2
187
PropCity
Physical Addr City
188
25
PropState
Physical Address State
189
PropPostalCode
Physical Address Zip
190
13
CollatCode
Security Type Code
116
CollatDesc
Security Type Code Description
USERCOD.ISM
USER_DESCRIPTION
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024