| key |
id |
string(100)* |
= |
Unique identifier for Branch Ownership |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
branchHomeOffice |
boolean* |
|
Indicates that the branch is the home office or the headquarters of the operating institution as originally reported |
| link |
branchId |
Branch |
|
Unique key to identify individual branch. |
|
branchOwnershipEnded |
date |
|
Date as of which this owner transferred the ownership rights of the branch to another owner |
|
branchOwnershipId |
long(-2147483648,2147483647)* |
|
Unique identifier for Branch Ownership |
|
branchOwnershipPriorId |
long(-2147483648,2147483647) |
|
Unique identifier for Prior Branch Ownership Record |
|
companyId |
long(-2147483648,2147483647)* |
|
Unique identifier assigned to a company |
|
companyIdParent |
string(13) |
|
Unique identifier for the highest-holder parent company |
|
dealAnnounceDate |
date |
|
Earliest date on which a letter of intent or definitive agreement was signed. If this date is unavailable, the date on which the deal was originally announced in a press release, regulatory filing, public notice, letter to shareholders or publication. |
|
dealId |
long(-2147483648,2147483647) |
|
Unique key for identifying deals |
|
institutionId |
long(-2147483648,2147483647)* |
|
S&P's unique key to identify institutions. |
|
mostRecentCurrentOwner |
boolean |
|
Indicates that this row represents 'current' ownership, that is, it is updated for any completed deals but does not reflect any deals announced but that have not closed |
|
mostRecentSequence |
long(-32768,32767) |
|
Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some entities, but not all entities, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from entity to entity, but there will always be at least one row marked with a 1. |
|
ownershipDerived |
boolean* |
|
Indicates that this row was derived from M&A data by an automated process, rather than entered manually as a result of a branch sale or other non-whole-deal transaction |
|
ownershipEventDate |
date |
|
Date of the event, such as a deal announcement or closing, charter change, or any other modification in the relevant information that necessitated an update to this row |
|
parentInstitutionId |
long(-2147483648,2147483647)* |
|
S&P's unique key for the highest-holder parent institutions |
| link |
regDomainAliasId |
RegDomainAlias |
|
Unique identifier for Reg Domain Alias |
|
regDomainClassBankLevelId |
long(0,255)* |
|
Regulatory Domain key for the domain of the Institution; this is the subsidiary/bank-level Reg Domain |
| link |
regDomainClassId |
RegDomainClass |
|
The primary division of companies for which regulatory information is available. |