Previous Topic

Next Topic

Sessions Template

Use the Sessions Template to upload session records quickly and easily. The table below shows the correct data format for each field in the template.

Field Name

Format

Session ID

Field is required. Field must be less than or equal to 50 characters.

Status

Field is required. Field must be one of the following:

  • Unconfirmed
  • Confirmed
  • Completed
  • Canceled

Facility ID

Field is optional. Field must match an existing facility.

Classroom ID

Field is optional. Field must match an existing classroom or one in the classroom upload file.

Course ID

Field is required. Field must match an existing course or one in the course upload file.

Capacity

Field is required. Field must be in the range 0-99999.

Instructor User Name

Field is optional. Field must match an existing instructor.

Time Zone

Field is required. Use the drop down to select the desired time zone.

Contact ID

Field is optional. Field must match an existing contact.

Notes

Field is optional. Field must be less than or equal to 2500 characters.

Schedule Time

Field is required. Field must be of the format mm/dd/yyyy hh:mm (for example, 10/12/1972 13:54).

Duration

Field is required. Field must be a valid float in range 0.0-24.0.

Session Administrator 1 User Name

Field is optional. Field must match an existing session administrator.

Session Administrator 2 User Name

Field is optional. Field must match an existing session administrator.

Session Administrator 3 User Name

Field is optional. Field must match an existing session administrator.

Manager Approval Required

Field is required. Field must be either 0 or 1.

  • 0 - Not required
  • 1 - Required

Session Approval Required

Field is required. Field must be either 0 or 1.

  • 0 - Not required
  • 1 - Required

Session Approver User Name

Field is required if Session Approval Required has value 1. Field must match an existing session approver.

Instructor Can Manage Roster

Field is required. Field must be either 0 or 1.

  • 0 - Not required
  • 1 - Required

Type

Field is optional. Field must be :

  • 0 for Physical Classroom, or
  • 1 for Dialogue Live, or
  • 2 for Other

Phone

Field is optional. Field must be less than or equal to 50 characters.

Alt Phone

Field is optional. Field must be less than or equal to 50 characters.

Passcode

Field is optional. Field must be less than or equal to 20 characters.

URL

Field is optional. Field must be less than or equal to 255 characters.

Open to Enrollment

Field is required. Field must be either 0 or 1.

  • 0 - closed to enrollment
  • 1 - open to enrollment

Close Session (days before/after session start)

Field is optional. Field must be in range {-90 -60 -45 (-30.0 to 30.0) 45 60 90}.

Prohibit Self-Withdrawal (days before session start)

Field is optional and can be one of the following:

  • leave blank (renders a value of Never)
  • always
  • a number from 1 to 31

Late Withdrawal (days before session start)

Field is optional and can be one of the following:

  • leave blank (renders a value of Never)
  • a number from 1 to 31

Minimum Enrollment

Field is optional. Field must be in range 0-99999.

Low Enrollment Alert (days before session start)

Field is optional. Field must be (never) or from 0 to 31.

san1

Field is required. Field must match an existing item in the extended attribute list.

san2

Field is required. Field must be less than or equal to 250 characters.

san3

Field is required. Field must match an existing item in the extended attribute list.

2

Field is optional. Field must match an existing item in the extended attribute list.