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.