Alias: IVXPE#

(INF_CV_PNEVALUATIONS)

Pension Evaluations

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
PENSION_PLAN_CODEVarchar2(16)Y
PENSION_OPTION_CODEVarchar2(16)Y
ENTITY_CODEVarchar2(16)Y
PENSION_ACCOUNT_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
EVALUATION_DATEDate()Y
EVALUATION_CATEGORYVarchar2(30)Y
EVALUATION_STATUSVarchar2(30)Y
PROPOSED_RETIREMENT_DATEDate()
PROPOSED_TERMINATION_DATEDate()
OFFICIALVarchar2(4)
VALUEVarchar2(2000)
PN_CODEVarchar2(16)
OVERRIDE_VALUEVarchar2(2000)
AUDIT_TEXTVarchar2(4000)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.