| Name | Description | Type | Additional information |
|---|---|---|---|
| RECORD_ID | integer |
None. |
|
| strRECORD_ID | string |
None. |
|
| RECORD_END_DT | date |
None. |
|
| INVESTOR_RECORD_ID | integer |
None. |
|
| strINVESTOR_RECORD_ID | string |
None. |
|
| CP_RECORD_ID | integer |
None. |
|
| strCP_RECORD_ID | string |
None. |
|
| CP_ID | integer |
None. |
|
| strCP_ID | string |
None. |
|
| CLIENT_ID | integer |
None. |
|
| CP_REFERENCE_ID | string |
None. |
|
| FullName | string |
None. |
|
| RELATIONSHIP_TYPE_NAME | string |
None. |
|
| CONTROL_PERCENTAGE | string |
None. |
|
| TIN_COUNTRY_1 | string |
None. |
|
| TIN_1 | string |
None. |
|
| TIN_COUNTRY_2 | string |
None. |
|
| TIN_2 | string |
None. |
|
| str_Address | string |
None. |
|
| BIRTH_CITY | string |
None. |
|
| BIRTH_STATE | string |
None. |
|
| BIRTH_COUNTRY_NAME | string |
None. |
|
| str_BIRTHDATE | string |
None. |
|
| FIRST_NAME | string |
None. |
|
| LAST_NAME | string |
None. |
|
| BIRTH_COUNTRY_ID | integer |
None. |
|
| BIRTH_DATE | date |
None. |
|
| TIN_COUNTRY_1_ID | integer |
None. |
|
| TIN_COUNTRY_2_ID | integer |
None. |
|
| TIN_COUNTRY_3_ID | integer |
None. |
|
| ADDRESS_NUMBER_STREET | string |
None. |
|
| ADDRESS_CITY | string |
None. |
|
| ADDRESS_STATE | string |
None. |
|
| ADDRESS_POST_CODE | string |
None. |
|
| ADDRESS_COUNTRY_ID | integer |
None. |
|
| ADDRESS_COUNTRY_NAME | string |
None. |
|
| MAILING_NUMBER_STREET | string |
None. |
|
| MAILING_CITY | string |
None. |
|
| MAILING_STATE | string |
None. |
|
| MAILING_POST_CODE | string |
None. |
|
| MAILING_COUNTRY_ID | integer |
None. |
|
| TIN_3 | string |
None. |
|
| TIN_COUNTRY_3 | string |
None. |
|
| TIN_COUNTRY_1_NAME | string |
None. |
|
| TIN_COUNTRY_2_NAME | string |
None. |
|
| TIN_COUNTRY_3_NAME | string |
None. |
|
| operationType | string |
None. |
|
| CreatedBy | integer |
None. |
|
| RELATIONSHIP_TYPE_ID | integer |
None. |
|
| INVESTOR_ID | integer |
None. |
|
| strINVESTOR_ID | string |
None. |
|
| RECORD_CHANGED_BY | string |
None. |
|
| Controlling_RecordId | integer |
None. |
|
| strControlling_RecordId | string |
None. |
|
| ControllingPersonRecordId | integer |
None. |
|
| ControlledEntities_RecordId | integer |
None. |
|
| strControlledEntities_RecordId | string |
None. |
|
| strRECORD_START_DT | string |
None. |
|
| strRECORD_END_DT | string |
None. |
|
| ENTITY_ID | integer |
None. |
|
| strENTITY_ID | string |
None. |
|
| TYPE | string |
None. |
|
| LAST_UPDATE_ON | string |
None. |
|
| LAST_UPDATE_BY | string |
None. |
|
| StrBIRTH_DATE | string |
None. |
|
| ADDRESS_CountryName | string |
None. |
|
| Mailing_CountryName | string |
None. |
|
| USCTAFinCENID | string |
None. |