| Name | Description | Type | Additional information |
|---|---|---|---|
| RECORD_ID | integer |
None. |
|
| strRECORD_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. |
|
| strCONTROL_PERCENTAGE | string |
None. |
|
| TIN_COUNTRY_1_ID | integer |
None. |
|
| TIN_COUNTRY_1 | string |
None. |
|
| TIN_COUNTRY_1_NAME | string |
None. |
|
| TIN_1 | string |
None. |
|
| TIN_COUNTRY_2_ID | integer |
None. |
|
| TIN_COUNTRY_2 | string |
None. |
|
| TIN_COUNTRY_2_NAME | string |
None. |
|
| TIN_2 | string |
None. |
|
| TIN_COUNTRY_3_ID | integer |
None. |
|
| TIN_COUNTRY_3 | string |
None. |
|
| TIN_COUNTRY_3_NAME | string |
None. |
|
| TIN_3 | 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. |
|
| ADDRESS_NUMBER_STREET | string |
None. |
|
| ADDRESS_CITY | string |
None. |
|
| ADDRESS_STATE | string |
None. |
|
| ADDRESS_POST_CODE | string |
None. |
|
| ADDRESS_COUNTRY_ID | integer |
None. |
|
| MAILING_NUMBER_STREET | string |
None. |
|
| MAILING_CITY | string |
None. |
|
| MAILING_STATE | string |
None. |
|
| MAILING_POST_CODE | string |
None. |
|
| MAILING_COUNTRY_ID | integer |
None. |
|
| USCTAFinCENID | string |
None. |
|
| operationType | string |
None. |
|
| CreatedBy | integer |
None. |
|
| RELATIONSHIP_TYPE_ID | integer |
None. |
|
| INVESTOR_ID | integer |
None. |
|
| strINVESTOR_ID | string |
None. |
|
| INVESTOR_RECORD_ID | integer |
None. |
|
| strINVESTOR_RECORD_ID | string |
None. |
|
| INVESTOR_FULL_NAME | string |
None. |
|
| INVESTOR_TYPE | string |
None. |
|
| ENTITY_ID | integer |
None. |
|
| strENTITY_ID | string |
None. |
|
| ENTITY_RECORD_ID | integer |
None. |
|
| strENTITY_RECORD_ID | string |
None. |
|
| GROUP_ENTITY_FULL_NAME | string |
None. |
|
| GROUP_ENTITY_LEGAL_NAME | 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. |
|
| TYPE | string |
None. |
|
| LAST_UPDATE_ON | string |
None. |
|
| LAST_UPDATE_BY | string |
None. |
|
| Relationship_Start_Date | date |
None. |
|
| Relationship_End_Date | date |
None. |
|
| STR_Relationship_Start_Date | string |
None. |
|
| STR_Relationship_End_Date | string |
None. |
|
| FATCA_REPORTING_REQUIRED | string |
None. |
|
| CRS_REPORTING_REQUIRED | string |
None. |
|
| REPORTABLE_FOR_US_CTA | string |
None. |
|
| INVESTOR_LEGAL_NAME | string |
None. |
|
| EntityName | string |
None. |
|
| INVESTOR_CLIENT_REFERENCE_ID | string |
None. |
|
| FORM_SIGNATURE_DATE | date |
None. |
|
| FORM_EXPIRATION_DATE | date |
None. |
|
| GE_VAT_NUMBER | string |
None. |
|
| GE_USCTAFinCENID | string |
None. |
|
| PGE_GROUP_ENTITY_NAME | string |
None. |
|
| PGE_GROUP_ENTITY_LEGAL_NAME | string |
None. |
|
| PGE_ENTITY_ID | integer |
None. |
|
| PGE_RECORD_ID | integer |
None. |
|
| STR_PGE_ENTITY_ID | string |
None. |
|
| STR_PGE_RECORD_ID | string |
None. |