Back to Data Quality
Securities missing ISIN identifier
Issue #1•Missing ISIN•12 affected records
Description
Multiple securities in the database are missing their ISIN (International Securities Identification Number). This impacts regulatory reporting and cross-referencing with external systems.
Quality Rule:
DQ-ISIN-001: All equity securities must have valid ISINWorkflow Progress
Issue Detected1/15/2024
Assigned1/15/2024
3
Investigation4
Data Correction5
Verification6
ClosedAffected Records
Pending: 12To Fix: 0Ignore: 0
| Symbol | Name | Field | Current | Expected | Action | |
|---|---|---|---|---|---|---|
| NEWCO | New Company Inc. | isin | (empty) | US1234567890 | ||
| TECHX | TechX Corporation | isin | (empty) | US0987654321 | ||
| FINCO | Financial Corp | isin | (empty) | - | ||
| BIOTECH | BioTech Labs | isin | (empty) | - | ||
| ENERGY | Energy Partners | isin | (empty) | - | ||
| RETAIL | Retail Holdings | isin | (empty) | - | ||
| MEDIA | Media Group | isin | (empty) | - | ||
| TRANSPORT | Transport Inc. | isin | (empty) | - | ||
| HEALTH | Healthcare Systems | isin | (empty) | - | ||
| TELECOM | Telecom Networks | isin | (empty) | - | ||
| AGRI | Agriculture Co. | isin | (empty) | - | ||
| CONSTRUCT | Construction Ltd. | isin | (empty) | - |
Activity & Comments
John Smith1/15/2024, 9:00:00 AM
Started investigating. Most of these appear to be newly listed securities that haven't been mapped yet.
System1/15/2024, 9:15:00 AM
Automated ISIN lookup found potential matches for 8 out of 12 securities.
Details
- Status
- Investigating
- Severity
- high
- Priority
- P1
- Assignee
- John Smith
- Detected
- 1/15/2024, 8:00:00 AM
- Source
- Automated Quality Check