INF_CV_REVIEWS
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 nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODEY
ASSIGNMENT_START_DATEDate()DATEY
REVIEW_NUMBERNumber(10)NUMBER10Y
REVIEW_TYPE_CODEVarchar2(16)CODEY
REVIEW_STATUSVarchar2(30)VARCHAR30Y
REVIEW_DATEDate()DATEY
USER_NAMEVarchar2(30)VARCHAR30
NEXT_REVIEW_DATEDate()DATE
REVIEW_METHODVarchar2(30)VARCHAR30
REVIEW_DONE_BYVarchar2(50)DESCRIPTION
OVERALL_RATINGVarchar2(30)VARCHAR30
OVERALL_POINTSNumber(5)NUMBER5
BASED_ON_PRIOR_JOBVarchar2(4)VARCHAR4
DESCRIPTIONVarchar2(50)DESCRIPTION
REVIEW_COMMENTSVarchar2(2000)VARCHAR2000
MATRIX_CODEVarchar2(16)CODE
MATRIX_START_DATEDate()DATE
REVIEW_CATEGORYVarchar2(30)VARCHAR30
REVIEW_RATINGVarchar2(16)VARCHAR16
REVIEW_POINTSNumber(5)NUMBER5
APPROVEDVarchar2(4)VARCHAR4
MERIT_MONTHSNumber(10)NUMBER10
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation