This is version 1 2 3 4 5 6 7 8 9 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: IVEEM#

(INF_CV_EMPLOYMENTS)
Provides all of the details for the entity Employm

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	Y
HIRE_DATE	Date()	DATE	Y
TERMINATION_CODE	Varchar2(16)	CODE
ORIGINAL_HIRE_DATE	Date()	DATE
SENIORITY_DATE	Date()	DATE
HIRE_SEQUENCE	Number(5)	NUMBER5
FIRST_WORK_DATE	Date()	DATE
LAST_WORK_DATE	Date()	DATE
TERMINATION_DATE	Date()	DATE
ROE_STATUS	Varchar2(30)	VARCHAR30
ROE_ISSUED_DATE	Date()	DATE
ROE_LETTER	Varchar2(30)	VARCHAR30
ROE_COMMENTS	Varchar2(2000)	VARCHAR2000
REHIRE_STATUS	Varchar2(30)	VARCHAR30
EXPECTED_RETURN_DATE	Date()	DATE
INCOME_GUARANTEE	Number(5)	PERCENT
USER_FIELD_VALUE_01	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_02	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_03	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_04	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_05	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_06	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_07	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_08	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_09	Varchar2(2000)	VARCHAR2000
USER_FIELD_VALUE_10	Varchar2(2000)	VARCHAR2000
CREATE_DATE	Date()	DATE
CREATE_USER	Varchar2(30)	VARCHAR30
CHANGE_DATE	Date()	DATE
CHANGE_USER	Varchar2(30)	VARCHAR30