[Home] [Help]
View: CSC_HZ_EMPLOYMENT_HISTORY_V
Product: | CSC - Customer Care |
Description: | View of HZ_EMPLOYEE_HISTORY. This view is used to get employee history details. |
Implementation/DBA Data: |
APPS.CSC_HZ_EMPLOYMENT_HISTORY_V
|
View Text
SELECT EMPLOYMENT_HISTORY_ID
, BEGIN_DATE
, PARTY_ID
, EMPLOYED_AS_TITLE
, EMPLOYED_BY_DIVISION_NAME
, EMPLOYED_BY_NAME_COMPANY
, END_DATE
, SUPERVISOR_NAME
, BRANCH
, MILITARY_RANK
, CREATED_BY
, CREATION_DATE
, SERVED
, LAST_UPDATE_LOGIN
, STATION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, RESPONSIBILITY
, NULL
FROM HZ_EMPLOYMENT_HISTORY
Columns
Name |
EMPLOYMENT_HISTORY_ID |
BEGIN_DATE |
PARTY_ID |
EMPLOYED_AS_TITLE |
EMPLOYED_BY_DIVISION_NAME |
EMPLOYED_BY_NAME_COMPANY |
END_DATE |
SUPERVISOR_NAME |
BRANCH |
MILITARY_RANK |
CREATED_BY |
CREATION_DATE |
SERVED |
LAST_UPDATE_LOGIN |
STATION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
WH_UPDATE_DATE |
RESPONSIBILITY |
STATUS |