INF_CV_ASSESSMENTS
Back to current versionRestore this version

Alias: IVRAS#

(INF_CV_ASSESSMENTS)
Assessments

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ASSESSMENT_CODEVarchar2(16)CODEY
COMPETENCE_GROUPVarchar2(30)VARCHAR30Y
ASSESSMENT_STATUSVarchar2(30)VARCHAR30Y
ASSESSMENT_TYPEVarchar2(30)VARCHAR30Y
ENTITY_CODEVarchar2(16)CODE
SUPPLIER_CODEVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
ASSESSMENT_CATEGORYVarchar2(30)VARCHAR30
APPROVEDVarchar2(4)VARCHAR4
DESCRIPTIONVarchar2(50)DESCRIPTION
FONT_HTMLVarchar2(2000)VARCHAR2000
EXTERNAL_ASSESSMENT_IDVarchar2(16)VARCHAR16
DESIRED_POINTSNumber(5)NUMBER5
ESSENTIAL_POINTSNumber(5)NUMBER5
MAXIMUM_POINTSNumber(5)NUMBER5
ANONYMOUSVarchar2(4)VARCHAR4
ALLOW_QUESTION_REVIEWVarchar2(4)VARCHAR4
SHOW_WEIGHTINGVarchar2(4)VARCHAR4
MUST_BE_SCHEDULEDVarchar2(4)VARCHAR4
IMAGE_LOCATIONVarchar2(2000)VARCHAR2000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30