VIEW: AR.HZ_EMPLOYMENT_HISTORY#

Source

View Text - Preformatted

select EMPLOYMENT_HISTORY_ID EMPLOYMENT_HISTORY_ID, BEGIN_DATE BEGIN_DATE, PARTY_ID PARTY_ID, EMPLOYED_AS_TITLE EMPLOYED_AS_TITLE, EMPLOYED_BY_DIVISION_NAME EMPLOYED_BY_DIVISION_NAME, EMPLOYED_BY_NAME_COMPANY EMPLOYED_BY_NAME_COMPANY, END_DATE END_DATE, SUPERVISOR_NAME SUPERVISOR_NAME, BRANCH BRANCH, MILITARY_RANK MILITARY_RANK, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SERVED SERVED, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STATION STATION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, WH_UPDATE_DATE WH_UPDATE_DATE, RESPONSIBILITY RESPONSIBILITY, STATUS STATUS, EMPLOYED_BY_PARTY_ID EMPLOYED_BY_PARTY_ID, REASON_FOR_LEAVING REASON_FOR_LEAVING, FACULTY_POSITION_FLAG FACULTY_POSITION_FLAG, TENURE_CODE TENURE_CODE, FRACTION_OF_TENURE FRACTION_OF_TENURE, EMPLOYMENT_TYPE_CODE EMPLOYMENT_TYPE_CODE, EMPLOYED_AS_TITLE_CODE EMPLOYED_AS_TITLE_CODE, WEEKLY_WORK_HOURS WEEKLY_WORK_HOURS, COMMENTS COMMENTS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, APPLICATION_ID APPLICATION_ID, CREATED_BY_MODULE CREATED_BY_MODULE from "AR"."HZ_EMPLOYMENT_HISTORY"

View Text - HTML Formatted

SELECT EMPLOYMENT_HISTORY_ID EMPLOYMENT_HISTORY_ID
, BEGIN_DATE BEGIN_DATE
, PARTY_ID PARTY_ID
, EMPLOYED_AS_TITLE EMPLOYED_AS_TITLE
, EMPLOYED_BY_DIVISION_NAME EMPLOYED_BY_DIVISION_NAME
, EMPLOYED_BY_NAME_COMPANY EMPLOYED_BY_NAME_COMPANY
, END_DATE END_DATE
, SUPERVISOR_NAME SUPERVISOR_NAME
, BRANCH BRANCH
, MILITARY_RANK MILITARY_RANK
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SERVED SERVED
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STATION STATION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, RESPONSIBILITY RESPONSIBILITY
, STATUS STATUS
, EMPLOYED_BY_PARTY_ID EMPLOYED_BY_PARTY_ID
, REASON_FOR_LEAVING REASON_FOR_LEAVING
, FACULTY_POSITION_FLAG FACULTY_POSITION_FLAG
, TENURE_CODE TENURE_CODE
, FRACTION_OF_TENURE FRACTION_OF_TENURE
, EMPLOYMENT_TYPE_CODE EMPLOYMENT_TYPE_CODE
, EMPLOYED_AS_TITLE_CODE EMPLOYED_AS_TITLE_CODE
, WEEKLY_WORK_HOURS WEEKLY_WORK_HOURS
, COMMENTS COMMENTS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, APPLICATION_ID APPLICATION_ID
, CREATED_BY_MODULE CREATED_BY_MODULE
FROM "AR"."HZ_EMPLOYMENT_HISTORY"