# 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 |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.