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

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