entity_fct_cdd
Pipelined Data Sets
>
Entity Services
>
entity_fct_cdd
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| Id | This attribute defines the unique account identifier. | REQUIRED | STRING | |
| EntityType | This attribute defines the type of the entity. | NULLABLE | STRING | |
| EntitySubtypeId | This attribute defines the subtype ID of the entity. | NULLABLE | STRING | |
| TaxIdTypeId | This attribute defines the tax ID type ID. | NULLABLE | STRING | |
| TaxIdNumber | This attribute defines the tax ID number. | NULLABLE | STRING | |
| FirstName | This attribute defines the first name of the entity. | NULLABLE | STRING | |
| MiddleName | This attribute defines the middle name of the entity. | NULLABLE | STRING | |
| LastName | This attribute defines the last name of the entity. | NULLABLE | STRING | |
| PreferredName | This attribute defines the preferred name of the entity. | NULLABLE | STRING | |
| Title | This attribute defines the title of the entity. | NULLABLE | STRING | |
| Suffix | This attribute defines the suffix of the entity. | NULLABLE | STRING | |
| VipEntity | This attribute defines if the entity is a VIP. | REQUIRED | BOOLEAN | |
| ForeignEntity | This attribute defines if the entity is foreign. | REQUIRED | BOOLEAN | |
| ForeignTaxIdNumber | This attribute defines the foreign tax ID number. | NULLABLE | STRING | |
| InsiderRoleId | This attribute defines the insider role ID. | NULLABLE | STRING | |
| StartDate | This attribute defines the start date. | NULLABLE | DATE | |
| EndDate | This attribute defines the end date. | NULLABLE | DATE | |
| EntityOfficerId | This attribute defines the entity officer ID. | NULLABLE | STRING | |
| EntityBranchAddressId | This attribute defines the entity branch address ID. | NULLABLE | STRING | |
| NetWorthValue | This attribute defines the net worth value. | NULLABLE | NUMERIC | |
| NetWorthCurrencyType | This attribute defines the net worth currency type. | NULLABLE | STRING | |
| PreferredContactVoiceId | This attribute defines the preferred contact voice ID. | NULLABLE | STRING | |
| PreferredContactTextId | This attribute defines the preferred contact text ID. | NULLABLE | STRING | |
| PreferredContactMailId | This attribute defines the preferred contact mail ID. | NULLABLE | STRING | |
| PreferredContactDigitalId | This attribute defines the preferred contact digital ID. | NULLABLE | STRING | |
| LastContactDate | This attribute defines the last contact date. | NULLABLE | DATE | |
| GenderId | This attribute defines the gender ID. | NULLABLE | STRING | |
| RaceId | This attribute defines the race ID. | NULLABLE | STRING | |
| PronounId | This attribute defines the pronoun ID. | NULLABLE | STRING | |
| EthnicityId | This attribute defines the ethnicity ID. | NULLABLE | STRING | |
| DisabilityId | This attribute defines the disability ID. | NULLABLE | STRING | |
| ActiveDutyVerificationDate | This attribute defines the active duty verification date. | NULLABLE | DATE | |
| ActiveDutyStartDate | This attribute defines the active duty start date. | NULLABLE | DATE | |
| ActiveDutySeparationDate | This attribute defines the active duty separation date. | NULLABLE | DATE | |
| PrivacyOptOutAll | This attribute defines if the entity has opted out of all privacy options. | REQUIRED | BOOLEAN | |
| PrivacyActLastNoticeDate | This attribute defines the last notice date for the privacy act. | NULLABLE | DATE | |
| AffiliateOptOutAll | This attribute defines if the entity has opted out of all affiliate options. | REQUIRED | BOOLEAN | |
| IncludeLegalEntity | This attribute defines if the legal entity is included. | REQUIRED | BOOLEAN | |
| LegalEntityExclusionReasonId | This attribute defines the reason for legal entity exclusion. | NULLABLE | STRING | |
| LegalEntityId | This attribute defines the legal entity ID. | NULLABLE | STRING | |
| IncomeLevelId | This attribute defines the income level ID. | NULLABLE | STRING | |
| TaxIdCertificationStatus | This attribute defines the tax ID certification status. | NULLABLE | STRING | |
| TaxIdCertificationDate | This attribute defines the tax ID certification date. | NULLABLE | DATE | |
| FederalWithholdingId | This attribute defines the federal withholding ID. | NULLABLE | STRING | |
| FederalWithholdingEffectiveDate | This attribute defines the federal withholding effective date. | NULLABLE | DATE | |
| StateWithholdingId | This attribute defines the state withholding ID. | NULLABLE | STRING | |
| BNoticesSent | This attribute defines the number of B notices sent. | NULLABLE | NUMERIC | |
| LastBNoticeDate | This attribute defines the date the last B notice was sent. | NULLABLE | DATE | |
| IrsReportable | This attribute defines if the entity is IRS reportable. | NULLABLE | STRING | |
| CitizenshipCountry | This attribute defines the citizenship country. | NULLABLE | STRING | |
| ReportingChapter | This attribute defines the reporting chapter. | NULLABLE | STRING | |
| ChapterExemptionId | This attribute defines the chapter exemption ID. | NULLABLE | STRING | |
| ChapterStatusId | This attribute defines the chapter status ID. | NULLABLE | STRING | |
| W8TypeId | This attribute defines the W8 type ID. | NULLABLE | STRING | |
| W8CertificationDate | This attribute defines the W8 certification date. | NULLABLE | DATE | |
| W8ExpirationDate | This attribute defines the W8 expiration date. | NULLABLE | DATE | |
| GiinId | This attribute defines the GIIN ID. | NULLABLE | STRING | |
| GiinProvidedDate | This attribute defines the GIIN provided date. | NULLABLE | DATE | |
| GiinCertificationDate | This attribute defines the GIIN certification date. | NULLABLE | DATE | |
| CreatedDate | This attribute defines the date the record was created. | REQUIRED | TIMESTAMP | |
| InstitutionUniversalId | This attribute defines a unique identifier to establish the identity of an Institution/Environment/Brand combination. | REQUIRED | STRING | |
| FullName | This attribute defines the full name of the entity. | NULLABLE | STRING | |
| FederalTaxRate | This attribute defines the federal tax rate. | NULLABLE | NUMERIC | |
| StateTaxRate | This attribute defines the state tax rate. | NULLABLE | NUMERIC | |
| MilitaryInformationStatus | This attribute defines the military information status. | NULLABLE | STRING |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026