INF_CV_CLASSSCHEDULES
Back to current versionRestore this version

Alias: IVCRSC#

(INF_CV_CLASSSCHEDULES)
Class Schedules

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
COURSE_CODEVarchar2(16)Y
CLASS_CODEVarchar2(16)Y
CLASS_STATUSVarchar2(30)Y
LOCATION_CODEVarchar2(16)
USER_NAMEVarchar2(30)
FIRST_NAMEVarchar2(50)
LAST_NAMEVarchar2(50)
RELATIONVarchar2(30)
EMPLOYERVarchar2(50)
APPROVEDVarchar2(4)
CLASS_TITLEVarchar2(50)
FONT_HTMLVarchar2(2000)
ENROLLMENT_START_DATEDate()
ENROLLMENT_END_DATEDate()
EXTERNAL_CLASS_IDVarchar2(16)
CLASS_START_DATEDate()
CLASS_END_DATEDate()
DURATIONNumber(9)
DURATION_BASISVarchar2(30)
COURSE_FORMATVarchar2(30)
LANGUAGE_CODEVarchar2(30)
MINIMUM_SIZENumber(5)
MAXIMUM_SIZENumber(5)
IDEAL_SIZENumber(5)
BUDGETED_COSTNumber(18)
ACTUAL_COSTNumber(18)
CURRENCYVarchar2(30)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.