P 2 K_CP_CLASS_REGISTRATIONS
Back to current versionRestore this version

Alias: CRSE#

(P2K_CP_CLASS_REGISTRATIONS)

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


Class Registrations

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CRSC_IDNumber(10)IDYlink to P2K_CP_CLASS_SCHEDULES
RCA_IDNumber(10)IDYlink to P2K_RE_CANDIDATES
REGISTRATION_STATUSVarchar2(2)X_REGISTRATION_STATUSY
FEE_SCHEDULEVarchar2(2)X_FEE_SCHEDULE
DESCRIPTIONVarchar2(50)DESCRIPTION
REGISTRATION_NUMBERVarchar2(30)ABBREVIATION
FINAL_GRADENumber(7)AMT5V2
REGISTRATION_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
APPROVEDVarchar2(1)TOGGLE

Derived Fields#

Column Name
DRV_APPROVAL_BAR

User Fields: Allowed
Audit Logging: Allowed