DW_DEGREE_D

It stores profile education details

Details

Module: Recruiting

Key Columns

PROFILE_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROFILE_ITEM_ID NUMBER 38 0 True Profile Item Identifier    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier    
BUSINESS_GROUP_ID NUMBER 38 0   Identifier of Enterprise, used for multi-tenancy partitioning.    
PROFILE_ID NUMBER 38 0   Profile Identifier    
CONTENT_ITEM_ID NUMBER 38 0   Content Item Identifier DW_CONTENT_ITEM_D_TL CONTENT_ITEM_ID
DATE_FROM DATE       Date From    
DATE_TO DATE       Date To    
COUNTRY_ID NUMBER 38 0   Country Identifier    
COUNTRY_CODE VARCHAR2 32     Country Code    
IMPORTANCE NUMBER 38 0   Importance    
STATE_PROVINCE_ID NUMBER 38 0   State Province Identifier    
ITEM_TEXT_240_1 VARCHAR2 256     Degree Major    
ITEM_TEXT_240_2 VARCHAR2 256     Area of Study    
ITEM_TEXT_240_3 VARCHAR2 256     Degree Awarded By Body    
ITEM_TEXT_240_4 VARCHAR2 256     Educator    
ITEM_TEXT_240_5 VARCHAR2 256     Degree Minor    
ITEM_TEXT_240_6 VARCHAR2 256     Average Grade    
ITEM_TEXT_240_7 VARCHAR2 256     Training Completed Units    
ITEM_TEXT_240_8 VARCHAR2 256     Degree Duration    
ITEM_TEXT_240_9 VARCHAR2 256     Department    
ITEM_TEXT_240_10 VARCHAR2 256     Title    
ITEM_TEXT_240_11 VARCHAR2 256     Degree Name    
ITEM_TEXT_30_1 VARCHAR2 32     Graduation Flag    
ITEM_TEXT_30_2 VARCHAR2 32     Terminal Degree for Discipline    
ITEM_TEXT_30_3 VARCHAR2 32     Currency of Fee    
ITEM_TEXT_30_4 VARCHAR2 32     Academic Standing    
ITEM_TEXT_30_6 VARCHAR2 32     Education Duration    
ITEM_TEXT_30_7 VARCHAR2 32     Tuition Method    
ITEM_TEXT_30_8 VARCHAR2 32     Education Level    
ITEM_TEXT_30_10 VARCHAR2 32     City    
ITEM_TEXT_30_11 VARCHAR2 32     Status    
ITEM_TEXT_30_12 VARCHAR2 32     Education Level Flag    
ITEM_TEXT_30_13 VARCHAR2 32     Highest Education Level    
ITEM_TEXT_30_14 VARCHAR2 32     Part-Time Flag    
ITEM_DATE_4 DATE       Degree End Date    
ITEM_DATE_6 DATE       Degree Completion date    
ITEM_DATE_7 DATE       Start Date    
ITEM_DATE_8 DATE       Projected Degree Completion date    
ITEM_NUMBER_1 NUMBER 38 0   Fee    
ITEM_NUMBER_2 NUMBER 38 0   Completed Amount    
ITEM_NUMBER_3 NUMBER 38 0   Total Amount    
ITEM_NUMBER_8 NUMBER 38 0   Degree Acquired Year    
ITEM_NUMBER_9 NUMBER 38 0   Education Establishment ID    
ITEM_DECIMAL_1 NUMBER       GPA