View: GHR_MT_MISC_V

Product:	GHR - US Federal Human Resources
Description:	This views is used by mass transfer in and out processes for datatransfer.
Implementation/DBA Data:	APPS.GHR_MT_MISC_V

View Text

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'

Columns