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.

[Home] [Help]

VIEW: HR.GHR_MASS_REALIGNMENT#

Source

View Text - Preformatted


select MASS_REALIGNMENT_ID MASS_REALIGNMENT_ID, EFFECTIVE_DATE EFFECTIVE_DATE, NAME NAME, REASON REASON, STATUS STATUS, PA_REQUEST_ID PA_REQUEST_ID, NEW_ORGANIZATION_ID NEW_ORGANIZATION_ID, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT, NEW_ORGANIZATION_NAME NEW_ORGANIZATION_NAME, 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, TARGET_AGENCY_CODE_SUBELEMENT TARGET_AGENCY_CODE_SUBELEMENT, TARGET_APPROPRIATION_CODE1 TARGET_APPROPRIATION_CODE1, TARGET_APPROPRIATION_CODE2 TARGET_APPROPRIATION_CODE2, TARGET_DUTY_STN_LOCATION_ID TARGET_DUTY_STN_LOCATION_ID, TARGET_DUTY_STATION_ID TARGET_DUTY_STATION_ID, TARGET_DUTY_STATION_CODE TARGET_DUTY_STATION_CODE, TARGET_OFFICE_SYMBOL TARGET_OFFICE_SYMBOL, TARGET_ORG_FUNCTION_CODE TARGET_ORG_FUNCTION_CODE, TARGET_PAYROLL_OFFICE_ID TARGET_PAYROLL_OFFICE_ID, TARGET_PERSONNEL_OFFICE_ID TARGET_PERSONNEL_OFFICE_ID, TARGET_POSITION_ORG_ID TARGET_POSITION_ORG_ID, TARGET_POSITION_ORG_NAME TARGET_POSITION_ORG_NAME, 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_REALIGNMENT"

View Text - HTML Formatted

SELECT MASS_REALIGNMENT_ID MASS_REALIGNMENT_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, NAME NAME
, REASON REASON
, STATUS STATUS
, PA_REQUEST_ID PA_REQUEST_ID
, NEW_ORGANIZATION_ID NEW_ORGANIZATION_ID
, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT
, NEW_ORGANIZATION_NAME NEW_ORGANIZATION_NAME
, 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
, TARGET_AGENCY_CODE_SUBELEMENT TARGET_AGENCY_CODE_SUBELEMENT
, TARGET_APPROPRIATION_CODE1 TARGET_APPROPRIATION_CODE1
, TARGET_APPROPRIATION_CODE2 TARGET_APPROPRIATION_CODE2
, TARGET_DUTY_STN_LOCATION_ID TARGET_DUTY_STN_LOCATION_ID
, TARGET_DUTY_STATION_ID TARGET_DUTY_STATION_ID
, TARGET_DUTY_STATION_CODE TARGET_DUTY_STATION_CODE
, TARGET_OFFICE_SYMBOL TARGET_OFFICE_SYMBOL
, TARGET_ORG_FUNCTION_CODE TARGET_ORG_FUNCTION_CODE
, TARGET_PAYROLL_OFFICE_ID TARGET_PAYROLL_OFFICE_ID
, TARGET_PERSONNEL_OFFICE_ID TARGET_PERSONNEL_OFFICE_ID
, TARGET_POSITION_ORG_ID TARGET_POSITION_ORG_ID
, TARGET_POSITION_ORG_NAME TARGET_POSITION_ORG_NAME
, 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_REALIGNMENT"