Alias: IVSRW#

(INF_CV_REVIEWS)
Reviews

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