INF_CV_PNACTIVITIES
Back to current versionRestore this version

Alias: IVXAC#

(INF_CV_PNACTIVITIES)
Pension Activities

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PENSION_PLAN_CODEVarchar2(16)CODEY
PENSION_ACCOUNT_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
START_DATEDate()DATEY
END_DATEDate()DATEY
PENSION_ACTIVITY_STATUSVarchar2(30)VARCHAR30Y
PENSION_ACTIVITY_SOURCEVarchar2(30)VARCHAR30
CALENDAR_CODEVarchar2(16)CODE
CALENDAR_PERIODNumber(10)NUMBER10
ACTIVITY_START_DATEDate()DATE
PN_CODEVarchar2(16)CODE
ACTIVITY_COMPONENT_STATUSVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30