DW_CXS_ACTIVITY_RESOURCE_CF

Activity Assign Fact

Details

Module:

Key Columns

ACTIVITY_ID, RESOURCE_PARTY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_ID NUMBER 38 0 True Primary key    
RESOURCE_PARTY_ID NUMBER 38 0 True Primary key    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Unique Identifier    
SHOW_TIME_AS_CODE VARCHAR2 32     User friendly name for Show Time As Code('TENTATIVE','FREE','BUSY') DW_CXS_ACTIVITY_RESOURCE_SHOW_TIME_D_TL Code
APPOINTMENT_RESPONSE_CODE VARCHAR2 32     User friendly name for Appointment Response Code('NOT_RESPONDED','ACCEPT','TENTATIVELY_ACCEPT') DW_CXS_ACTIVITY_RESOURCE_RESPONSE_D_TL Code
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    
APPOINTMENT_REMINDER_PERIOD_CODE VARCHAR2 32     Period of the Appointment Reminder ('2 hours before','1 day before','15 minutes before','2 days before','30 minutes before','5 minutes before','1 hour before') DW_CXS_ACTIVITY_RESOURCE_REMINDER_D_TL Code
ACTIVITY_NUMBER VARCHAR2 128     A default, system generated number. Customers should be able to use their own number scheme.    
ACTIVITY_OWNER_FLAG VARCHAR2 32     Direved Flag to identified Primary Resource    
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_TYPE_CODE VARCHAR2 32     It describes the channel through which the communication has taken place, (email, phone call, chat ,Demo) DW_CXS_ACTIVITY_TYPE_D_TL Code
ACTIVITY_SUBTYPE_CODE VARCHAR2 32     ACTIVITY_SUBTYPE_CODE (DEMO :(INTERNAL DEMO,EXTRNAL DEMO) DW_CXS_ACTIVITY_SUBTYPE_D_TL ACTIVITY_SUBTYPE_CODE
ACTIVITY_ACTUAL_END_DATE DATE       The date and time when the activity is ended    
ACTIVITY_ACTUAL_END_TIMESTAMP TIMESTAMP       The date and time when the activity is ended    
ACTIVITY_ACTUAL_START_DATE DATE       The date and time when the activity is started    
ACTIVITY_ACTUAL_START_TIMESTAMP TIMESTAMP       The date and time when the activity is started    
ACTIVITY_ALL_DAY_FLAG VARCHAR2 32     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_DURATION NUMBER 38 0   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.('CALL_ANSWERED','CALL_TRANSFERRED','CAPTURED_ISSUE','CUSTOMER_UNDECIDED','FAILED','INCOMPLETE','NOT_AVAILABLE','NO_ANSWER') DW_CXS_ACTIVITY_OUTCOME_D_TL Code
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.    
ACTIVITY_CUSTOMER_PARTY_TYPE_CODE VARCHAR2 32     Party Type of associated account    
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
ACTIVITY_PARTNER_PARTY_ID NUMBER 38 0   Partner Organization Identifier. DW_CXS_PARTNER_D PARTNER_ID
ACTIVITY_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
ACTIVITY_OPPORTUNITY_ID NUMBER 38 0   Opportunity Identifier in which the activity is related to.    
ACTIVITY_CREATION_DATE DATE       audit columns for activity tables    
ACTIVITY_CREATION_TIMESTAMP TIMESTAMP       audit columns for activity tables    
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
ACTIVITY_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.    
ACTIVITY_RECURRENCE_SERIES_ID NUMBER 38 0   This is for the recurring appoinment instance row.The recurrence series appointment id is stored in this attribute.    
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    
OWNER_RESOURCE_PARTY_ID NUMBER 38 0     DW_CXS_RESOURCE_D RESOURCE_ID
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
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.    
ACTIVITY_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, 2024, Oracle and/or its affiliates.