DW_CXS_ACTIVITY_CF

Activity Fact

Details

Module:

Key Columns

ACTIVITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_ID NUMBER 38 0 True Primary key
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Identifier
ACTIVITY_NUMBER VARCHAR2 128 A default, system generated number. Customers should be able to use their own number scheme.
ACTIVITY_FUNCTION_CODE VARCHAR2 32 A list of values that allows the user to select where activities appear, for example Appointment, Todo and Application-Task. This will be a required field.('APPOINTMENT','CALLREPORT','TASK') DW_CXS_ACTIVITY_FUNCTION_CODE_D_TL Code
ACTIVITY_DESCRIPTION VARCHAR2 999 This is a text field for capturing some descriptive information about the activity.
ACTIVITY_TYPE_CODE VARCHAR2 32 It describes the channel through which the communication has taken place, like('email', 'phone call',' chat ','Demo') DW_CXS_ACTIVITY_TYPE_D_TL Code
ACTIVITY_SUBTYPE_CODE VARCHAR2 64 It describes the channel through which the communication has taken place, like demo ('internal demo','extranl demo') DW_CXS_ACTIVITY_SUBTYPE_D_TL ACTIVITY_SUBTYPE_CODE
ACTIVITY_ACTUAL_END_TIMESTAMP TIMESTAMP The date and time when the activity is ended
ACTIVITY_ACTUAL_END_DATE DATE The date and time when the activity is ended
ACTIVITY_ACTUAL_START_TIMESTAMP TIMESTAMP The date and time when the activity is started
ACTIVITY_ACTUAL_START_DATE DATE The date and time when the activity is started
ACTIVITY_ALL_DAY_FLAG VARCHAR2 16 This flag is used to identify that the activity takes place for the whole day. DW_CXS_ALL_DAY_FLAG_D_TL Code
ACTIVITY_DUE_DATE DATE The due date in which the activity is due for completion.
ACTIVITY_DIRECTION_CODE VARCHAR2 32 Indicate the activity is( inbound or outbound ) DW_CXS_ACTIVITY_DIRECTION_D_TL Code
ACTIVITY_CREATED_BY VARCHAR2 128 Functional who column determines the created user
ACTIVITY_CREATED_TIMESTAMP TIMESTAMP Functional who column determines the user creation date
ACTIVITY_CREATED_DATE DATE Functional who column determines the user creation date
ACTIVITY_DURATION NUMBER Actual Duration of the Activity in the appropriate Unit of Measure (Minutes, Hours, Days, etc.) and stored in milliseconds.
ACTIVITY_OUTCOME_CODE VARCHAR2 32 Lookup code for the activity outcome('AT_RISK','CALL_ANSWERED','CALL_TRANSFERRED','CAPTURED_ISSUE','CUSTOMER_UNDECIDED','FAILED','INCOMPLETE','LEFT_MESSAGE','NOT_AVAILABLE','NO_ANSWER') DW_CXS_ACTIVITY_OUTCOME_D_TL Code
OWNER_RESOURCE_PARTY_ID NUMBER 38 0 The primary required owner of the activity
ACTIVITY_PRIORITY_CODE VARCHAR2 32 Priority code of the activity.This is based on lookup. ('High','Medium','Low') DW_CXS_ACTIVITY_PRIORITY_D_TL Code
ACTIVITY_STATUS_CODE VARCHAR2 32 Status of the activity.This is based on the lookup. ('Canceled','Complete','In progress','Not started','On hold') DW_CXS_ACTIVITY_STATUS_D_TL Code
ACTIVITY_SUBJECT VARCHAR2 512 Name of the activity. This is a summary field.
ACTIVITY_SUBMITTED_BY NUMBER 38 0 Call Report submiited by.
ACTIVITY_SUBMITTED_TIMESTAMP TIMESTAMP Call Report submission date.
ACTIVITY_SUBMITTED_DATE DATE Call Report submission date.
CUSTOMER_PARTY_TYPE_CODE VARCHAR2 32 Party Type of associated account('ORGANIZATION','GROUP','PERSON') DW_CXS_CUSTOMER_PARTY_TYPE_D_TL Code
PARENT_ACTIVITY_ID NUMBER 38 0 Parent Activity Identifier where the activity is related to.
ACTIVITY_ACCOUNT_ID NUMBER 38 0 Organization Account Identifier. DW_CXS_SALES_ACCOUNT_D PARTY_ID
PARTNER_PARTY_ID NUMBER 38 0 Partner Organization Identifier. DW_CXS_PARTNER_D PARTNER_ID
LEAD_ID NUMBER 38 0 Lead Identifier for the related object.
ACTIVITY_BUSINESS_UNIT_ID NUMBER 38 0 Identifier for the business unit. DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
OPPORTUNITY_ID NUMBER 38 0 Opportunity Identifier in which the activity is related to.
CREATION_DATE DATE audit columns for activity tables
LAST_UPDATE_DATE DATE audit columns for activity tables
CREATION_TIMESTAMP TIMESTAMP audit columns for activity tables
LAST_UPDATE_TIMESTAMP TIMESTAMP audit columns for activity tables
RECURRENCE_TYPE_FLAG VARCHAR2 32 This is a recurrence related attribute which stores the recurrence type Instance or Series row.Null for non-recurring appointments.
RECURRENCE_SERIES_ID NUMBER 38 0 This is for the recurring appoinment instance row.The recurrence series appointment id is stored in this attribute.
OPPORTUNITY_STATUS_CODE VARCHAR2 64 User configurable status of Opportunit Stores Values such as ('Open' 'Won' 'Lost' and 'No Sale') DW_CXS_STATUS_CODE_D_TL CODE
OPPORTUNITY_STATUS_CATEGORY VARCHAR2 32 Status Category of the Opportunity Status Eg: Open, Won, Lost DW_CXS_STATUS_CATEGORY_D_TL CODE
OPPORTUNITY_CURRENT_SALES_STAGE_ID NUMBER 38 0 Current Sales Stage and Stores Values such as 'Short List', 'Negotiation', 'Closed', 'Discovery',' Discovery',' Solution Presentation', 'Short List' DW_CXS_SALES_STAGE_D_TL SALES_STAGE_ID
OPPORTUNITY_REASON_WON_LOST_CODE VARCHAR2 64 Reason for won or lost. And Which Stores Values such as ('Customer not ready', 'Good lead', 'Install base', 'Lost to competition', 'Lost to internal development', 'Lost to no decision', 'No budget') DW_CXS_REASON_WON_LOST_CODE_D_TL CODE
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0 Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID
OPPORTUNITY_SALES_ACCOUNT_ID NUMBER 38 0 Sales Account Identifier maps to the sales account in use for the opportunity DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID NUMBER 38 0 Primary Contact for the opportunity associated with the sales account DW_CXS_CONTACT_D CONTACT_ID
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0 Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID NUMBER 38 0 Primary Partner asociated with the opportunity DW_CXS_PARTNER_D PARTNER_ID
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Sales resource marked as the owner for the opportunity DW_CXS_RESOURCE_D RESOURCE_ID
OPPORTUNITY_SALES_ACCOUNT_OWNER_PARTY_ID NUMBER 38 0 Sales Account owner Id DW_CXS_RESOURCE_D RESOURCE_ID
OPPORTUNITY_NAME VARCHAR2 512 Opportunity Name
OPPORTUNITY_CREATION_DATE DATE Truncated Opportunity creation date for functional use.Can be used for DATE dimension join
OPPORTUNITY_BUSINESS_UNIT_ID NUMBER 38 0 (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
OPPORTUNITY_EXPECTED_CLOSE_DATE DATE Estimated close date for this revenue - defaulted from opportunity's close date
OPPORTUNITY_WIN_PROBABILITY NUMBER Win probability percent
OPPORTUNITY_LOST_FLAG VARCHAR2 16 LOST_FLAG is set to Y when status is lost else N
OPPORTUNITY_CLOSED_FLAG VARCHAR2 16 CLOSED_FLAG is set to Y when status is close else N
OPPORTUNITY_STRATEGIC_VALUE_CODE VARCHAR2 64 Strategy for the opportunity and Stores Values Such as ('High', 'Low', 'Medium') DW_CXS_STRATEGIC_VALUE_CODE_D_TL CODE
OPPORTUNITY_RISK_LEVEL_CODE VARCHAR2 64 Risk Level for the opportunity. And Stores Values Such as ('High', 'Low', 'None') DW_CXS_RISK_LEVEL_CODE_D_TL CODE
OPPORTUNITY_DECISION_LEVEL_CODE VARCHAR2 64 Decision level for the opportunity. And Stores values such as ('CEO', 'CIO', 'Director', 'Manager', 'Other', 'VP') DW_CXS_DECISION_LEVEL_CODE_D_TL CODE
OPPORTUNITY_DEAL_HORIZON_CODE VARCHAR2 64 Deal Horizon for the opportunity. And Stores values such as ('Greater than 120 days', 'Less than 15 days','15 - 30 days','31 - 60 days','61 - 120 days') DW_CXS_DEAL_HORIZON_CODE_D_TL CODE
LEAD_NAME VARCHAR2 256 Lead Name used for identifying the lead.
LEAD_NUMBER VARCHAR2 128 Lead number. System generated key for this table.
LEAD_STATUS_CODE VARCHAR2 32 Status Code . Denotes the current status of the lead.('UNQUALIFIED','CONVERTED','RETIRED','QUALIFIED') DW_CXS_LEAD_STATUS_D_TL CODE
LEAD_QUALIFIED_DATE DATE Qualified Date. Stores the date the lead was qualified.
LEAD_CHANNEL_TYPE_CODE VARCHAR2 64 Channel type of the lead. DW_CXS_LEAD_CHANNEL_D_TL CODE
LEAD_OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Lead Owner Resource DW_CXS_RESOURCE_D RESOURCE_ID
LEAD_PRIMARY_CONTACT_ID NUMBER 38 0 Primary Contact Id . Denormalized column from lead contacts table. DW_CXS_CONTACT_D CONTACT_ID
LEAD_CUSTOMER_ORGANIZATION_TYPE_CODE VARCHAR2 32 Lead Customer Organization Type. ('ORGANIZATION','A: Health; T: Health','A: Commercial; T: Higher Ed','A: Commercial; T: Health','A: Commercial; T: PS-SL','PUBLIC_COMPANY') DW_CXS_ORGANIZATION_TYPE_CODE_D_TL CODE
LEAD_ESTIMATED_CLOSE_DATE DATE Estimated close date of the deal
LEAD_CUSTOMER_EXISTING_FLAG VARCHAR2 32 Customer Existing Flag.
LEAD_CUSTOMER_ID NUMBER 38 0 Customer Identifier DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEAD_SCORE NUMBER 38 0 Score for this lead.
LEAD_CREATION_DATE DATE Business specific Creation Date of the lead.
LEAD_EXPIRATION_DATE DATE Expiration Date of the deal.
LEAD_ACTIVITY_DATE DATE Last Activity Date for lead
ACTIVITY_PRIMARY_CONTACT_ID NUMBER 38 0 Primary Contact Id . Denormalized column from activity contacts table. DW_CXS_CONTACT_D CONTACT_ID
ACTIVITY_DELEGATOR_ID NUMBER 38 0 ID of the Delegator (resource) of the activity
ACTIVITY_CUSTOMER_PARTY_ID NUMBER 38 0 Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID
LEAD_PRIMARY_PRODUCT_ITEM_ID NUMBER 38 0 Primary Inventory Item Primy Id
LEAD_PRIMARY_INVENTORY_ORGANIZATION_ID NUMBER 38 0 Primary Inventory Organization Primy Id
LEAD_PRIMARY_PRODUCT_GROUP_ID NUMBER 38 0 Primary Product Group Primy Id
LEAD_PRIMARY_PRODUCT_ID NUMBER 38 0 Product Identifier for the Product or Product Group
LEAD_RETIRED_DATE DATE Date and time when the lead was Retired
LEAD_CONVERSION_DATE DATE Converted date Indicates when the lead was converted to an opportunity.
LEAD_BUDGET_AMOUNT NUMBER Budget Amount.
LEAD_AMOUNT NUMBER Deal size for the lead.
CRM_CURRENCY_LEAD_AMOUNT NUMBER Deal size convtered to CRM Currency
GLOBAL_CURRENCY_LEAD_AMOUNT NUMBER Deal size convtered to Global Currency
GLOBAL_CURRENCY_LEAD_BUDGET_AMOUNT NUMBER Converting Budget Amount in To Global Currency
LEAD_ACCEPTED_DATE DATE Date when the lead was accepted.
LEAD_REJECTED_DATE DATE Date when the lead was rejected.
LEAD_APPROVAL_DATE DATE Approval date of the deal. This is a deal specific attribute.
LEAD_APPROVER_ID NUMBER 38 0 Approver Id. Foreign key to TCA party Id of resource who approved lead registration.
LEAD_BUDGET_CURRENCY_CODE VARCHAR2 32 Budget Currency Code
LEAD_CURRENCY_CODE VARCHAR2 32 Currency code for the lead.('USD','GBP','INR','EUR')
LEAD_CRM_CURRENCY_CODE VARCHAR2 32 Corporate Currency Code('USD','GBP','INR','EUR')
LEAD_GLOBAL_CURRENCY_CODE VARCHAR2 32 Global Currency Code('USD','GBP','INR','EUR')
LEAD_ACCEPTED_FLAG VARCHAR2 32 Lead Accepted Flag. Indicator for whether the lead is accepted
LEAD_ASSIGNMENT_STATUS_CODE VARCHAR2 32 Assignment Status Code. Tracks the current assignment related status for the lead ('ASSIGNED','REJECTED') DW_CXS_LEAD_ASSIGNMENT_STATUS_D_TL CODE
LEAD_QUALITY_CODE VARCHAR2 32 Quality code of the lead.('5-Poor','2-Very High','3-High','1-Excellent','4-Fair')
LEAD_RETIRE_REASON_CODE VARCHAR2 64 Retire Reason Code . Tracks the reason this lead was retired.('DUPLICATE_LEAD','NOT_INTERESTED','Opportunity Created','OPPORTUNITY_CREATED') DW_CXS_LEAD_RETIRE_REASON_D_TL CODE
LEAD_QUALIFICATION_SCORE NUMBER 38 0 Qualification Score of the lead.
LEAD_RANK_CODE VARCHAR2 64 Rank of the lead.('COOL','HOT','WARM') DW_CXS_LEAD_RANK_D_TL CODE
LEAD_SALES_CHANNEL_CODE VARCHAR2 32 Sales Channel is the channel through which the deploying company conducts the sales. Direct channel means that the sales force employed by the deploying company is used whereas indirect channel means that the partners of the deploying company are used.('ZPM_DIRECT_CHANNEL_TYPES','ZPM_PARTNER_CHANNEL_TYPES') DW_CXS_LEAD_SALES_CHANNEL_D_TL CODE
LEAD_BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Id stamped on the lead for tracking.
ACTIVITY_PRIVATE_FLAG VARCHAR2 16 16
OPPORTUNITY_ACTUAL_CLOSE_DATE DATE when opty is closed (status category in win/loss/no sale) then it is equal to effective date else null
SERVICE_REQUEST_ID NUMBER 38 0 Service Request ID
SERVICE_REQUEST_CONTACT_PARTY_ID NUMBER 38 0 The ongoing primary customer contact of the service request. DW_CXS_CONTACT_D CONTACT_ID
SERVICE_REQUEST_RESOURCE_PARTY_ID NUMBER 38 0 The engineer (resource) who is assigned to work on the service request. DW_CXS_RESOURCE_D RESOURCE_ID
SERVICE_REQUEST_CATEGORY_ID NUMBER 38 0 Foreign key; Service Catalog ID the service request is logged against. Derived from Product ID. DW_CXS_CATEGORIES_D CATEGORY_ID
SERVICE_REQUEST_INVENTORY_ITEM_ID NUMBER 38 0 The inventory item that the service request is logged against. DW_CXS_PRODUCT_D INVENTORY_ITEM_ID
SERVICE_REQUEST_INVENTORY_ORG_ID NUMBER 38 0 The organization of the inventory item that the service request is logged against. DW_CXS_PRODUCT_D INVENTORY_ORG_ID
SERVICE_REQUEST_PRODUCT_GROUP_ID NUMBER 38 0 The product group that the product belongs in. DW_CXS_PRODUCT_GROUP_D PRODUCT_GROUP_ID
SERVICE_REQUEST_ACCOUNT_PARTY_ID NUMBER 38 0 Account ID DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SERVICE_REQUEST_PARTNER_PARTY_ID NUMBER 38 0 Partner Account Party ID DW_CXS_PARTNER_D PARTNER_ID
SERVICE_REQUEST_REPORTED_BY_PARTY_ID NUMBER 38 0 Reported by Party ID DW_CXS_RESOURCE_D RESOURCE_ID
SERVICE_REQUEST_STATUS_CODE VARCHAR2 128 Lookup code that indicates the status code of the service request, such as NEW, INPROGRESS, WAITING, RESOLVED, CLOSED. DW_CXSR_STATUS_CODE_D_TL CODE
SERVICE_REQUEST_STATUS_TYPE_CODE VARCHAR2 128 Lookup code the indicates the status type of the status code, such as NEW, INPROGRESS, WAITING, RESOLVED, CLOSED. DW_CXSR_STATUS_TYPE_CODE_D_TL CODE
SERVICE_REQUEST_SEVERITY_CODE VARCHAR2 128 Lookup code that indicates the severity of the service request reported by the customer, such as SEV1, SEV2, SEV3, SEV4. DW_CXSR_SEVERITY_CODE_D_TL CODE
SERVICE_REQUEST_PRIORITY_CODE VARCHAR2 128 Lookup code that indicates the internal priority of the service request, such as HIGH, NORMAL, LOW. DW_CXSR_INTERNAL_PRIORITY_CODE_D_TL CODE
SERVICE_REQUEST_PROBLEM_CODE VARCHAR2 128 Lookup code that indicates the identified problem of the service request, such as PRODUCT, USER, DOCS. DW_CXSR_PROBLEM_CODE_D_TL CODE
SERVICE_REQUEST_RESOLUTION_CODE VARCHAR2 128 Lookup code that indicates the resolution of service request, such as SATISFIED, NOT_SATISFIED, RETURNED_PRODUCT, NEW_PURCHASE, UNKNOWN. DW_CXSR_RESOLUTION_CODE_D_TL CODE
SERVICE_REQUEST_SOURCE_CODE VARCHAR2 128 Lookup code that indicates how the SR was entered into the system, such as AGENT_UI, CUSTOMER_UI, API. DW_CXSR_SOURCE_CODE_D_TL CODE
SERVICE_REQUEST_CHANNEL_TYPE_CODE VARCHAR2 128 Lookup code that indicates the channel type. Examples: EMAIL, PHONE, FACEBOOK, TWITTER. DW_CXSR_CHANNEL_TYPE_CODE_D_TL CODE
SERVICE_REQUEST_OWNER_TYPE_CODE VARCHAR2 128 Lookup code that indicates the type of owner who is receiving service for this service request, such as CUSTOMER or PARTNER. DW_CXSR_OWNER_TYPE_CODE_D_TL CODE
SERVICE_REQUEST_STRIPE_CODE VARCHAR2 128 Lookup code that indicates the stripe code, such as CRM, HCM, or PRM. DW_CXSR_STRIPE_CODE_D_TL CODE
SERVICE_REQUEST_RESOLVE_OUTCOME_CODE VARCHAR2 128 Lookup code that indicates the outcome of a service request resolution, such as "solution provided", "unable to resolve", "customer abandoned". DW_CXSR_RESOLVE_OUTCOME_CODE_D_TL CODE
SERVICE_REQUEST_CREATION_DATE DATE Indicates the date and time of the creation of the row.
SERVICE_REQUEST_LAST_UPDATE_DATE DATE Indicates the date and time of the last update of the row.
SERVICE_REQUEST_OPEN_DATE DATE Migration Who Column: Defaults to CREATION_DATE if null, or for migration, set to the SR creation date.
SERVICE_REQUEST_LAST_REOPEN_DATE DATE Last reopen date of the SR if SR was reopened.
SERVICE_REQUEST_LAST_RESOLVED_DATE DATE Last resolved date of the SR if the SR has been resolved.
SERVICE_REQUEST_CLOSED_DATE DATE Closed date of the SR if SR is closed.
SERVICE_REQUEST_NUMBER VARCHAR2 256 Auto-generated unique number with customizable format.
SERVICE_REQUEST_CRITICAL_FLAG VARCHAR2 16 Indicates whether the service request is critical (Y or N).
SERVICE_REQUEST_TITLE VARCHAR2 512 A brief title of the service request.
SERVICE_REQUEST_PROBLEM_DESCRIPTION VARCHAR2 999 Problem description/statement/steps to reproduce issue for the service request.
SERVICE_REQUEST_RESOLVED_BY VARCHAR2 256 Indicates the user who resolved the service request.
SERVICE_REQUEST_DELETED_FLAG VARCHAR2 16 Indicates whether the service request is logically deleted (Y or N).
SERVICE_REQUEST_RESOLVE_DESCRIPTION VARCHAR2 999 Solution description, how the service request has been resolved.
SERVICE_REQUEST_CREATED_BY VARCHAR2 256 Migration Who Column: Defaults to CREATED_BY if null, or for migration, set to the user who created the row.
SERVICE_REQUEST_LAST_UPDATED_BY VARCHAR2 256 Migration Who Column: Defaults to LAST_UPDATED_BY if null, or for migration, set to the user who last updated the row.
TEMPLATE_FLAG VARCHAR2 16 Flag indicating whether this is a template activity.
SERVICE_REQUEST_LAST_TRANSFER_DATE DATE Indicates the date and time of the last transfer of the service request.
SERVICE_REQUEST_LAST_TRANSFER_TIMESTAMP TIMESTAMP Indicates the date and time of the last transfer of the service request.
SERVICE_REQUEST_FIRST_TRANSFER_DATE DATE Indicates the date and time of the last transfer of the service request.
SERVICE_REQUEST_FIRST_TRANSFER_TIMESTAMP TIMESTAMP Indicates the date and time of the last transfer of the service request.
SERVICE_REQUEST_LAST_TRANSFERRED_BY VARCHAR2 256 Indicates the user who last transferred the service request.
SERVICE_REQUEST_TRANSFER_COUNT NUMBER 38 0 Count showing how many times a service request has been transferred.
SERVICE_REQUEST_TRANSFER_FLAG VARCHAR2 64 derive logic from FAW (case when transfer_count > 0 then 'Y' else 'N' end)
SERVICE_REQUEST_TRANSFER_NOTE VARCHAR2 999 This field contains information about transfer note.
SERVICE_REQUEST_TRANSFER_REASON_CODE VARCHAR2 64 Lookup code that indicates the transfer reason. DW_CXSR_TRANSFER_REASON_CODE_D_TL CODE