...
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 |
...