Alias: CRS#

(P2K_CP_COURSES)

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

Courses

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
CTS_ID	Number(10)	ID		link to P2K_CP_TRAINING_SUPPLIERS
RAS_ID_TESTED	Number(10)	ID		link to P2K_RE_ASSESSMENTS
RAS_ID_SURVEYED	Number(10)	ID		link to P2K_RE_ASSESSMENTS
COURSE_CODE	Varchar2(16)	CODE	Y
COMPETENCE_GROUP	Varchar2(2)	X_COMPETENCE_GROUP	Y
COURSE_STATUS	Varchar2(2)	X_COURSE_STATUS	Y
APPROVED	Varchar2(1)	TOGGLE
COURSE_TYPE	Varchar2(2)	X_COURSE_TYPE
COURSE_CATEGORY	Varchar2(2)	X_COURSE_CATEGORY
COURSE_TITLE	Varchar2(50)	DESCRIPTION
FONT_HTML	Varchar2(2000)	VARCHAR2000
WEB_ADDRESS	Varchar2(200)	URL
EXTERNAL_COURSE_ID	Varchar2(16)	VARCHAR16
COURSE_START_DATE	Date()	DATE
COURSE_END_DATE	Date()	DATE
STARTING_DAY	Varchar2(3)	X_DAY_OF_WEEK
DURATION	Number(9)	AMT5V4
DURATION_BASIS	Varchar2(2)	X_PERIOD_BASIS
COURSE_FORMAT	Varchar2(2)	X_COURSE_FORMAT
LANGUAGE_CODE	Varchar2(3)	X_LANGUAGE_CODE
REPEAT_INTERVAL	Number(7)	AMT5V2
REPEAT_BASIS	Varchar2(2)	X_PERIOD_BASIS
REGISTRATION_NUMBER	Varchar2(30)	ABBREVIATION
REQUIRED_GRADE	Number(7)	AMT5V2
SPONSOR	Varchar2(50)	DESCRIPTION
OBJECTIVES	Varchar2(4000)	VARCHAR4000
AUDIENCE	Varchar2(4000)	VARCHAR4000
PREREQUISITES	Varchar2(4000)	VARCHAR4000
FEE_POLICY	Varchar2(4000)	VARCHAR4000
COURSE_TEXT	Varchar2(4000)	VARCHAR4000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_REPEAT

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page