Data Table for Issuer Organization
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Former user (Deleted)
The following table describes the required and optional data fields for Issuer Organization.
Tag # – Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
1102 – Source | Required | CHAR (15) | Source |
1144 – Issuer ID | Required | CHAR (20) | Issuer ID |
1173 – Issuer Name | Required | VARCHAR2 (255) | Issuer Name |
1145 – Address | Optional | VARCHAR2 (255) | Address |
681 – Issuer City | Optional | VARCHAR2 (30) | Issuer City |
1153 – Composite Entity ID | Optional | VARCHAR2 (30) | Composite Entity ID |
3423 – User Reserved 3423 | Optional | VARCHAR2 (60) | |
1152 – Country Exposure | Optional | VARCHAR2 (30) | Country Exposure |
1174 – Country of Incorporation | Optional | VARCHAR2 (30) | Country of Incorporation |
1172 – Currency | Optional | VARCHAR2 (30) | Currency |
1155 – Industry Code | Optional | VARCHAR2 (30) | Industry Code |
1156 – Industry Sector | Optional | VARCHAR2 (30) | Industry Sector |
1157 – Review Date | Optional | CHAR | Review Date |
1158 – Portfolio Type | Optional | CHAR | Portfolio Type |
3418 – Classification Sector1 | Optional | VARCHAR2 (30) | Classification Sector1 |
3419 – Classification Sector1 | Optional | VARCHAR2 (30) | Classification Sector1 |
3420 – Issuer Relationship Sum to Percent | Optional | DEC | Issuer Relationship Sum to Percent |
3421 – Primary Analyst | Optional | VARCHAR2 (60) | Primary Analyst |
3422 – Credit Analyst | Optional | VARCHAR2 (60) | Credit Analyst |
944 – Update Source | Optional | VARCHAR2 (8) | Defaults to MCADMIN. |
5089 - Legal Entity Identifier(Lei) | Optional | VARCHAR2 (20) | Legal Entity Identifier(Lei) |
5090 - Legal Name | Optional | NVARCHAR2(255) | Legal Name |
5091 - Entity Status | Optional | NVARCHAR2(30) | Entity Status |
5092 - Legal Form | Optional | NVARCHAR2(30) | Legal Form |
5093 - Assigned Date | Optional | DATE | Assigned Date |
5094 - Last Update Date | Optional | DATE | Last Update Date |
5095 - Disabled Date | Optional | DATE | Disabled Date |
5096 - Record State | Optional | NVARCHAR2(30) | Record State |
5097 - Certification State | Optional | NVARCHAR2(30) | Certification State |
5098 - Street | Optional | NVARCHAR2(255) | Street |
5099 - City | Optional | NVARCHAR2(255) | City |
5100 - State | Optional | NVARCHAR2(255) | State |
5180 - Zip | Optional | NVARCHAR2(255) | Zip |
5181 - Country Code | Optional | NVARCHAR2(30) | Country Code |
Â