Activity Fact
Module: Opportunity Management
ACTIVITY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ACTIVITY_ID | NUMBER | 38 | 0 | True | Primary key | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | 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 | 32 | 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 | 32 | 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 | 32 | 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 | 32 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.