Alias: CRS#

(P2K_CP_COURSES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-CP04


Courses

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CTS_IDNumber(10)ID link to P2K_CP_TRAINING_SUPPLIERS
RAS_ID_TESTEDNumber(10)ID link to P2K_RE_ASSESSMENTS
RAS_ID_SURVEYEDNumber(10)ID link to P2K_RE_ASSESSMENTS
COURSE_CODEVarchar2(16)CODEY
COMPETENCE_GROUPVarchar2(2)X_COMPETENCE_GROUPY
COURSE_STATUSVarchar2(2)X_COURSE_STATUSY
APPROVEDVarchar2(1)TOGGLE
COURSE_TYPEVarchar2(2)X_COURSE_TYPE
COURSE_CATEGORYVarchar2(2)X_COURSE_CATEGORY
COURSE_TITLEVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
WEB_ADDRESSVarchar2(200)URL
EXTERNAL_COURSE_IDVarchar2(16)VARCHAR16
COURSE_START_DATEDate()DATE
COURSE_END_DATEDate()DATE
STARTING_DAYVarchar2(3)X_DAY_OF_WEEK
DURATIONNumber(9)AMT5V4
DURATION_BASISVarchar2(2)X_PERIOD_BASIS
COURSE_FORMATVarchar2(2)X_COURSE_FORMAT
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
REPEAT_INTERVALNumber(7)AMT5V2
REPEAT_BASISVarchar2(2)X_PERIOD_BASIS
REGISTRATION_NUMBERVarchar2(30)ABBREVIATION
REQUIRED_GRADENumber(7)AMT5V2
SPONSORVarchar2(50)DESCRIPTION
OBJECTIVESVarchar2(4000)VARCHAR4000
AUDIENCEVarchar2(4000)VARCHAR4000
PREREQUISITESVarchar2(4000)VARCHAR4000
FEE_POLICYVarchar2(4000)VARCHAR4000
COURSE_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_APPROVAL_BAR

User Fields: Allowed
Audit Logging: Allowed

This particular version was published on 26-Nov-2021 10:22 by JEscott.Top