DW_CERTIFICATION_D

It stores certification 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_CODE VARCHAR2 32 Country Code
IMPORTANCE NUMBER 38 0 Importance
ITEM_TEXT_240_1 VARCHAR2 256 Title
ITEM_TEXT_240_2 VARCHAR2 256 Certification Number
ITEM_TEXT_240_3 VARCHAR2 256 Certification Name
ITEM_TEXT_240_4 VARCHAR2 256 Issued By
ITEM_TEXT_240_7 VARCHAR2 256 Training Completed Units
ITEM_TEXT_30_1 VARCHAR2 32 Renewal Required Flag
ITEM_TEXT_30_4 VARCHAR2 32 ITEM_TEXT_30_4
ITEM_TEXT_30_5 VARCHAR2 32 Renewal Inprogress Flag
ITEM_TEXT_30_6 VARCHAR2 32 Verified Flag
ITEM_TEXT_30_8 VARCHAR2 32 Status
ITEM_DATE_3 DATE Expiration Date
ITEM_DATE_4 DATE Renewal Date
ITEM_DATE_6 DATE Issue Date
ITEM_DATE_8 DATE ITEM_DATE_8
ITEM_DATE_9 DATE Actual Completion Date
ITEM_NUMBER_2 NUMBER 38 0 Completed Amount
ITEM_NUMBER_3 NUMBER 38 0 Total Amount
ITEM_NUMBER_4 NUMBER 38 0 ITEM_NUMBER_4
ITEM_NUMBER_9 NUMBER 38 0 Education Establishment ID