DW_PRFL_JOB_DEGREES_CRNT_F

This view contains the job profile information for degrees content type

Details

Module: Profile Management

Key Columns

PROFILE_ITEM_ID, JOB_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 DW_PRFL_PROFILE_ITEM_D PROFILE_ITEM_ID
JOB_ID NUMBER 38 0 True Job Identifier DW_JOB_D JOB_ID
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique identifier
PROFILE_ID NUMBER 38 0 Profile Identifier DW_PRFL_PROFILE_D PROFILE_ID
BUSINESS_GROUP_ID NUMBER 38 0 Business Group
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
SOURCE_TYPE VARCHAR2 32 Source Type. For example, HRTR
CALENDAR_DATE DATE Calendar Date
MAJOR VARCHAR2 256 Major
EDUCATIONAL_ESTABLISHMENT_ID NUMBER 38 0 School DW_PRFL_ESTABLISHMENT_D ESTABLISHMENT_ID
COUNTRY_ID NUMBER 38 0 Country DW_PRFL_GEOGRAPHY_D GEOGRAPHY_ID
GRADUATION_REQUIRED_FLAG VARCHAR2 32 Graduation Required
REQUIRED_GPA NUMBER Required GPA
REQUIRED_FLAG VARCHAR2 32 Required
SECTION_ID NUMBER 38 0 Section Identifier
QUALIFIER_ID1 NUMBER 38 0 The instance qualifier to use for the item DW_PRFL_QUALIFIERS_D QUALIFIER_ID
COUNTRY_CODE VARCHAR2 32 Country Code