DW_CXS_ACTIVITY_ASSIGNEES_D

This table stores Activity Resource Details

Details

Module: Opportunity Management

Key Columns

ASSIGNEE_ID, ACTIVITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_ID NUMBER 38 0 True The unique identifier for the activity.    
ASSIGNEE_ID NUMBER 38 0 True ID of the HZ_PARTY record with a party_usage = Resource    
SOURCE_RECORD_ID VARCHAR2 256     System    
ACTIVITY_NUMBER VARCHAR2 128     Activity Number.This is added to the child table mainly for the batch import where the parent record may not exist.    
ACTIVITY_ASSIGNEE_ID NUMBER 38 0   Surrogate key for assignee.This is added based on the requirement from Outlook and BI. This column is not a substitute for primary key.    
ATK_MESSAGE_ID NUMBER 38 0   Identifier for the ATK popup notification created    
CORP_CURRENCY_CODE VARCHAR2 16     Holds Corporate Currency Code from profile    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
CURCY_CONV_RATE_TYPE VARCHAR2 32     Holds Currency Conversion Rate Type from profile    
CURRENCY_CODE VARCHAR2 16     Holds currency code of a record    
LAST_UPDATE_LOGIN VARCHAR2 64     Who column: indicates the session login associated to the user who last updated the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
RECUR_SERIES_ID NUMBER 38 0   Recurrence Series Id.This is for deleting the recur instance child records    
REMINDER_DATETIME TIMESTAMP       Actual time when the reminder will be sent.    
REMINDER_PERIOD NUMBER 38 0   Period of the Appointment Reminder    
RESPONSE_CODE VARCHAR2 32     User friendly name for Appointment Response Code    
SENDER_JOB_ID NUMBER 38 0   Job Identifier for the Sender Job    
SHOW_TIME_AS_CODE VARCHAR2 32     User friendly name for Show Time As Code.    
USER_LAST_UPDATE_DATE TIMESTAMP       Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).    
ATTENDEE_FLAG VARCHAR2 16     Identify if the assignee is an attendee.    
DISMISS_FLAG VARCHAR2 16     Flag that indicates a Call Report creation for Activity is dismissed for the Assignee    
SORT_DATE TIMESTAMP       This is an internal column which is used to sort the activity based on the due date for task and start date for activity.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
ACTIVITY_FUNCTION_CODE VARCHAR2 32     This attribute is for internal use and the value is set based on the user's navigation to the activity whether it is Task or Appointment.    
ASSIGNEE_ORG NUMBER 38 0   Indicates the identifier of the business unit associated to the Assignee.    
ATTRIBUTE_CATEGORY VARCHAR2 32     Descriptive Flexfield: structure definition of the user descriptive flexfield.    
UPG_SOURCE_OBJECT_ID NUMBER 38 0   Primary key value of the record in the source table that is upgraded to Rel9 Activity record.    
UPG_SOURCE_OBJECT_TYPE VARCHAR2 32     Source object type could be Appointment, Task or Interaction to indicate the source of the upgraded record.    
STATUS_CODE VARCHAR2 32     Status of the activity.This is based on the lookup.    
ACTIVITY_PRIVATE_FLAG VARCHAR2 16     FWA Derived flag from activity table