DW_CXS_ACTIVITY_ASSIGNEES_D

This table stores Activity Resource Details

Details

Module:

Key Columns

ACTIVITY_ID, ASSIGNEE_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 This column is for Oracle Internal use only. 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