DW_CXS_RESOURCE_D

Resource dimension

Details

Module:

Key Columns

RESOURCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RESOURCE_ID NUMBER 38 0 True Unique identifier for the sales Resource Party    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique identifier    
RESOURCE_PROFILE_ID NUMBER 38 0   the sales Resource Party    
NAME VARCHAR2 512     Resource name.    
EMAIL_ADDRESS VARCHAR2 512     Resource Email Address    
PRIMARY_ORGANIZATION_ID NUMBER       Organization code for sales resource DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
JOB_TITLE_CODE VARCHAR2 64     Job title code for Sales Resource DW_CXS_JOB_TITLE_D_TL CODE
JOB_TITLE VARCHAR2 128     Job title for Sales Resource    
PHONE VARCHAR2 64     Phone Number of Sales Resource    
PRIMARY_ROLE_CODE VARCHAR2 64     Role code of Sales Resource DW_CXS_SALES_RESOURCE_ROLE_CODE_TL CODE
ADDRESS1 VARCHAR2 256     First line of the Identifying address    
ADDRESS2 VARCHAR2 256     Second line of the Identifying address    
ADDRESS3 VARCHAR2 256     Third line of the Identifying address    
ADDRESS4 VARCHAR2 256     Fourth line of the Identifying address    
CITY VARCHAR2 64     City of the Identifying address    
COUNTRY VARCHAR2 16     The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.    
COUNTY VARCHAR2 64     County of the Identifying address    
POSTAL_CODE VARCHAR2 64     Postal Code of the Identifying address    
PROVINCE VARCHAR2 64     Province of the Identifying address    
STATE VARCHAR2 64     State of the Identifying address    
LATITUDE NUMBER       Used to store Latitude Information for the Location for Spatial Proximity and containment purposes    
LONGITUDE NUMBER       Used to store Longitude Information for the Location for Spatial Proximity and containment purposes    
END_DATE_ACTIVE DATE       Indicates the date at which the resource becomes inactive    
START_DATE_ACTIVE DATE       Date this role-resource becomes active    
CREATION_DATE TIMESTAMP       who column for creation date    

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