This chapter describes about seeded attributes and transformations.
This chapter covers the following topics:
Seeded attributes are provided for the entities used in Data Quality Management: Party, Address, Contact, and Contact Point. These attributes are used for matching in the staged schema. Most of the attributes correspond to a column in a HZ table, such as HZ_PARTIES. A table exists in the staged schema for each entity, and each of the four tables has 30 custom attribute columns that you can use to add attributes that are not seeded.
Seeded attributes are defined as lookup codes, and the lookup meaning is what appears as the attribute name in the Define Attributes and Transformations page.
The staged schema also includes special logical attributes to facilitate matching for more frequently used and ambiguously defined attributes:
Address: Concatenates address information from the ADDRESS1, ADDRESS2, ADDRESS3, and ADDRESS 4 columns in the HZ_LOCATIONS table
All Account Names: Concatenates all account names for a party from the ACCOUNT_NAME column in the HZ_CUST_ACCOUNTS table
All Account Numbers: Concatenates all account numbers for a party from the ACCOUNT_NUMBER column in the HZ_CUST_ACCOUNTS table
Concatenated Party Names: Concatenates all party names including known-as names from the PARTY_NAME, KNOWN_AS, KNOWN_AS2, KNOWN_AS3, KNOWN_AS4, and KNOWN_AS5 columns in the HZ_PARTIES table
Phone Number Flexible Format: Concatenates phone numbers in the format of phone number, raw phone number, phone country code, and raw phone number from the PHONE_NUMBER, RAW_PHONE_NUMBER, PHONE_COUNTRY_CODE, and RAW_PHONE_NUMBER columns in the HZ_CONTACT_POINTS table
You cannot apply similarity algorithms to these attributes because the attributes consist of a concatenation of columns. The similarity algorithm would apply to the entire concatenation and likely produce unusable results. See: Assigning Scores, Transformations, and Thresholds, Oracle Trading Community Architecture Administration Guide.
Related Topics
Attributes for DQM, Oracle Trading Community Architecture Administration Guide
Creating Custom Attributes, Oracle Trading Community Architecture Administration Guide
The attributes for the party entity are stored in the HZ_STAGED_PARTIES table of the staged schema. The source tables for the attribute values include HZ_PARTIES, HZ_ORGANIZATION_PROFILES, and HZ_PERSON_PROFILES. This table shows the seeded attributes and their source table from the TCA Registry.
| Attribute Name | Attribute Code | Source Table |
|---|---|---|
| Account Number | ALL_ACCOUNT_NUMBERS | HZ_ORGANIZATION_PROFILES |
| All Account Names | ALL_ACCOUNT_NAMES | HZ_ORGANIZATION_PROFILES |
| All Party Names | PARTY_ALL_NAMES | CUSTOM |
| Average High Credit | AVE_HIGH_CREDIT | HZ_ORGANIZATION_PROFILES |
| Best Time to Begin Contact | BEST_TIME_CONTACT_BEGIN | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Best Time to End Contact | BEST_TIME_CONTACT_END | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Branch Flag | BRANCH_FLAG | HZ_ORGANIZATION_PROFILES |
| Business Scope | BUSINESS_SCOPE | HZ_ORGANIZATION_PROFILES |
| Category Code | CATEGORY_CODE | HZ_PARTIES |
| CEO Name | CEO_NAME | HZ_ORGANIZATION_PROFILES |
| CEO Title | CEO_TITLE | HZ_ORGANIZATION_PROFILES |
| Competitor Flag | COMPETITOR_FLAG | HZ_PARTIES |
| Concatenated Party Names | PARTY_ALL_NAMES | <Logical attribute> |
| Congressional District Code | CONG_DIST_CODE | HZ_ORGANIZATION_PROFILES |
| Content Source Number | CONTENT_SOURCE_NUMBER | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Content Source Type | CONTENT_SOURCE_TYPE | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Control Year | CONTROL_YR | HZ_ORGANIZATION_PROFILES |
| Corporation Class | CORPORATION_CLASS | HZ_ORGANIZATION_PROFILES |
| Credit Score | CREDIT_SCORE | HZ_ORGANIZATION_PROFILES |
| Credit Score Age | CREDIT_SCORE_AGE | HZ_ORGANIZATION_PROFILES |
| Credit Score Class | CREDIT_SCORE_CLASS | HZ_ORGANIZATION_PROFILES |
| Credit Score Commentary | CREDIT_SCORE_COMMENTARY | HZ_ORGANIZATION_PROFILES |
| Credit Score Commentary 2 through Credit Score Commentary 10 | CREDIT_SCORE_COMENTARY2 through CREDIT_SCORE_COMMENTARY10 | HZ_ORGANIZATION_PROFILES |
| Credit Score Date | CREDIT_SCORE_DATE | HZ_ORGANIZATION_PROFILES |
| Credit Score Incident Default | CREDIT_SCORE_INCD_DEFAULT | HZ_ORGANIZATION_PROFILES |
| Credit Score National Percentile | CREDIT_SCORE_NATL_PERCENTILE | HZ_ORGANIZATION_PROFILES |
| Customer Reference | REFERENCE_USE_FLAG | HZ_PARTIES |
| CUSTOM ATTRIBUTE 1 through CUSTOM ATTRIBUTE 30 | CUSTOM_ATTRIBUTES1 through CUSTOM_ATTRIBUTES30 | CUSTOM |
| Date of Birth | DATE_OF_BIRTH | HZ_PERSON_PROFILES |
| Date of Death | DATE_OF_DEATH | HZ_PERSON_PROFILES |
| Debarment Indicator | DEBARMENT_IND | HZ_ORGANIZATION_PROFILES |
| Debarments Count | DEBARMENTS_COUNT | HZ_ORGANIZATION_PROFILES |
| Debarments Date | DEBARMENTS_DATE | HZ_ORGANIZATION_PROFILES |
| Declared Ethnicity | DECLARED_ETHNICITY | HZ_PERSON_PROFILES |
| Disadvantaged Under Title 8A Indicator | DISADV_8A_IND | HZ_ORGANIZATION_PROFILES |
| Domain | DOMAIN_NAME | HZ_EMAIL_DOMAIN |
| Dun & Bradstreet Credit Rating | DB_RATING | HZ_ORGANIZATION_PROFILES |
| D-U-N-S Number | DUNS_NUMBER_C | HZ_ORGANIZATION_PROFILES |
| Effective End Date | EFFECTIVE_END_DATE | HZ_ORGANIZATION_PROFILES |
| Effective Start Date | EFFECTIVE_START_DATE | HZ_ORGANIZATION_PROFILES |
| E-Mail Domain | DOMAIN_NAME | CUSTOM |
| Enquiry D-U-N-S | ENQUIRY_DUNS | HZ_ORGANIZATION_PROFILES |
| Export Indicator | EXPORT_IND | HZ_ORGANIZATION_PROFILES |
| Failure Score | FAILURE_SCORE | HZ_ORGANIZATION_PROFILES |
| Failure Score Age | FAILURE_SCORE_AGE | HZ_ORGANIZATION_PROFILES |
| Failure Score Class | FAILURE_SCORE_CLASS | HZ_ORGANIZATION_PROFILES |
| Failure Score Commentary | FAILURE_SCORE_COMMENTARY | HZ_ORGANIZATION_PROFILES |
| Failure Score Commentary 2 through Failure Score Commentary 10 | FAILURE_SCORE_COMMENTARY2 through FAILURE_SCORE_COMMENTARY10 | HZ_ORGANIZATION_PROFILES |
| Failure Score Date | FAILURE_SCORE_DATE | HZ_ORGANIZATION_PROFILES |
| Failure Score Incident Default | FAILURE_SCORE_INCD_DEFAULT | HZ_ORGANIZATION_PROFILES |
| Failure Score Override Code | FAILURE_SCORE_OVERRIDE_CODE | HZ_ORGANIZATION_PROFILES |
| Fiscal Year for Financial Analysis | ANALYSIS_FY | HZ_ORGANIZATION_PROFILES |
| Gender | GENDER | HZ_PERSON_PROFILES |
| Global Failure Score | GLOBAL_FAILURE_SCORE | HZ_ORGANIZATION_PROFILES |
| Group Type | GROUP_TYPE | HZ_PARTIES |
| GSA Indicator Flag | GSA_INDICATOR_FLAG | HZ_ORGANIZATION_PROFILES |
| Head of Household Flag | HEAD_OF_HOUSEHOLD_FLAG | HZ_PERSON_PROFILES |
| Highest Credit | HIGH_CREDIT | HZ_ORGANIZATION_PROFILES |
| Household Income | HOUSEHOLD_INCOME | HZ_PERSON_PROFILES |
| Household Size | HOUSEHOLD_SIZE | HZ_PERSON_PROFILES |
| HQ Branch Indicator | HQ_BRANCH_IND | HZ_ORGANIZATION_PROFILES |
| Import Indicator | IMPORT_IND | HZ_ORGANIZATION_PROFILES |
| Internal Flag | INTERNAL_FLAG | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Known As 1 | KNOWN_AS | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Known As 2 through Known As 5 | KNOWN_AS2 through KNOWN_AS5 | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Labor Surplus Indicator | LABOR_SURPLUS_IND | HZ_ORGANIZATION_PROFILES |
| Language Name | LANGUAGE_NAME | HZ_PARTIES |
| Last Known GPS | LAST_KNOWN_GPS | HZ_PERSON_PROFILES |
| Last Month of Fiscal Year | FISCAL_YEAREND_MONTH | HZ_ORGANIZATION_PROFILES |
| Legal Structure | LEGAL_STATUS | HZ_ORGANIZATION_PROFILES |
| Line of Business | LINE_OF_BUSINESS | HZ_ORGANIZATION_PROFILES |
| Local Activity Classification Code | LOCAL_ACTIVITY_CODE | HZ_ORGANIZATION_PROFILES |
| Local Activity Classification Code Type | LOCAL_ACTIVITY_CODE_TYPE | HZ_ORGANIZATION_PROFILES |
| Local Business Identifier | LOCAL_BUS_IDEN_TYPE | HZ_ORGANIZATION_PROFILES |
| Local Business Identifier Type | LOCAL_BUS_IDENTIFIER | HZ_ORGANIZATION_PROFILES |
| Marital Status | MARITAL_STATUS | HZ_PERSON_PROFILES |
| Marital Status Effective Date | MARITAL_STATUS_EFFECTIVE_DATE | HZ_PERSON_PROFILES |
| Maximum Credit Currency Code | MAXIMUM_CREDIT_CURRENCY_CORE | HZ_ORGANIZATION_PROFILES |
| Maximum Credit Recommendation | MAXIMUM_CREDIT_RECOMMENDATION | HZ_ORGANIZATION_PROFILES |
| Min/Max/Ave Number of Employees at Primary Address Indicator | EMP_AT_PRIMARY_ADR_MIN_IND | HZ_ORGANIZATION_PROFILES |
| Minority Owned Indicator | MINORITY_OWNED_IND | HZ_ORGANIZATION_PROFILES |
| Minority Type | MINORITY_OWNED_TYPE | HZ_ORGANIZATION_PROFILES |
| Name | PARTY_ALL_NAMES | CUSTOM |
| Name | PARTY_NAME | HZ_PARTIES |
| Number of Employees | EMPLOYEES_TOTAL | HZ_ORGANIZATION_PROFILES |
| Number of Employees at Primary Address | EMP_AT_PRIMARY_ADR | HZ_ORGANIZATION_PROFILES |
| Number of Employees Estimation Indicator | EMP_AT_PRIMARY_ADR_EST_IND | HZ_ORGANIZATION_PROFILES |
| Organization Name | ORGANIZATION_NAME | HZ_ORGANIZATION_PROFILES |
| Organization Type | ORGANIZATION_TYPE | HZ_ORGANIZATION_PROFILES |
| Out of Business Indicator | OOB_IND | HZ_ORGANIZATION_PROFILES |
| Parent/Subsidiary Indicator | PARENT_SUB_IND | HZ_ORGANIZATION_PROFILES |
| Party Name | PARTY_NAME | HZ_PARTIES |
| Party Source Details | PARTY_SOURCE_SYSTEM_REF | CUSTOM |
| Party Type | PARTY_TYPE | HZ_PARTIES |
| Paydex Norm | PAYDEX_NORM | HZ_ORGANIZATION_PROFILES |
| Paydex Score | PAYDEX_SCORE | HZ_ORGANIZATION_PROFILES |
| Paydex Score Three Months Ago | PAYDEX_THREE_MONTHS_AGO | HZ_ORGANIZATION_PROFILES |
| Person Academic Title | PERSON_ACADEMIC_TITLE | HZ_PERSON_PROFILES |
| Person First Name | PERSON_FIRST_NAME | HZ_PERSON_PROFILES |
| Person Initials | PERSON_INITIALS | HZ_PERSON_PROFILES |
| Person Last Name | PERSON_LAST_NAME | HZ_PERSON_PROFILES |
| Person Middle Name | PERSON_MIDDLE_NAME | HZ_PERSON_PROFILES |
| Person Middle Name Phonetic | MIDDLE_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Person Name | PERSON_NAME | HZ_PERSON_PROFILES |
| Person Name Suffix | PERSON_NAME_SUFFIX | HZ_PERSON_PROFILES |
| Person Pre-Name Adjunct | PERSON_PRE_NAME_ADJUNCT | HZ_PERSON_PROFILES |
| Person Previous Last Name | PERSON_PREVIOUS_LAST_NAME | HZ_PERSON_PROFILES |
| Person Title | PERSON_TITLE | HZ_PERSON_PROFILES |
| Personal Identification | PERSON_IDENTIFIER | HZ_PERSON_PROFILES |
| Personal Income | PERSONAL_INCOME | HZ_PERSON_PROFILES |
| Phonetic Representation of Organization Name | ORGANIZATION_NAME_PHONETIC | HZ_ORGANIZATION_PROFILES |
| Phonetic Representation of Person First Name | PERSON_FIRST_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Phonetic Representation of Person Last Name | PERSON_LAST_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Phonetic Representation of Person Name | PERSON_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Place of Birth | PLACE_OF_BIRTH | HZ_PERSON_PROFILES |
| Potential Revenue of Current Fiscal Year | CURR_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES |
| Potential Revenue of the Next Fiscal Year | NEXT_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES |
| Preferred Functional Currency | PREF_FUNCTIONAL_CURRENCY | HZ_ORGANIZATION_PROFILES |
| Princical Title | PRINCIPAL_TITLE | HZ_ORGANIZATION_PROFILES |
| Principal Name | PRINCIPAL_NAME | HZ_ORGANIZATION_PROFILES |
| Private Ownership Flag | PUBLIC_PRIVATE_OWNERSHIP_FLAG | HZ_ORGANIZATION_PROFILES |
| Reference Use Flag | REFERENCE_USE_FLAG | HZ_PARTIES |
| Registration Type | REGISTRATION_TYPE | HZ_ORGANIZATION_PROFILES |
| Registry ID | PARTY_NUMBER | HZ_PARTIES |
| Rent or Own Indicator | RENT_OWN_IND | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Salutation | SALUTATION | HZ_PARTIES |
| SIC Code | SIC_CODE | HZ_ORGANIZATION_PROFILES |
| SIC Code Version | SIC_CODE_TYPE | HZ_ORGANIZATION_PROFILES |
| Small Business Indicator | SMALL_BUS_IND | HZ_ORGANIZATION_PROFILES |
| Status | STATUS | HZ_PARTIES |
| Tax Name | TAX_NAME | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Tax Registration Num | TAX_REFERENCE | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Taxpayer ID | JGZZ_FISCAL_CODE | HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES |
| Text Number of Employees at Primary Address | EMP_AT_PRIMARY_ADR_TEXT | HZ_ORGANIZATION_PROFILES |
| Third Party Flag | THIRD_PARTY_FLAG | HZ_PARTIES |
| Total Number of Employees Estimation Indicator | TOTAL_EMP_EST_IND | HZ_ORGANIZATION_PROFILES |
| Total Number of Employees in Text Format | TOTAL_EMPLOYEES_TEXT | HZ_ORGANIZATION_PROFILES |
| Total Number of Employees Indicator | TOTAL_EMPLOYEES_IND | HZ_ORGANIZATION_PROFILES |
| Total Number of Employees Min/Max/Ave Indicator | TOTAL_EMP_MIN_IND | HZ_ORGANIZATION_PROFILES |
| Total Payments | TOTAL_PAYMENTS | HZ_ORGANIZATION_PROFILES |
| Type of Personal Identification | PERSON_IDEN_TYPE | HZ_PERSON_PROFILES |
| Validated Flag | VALIDATED_FLAG | HZ_PARTIES |
| Woman Owned Index | WOMAN_OWNED_IND | HZ_ORGANIZATION_PROFILES |
| Year Established | YEAR_ESTABLISHED | HZ_ORGANIZATION_PROFILES |
| Year Incorporated | INCORP_YEAR | HZ_ORGANIZATION_PROFILES |
The attributes for the Address entity are stored in the HZ_STAGED_PARTY_SITES table of the staged schema. The source tables for the attribute values include HZ_LOCATIONS and HZ_PARTY_SITES. This table shows the seeded attributes and their source table from the TCA Registry.
| Attribute Name | Attribute Code | Source Table |
|---|---|---|
| Address | Address | CUSTOM |
| Address 1 through Address 4 | ADDRESS1 through ADDRESS4 | HZ_LOCATIONS |
| Address Effective Date | ADDRESS_EFFECTIVE_DATE | HZ_LOCATIONS |
| Address Expiration Date | ADDRESS_EXPIRATION_DATE | HZ_LOCATIONS |
| Address Phonetic Representation | ADDRESS_LINES_PHONETIC | HZ_LOCATIONS |
| Address Source Details | ADDR_SOURCE_SYSTEM_REF | CUSTOM |
| Address Source Status | STATUS | HZ_PARTY_SITES |
| City | CITY | HZ_LOCATIONS |
| CLLI Code | CLLI_CODE | HZ_LOCATIONS |
| Content Source Type | CONTENT_SOURCE_TYPE | HZ_LOCATIONS |
| Country Code | COUNTRY | HZ_LOCATIONS |
| County | COUNTY | HZ_LOCATIONS |
| CUSTOM ATTRIBUTE 1 through CUSTOM ATTRIBUTE 30 | CUSTOM_ATTRIBUTES1 through CUSTOM_ATTRIBUTES30 | <Custom attribute> |
| Floor | FLOOR | HZ_LOCATIONS |
| House Number | HOUSE_NUMBER | HZ_LOCATIONS |
| Identifying Address Flag | IDENTIFYING_ADDRESS_FLAG | HZ_PARTY_SITES |
| Language | LANGUAGE | HZ_LOCATIONS |
| Mailstop | MAILSTOP | HZ_PARTY_SITES |
| P.O. Box Number | PO_BOX_NUMBER | HZ_LOCATIONS |
| Position | POSITION | HZ_LOCATIONS |
| Postal Code | POSTAL_CODE | HZ_LOCATIONS |
| Postal Code Extension | POSTAL_PLUS4_CODE | HZ_LOCATIONS |
| Province | PROVINCE | HZ_LOCATIONS |
| Sales Tax Geocode | SALES_TAX_GEOCODE | HZ_LOCATIONS |
| Sales Tax Inside City Limits | SALES_TAX_INSIDE_CITY_LIMITS | HZ_LOCATIONS |
| Site Name | PARTY_SITE_NAME | HZ_PARTY_SITES |
| Site Number | PARTY_SITE_NUMBER | HZ_PARTY_SITES |
| State | STATE | HZ_LOCATIONS |
| Status | STATUS | HZ_PARTY_SITES |
| Street | STREET | HZ_LOCATIONS |
| Street Number | STREET_NUMBER | HZ_LOCATIONS |
| Street Suffix | STREET_SUFFIX | HZ_LOCATIONS |
| Suite | SUITE | HZ_LOCATIONS |
| Validated Flag | VALIDATED_FLAG | HZ_LOCATIONS |
The attributes for the Contact entity are stored in the HZ_STAGED_CONTACTS table of the staged schema. The source tables for the attribute values include HZ_ORG_CONTACTS, HZ_PERSON_PROFILES, and HZ_RELATIONSHIPS. This table shows the seeded attributes and their source table from the TCA registry.
| Attribute Name | Attribute Code | Source Table |
|---|---|---|
| Best Time to Begin Contact | BEST_TIME_CONTACT_BEGIN | HZ_PERSON_PROFILES |
| Best Time to End Contact | BEST_TIME_CONTACT_END | HZ_PERSON_PROFILES |
| Contact Name | CONTACT_NAME | CUSTOM |
| Contact Number | CONTACT_NUMBER | HZ_ORG_CONTACTS |
| Contact Source Details | CONTACT_SOURCE_SYSTEM_REF | CUSTOM |
| Content Source Type | CONTENT_SOURCE_TYPE | HZ_RELATIONSHIPS |
| CUSTOM ATTRIBUTE 1 through CUSTOM ATTRIBUTE 30 | CUSTOM_ATTRIBUTES1 through CUSTOM_ATTRIBUTES30 | <Custom attribute> |
| Date of Birth | DATE_OF_BIRTH | HZ_PERSON_PROFILES |
| Date of Death | DATE_OF_DEATH | HZ_PERSON_PROFILES |
| Decision Maker Flag | DECISION_MAKER_FLAG | HZ_ORG_CONTACTS |
| Directional Flag | DIRECTIONAL_FLAG | HZ_RELATIONSHIPS |
| Job Title | JOB_TITLE | HZ_ORG_CONTACTS |
| Known As | KNOWN_AS | HZ_PERSON_PROFILES |
| Person Academic Title | PERSON_ACADEMIC_TITLE | HZ_PERSON_PROFILES |
| Person First Name | PERSON_FIRST_NAME | HZ_PERSON_PROFILES |
| Person Initials | PERSON_INITIALS | HZ_PERSON_PROFILES |
| Person Last Name | PERSON_LAST_NAME | HZ_PERSON_PROFILES |
| Person Middle Name | PERSON_MIDDLE_NAME | HZ_PERSON_PROFILES |
| Person Name | PERSON_NAME | HZ_PERSON_PROFILES |
| Person Name Suffix | PERSON_NAME_SUFFIX | HZ_PERSON_PROFILES |
| Person Previous Last Name | PERSON_PREVIOUS_LAST_NAME | HZ_PERSON_PROFILES |
| Person Title | PERSON_TITLE | HZ_PERSON_PROFILES |
| Personal Identification | PERSON_IDENTIFIER | HZ_PERSON_PROFILES |
| Personal Identification Type | PERSON_IDEN_TYPE | HZ_PERSON_PROFILES |
| Phonetic Representation of Person First Name | PERSON_FIRST_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Phonetic Representation of Person Last Name | PERSON_LAST_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Phonetic Representation of Person Name | PERSON_NAME_PHONETIC | HZ_PERSON_PROFILES |
| Place of Birth | PLACE_OF_BIRTH | HZ_PERSON_PROFILES |
| Rank | RANK | HZ_ORG_CONTACTS |
| Reference Use Flag | REFERENCE_USE_FLAG | HZ_ORG_CONTACTS |
| Relationship Type | RELATIONSHIP_TYPE | HZ_RELATIONSHIPS |
| Tax Name | TAX_NAME | HZ_PERSON_PROFILES |
| Tax Registration Num | TAX_REFERENCE | HZ_PERSON_PROFILES |
| Taxpayer ID | JGZZ_FISCAL_CODE | HZ_PERSON_PROFILES |
| Title | TITLE | HZ_ORG_CONTACTS |
The attributes for the Contact Point entity are stored in the HZ_STAGED_CONTACT_POINTS table of the staged schema. The source tables for the attribute values is HZ_CONTACT_POINTS. This table shows the seeded attributes and their source table from the TCA Registry.
| Attribute Name | Attribute Code | Source Table |
|---|---|---|
| Contact Point Purpose | CONTACT_POINT_PURPOSE | HZ_CONTACT_POINTS |
| Contact Point Source Details | CPT_SOURCE_SYSTEM_REF | CUSTOM |
| Contact Point Type | CONTACT_POINT_TYPE | HZ_CONTACT_POINTS |
| CUSTOM ATTRIBUTE 1 through CUSTOM ATTRIBUTE 30 | CUSTOM_ATTRIBUTES1 through CUSTOM_ATTRIBUTES30 | <Custom attribute> |
| EDI ECE TP Location Code | EDI_ECE_TP_LOCATION_CODE | HZ_CONTACT_POINTS |
| EDI ID Number | EDI_ID_NUMBER | HZ_CONTACT_POINTS |
| EDI Payment Format | EDI_PAYMENT_FORMAT | HZ_CONTACT_POINTS |
| EDI Payment Method | EDI_PAYMENT_METHOD | HZ_CONTACT_POINTS |
| EDI Remittance Instruction | EDI_REMITTANCE_INSTRUCTION | HZ_CONTACT_POINTS |
| EDI Remittance Method | EDI_REMITTANCE_METHOD | HZ_CONTACT_POINTS |
| EDI TP Header ID | EDI_TP_HEADER_ID | HZ_CONTACT_POINTS |
| EDI Transaction Handling | EDI_TRANSACTION_HANDLING | HZ_CONTACT_POINTS |
| E-Mail Address | EMAIL_ADDRESS | HZ_CONTACT_POINTS |
| E-Mail Format | EMAIL_FORMAT | HZ_CONTACT_POINTS |
| Last Contact Day and Time | LAST_CONTACT_DT_TIME | HZ_CONTACT_POINTS |
| Phone Area Code | PHONE_AREA_CODE | HZ_CONTACT_POINTS |
| Phone Calling Calendar | PHONE_CALLING_CALENDAR | HZ_CONTACT_POINTS |
| Phone Country Code | PHONE_COUNTRY_CODE | HZ_CONTACT_POINTS |
| Phone Extension | PHONE_EXTENSION | HZ_CONTACT_POINTS |
| Phone Line Type | PHONE_LINE_TYPE | HZ_CONTACT_POINTS |
| Phone Number | PHONE_NUMBER | HZ_CONTACT_POINTS |
| Phone Number | FLEX_FORMAT_PHONE_NUMBER | CUSTOM |
| Primary Flag | PRIMARY_FLAG | HZ_CONTACT_POINTS |
| Phone Number | RAW_PHONE_NUMBER | HZ_CONTACT_POINTS |
| Status | STATUS | HZ_CONTACT_POINTS |
| Phone Type | TELEPHONE_TYPE | HZ_CONTACT_POINTS |
| Telex Number | TELEX_NUMBER | HZ_CONTACT_POINTS |
| Time Zone | TIME_ZONE | HZ_CONTACT_POINTS |
| URL | URL | HZ_CONTACT_POINTS |
| Web Site | URL | HZ_CONTACT_POINTS |
| Web Type | WEB_TYPE | HZ_CONTACT_POINTS |
Transformations are preconfigured for the entities of Party, Address, Contact, and Contact Point. You can also create your own transformations.
Transformations, seeded or not, can also contain word replacements. See: Word Replacements, Oracle Trading Community Architecture Administration Guide.
Note: The EXACT transformation, as well as other transformations that include EXACT, replaces non-English characters, for example á with a, ü and û with u, ô with o, and é with e.
This table shows the seeded transformations, the function and purpose of each, as well as examples of the transformation.
| Transformation Name | PL/SQL Function Name | Operations | Purpose | Example Input | Example Output |
|---|---|---|---|---|---|
| CLEANSE | HZ_TRANS_PKG.CLEANSE | Applies EXACT. Reduces any double letters to single letters. Removes all non-leading vowels. Replaces vowels that have a prepending % with a %. |
To catch incorrect vowel usage and typing errors. | D' Angello | D ANGL |
| CLEANSE (EMAIL) + WRDOMAIN | HZ_TRANS_PKG.CLEANSED_EMAIL | Applies EXACT. Applies the DOMAIN_NAME_DICTIONARY word replacement list. Applies CLEANSE. |
To catch incorrect vowel usage and typing errors. as well as mistakes with domain names. | joe.smith@ oracle.com | J SMTH ORCL |
| CLEANSE (URL) + WRDOMAIN | HZ_TRANS_PKG.CLEANSED_URL | Applies EXACT (URL). Applies the DOMAIN_NAME_DICTIONARY word replacement list. Applies CLEANSE. Removes leading and trailing spaces. |
To catch incorrect vowel usage and typing errors. as well as mistakes with domain names. | http://ww. oracle.com | ORCL |
| CLEANSE + WRADDRESS | HZ_TRANS_PKG.BASIC_CLEANSE_WRADDR | Applies EXACT. Applies the ADDRESS_DICTIONARY word replacement list. Applies CLEANSE. |
Clean and replace words for addresses. | 300 Oracle Pkwy. | 300 ORCL PRKWY |
| CLEANSE + WRNAMES | HZ_TRANS_PKG.BASIC_CLEANSE_WRNAMES | Applies EXACT. Applies the ORGANIZATION_NAME_DICTIONARY or PERSON_NAME_DICTIONARY word replacement list depending on party type. Applies CLEANSE. |
Clean and replace words for organization names. | Transform Corp. | TRNSFRM CRPRTN |
| CLEANSE + WRNAMES + REVERSE | HZ_TRANS_PKG.REVERSE_WRNAMES_CLEANSE (for person or organization names) | Applies REVERSE. Applies the ORGANIZATION_NAME_DICTIONARY and then PERSON_NAME_DICTIONARY. Applies CLEANSE. |
To catch incorrect ordering of words, as well as nicknames, abbreviations, and spelling variations for person or organization names and incorrect vowel usage and typing errors. | D' Angello Mike | MCHL D ANGL |
| CLEANSE + WRORGANIZATION | HZ_TRANS_PKG.WRORG_CLEANSE | Applies CLEANSE. Applies the ORGANIZATION_NAME_DICTIONARY word replacement list. |
To catch nicknames, abbreviations, and spelling variations for organization names as well as incorrect vowel usage and typing errors. | Transform Corp | TRNSFRM CRPRTN |
| CLEANSE + WRPERSON | HZ_TRANS_PKG.BASIC_CLEANSE_WRPERSON | Applies EXACT. Applies the PERSON_NAME_DICTIONARY word replacement list. Applies CLEANSE. |
Clean and replace words for person names. | Bob S. Smith | RBRT S SMTH |
| CLEANSE + WRPERSON + REVERSE | HZ_TRANS_PKG.REVERSE_WRPERSON_CLEANSE | Applies REVERSE. Applies the PERSON_NAME_DICTIONARY. Applies CLEANSE. |
Clean and reverses person names. | Smith Bob | Bob Smith |
| CLEANSE + WRSTATE | HZ_TRANS_PKG.WRSTATE_CLEANSE | Applies CLEANSE. Applies the US_STATE_DICTIONARY word replacement list. |
To catch spelling errors and incorrect abbreviations for state as well as incorrect vowel usage and typing errors. | CA | CLFRN |
| CLEANSE SPECIAL + WRADDRESS | HZ_TRANS_PKG.WRADDRESS_CLEANSE | Applies EXACT and EXACT SPECIAL, if different. Applies the ADDRESS_DICTIONARY word replacement list. Applies CLEANSE. |
To catch abbreviations for words used in the address as well as incorrect vowel usage and typing errors. | W. Main St. | WST MN STRT |
| CLEANSE SPECIAL + WRNAMES | HZ_TRANS_PKG.WRNAMES_CLEANSE | Applies EXACT and EXACT SPECIAL, if different. Applies the ORGANIZATION_NAME_DICTIONARY or PERSON_NAME_DICTIONARY word replacement list depending on party type. Applies CLEANSE. |
To transform and clean organization names. | Poot's Coffee | PTS CF PTS |
| CLEANSE SPECIAL + WRPERSON | HZ_TRANS_PKG.WRPERSON_CLEANSE | Applies EXACT and EXACT SPECIAL, if different. Applies the PERSON_NAME_DICTIONARY word replacement list. Applies CLEANSE. |
To transform and clean person names. | Bob Smith | RBRT SMTH RBRT |
| CLUSTER | HZ_TRANS_PKG.CLUSTER_WORD | Applies EXACT. Removes all except the first 3 characters of the first 2 words. |
To catch spelling errors at the end of the word and minor format errors. | D' Angello | D ANGE |
| CLUSTER + WRNAMES | HZ_TRANS_PKG.WRNAMES_CLUSTER | Applies EXACT. Applies the ORGANIZATION_NAME_DICTIONARY or PERSON_NAME_DICTIONARY word replacement list depending on party type. Applies CLUSTER. |
To catch nicknames, abbreviations, and spelling variations for person or organization names as well as spelling errors at the end of the word and minor format errors. | D' Angello Corp | D ANGE |
| CLUSTER + WRNAMES + REVERSE | HZ_TRANS_PKG.REVERSE_WRNAMES_CLUSTER (for person or organization names) | Applies REVERSE. Applies the ORGANIZATION_NAME_DICTIONARY and then PERSON_NAME_DICTIONARY. Applies CLUSTER. |
To catch incorrect ordering of words, as well as nicknames, abbreviations, and spelling variations for person names and spelling errors at the end of the word and minor format errors. | Inc Mitchell | MITC INCO |
| CLUSTER + WRORGANIZATION | HZ_TRANS_PKG.WRORG_CLUSTER | Applies EXACT. Applies the ORGANIZATION_NAME_DICTIONARY word replacement list. Applies CLUSTER. |
To catch nicknames, abbreviations, and spelling variations for organization names as well as spelling errors at the end of the word and minor format errors. | Mitchell Inc | MITC INCO |
| CLUSTER + WRPERSON | HZ_TRANS_PKG.WRPERSON_CLUSTER | Applies EXACT. Applies the PERSON_NAME_DICTIONARY word replacement list. Applies CLUSTER. |
To catch nicknames, abbreviations, and spelling variations for person names as well as spelling errors at the end of the word and minor format errors. | Mike D' Angello | MICH D |
| CLUSTER + WRPERSON + REVERSE | HZ_TRANS_PKG.REVERSE_WRPERSON_CLUSTER (for person names only) | Applies REVERSE. Applies the PERSON_NAME_DICTIONARY. Applies CLUSTER. |
To catch incorrect ordering of words, as well as nicknames, abbreviations, and spelling variations for person names and spelling errors at the end of the word and minor format errors. | Inc Mitchell | MITC INCO |
| CORE DOMAIN EXTRACTION | HZ_EMAIL_DOMAINS_V2PUB.CORE_DOMAIN | Extracts core domain of e-mail address. | To extract the core domain of e-mail addresses and ignore ISP e-mail domains. | Joe.smith@ oracle.co.uk | ORACLE.CO.UK (if CO.UK is an E-Mail Domain Suffixes lookup code and not included in the ISP E-Mail Domains lookup type) CO.UK (if the input does not match codes in either lookup type) |
| EXACT | HZ_TRANS_PKG.EXACT | Capitalize all letters. Replace all non-alphanumeric characters except for a % with a space. Reduce double spaces to a single space. |
To catch format errors. | D' Angello | D ANGELLO |
| EXACT (DATE) | HZ_TRANS_PKG.EXACT_DATE | Standardizes any date value to DD-MM-YYYY. | To enable character comparison for dates. | 01-JAN-2002 | 01-JAN-2002 |
| EXACT (URL) | HZ_TRANS_PKG.EXACT_URL | Capitalize all letters. Removes the xyz:// value. |
To catch case errors. | http:// WWw.oracle.com | WWW. ORACLE. COM |
| EXACT + WRADDRESS | HZ_TRANS_PKG.BASIC_WRADDR | Applies EXACT. Applies the ADDRESS_DICTIONARY word replacement list. |
To standardize address details. | 300 Oracle Pkwy. | 300 Oracle Parkway |
| EXACT + WRNAMES | HZ_TRANS_PKG.BASIC_WRNAMES | Applies EXACT. Applies the ORGANIZATION_NAME_DICTIONARY or PERSON_NAME_DICTIONARY word replacement list depending on party type. |
To standardize organization names. | Transform Corp. | Transform Corporation |
| EXACT + WRORGANIZATION | HZ_TRANS_PKG.WRORG_EXACT | Applies EXACT. Applies the ORGANIZATION_NAME_DICTIONARY word replacement list. |
To catch nicknames, abbreviations, and spelling variations for organization names. | Transform Corp | Transform CORPORATION |
| EXACT + WRPERSON | HZ_TRANS_PKG.BASIC_WRPERSON | Applies EXACT. Applies the PERSON_NAME_DICTIONARY word replacement list. |
To standardize common person nicknames. | Bob Smith | Robert Smith |
| EXACT + WRSTATE | HZ_TRANS_PKG.WRSTATE_EXACT | Applies EXACT. Applies the US_STATE_DICTIONARY word replacement list. |
To catch spelling errors and incorrect abbreviations for state. | CA | California |
| EXACT SPECIAL | HZ_TRANS_PKG.RM_SPLCHAR | Capitalize all letters. Replace all non-alphanumeric characters except for a % with a space. Reduce double spaces to a single space. Remove characters .!"#$&. |
To catch format errors. | D.D. Angello | DD ANGELLO |
| EXACT SPECIAL + WRADDRESS | HZ_TRANS_PKG.WRADDRESS_EXACT | Applies EXACT and EXACT SPECIAL, if different. Applies the ADDRESS_DICTIONARY word replacement list. |
To catch abbreviations for words used in the address. | W. Main St. | WEST Main STREET |
| EXACT SPECIAL + WRNAMES | HZ_TRANS_PKG.WRNAMES_EXACT | Applies EXACT and EXACT SPECIAL, if different. Applies the ORGANIZATION_NAME_DICTIONARY or PERSON_NAME_DICTIONARY word replacement list depending on party type. |
To catch nicknames, abbreviations, and spelling variations for person or organization names. | Transform Corp | Transform CORPORATION |
| EXACT SPECIAL + WRPERSON | HZ_TRANS_PKG.WRPERSON_EXACT | Applies EXACT and EXACT SPECIAL, if different. Applies the PERSON_NAME_DICTIONARY word replacement list. |
To catch nicknames, abbreviations, and spelling variations for person names. | Mike D' Angello | MICHAEL DANGELLO |
| EXACT SPECIAL CTX | HZ_TRANS_PKG.RM_SPLCHAR_CTX | For staging context, applies EXACT SPECIAL. For search context, forces uppercase, replaces all non-alphanumeric characters with a space, removes all spaces. |
To remove non-alphanumeric characters. | 25-321@4 | 25 321 4 |
| EXACT SPECIAL NOSPC | HZ_TRANS_PKG.RM_SPLCHAR_BLANKS | Capitalize all letters. Replace all non-alphanumeric characters except for a % with a space. Reduce double spaces to a single space. Remove characters .!"#$&, and removes all spaces. |
To remove blanks before or after special characters. | joe. smith@oracle.com | joe.smith@oracle.com |
| EXACT STRING | HZ_TRANS_PKG.EXACT_PADDED | Does basic sanitization as per EXACT. Prepends and appends a # to the sanitized string to disable contains matching. |
To capture the exact string and catch format errors. | D' Angello | #D ANGELLO# |
| FORCE UPPERCASE ONLY | HZ_TRANS_PKG.EXACT_EMAIL | Capitalize all letters. | To catch case errors. | Joe.smith@ oracle.com | JOE.SMITH@ORACLE. COM |
| FULL DOMAIN EXTRACTION | HZ_EMAIL_DOMAINS_V2PUB.FULL_DOMAIN | Extracts full domain of e-mail address. | To extract the full domain of e-mail addresses and ignore ISP e-mail domains. | Joe.smith@ oracle.co.uk | ORACLE.CO.UK (if the input does not match codes in the ISP E-Mail Domains lookup type) |
| REVERSE | HZ_TRANS_PKG.REVERSE_NAME | Applies EXACT SPECIAL. Reorders the first and last words of the string. |
To catch incorrect ordering of words. | Madison Mitchell | Mitchell Madison |
| REVERSE PHONE NUMBER | HZ_TRANS_PKG.REVERSE_PHONE_NUMBER | Applies EXACT. Reverses the string. Replaces any alphanumeric characters with their corresponding numbers as per a telephone keypad. |
To reverse the phone number. | 1 (650)555-2325 | 54325550561 |
| SOUNDEX | HZ_TRANS_PKG.SOUNDX | Applies EXACT. Applies the Soundex Algorithm. |
To catch spelling errors. | Smith | S260 |
Related Topics
Transformations Overview, Oracle Trading Community Architecture Administration Guide
Creating Custom Transformations, Oracle Trading Community Architecture Administration Guide