Alias: IVXAC#

(INF_CV_PNACTIVITIES)

Pension Activities

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.
ENTITY_CODEVarchar2(16)Y
PENSION_PLAN_CODEVarchar2(16)Y
PENSION_ACCOUNT_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)Y
START_DATEDate()Y
END_DATEDate()Y
PENSION_ACTIVITY_STATUSVarchar2(30)Y
PENSION_ACTIVITY_SOURCEVarchar2(30)
CALENDAR_CODEVarchar2(16)
CALENDAR_PERIODNumber(10)
ACTIVITY_START_DATEDate()
PN_CODEVarchar2(16)
ACTIVITY_COMPONENT_STATUSVarchar2(30)
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.


Notes #

Click to create a new notes page