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
PARENT_RESOURCE_ID NUMBER 38 0 the sales Resource Party
PARENT_ORGANIZATION_ID NUMBER 38 0 the sales Resource Party