DW_TA_SOURCE_DIMENSION_D

DW_TA_SOURCE_DIMENSION_D stores source dimension details

Details

Module: Recruiting

Key Columns

DIMENSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DIMENSION_ID NUMBER 38 0 True Primary key for the dimension definition.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
SOURCE_URL_VALUE VARCHAR2 999 Name of the source parameter. The value that will be passed in the URL through the parameters.
SOURCE_MEDIUM VARCHAR2 64 The associated source medium lookup value corresponding to lookup type ORA_IRC_SOURCE_TRACKING_MEDIUM.