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_SALARIES#

Source

View Text - Preformatted


select MASS_SALARY_ID MASS_SALARY_ID, NAME NAME, PA_REQUEST_ID PA_REQUEST_ID, EFFECTIVE_DATE EFFECTIVE_DATE, EXECUTIVE_ORDER_NUMBER EXECUTIVE_ORDER_NUMBER, EXECUTIVE_ORDER_DATE EXECUTIVE_ORDER_DATE, USER_TABLE_ID USER_TABLE_ID, ORGANIZATION_ID ORGANIZATION_ID, DUTY_STATION_ID DUTY_STATION_ID, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT, SUBMIT_FLAG SUBMIT_FLAG, OPM_ISSUANCE_NUMBER OPM_ISSUANCE_NUMBER, 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, OPM_ISSUANCE_DATE OPM_ISSUANCE_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PROCESS_TYPE PROCESS_TYPE, LOCALITY_PAY_AREA_CODE LOCALITY_PAY_AREA_CODE, NOA_CODE NOA_CODE, NTE_DATE NTE_DATE, TARGET_BARGAINING_UNIT_STATUS TARGET_BARGAINING_UNIT_STATUS, TARGET_FLSA_CATEGORY TARGET_FLSA_CATEGORY, TARGET_OCC_CODE TARGET_OCC_CODE, TARGET_AGENCY_CODE_SUBELEMENT TARGET_AGENCY_CODE_SUBELEMENT, TARGET_DUTY_STATION_ID TARGET_DUTY_STATION_ID, TARGET_DUTY_STATION_CODE TARGET_DUTY_STATION_CODE, TARGET_JOB_ID TARGET_JOB_ID, TARGET_FUNCTIONAL_CLASS TARGET_FUNCTIONAL_CLASS, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS, JOB_ID JOB_ID, FLSA_CATEGORY FLSA_CATEGORY, TARGET_MASS_ACTION_ID TARGET_MASS_ACTION_ID, TARGET_MASS_ACTION_TYPE TARGET_MASS_ACTION_TYPE from "HR"."GHR_MASS_SALARIES"

View Text - HTML Formatted

SELECT MASS_SALARY_ID MASS_SALARY_ID
, NAME NAME
, PA_REQUEST_ID PA_REQUEST_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXECUTIVE_ORDER_NUMBER EXECUTIVE_ORDER_NUMBER
, EXECUTIVE_ORDER_DATE EXECUTIVE_ORDER_DATE
, USER_TABLE_ID USER_TABLE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DUTY_STATION_ID DUTY_STATION_ID
, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT
, SUBMIT_FLAG SUBMIT_FLAG
, OPM_ISSUANCE_NUMBER OPM_ISSUANCE_NUMBER
, 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
, OPM_ISSUANCE_DATE OPM_ISSUANCE_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PROCESS_TYPE PROCESS_TYPE
, LOCALITY_PAY_AREA_CODE LOCALITY_PAY_AREA_CODE
, NOA_CODE NOA_CODE
, NTE_DATE NTE_DATE
, TARGET_BARGAINING_UNIT_STATUS TARGET_BARGAINING_UNIT_STATUS
, TARGET_FLSA_CATEGORY TARGET_FLSA_CATEGORY
, TARGET_OCC_CODE TARGET_OCC_CODE
, TARGET_AGENCY_CODE_SUBELEMENT TARGET_AGENCY_CODE_SUBELEMENT
, TARGET_DUTY_STATION_ID TARGET_DUTY_STATION_ID
, TARGET_DUTY_STATION_CODE TARGET_DUTY_STATION_CODE
, TARGET_JOB_ID TARGET_JOB_ID
, TARGET_FUNCTIONAL_CLASS TARGET_FUNCTIONAL_CLASS
, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS
, JOB_ID JOB_ID
, FLSA_CATEGORY FLSA_CATEGORY
, TARGET_MASS_ACTION_ID TARGET_MASS_ACTION_ID
, TARGET_MASS_ACTION_TYPE TARGET_MASS_ACTION_TYPE
FROM "HR"."GHR_MASS_SALARIES"