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

Source

View Text - Preformatted


select MASS_NOA_PREVIEW_ID MASS_NOA_PREVIEW_ID, SESSION_ID SESSION_ID, EFFECTIVE_DATE EFFECTIVE_DATE, UI_TYPE UI_TYPE, MASS_ACTION_TYPE MASS_ACTION_TYPE, PERSON_ID PERSON_ID, FULL_NAME FULL_NAME, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, POSITION_TITLE POSITION_TITLE, POSITION_ID POSITION_ID, POSITION_NUMBER POSITION_NUMBER, POSITION_SEQ_NO POSITION_SEQ_NO, NOA_CODE NOA_CODE, AGENCY_CODE AGENCY_CODE, TO_AGENCY_CODE TO_AGENCY_CODE, OLD_ASSIGNMENT_STATUS OLD_ASSIGNMENT_STATUS, NEW_ASSIGNMENT_STATUS NEW_ASSIGNMENT_STATUS, OLD_TYPE_OF_EMPLOYMENT OLD_TYPE_OF_EMPLOYMENT, NEW_TYPE_OF_EMPLOYMENT NEW_TYPE_OF_EMPLOYMENT, OLD_PAY_USERRA_STATUS OLD_PAY_USERRA_STATUS, NEW_PAY_USERRA_STATUS NEW_PAY_USERRA_STATUS, DUTY_STATION_ID DUTY_STATION_ID, DUTY_STATION_CODE DUTY_STATION_CODE, DUTY_STATION_DESC DUTY_STATION_DESC, TO_DUTY_STATION_ID TO_DUTY_STATION_ID, TO_DUTY_STATION_CODE TO_DUTY_STATION_CODE, TO_DUTY_STATION_DESC TO_DUTY_STATION_DESC, FROM_BASIC_PAY FROM_BASIC_PAY, TO_BASIC_PAY TO_BASIC_PAY, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ, TO_LOCALITY_ADJ TO_LOCALITY_ADJ, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY, FROM_TOTAL_SALARY FROM_TOTAL_SALARY, TO_TOTAL_SALARY TO_TOTAL_SALARY, OCC_CODE OCC_CODE, TO_OCC_CODE TO_OCC_CODE, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID, POI_DESC POI_DESC, FROM_BARGAINING_UNIT_STATUS FROM_BARGAINING_UNIT_STATUS, TO_BARGAINING_UNIT_STATUS TO_BARGAINING_UNIT_STATUS, FROM_FLSA_CATEGORY FROM_FLSA_CATEGORY, TO_FLSA_CATEGORY TO_FLSA_CATEGORY, FROM_FUNCTIONAL_CLASS FROM_FUNCTIONAL_CLASS, TO_FUNCTIONAL_CLASS TO_FUNCTIONAL_CLASS, SELECT_FLAG SELECT_FLAG, FURLOUGH_INDICATOR FURLOUGH_INDICATOR, OLD_LWOP_NTE_START_DATE OLD_LWOP_NTE_START_DATE, NEW_LWOP_NTE_START_DATE NEW_LWOP_NTE_START_DATE, OLD_LWOP_NTE OLD_LWOP_NTE, NEW_LWOP_NTE NEW_LWOP_NTE, OLD_FURLOUGH_NTE_START_DATE OLD_FURLOUGH_NTE_START_DATE, NEW_FURLOUGH_NTE_START_DATE NEW_FURLOUGH_NTE_START_DATE, OLD_FURLOUGH_NTE OLD_FURLOUGH_NTE, NEW_FURLOUGH_NTE NEW_FURLOUGH_NTE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, USER_ATTRIBUTE16 USER_ATTRIBUTE16, USER_ATTRIBUTE17 USER_ATTRIBUTE17, USER_ATTRIBUTE18 USER_ATTRIBUTE18, USER_ATTRIBUTE19 USER_ATTRIBUTE19, USER_ATTRIBUTE20 USER_ATTRIBUTE20, USER_ATTRIBUTE21 USER_ATTRIBUTE21, USER_ATTRIBUTE22 USER_ATTRIBUTE22, USER_ATTRIBUTE23 USER_ATTRIBUTE23, USER_ATTRIBUTE24 USER_ATTRIBUTE24, USER_ATTRIBUTE25 USER_ATTRIBUTE25, USER_ATTRIBUTE26 USER_ATTRIBUTE26, USER_ATTRIBUTE27 USER_ATTRIBUTE27, USER_ATTRIBUTE28 USER_ATTRIBUTE28, USER_ATTRIBUTE29 USER_ATTRIBUTE29, USER_ATTRIBUTE30 USER_ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY from "HR"."GHR_MASS_NOA_PREVIEW"

View Text - HTML Formatted

SELECT MASS_NOA_PREVIEW_ID MASS_NOA_PREVIEW_ID
, SESSION_ID SESSION_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, UI_TYPE UI_TYPE
, MASS_ACTION_TYPE MASS_ACTION_TYPE
, PERSON_ID PERSON_ID
, FULL_NAME FULL_NAME
, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, POSITION_TITLE POSITION_TITLE
, POSITION_ID POSITION_ID
, POSITION_NUMBER POSITION_NUMBER
, POSITION_SEQ_NO POSITION_SEQ_NO
, NOA_CODE NOA_CODE
, AGENCY_CODE AGENCY_CODE
, TO_AGENCY_CODE TO_AGENCY_CODE
, OLD_ASSIGNMENT_STATUS OLD_ASSIGNMENT_STATUS
, NEW_ASSIGNMENT_STATUS NEW_ASSIGNMENT_STATUS
, OLD_TYPE_OF_EMPLOYMENT OLD_TYPE_OF_EMPLOYMENT
, NEW_TYPE_OF_EMPLOYMENT NEW_TYPE_OF_EMPLOYMENT
, OLD_PAY_USERRA_STATUS OLD_PAY_USERRA_STATUS
, NEW_PAY_USERRA_STATUS NEW_PAY_USERRA_STATUS
, DUTY_STATION_ID DUTY_STATION_ID
, DUTY_STATION_CODE DUTY_STATION_CODE
, DUTY_STATION_DESC DUTY_STATION_DESC
, TO_DUTY_STATION_ID TO_DUTY_STATION_ID
, TO_DUTY_STATION_CODE TO_DUTY_STATION_CODE
, TO_DUTY_STATION_DESC TO_DUTY_STATION_DESC
, FROM_BASIC_PAY FROM_BASIC_PAY
, TO_BASIC_PAY TO_BASIC_PAY
, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ
, TO_LOCALITY_ADJ TO_LOCALITY_ADJ
, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY
, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY
, FROM_TOTAL_SALARY FROM_TOTAL_SALARY
, TO_TOTAL_SALARY TO_TOTAL_SALARY
, OCC_CODE OCC_CODE
, TO_OCC_CODE TO_OCC_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, POI_DESC POI_DESC
, FROM_BARGAINING_UNIT_STATUS FROM_BARGAINING_UNIT_STATUS
, TO_BARGAINING_UNIT_STATUS TO_BARGAINING_UNIT_STATUS
, FROM_FLSA_CATEGORY FROM_FLSA_CATEGORY
, TO_FLSA_CATEGORY TO_FLSA_CATEGORY
, FROM_FUNCTIONAL_CLASS FROM_FUNCTIONAL_CLASS
, TO_FUNCTIONAL_CLASS TO_FUNCTIONAL_CLASS
, SELECT_FLAG SELECT_FLAG
, FURLOUGH_INDICATOR FURLOUGH_INDICATOR
, OLD_LWOP_NTE_START_DATE OLD_LWOP_NTE_START_DATE
, NEW_LWOP_NTE_START_DATE NEW_LWOP_NTE_START_DATE
, OLD_LWOP_NTE OLD_LWOP_NTE
, NEW_LWOP_NTE NEW_LWOP_NTE
, OLD_FURLOUGH_NTE_START_DATE OLD_FURLOUGH_NTE_START_DATE
, NEW_FURLOUGH_NTE_START_DATE NEW_FURLOUGH_NTE_START_DATE
, OLD_FURLOUGH_NTE OLD_FURLOUGH_NTE
, NEW_FURLOUGH_NTE NEW_FURLOUGH_NTE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, USER_ATTRIBUTE16 USER_ATTRIBUTE16
, USER_ATTRIBUTE17 USER_ATTRIBUTE17
, USER_ATTRIBUTE18 USER_ATTRIBUTE18
, USER_ATTRIBUTE19 USER_ATTRIBUTE19
, USER_ATTRIBUTE20 USER_ATTRIBUTE20
, USER_ATTRIBUTE21 USER_ATTRIBUTE21
, USER_ATTRIBUTE22 USER_ATTRIBUTE22
, USER_ATTRIBUTE23 USER_ATTRIBUTE23
, USER_ATTRIBUTE24 USER_ATTRIBUTE24
, USER_ATTRIBUTE25 USER_ATTRIBUTE25
, USER_ATTRIBUTE26 USER_ATTRIBUTE26
, USER_ATTRIBUTE27 USER_ATTRIBUTE27
, USER_ATTRIBUTE28 USER_ATTRIBUTE28
, USER_ATTRIBUTE29 USER_ATTRIBUTE29
, USER_ATTRIBUTE30 USER_ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "HR"."GHR_MASS_NOA_PREVIEW"