Alias: CRSC#

(P2K_CP_CLASS_SCHEDULES)

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

Class Schedules

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
CRS_ID	Number(10)	ID	Y	link to P2K_CP_COURSES
ECT_ID	Number(10)	ID		link to P2K_HR_CONTACTS
DLN_ID	Number(10)	ID		link to P2K_CM_LOCATIONS
CLASS_CODE	Varchar2(16)	CODE	Y
CLASS_STATUS	Varchar2(2)	X_CLASS_STATUS	Y
APPROVED	Varchar2(1)	TOGGLE
CLASS_TITLE	Varchar2(50)	DESCRIPTION
FONT_HTML	Varchar2(2000)	VARCHAR2000
WEB_ADDRESS	Varchar2(200)	URL
ENROLLMENT_START_DATE	Date()	DATE
ENROLLMENT_END_DATE	Date()	DATE
EXTERNAL_CLASS_ID	Varchar2(16)	VARCHAR16
CLASS_START_DATE	Date()	DATE
CLASS_END_DATE	Date()	DATE
CLASS_START_TIME	Number(5)	MINUTES
CLASS_END_TIME	Number(5)	MINUTES
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
MINIMUM_SIZE	Number(5)	NUMBER5
MAXIMUM_SIZE	Number(5)	NUMBER5
IDEAL_SIZE	Number(5)	NUMBER5
BUDGETED_COST	Number(18)	AMT12V6
ACTUAL_COST	Number(18)	AMT12V6
CURRENCY	Varchar2(2)	X_CURRENCY
CLASS_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
CLASS_ENROLLMENT_OPTIONS	Varchar2(2)	X_CLASS_ENROLLMENT_OPTIONS

Derived Fields#

Column Name
DRV_ALERT_MSG
DRV_APPROVAL_BAR
DRV_AVAILABILITY
DRV_DATE_RANGE
DRV_HEAD_COUNT
DRV_TIME_FRAME

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page