P 2 K_CP_COURSES

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
DRV_REPEAT

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation