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

#	Connector Name	Primary Source	Target	# of fields	# of key fields	# of Direct Mapping	# of Expression Mapping	# of variable mapping	# of LOV mapping
1	Instruments	Stage Letter of Credit	Stage Off Balance sheet	91	2	80	1	3	5
2	Instruments	Stage Borrowings	Stage Liability	135	2	121	1	3	8
3	Instruments	Stage CASA	Stage Liability	159	2	145	1	3	8
4	Instruments	Stage Term Deposit Contracts	Stage Liability	161	2	149	1	3	6
5	Instruments	Stage Bill Contracts	Stage Assets	99	2	87	1	3	6
6	Instruments	Stage Cards	Stage Assets	145	2	133	0	3	7
7	Instruments	Stage Investments	Stage Assets	148	2	135	1	3	7
8	Instruments	Stage Over-Draft Contracts	Stage Assets	151	2	133	5	3	8
9	Instruments	Stage Loan Contracts	Stage Assets	230	2	207	8	3	10
10	Instruments	Stage Leases Contracts	Stage Assets	167	2	147	8	3	7
11	Instruments	Stage Foreign Exchange Contracts	Stage Derivatives	248	2	236	1	3	6
12	Instruments	Stage Forward Contracts	Stage Derivatives	236	2	225	1	3	5
13	Instruments	Stage Option Contracts	Stage Derivatives	271	2	259	1	3	6
14	Instruments	Stage Swaps Contracts	Stage Derivatives	275	2	264	1	3	5
15	Instruments	Stage Commitment Contracts	Stage Loan Commitments	95	2	84	0	3	6