| Data element |
Definition |
ASSIGNMENT_DATE
Indexed - no
Format - date
May be null? yes |
The date when the Course was assigned to the Learner in WDL. The value will be null if the Course is not assigned to the Learner (PENN_ID) in WDL or if the Learner is not an active WDL user.
Source: Workday Learning
|
COMPLETED
Indexed - yes
Format - char (1)
May be null? yes |
Y or N. This column has the same value as COMPLETED_AT_LEAST_ONCE.
Source: Based on Knowledge Link and Workday Learning data
|
COMPLETED_AT_LEAST_ONCE
Indexed - no
Format - char (1)
May be null? yes |
If the Learner completed the Course (or an Item with the Item ID) with credit at least once in WDL or KL, the value is Y; otherwise, it is N. NOTE: If the Learner never completed the Course in WDL, and COMPLETED_AT_LEAST_ONCE is N, it is possible that the Learner got credit in KL for completing an Item with the Item ID in the past, but the status of their latest KL learning history record(s) for the Item ID is Incomplete. This column has the same value as COMPLETED.
Source: Based on Knowledge Link and Workday Learning data
|
COMPLETION_DATE
Indexed - no
Format - date
May be null? yes |
This column has the same value as LAST_COMPLETION_DATE_AND_TIME.
Source: Based on Knowledge Link and Workday Learning data
|
CONTENT_TYPE
Indexed - yes
Format - varchar2 (200)
May be null? yes |
The type of WDL learning content: Course Offering, Digital Course, or Program.
Source: Workday Learning
|
COURSE_SOURCE
Indexed - no
Format - varchar2 (200)
May be null? yes |
The source of the WDL Course (for example, PSOM - Office of Clinical Research); null for Programs.
Source: Workday Learning
|
CURRENTLY_ASSIGNED
Indexed - no
Format - char (1)
May be null? yes |
Y or N, per the WDL assignment. The value will be null if the Learner (PENN_ID) is not an active WDL user.
Source: Workday Learning
|
CURRENTLY_REQUIRED
Indexed - no
Format - char (1)
May be null? yes |
Y or N, per the WDL assignment. The value will be null if the Course is not assigned to the Learner (PENN_ID) in WDL or if the Learner is not an active WDL user.
Source: Workday Learning
|
FIRST_NAME
Indexed - yes
Format - varchar2 (200)
May be null? yes |
This column has the same value as FIRST_NAME.
Source: Based on Knowledge Link and Workday Learning data |
INSTRUCTION_ID
Indexed - yes
Format - varchar2 (300)
May be null? yes |
ITEM_ID (for example, UP.87023.ITEM.ERS001) for ITEM_IDs with or without a corresponding WDL Course or Program;
'WDL~' || LEARNING_CONTENT_TITLE for Courses without a corresponding ITEM_ID.
Source: Based on Knowledge Link and Workday Learning data |
ITEM_ID
Indexed - yes
Format - varchar2 (90)
May be null? yes |
Part 2 of the 3-part Item Key (Item Type, ID, and Revision Date). The Item Key is the unique identifier for a Knowledge Link Item. An Item ID may or may not have a corresponding Workday Course or Program.
Source: Knowledge Link |
ITEM_ID_STATUS
Indexed - no
Format - char (1)
May be null? yes |
A (Active) or I (inactive). The value will be null if the WDL Learning Content does not have a corresponding Item ID in KL.
Source: Knowledge Link |
LAST_COMPLETION_DATE_AND_TIME
Indexed - no
Format - date (90)
May be null? yes |
The latest date when the Learner (PENN_ID) got credit for completing the Course (or an Item with the Item ID) in WDL or KL. (See the NOTE for COMPLETED_AT_LEAST_ONCE.)
This column has the same value as COMPLETION_DATE.
Source: Based on Knowledge Link and Workday Learning data |
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The latest date when the the data was refreshed in the DWLMS.WDL_CURRENT_LEARNING_STATUS and/or DWLMS.LM_CURRENT_TRAINING_STATUS record(s)
Source: Based on Knowledge Link and Workday Learning data |
LAST_NAME
Indexed - yes
Format - varchar2 (200)
May be null? yes |
This column has the same value as PREFERRED_LAST_NAME.
Source: Based on Knowledge Link and Workday Learning data |
LEARNING_CONTENT_NUMBER
Indexed - yes
Format - varchar2 (200)
May be null? yes |
The Course Number or the Program Number, depending on the Content Type; null for LinkedIn Learning courses and Item IDs with no corresponding WDL Learning Content.
Source: Workday Learning |
LEARNING_CONTENT_STATUS
Indexed - yes
Format - varchar2 (200)
May be null? yes |
Open or Closed. The status of the Workday Learning (WDL) Course Number or the Program Number, depending on the Content Type. The value will be null if the Item ID does not have a corresponding Course or Program in WDL.
Source: Workday Learning |
LEARNING_CONTENT_TITLE
Indexed - yes
Format - varchar2 (200)
May be null? yes |
The Course Title or the Program Title, depending on the Content Type. If the INSTRUCTION_ID is an Item ID with no corresponding WDL Learning Content, this is the min(ITEM_TITLE) for the ITEM_ID in DWLMS.LM_ITEM.
Source: Based on Knowledge Link and Workday Learning data |
MIDDLE_INITIAL
Indexed - no
Format - varchar2 (200)
May be null? yes |
This column has the same value as PREFERRED_MIDDLE_INITIAL.
Source: Based on Knowledge Link and Workday Learning data |
MULTIPLE_ITEM_KEYS
Indexed - no
Format - char (1)
May be null? yes |
Y or N. The 3-part Item Key (Item Type, ID, and Revision Date) is the unique identifier for a Knowledge Link Item. The value is Y if the Learner (PENN_ID) has multiple KL records with the same Item ID but different Item Keys. In that case, it is a judgement call as to whether to use the completion data in DWLMS.WDL_AND_KL_CURR_LEARN_STATUS_V or in DWLMS.LM_CURRENT_TRAINING_STATUS. See also MULTIPLE_ITEM_TYPES and MULTIPLE_ITEM_REV_DATES.
Source: Knowledge Link |
MULTIPLE_ITEM_REV_DATES
Indexed - no
Format - char (1)
May be null? yes |
Y or N. The 3-part Item Key (Item Type, ID, and Revision Date) is the unique identifier for a Knowledge Link Item. The value is Y if the Learner (PENN_ID) has multiple KL records with the same Item ID but different Revision Dates. In that case, it is a judgement call as to whether to use the completion data in DWLMS.WDL_AND_KL_CURR_LEARN_STATUS_V or in DWLMS.LM_CURRENT_TRAINING_STATUS. (For example, a learner could have two LM_CURRENT_TRAINING_STATUS records for Item ID UP.83015.ITEM.XRDEN, one with Revision Date 10/1/2012 and the other with Revision Date 3/1/2019.) See also MULTIPLE_ITEM_KEYS and MULTIPLE_ITEM_TYPES.
Source: Knowledge Link |
MULTIPLE_ITEM_TYPES
Indexed - no
Format - char (1)
May be null? yes |
Y or N. The 3-part Item Key (Item Type, ID, and Revision Date) is the unique identifier for a Knowledge Link Item. The value is Y if the Learner (PENN_ID) has multiple KL records with the same Item ID but different Item Types. In that case, it is a judgement call as to whether to use the completion data in DWLMS.WDL_AND_KL_CURR_LEARN_STATUS_V or in DWLMS.LM_CURRENT_TRAINING_STATUS. (For example, a learner could have two LM_CURRENT_TRAINING_STATUS records for Item ID UP.40013.ITEM.GTPLS0001, one with Item Type COURSE and the other with Item Type DOC.) See also MULTIPLE_ITEM_KEYS and MULTIPLE_ITEM_REV_DATES.
Source: Knowledge Link |
PENN_ID
Indexed - yes
Format - char (8)
May be null? no |
The unique identifier for the Learner in both WDL and KL. It consists of eight numerals.
Source: Based on Knowledge Link and Workday Learning data |
POSSIBILITY_OF_MISSING_TITLES
Indexed - no
Format - char (1)
May be null? yes |
Y or N. The value is Y if it is possible for the Learner to have records for the LEARNING_CONTENT_NUMBER with a LEARNING_CONTENT_TITLE that is not included in the view. In that case, it is a judgement call as to whether to use the completion data in DWLMS.WDL_AND_KL_CURR_LEARN_STATUS_V or in DWLMS.WDL_CURRENT_LEARNING_STATUS.
WDL does not display the Learning Course ID, but it uses it internally to uniquely identify units of Learning Content (Courses or Programs). A Learning Course ID does not necessarily have a LEARNING_CONTENT_NUMBER (for example, the value is null for LinkedIn Learning Courses), but if it does have one, the value ought to be unique. However, it is possible for more than one Learning Course ID to have the same value for LEARNING_CONTENT_NUMBER, and for that value to match an ITEM_ID. In that situation, when multiple LEARNING_CONTENT_TITLES are associated with the same LEARNING_CONTENT_NUMBER (ITEM_ID), the value of the LEARNING_CONTENT_TITLE in the DWLMS.WDL_KL_1_TO_1_INSTRUCTION_MAP is the min(LEARNING_CONTENT_TITLE) for the set of titles associated with the LEARNING_CONTENT_NUMBER. Because this view joins the _MAP to DWLMS.WDL_CURRENT_LEARNING_STATUS where LEARNING_CONTENT_TITLE = LEARNING_CONTENT_TITLE, if a title is not listed in the _MAP, this view will not return records for that title.
Source: Workday Learning |
PREFERRED_FIRST_NAME
Indexed - yes
Format - varchar2 (200)
May be null? yes |
If WDL has an assignment record or completion data for the Learner and Course, this is the Learner's Preferred First Name according to their WDL_USER record; otherwise, it is the Learner's First Name according to their LM_USER (KL user) record.
Source: Based on Knowledge Link and Workday Learning data |
PREFERRED_LAST_NAME
Indexed - yes
Format - varchar2 (200)
May be null? yes |
If WDL has an assignment record or completion data for the Learner and Course, this is the Learner's Preferred Last Name according to their WDL_USER record; otherwise, it is the Learner's Last Name according to their LM_USER (KL user) record.
Source: Based on Knowledge Link and Workday Learning data |
PREFERRED_MIDDLE_NAME
Indexed - yes
Format - varchar2 (200)
May be null? yes |
If WDL has an assignment record or completion data for the Learner and Course, this is the Learner's Preferred Middle Name according to their WDL_USER record; otherwise, it is the Learner's Middle Initial according to their LM_USER (KL user) record.
Source: Based on Knowledge Link and Workday Learning data
|
RETRAINING_REQUIRED
Indexed - no
Format - char (1)
May be null? yes |
Y or N, per the WDL assignment. The value will be null if the Course is not assigned to the Learner (PENN_ID) in WDL or if the Learner is not an active WDL user.
Source: Workday Learning |
WDL_HAS_LATEST_COMPLETION
Indexed - no
Format - char (1)
May be null? yes |
Y or N. If the flag is N, and the Course is assigned to the Learner in WDL, the EXPIRATION_DATE, etc. in the DWLMS.WDL_CURRENT_LEARNING_STATUS record does not take the KL completion into account. For example, WDL may consider the Course to be Overdue or Expired for the Learner, but if the KL completion were taken into account, the Course would not be flagged as Overdue or Expired for the Learner.
Source: Based on Knowledge Link and Workday Learning data |
WDL_USER_STATUS
Indexed - no
Format - char (1)
May be null? yes |
A (Active) or I (inactive). The value will be null if the Learner (PENN_ID) is not a Workday Learning (WDL) user.
Source: Workday Learning |
