It stores certification 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_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, 2023, Oracle and/or its affiliates.