FIELD NAME LEN TYPE
courses element attributes
ID_PARENT_PROVIDER 9 NUMBER
UPLOAD_KEY 9 NUMBER
ID_PROVIDER 9 NUMBER
You can use either PROVIDER_COURSE_CODE or ID_COURSE to identify the course to be publis
PROVIDER_COURSE_CODE 80 VARCHAR2
ID_COURSE 9 NUMBER
ID_PUBLISHING 9 NUMBER
IN_HOUSE 1 NUMBER
DT_START DATE
DT_END DATE
TM_START DATE
TM_END DATE
DS_REGISTRATION_WEBSITE 255 VARCHAR2
AM_PRICE (5,2) NUMBER
This element is optional to Anytime Courses
ID_LOCATION 9 NUMBER
MONDAY 1 CHAR
TUESDAY 1 CHAR
WEDNESDAY 1 CHAR
THURSDAY 1 CHAR
FRIDAY 1 CHAR
SATURDAY 1 CHAR
SUNDAY 1 CHAR
This element is optional, only is necessary if lunch break if desired.
DT_MEAL_BEG DATE
DT_MEAL_END DATE
COMMENTS
Provider Parent Id.
This is the CE Broker Provider Tracking # (without the 50-, only the last numbers after the hyphen)
either PROVIDER_COURSE_CODE or ID_COURSE to identify the course to be published.
According to the Provider internal Course Code
This is the CE Broker Course Tracking # (without the 20-, only the last numbers after the hyphen)
This is the identifier for an existing publishing
If this publishing will be available only to your own company's employees IN_HOUSE = 1, otherwise IN_HOUSE = 0.
Start Date in format MM/DD/YYYY - (not applicable to "anytime courses"-data will not be utilized even if it is sent)
End Date in format MM/DD/YYYY - (not applicable to "anytime courses"-data will not be utilized even if it is sent)
Start Time in format HH:MI - (not applicable to "anytime courses"-data will not be utilized even if it is sent)
End Time in format HH:MI - (not applicable to "anytime courses"-data will not be utilized even if it is sent)
Registration website URL
Course Price
is optional to Anytime Courses
This is the CE Broker Location Tracking # (without the 40-, only the last numbers after the hyphen).
When the course has session on Monday, this element takes a value = 1, if not value = 0.
When the course has session onTuesday, this element takes a value = 1, if not value = 0.
When the course has session on Wednesday, this element takes a value = 1, if not value = 0.
When the course has session on Thursday, this element takes a value = 1, if not value = 0.
When the course has session on Friday, this element takes a value = 1, if not value = 0.
When the course has session on Saturday, this element takes a value = 1, if not value = 0.
When the course has session on Sunday, this element takes a value = 1, if not value = 0.
is optional, only is necessary if lunch break if desired.
Date in format HH:MI -(not applicable to "anytime courses"-data will not be utilized even if it is sent)
Date in format HH:MI -(not applicable to "anytime courses"-data will not be utilized even if it is sent)
N_HOUSE = 0.