INF_CV_PNACCOUNTS
Back to current versionRestore this version

Alias: IVXPA#

(INF_CV_PNACCOUNTS)
Pension Accounts

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
PENSION_PLAN_CODEVarchar2(16)CODEY
ENTITY_CODEVarchar2(16)CODEY
PENSION_OPTION_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODEY
PENSION_ACCOUNT_CODEVarchar2(16)CODEY
ENROLLMENT_DATEDate()DATEY
ADJUSTED_ENROLLMENT_DATEDate()DATE
VESTED_DATEDate()DATE
RETIREMENT_DATEDate()DATE
ANNUITY_START_DATEDate()DATE
DECEASED_DATEDate()DATE
SERVICE_CONNECTED_DEATHVarchar2(4)VARCHAR4
OVERRIDE_VEST_PERCENTAGENumber(18)AMT12V6
CHANGE_CODEVarchar2(16)CODE
PENSION_STATUS_CODEVarchar2(16)CODE
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
PENSION_ACCOUNT_TEXT_DETAILSVarchar2(4000)VARCHAR4000
PENSION_PLAN_DETAILSVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30