eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: HR.GHR_MASS_TRANSFERS#

Source

View Text - Preformatted


select MASS_TRANSFER_ID MASS_TRANSFER_ID, EFFECTIVE_DATE EFFECTIVE_DATE, INTERFACE_FLAG INTERFACE_FLAG, NAME NAME, REASON REASON, STATUS STATUS, PA_REQUEST_ID PA_REQUEST_ID, TRANSFER_TYPE TRANSFER_TYPE, WITHIN_BG_TRANSFER WITHIN_BG_TRANSFER, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT, DUTY_STATION_CODE DUTY_STATION_CODE, DUTY_STATION_ID DUTY_STATION_ID, OLD_ORGANIZATION_ID OLD_ORGANIZATION_ID, OLD_ORGANIZATION_NAME OLD_ORGANIZATION_NAME, OLD_ORG_STRUCTURE_VERSION_ID OLD_ORG_STRUCTURE_VERSION_ID, OLD_ORG_STRUCTURE_NAME OLD_ORG_STRUCTURE_NAME, OLD_POSITION_ID OLD_POSITION_ID, OLD_POSITION_NAME OLD_POSITION_NAME, OLD_POS_STRUCTURE_VERSION_ID OLD_POS_STRUCTURE_VERSION_ID, OLD_POS_STRUCTURE_NAME OLD_POS_STRUCTURE_NAME, ORG_STRUCTURE_ID ORG_STRUCTURE_ID, OFFICE_SYMBOL OFFICE_SYMBOL, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID, TO_AGENCY_CODE_SUBELEMENT TO_AGENCY_CODE_SUBELEMENT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BUSINESS_GROUP_ID BUSINESS_GROUP_ID from "HR"."GHR_MASS_TRANSFERS"

View Text - HTML Formatted

SELECT MASS_TRANSFER_ID MASS_TRANSFER_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, INTERFACE_FLAG INTERFACE_FLAG
, NAME NAME
, REASON REASON
, STATUS STATUS
, PA_REQUEST_ID PA_REQUEST_ID
, TRANSFER_TYPE TRANSFER_TYPE
, WITHIN_BG_TRANSFER WITHIN_BG_TRANSFER
, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT
, DUTY_STATION_CODE DUTY_STATION_CODE
, DUTY_STATION_ID DUTY_STATION_ID
, OLD_ORGANIZATION_ID OLD_ORGANIZATION_ID
, OLD_ORGANIZATION_NAME OLD_ORGANIZATION_NAME
, OLD_ORG_STRUCTURE_VERSION_ID OLD_ORG_STRUCTURE_VERSION_ID
, OLD_ORG_STRUCTURE_NAME OLD_ORG_STRUCTURE_NAME
, OLD_POSITION_ID OLD_POSITION_ID
, OLD_POSITION_NAME OLD_POSITION_NAME
, OLD_POS_STRUCTURE_VERSION_ID OLD_POS_STRUCTURE_VERSION_ID
, OLD_POS_STRUCTURE_NAME OLD_POS_STRUCTURE_NAME
, ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, OFFICE_SYMBOL OFFICE_SYMBOL
, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, TO_AGENCY_CODE_SUBELEMENT TO_AGENCY_CODE_SUBELEMENT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM "HR"."GHR_MASS_TRANSFERS"