8.3 Instruments
Connectors in this category manage core financial instruments and products, such as loans, deposits, contracts, and securities, along with their terms, conditions, and balances associated with each instrument.
Entities
For all target entities in the Instruments category:
- Primary Keys (PK): As Of Date, Account or Contract Number
- Execution Parameters (variable mappings):
- Input File Name
- Load Identifier
- Data File Specifications ID
Table 8-4 List of connectors in this category is listed below
| # | Primary Source | Target | # of fields | # of key fields | # of Direct Mapping | # of Expression Mapping | # of variable mapping | # of LOV mapping |
|---|---|---|---|---|---|---|---|---|
| 1 | Stage Letter of Credit | Stage Off Balance sheet | 91 | 2 | 80 | 1 | 3 | 5 |
| 2 | Stage Borrowings | Stage Liability | 135 | 2 | 121 | 1 | 3 | 8 |
| 3 | Stage CASA | Stage Liability | 159 | 2 | 145 | 1 | 3 | 8 |
| 4 | Stage Term Deposit Contracts | Stage Liability | 161 | 2 | 149 | 1 | 3 | 6 |
| 5 | Stage Bill Contracts | Stage Assets | 99 | 2 | 87 | 1 | 3 | 6 |
| 6 | Stage Cards | Stage Assets | 145 | 2 | 133 | 0 | 3 | 7 |
| 7 | Stage Investments | Stage Assets | 148 | 2 | 135 | 1 | 3 | 7 |
| 8 | Stage Over-Draft Contracts | Stage Assets | 151 | 2 | 133 | 5 | 3 | 8 |
| 9 | Stage Loan Contracts | Stage Assets | 230 | 2 | 207 | 8 | 3 | 10 |
| 10 | Stage Leases Contracts | Stage Assets | 167 | 2 | 147 | 8 | 3 | 7 |
| 11 | Stage Foreign Exchange Contracts | Stage Derivatives | 248 | 2 | 236 | 1 | 3 | 6 |
| 12 | Stage Forward Contracts | Stage Derivatives | 236 | 2 | 225 | 1 | 3 | 5 |
| 13 | Stage Option Contracts | Stage Derivatives | 271 | 2 | 259 | 1 | 3 | 6 |
| 14 | Stage Swaps Contracts | Stage Derivatives | 275 | 2 | 264 | 1 | 3 | 5 |
| 15 | Stage Commitment Contracts | Stage Loan Commitments | 95 | 2 | 84 | 0 | 3 | 6 |
| 16 | Stage Credit Facility Details | Stage Off Balance | 29 | 2 | 14 | 0 | 0 | 0 |