CollatTrackItem
ODI Extracts
>
CIF2020
>
CollatTrackItem
Extract to provide collateral information by loan per institution
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| CIF2020 | Dlt | Delete flag | String | 1 | 0 | 0 | ||
| CIF2020 | SrcKey | Record key | String | 128 | 0 | 0 | ||
| CIF2020 | FornKey | Foreign key | String | 24 | 0 | 0 | ||
| CIF2020 | AcctId | Account Number | Integer | 9 | 16 | 0 | ||
| CIF2020 | AcctType | Account Type | String | 1 | 0 | 0 | ||
| CIF2020 | CusipId | Cusip Number | String | 10 | 0 | 0 | ||
| CIF2020 | CusipBankId | Cusip Bank# | Integer | 2 | 3 | 0 | ||
| CIF2020 | CollatValAmt | Current Value | Integer | 7 | 13 | 2 | ||
| CIF2020 | CollatMatDt | Maturity Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CollatUnit | Units | Integer | 6 | 11 | 0 | ||
| CIF2020 | CollatItemDocDt | Document Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CollatStat | Status Code | String | 2 | 0 | 0 | ||
| CIF2020 | CollatStatDesc | Description | String | 40 | 0 | 0 | ||
| CIF2020 | CollatStatDt | Status Date | Integer | 4 | 7 | 0 | ||
| CIF2020 | DocLocCode | Location | String | 10 | 0 | 0 | ||
| CIF2020 | CollatOrgValAmt | Original value | Integer | 7 | 13 | 2 | ||
| CIF2020 | CollatRcptDt | Received date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CollatValDt | Current value date | Integer | 4 | 7 | 0 | ||
| CIF2020 | PriceDt | Priced date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CollatRecDt | Recorded date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CollatRecId | Recorded number | String | 30 | 0 | 0 | ||
| CIF2020 | CollatRecCode | Recorded location | String | 2 | 0 | 0 | ||
| CIF2020 | CollatCode | Collateral Type | Integer | 2 | 3 | 0 | ||
| CIF2020 | CollatDesc | Collateral Description | String | 60 | 0 | 0 | ||
| CIF2020 | PropStreet1 | Property Street | String | 30 | 0 | 0 | ||
| CIF2020 | PropCity | Property City | String | 20 | 0 | 0 | ||
| CIF2020 | PropState | Property State | String | 2 | 0 | 0 | ||
| CIF2020 | PropPostalCode | Property Zip Code | Integer | 5 | 9 | 0 | ||
| CIF2020 | PropCounty | Property County Name | String | 20 | 0 | 0 | ||
| CIF2020 | CollatToLnRelCode | Primary | String | 1 | 0 | 0 |
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.
Did this page help you?
Last updated Fri Feb 21 2025