!!!Alias: IVBBR
(INF_CV_RECIPIENTS)
\\
Benefit Recipients

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HIRE_DATE]|Date()|[DATE]| |
|[PLAN_CODE]|Varchar2(16)|[CODE]|Y|
|[FIRST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[LAST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[RELATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[START_DATE]|Date()|[DATE]|Y|
|[END_DATE]|Date()|[DATE]| |
|[BENEFIT_PERCENT]|Number(5)|[PERCENT]| |
|[BOND_PARTICIPATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |