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: APPS.GHR_MT_MISC_V

Source

View Text - Preformatted


SELECT INTERFACE_ID GHR_INTERFACE_ID , PROCESS_DATE MT_PROCESS_DATE , SOURCE_NAME MT_SOURCE , DATE_FROM MT_EFFECTIVE_DATE , INFORMATION1 MT_NAME , INFORMATION2 MT_STATUS , INFORMATION3 MT_PERSON_ID , INFORMATION4 MT_TABLE_NAME , INFORMATION5 MT_INFORMATION_TYPE , INFORMATION6 MT_INTER_BG_TRANSFER , INFORMATION7 FROM_GRADE_OR_LEVEL , INFORMATION8 FROM_PAY_PLAN , INFORMATION9 FROM_POSITION_TITLE , INFORMATION10 FROM_POSITION_SEQ_NUM , INFORMATION11 FROM_POSITION_DESC_NUM , INFORMATION12 FROM_POSITION_ID , INFORMATION13 FROM_AGENCY_CODE , INFORMATION14 OCC_SERIES , INFORMATION15 TO_POSITION_ID , INFORMATION16 DUTY_STATION_DESC , INFORMATION17 DUTY_STATION_CODE , INFORMATION18 FROM_AGENCY_CODE_DESC FROM GHR_INTERFACE WHERE INFORMATION4 = 'MISCELANEOUS'

View Text - HTML Formatted

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 FROM_GRADE_OR_LEVEL
, INFORMATION8 FROM_PAY_PLAN
, INFORMATION9 FROM_POSITION_TITLE
, INFORMATION10 FROM_POSITION_SEQ_NUM
, INFORMATION11 FROM_POSITION_DESC_NUM
, INFORMATION12 FROM_POSITION_ID
, INFORMATION13 FROM_AGENCY_CODE
, INFORMATION14 OCC_SERIES
, INFORMATION15 TO_POSITION_ID
, INFORMATION16 DUTY_STATION_DESC
, INFORMATION17 DUTY_STATION_CODE
, INFORMATION18 FROM_AGENCY_CODE_DESC
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'MISCELANEOUS'