DW_CXS_LEAD_ACCESS_D

This table stores Lead Access

Details

Module: Opportunity Management

Key Columns

LEAD_ACCESS_ID, TYPE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEAD_ACCESS_ID NUMBER 38 0 True The unique identifier for the activity.    
TYPE_CODE VARCHAR2 32   True The unique identifier for the activity.    
SOURCE_RECORD_ID VARCHAR2 256     System    
ACCESS_LEVEL_CODE VARCHAR2 32     Access Level code of resource on lead for records with type RESOURCE or TERRITORY    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
GROUP_ID NUMBER 38 0   Contains either Resources Party Id or Territory Id based on Type column value    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
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.    
LEAD_EFFECTIVE_DATE TIMESTAMP       Effective Date which is a de-normalized column of Creation_Date in MKL_LM_LEADS    
LEAD_ID NUMBER 38 0   Lead Id to which the row belongs    
LEAD_RESOURCE_ID NUMBER 38 0   Lead Resource Id which is primary key column to MKL_LEAD_RESOURCES table    
LEAD_STATUS_CD VARCHAR2 32     Status Code which is a de-normalized column of Status Code in MKL_LM_LEADS    
LEAD_TERRITORY_ID NUMBER 38 0   Lead Territory Id which is primary key column to MKL_LEAD_TERRITORY table    

Copyright © 2019, 2023, Oracle and/or its affiliates.