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 This column is for Oracle Internal use only. 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