IVXPP
Back to current versionRestore this version

Alias: IVXPP#

(INF_CV_PNPAYMENTS)

Pension Payments

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
FIRST_NAMEVarchar2(50)
LAST_NAMEVarchar2(50)
RELATIONVarchar2(30)
EMPLOYERVarchar2(50)
EVALUATION_STATUSVarchar2(30)Y
EVALUATION_DATEDate()Y
PENSION_OPTION_CODEVarchar2(16)Y
PAYMENT_CATEGORY_CODEVarchar2(16)Y
PAYMENT_DATEDate()Y
PAYMENT_AMOUNTNumber(14)Y