List of Additional Attributes for Subset Rule
You can find a detailed description of the standard account and contact attributes available for use in Subset Rule Selection Criteria in this topic.
Standard Attributes for Accounts
This table lists the standard attributes for account (organization) along with their lookup code, display name (meaning), and API name (tag) that you can add as subset rule selection criteria for identifying duplicates:
|
Lookup Code |
Meaning (Attribute Display Name) |
Tag (API Name) |
|---|---|---|
|
ANALYSIS_FY |
Analysis Year |
AnalysisFy |
|
BANK_CODE |
Bank Code |
BankCode |
|
BANK_OR_BRANCH_NUMBER |
Bank or Branch Number |
BankOrBranchNumber |
|
BRANCH_CODE |
Branch Code |
BranchCode |
|
BRANCH_FLAG |
Branch Indicator |
BranchFlag |
|
BUSINESS_SCOPE |
Business Scope |
BusinessScope |
|
CEO_NAME |
Chief Executive Name |
CeoName |
|
CEO_TITLE |
Chief Executive Title |
CeoTitle |
|
CERTIFICATION_LEVEL |
Certification Level |
CertificationLevel |
|
CERTREASON_CODE |
Certification Reason |
CertReasonCode |
|
CLEANLINESS_SCORE |
Cleanliness |
CleanlinessScore |
|
COMMENTS |
Comments |
Comments |
|
COMPLETENESS_SCORE |
Completeness |
CompletenessScore |
|
CONG_DIST_CODE |
Congressional District |
CongDistCode |
|
CONTROL_YR |
Organization Control Year |
ControlYr |
|
CORPORATION_CLASS |
Corporation Class |
CorporationClass |
|
CREATION_DATE |
Creation Date |
CreationDate |
|
CURRENT_FY_POTENTIAL_REV |
Current Fiscal Year's Potential Revenue |
CurrFyPotentialRevenue |
|
DATA_CLOUD_STATUS |
Enrichment Status |
DataCloudStatus |
|
DATA_CONFIDENCE_SCORE |
Data Confidence |
DataConfidenceScore |
|
DB_RATING |
D&B Credit Rating |
DbRating |
|
DIS_ADV_IND |
Disadvantaged Indicator |
DisadvantagedIndicator |
|
DOM_ULTIMATE_DUNSNUM_C |
Domestic D-U-N-S number |
DomesticUltimateDunsNumC |
|
DO_NOT_CONFUSE_WITH |
Do Not Confuse With |
DoNotConfuseWith |
|
DUNS_NUMBER_C |
D-U-N-S number |
DunsNumberC |
|
DUPLICATE_INDICATOR |
Duplicate Type |
DuplicateIndicator |
|
DUPLICATE_SCORE |
Duplication |
DuplicateScore |
|
EMPS_AT_PRIMARY_ADDRESS |
Number of Employees at Identifying Address |
EmpAtPrimaryAdr |
|
EMPS_AT_PRIMARY_ADDR_EST |
Number of Employees at Identifying Address Estimated Qualifier |
EmpAtPrimaryAdrEstInd |
|
EMPS_AT_PRIMARY_ADDR_MIN |
Number of Employees at Identifying Address Minimum Qualifier |
EmpAtPrimaryAdrMinInd |
|
EMPLOYEES_TOTAL |
Number of Employees |
EmployeesTotal |
|
ENQUIRY_DUNS |
ENQUIRY_DUNS |
EnquiryDuns |
|
ENRICHMENT_SCORE |
Enrichment |
EnrichmentScore |
|
EXPORT_IND |
Exporter Indicator |
ExportInd |
|
FISCAL_YEAREND_MONTH |
Fiscal Year End Month |
FiscalYearendMonth |
|
GLOBAL_ULTIMATE_DUNSNUM_C |
Global Ultimate D-U-N-S Number |
GlobalUltimateDunsNumC |
|
GROWTH_STRATEGY_DESC |
Growth Strategy Description |
GrowthStrategyDesc |
|
GSA_INDICATOR_FLAG |
GSA Indicator |
GsaIndicatorFlag |
|
HOME_COUNTRY |
Home Country |
HomeCountry |
|
HQ_BRANCH_INDICATOR |
HQ branch indicator |
HqBranchInd |
|
IMPORT_IND |
Importer Indicator |
ImportInd |
|
INCORP_YEAR |
Year Incorporated |
IncorpYear |
|
INTERNAL_FLAG |
Internal |
InternalFlag |
|
JGZZ_FISCAL_CODE |
Taxpayer identification number |
JgzzFiscalCode |
|
LABOR_SURPLUS_IND |
Labor Surplus Indicator |
LaborSurplusInd |
|
LAST_ASSIGNMENT_DATE |
Last Assigned Date |
LastAssignedDate |
|
LAST_ENRICHMENT_DATE |
Last Enrichment Date |
LastEnrichmentDate |
|
LAST_SCORE_UPDATE_DATE |
Last Score Date |
LastScoreUpdateDate |
|
LAST_SOURCE_UPDATE_DATE |
Last Source Update Date |
LastSourceUpdateDate |
|
LAST_UPDATE_DATE |
Last modified date |
LastUpdateDate |
|
LAST_UPDATED_BY |
Last modified by |
LastUpdatedBy |
|
LAST_UPDATE_SOURCE_SYSTEM |
Last Update Source System |
LastUpdateSourceSystem |
|
LEGAL_STATUS |
Legal Status |
LegalStatus |
|
LINE_OF_BUSINESS |
Line of Business |
LineOfBusiness |
|
LOCAL_ACTIVITY_CODE |
Local Activity Code |
LocalActivityCode |
|
LOCAL_ACTIVITY_CODE_TYPE |
Local Activity Code Type |
LocalActivityCodeType |
|
LOCAL_BUS_IDENTIFIER |
Common Business Identifier |
LocalBusIdentifier |
|
LOCAL_BUS_IDEN_TYPE |
Common Business Identifier Type |
LocalBusIdenType |
|
MINORITY_OWNED_IND |
Minority-Owned Indicator |
MinorityOwnedInd |
|
MINORITY_OWNED_TYPE |
Type of Minority-Owned Organization |
MinorityOwnedType |
|
MISSION_STATEMENT |
Mission Statement |
MissionStatement |
|
NAMED_FLAG |
Named Account |
NamedFlag |
|
NEXT_FY_POTENTIAL_REVENUE |
Next Fiscal Year's Potential Revenue |
NextFyPotentialRevenue |
|
OOB_IND |
Out of Business Indicator |
OobInd |
|
ORGANIZATION_NAME |
Name |
OrganizationName |
|
OWNER_PARTY_ID |
Owner ID |
OwnerPartyId |
|
PARENT_DUNS_NUMBER_C |
Parent D-U-N-S Number |
ParentDunsNumC |
|
PARENT_SUB_IND |
Subsidiary Indicator |
ParentSubInd |
|
PARTY_ID |
Party Id |
PartyId |
|
PARTY_NUMBER |
Registry ID |
PartyNumber |
|
PREF_CONTACT_METHOD |
Preferred Contact Method |
PreferredContactMethod |
|
PREF_CONTACT_PERSON_ID |
Preferred Contact Person Id |
PreferredContactPersonId |
|
PREF_FUNCTIONAL_CUR |
Preferred Functional Currency |
PrefFunctionalCurrency |
|
PRINCIPAL_NAME |
Principal Name |
PrincipalName |
|
PRINCIPAL_TITLE |
Principal Title |
PrincipalTitle |
|
PUBLIC_PRIVATE_OWNER_FLAG |
Private Ownership |
PublicPrivateOwnershipFlag |
|
RECENCY_SCORE |
Recency |
RecencyScore |
|
REGISTRATION_TYPE |
Registration Type |
RegistrationType |
|
RENT_OWN_IND |
Rent or Own Indicator |
RentOwnInd |
|
SALES_PROFILE_STATUS |
Sales Profile Status |
SalesProfileStatus |
|
SALES_PROFILE_TYPE |
Type |
SalesProfileType |
|
SMALL_BUS_IND |
Small Business Indicator |
SmallBusInd |
|
STOCK_SYMBOL |
Stock Symbol |
StockSymbol |
|
TOTAL_EMP_EST_IND |
Number of Employees Estimated Qualifier |
TotalEmpEstInd |
|
TOTAL_EMPLOYEES_IND |
Number of Employees Includes Subsidiaries |
TotalEmployeesInd |
|
TOTAL_EMP_MIN_IND |
Number of Employees Minimum Qualifier |
TotalEmpMinInd |
|
TOTAL_EMP_TEXT |
Total Number of Employees |
TotalEmployeesText |
|
TOTAL_PAYMENT_AMOUNT |
Total Payments |
TotalPayments |
|
UNIQUE_NAME_ALIAS |
Organization Name |
UniqueNameAlias |
|
UNIQUE_NAME_SUFFIX |
Name Suffix |
UniqueNameSuffix |
|
VALIDITY_SCORE |
Validity |
ValidityScore |
|
WOMAN_OWNED_IND |
Woman-Owned Indicator |
WomanOwnedInd |
|
YEAR_ESTABLISHED |
Year Established |
YearEstablished |
Standard Attributes for Contact
This table lists the standard attributes for contact (person) along with their lookup code, display name (meaning), and API name (tag) that you can add as subset rule selection criteria for identifying duplicates:
|
Lookup Code |
Meaning (Attribute Display Name) |
Tag (API Name) |
|---|---|---|
|
CERTIFICATION_LEVEL |
Certification Level |
CertificationLevel |
|
CERT_REASON_CODE |
Certification Reason |
CertReasonCode |
|
CLEANLINESS_SCORE |
Cleanliness |
CleanlinessScore |
|
COMMENTS |
Comments |
Comments |
|
COMPLETENESS_SCORE |
Completeness |
CompletenessScore |
|
CREATED_BY |
Created by |
CreatedBy |
|
CREATION_DATE |
Creation date |
CreationDate |
|
DATA_CLOUD_STATUS |
Enrichment Status |
DataCloudStatus |
|
DATA_CONFIDENCE_SCORE |
Data Confidence |
DataConfidenceScore |
|
DATE_OF_BIRTH_DATE |
Date of Birth |
DateOfBirth |
|
DATE_OF_DEATH_DATE |
Date of Death |
DateOfDeath |
|
DECEASED_FLAG |
Person Deceased |
DeceasedFlag |
|
DECLARED_ETHNICITY |
Declared Ethnicity |
DeclaredEthnicity |
|
DEPARTMENT |
Department |
Department |
|
DEPARTMENT_CODE |
Department Code |
DepartmentCode |
|
DO_NOT_CALL_FLAG |
Do not call |
DoNotCallFlag |
|
DO_NOT_CONTACT_FLAG |
Do not contact |
DoNotContactFlag |
|
DO_NOT_EMAIL_FLAG |
Do not e-mail |
DoNotEmailFlag |
|
DO_NOT_MAIL_FLAG |
Do not mail |
DoNotMailFlag |
|
DUPLICATE_INDICATOR |
Duplicate Type |
DuplicateIndicator |
|
DUPLICATE_SCORE |
Duplication |
DuplicateScore |
|
ENRICHMENT_SCORE |
Enrichment |
EnrichmentScore |
|
GENDER |
Gender |
Gender |
|
INTERNAL_FLAG |
Internal |
InternalFlag |
|
JGZZFISCAL_CODE |
Taxpayer identification number |
JgzzFiscalCode |
|
JOB_TITLE |
Job Title |
JobTitle |
|
JOB_TITLE_CODE |
Job Title Code |
JobTitleCode |
|
LAST_ASSIGNMENT_DATE |
Last Assigned Date |
LastAssignedDate |
|
LAST_CONTACT_DATE |
Last Contact Date |
LastContactDate |
|
LAST_ENRICHMENT_DATE |
Last Enrichment Date |
LastEnrichmentDate |
|
LAST_KNOWN_GPS |
Last Known Location |
LastKnownGPS |
|
LAST_SCORE_UPDATE_DATE |
Last Score Date |
LastScoreUpdateDate |
|
LAST_SOURCE_UPDATE_DATE |
Last Source Update Date |
LastSourceUpdateDate |
|
LAST_UPDATE_DATE |
Last modified date |
LastUpdateDate |
|
LAST_UPDATED_BY |
Last modified by |
LastUpdatedBy |
|
LAST_UPDATE_SOURCE_SYS |
LastUpdateSourceSystem |
LastUpdateSourceSystem |
|
MARITAL_STATUS |
Marital Status |
MaritalStatus |
|
MARITAL_STATUS_EFF_DATE |
Marital Status Effective Date |
MaritalStatusEffectiveDate |
|
NAMED_FLAG |
Named Contact |
NamedFlag |
|
OWNER_PARTY_ID |
Owner ID |
OwnerPartyId |
|
PARTY_ID |
PartyId |
PartyId |
|
PARTY_NUMBER |
Registry ID |
PartyNumber |
|
PERSON_ACADEMIC_TITLE |
Academic Title |
PersonAcademicTitle |
|
PERSONAL_INCOME |
Annual Income |
PersonalIncome |
|
PERSON_FIRST_NAME |
First name |
PersonFirstName |
|
PERSON_INITIALS |
Initials |
PersonInitials |
|
PERSON_LAST_NAME |
Last name |
PersonLastName |
|
PERSON_LAST_NAME_PREFIX |
Last Name Prefix |
PersonLastNamePrefix |
|
PERSON_MIDDLE_NAME |
Middle Name |
PersonMiddleName |
|
PERSON_NAME_SUFFIX |
Suffix |
PersonNameSuffix |
|
PERSON_PRENAME_ADJUNCT |
Prefix |
PersonPreNameAdjunct |
|
PERSON_PREV_LASTNAME |
Previous Last Name |
PersonPreviousLastName |
|
PERSON_SECOND_LASTNAME |
Second Last Name |
PersonSecondLastName |
|
PERSON_TITLE |
Title |
PersonTitle |
|
PLACE_OF_BIRTH |
Place of Birth |
PlaceOfBirth |
|
PREF_CONTACT_METHOD |
Preferred Contact Method |
PreferredContactMethod |
|
PREF_FUNCTIONAL_CUR |
Preferred Functional Currency |
PrefFunctionalCurrency |
|
RECENCY_SCORE |
Recency |
RecencyScore |
|
RENT_OWN_IND |
Rent or Own Indicator |
RentOwnInd |
|
SALES_AFFINITY_CODE |
Affinity |
SalesAffinityCode |
|
SALES_BUYING_ROLE_CODE |
Buying Role |
SalesBuyingRoleCode |
|
SALES_PROFILE_STATUS |
Sales Profile Status |
SalesProfileStatus |
|
SALES_PROFILE_TYPE |
Type |
SalesProfileType |
|
SALUTATION |
Salutation |
Salutation |
|
UNIQUE_NAME_SUFFIX |
Name Suffix |
UniqueNameSuffix |
|
VALIDITY_SCORE |
Validity |
ValidityScore |