!!!Alias: IVRAS (INF_CV_ASSESSMENTS) \\ Assessments !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[ASSESSMENT_CODE]|Varchar2(16)|Y| |[COMPETENCE_GROUP]|Varchar2(30)|Y| |[ASSESSMENT_STATUS]|Varchar2(30)|Y| |[ASSESSMENT_TYPE]|Varchar2(30)|Y| |[ENTITY_CODE]|Varchar2(16)| | |[SUPPLIER_CODE]|Varchar2(16)| | |[COUNTRY_CODE]|Varchar2(16)| | |[STATE_PROVINCE_CODE]|Varchar2(16)| | |[ASSESSMENT_CATEGORY]|Varchar2(30)| | |[APPROVED]|Varchar2(4)| | |[DESCRIPTION]|Varchar2(50)| | |[FONT_HTML]|Varchar2(2000)| | |[EXTERNAL_ASSESSMENT_ID]|Varchar2(16)| | |[DESIRED_POINTS]|Number(5)| | |[ESSENTIAL_POINTS]|Number(5)| | |[MAXIMUM_POINTS]|Number(5)| | |[ANONYMOUS]|Varchar2(4)| | |[ALLOW_QUESTION_REVIEW]|Varchar2(4)| | |[SHOW_WEIGHTING]|Varchar2(4)| | |[MUST_BE_SCHEDULED]|Varchar2(4)| | |[IMAGE_LOCATION]|Varchar2(2000)| | |[CREATE_DATE]|Date()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.