This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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
HIRE_DATE	Date()	DATE
ASSIGNMENT_CODE	Varchar2(16)	CODE	Y
ASSIGNMENT_START_DATE	Date()	DATE	Y
REVIEW_NUMBER	Number(10)	NUMBER10	Y
REVIEW_TYPE_CODE	Varchar2(16)	CODE	Y
REVIEW_STATUS	Varchar2(30)	VARCHAR30	Y
REVIEW_DATE	Date()	DATE	Y
USER_NAME	Varchar2(30)	VARCHAR30
NEXT_REVIEW_DATE	Date()	DATE
REVIEW_METHOD	Varchar2(30)	VARCHAR30
REVIEW_DONE_BY	Varchar2(50)	DESCRIPTION
OVERALL_RATING	Varchar2(30)	VARCHAR30
OVERALL_POINTS	Number(5)	NUMBER5
BASED_ON_PRIOR_JOB	Varchar2(4)	VARCHAR4
DESCRIPTION	Varchar2(50)	DESCRIPTION
REVIEW_COMMENTS	Varchar2(2000)	VARCHAR2000
MATRIX_CODE	Varchar2(16)	CODE
MATRIX_START_DATE	Date()	DATE
REVIEW_CATEGORY	Varchar2(30)	VARCHAR30
REVIEW_RATING	Varchar2(16)	VARCHAR16
REVIEW_POINTS	Number(5)	NUMBER5
APPROVED	Varchar2(4)	VARCHAR4
MERIT_MONTHS	Number(10)	NUMBER10
CREATE_DATE	Date()	DATE
CREATE_USER	Varchar2(30)	VARCHAR30
CHANGE_DATE	Date()	DATE
CHANGE_USER	Varchar2(30)	VARCHAR30