This table requires activation of Learning Management functional area. This table stores Specialization information along with Learning Item details
Module: Work Life
EFFECTIVE_START_DATE, SPECIALIZATION_ID, EFFECTIVE_END_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SPECIALIZATION_ID | NUMBER | 38 | 0 | True | System generated unique identifier | ||
| EFFECTIVE_START_DATE | DATE | True | Indicates the date at the beginning of the date range within which the row is effective | ||||
| EFFECTIVE_END_DATE | DATE | True | Indicates the date at the end of the date range within which the row is effective | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| LEARNING_ITEM_ID | NUMBER | 38 | 0 | This column behaves as foriegn key and refers to parent table column | |||
| SPECIALIZATION_NUMBER | VARCHAR2 | 32 | Specialization number | ||||
| START_DATE | DATE | Specialization Start Date | |||||
| END_DATE | DATE | Specialization End Date | |||||
| STATUS_CODE | VARCHAR2 | 32 | Specialization status code | ||||
| ATTRIBUTION_PERSON_ID | NUMBER | 38 | 0 | Person who published the specialization |
Copyright © 2019, 2024, Oracle and/or its affiliates.