Alias: IVXPR#

(INF_CV_PNRECIPIENTS)

Pension Recipients

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
ENTITY_CODEVarchar2(16)Y
PENSION_ACCOUNT_CODEVarchar2(16)Y
PERSON_CODE_OWNERVarchar2(16)Y
PERSON_CODE_RECPTVarchar2(16)
RECIPIENT_CATEGORYVarchar2(30)Y
DECEASED_DATEDate()
INCLUDE_COLAVarchar2(4)
FIRST_NAMEVarchar2(50)
LAST_NAMEVarchar2(50)
RELATIONVarchar2(30)
EMPLOYERVarchar2(50)
EFFECTIVEDate()
EXPIRYDate()
RECIPIENT_STATUSVarchar2(30)
PAYMENT_SEQUENCENumber(10)
PAYMENT_AMOUNTNumber(14)
PAYMENT_PERCENTNumber(18)
CHANGE_CODEVarchar2(16)