!!!Alias: IVSRW
The INF_CV_REVIEWS table is used to import employee review information into the software data structures. Reviews are used to record the evaluation and assessment of an employee.   

Reviews are carried out for different reasons, for example, to evaluate an employee's performance, to determine their employment status, or to implement disciplinary procedures.


!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HIRE_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[ASSIGNMENT_START_DATE]|Date()|[DATE]|Y|
|[REVIEW_NUMBER]|Number(10)|[NUMBER10|NUMBERn]|Y|
|[REVIEW_TYPE_CODE]|Varchar2(16)|[CODE]|Y|
|[REVIEW_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[REVIEW_DATE]|Date()|[DATE]|Y|
|[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |
|[REVIEW_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[REVIEW_DONE_BY]|Varchar2(50)|[DESCRIPTION]| |
|[OVERALL_RATING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[OVERALL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[BASED_ON_PRIOR_JOB]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[REVIEW_COMMENTS]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[MATRIX_CODE]|Varchar2(16)|[CODE]| |
|[MATRIX_START_DATE]|Date()|[DATE]| |
|[REVIEW_CATEGORY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[REVIEW_RATING]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[REVIEW_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[APPROVED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[MERIT_MONTHS]|Number(10)|[NUMBER10|NUMBERn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |