[Home] [Help] [Dependency Information]
Object Name: | JTF_RS_EMPLOYEES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_RS_EMPLOYEES_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view has the list of all Employees that can be importedor is already present in Resource Manager
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (10) | Yes | Person( Employee) identifier FK to Pe_people_f |
FIRST_NAME | VARCHAR2 | (150) | First Name of Employee | |
LAST_NAME | VARCHAR2 | (150) | Yes | last name of the employee |
MIDDLE_NAME | VARCHAR2 | (60) | Middle Name of Employee | |
FULL_NAME | VARCHAR2 | (240) | Full Name of Employee | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee Number | |
PHONE | VARCHAR2 | (4000) | Phone of Employee | |
VARCHAR2 | (240) | email of employee | ||
JOB_TITLE | VARCHAR2 | (0) | The value for this field will be null for performcae reasons | |
MANAGER_PERSON_ID | NUMBER | (10) | Person id of manager of employee | |
MANAGER_NAME | VARCHAR2 | (240) | Manager's Name | |
EFFECTIVE_START_DATE | DATE | Yes | Date on which This person becomes active in HR | |
EFFECTIVE_END_DATE | DATE | Yes | Date after which This person becomes inactive in HR | |
EMP_CATEGORY | VARCHAR2 | (0) | Value is null for performance reasons | |
EMP_STATUS | VARCHAR2 | (0) | Value is null for performance reasons | |
ORG_ID | NUMBER | (15) | Yes | Organization identifier |
ORG_NAME | VARCHAR2 | (240) | Yes | Employee's Organization Name |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, FULL_NAME
, EMPLOYEE_NUMBER
, PHONE
, EMAIL
, JOB_TITLE
, MANAGER_PERSON_ID
, MANAGER_NAME
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, EMP_CATEGORY
, EMP_STATUS
, ORG_ID
, ORG_NAME
FROM APPS.JTF_RS_EMPLOYEES_VL;
APPS.JTF_RS_EMPLOYEES_VL is not referenced by any database object
|
|
|