8.4 Instruments Supplementary
- Stage Account Index History: The primary key (PK) attributes are As of
Date, Index Value Start Date, and Account or Contract
Number.
The execution parameters to be passed include Input File Name, Load Identifier, and Data File Specifications ID.
- Stage Account Rate Tiers: The primary key (PK) attributes are As of
Date, Account or Contract Number, and Account Rate Tier
Name.
The execution parameters to be passed include Input File Name, Load Identifier, and Data File Specifications ID.
- Stage Embedded Options: The primary key (PK) attributes are As of
Date, Account or Contract Number, and Account Rate Tier
Name.
The execution parameters to be passed include Input File Name, Load Identifier, and Data File Specifications ID.
- Stage Payments Schedule: The primary key (PK) attributes are As of
Date, Account or Contract Number, Payment Date,
Instrument Type, and Leg Type.
The execution parameters to be passed include Input File Name, Load Identifier, and Data File Specifications ID.
Note:
There is 1 LOV mapping for Stage Account Rate Tiers and Stage Payments Schedule each.Table 8-5 Stage Account Rate Tiers and Stage Payments Schedule table
| # | Connector Name | Primary Source | Target | # of fields | # of key fields | # of Direct Mapping | # of Expression Mapping | # of variable mapping | # of LOV mapping |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Instruments Supplementary | Stage Account Index History | Stage Account Index History | 10 | 3 | 3 | 1 | 3 | 0 |
| 2 | Instruments Supplementary | Stage Account Rate Tiers | Stage Account Rate Tiers | 28 | 3 | 21 | 0 | 3 | 1 |
| 3 | Instruments Supplementary | Stage Embedded Options Schedule | Stage Embedded Options Schedule | 9 | 3 | 2 | 1 | 3 | 0 |
| 4 | Instruments Supplementary | Stage Payment Schedule | Stage Payment Schedule | 12 | 3 | 4 | 1 | 3 | 1 |