It stores profile education details
Module: Recruiting
PROFILE_ITEM_ID
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 |