Event Template and Validations

Learning Loads Deprecation: Ability to perform learning data loads using Data Load Wizard will be deprecated with and end-of-life in the February '21 Release. Edge Import replaces this functionality. For more information on learning loads deprecation, See Learning Data Load Overview. For information about Edge Import, See Edge Import Homepage.

The Event template contains all of the fields that can be loaded via the Data Load Wizard. Note: Vendors and Event IDs cannot be modified via the Data Load Wizard.

The Event template contains the following data fields:

Properties Event Section

Each of these fields relates to a field on the Properties page when creating or editing an event. See ILT Event - Create - Step 1 - Properties.

System Field Type Limit Comments/Rules
Event Name String 500  
LO Reference Number String 100

This is set by the administrator and is used to reference the event that is being loaded into the system. Ref IDs are not displayed within the system and must be tracked by the administrator in order to reference the data in the future. This field supports up to 100 alphanumeric characters. This field is required.

  • When loading new events, a unique Ref ID must specified.
  • When updating existing events, the Ref ID for the data that is being loaded must match the Ref ID for the existing data.
  • Data that is manually created in the system cannot be updated using the Data Load Wizard because this data does not have a Ref ID.
Culture ID String 10 This determines in which culture (language) the event is loaded. This value must match one of the existing Culture IDs within the system. This defaults to the Culture ID of the administrator who is performing the data load.
Event Number String 100  
Vendor (Provider) String 100 This is required and must match an existing vendor within the system. Vendors cannot be modified via the Data Load Wizard.
Training Hours String 10 This should be entered in the following format: HHHH:MM
Description String 2000 This supports HTML text.
Objectives String 4000 This supports HTML text.
Default Language String 400 This must be one of the known languages in the Culture table. This is only used if multiple languages are enabled for the portal.
Available Language Enumerated List 400 This is a semicolon separated list of languages. Each language must be one of the known languages in the Culture table. This is only used if multiple languages are enabled for the portal.
Subjects String 100 This is required and must match existing active subjects within the system.
Competencies String 500 This must contain the Ref IDs for existing competencies within the system.
Skills String 3950 This can contain one or more skills separated by a semicolon.
Active Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. An event can be made inactive even if it has active sessions.
Allow Multiple Users Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Allow Interest Tracking Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Allow Users to Select Sessions   50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Keywords String 1000  
Training Contact String 100 This field is required. This is the User ID of the training contact. This must be a valid User ID that is associated with an existing active or inactive user within the system.

Availability Event Section

Each of these fields relates to a field on the Availability page when creating or editing an event. See ILT Event - Create - Step 2 - Availability.

System Field Type Limit Comments/Rules
Availability to All Users Boolean   Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. This determines whether the event is available to all users.

Pricing Event Section

Each of these fields relates to a field on the Pricing page when creating or editing an event. See ILT Event - Create - Step 3 - Pricing.

System Field Type Limit Comments/Rules
Default Price Integer 9 This must be less than 500000000. This field defaults to 0.
Default Price Currency Enumerated List   This is required when a default price is set. This must be a valid currency ID.

Session Defaults Event Section

Each of these fields relates to a field on the Session Defaults page when creating or editing an event. See ILT Event - Create - Step 5 - Session Defaults.

System Field Type Limit Comments/Rules
Registration Deadline Integer 3 This is required if the Registration Deadline - Days/Hours or Registration Deadline - Before or After fields are provided.
Registration Deadline - Days/Hours String 100 This must be set to either Days or Hours. This is required if the Registration Deadline or Registration Deadline - Before or After fields are provided.
Registration Deadline - Before or After String 100 This must be set to either Before or After. This is required if the Registration Deadline or Registration Deadline - Days/Hours fields are provided.
Minimum Registration Integer 10  
Maximum Registration Integer 10  
Enrollment String 100 This must be set to either Place Restrictions or Manage Restrictions. This defaults to None if left empty.
Allow Waitlist for Sessions Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. This must be set to True if the Allow Auto-Management of Waitlist field is provided.
Allow Auto-Management of Waitlist String 100 This must be set to either Time based or First come first served.
Auto-Register User upon Granting Waitlist Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Waitlist Deadline to Register Integer 9  
Waitlist Deadline Expiration Integer 9  
Refund Percentage Integer 3 This is required if the Refund Type or Number of days prior to start fields are provided.
Refund Amount Integer   This is required if the Refund Type or Number of days prior to start fields are provided.
Refund Type String   This must be set to either Monetary or Training Unit. This is required if the Refund Amount, Refund Percentage, or Number of days prior to start fields are provided.
Number of days prior to start Integer 2 This is required if the Refund Amount or Refund Percentage fields are provided.
No Show Penalty - Money Integer 8  
No Show Penalty - Training Units Integer 8  
Restrict Withdrawal from Session Boolean 50 Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Preferred Instructors String   This is the User ID of the preferred instructors. Multiple IDs should be separated by a semi-colon. This must be a valid User ID that is associated with an existing active or inactive internal instructor. The instructors should be valid instructors for the session vendor/provider. External instructors are not supported in the Data Load Wizard.
Ability to Select Sessions - End Users Text 50 This field is optional. The field only accepts Boolean values (i.e., True, False, T, F, Yes, No, Y, N, Active, Inactive). If no value is provided, then this field defaults to True. When the Ability to Select Sessions - Admins and Managers field is set to False, then this field must be set to True.
Ability to Select Sessions - Admins and Managers Text 50 This field is optional. The field only accepts Boolean values (i.e., True, False, T, F, Yes, No, Y, N, Active, Inactive). If no value is provided, then this field defaults to True. When the Ability to Select Sessions - End Users field is set to False, then this field must be set to True.

Learning Object Identifier Auto-generation Rules

When the course code functionality is enabled and activated for the portal, then events and sessions that are loaded via the Data Load Wizard are automatically assigned a system-generated course code.

When the course code functionality is disabled or not activated for the portal, then events and sessions that are loaded via the Data Load Wizard are not assigned a course code. However, the learning object (LO) is always assigned a LO ID.