This appendix covers the following topics:
The seeded parent data sources are:
Person: Represents Business to Consumer (B2C) customer attributes such as first name, last name, marital status, household income, etc.
Organization Contacts: Represents Business to Business (B2B) attributes such as first name, last name, job title, work e-mail address, etc.
Organization: Represents organization attributes such as company name, business type, revenue, etc.
The following table describes parent-child relationships for each of the seeded data sources.
| Parent Data Source | Child Data Sources |
|---|---|
| Persons |
|
| Organization Contacts |
|
| Organization |
|
The following table lists seeded data source attributes, the tables or logic from which attribute values are derived, and the name of the data source(s) that use the attribute.
| Attribute | Source | Data Source Name(s) |
|---|---|---|
| ACCOUNT_ACTIVATION_DATE | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_ESTABLISHED_DATE | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_LIABLE_FLAG | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_NAME | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_NUMBER | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_TERMINATION_DATE | HZ_CUST_ACCOUNTS | Account |
| ACCT_LIFE_CYCLE_STATUS | HZ_CUST_ACCOUNTS | Account |
| AUTOPAY_FLAG | HZ_CUST_ACCOUNTS | Account |
| COMPETITOR_TYPE | HZ_CUST_ACCOUNTS | Account |
| COTERMINATE_DAY_MONTH | HZ_CUST_ACCOUNTS | Account |
| CREDIT_CLASSIFICATION_CODE | HZ_CUST_ACCOUNTS | Account |
| CURRENT_BALANCE | HZ_CUST_ACCOUNTS | Account |
| CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS | Account |
| CUSTOMER_CLASS_CODE | HZ_CUST_ACCOUNTS | Account |
| CUSTOMER_TYPE | HZ_CUST_ACCOUNTS | Account |
| DATE_TYPE_PREFERENCE | HZ_CUST_ACCOUNTS | Account |
| DATES_NEGATIVE_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| DATES_POSITIVE_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| DEPARTMENT | HZ_CUST_ACCOUNTS | Account |
| DEPOSIT_REFUND_METHOD | HZ_CUST_ACCOUNTS | Account |
| DORMANT_ACCOUNT_FLAG | HZ_CUST_ACCOUNTS | Account |
| FOB_POINT | HZ_CUST_ACCOUNTS | Account |
| FREIGHT_TERM | HZ_CUST_ACCOUNTS | Account |
| HELD_BILL_EXPIRATION_DATE | HZ_CUST_ACCOUNTS | Account |
| HIGH_PRIORITY_INDICATOR | HZ_CUST_ACCOUNTS | Account |
| HOLD_BILL_FLAG | HZ_CUST_ACCOUNTS | Account |
| HOTWATCH_SERVICE_FLAG | HZ_CUST_ACCOUNTS | Account |
| HOTWATCH_SVC_BAL_IND | HZ_CUST_ACCOUNTS | Account |
| ITEM_CROSS_REF_PREF | HZ_CUST_ACCOUNTS | Account |
| MAJOR_ACCOUNT_NUMBER | HZ_CUST_ACCOUNTS | Account |
| NOTIFY_FLAG | HZ_CUST_ACCOUNTS | Account |
| NPA_NUMBER | HZ_CUST_ACCOUNTS | Account |
| ORIG_SYSTEM_REFERENCE | HZ_CUST_ACCOUNTS | Account |
| OVER_RETURN_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| OVER_SHIPMENT_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| PAYMENT_TERM_ID | HZ_CUST_ACCOUNTS | Account |
| PERSON_NAME_SUFFIX | HZ_CUST_ACCOUNTS | Account |
| PO_EFFECTIVE_DATE | HZ_CUST_ACCOUNTS | Account |
| PO_EXPIRATION_DATE | HZ_CUST_ACCOUNTS | Account |
| POSTAL_CODE | HZ_CUST_ACCOUNTS | Account |
| PRICING_EVENT | HZ_CUST_ACCOUNTS | Account |
| PRIMARY_SALESREP_ID | HZ_CUST_ACCOUNTS | Account |
| PRIMARY_SPECIALIST_ID | HZ_CUST_ACCOUNTS | Account |
| REALTIME_RATE_FLAG | HZ_CUST_ACCOUNTS | Account |
| RESTRICTION_LIMIT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
| SALES_CHANNEL_CODE | HZ_CUST_ACCOUNTS | Account |
| SECONDARY_SPECIALIST_ID | HZ_CUST_ACCOUNTS | Account |
| SHIP_PARTIAL | HZ_CUST_ACCOUNTS | Account |
| SHIP_VIA | HZ_CUST_ACCOUNTS | Account |
| SINGLE_USER_FLAG | HZ_CUST_ACCOUNTS | Account |
| SOURCE_CODE | HZ_CUST_ACCOUNTS | Account |
| STATUS | HZ_CUST_ACCOUNTS | Account |
| STATUS_UPDATE_DATE | HZ_CUST_ACCOUNTS | Account |
| SUSPENSION_DATE | HZ_CUST_ACCOUNTS | Account |
| TAX_CODE | HZ_CUST_ACCOUNTS | Account |
| TAX_HEADER_LEVEL_FLAG | HZ_CUST_ACCOUNTS | Account |
| TAX_ROUNDING_RULE | HZ_CUST_ACCOUNTS | Account |
| UNDER_RETURN_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| UNDER_SHIPMENT_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
| WATCH_ACCOUNT_FLAG | HZ_CUST_ACCOUNTS | Account |
| WATCH_BALANCE_INDICATOR | HZ_CUST_ACCOUNTS | Account |
| WRITE_OFF_ADJUSTMENT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
| WRITE_OFF_AMOUNT | HZ_CUST_ACCOUNTS | Account |
| WRITE_OFF_PAYMENT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
| ACCOUNT_RECEIVABLE | HZ_FINANCIAL_NUMBERS. (FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘ACCOUNTS_RECEIVABLE') | Data Mining Aggregates |
| AVG_CALL_LENGTH | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_CLOSED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_COMPLAINTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_DISC_OFFERED | Derived using AMS_ACT_OFFERS and AMS_CAMPAIGN_SCHEDULES_VL fields | Data Mining Aggregates |
| AVG_HOLD_TIME | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_LEN_OF_EMP | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_ORDER_AMOUNT | BIC_PARTY_SUMM. ORDER_AMT divided by ORDER_NUM | Data Mining Aggregates |
| AVG_RESOLVE_DAYS_1_MONTH | BIC_PARTY_SUMM.AVG_SR_RESL_TIME | Data Mining Aggregates |
| AVG_RESOLVE_DAYS_3_MONTHS | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the last 3 months | Data Mining Aggregates |
| AVG_RESOLVE_DAYS_6_MONTHS | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the last 6 months | Data Mining Aggregates |
| AVG_RESOLVE_DAYS_YEAR | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the past year | Data Mining Aggregates |
| AVG_TALK_TIME | BIC_PARTY_SUMM. AVG_TALK_TIME | Data Mining Aggregates |
| AVG_TRANSFERS_PER_SR | BIC_PARTY_SUMM | Data Mining Aggregates |
| AVG_UNITS_PER_ORDER | BIC_PARTY_SUMM. ORDER_QTY divided by ORDER_NUM | Data Mining Aggregates |
| AVG_WORKLOAD | BIC_PARTY_SUMM | Data Mining Aggregates |
| CAPITAL_AMOUNT | "HZ_FINANCIAL_NUMBERS.[FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME IN (‘ISSUED_CAPITAL', ‘PAID_IN_CAPITAL' ‘NOMINAL_CAPITAL', ‘AUTHORIZED_CAPITAL')]" | Data Mining Aggregates |
| CAPITAL_TYPE_INDICATOR | HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER_NAME (where FINANCIAL_NUMBER_NAME in (‘ISSUED_CAPITAL' , ‘PAID_IN_CAPITAL', ‘NOMINAL_CAPITAL', ‘AUTHORIZED_CAPITAL')) | Data Mining Aggregates |
| CLOSED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
| COGS | BIC_PARTY_SUMM | Data Mining Aggregates |
| CONTRACT_AMT | BIC_PARTY_SUMM | Data Mining Aggregates |
| CONTRACT_DURATION | BIC_PARTY_SUMM | Data Mining Aggregates |
| CONTRACTS_CUML | BIC_PARTY_SUMM | Data Mining Aggregates |
| CURRENT_ASSETS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_CURRENT_ASSETS') | Data Mining Aggregates |
| CURRENT_LIABILITIES | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_CURR_LIABILITIES') | Data Mining Aggregates |
| DAYS_SINCE_FIRST_CONTACT | Derived using MIN (AMS_LIST_HEADERS_VL. SENT_OUT_DATE) where SENT_OUT_DATE is not Null and AMS_LIST_ENTRIES fields | Data Mining Aggregates |
| DAYS_SINCE_LAST_EVENT | MAX (AMS_EVENT_OFFERS_VL.EVENT_START_DATE) where PARTY_ID in (AMS_EVENT_REGISTRATIONS.ATTENDANT_PARTY_ID) | Data Mining Aggregates |
| DAYS_SINCE_LAST_TARGETED | Derived using MAX (AMS_LIST_HEADERS_VL. SENT_OUT_DATE) where party in AMS_LIST_ENTRIES. PARTY_ID | Data Mining Aggregates |
| DEBT_TO_INCOME_RATIO | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY Where FINANCIAL_NUMBER_NAME = ‘LONG_TERM_DEBT') | Data Mining Aggregates |
| ESCALATED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
| FIRST_CALL_CL_RATE | BIC_PARTY_SUMM | Data Mining Aggregates |
| GROSS_ANNUAL_INCOME | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘GROSS_INCOME') | Data Mining Aggregates |
| GROSS_ANNUAL_SALES | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘SALES') | Data Mining Aggregates |
| HZ_PARTY_SITE_USES.BEGIN_DATE and END_DATE for SITE_USE_TYPE = RESIDES_AT | HZ_PARTY_SITE_USES | Data Mining Aggregates |
| INACTIVE_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| LAST_TARGETED_CHANNEL_CODE | Derived using AMS_CAMPAIGN_SCHEDULES_VL AMS_LIST_HEADERS_VL and AMS_LIST_ENTRIES fields | Data Mining Aggregates |
| NET_PROFIT | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME=‘PROFIT_BEFORE_TAX') | Data Mining Aggregates |
| NET_WORTH | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘NET_WORTH') | Data Mining Aggregates |
| NEW_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| NUM_OF_COMPLAINTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| NUM_OF_INTERACTIONS | BIC_PARTY_SUMM | Data Mining Aggregates |
| NUM_OF_SR_1_MONTH | BIC_PARTY_SUMM. SRS_LOGGED | Data Mining Aggregates |
| NUM_OF_SR_3_MONTHS | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the last 3 months | Data Mining Aggregates |
| NUM_OF_SR_6_MONTHS | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the last 6 months | Data Mining Aggregates |
| NUM_OF_SR_YEAR | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the past year | Data Mining Aggregates |
| NUM_OF_TRANSFERS | BIC_PARTY_SUMM | Data Mining Aggregates |
| NUM_TGT_BY_OFFR_TYP1 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
| NUM_TGT_BY_OFFR_TYP2 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
| NUM_TGT_BY_OFFR_TYP3 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
| NUM_TGT_BY_OFFR_TYP4 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
| NUM_TIMES_TARGETED | AMS_LIST_HEADERS_VL.SENT_OUT_DATE is not Null AND party is in AMS_LIST_ENTRIES. PARTY_ID | Data Mining Aggregates |
| NUM_TIMES_TARGETED_DIRECT | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
| NUM_TIMES_TARGETED_EMAIL | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
| NUM_TIMES_TARGETED_TELEMKT | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
| NUM_TYPES_DISC_OFFERED | Derived using AMS_ACT_OFFERS And AMS_CAMPAIGN_SCHEDULES_VL fields | Data Mining Aggregates |
| ONTIME_PAYMENTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| ONTIME_SHIP_PCT | BIC_PARTY_SUMM | Data Mining Aggregates |
| OPEN_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| OPEN_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
| ORDER_LINES_DELIVERED | BIC_PARTY_SUMM | Data Mining Aggregates |
| ORDER_LINES_ONTIME | BIC_PARTY_SUMM | Data Mining Aggregates |
| ORDER_QTY_CUML | BIC_PARTY_SUMM | Data Mining Aggregates |
| ORDER_RECENCY | BIC_PARTY_SUMM | Data Mining Aggregates |
| PARTY_ID | -- | Data Mining Aggregates |
| PAYMENTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| PERCT_CALL_REWORK | BIC_PARTY_SUMM | Data Mining Aggregates |
| PRODUCTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| REFERALS | BIC_PARTY_SUMM | Data Mining Aggregates |
| RENEWED_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
| REOPENED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
| RETAINED_EARNINGS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘RETAINED_EARNINGS') | Data Mining Aggregates |
| RETURN_BY_VALUE | BIC_PARTY_SUMM | Data Mining Aggregates |
| RETURN_BY_VALUE_PCT | BIC_PARTY_SUMM | Data Mining Aggregates |
| RETURNS | BIC_PARTY_SUMM | Data Mining Aggregates |
| SALES | BIC_PARTY_SUMM | Data Mining Aggregates |
| TIMES_TARGETED_12_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last year | Data Mining Aggregates |
| TIMES_TARGETED_3_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 3 months | Data Mining Aggregates |
| TIMES_TARGETED_6_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 6 months | Data Mining Aggregates |
| TIMES_TARGETED_9_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 9 months | Data Mining Aggregates |
| TIMES_TARGETED_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last month | Data Mining Aggregates |
| TOT_CALLS | BIC_PARTY_SUMM | Data Mining Aggregates |
| TOT_NUM_ORDER_3_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 3 months | Data Mining Aggregates |
| TOT_NUM_ORDER_6_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 6 months | Data Mining Aggregates |
| TOT_NUM_ORDER_9_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 9 months | Data Mining Aggregates |
| TOT_NUM_ORDER_YEAR | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past year | Data Mining Aggregates |
| TOT_ORDER_AMOUNT_3_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 3 months | Data Mining Aggregates |
| TOT_ORDER_AMOUNT_6_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 6 months | Data Mining Aggregates |
| TOT_ORDER_AMOUNT_9_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 9 months | Data Mining Aggregates |
| TOT_ORDER_AMOUNT_YEAR | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past year | Data Mining Aggregates |
| TOTAL_ASSETS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_ASSETS') | Data Mining Aggregates |
| TOTAL_DEBT_OUTSTANDING | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘LONG_TERM_DEBT') | Data Mining Aggregates |
| TOTAL_SR_RESPONSE_TIME | BIC_PARTY_SUMM | Data Mining Aggregates |
| ARC_USED_FOR_OBJECT | AMS_DM_SOURCE | Data Mining Scores |
| CONTINUOUS_SCORE | AMS_DM_SOURCE | Data Mining Scores |
| CREATED_BY | ams_dm_scores_all_b | Data Mining Scores |
| CREATION_DATE | ams_dm_scores_all_b | Data Mining Scores |
| DECILE | AMS_DM_SOURCE | Data Mining Scores |
| LAST_UPDATE_DATE | ams_dm_scores_all_b | Data Mining Scores |
| LAST_UPDATE_LOGIN | ams_dm_scores_all_b | Data Mining Scores |
| LAST_UPDATED_BY | ams_dm_scores_all_b | Data Mining Scores |
| MODEL_ID | ams_dm_scores_all_b | Data Mining Scores |
| MODEL_NAME | ams_dm_models_all_tl | Data Mining Scores |
| MODEL_TYPE | ams_dm_scores_all_tl | Data Mining Scores |
| PARTY_ID | AMS_DM_SOURCE | Data Mining Scores |
| SCORE_ID | ams_dm_scores_all_b | Data Mining Scores |
| SCORE_NAME | ams_dm_scores_all_tl | Data Mining Scores |
| USED_FOR_OBJECT_ID | AMS_DM_SOURCE | Data Mining Scores |
| BEGIN_DATE | HZ_EMPLOYMENT_HISTORY | Employment History |
| BRANCH | HZ_EMPLOYMENT_HISTORY | Employment History |
| EMPLOYED_AS_TITLE | HZ_EMPLOYMENT_HISTORY | Employment History |
| EMPLOYED_BY_DIVISION_NAME | HZ_EMPLOYMENT_HISTORY | Employment History |
| EMPLOYED_BY_NAME_COMPANY | HZ_EMPLOYMENT_HISTORY | Employment History |
| EMPLOYMENT_HISTORY_ID | HZ_EMPLOYMENT_HISTORY | Employment History |
| END_DATE | HZ_EMPLOYMENT_HISTORY | Employment History |
| MILITARY_RANK | HZ_EMPLOYMENT_HISTORY | Employment History |
| PARTY_ID | HZ_EMPLOYMENT_HISTORY | Employment History |
| RESPONSIBILITY | HZ_EMPLOYMENT_HISTORY | Employment History |
| SERVED | HZ_EMPLOYMENT_HISTORY | Employment History |
| STATION | HZ_EMPLOYMENT_HISTORY | Employment History |
| SUPERVISOR_NAME | HZ_EMPLOYMENT_HISTORY | Employment History |
| ACTIVE_END_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| ACTIVE_START_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| ACTUAL_RETURN_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| CATEGORY_DESC | CSI_ITEM_INSTANCES | Install Base Details |
| CITY | CSI_ITEM_INSTANCES | Install Base Details |
| COMPLETENESS_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
| CONCAT_CAT_PARENTAGE | CSI_ITEM_INSTANCES | Install Base Details |
| CONCATENATED_SEGMENTS | CSI_ITEM_INSTANCES | Install Base Details |
| CONTEXT | CSI_ITEM_INSTANCES | Install Base Details |
| COUNTRY | CSI_ITEM_INSTANCES | Install Base Details |
| COUNTY | CSI_ITEM_INSTANCES | Install Base Details |
| CREATED_BY | CSI_ITEM_INSTANCES | Install Base Details |
| CREATION_COMPLETE_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
| CREATION_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
| INSTALL_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| INSTANCE_DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
| INSTANCE_ID | CSI_ITEM_INSTANCES | Install Base Details |
| INSTANCE_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
| INSTANCE_STATUS_ID | CSI_ITEM_INSTANCES | Install Base Details |
| INSTANCE_USAGE_MEANING | CSI_ITEM_INSTANCES | Install Base Details |
| INV_MASTER_ORGANIZATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
| INV_ORGANIZATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
| INVENTORY_ITEM_ID | CSI_ITEM_INSTANCES | Install Base Details |
| ITEM_DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
| ITEM_TYPE | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_CUST_PO_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_HEADER_ID | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_LINE_ID | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_LINE_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_OE_ORDER_LINE_ID | CSI_ITEM_INSTANCES | Install Base Details |
| LAST_ORDER_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
| LOCATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
| LOCATION_TYPE_CODE | CSI_ITEM_INSTANCES | Install Base Details |
| LOT_CONTROL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
| MANUALLY_CREATED_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
| NAME | CSI_ITEM_INSTANCES | Install Base Details |
| OWNER_PARTY_ACCOUNT_ID | CSI_ITEM_INSTANCES | Install Base Details |
| OWNER_PARTY_ID | CSI_ITEM_INSTANCES | Install Base Details |
| PADDED_CONCATENATED_SEGMENTS | CSI_ITEM_INSTANCES | Install Base Details |
| POSTAL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
| PROVINCE | CSI_ITEM_INSTANCES | Install Base Details |
| QUANTITY | CSI_ITEM_INSTANCES | Install Base Details |
| RETURN_BY_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| SERIAL_NUMBER_CONTROL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
| SHIPPED_DATE | CSI_ITEM_INSTANCES | Install Base Details |
| STATE | CSI_ITEM_INSTANCES | Install Base Details |
| TERMINATED_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
| UNIT_OF_MEASURE | CSI_ITEM_INSTANCES | Install Base Details |
| ACTION | JTF_IH_ACTIONS_TL | Interactions |
| ACTION_ID | JTF_IH_ACTIVITIES | Interactions |
| ACTION_ITEM | JTF_IH_ACTION_ITEMS_TL | Interactions |
| ACTION_ITEM_ID | JTF_IH_ACTIVITIES | Interactions |
| ACTIVE | JTF_IH_ACTIVITIES | Interactions |
| ACTIVITY | JTF_IH_ACTION_ITEMS_TL | Interactions |
| ACTIVITY_ID | JTF_IH_ACTIVITIES | Interactions |
| CREATION_DATE | JTF_IH_ACTIVITIES | Interactions |
| CUST_ACCOUNT_ID | JTF_IH_INTERACTIONS | Interactions |
| DIRECTION | JTF_IH_ACTIVITIES | Interactions |
| DOC_ID | JTF_IH_MEDIA_ITEMS | Interactions |
| DOC_REF | JTF_IH_ACTIVITIES | Interactions |
| END_DATE_TIME | JTF_IH_ACTIVITIES | Interactions |
| HANDLER_ID | JTF_IH_ACTIVITIES | Interactions |
| INTERACTION_ID | JTF_IH_INTERACTIONS | Interactions |
| MEDIA_ID | JTF_IH_ACTIVITIES | Interactions |
| MEDIA_ITEM_TYPE | JTF_IH_ACTIVITIES | Interactions |
| OBJECT_ID | JTF_IH_MEDIA_ITEMS | Interactions |
| OUTCOME_CODE | JTF_IH_ACTIVITIES | Interactions |
| OUTCOME_DESCRIPTION | JTF_IH_OUTCOMES_TL | Interactions |
| OUTCOME_ID | JTF_IH_ACTIVITIES | Interactions |
| PARTY_ID | JTF_IH_INTERACTIONS | Interactions |
| POSITIVE_RESPONSE_FLAG | JTF_IH_RESULTS_TL | Interactions |
| REASON_CODE | JTF_IH_REASONS_TL | Interactions |
| REASON_DESCRIPTION | JTF_IH_ACTIVITIES | Interactions |
| REASON_ID | JTF_IH_INTERACTIONS | Interactions |
| RESOURCE_ID | JTF_IH_RESULTS_TL | Interactions |
| RESULT_CODE | JTF_IH_ACTIVITIES | Interactions |
| RESULT_DESCRIPTION | JTF_IH_ACTIVITIES | Interactions |
| RESULT_ID | JTF_IH_OUTCOMES_TL | Interactions |
| SCRIPT_ID | JTF_IH_REASONS_TL | Interactions |
| SCRIPT_TRANS_ID | JTF_IH_RESULTS_TL | Interactions |
| SOURCE_CODE | JTF_IH_ACTIVITIES | Interactions |
| SOURCE_CODE_ID | JTF_IH_ACTIVITIES | Interactions |
| START_DATE_TIME | JTF_IH_ACTIVITIES | Interactions |
| PARTY_NAME | HZ_PARTIES | Interactions, Organization, and Person |
| ACCEPT_FLAG | AS_SALES_LEADS | Leads |
| ADDRESS_ID | AS_SALES_LEADS | Leads |
| ASSIGN_SALES_GROUP_ID | AS_SALES_LEADS | Leads |
| ASSIGN_TO_PERSON_ID | AS_SALES_LEADS | Leads |
| ASSIGN_TO_SALESFORCE_ID | AS_SALES_LEADS | Leads |
| BUDGET_AMOUNT | AS_SALES_LEADS | Leads |
| BUDGET_STATUS | AS_LOOKUPS | Leads |
| BUDGET_STATUS_CODE | AS_SALES_LEADS | Leads |
| CATEGORY_ID | AS_SALES_LEAD_LINES | Leads |
| CATEGORY_SET_ID | AS_SALES_LEAD_LINES | Leads |
| CHANNEL_CODE | AS_SALES_LEADS | Leads |
| CLOSE_REASON | AS_SALES_LEADS | Leads |
| CONTACT_ROLE_CODE | AS_SALES_LEADS | Leads |
| CREATION_DATE | AS_SALES_LEADS | Leads |
| CURRENCY_CODE | AS_SALES_LEADS | Leads |
| CUSTOMER_ID | AS_SALES_LEADS | Leads |
| DECISION_TIMEFRAME_CODE | AS_SALES_LEADS | Leads |
| DESCRIPTION | AS_SALES_LEADS | Leads |
| GROUP_NAME | AS_LOOKUPS | Leads |
| INVENTORY_ITEM_ID | AS_SALES_LEAD_LINES | Leads |
| LAST_UPDATE_DATE | AS_SALES_LEADS | Leads |
| LEAD_NUMBER | AS_SALES_LEADS | Leads |
| LEAD_RANK_CODE | AS_SALES_LEADS | Leads |
| LEAD_RANK_ID | AS_SALES_LEADS | Leads |
| LEAD_STATUS | AS_STATUSES_TL | Leads |
| ORGANIZATION_ID | AS_SALES_LEAD_LINES | Leads |
| ORIG_SYSTEM_REFERENCE | AS_SALES_LEADS | Leads |
| PRIMARY_CNT_PERSON_PARTY_ID | AS_SALES_LEADS | Leads |
| PRIMARY_CONTACT_PARTY_ID | AS_SALES_LEADS | Leads |
| PRIMARY_CONTACT_PHONE_ID | AS_SALES_LEADS | Leads |
| QUALIFIED_FLAG | AS_SALES_LEADS | Leads |
| QUANTITY | AS_SALES_LEAD_LINES | Leads |
| RANK | AS_SALES_LEAD_RANKS_TL | Leads |
| SALES_CHANNEL | ASO_I_SALES_CHANNELS_V | Leads |
| SALES_LEAD_ID | AS_SALES_LEADS | Leads |
| SOURCE_PROMOTION_CODE | AMS_P_SOURCE_CODES_V | Leads |
| SOURCE_PROMOTION_ID | AS_SALES_LEADS | Leads |
| SOURCE_PROMOTION_NAME | AMS_P_SOURCE_CODES_V | Leads |
| STATUS_CODE | AS_SALES_LEADS | Leads |
| TIME_FRAME | AS_SALES_LEADS | Leads |
| UNIT_OF_MEASURE_TL | MTL_UNITS_OF_MEASURE | Leads |
| UOM_CODE | AS_SALES_LEAD_LINES | Leads |
| URGENT_FLAG | AS_SALES_LEADS | Leads |
| VEH_RESP_CODE_MEANING | AS_LOOKUPS | Leads |
| VEHICLE_RESPONSE_CODE | AS_SALES_LEADS | Leads |
| CONCAT_CAT_PARENTAGE | ENI_PROD_DEN_HRCHY_PARENTS_V | Leads and Order Details |
| CONCATENATED_SEGMENTS | MTL_SYSTEM_ITEMS_VL | Leads and Order Details |
| ITEM_DESCRIPTION | MTL_SYSTEM_ITEMS_VL | Leads and Order Details |
| CATEGORY_DESC | ENI_PROD_DEN_HRCHY_PARENTS_V | Leads and Order Details |
| RESOURCE_NAME | JTF_RS_RESOURCE_EXTNS | Leads and Sales Access |
| ACTUAL_ARRIVAL_DATE | OE_ORDER_LINES_ALL | Order Details |
| ACTUAL_SHIPMENT_DATE | OE_ORDER_LINES_ALL | Order Details |
| ATO_LINE_ID | OE_ORDER_LINES_ALL | Order Details |
| BOOKED_DATE | OE_ORDER_HEADERS_ALL | Order Details |
| BOOKED_FLAG | OE_ORDER_LINES_ALL | Order Details |
| CANCELLED_FLAG | OE_ORDER_LINES_ALL | Order Details |
| CANCELLED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| CREATION_DATE | OE_ORDER_LINES_ALL | Order Details |
| EXTENDED_PRICE | NVL(OL.UNIT_SELLING_PRICE,0)*( NVL(OL.ORDERED_QUANTITY,0) - NVL(OL.CANCELLED_QUANTITY,0) ) | Order Details |
| FULFILLED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| HEADER_ID | OE_ORDER_LINES_ALL | Order Details |
| INVENTORY_ITEM_ID | MTL_SYSTEM_ITEMS_VL | Order Details |
| INVOICE_TO_ORG_ID | OE_ORDER_LINES_ALL | Order Details |
| ITEM_NUMBER | MTL_SYSTEM_ITEMS_VL | Order Details |
| LAST_UPDATE_DATE | OE_ORDER_LINES_ALL | Order Details |
| LINE_CATEGORY_CODE | OE_ORDER_LINES_ALL | Order Details |
| LINE_ID | OE_ORDER_LINES_ALL | Order Details |
| LINE_NUMBER | OE_ORDER_LINES_ALL | Order Details |
| LINE_TYPE_ID | OE_ORDER_LINES_ALL | Order Details |
| MARKETING_SOURCE_CODE_ID | OE_ORDER_HEADERS_ALL | Order Details |
| OPEN_FLAG | OE_ORDER_LINES_ALL | Order Details |
| OPTION_NUMBER | OE_ORDER_LINES_ALL | Order Details |
| ORDER_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
| ORDER_SOURCE_ID | OE_ORDER_LINES_ALL | Order Details |
| ORDERED_DATE | OE_ORDER_HEADERS_ALL | Order Details |
| ORDERED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
| PARTY_ID | HZ_CUST_ACCOUNTS | Order Details |
| PRICING_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| PRICING_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
| PROMISE_DATE | OE_ORDER_LINES_ALL | Order Details |
| REQUEST_DATE | OE_ORDER_LINES_ALL | Order Details |
| SALES_CHANNEL_CODE | OE_ORDER_HEADERS_ALL | Order Details |
| SCHEDULE_ARRIVAL_DATE | OE_ORDER_LINES_ALL | Order Details |
| SCHEDULE_SHIP_DATE | OE_ORDER_LINES_ALL | Order Details |
| SHIP_TO_CONTACT_ID | OE_ORDER_LINES_ALL | Order Details |
| SHIP_TO_ORG_ID | OE_ORDER_LINES_ALL | Order Details |
| SHIPMENT_PRIORITY_CODE | OE_ORDER_LINES_ALL | Order Details |
| SHIPPED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| SHIPPING_METHOD_CODE | OE_ORDER_LINES_ALL | Order Details |
| SHIPPING_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
| SHIPPING_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
| SOLD_FROM_ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
| SOLD_TO_ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
| TRANSACTIONAL_CURR_CODE | OE_ORDER_HEADERS_ALL | Order Details |
| UNIT_LIST_PRICE | OE_ORDER_LINES_ALL | Order Details |
| UNIT_SELLING_PRICE | OE_ORDER_LINES_ALL | Order Details |
| ANALYSIS_FY | HZ_ORGANIZATION_PROFILES | Organization |
| AVG_HIGH_CREDIT | HZ_ORGANIZATION_PROFILES | Organization |
| BRANCH_FLAG | HZ_ORGANIZATION_PROFILES | Organization |
| CEO_NAME | HZ_ORGANIZATION_PROFILES | Organization |
| CEO_TITLE | HZ_ORGANIZATION_PROFILES | Organization |
| CONG_DIST_CODE | HZ_ORGANIZATION_PROFILES | Organization |
| CONTROL_YR | HZ_ORGANIZATION_PROFILES | Organization |
| CORPORATION_CLASS | HZ_ORGANIZATION_PROFILES | Organization |
| CREDIT_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
| CURR_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES | Organization |
| CUSTOMER_KEY | HZ_PARTIES | Organization |
| DB_RATING | HZ_ORGANIZATION_PROFILES | Organization |
| DISADV_8A_IND | HZ_ORGANIZATION_PROFILES | Organization |
| EFFECTIVE_END_DATE | HZ_ORGANIZATION_PROFILES | Organization |
| EFFECTIVE_START_DATE | HZ_ORGANIZATION_PROFILES | Organization |
| EMP_AT_PRIMARY_ADR | HZ_ORGANIZATION_PROFILES | Organization |
| EMPLOYEES_TOTAL | HZ_ORGANIZATION_PROFILES | Organization |
| EXPORT_IND | HZ_ORGANIZATION_PROFILES | Organization |
| FAILURE_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
| FAILURE_SCORE_NATL_PERCENTILE | HZ_ORGANIZATION_PROFILES | Organization |
| FISCAL_YEAREND_MONTH | HZ_ORGANIZATION_PROFILES | Organization |
| GLOBAL_FAILURE_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
| GSA_INDICATOR_FLAG | HZ_PARTIES | Organization |
| HIGH_CREDIT | HZ_ORGANIZATION_PROFILES | Organization |
| HQ_BRANCH_IND | HZ_ORGANIZATION_PROFILES | Organization |
| IMPORT_IND | HZ_ORGANIZATION_PROFILES | Organization |
| INCORP_YEAR | HZ_ORGANIZATION_PROFILES | Organization |
| INTERNAL_FLAG | HZ_ORGANIZATION_PROFILES | Organization |
| LANGUAGE_NAME | HZ_PARTIES | Organization |
| LEGAL_STATUS | HZ_ORGANIZATION_PROFILES | Organization |
| LINE_OF_BUSINESS | HZ_ORGANIZATION_PROFILES | Organization |
| LOCAL_BUS_IDEN_TYPE | HZ_ORGANIZATION_PROFILES | Organization |
| LOCAL_BUS_IDENTIFIER | HZ_ORGANIZATION_PROFILES | Organization |
| PRIMARY_CONTACT_ID | HZ_ORGANIZATION_PROFILES | Organization |
| STATUS | HZ_PARTIES | Organization |
| TOTAL_EMPLOYEES_IND | HZ_ORGANIZATION_PROFILES | Organization |
| VALIDATED_FLAG | HZ_PARTIES | Organization |
| PARTY_TYPE | HZ_PARTIES | Organization and Organization Contact |
| GROUP_TYPE | HZ_PARTIES | Organization and Organization Contact |
| NEXT_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES | Organization and Organization Contact |
| ORIG_SYSTEM_REFERENCE | HZ_PARTIES | Organization and Organization Contact |
| PUBLIC_PRIVATE_OWNERSHIP_FLAG | HZ_ORGANIZATION_PROFILES | Organization and Organization Contact |
| TAX_NAME | HZ_PARTIES | Organization and Organization Contact |
| OOB_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| ORGANIZATION_NAME | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| ORGANIZATION_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| PARENT_SUB_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| PAYDEX_NORM | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| PAYDEX_SCORE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| PAYDEX_THREE_MONTHS_AGO | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| PREF_FUNCTIONAL_CURRENCY | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| REGISTRATION_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| SIC_CODE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| SIC_CODE_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| SMALL_BUS_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| TOTAL_EMP_EST_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| TOTAL_EMP_MIN_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| TOTAL_NUM_OF_ORDERS | HZ_PARTIES | Organization and Organization Profile |
| TOTAL_ORDERED_AMOUNT | HZ_PARTIES | Organization and Organization Profile |
| TOTAL_PAYMENTS | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| WOMAN_OWNED_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| YEAR_ESTABLISHED | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
| LAST_ORDERED_DATE | HZ_PARTIES | Organization and Person |
| PARTY_NUMBER | HZ_PARTIES | Organization and Person |
| SALUTATION | HZ_PARTIES | Organization and Person |
| CONTACT_ID | HZ_PARTIES | Organization Contact |
| CONTACT_NUMBER | HZ_ORG_CONTACTS | Organization Contact |
| CUSTOMER_KEY | HZ_PARTIES | Organization Contact |
| DECISION_MAKER_FLAG | HZ_ORG_CONTACTS | Organization Contact |
| DEPARTMENT | HZ_ORG_CONTACTS | Organization Contact |
| DEPARTMENT_CODE | HZ_ORG_CONTACTS | Organization Contact |
| GENDER | HZ_PARTIES | Organization Contact |
| HQ_BRANCH_IND | HZ_PARTIES | Organization Contact |
| JOB_TITLE | HZ_ORG_CONTACTS | Organization Contact |
| JOB_TITLE_CODE | HZ_ORG_CONTACTS | Organization Contact |
| MANAGED_BY | HZ_ORG_CONTACTS | Organization Contact |
| NATIVE_LANGUAGE | HZ_ORG_CONTACTS | Organization Contact |
| ORGANIZATION_ID | HZ_PARTIES | Organization Contact |
| ORGANIZATION_PARTY_NAME | HZ_PARTIES | Organization Contact |
| PARTY_CONTACT_NAME | HZ_ORG_CONTACTS | Organization Contact |
| PERSON_ACADEMIC_TITLE | HZ_PARTIES | Organization Contact |
| PERSON_PREVIOUS_LAST_NAME | HZ_PARTIES | Organization Contact |
| PHONE_COUNTRY_CODE | HZ_PARTIES | Organization Contact |
| PHONE_EXTENSION | HZ_PARTIES | Organization Contact |
| PHONE_NUMBER | HZ_PARTIES | Organization Contact |
| RANK | HZ_ORG_CONTACTS | Organization Contact |
| RELATIONSHIP_CODE | HZ_RELATIONSHIPS | Organization Contact |
| ROLE_TYPE | HZ_PARTIES | Organization Contact |
| SIC_CODE | HZ_PARTIES | Organization Contact |
| SIC_CODE_TYPE | HZ_PARTIES | Organization Contact |
| TITLE | HZ_PARTIES | Organization Contact |
| VALIDATED_FLAG | HZ_PARTIES | Organization Contact |
| EMAIL_ADDRESS | HZ_PARTIES | Organization Contact and Person |
| MAIL_STOP | HZ_ORG_CONTACTS | Organization Contact and Person |
| PARTY_SITE_ID | HZ_PARTIES | Organization Contact and Person |
| PERSON_FIRST_NAME | HZ_PARTIES | Organization Contact and Person |
| PERSON_LAST_NAME | HZ_PARTIES | Organization Contact and Person |
| PERSON_MIDDLE_NAME | HZ_PARTIES | Organization Contact and Person |
| PERSON_NAME_SUFFIX | HZ_PARTIES | Organization Contact and Person |
| PERSON_PRE_NAME_ADJUNCT | HZ_PARTIES | Organization Contact and Person |
| PHONE_AREA_CODE | HZ_PARTIES | Organization Contact and Person |
| PERSON_IDENTIFIER | HZ_PARTIES | Organization Contact and Person Profile |
| MINORITY_OWNED_IND | HZ_ORGANIZATION_PROFILES | Organization Profile |
| MINORITY_OWNED_TYPE | HZ_ORGANIZATION_PROFILES | Organization Profile |
| PARTY_ID | HZ_ORGANIZATION_PROFILES | Organization Profile |
| TAX_NAME | HZ_ORGANIZATION_PROFILES | Organization Profile |
| TAX_REFERENCE | HZ_ORGANIZATION_PROFILES | Organization Profile |
| TOTAL_EMPLOYEES_TEXT | HZ_ORGANIZATION_PROFILES | Organization Profile |
| ADDRESS4 | HZ_PARTIES | Organization and Organization Contact |
| DUNS_NUMBER | HZ_PARTIES | Organization and Organization Contact |
| POSTAL_CODE | HZ_PARTIES | Organization and Organization Contact |
| PROVINCE | HZ_PARTIES | Organization and Organization Contact |
| REFERENCE_USE_FLAG | HZ_PARTIES | Organization, Organization Contact, and Person |
| COUNTY | HZ_PARTIES | Organization, Organization Contact, and Person |
| KNOWN_AS | HZ_PARTIES | Organization, Organization Contact, and Person Profile |
| TAX_REFERENCE | HZ_PARTIES | Organization, Organization Contact, Person |
| ADDRESS1 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| ADDRESS2 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| ADDRESS3 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| CITY | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| COUNTRY | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| STATE | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| URL | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
| JGZZ_FISCAL_CODE | HZ_PARTIES | Organization, Organization Contact, Person, Person Profile |
| RENT_OWN_IND | HZ_ORGANIZATION_PROFILES | Organization, Organization Contact, Person, Person Profile |
| PARTY_ID | HZ_PARTIES | Organization, Person, and Organization Contact |
| BEST_TIME_CONTACT_BEGIN | HZ_ORGANIZATION_PROFILES | Organization, Person, and Person Profile |
| BEST_TIME_CONTACT_END | HZ_ORGANIZATION_PROFILES | Organization, Person, and Person Profile |
| CUSTOMER_KEY | HZ_PARTIES | Person |
| LANGUAGE | HZ_PARTY_SITES | Person |
| LAST_ORDERED_DATE | HZ_PARTIES | Person |
| PARTY_SITE_NAME | HZ_PARTY_SITES | Person |
| PHONE_COUNTRY_CODE | HZ_CONTACT_POINTS | Person |
| PHONE_EXTENSION | HZ_CONTACT_POINTS | Person |
| PHONE_NUMBER | HZ_CONTACT_POINTS | Person |
| AGE | trunc(months_between(sysdate date_of_birth) / 12,0) | Person and Person Profile |
| DATE_OF_BIRTH | HZ_PERSON_PROFILES | Person and Person Profile |
| DATE_OF_DEATH | HZ_PERSON_PROFILES | Person and Person Profile |
| DECLARED_ETHNICITY | HZ_PERSON_PROFILES | Person and Person Profile |
| GENDER | HZ_PERSON_PROFILES | Person and Person Profile |
| HEAD_OF_HOUSEHOLD_FLAG | HZ_PERSON_PROFILES | Person and Person Profile |
| HOUSEHOLD_INCOME | HZ_PERSON_PROFILES | Person and Person Profile |
| HOUSEHOLD_SIZE | HZ_PERSON_PROFILES | Person and Person Profile |
| INTERNAL_FLAG | HZ_PERSON_PROFILES | Person and Person Profile |
| MARITAL_STATUS | HZ_PERSON_PROFILES | Person and Person Profile |
| MARITAL_STATUS_EFFECTIVE_DATE | HZ_PERSON_PROFILES | Person and Person Profile |
| PERSON_NAME | HZ_PERSON_PROFILES | Person and Person Profile |
| PERSONAL_INCOME | HZ_PERSON_PROFILES | Person and Person Profile |
| PLACE_OF_BIRTH | HZ_PERSON_PROFILES | Person and Person Profile |
| COURSE_MAJOR | HZ_EDUCATION | Person Education |
| DEGREE_RECEIVED | HZ_EDUCATION | Person Education |
| EDUCATION_ID | HZ_EDUCATION | Person Education |
| LAST_DATE_ATTENDED | HZ_EDUCATION | Person Education |
| PARTY_ID | HZ_EDUCATION | Person Education |
| SCHOOL_ATTENDED_NAME | HZ_EDUCATION | Person Education |
| START_DATE_ATTENDED | HZ_EDUCATION | Person Education |
| TYPE_OF_SCHOOL | HZ_EDUCATION | Person Education |
| INTEREST_NAME | HZ_PERSON_INTEREST | Person Interest |
| INTEREST_TYPE_CODE | HZ_PERSON_INTEREST | Person Interest |
| LEVEL_OF_INTEREST | HZ_PERSON_INTEREST | Person Interest |
| LEVEL_OF_PARTICIPATION | HZ_PERSON_INTEREST | Person Interest |
| PARTY_ID | HZ_PERSON_INTEREST | Person Interest |
| PERSON_INTEREST_ID | HZ_PERSON_INTEREST | Person Interest |
| SINCE | HZ_PERSON_INTEREST | Person Interest |
| SUB_INTEREST_TYPE_CODE | HZ_PERSON_INTEREST | Person Interest |
| TEAM | HZ_PERSON_INTEREST | Person Interest |
| AMS_PERSON_PROFILE_ID | HZ_PERSON_PROFILES | Person Profile |
| CONTENT_SOURCE_TYPE | HZ_PERSON_PROFILES | Person Profile |
| DECLARED_ETHNICITY | HZ_PERSON_PROFILES | Person Profile |
| PARTY_ID | HZ_PERSON_PROFILES | Person Profile |
| PERSON_IDEN_TYPE | HZ_PERSON_PROFILES | Person Profile |
| PERSON_PERVIOUS_LAST_NAME | HZ_PERSON_PROFILES | Person Profile |
| TAX_REFERENCE | HZ_PERSON_PROFILES | Person Profile |
| ACCOUNTS1 | FEM_PARTY_PROFITABILITY | Profitability |
| ACCOUNTS2 | FEM_PARTY_PROFITABILITY | Profitability |
| ACCOUNTS3 | FEM_PARTY_PROFITABILITY | Profitability |
| ACCOUNTS4 | FEM_PARTY_PROFITABILITY | Profitability |
| ACCOUNTS5 | FEM_PARTY_PROFITABILITY | Profitability |
| BALANCE1 | FEM_PARTY_PROFITABILITY | Profitability |
| BALANCE2 | FEM_PARTY_PROFITABILITY | Profitability |
| BALANCE3 | FEM_PARTY_PROFITABILITY | Profitability |
| BALANCE4 | FEM_PARTY_PROFITABILITY | Profitability |
| BALANCE5 | FEM_PARTY_PROFITABILITY | Profitability |
| CACC_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
| CACC1 | FEM_PARTY_PROFITABILITY | Profitability |
| CACC2 | FEM_PARTY_PROFITABILITY | Profitability |
| CACC3 | FEM_PARTY_PROFITABILITY | Profitability |
| CACC4 | FEM_PARTY_PROFITABILITY | Profitability |
| CACC5 | FEM_PARTY_PROFITABILITY | Profitability |
| CONTRIB_AFTER_CPTL_CHG | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE1 | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE2 | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE3 | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE4 | FEM_PARTY_PROFITABILITY | Profitability |
| EXPENSE5 | FEM_PARTY_PROFITABILITY | Profitability |
| ISO_CURRENCY_CD | FEM_PARTY_PROFITABILITY | Profitability |
| LTD1 | FEM_PARTY_PROFITABILITY | Profitability |
| LTD2 | FEM_PARTY_PROFITABILITY | Profitability |
| LTD3 | FEM_PARTY_PROFITABILITY | Profitability |
| LTD4 | FEM_PARTY_PROFITABILITY | Profitability |
| LTD5 | FEM_PARTY_PROFITABILITY | Profitability |
| PARTNER_VALUE_INDEX | FEM_PARTY_PROFITABILITY | Profitability |
| PARTY_ID | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT_PCT | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT1 | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT2 | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT3 | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT4 | FEM_PARTY_PROFITABILITY | Profitability |
| PROFIT5 | FEM_PARTY_PROFITABILITY | Profitability |
| RATIO1 | FEM_PARTY_PROFITABILITY | Profitability |
| RATIO2 | FEM_PARTY_PROFITABILITY | Profitability |
| RATIO3 | FEM_PARTY_PROFITABILITY | Profitability |
| RATIO4 | FEM_PARTY_PROFITABILITY | Profitability |
| RATIO5 | FEM_PARTY_PROFITABILITY | Profitability |
| RELATIONSHIP_EXPENSE | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE1 | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE2 | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE3 | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE4 | FEM_PARTY_PROFITABILITY | Profitability |
| REVENUE5 | FEM_PARTY_PROFITABILITY | Profitability |
| TOTAL_EQUITY | FEM_PARTY_PROFITABILITY | Profitability |
| TOTAL_GROSS_CONTRIB | FEM_PARTY_PROFITABILITY | Profitability |
| TOTAL_ROE | FEM_PARTY_PROFITABILITY | Profitability |
| TRANSACTION1 | FEM_PARTY_PROFITABILITY | Profitability |
| TRANSACTION2 | FEM_PARTY_PROFITABILITY | Profitability |
| TRANSACTION3 | FEM_PARTY_PROFITABILITY | Profitability |
| TRANSACTION4 | FEM_PARTY_PROFITABILITY | Profitability |
| TRANSACTION5 | FEM_PARTY_PROFITABILITY | Profitability |
| VALUE1 | FEM_PARTY_PROFITABILITY | Profitability |
| VALUE2 | FEM_PARTY_PROFITABILITY | Profitability |
| VALUE3 | FEM_PARTY_PROFITABILITY | Profitability |
| VALUE4 | FEM_PARTY_PROFITABILITY | Profitability |
| VALUE5 | FEM_PARTY_PROFITABILITY | Profitability |
| YTD1 | FEM_PARTY_PROFITABILITY | Profitability |
| YTD2 | FEM_PARTY_PROFITABILITY | Profitability |
| YTD3 | FEM_PARTY_PROFITABILITY | Profitability |
| YTD4 | FEM_PARTY_PROFITABILITY | Profitability |
| YTD5 | FEM_PARTY_PROFITABILITY | Profitability |
| CUSTOMER_ID | AS_ACCESSES_ALL | Sales Access |
| GROUP_ID | JTF_RS_GROUPS_VL | Sales Access |
| GROUP_NAME | JTF_RS_GROUPS_VL | Sales Access |
| RESOURCE_ID | JTF_RS_RESOURCE_EXTNS | Sales Access |
| SALESFORCE_ID | AS_ACCESSES_ALL | Sales Access |
| ORIG_SYSTEM | HZ_ORIG_SYS_REFERENCES | System Reference |
| ORIG_SYSTEM_REFERENCE | HZ_ORIG_SYS_REFERENCES | System Reference |
| OWNER_TABLE_ID | HZ_ORIG_SYS_REFERENCES | System Reference |
| OWNER_TABLE_NAME | HZ_ORIG_SYS_REFERENCES | System Reference |
| STATUS | HZ_ORIG_SYS_REFERENCES | System Reference |