• ALLOW_WAIT_LIST
• CAPACITY
• CERT_ISSUED
• CO_REC_ID
• DATE_CREATED
• DATE_MODIFIED
• DAYS_OF_WEEK
• DESCRIPTION
• DIST_MODE
• END_DATE
• END_TIME
• ENROLL_COUNT
• ENROLL_URL
• ENROLLMENT_CAT
• EXP_COMMENT
• FAC_EXP
• INSTR_EXP
• IS_LATEST_ITER
• ITERATION_ID
• ITERATION_XREF
• KNODE_ID
• LANG_ID
• LANG_NAME

• LAST_DROP_DATE
• LAST_ENROLL_DATE
• LOCATION_ID
• MAX_STUDENT
• MIN_STUDENT
• NAME
• OTHER_EXP
• PASSING_SCORE
• PERFORMANCE_TEST
• REMARKS
• REMINDER_DAYS
• RES_EXP
• SKILLSOFT_ID
• START_DATE
• START_TIME
• STATUS
• TERM_DEF_ID
• THRESHOLD_SCORE
• TIME_ZONE
• URL
• WL_ACTIVE
• XACCESS

A one digit number indicating whether the course iteration can have a wait list once the maximum number of enrolled trainees has been reached. See also MAX_STUDENT and WL_ACTIVE.

If ALLOW_WAIT_LIST is 1 (the default value), when a trainee attempts to register for the course iteration after it has reached its maximum number of enrolled trainees, Knowledge Link displays a message asking whether the trainee agrees to be added to the wait list. If the trainee agrees, that trainee's registration record for the course iteration will have a status of Wait-Listed (rather than Enrolled). If the trainee disagrees, no registration record is created.

If ALLOW_WAIT_LIST is 0, no additional trainees can register for the course iteration once its maximum number of enrolled trainees has been reached. When a trainee attempts to register for the course iteration after it has reached its maximum number of enrolled trainees, Knowledge Link displays a message explaining that the class is full. No registration record is created.

Note that a Knowledge Link Administrator or Junior Administrator can use the forced enrollment feature to register a trainee for a course iteration regardless of how its ALLOW_WAIT_LIST is set.

ALLOW_WAIT_LIST affects the course registration process only for instructor led training; it is irrelevant for Web-based training, even when its value is not null. In some cases, ALLOW_WAIT_LIST for a Web-based course iteration has been set to a non-null value via the Knowledge Link Gradebook facility, but it has no functional consequence. ALLOW_WAIT_LIST can be set via the Knowledge Link Gradebook facility, or by using the check box on the Course Iteration Details page.

Values:
1 (the course iteration can have a wait list)
0 (the course iteration cannot have a wait list)

If the course iteration is held at a specified location, this number reflects the location's seating capacity at the time the course iteration record was created. (If the course iteration has no location information, CAPACITY is 0 or null.) See also LOCATION_ID and MAX_STUDENT.

Example: 58

Values:
List of values not available

This data element currently is not used.

A number used to identify the version of the course that is offered via the course iteration. CO_REC_ID uniquely identifies the course version within the Knowledge Link system. Further information on the course version is available in the COURSE_OBJECT table where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.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 a session 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 course iteration per version.

Example: 10142

Values:
Refer to the COURSE_OBJECT table for values.

DATE_CREATED

Indexed - no
Format - date
May be null? yes

The date when the COURSE_ITERATION record was created in Knowledge Link. The value of DATE_CREATED may or may not include the time. See also DATE_MODIFIED.

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. To select records for a particular date (say, 7/21/2008), set your query conditions to DATE_CREATED is greater than or equal to 7/21/2008 and DATE_CREATED is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Examples: 1/24/2008; 1/31/2008 2:13:01 PM

Values:
List of values not available

The date when the COURSE_ITERATION record was last updated in Knowledge Link. See also DATE_CREATED.

Examples: 2/14/2008

Values:
List of values not available

A number that indicates what day(s) of the week are the class meeting dates for the course iteration. DAYS_OF_WEEK is used together with START_DATE and END_DATE to determine the dates listed on Knowledge Link's class schedule detail page when a trainee registers for the course iteration.

Each day of the week has a unique value for DAYS_OF_WEEK. If a course iteration will have class meetings on more than one day of the week, DAYS_OF_WEEK is equal to the sum of the values for those days. DAYS_OF_WEEK may be null or 0 if the course iteration will meet every day from the START_DATE through the END_DATE, or if the course iteration is Web-based and may be taken on any day from the START_DATE through the END_DATE.

For example, if a course iteration has a START_DATE of May 5, 2008 (a Monday), an END_DATE of May 9, 2008 (a Friday), and DAYS_OF_WEEK set to 42 (32 + 8 + 2), the class schedule detail for the course iteration will show that the meeting dates are May 5, 7, and 9, 2008 (Monday, Wednesday, and Friday)..

Note: DAYS_OF_WEEK cannot be decoded using the LMS_DEFINITION table.

Examples: 64 (Sunday), 32 (Monday), 16 (Tuesday), 8 (Wednesday), 4 (Thursday), 2 (Friday), 1 (Saturday), 40 (32 + 8; Monday and Wednesday)

Values:
List of values not available

Text (often a few sentences) describing the content of the course iteration and the target audience.

The DESCRIPTION may be stored in upper case, lower case, or mixed case. Some course iterations have no description--their value for DESCRIPTION is null. It is common for more than one course iteration to have the same value for DESCRIPTION.

See also NAME and ITERATION_ID.

Example: 'University Human Resource representative discusses how to give Performance Appraisals. For SOM SUPERVISORS.' The value is stored without the surrounding quotes.

Values:
List of values not available

This data element currently is not used, even when its value is not null. DIST_MODE refers to the way the course content is delivered to the trainees (for example, in a Web-based or instructor led format). For information on the course iteration's distribution mode, see COURSE_OBJECT.DIST_MODE where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.

The date when the course iteration ends. For instructor led courses, this is the date of the course iteration's last class meeting. For Web-based courses, this is the last day when trainees can access the course iteration's content. See also START_DATE, START_TIME, END_TIME, and TIME_ZONE.

END_DATE may be null if the course iteration is not active. See also STATUS.

The value of END_DATE may or may not include the time. 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. To select records for a particular date (say, 7/21/2008), set your query conditions to END_DATE is greater than or equal to 7/21/2008 and END_DATE is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Examples: 2/15/2008; 6/1/2008 4:18:31 PM

Values:
List of values not available

A text string (in the format HH:MM:XM) indicating the time of day when the course iteration ends. The value of END_TIME is often null (regardless of the status of the course iteration). See also START_DATE, START_TIME, END_DATE, and TIME_ZONE.

For instructor led courses, END_TIME is the time when the course iteration's last class meeting ends. For Web-based courses, trainees cannot access the course iteration's content or pass the test after the END_TIME on the END_DATE.

Examples: ‘11:00:AM’; ‘04:30:PM’ The value is stored without the surrounding quotes.

Values:
List of values not available

The number of trainees enrolled in the course iteration. The value is often null.

Example: 13

Values:
List of values not available

A text string that is displayed as the Class Information URL on the Enrollment Confirmation page (or the Wait List Confirmation page) when a trainee registers for the course iteration, if it is an iteration of instructor led training. (A URL is a Uniform or Universal Resource Locator, the Internet address for a file or Web page.) The value for ENROLL_URL may be null.

The value for ENROLL_URL is entered on the Course Iteration Details page in the Class Information URL field, which does not require the value to be a valid address for a Web page. ENROLL_URL is displayed to trainees only for iterations of instructor led training; it is irrelevant for Web-based training, even when its value is not null.

Example: http://www.med.upenn.edu/penn/ohr/crc.shtml’ The value is stored without the surrounding quotes.

Values:
List of values not available

This data element currently is not used.

Notes regarding expenses associated with the course iteration. EXP_COMMENT is null for most course iterations, because most training providers do not use Knowledge Link to track their training costs. In the few cases where it is not null, the value for EXP_COMMENT is stored in mixed case, and may include special characters. See also INSTR_EXP, RES_EXP, and OTHER_EXP.

Example: ‘No-show, late drop, or frequent changes may incur a fee.’ The value is stored without the surrounding quotes.

Values:
List of values not available

This data element currently is not used.

A number indicating the costs associated with the instructor for the course iteration. INSTR_EXP is null for most course iterations, because most training providers do not use Knowledge Link to track their training costs.

Example: 43000

Values:
0 to 9,999,999,999

A one digit number used for Web-based training, to indicate whether the course iteration is the course version’s most recently created iteration. For a given course version (CO_REC_ID), the iteration with the highest ITERATION_ID is the one that has IS_LATEST_ITER set to 1; other iterations have IS_LATEST_ITER set to 0.

Knowledge Link uses IS_LATEST_ITER to determine how course iterations are displayed for Web-based courses. For example, if a trainee is registering for an optional Web-based course, and more than one iteration of that course is currently active, only the most recently created iteration is shown on the Optional Training screen.

Note: IS_LATEST_ITERATION is irrelevant for iterations of instructor led training, even when its value is not null.

Values:
1 (this is the course version’s most recently created iteration)
0 (this is not the course version’s most recently created iteration)

A number used within the Knowledge Link system as the unique identifier for the course iteration. The COURSE_ITERATION table has one record per course iteration. See also NAME and DESCRIPTION.

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. (See CO_REC_ID. Information on course versions is available in the COURSE_OBJECT table.)

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.

Example: 10843

Values:
Refer to the COURSE_ITERATION table for values.

A character string used within the Knowledge Link Gradebook facility as the unique identifier for the course iteration. When registration records for a given course iteration are loaded into Knowledge Link via the Gradebook, each record in the Gradebook spreadsheet specifies that course iteration’s ITERATION_XREF. The Gradebook facility uses the ITERATION_XREF to look up the ITERATION_ID that is specified in the registration record in Knowledge Link.

A course iteration’s ITERATION_XREF value is entered by the course administrator on the Course Iteration Details page in the Knowledge Link Manager.

Examples: ‘0000032502’, ‘SCM111030920061800SpruceB’, ‘new spccp’ The value is stored without the surrounding quotes.

Values:
List of values not available

This data element currently is not used, even when its value is not null. See COURSE_OBJECT.KNODE_ID where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.

A numeric code that indicates the language in which the course iteration is offered. As of this writing, all course iterations are offered in English; LANG_ID is 29.

The description for LANGUAGE is LMS_DEFINITION.NAME where COURSE_ITERATION.LANG_ID = LMS_DEFINITION.DEF_ID.

Example: 29 (US English)

Values:
List of values not available

This data element currently is not used.

The last day when a trainee who has registered for the course iteration can drop it.

LAST_DROP_DATE affects the course registration process only for instructor led training; it is irrelevant for Web-based training, even when its value is not null. In some cases, LAST_DROP_DATE for a Web-based course iteration has been set to a non-null value via the Knowledge Link Gradebook facility, but it has no functional consequence. For iterations of instructor led training, LAST_DROP_DATE can be entered via either the Knowledge Link Gradebook facility or the Course Iteration Details page.

See also LAST_ENROLL_DATE.

Example: 2/15/2008

Values:
List of values not available

The last day when a trainee can register for the course iteration via the Knowledge Link Navigator. Note that a Knowledge Link Administrator or Junior Administrator can use the forced enrollment feature to register a trainee for a course iteration regardless of how its LAST_ENROLL_DATE is set. Also, if a trainee is waitlisted for a course iteration, and an enrolled trainee drops it after its LAST_ENROLL_DATE, the waitlisted trainee will become enrolled.

LAST_ENROLL_DATE affects the course registration process only for instructor led training; it is irrelevant for Web-based training, even when its value is not null. In some cases, LAST_ENROLL_DATE for a Web-based course iteration has been set to a non-null value via the Knowledge Link Gradebook facility, but it has no functional consequence. For iterations of instructor led training, LAST_ENROLL_DATE can be entered via either the Knowledge Link Gradebook facility or the Course Iteration Details page.

See also LAST_DROP_DATE.

Example: 1/23/2008

Values:
List of values not available

A number that uniquely identifies the place where the course iteration's class meetings (if any) will be held. (Web-based courses, for example, have no location--their value for LOCATION_ID is null.)

Information on the location is available in the LMS_LOCATION table where COURSE_ITERATION.LOCATION_ID = LMS_LOCATION.LOCATION_ID

Example: 10280

Values:
Refer to the LMS_LOCATION table for values.

The maximum number of trainees that can enroll in the course iteration. If the course iteration is held at a specified location, the default value for MAX_STUDENT may reflect the location's seating capacity at the time the course iteration record was created. However, MAX_STUDENT is set by the course administrator and can have any value, even one that is greater than the location's seating capacity. See also LOCATION_ID, CAPACITY, MIN_STUDENT, ALLOW_WAIT_LIST, and WL_ACTIVE.

Example: 40

Values:
List of values not available

The minimum number of trainees that must enroll in the course iteration to prevent it from being cancelled. The default value is 0. See also MAX_STUDENT.

Example: 4

Values:
List of values not available

The title of the course iteration.

The NAME may be stored in upper case, lower case, or mixed case. Some course iterations have no title--their value for NAME is null.

It is common for more than one course iteration to have the same value for NAME.

The NAME of a course iteration might or might not be the same as the title of the course version that is offered in the course iteration.

See also DESCRIPTION and ITERATION_ID.

Example: 'Performance Appraisals: Supervisor SOM' The value is stored without the surrounding quotes.

Values:
List of values not available

A number indicating the miscellaneous costs associated with the course iteration. OTHER_EXP is null for most course iterations, because most training providers do not use Knowledge Link to track their training costs.

Example: 2000

Values:
0 – 9,999,999,999

A number that represents the score the trainee must achieve to pass the course assessment. A passing score may be required in order to receive course credit.

The default value for the passing score for a course iteration is the value of the passing score for its parent course version (COURSE_OBJECT.PASSING_SCORE where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID). However, a course iteration’s passing score can be set to a different value. For example, for Web-based courses loaded by the TOC-SCORM API, the passing score is set for the embedded “testable SCO” at the course iteration level to the value sent in the SCORM manifest file, which may be a value that is different from the passing score for the iteration’s parent course version.

Examples: 0, 80, 100

Values:
List of values not available

This data element currently is not used.

Notes regarding the course iteration. The value of REMARKS may be null.

REMARKS can be entered via the Knowledge Link Gradebook facility. Currently, REMARKS is used only for some UPHS courses, and is usually a UPHS entity code or an abbreviation for another UPHS group. For more information on UPHS entity codes, see the documentation for CUSTOM_V2 in the KNODE table.

Examples: ‘CORP’, ‘PMC’ The value is stored without the surrounding quotes.

Values:
List of values not available

The number of days before the START_DATE when a message is e-mailed to trainees that have enrolled in the course iteration, to remind them that they are expected to attend. If REMINDER_DAYS is 0, no reminder is sent.

Knowledge Link’s reminder e-mail feature is independent of its E-mail Notifications feature. The reminder is e-mailed to the trainee regardless of whether the course is required or optional for the trainee, and regardless of how the course version’s NOTIFICATION parameter is set.

Because reminders are e-mailed only to trainees enrolled in instructor led training, REMINDER_DAYS is irrelevant for Web-based training, even when its value is not null. In some cases, REMINDER_DAYS for a Web-based course iteration has been set to a non-null value via the Knowledge Link Gradebook facility, but it has no functional consequence. For iterations of instructor led training, REMINDER_DAYS can be entered via either the Knowledge Link Gradebook facility or the Course Iteration Details page.

Example: 2

Values:
List of values not available

A number indicating the costs associated with the classroom resources for the course iteration. (Classroom resources might include a microphone, a projector, or other equipment, facilities, or supplies.) RES_EXP is null for most course iterations, because most training providers do not use Knowledge Link to track their training costs.

Example: 60000

Values:
0 to 9,999,999

This data element currently is not used.

The date when the course iteration begins. For instructor led courses, this is the date of the course iteration's first class meeting. For Web-based courses, this is the first day when trainees can access the course iteration's content. See also START_TIME, END_DATE, END_TIME, and TIME_ZONE.

START_DATE may be null if the course iteration is not active. See also STATUS.

The value of START_DATE may or may not include the time. 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. To select records for a particular date (say, 7/21/2008), set your query conditions to START_DATE is greater than or equal to 7/21/2008 and START_DATE is less than 7/22/2008. (The system will supply the time--12:00:00 AM--for both dates.)

Examples: 2/15/2008; 8/15/2007 10:52:57 AM

Values:
List of values not available

A text string (in the format HH:MM:XM) indicating the time of day when the course iteration begins. The value of START_TIME is often null (regardless of the status of the course iteration). See also START_DATE, END_DATE, END_TIME, and TIME_ZONE.

For instructor led courses, START_TIME is the time when the course iteration's first class meeting begins. For Web-based courses, trainees cannot access the course iteration's content or pass the test before the START_TIME on the START_DATE.

Examples: ‘10:00:AM’; ‘01:30:PM’ The value is stored without the surrounding quotes.

Values:
List of values not available

A numeric code that denotes the status of the course iteration. A trainee can register for the course iteration only if its status is active (50).

To display the description of the status (rather than its numeric code), use the LMS_DEFINITION.NAME where COURSE_ITERATION.STATUS = LMS_DEFINITION.DEF_ID.

Values:
 50 (Active--trainees can register for the course
     iteration; the end date has not passed;
     for instructor-led courses, the start
     date also has not passed)
 51 (Closed--the course iteration has been 
     held; its end date has passed;
     for instructor-led courses, the start
     date has passed)
 52 (Cancelled--the course iteration was not
     held, or will not be held)
124 (Under Construction--the course iteration 
     is not in Active status because its 
     record is missing some required 
     information)
442 (Preview--the course iteration is for a 
     Web based course that was created with
     the assembler, and it is not in Active 
     status because it is to be reviewed by 
     someone with the Reviewer role)

This data element currently is not used.

This data element currently is not used, even when its value is not null or 0. It is a property of Knowledge Link Assembler courses that are not available on Penn’s Knowledge Link system at this time.

Text describing the time zone for the START_TIME and END_TIME. In other words, the TIME_ZONE is the geographic region where the START_TIME and END_TIME values reflect the local time. The value of TIME_ZONE is often null (regardless of the status of the course iteration). See also START_TIME and END_TIME.

Example: ‘US/Eastern’ The value is stored without the surrounding quotes.

Values:
List of values not available

A text string containing the URL (if any) for the Web page that it is opened when a Web-based course iteration is launched. (A URL is a Uniform or Universal Resource Locator, the Internet address for a file or Web page.) The value for URL may be null.

The default value for the URL for a course iteration is the value of the CO_BASE_URL for its parent course version (COURSE_OBJECT.CO_BASE_URL where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID). A Knowledge Link Administrator or Junior Administrator can set the course iteration’s URL to a different value in the Knowledge Link Manager. However, URL is pertinent for Web-based training only; it is irrelevant for instructor led training, even when its value is not null

Example: ‘http://www.ehrs.upenn.edu/training/onlinetrain.html’ The value is stored without the surrounding quotes.

Values:
List of values not available

A one digit number indicating whether the course iteration’s wait list is active. If the course iteration can have a wait list, WL_ACTIVE is set to 1 (active) when the course iteration has reached its maximum number of enrolled trainees. See also ALLOW_WAIT_LIST and MAX_STUDENT.

If the course iteration’s wait list is active, when an enrolled trainee drops out of the course iteration, the first trainee on the wait list becomes enrolled. That trainee's registration record for the course iteration has its status changed from Wait-Listed to Enrolled, and Knowledge Link informs the newly enrolled trainee via e-mail about this change in registration status.

If the course iteration can have a wait list, and that wait list is inactive (WL_ACTIVE = 0), the number of trainees enrolled in the course iteration is below the maximum (MAX_STUDENT).

Note that a Knowledge Link Administrator or Junior Administrator can use the forced enrollment feature to register a trainee for a course iteration regardless of how its WL_ACTIVE is set.

WL_ACTIVE affects the course registration process only for instructor led training; it is irrelevant for Web-based training, even when its value is not null.

Values:
1 (the course iteration’s wait list is active)
0 (the course iteration’s wait list is inactive)

This data element currently is not used, even when its value is not null. See COURSE_OBJECT.XACCESS where COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.