Alias: IVCRSC#

(INF_CV_CLASSSCHEDULES)
Class Schedules

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10)
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()
CREATE_USERVarchar2(30)
CHANGE_DATEDate()
CHANGE_USERVarchar2(30)