Resource dimension
Module:
RESOURCE_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.