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_POSITION_DEFINITIONS_V |
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 POSITION_DEFINITION_ID
, INFORMATION8 ID_FLEX_NUM
, INFORMATION9 SUMMARY_FLAG
, INFORMATION10 ENABLED_FLAG
, INFORMATION11 START_DATE_ACTIVE
, INFORMATION12 END_DATE_ACTIVE
, INFORMATION13 SEGMENT1
, INFORMATION14 SEGMENT2
, INFORMATION15 SEGMENT3
, INFORMATION16 SEGMENT4
, INFORMATION17 SEGMENT5
, INFORMATION18 SEGMENT6
, INFORMATION19 SEGMENT7
, INFORMATION20 SEGMENT8
, INFORMATION21 SEGMENT9
, INFORMATION22 SEGMENT10
, INFORMATION23 SEGMENT11
, INFORMATION24 SEGMENT12
, INFORMATION25 SEGMENT13
, INFORMATION26 SEGMENT14
, INFORMATION27 SEGMENT15
, INFORMATION28 SEGMENT16
, INFORMATION29 SEGMENT17
, INFORMATION30 SEGMENT18
, INFORMATION31 SEGMENT19
, INFORMATION32 SEGMENT20
, INFORMATION33 SEGMENT21
, INFORMATION34 SEGMENT22
, INFORMATION35 SEGMENT23
, INFORMATION36 SEGMENT24
, INFORMATION37 SEGMENT25
, INFORMATION38 SEGMENT26
, INFORMATION39 SEGMENT27
, INFORMATION40 SEGMENT28
, INFORMATION41 SEGMENT29
, INFORMATION42 SEGMENT30
, INFORMATION43 LAST_UPDATE_DATE
, INFORMATION44 LAST_UPDATED_BY
, INFORMATION45 LAST_UPDATE_LOGIN
, INFORMATION46 CREATED_BY
, INFORMATION47 CREATION_DATE
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_POSITION_DEFINITIONS'