Alias: EEM#

(P2K_HR_EMPLOYMENTS)

Unique Keys: DEN_ID (ENTITY_CODE) + EID_ID (PERSON_CODE) + EMPLOYMENT_TYPE + HIRE_DATE

ERD: ERD-HR2

This table identifies the relationship between the employee and the company. An employee may have multiple employment records to reflect different periods of employment or concurrent employment with different arrangements.

Note that most other data in the system is subordinate to the employment record, and so each employment record will have its own assignment history, benefit history, pay history, etc.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
ROE_STATUS	Varchar2(2)	X_ROE_STATUS
EID_ID	Number(10)	ID	Y	Link to P2K_HR_IDENTITIES
DEN_ID	Number(10)	ID	Y	Link to P2K_CM_ENTITIES
EMPLOYMENT_TYPE	Varchar2(2)	X_EMPLOYMENT_TYPE	Y
HIRE_DATE	Date()	DATE	Y
TERMINATION_DATE	Date()	DATE
HIRE_SEQUENCE	Number(5)	NUMBER5
ORIGINAL_HIRE_DATE	Date()	DATE	Y
SENIORITY_DATE	Date()	DATE	Y
FIRST_WORK_DATE	Date()	DATE
LAST_WORK_DATE	Date()	DATE
DTR_ID	Number(10)	ID		Link to P2K_CM_TERMINATION_REASONS
REHIRE_STATUS	Varchar2(2)	X_REHIRE_STATUS
EXPECTED_RETURN_DATE	Date()	DATE
ROE_LETTER	Varchar2(1)	X_ROE_LETTER
ROE_ISSUED_DATE	Date()	DATE
ROE_COMMENTS	Varchar2(2000)	VARCHAR2000
LAST_PAY_NUMBER	Number(5)	NUMBER5
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
INCOME_GUARANTEE	Number(5)	PERCENT
GR_ELECTRONIC_CONSENT	Varchar2(1)	TOGGLE
GR_ELECTRONIC_CONSENT_BY	Varchar2(30)	VARCHAR30
GR_ELECTRONIC_CONSENT_DATE	Date()	DATE
GR_LAST_YEAR_PRINTED	Varchar2(4)	VARCHAR4

Derived Fields#

Column Name
DRV_LAST_FIRST_EECODE
DRV_SERVICE_MONTHS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page