Data Table for PACE Cash Activity Upload
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Pamela Totas (Deactivated)
- Former user (Deleted)
The PACE Cash Upload message stream data table shows STAR tags to be used in the data file, either STAR or CSV format, and the corresponding column that the STAR upload processing stream populates in the PACE table. This stream performs an insert through the panels found on the STAR Web Server – no formulas or calculations have been included.
This stream supports all fields defined on the pan-csa_egl_gen_interface.htm panel, whether listed below or not.
The following table describes several required and optional data fields for PACE Cash Upload message stream.
Tag Number/Name | Required/Optional | Data Type | Value/Description of Field | PACE Table | PACE Field |
|---|---|---|---|---|---|
1076 – Update Mode Flag | Optional | CHAR | Used by the procedure to determine if it should check for an existing record or simply insert the record. Options include: | n/a | |
55 – Event Type | Required | CHAR | Required – defaults on panel. Used by message stream for identification of the event. Must be UPLOAD_CASH. | ||
1102 – Source Name | Required | CHAR (15) | Used to resolve src_intfc_inst if tag 1168 is null | n/a | n/a |
1077 – Calculate Reflexive rows | Optional | CHAR | Calculate Reflexive Flows Switch – Y = Yes, N = No. | n/a | n/a |
1081 – Entity Translation Type | Optional | CHAR | Used to indicate that the entity cross reference or entity bank relationship is used to generate the entity identifier. Options include:
| n/a | n/a |
7233 – Entity Xref ID | Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL. | CHAR | Used for entity ID resolution. The value corresponds to the tag 1233 value used for entity cross reference lookup. | n/a | n/a |
7234 – Entity Xref ID Type | Conditionally Required – used when tag 1081 is set to XREFERENCE and tag 1163 is NULL. | CHAR | Used for entity ID resolution. The value corresponds to the tag 1234 value used for entity cross reference lookup. | n/a | n/a |
7001 – Resolve in Panel Flag | Optional | CHAR | Used by message stream to determine if entity ID and security alias should be resolved in the panel or the procedure. Valid Values: 1 – Resolve All, 2 – Resolve Entity Only, 3 – Resolve None (resolve using the procedure). | n/a | n/a |
1233/14 – Security ID | Conditionally Required – tag 7001 = 1 or 2 | CHAR (100) | Xreference lookup to resolve security alias. | n/a | n/a |
1234 – Security ID Type | Conditionally Required – tag 7001 = 1 or 2 | CHAR (30) | Xreference lookup to resolve security alias. | n/a | n/a |
1952 – XID 1 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1953 – XID Type 1 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1955 – XID 2 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1956 – XID Type 2 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1958 – XID 3 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1959 – XID Type 3 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1961 – XID 4 | Conditionally Required – tag 7001 = 3 | CHAR (100) | Used to resolve security_alias. | n/a | n/a |
1962 – XID Type 4 | Optional | CHAR (30) | Used to resolve security_alias. | n/a | n/a |
1964 – XID 5 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1965 – XID Type 5 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
1967 – XID 6 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1968 – XID Type 6 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
1970 – XID 7 | Conditionally Required – tag 7001 = 3 | CHAR | Used to resolve security_alias. | n/a | n/a |
1971 – XID Type 7 | Optional | CHAR | Used to resolve security_alias. | n/a | n/a |
7052 – CUSIP Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7053 – Xref – ID Type for 7052 | Optional | CHAR | Xref ID type associated with tag 7052; defaults to CUSIP. | n/a | n/a |
7055 – ISIN Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7056 – Xref – ID Type for 7055 | Optional | CHAR | Xref ID type associated with tag 7055; defaults to ISIN. | n/a | n/a |
7058 – SEDOL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7059 – Xref – ID Type for 7058 | Optional | CHAR | Xref ID type associated with tag 7058; defaults to SEDOL. | n/a | n/a |
7061 – REUTERS Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7062 – Xref – ID Type for 7061 | Optional | CHAR | Xref ID type associated with tag 7061; defaults to RIC. | n/a | n/a |
7064 – BLOOMBERG Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7065 – Xref – ID Type for 7064 | Optional | CHAR | Xref ID type associated with tag 7064; defaults to BBID. | n/a | n/a |
7067 – SICOVM Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7068 – Xref – ID Type for 7067 | Optional | CHAR | Xref ID type associated with tag 7067; defaults to SICOVM. | n/a | n/a |
7070 – VALOREN Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7071 – Xref – ID Type for 7070 | Optional | CHAR | Xref ID type associated with tag 7070; defaults to VALOREN. | n/a | n/a |
7073 – CEDEL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7074 – Xref – ID Type for 7073 | Optional | CHAR | Xref ID type associated with tag 7073; defaults to CEDEL. | n/a | n/a |
7076 – INTERNAL Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7077 – Xref – ID Type for 7076 | Optional | CHAR | Xref ID type associated with tag 7076; defaults to INTERNAL. | n/a | n/a |
7079 – CINS Xref – ID | Not used if tag 7001 = 3 | CHAR | Additional security identifier used to resolve security alias if tag 10 is null. Uses next tag to control xref ID type. Overrides the use of tags 1952 – 1980 for security resolution. | n/a | n/a |
7080 – Xref – ID Type for 7079 | Optional | CHAR | Xref ID type associated with tag 7079; defaults to CINS. | n/a | n/a |
1981 – Xreference Exchange | Optional | CHAR (8) | Used by the Xref ID lookup to further qualify the security resolution. | n/a | n/a |
11043 – Inactive Flag | Optional | VARCHAR2 (255) | Valid values are Y = Yes or N = No. Used by the Xref ID lookup to qualify security resolution. | n/a | n/a |
1981 – Xref Exchange | Optional | CHAR (8) | Used by the Xref ID lookup to further qualify the security resolution. | n/a | n/a |
10 – security_alias | Conditionally Required | NUMBER | Conditionally Required if tag 7001 = 2 or 3 and tags 1952 – 1971 are null. | CASHCASH_ACTIVITY | security_alias |
21– acct basis | Optional | VARCHAR2(5) | CASHCASH_ACTIVITY | account | |
85 – local_currency | Optional | CHAR (30) | 3-character currency code – Code Value. Used by the Xref ID lookup to further qualify the security resolution. | CASHCASH_ACTIVITY | local_currency |
86 – base_currency | Optional | CHAR (3) | CASHCASH_ACTIVITY | base_currency | |
1168 – src_intfc_inst | Conditionally Required | INTEGER | Conditionally Required – tag 1102 is null | CASHCASH_ACTIVITY | src_intfc_inst |
1163 – Entity ID | Conditionally Required | CHAR (8) | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | CASHCASH_ACTIVITY | entity_id |
1164 – Entity Name | Conditionally Required | CHAR (30) | Conditionally Required – either tag 1163 or tag 1164 must be sent, unless tag 1081 set to BANK or XREFERENCE. | N/A | n/a |
221 – Effective Date | Required | DATE | CASHCASH_ACTIVITY | effective_date | |
15 – Long/Short Indicator | Optional | CHAR | CASHCASH_ACTIVITY | long_short_indicator | |
2283 – Event type | Optional | CHAR | Event type of the cash_activity record | CASHCASH_ACTIVITY | trans_type |
16 – Bank Alias | Optional | VARCHAR2 (25) | Bank alias assigned to the custodian bank. | CASHCASH_ACTIVITY | bank_alias |
17 – Exchange Code | Optional | CHAR (8) | Exchange code. | ||
25 – Event ID | Optional | VARCHAR2(55) | Event ID of the transaction. | CASHCASH_ACTIVITY | star_tag25 |
26 – Target Event ID | Optional | VARCHAR2(55) | Event ID of the transaction to be canceled, closed, or adjusted. | CASHCASH_ACTIVITY | star_tag26 |
28 – Link Event ID | Optional | CHAR | Assigned Event ID that groups multiple lots together; for keeping track of activity related to originating transaction. | CASHCASH_ACTIVITY | linked_event_id |
30 – Post Date | Optional | DATE | System processing date of the transaction. | CASHCASH_ACTIVITY | post_date |
35 – Trade Date | Optional | DATE | Date on which the transaction is executed. | CASHCASH_ACTIVITY | trade_date |
36 – Accounting Date | Optional | DATE | Accounting date. | CASHCASH_ACTIVITY | accounting_date |
37 – Settlement Date | Optional | DATE | Contractual settlement date of the trade. | CASHCASH_ACTIVITY | settlement_date |
38 – Maturity Date | Optional | DATE | Date on which the security matures. Used by the Xref ID lookup to qualify security resolution. | N/A | N/A |
45 – Price | Optional | DEC | Price for the given transaction | CASHCASH_ACTIVITY | price |
46 – Tax Amount Local | Optional | MONEYL | Taxes applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | trade_taxes |
47 – Commission Amount Local | Optional | MONEYL | Commission applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_commission |
48 – Fee Amount Local | Optional | MONEYL | Fees applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | trade_fee |
50 – Net Amount Local | Optional | MONEYL | Net amount of the transaction. | CASHCASH_ACTIVITY | local_amount |
51 – Stamp Duty Tax Local | Optional | MONEYL | Stamp duty taxes applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_stamp_duty_tax |
53 – Cash Event Type | Optional | CHAR | Must be RECPT or DISB | CASHCASH_ACTIVITY | cash_event_type |
54 – Trade Status | Optional | VARCHAR2 (2) | Transaction is either SETTLED or TRADED | CASHCASH_ACTIVITY | transaction_status |
56 – Reason Code | Optional | VARCHAR2(255) | Reason code stored on the transaction | CASHCASH_ACTIVITY | comments1 |
62 – Cash Category | Optional | CHAR | CASHCASH_ACTIVITY | cash_category | |
63 – Settlement Currency | Optional | CHAR (3) | Currency in which the trade is to be settled | CASHCASH_ACTIVITY | settlement_currency |
79 – Settle to Base FX Rates | Optional | DEC | FX Rates on the transaction between the settlement amount and the base currency of the entity. | CASHCASH_ACTIVITY | curr_fx_rate |
87 – FX Rates Local to Base | Optional | DEC | FX Rates on the transaction between the asset currency and base currency of the entity. | CASHCASH_ACTIVITY | local_fx_rate |
88 – Broker Code | Optional | CHAR (20) | Broker code assigned to the transaction. | CASHCASH_ACTIVITY | broker_code |
126 – Event Sequence | Optional | NUMBER(38) | Position sequence number assigned to the transaction. | CASHCASH_ACTIVITY | cash_bal_inst |
151 – Event ID | Optional | CHAR | Event ID assigned to the transaction that generated an open lot in STAR. | CASHCASH_ACTIVITY | source_event_id |
159 – Quantity | Optional | DEC | Unit amount of the transaction. | CASHCASH_ACTIVITY | trans_quantity |
164 – Holding Period Date | Optional | DATE | Date on which the transaction was originally held. | CASHCASH_ACTIVITY | holding_period_date |
198 – Security Currency Gain | Optional | MONEYB | Currency gain on events such as MARGIN due to FX Rates changes on the approval date. | CASHCASH_ACTIVITY | security_currency_gain |
199 – Security Currency Loss | Optional | MONEYB | Currency loss on events such as MARGIN due to FX Rates changes on the approval date. | CASHCASH_ACTIVITY | security_currency_loss |
216 – Original Acquisition Date | Optional | DATE | Original acquisition date of the trade. | CASHCASH_ACTIVITY | orig_acq_date |
221 – Effective Date | Optional | DATE | Effective date of the transaction | CASHCASH_ACTIVITY | effective_date |
325 – Gross Amount Local | Optional | MONEYL | Gross amount local on any coupon or cash div | CASHCASH_ACTIVITY | gross_amount_local |
330 – Gross Amount Base | Optional | MONEYB | Gross amount base on any coupon or cash div | CASHCASH_ACTIVITY | gross_amount |
362 – From Event ID | Optional | CHAR | CASHCASH_ACTIVITY | trans_num | |
368 – Dividend Rate | Optional | DEC | Rate applied due to a Corporate Action entitlement | CASHCASH_ACTIVITY | dividend_rate |
457 – Trade ID | Required | CHAR | Trade ID of the transaction. If a match is found, the record is updated. If no match is found, the record is inserted | CASHCASH_ACTIVITY | master_trans_num |
9418 – orig_tran_num | Optional | VARCHAR2 (50) | CASHCASH_ACTIVITY | orig_trans_num | |
478 – Net Amount Base | Optional | MONEYB | Base equivalent amount of the settlement amount in which the transaction contractually settles. The base currency of the entity (Tag 86) is the currency of this amount. | CASHCASH_ACTIVITY | base_amount |
701 – Batch Event ID | Optional | VARCHAR2 (55) | Unique ID used to link multiple individual transactions together for reporting and cancellation | CASHCASH_ACTIVITY | batch_event_id |
761 – Trade Ticket Number | Optional | VARCHAR2 (55) | Source system transaction number stored on the transaction record. | CASHCASH_ACTIVITY | master_ticket_number |
851 – Reclaim Base | Optional | MONEYB | Reclaim base amount on any coupon or cash div. | CASHCASH_ACTIVITY | reclaim |
852 – Reclaim Local | Optional | MONEYL | Reclaim local on any coupon or cash div. | CASHCASH_ACTIVITY | reclaim_local |
853 – Withholding Local | Optional | MONEYL | Tax withholding local on any coupon or cash div. | CASHCASH_ACTIVITY | withholding_local |
854 – Withholding Base | Optional | MONEYB | Withholding base on any coupon or cash div. | CASHCASH_ACTIVITY | withholding |
860 – Lot Number | Optional | MONEYB | Lot number affected by the transaction | CASHCASH_ACTIVITY | lot_number |
1236 – Clearing Broker Code | Optional | CHAR | Clearing broker code assigned to the transaction. | CASHCASH_ACTIVITY | clearing_broker_code |
1240 – Custodian Bank Code | Optional | CHAR | Bank code assigned by the user to the custodian bank. | CASHCASH_ACTIVITY | bank_code |
1661 – Sub account | Optional | VARCHAR2 (30) | General ledger cash sub–account number | CASHCASH_ACTIVITY | sub_account |
1728 – Corporate Action Type | Optional | VARCHAR2 (50) | CASHCASH_ACTIVITY | comments4 | |
1827 – Rec Pay Event Type | Optional | CHAR | CASHCASH_ACTIVITY | gl_account | |
1981 –Exchange Code | Optional | CHAR (8) | Exchange code. Used by the Xref ID lookup to further qualify the security resolution. | ||
3746 – Original Acquisition Base | Optional | MONEYB | Original cost associated with the trade. | CASHCASH_ACTIVITY | orig_acq_cost_base |
3747 – Original Acquisition Local | Optional | MONEYL | Original cost associated with the trade. | CASHCASH_ACTIVITY | orig_acq_cost_local |
3752 – Other Fees | Optional | MONEYL | Any other fee applied to the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | sec_fees |
4268 – Corporate Action Instance | Optional | INTEGER | Instance assigned to the corporate action record. Stored on each record created for the Corporate Action. | CASHCASH_ACTIVITY | corporate_action_inst |
4597 – Performance Flow Value | Optional | MONEYL | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Initial value assigned to the security. | CASHCASH_ACTIVITY | performance_flow_value |
4598 – Performance_Price | Optional | DEC | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Initial price assigned to the security. | CASHCASH_ACTIVITY | performance_price |
4599 – Performance Code | Optional | CHAR | Eagle Performance requires this value for events that have no cash movements (ex. REC, DEL, SPINOFF). Code used by PACE to determine what price is used. | CASHCASH_ACTIVITY | performance_code |
4733 – Month End Accounting Date | Optional | DATE | Assigned monthly accounting date. | CASHCASH_ACTIVITY | month_end_acct_date |
1870 – Gain Loss | Optional | DEC | Gain/loss for the given transaction. | CASHCASH_ACTIVITY | gain_loss |
10170 – Performance Flow Description | Optional | VARCHAR2 (4) | Translation updated for both the Security and the Currency Cash Activity records. | CASHCASH_ACTIVITY | performance_flow_descr |
5363 – Local Total Flow | Optional | MONEYL | Total amount of the trade in asset currency | CASHCASH_ACTIVITY | local_total_flow |
10716 – Local Principal Flow | Optional | VARCHAR2 (4) | Amount of the trade (not including the purchased/sold interest) in terms of the asset currency. | CASHCASH_ACTIVITY | local_principal_flow |
10717 – Local Income Flow | Optional | VARCHAR2 (4) | Purchased/sold interest on the transaction in terms of the asset currency. | CASHCASH_ACTIVITY | local_income_flow |
10718 – Base Total Flow | Optional | VARCHAR2 (4) | Total amount of trade in terms of Base Currency | CASHCASH_ACTIVITY | base_total_flow |
169 – Base Principal Flow | Optional | MONEYB | Amount of the trade (not including the purchased/sold interest) in terms of the base currency. | CASHCASH_ACTIVITY | base_principal_flow |
1986 – Base Income Flow | Optional | MONEYB | Purchased/sold interest on the transaction in terms of the entity base currency. | CASHCASH_ACTIVITY | base_income_flow |
10721 – Settle to Local FX Rates | Optional | VARCHAR2 (4) | FX Rates used to convert the cash settlement amount back into the asset currency equivalent for Eagle Performance calculations. | CASHCASH_ACTIVITY | fx_rate_settle_to_asset |
11415 – Activity Source | Optional | VARCHAR2 (255) | Must be either CASH or COST | CASHCASH_ACTIVITY | activity_source |
10045 – Cancel Flag | Optional | CHAR | Used to flag a cancel record | CASHCASH_ACTIVITY | cancel_flag |
10046 – Cancel Status | Optional | CHAR | Used to flag that a record has been cancelled | CASHCASH_ACTIVITY | cancel_status |
5398 – Reflexive Flow Flag | Optional | VARCHAR2 (1) | Indicates whether or not a record is a reflexive flow | CASHCASH_ACTIVITY | reflexive_flow |
49 – Traded Interest | Optional | MONEYL | The amount of interest on the trade | CASHCASH_ACTIVITY | local_int_pur_sold |
475 – Traded Interest Base | Optional | MONEYB | CASHCASH_ACTIVITY | int_pur_sold | |
505 – Cancel Accounting Date | Optional | DATE | CASHCASH_ACTIVITY | cancel_acctg_date | |
8378 – Cancel Month End Accounting Date | Optional | DATE | CASHCASH_ACTIVITY | cancel_me_acctg_date | |
10674 – Replay Indicator | Optional | VARCHAR2 (4) | CASHCASH_ACTIVITY | replay_ind | |
11416 – Source Long Short Ind | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | source_long_short_ind | |
11417 – Source Security Alias | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | source_security_alias | |
9201 – Position ID | Optional | INTEGER | CASHCASH_ACTIVITY | position_id | |
9418 – Orig Trans Num | Optional | VARCHAR2 (50) | CASHCASH_ACTIVITY | orig_trans_num | |
11728 – Sys Currency | Optional | VARCHAR2 (30) | CASHCASH_ACTIVITY | sys_currency | |
11738 – Sys Total Flow | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | sys_total_flow | |
11729 – Sys Currency FX Rates | Optional | VARCHAR2 (30) | CASHCASH_ACTIVITY | sys_curr_fx_rate | |
11730 – Sys Currency FX Rates Date | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | sys_curr_fx_rate_date | |
11739 – Sys Principal Flow | Optional | VARCHAR2 (255) | CASHCASH_ACTIVITY | sys_principal_flow | |
11740 – Sys Income Flow | Optional | VARCHAR2 (30) | CASHCASH_ACTIVITY | sys_income_flow | |
11819 – Gain Swap L | Optional | DEC | CASHCASH_ACTIVITY | gain_swap_l | |
11820 – Gain Swap B | Optional | CHAR (2) | CASHCASH_ACTIVITY | gain_swap_b | |
11821– Loss Swap L | Optional | CHAR (2) | CASHCASH_ACTIVITY | loss_swap_l | |
11822 – Loss Swap B | Optional | CHAR (2) | CASHCASH_ACTIVITY | loss swap_b |