P 2 K_RE_ASSESSMENTS

Alias: RAS#

(P2K_RE_ASSESSMENTS)

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


Assessments

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
CTS_IDNumber(10)ID link to P2K_CP_TRAINING_SUPPLIERS
ASSESSMENT_CODEVarchar2(16)CODEY
COMPETENCE_GROUPVarchar2(2)X_COMPETENCE_GROUPY
ASSESSMENT_STATUSVarchar2(2)X_ASSESSMENT_STATUSY
ASSESSMENT_TYPEVarchar2(2)X_ASSESSMENT_TYPEY
ASSESSMENT_CATEGORYVarchar2(2)X_ASSESSMENT_CATEGORY
APPROVEDVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
WEB_ADDRESSVarchar2(200)URL
EXTERNAL_ASSESSMENT_IDVarchar2(16)VARCHAR16
DESIRED_POINTSNumber(5)NUMBER5
ESSENTIAL_POINTSNumber(5)NUMBER5
MAXIMUM_POINTSNumber(5)NUMBER5
REQUIRED_GRADENumber(7)AMT5V2
ANONYMOUSVarchar2(1)TOGGLE
ALLOW_QUESTION_REVIEWVarchar2(1)TOGGLE
SHOW_WEIGHTINGVarchar2(1)TOGGLE
ASSESSMENT_TEXTVarchar2(4000)VARCHAR4000
MUST_BE_SCHEDULEDVarchar2(1)TOGGLE
IMAGE_LOCATIONVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_APPROVAL_BAR

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page