Data Table for Share Offers
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
Share Offer corporate action messages require Event Type (tag 55) set to ACORPACTION for message routing to the correct XML processing rule.
The following table describes the required and optional data fields for Share Offer corporate actions.
Tag # – Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
55 – Event Type | Required | CHAR | Used by message stream, must be set to ACORPACTION. |
1695 – Client Specific CA ID | Optional | VARCHAR2 (50) | Client Specific CA ID |
1102 – Source Name | Required | CHAR (15) | Source Name |
4003 – Original Source Name | Optional | VARCHAR2 (15) | Original Source Name |
1432 – From Asset ID Type | Optional | CHAR (30) | From Asset ID Type |
14 – From Asset ID | Required | CHAR (100) | From Asset ID |
961 – From Issue Name | Required | VARCHAR2 (255) | From Issue Name |
11043 – Inactive Flag | Optional | VARCHAR2 (255) | Inactive Flag |
1269 – From Issue Currency | Optional | CHAR (3) | From Issue Currency |
1264 – From Pre Action Price | Optional | NUMBER (28,12) | From Pre Action Price |
369 – From Post Action Price | Optional | NUMBER (28,12) | From Post Action Price |
1257 – Trans Type | Required | CHAR (30) | Trans Type |
1197 – Sweep Date | Required | DATE | Sweep Date |
1109 – Effective Date | Required | DATE | Effective Date |
65 – Ex Date | Required | DATE | Ex Date |
1694 – Record Date | Optional | DATE | Record Date |
1260 – Announcement Date | Optional | DATE | Announcement Date |
1275 – Pay Date | Optional | DATE | Pay Date |
3965 – Treatment of Fractional Shares | Optional | VARCHAR2 (3) | Treatment of Fractional Shares |
8028 – Rounding Point | Optional | NUMBER (28,12) | Rounding Point |
54 – Corporate Action Status | Required | VARCHAR2 (2) | Corporate Action Status |
3961 – Corporate Action Sub Priority | Optional | INTEGER | Corporate Action Sub Priority |
1734 – Mandatory/Voluntary Indicator | Required | CHAR (2) | Mandatory/Voluntary Indicator |
8081 – Proration Percent | Optional | NUMBER (22,12) | Proration Percent |
60 – Corp Action ID | Required | INTEGER | Corp Action ID |
1103 – To Asset ID Type | Optional | CHAR (50) | To Asset ID Type |
1348 – To Asset ID | Required | CHAR (100) | To Asset ID |
1141 – To Issue Name | Required | VARCHAR2 (255) | To Issue Name |
2286 – Inactive Flag | Optional | CHAR | Inactive Flag |
3962 – To Settlement Currency | Optional | CHAR (3) | To Settlement Currency |
1705 – Subscription Price | Optional | NUMBER (28,12) | Subscription Price |
319 – To Post Action Price | Optional | NUMBER (28,12) | To Post Action Price |
1710 – From Shares | Optional | NUMBER (28,12) | From Shares |
1723 – To Shares | Optional | NUMBER (28,12) | To Shares |
1001 – To Ratio (Shares) | Optional | NUMBER (28,12) | To Ratio (Shares) |
1728 – Corporate Action Type | Required | VARCHAR2 (50) | Corporate Action Type |
1740 – Corporate Action Notes | Optional | VARCHAR2 (255) | Corporate Action Notes |
10 – Security Alias | Required | NUMBER | Security Alias |
302 – To Security Alias | Required | NUMBER | To Security Alias |
2299 – Released Corp Action Status Check | Optional | CHAR | Released Corp Action Status Check |
1256 – Generate Batch Event ID | Required | CHAR (6) | Generate Batch Event ID |
115 – Trigger Corp Action ID Lookup | Optional | INTEGER | Trigger Corp Action ID Lookup |
77 – Retrieve Max Corp Action ID | Optional | INTEGER | Retrieve Max Corp Action ID |
614 – Release Status | Optional | CHAR (1) | Release Status |
1168 – Source Number | Optional | INTEGER | Source Number |
2303 – Effective Date From Scrub | Optional | DATE | Effective Date From Scrub |
615 – Release Status To Security | Optional | CHAR | Release Status To Security |
613 – Effective Date From Scrub To Security | Optional | DT | Effective Date From Scrub To Security |
1169 – Source Number To Security | Optional | INTEGER | Source Number To Security |
30 – Post Dt | Optional | DATE | Post Dt |
95 – Partition | Required | INTEGER | Partition |
98 – Source System | Required | CHAR | Source System |
Â