This table stores Activity Resource Details
Module:
ASSIGNEE_ID, ACTIVITY_ID
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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.