| key |
id |
string(36)* |
= |
The identifier that uniquely identifies each financial to advisor record, expressed as a string. |
|
auditorName |
string(100) |
|
The name of the auditor or advisory firm associated with the financial filing. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data. |
|
calendarQuarter |
long(1,4) |
|
The calendar quarter of the financial period to which this advisor relationship applies. Allowed values: 1 (Q1), 2 (Q2), 3 (Q3), 4 (Q4). |
|
calendarYear |
long(1600,9999) |
|
The calendar year of the financial period to which this advisor relationship applies. |
|
companyId |
long(-2147483648,2147483647) |
|
The S&P Cap IQ Company ID for the company that filed the financial statement. |
|
companyIdAuditor |
long(-2147483648,2147483647) |
|
The S&P Cap IQ Company ID for the auditor company associated with the financial filing. |
|
companyName |
string(100)* |
|
The name of the company that filed the financial statement. |
|
financialToAdvisorId |
long(-2147483648,2147483647)* |
|
The native unique integer identifier for each financial to advisor record. |
|
isDeleted |
boolean* |
|
Indicates that this record has been logically deleted and should no longer be considered active. |
|
lastModifiedDate |
dateTime* |
|
The date and time when this record was last updated or modified in the source system. |
|
latestFlag |
boolean* |
|
Indicates that this record represents the most recent advisor relationship for the company and financial period. |