• CO_MAS_ID
• CO_MAS_ID_AS_IS
• CO_REC_ID
• CO_REC_ID_AS_IS
• COMPLIANT
• COURSE_COMPLETED
• COURSE_MASTER_ID
• COURSE_OR_ITERATION_TITLE
• COURSE_OWNER_BU_ID
• COURSE_OWNER_BU_NAME
• COURSE_OWNER_BU_NUMBER
• COURSE_TITLE_AND_ID
• CURRENT_COURSE_REG_FLAG
• CURRENT_CRS_ITERATION_REG_FLAG
• CURRENT_PERIODICITY
• CURRENTLY_REQUIRED
• DATE_COURSE_COMPLETED
• DATE_REGISTRATION_CREATED
• DATE_REGISTRATION_DROPPED
• DATE_REGISTRATION_MODIFIED
• DUE_BY_DATE

• FIRST_NAME
• ITERATION_ID
• LAST_COURSE_COMPLETION_FLAG
• LAST_CRS_COMPL_OR_REG_FLAG
• LAST_EXTRACT_DATE
• LAST_NAME
• MIDDLE_INITIAL
• NEXT_COURSE_DATE
• OVERDUE
• PENN_ID
• REG_REC_ID
• REGISTRATION_BU_ID
• REGISTRATION_BU_NAME
• REGISTRATION_BU_NUMBER
• REGISTRATION_STATUS_CODE
• REGISTRATION_STATUS_DESC
• REGISTRATION_STATUS_REASON
• STATUS_DUEDATE_DESCRIPTION
• TIME_COURSE_COMPLETED
• USER_REC_ID
• WAIT_LIST_PRIORITY

The number used within the Knowledge Link system as the unique identifier for the course, which is either a course that is currently required for the trainee, or an optional course for which the trainee has registered. See also COURSE_MASTER_ID, COURSE_OR_ITERATION_TITLE, COURSE_TITLE_AND_ID, and CO_MAS_ID_AS_IS.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

To retrieve the attributes of the course, query the LMS_COURSE_MASTER table where LMS_CURRENT_TRAINEE_CRS_STATUS.CO_MAS_ID = LMS_COURSE_MASTER.CO_MAS_ID.

Examples: 12437 (UNIV_ALL_ALL_PROFILER ); 10252 (UPHS_HUP_NURS_ORT131)

Values:
Refer to the LMS_COURSE_MASTER
or COURSE_MASTER table for values.
Note:  some of the courses in those tables
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

The numeric code identifying the course for which the trainee (USER_REC_ID) has registered according to the Knowledge Link REGISTRATION table's record where LMS_CURRENT_TRAINEE_CRS_STATUS.REG_REC_ID = REGISTRATION.REG_REC_ID. (That is the registration record that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID).) Trainees register for course iterations (not courses); CO_MAS_ID_AS_IS might not accurately reflect the course to which the course iteration (ITERATION_ID) belongs. If the trainee has not registered for the course, CO_MAS_ID_AS_IS is null. See also CO_MAS_ID, CO_REC_ID_AS_IS, and REG_REC_ID.

CO_MAS_ID_AS_IS stores the number used within the Knowledge Link system as the unique identifier for a course. To retrieve the attributes of that course, query the LMS_COURSE_MASTER table where LMS_CURRENT_TRAINEE_CRS_STATUS.CO_MAS_ID_AS_IS = LMS_COURSE_MASTER.CO_MAS_ID.

Examples: 12437 (UNIV_ALL_ALL_PROFILER ); 10221 (UPHS_HUP_NURS_ORT101)

Values:
Refer to the LMS_COURSE_MASTER
or COURSE_MASTER table for values.
Note:  some of the courses in those tables
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS 
records.

The number used within the Knowledge Link system as the unique identifier for the course version offered in the course iteration (ITERATION_ID) for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, CO_REC_ID is null. See also COURSE_MASTER_ID, COURSE_OR_ITERATION_TITLE, COURSE_TITLE_AND_ID, and CO_REC_ID_AS_IS, and REG_REC_ID.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

To retrieve the attributes of the course version, query the COURSE_OBJECT table where LMS_CURRENT_TRAINEE_CRS_STATUS.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.

Examples: 12675 (UNIV_ALL_ALL_PROFILER_v1; PennProfiler-Required Training Assessment-VPR); 10272 (UPHS_HUP_NURS_ORT131_v1; Nurse Residency Program - HUP); 10000 (UPHS_ALL_WORK_HIPAA105_v1; HIPAA Privacy Overview for the Workforce [Learning Module Only] - UPHS)

Values:
Refer to the COURSE_OBJECT table for values.
Note:  some of the course versions in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS 
records.

The numeric code identifying the course version for which the trainee has registered, according to the Knowledge Link REGISTRATION table's record where LMS_CURRENT_TRAINEE_CRS_STATUS.REG_REC_ID = REGISTRATION.REG_REC_ID. (That is the registration record that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID).) Trainees register for course iterations (not course versions); CO_REC_ID_AS_IS might not accurately reflect the course version that is offered in the course iteration (ITERATION_ID). If REG_REC_ID is null, CO_REC_ID_AS_IS is null. See also CO_REC_ID, CO_MAS_ID_AS_IS, and REG_REC_ID.

CO_REC_ID_AS_IS stores the number used within the Knowledge Link system as the unique identifier for a course version. To retrieve the attributes of that course version, query the COURSE_OBJECT table where LMS_CURRENT_TRAINEE_CRS_STATUS = COURSE_OBJECT.CO_REC_ID.

Examples: 12675 (UNIV_ALL_ALL_PROFILER_v1; PennProfiler-Required Training Assessment-VPR); 10241 (UPHS_HUP_NURS_ORT101_v1; Nursing Orientation - HUP)

Values:
Refer to the COURSE_OBJECT table for values.
Note:  some of the course versions in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS 
records.

A Yes/No flag indicating whether the trainee (USER_REC_ID) is currently compliant with regard to the course (CO_MAS_ID).

If the trainee is currently required to take the course, and has completed an iteration of the course, and is not overdue to complete the course again, the trainee is compliant with regard to the course. The term "compliant" has no meaning for optional courses. When CURRENTLY_REQUIRED is 'N', COMPLIANT is null.

Values:
[null] (the course is optional for the trainee)
Y      (the trainee is compliant with the course requirement)
N      (the trainee is not compliant with the course 
        requirement)

A Yes/No flag indicating whether the trainee (USER_REC_ID) has completed the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). Note: a trainee may legitimately be on record as having completed the course iteration even if the registration status is not Enrolled.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

COURSE_COMPLETED is 'N' if

• the trainee has not registered for the course, or
• the trainee has completed the course, but is overdue to complete it again.

Values:
Y (the trainee has completed the course iteration)
N (the trainee has not completed the course iteration,
   or is overdue to complete the course again,
   or has not registered for the course)

A string that uniquely identifies the course, which is either a course that is currently required for the trainee, or an optional course for which the trainee has registered. See also COURSE_MASTER_ID, COURSE_OR_ITERATION_TITLE, and COURSE_TITLE_AND_ID.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

To retrieve the attributes of the course, query the LMS_COURSE_MASTER table where LMS_CURRENT_TRAINEE_CRS_STATUS.COURSE_MASTER_ID = LMS_COURSE_MASTER.COURSE_MASTER_ID.

The COURSE_MASTER_ID may include letters and/or numerals and/or other characters. The letters in COURSE_MASTER_ID may be in upper case, lower case, or mixed case. Most COURSE_MASTER_ID values consist of four segments, in the following format:

1. the enterprise that developed the course, followed by an underscore. Examples: UNIV (the University); UPHS (the University of Pennsylvania Health System); SOM (the School of Medicine)
2. the intended audience for the course at the entity, school or center level, followed by an underscore. Examples: MED (Medicine); CPP (Clinical Practices); ALL (all entities)
3. the intended audience for the course at the level of the division within the enterprise, followed by an underscore. Examples: EHRS (Environmental Health and Radiation Safety); NURS (Nursing); ALL (all schools or divisions)
4. the course identifier code (determined by the course developer)

Examples: UNIV_ALL_ALL_PROFILER; UPHS_HUP_NURS_ORT131

Values:
Refer to the LMS_COURSE_MASTER
or COURSE_MASTER table for values.
Note:  some of the courses in those tables
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

The title of the course iteration (ITERATION_ID) for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). See also COURSE_MASTER_ID and COURSE_TITLE_AND_ID.

If REG_REC_ID is null, COURSE_OR_ITERATION_TITLE is the title of the version of the course that has the highest version number. (That version is usually, but not always, the one whose iterations are scheduled in the future, or were scheduled most recently in the past.) The course per se has no title specified in Knowledge Link, but the title of the most recently created version may be considered to be the current title of the course.

The COURSE_OR_ITERATION_TITLE may be stored in upper case, lower case, or mixed case. Note: it is common for more than one course to have the same value for COURSE_OR_ITERATION_TITLE.

Examples: 'Atlas Upgrade February 2011'; 'Pyxis Profile Training - HUP' The value is stored without the surrounding quotes.

Values:
List of values not available

A string that uniquely identifies the business unit that owns the course version (CO_REC_ID) for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). See also COURSE_OWNER_BU_NAME and COURSE_OWNER_BU_NUMBER.

If REG_REC_ID is null, COURSE_OWNER_BU_ID identifies the business unit that owns the course version cited in the mandatory course assignment that makes the course currently required for the trainee. (For more information, see the documentation on COURSE_OWNER_BU_ID in the LMS_TRAINEE_COURSE_ASSIGN table.)

Knowledge Communities (KC) and Knowledge Microcommunities (KMCs) are the types of business units that are course version owners. The KCs that own course versions correspond to University orgs. or to University of Pennsylvania Health System (UPHS) entities (process levels) or departments (cost centers or accounting units). A KMC identifies a group of trainees from unrelated UPHS departments. (For further information on business units, see the documentation for the KNODE table. The business unit hierarchy is described in the documentation for PARENT_ID in the KNODE table.)

The owner of the course version is one of the criteria used to determine what course versions (if any) are included on the list of course versions that a given user can assign. For more information, see the data element documentation for COURSE_OBJECT.KNODE_ID.

The COURSE_OWNER_BU_ID is the KNODE.IDENTIFIER where LMS_REGISTRATION.COURSE_OWNER_BU_NUMBER = KNODE.KNODE_ID. For information on how the COURSE_OWNER_BU_ID value is formatted, see the data element documentation for KNODE.IDENTIFIER.

Examples: 'UP.EHRS'; 'HS.PATREG' The value is stored without the surrounding quotes.

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A phrase or string that describes the business unit that owns the course version (CO_REC_ID) for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). It is possible for more than one business unit to have the same name. See also COURSE_OWNER_BU_ID and COURSE_OWNER_BU_NUMBER.

If REG_REC_ID is null, COURSE_OWNER_BU_NAME describes the business unit that owns the course version cited in the mandatory course assignment that makes the course currently required for the trainee. (For more information, see the documentation on COURSE_OWNER_BU_NAME in the LMS_TRAINEE_COURSE_ASSIGN table.)

Knowledge Communities (KC) and Knowledge Microcommunities (KMCs) are the types of business units that are course version owners. The KCs that own course versions correspond to University orgs. or to University of Pennsylvania Health System (UPHS) entities (process levels) or departments (cost centers or accounting units). A KMC identifies a group of trainees from unrelated UPHS departments. (For further information on business units, see the documentation for the KNODE table. The business unit hierarchy is described in the documentation for PARENT_ID in the KNODE table.)

The owner of the course version is one of the criteria used to determine what course versions (if any) are included on the list of course versions that a given user can assign. For more information, see the data element documentation for COURSE_OBJECT.KNODE_ID.

The COURSE_OWNER_BU_NAME is the KNODE.NAME where LMS_REGISTRATION.COURSE_OWNER_BU_NUMBER = KNODE.KNODE_ID. For information on how the COURSE_OWNER_BU_NAME value is formatted, see the data element documentation for KNODE.NAME.

Examples: 'Environmental Health and Radiation Safety Parent'; 'Patient Registration' The value is stored without the surrounding quotes.

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

The number used within the Knowledge Link system as the unique identifier for the business unit that owns the course version (CO_REC_ID) for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). The COURSE_OWNER_BU_NUMBER value corresponds to a KNODE.KNODE_ID. See also COURSE_OWNER_BU_ID and COURSE_OWNER_BU_NAME.

If REG_REC_ID is null, COURSE_OWNER_BU_NUMBER identifies the business unit that owns the course version cited in the mandatory course assignment that makes the course currently required for the trainee. (For more information, see the documentation on COURSE_OWNER_BU_NUMBER in the LMS_TRAINEE_COURSE_ASSIGN table.)

Knowledge Communities (KC) and Knowledge Microcommunities (KMCs) are the types of business units that are course version owners. The KCs that own course versions correspond to University orgs. or to University of Pennsylvania Health System (UPHS) entities (process levels) or departments (cost centers or accounting units). A KMC identifies a group of trainees from unrelated UPHS departments. (For further information on business units, see the documentation for the KNODE table. The business unit hierarchy is described in the documentation for PARENT_ID in the KNODE table.)

The owner of the course version is one of the criteria used to determine what course versions (if any) are included on the list of course versions that a given user can assign. For more information, see the data element documentation for COURSE_OBJECT.KNODE_ID.

Example: 44922 (Environmental Health and Radiation Safety Parent [UP.EHRS])

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

The latest title and Course Master ID for the course, which is either a course that is currently required for the trainee, or an optional course for which the trainee has registered. See also CO_MAS_ID, COURSE_MASTER_ID, and COURSE_OR_ITERATION_TITLE.

The title portion of the COURSE_TITLE_AND_ID value is actually the title of the version of the course that has the highest version number. (That version is usually, but not always, the one whose iterations are scheduled in the future, or were scheduled most recently in the past.) The course per se has no title specified in Knowledge Link, but the title of the most recently created version may be considered to be the current title of the course.

The Course Master ID portion of the COURSE_TITLE_AND_ID value is surrounded by parentheses.

Examples: 'Atlas Upgrade February 2011 (UNIV_DOF_DAR_ATS02726)'; 'Pyxis Profile Training - HUP (UPHS_NURS_HUP_PYX100)' The value is stored without the surrounding quotes.

Values:
List of values not available

A Yes/No flag indicating whether the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the trainee's latest Enrolled or Wait-Listed registration for the course (CO_MAS_ID).

If REG_REC_ID is null, the value of CURRENT_COURSE_REG_FLAG is 'N'.

See also CURRENT_CRS_ITERATION_REG_FLAG, LAST_COURSE_COMPLETION_FLAG, LAST_CRS_COMPL_OR_REG_FLAG, REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_DESC, REGISTRATION_STATUS_REASON, WAIT_LIST_PRIORITY, and REG_REC_ID.

Values:
Y (the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS
   record reflects the trainee's latest Enrolled or 
   Wait-Listed registration for the course)
N (either the registration data in this
   LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the  
   trainee’s latest completion of the course, or the
   trainee has not registered for the course)

A Yes/No flag indicating whether the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the trainee’s current registration status with regard to the course iteration (ITERATION_ID).

See also CURRENT_COURSE_REG_FLAG, LAST_COURSE_COMPLETION_FLAG, LAST_CRS_COMPL_OR_REG_FLAG, REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_DESC, REGISTRATION_STATUS_REASON, WAIT_LIST_PRIORITY, and REG_REC_ID.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

CURRENT_CRS_ITERATION_REG_FLAG is 'N' if one of the following is true:

• The trainee has not registered for the course.
• The registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID) has been superseded by a later registration record pertaining to the trainee and the course iteration. For example, if the course iteration is not instructor led, the trainee may have registered to take it again after completing it.

Values:

Y (the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS
   record reflects the trainee's current registration 
   status with regard to the course iteration)
N (either the registration data in this
   LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the  
   trainee’s latest completion of the course, or the
   trainee has not registered for the course)

An integer (with no decimal places) indicating the number of months in the period from the time when a trainee (USER_REC_ID) completes the course (CO_MAS_ID) to the time when the trainee is due to complete it again. When CURRENT_PERIODICITY is null or 0, if the course is currently required for the trainee, the trainee is required to complete it only once.

Periodicity is irrelevant if the course is optional for the trainee. When CURRENTLY_REQUIRED is 'N', CURRENT_PERIODICITY is null.

See also DATE_COURSE_COMPLETED, LAST_COURSE_COMPLETION_FLAG, CURRENTLY_REQUIRED, DUE_BY_DATE, and COMPLIANT.

Examples: 0, 12

Values:
List of values not available

A Yes/No flag indicating whether or not the course (CO_MAS_ID) is currently required for the trainee (USER_REC_ID). If the course is actively assigned as a mandatory course to a business unit that currently includes the trainee, and the trainee is not grandfathered for the course, CURRENTLY_REQUIRED is 'Y'.

See also COMPLIANT.

Values:
Y (the course is currently a required course for the trainee)
N (the course is currently an optional course for the trainee)

The date when the trainee (USER_REC_ID) completed the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). Note: a trainee may legitimately be on record as having completed the course iteration even if the registration status is not Enrolled.

DATE_COURSE_COMPLETED is null if

• the trainee has not registered for the course, or
• the trainee has completed the course, but is overdue to complete it again.

See also COURSE_COMPLETED, LAST_COURSE_COMPLETION_FLAG, CURRENTLY_REQUIRED, CURRENT_PERIODICITY, DUE_BY_DATE, and COMPLIANT.

Example: 4/11/2007

Values:
List of values not available

The creation date for the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). The value might or might not include the time. See also DATE_REGISTRATION_MODIFIED and DATE_REGISTRATION_DROPPED.

Note: the value for DATE_REGISTRATION_CREATED might not be reliable. For example, some records have a value for DATE_REGISTRATION_CREATED that is later than the value for DATE_REGISTRATION_MODIFIED.

Business Objects hints:

• By default, just the date will appear in your report, but you can change the format of the cell to show just the time, if you so desire.
• To select records that were created on a particular date (say, 7/21/2008), include a query filter stipulating that DATE_REGISTRATION_CREATED is greater than or equal to 7/21/2008 and DATE_REGISTRATION_CREATED is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Example: 5/29/2009

Values:
List of values not available

The date when the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID) had its registration status changed to Dropped. The value might or might not include the time. DATE_REGISTRATION_DROPPED is null if the status was never changed to Dropped. See also REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_DESC, REGISTRATION_STATUS_REASON, DATE_REGISTRATION_CREATED and DATE_REGISTRATION_MODIFIED.

Note:

• DATE_REGISTRATION_DROPPED may have a non-null value even if the registration status is not Dropped. This may be the case if the trainee dropped the course but an instructor overrode the registration status to enroll the trainee or put the trainee on the wait list.
• The value for DATE_REGISTRATION_DROPPED might not be reliable.
  • Some records have a null value for DATE_REGISTRATION_DROPPED even though their registration status is Dropped.
  • Some records have a value for DATE_REGISTRATION_CREATED that is later than the value for DATE_REGISTRATION_DROPPED.

Business Objects hints:

• By default, just the date will appear in your report, but you can change the format of the cell to show just the time, if you so desire.
• To select records that were created on a particular date (say, 7/21/2008), include a query filter stipulating that DATE_REGISTRATION_DROPPED is greater than or equal to 7/21/2008 and DATE_REGISTRATION_DROPPED is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Examples: 8/28/2009; 4/26/2006 10:45:52 AM

Values:
List of values not available

The date when the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID) was last modified. The value might or might not include the time. See also DATE_REGISTRATION_CREATED and DATE_REGISTRATION_DROPPED.

Note: the value for DATE_REGISTRATION_MODIFIED might not be reliable. For example, some records have a value for DATE_REGISTRATION_CREATED that is later than the value for DATE_REGISTRATION_MODIFIED, and some have a value for DATE_REGISTRATION_DROPPED that is later than the value for DATE_REGISTRATION_MODIFIED.

Business Objects hints:

• By default, just the date will appear in your report, but you can change the format of the cell to show just the time, if you so desire.
• To select records that were created on a particular date (say, 7/21/2008), include a query filter stipulating that DATE_REGISTRATION_MODIFIED is greater than or equal to 7/21/2008 and DATE_REGISTRATION_MODIFIED is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Examples: 4/19/2010; 4/26/2006 10:45:52 AM

Values:
List of values not available

The date when the trainee (USER_REC_ID) is next due to complete an iteration of the course (CO_MAS_ID). E_

DUE_BY_DATE is null if any of the following is true:

• No initial due date was specified when the currently required course was assigned, and the trainee has yet to complete an iteration of the course.
• CURRENT_PERIODICITY is null or 0, and the trainee has completed an iteration of the course.
• The course is optional for the trainee.

See also DATE_COURSE_COMPLETED, LAST_COURSE_COMPLETION_FLAG, CURRENTLY_REQUIRED, CURRENT_PERIODICITY, STATUS_DUEDATE_DESCRIPTION, and COMPLIANT.

Example: 10/27/2009

Values:
List of values not available

The given name of the trainee (USER_REC_ID), stored in upper case to facilitate record selection conditions and sorting. See also MIDDLE_INITIAL and LAST_NAME.

The FIRST_NAME is taken from LMS_PERSON.FIRST_NAME where LMS_CURRENT_TRAINEE_CRS_STATUS.USER_REC_ID = LMS_PERSON.USER_REC_ID. Further information about the trainee is available in the LMS_PERSON table.

Example: ABIGAIL

Values:
List of values not available.

The number used within the Knowledge Link system as the unique identifier for the course iteration for which the trainee (USER_REC_ID) has registered per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, ITERATION_ID is null. See also COURSE_MASTER_ID, COURSE_OR_ITERATION_TITLE, COURSE_TITLE_AND_ID, and CO_REC_ID.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. A course version may have more than one course iteration. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

To retrieve the attributes of the course iteration, query the COURSE_ITERATION table where LMS_CURRENT_TRAINEE_CRS_STATUS.ITERATION_ID = COURSE_ITERATION.ITERATION_ID.

Examples: 100856 (PennProfiler-Required Training Assessment-VPR); 13514 (RESIDENCY PHASE II (8&9/04)); 12323 (HIPAA ONLINE EDU - MANAGER EQUIV)

Values:
Refer to the COURSE_ITERATION table for values.
Note:  some of the course iterations in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS records.

A Yes/No flag indicating whether the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the trainee's latest completion information of the course (CO_MAS_ID). If the trainee has not registered for the course, the value of LAST_COURSE_COMPLETION_FLAG is 'N'.

See also CURRENT_COURSE_REG_FLAG, CURRENT_CRS_ITERATION_REG_FLAG LAST_CRS_COMPL_OR_REG_FLAG, REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_DESC, REGISTRATION_STATUS_REASON, WAIT_LIST_PRIORITY, and REG_REC_ID.

Values:
Y (the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS
   record reflects the trainee's latest completion of the
   course)
N (either the registration data in this
   LMS_CURRENT_TRAINEE_CRS_STATUS record reflects the  
   trainee’s latest Enrolled or Wait-Listed registration
   for the course, or the trainee has not registered 
   for the course)

A Yes/No flag indicating that the registration record (REG_REC_ID) reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, the value of LAST_CRS_COMPL_OR_REG_FLAG is 'N'. See also CURRENT_COURSE_REG_FLAG, CURRENT_CRS_ITERATION_REG_FLAG LAST_COURSE_COMPLETION_FLAG, and COMPLIANT.

This is the order of preference for choosing which of a group of registration records for a given trainee and course is the one that reflects the trainee's current compliance status with regard to the course and has LAST_CRS_COMPL_OR_REG_FLAG set to 'Y':

1. If the course is currently required for the trainee, and the trainee is compliant, the record with LAST_COURSE_COMPLETION_FLAG = ‘Y’ has LAST_CRS_COMPL_OR_REG_FLAG set to 'Y'.
2. If the course is currently required for the trainee, and the trainee is not compliant, the record with CURRENT_COURSE_REG_FLAG = ‘Y’ has LAST_CRS_COMPL_OR_REG_FLAG set to 'Y'.
3. If the course is currently optional for the trainee, and there is a record with LAST_COURSE_COMPLETION_FLAG = ‘Y’, it has LAST_CRS_COMPL_OR_REG_FLAG set to 'Y'.
4. If the course is currently optional for the trainee, and there is a record with CURRENT_COURSE_REG_FLAG = ‘Y’, it has LAST_CRS_COMPL_OR_REG_FLAG set to 'Y'.
5. If the group of registration records for the trainee and course does not include a record that was chosen in one of the four steps described above, all of the records in the group have LAST_CRS_COMPL_OR_REG_FLAG set to 'N', and REG_REC_ID is null in the LMS_CURRENT_TRAINEE_CRS_STATUS table.

Values:
Y (the registration data in this LMS_CURRENT_TRAINEE_CRS_STATUS
   record reflects the trainee's current compliance status 
   with regard to the course)
N (there is no registration data on the trainee's current
   compliance status with regard to the course) 

The date and time when this record was extracted from Knowledge Link and loaded into the Data Warehouse.

Business Objects hint: by default, just the date will appear in your report, but you can change the format of the cell to show just the time, if you so desire.

Example: 8/29/2009 3:09:00 AM

Values:
List of values not available.

The surname of the trainee (USER_REC_ID), stored in upper case to facilitate record selection conditions and sorting. See also FIRST_NAME and MIDDLE_INITIAL.

The LAST_NAME is taken from LMS_PERSON.LAST_NAME where LMS_CURRENT_TRAINEE_CRS_STATUS.USER_REC_ID = LMS_PERSON.USER_REC_ID. Further information about the trainee is available in the LMS_PERSON table.

Example: ADAMS

Values:
List of values not available

The first letter of the middle name of the trainee (USER_REC_ID), stored in upper case. The value is null for some trainees. See also FIRST_NAME and LAST_NAME.

Note: although the value of MIDDLE_INITIAL ought to be an upper case letter (if it is not null), it can be a character of any type--for example, '-'.

The MIDDLE_INITIAL is taken from LMS_PERSON.MIDDLE_INITIAL where LMS_CURRENT_TRAINEE_CRS_STATUS.USER_REC_ID = LMS_PERSON.USER_REC_ID. Further information about the trainee is available in the LMS_PERSON table.

Example: S

Values:
List of values not available

This data element currently is not used, even when its value is not null. See
LMS_CURRENT_TRAINEE_CRS_STATUS.DUE_BY_DATE.

A Yes/No flag indicating whether the trainee (USER_REC_ID) is overdue (past due) to complete the course (CO_MAS_ID). See STATUS_DUEDATE_DESCRIPTION and COMPLIANT.

The term "overdue" has no meaning for optional courses. When CURRENTLY_REQUIRED is 'N', OVERDUE is 'N'.

Values:

Y (the course is currently required for the
   trainee, and the trainee is past due to
   complete it)
N (either the course is currently required
   for the trainee and the trainee is not 
   past due to complete id, or the course is
   currently optional for the trainee)

An 8-digit identification number assigned to the trainee by the Penn Community system. No two persons have the same Penn ID. See also USER_REC_ID, FIRST_NAME, MIDDLE_INITIAL, and LAST_NAME.

Most tables in the Data Warehouse use PENN_ID as the unique identifier for a person. This facilitates joining tables with data that pertains to people, regardless of whether those tables are in the same data collection.

Example: 12345678

Values:
Refer to the LMS_PERSON table for values.
Note:  some of the trainees in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A number used within the Knowledge Link system as the unique identifier for the registration record that that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, there is no registration data on the trainee's current compliance status with regard to the course. See LAST_CRS_COMPL_OR_REG_FLAG.

Example: 10143

Refer to the LMS_REGISTRATION table for values.
Note:  some of the trainees in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A string that uniquely identifies the business unit that included the trainee (USER_REC_ID) and had the course version (CO_REC_ID) assigned to it at the time of the creation of the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). See also REGISTRATION_BU_NAME and REGISTRATION_BU_NUMBER.

If REG_REC_ID is null, REGISTRATION_BU_ID is null.

A trainee registers for a course iteration (ITERATION_ID), which is an offering of a particular version (CO_REC_ID) of a course (CO_MAS_ID). A trainee cannot register for an iteration of a course version if that course version does not have an active assignment to a business unit that includes the trainee.

A business unit (also known as a BU, role, Knowledge Node, or K Node) is a set of one or more Knowledge Link users. Business unit X includes a trainee if that trainee is actively assigned to X (see the KNODE_USER_JOIN table) or to a business unit that that falls below X in the business unit hierarchy. (For more information on the business unit hierarchy, see the documentation on PARENT_ID and TYPE in the KNODE table.)

The REGISTRATION_BU_ID is the KNODE.IDENTIFIER where LMS_CURRENT_TRAINEE_CRS_STATUS .REGISTRATION_BU_NUMBER = KNODE.KNODE_ID. For information on how the REGISTRATION_BU_ID value is formatted, see the data element documentation for KNODE.IDENTIFIER.

Examples: 'UP.10001205'; 'UP.0101'; 'HS.BCCD' The value is stored without the surrounding quotes.

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A phrase or string that describes the business unit that included the trainee (USER_REC_ID) and had the course version (CO_REC_ID) assigned to it at the time of the creation of the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). See also REGISTRATION_BU_ID and REGISTRATION_BU_NUMBER.

If REG_REC_ID is null, REGISTRATION_BU_NAME is null.

A trainee registers for a course iteration (ITERATION_ID), which is an offering of a particular version (CO_REC_ID) of a course (CO_MAS_ID). A trainee cannot register for an iteration of a course version if that course version does not have an active assignment to a business unit that includes the trainee.

A business unit (also known as a BU, role, Knowledge Node, or K Node) is a set of one or more Knowledge Link users. Business unit X includes a trainee if that trainee is actively assigned to X (see the KNODE_USER_JOIN table) or to a business unit that that falls below X in the business unit hierarchy. (For more information on the business unit hierarchy, see the documentation on PARENT_ID and TYPE in the KNODE table.)

The REGISTRATION_BU_NAME is the KNODE.NAME where LMS_REGISTRATION.REGISTRATION_BU_NUMBER = KNODE.KNODE_ID. For information on how the REGISTRATION_BU_NAME value is formatted, see the data element documentation for KNODE.NAME.

Examples: 'UP.jsheehan.External Affairs.ASSOC DEAN ADMIN'; 'Anthropology'; 'Billing Compliance (BCCD)' The value is stored without the surrounding quotes.

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A number used to uniquely identify the business unit that included the trainee (USER_REC_ID) and had the course version (CO_REC_ID) assigned to it at the time of the creation of the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). See also REGISTRATION_BU_ID and REGISTRATION_BU_NAME.

If REG_REC_ID is null, REGISTRATION_BU_NUMBER is null.

A trainee registers for a course iteration (ITERATION_ID), which is an offering of a particular version (CO_REC_ID) of a course (CO_MAS_ID). A trainee cannot register for an iteration of a course version if that course version does not have an active assignment to a business unit that includes the trainee.

A business unit (also known as a BU, role, Knowledge Node, or K Node) is a set of one or more Knowledge Link users. Business unit X includes a trainee if that trainee is actively assigned to X (see the KNODE_USER_JOIN table) or to a business unit that that falls below X in the business unit hierarchy. (For more information on the business unit hierarchy, see the documentation on PARENT_ID and TYPE in the KNODE table.)

Examples: 10022, 44239, 61352

Values:
Refer to the KNODE table for values.
Note:  some of the business units in that table
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

A number that uniquely identifies the status of the registration of the trainee (USER_REC_ID) for the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, REGISTRATION_STATUS_CODE is null.

See also REGISTRATION_STATUS_DESC, REGISTRATION_STATUS_REASON, WAIT_LIST_PRIORITY, CURRENT_CRS_ITERATION_REG_FLAG, and CURRENT_COURSE_REG_FLAG.

Values:
39 (Enrolled)
40 (Wait-Listed; applicable to instructor-led
    courses only)
41 (Dropped)

The description of the status of the registration of the trainee (USER_REC_ID) for the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, REGISTRATION_STATUS_DESC is null.

See also REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_REASON, WAIT_LIST_PRIORITY, CURRENT_CRS_ITERATION_REG_FLAG, and CURRENT_COURSE_REG_FLAG.

Values:
Dropped
Enrolled
Wait-Listed (applicable to instructor-led courses only)

Comments about the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, REGISTRATION_STATUS_DESC is null.). See also REGISTRATION_STATUS_CODE, REGISTRATION_STATUS_DESC, WAIT_LIST_PRIORITY, CURRENT_CRS_ITERATION_REG_FLAG, and CURRENT_COURSE_REG_FLAG.

This information is not available for many records. When the value for REGISTRATION_STATUS_REASON is not null, it is stored in mixed case, and may include letters and/or numerals and/or other characters. The comments may describe any characteristic of the registration request (such as how the record for the request was created); they do not necessarily have to do with the registration status.

Note: the value for REGISTRATION_STATUS_REASON might not describe the registration request in its current state. For example, some records have a value for REGISTRATION_STATUS_REASON that begins with 'Completed' but have COURSE_COMPLETED = 'N'.

Examples: 'Dropped for new version'; 'CPR400 Curriculum Enrollment'; 'BCCD Cleanup: Drop Enrollments' The value is stored without the surrounding quotes.

Values:
List of values not available

A phrase describing when the trainee is next due to complete the course. See also DATE_COURSE_COMPLETED, LAST_COURSE_COMPLETION_FLAG, CURRENTLY_REQUIRED, CURRENT_PERIODICITY, DUE_BY_DATE, and COMPLIANT.

STATUS_DUEDATE_DESCRIPTION is null if one of the following is true:

• The course is optional for the trainee.
• No initial due date was specified when the mandatory course was assigned, and the trainee has yet to complete an iteration of the course.

In addition to being one of the factors that determines whether the trainee is compliant with regard to a currently required course, STATUS_DUEDATE_DESCRIPTION also helps to determine whether Knowledge Link sends E-mail Notifications about a course to a trainee.

For more information, see the data element documentation for LMS_TRAINEE_COURSE_ASSIGN.STATUS_DUEDATE_DESCRIPTION.

Values:
[null] (the trainee has no due date for the course) 
Neither Soon Due nor Past Due
Past Due
Soon Due

A string indicating how much time the trainee (USER_REC_ID) has spent on taking the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID). If REG_REC_ID is null, TIME_COURSE_COMPLETED is null.

For instructor-led courses, TIME_COURSE_COMPLETED indicates how much time it took the trainee to complete the course iteration. For Web-based courses, it indicates how much time the trainee has spent on taking the course iteration so far, regardless of whether or not the trainee has completed the course iteration. (The code identifying the distribution mode is the COURSE_OBJECT.DIST_MODE where LMS_CURRENT_TRAINEE_CRS_STATUS.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.)

TIME_COURSE_COMPLETED is null for many records. When it is not null, the value may represent the amount of time in hours (when the value includes a decimal point) or the time in hours, minutes, and seconds (when the value is in the format HH:MM:SS).

Note:

• TIME_COURSE_COMPLETED values may be inconsistent. For example, some records for a particular ITERATION_ID have '0.25' for TIME_COURSE_COMPLETED, while other records for that same course iteration have '.25'.
• In some cases, TIME_COURSE_COMPLETED is null, even though COURSE_COMPLETED is 'Y'.

Examples: '1'; '.25'; '0.75'; '2.0'; '00:00:32'; '00:12:08'; '01:30:00' The value is stored without the surrounding quotes.

Values:
List of values not available

The number used within the Knowledge Link system as the unique identifier for the trainee, who is either currently required to take the course (CO_MAS_ID), or is not currently required to take it but has registered for one its iterations (ITERATION_ID). See also PENN_ID, FIRST_NAME, MIDDLE_INITIAL, and LAST_NAME.

Some tables in the Data Warehouse's Learning Management data collection store data about Knowledge Link users but do not store the users' Penn IDs. USER_REC_ID enables the LMS_CURRENT_TRAINEE_CRS_STATUS table to be joined to those tables.

Further information about the trainee is available in the LMS_PERSON table where LMS_CURRENT_TRAINEE_CRS_STATUS.USER_REC_ID = LMS_PERSON.USER_REC_ID.

Example: 10159

Values:
Refer to the LMS_PERSON table or the 
  GEN21_USER table for values.
Note:  some of the trainees in those tables
have no associated LMS_CURRENT_TRAINEE_CRS_STATUS
records.

When the trainee (USER_REC_ID) is Wait-Listed for the course iteration (ITERATION_ID) per the registration record (REG_REC_ID) that reflects the trainee's current compliance status with regard to the course (CO_MAS_ID), the number stored in WAIT_LIST_PRIORITY indicates what priority the trainee has for becoming enrolled in the course iteration if another trainee drops it. If WAIT_LIST_PRIORITY = 0, the trainee will become enrolled the next time someone drops the course iteration. See also REGISTRATION_STATUS_DESC.

If REG_REC_ID is null, WAIT_LIST_PRIORITY is null.

Note:

• Wait lists are kept only for instructor-led courses. (The code identifying the distribution mode is the COURSE_OBJECT.DIST_MODE where LMS_CURRENT_TRAINEE_CRS_STATUS.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.)
• In some records, WAIT_LIST_PRIORITY is null even though the registration status is Wait-Listed.
• In some records, WAIT_LIST_PRIORITY is not null even though the registration status is not Wait-Listed.

Examples: 0, 9

Values:
List of values not available