P 2 K_CP_CLASS_SCHEDULES

Alias: CRSC#

(P2K_CP_CLASS_SCHEDULES)

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


Class Schedules

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CRS_IDNumber(10)IDYlink to P2K_CP_COURSES
ECT_IDNumber(10)ID link to P2K_HR_CONTACTS
DLN_IDNumber(10)ID link to P2K_CM_LOCATIONS
CLASS_CODEVarchar2(16)CODEY
CLASS_STATUSVarchar2(2)X_CLASS_STATUSY
APPROVEDVarchar2(1)TOGGLE
CLASS_TITLEVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
WEB_ADDRESSVarchar2(200)URL
ENROLLMENT_START_DATEDate()DATE
ENROLLMENT_END_DATEDate()DATE
EXTERNAL_CLASS_IDVarchar2(16)VARCHAR16
CLASS_START_DATEDate()DATE
CLASS_END_DATEDate()DATE
CLASS_START_TIMENumber(5)MINUTES
CLASS_END_TIMENumber(5)MINUTES
DURATIONNumber(9)AMT5V4
DURATION_BASISVarchar2(2)X_PERIOD_BASIS
COURSE_FORMATVarchar2(2)X_COURSE_FORMAT
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
MINIMUM_SIZENumber(5)NUMBER5
MAXIMUM_SIZENumber(5)NUMBER5
IDEAL_SIZENumber(5)NUMBER5
BUDGETED_COSTNumber(18)AMT12V6
ACTUAL_COSTNumber(18)AMT12V6
CURRENCYVarchar2(2)X_CURRENCY
CLASS_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CLASS_ENROLLMENT_OPTIONSVarchar2(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

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