Alias: IVCRSC#

(INF_CV_CLASSSCHEDULES)
Class Schedules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
COURSE_CODEVarchar2(16)CODEY
CLASS_CODEVarchar2(16)CODEY
CLASS_STATUSVarchar2(30)VARCHAR30Y
LOCATION_CODEVarchar2(16)CODE
USER_NAMEVarchar2(30)VARCHAR30
FIRST_NAMEVarchar2(50)VARCHAR50
LAST_NAMEVarchar2(50)VARCHAR50
RELATIONVarchar2(30)VARCHAR30
EMPLOYERVarchar2(50)VARCHAR50
APPROVEDVarchar2(4)VARCHAR4
CLASS_TITLEVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
ENROLLMENT_START_DATEDate()DATE
ENROLLMENT_END_DATEDate()DATE
EXTERNAL_CLASS_IDVarchar2(16)VARCHAR16
CLASS_START_DATEDate()DATE
CLASS_END_DATEDate()DATE
DURATIONNumber(9)AMT5V4
DURATION_BASISVarchar2(30)VARCHAR30
COURSE_FORMATVarchar2(30)VARCHAR30
LANGUAGE_CODEVarchar2(30)VARCHAR30
MINIMUM_SIZENumber(5)NUMBER5
MAXIMUM_SIZENumber(5)NUMBER5
IDEAL_SIZENumber(5)NUMBER5
BUDGETED_COSTNumber(18)AMT12V6
ACTUAL_COSTNumber(18)AMT12V6
CURRENCYVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30