INF_CV_RECIPIENTS
Back to current versionRestore this version

Alias: IVBBR#

The INF_CV_RECIPIENTS table is used to import information about the recipients and beneficiaries of employee benefit plans into the software data structures.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODEY
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
PLAN_CODEVarchar2(16)CODEY
FIRST_NAMEVarchar2(50)VARCHAR50Y
LAST_NAMEVarchar2(50)VARCHAR50Y
RELATIONVarchar2(30)VARCHAR30
START_DATEDate()DATEY
END_DATEDate()DATE
BENEFIT_PERCENTNumber(5)PERCENT
BOND_PARTICIPATIONVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30