Table of Contents

COURSES INTERFACE FILE#

The Courses Interface File screen is used to import a list of courses.

Courses Interface File data is maintained on the INF_CV_COURSES table.


ID
This field uniquely identifies the course within the data base.
Course
This field identifies the courses included in the interface file.
Competence Group
The competence group associated with the course is defined in this field.
Course Status
The status of the course is displayed in this field.
Supplier
The course supplier is defined in this field.
Assessment Tested
This field identifies the test assessment associated with this course.
Assessment Surveyed
This field identifies the survey assessment associated with this course.
Approved
Course Type
The course type is defined in this field.
Course Category
The course category is defined in this field.
Course Title
The course title is defined in this field.
Font HTML
This field defines the font HTML for the web component
External Course ID
If the course is external, this field provides the course identifier.
Start Date of Course / Course to End On
These field identify the days the course starts and ends.
Starting Day
This field identifies the day of the week that the course will begin.
Duration
The duration of the course is displayed in this field.
Duration Basis
The time basis of the duration is displayed in this field.
Course Format
This field identifies the teaching format of the course.
Candidate
Repeat Basis
If this course needs to be retaken on a regular basis, that interval is defined in this field.
Sponsor
This field identifies the individual or position advocating this course.

Notes #

Few things need clearing up:

'Approved' - what text is supposed to go there? The person who approved it? This field is a text field, but the associated field parameter is a toggle field.

'Repeat Basis' - I've written the definition that goes with 'Repeat Interval' because there is no 'Repeat Inteval' field here. To just give a definition of the repeat basis (yearly, monthly) would make no sense.

'Candidate' - I can't find this field in INF_CV_COURSES page or in the IMCD screen, only 'Language'.