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 |
0 Comments