Alias: EEM#
(P2K_HR_EMPLOYMENTS)Unique Keys:
Child Table:
Parent Table:
ERD: ERD-HR2
This table identies the relationship between the employee and the company.
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 |
User Fields: Allowed
Audit Logging: Allowed
