DW_CXS_LEAD_ACCESS_D

This table stores Lead Access

Details

Module:

Key Columns

TYPE_CODE, LEAD_ACCESS_ID

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