# DW_PRFL_PRSN_DEGREES_D

This dimension holds information about Person Profile type for Degrees

## Details

Module: Profile Management

## 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 | Key to Profile items |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Primary key of Profile | DW_PRFL_PROFILE_D | PROFILE_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group |  |
SECTION_ID | NUMBER | 38 | 0 |  | Section Identifier |  |
DATE_FROM | DATE |  |  |  | Date From |  |
DATE_TO | DATE |  |  |  | Date To |  |
QUALIFIER_ID1 | NUMBER | 38 | 0 |  | The instance qualifier to use for the item |  |
SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source Type. For example, HRTR |  |
CONTENT_TYPE_ID | NUMBER | 38 | 0 |  | Content type Identifier | DW_CONTENT_TYPE_D | CONTENT_TYPE_ID
CONTENT_ITEM_ID | NUMBER | 38 | 0 |  | Content item Identifier | DW_CONTENT_ITEM_D | CONTENT_ITEM_ID
MAJOR | VARCHAR2 | 256 |  |  | Major |  |
EDUCATIONAL_ESTABLISHMENT_ID | NUMBER | 38 | 0 |  | School Id | DW_CONTENT_ITEM_D | CONTENT_ITEM_ID
DEGREE_START_DT | DATE |  |  |  | Degree Start Date |  |
DEGREE_END_DT | DATE |  |  |  | Degree End Date |  |
CITY | VARCHAR2 | 256 |  |  | City |  |
STATE_PROVINCE_ID | NUMBER | 38 | 0 |  | State Province Identifier | DW_PRFL_GEOGRAPHY_D | GEOGRAPHY_ID
COUNTRY_ID | NUMBER | 38 | 0 |  | Country Identifier | DW_PRFL_GEOGRAPHY_D | GEOGRAPHY_ID
YEAR_ACQUIRED | NUMBER | 38 | 0 |  | Year Acquired |  |
PROJECTED_COMP_DATE | DATE |  |  |  | Projected Completion Date |  |
COUNTRY_CODE | VARCHAR2 | 32 |  |  | Country Code |  |
STATE_PROVINCE_CODE | VARCHAR2 | 512 |  |  | State Province Code |  |

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