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_PEOPLE_EI_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 PERSON_EXTRA_INFO_ID
, INFORMATION8 PERSON_ID
, INFORMATION9 INFORMATION_TYPE
, INFORMATION10 REQUEST_ID
, INFORMATION11 PROGRAM_APPLICATION_ID
, INFORMATION12 PROGRAM_ID
, INFORMATION13 PROGRAM_UPDATE_DATE
, INFORMATION14 PEI_ATTRIBUTE_CATEGORY
, INFORMATION15 PEI_ATTRIBUTE1
, INFORMATION16 PEI_ATTRIBUTE2
, INFORMATION17 PEI_ATTRIBUTE3
, INFORMATION18 PEI_ATTRIBUTE4
, INFORMATION19 PEI_ATTRIBUTE5
, INFORMATION20 PEI_ATTRIBUTE6
, INFORMATION21 PEI_ATTRIBUTE7
, INFORMATION22 PEI_ATTRIBUTE8
, INFORMATION23 PEI_ATTRIBUTE9
, INFORMATION24 PEI_ATTRIBUTE10
, INFORMATION25 PEI_ATTRIBUTE11
, INFORMATION26 PEI_ATTRIBUTE12
, INFORMATION27 PEI_ATTRIBUTE13
, INFORMATION28 PEI_ATTRIBUTE14
, INFORMATION29 PEI_ATTRIBUTE15
, INFORMATION30 PEI_ATTRIBUTE16
, INFORMATION31 PEI_ATTRIBUTE17
, INFORMATION32 PEI_ATTRIBUTE18
, INFORMATION33 PEI_ATTRIBUTE19
, INFORMATION34 PEI_ATTRIBUTE20
, INFORMATION35 PEI_INFORMATION_CATEGORY
, INFORMATION36 PEI_INFORMATION1
, INFORMATION37 PEI_INFORMATION2
, INFORMATION38 PEI_INFORMATION3
, INFORMATION39 PEI_INFORMATION4
, INFORMATION40 PEI_INFORMATION5
, INFORMATION41 PEI_INFORMATION6
, INFORMATION42 PEI_INFORMATION7
, INFORMATION43 PEI_INFORMATION8
, INFORMATION44 PEI_INFORMATION9
, INFORMATION45 PEI_INFORMATION10
, INFORMATION46 PEI_INFORMATION11
, INFORMATION47 PEI_INFORMATION12
, INFORMATION48 PEI_INFORMATION13
, INFORMATION49 PEI_INFORMATION14
, INFORMATION50 PEI_INFORMATION15
, INFORMATION51 PEI_INFORMATION16
, INFORMATION52 PEI_INFORMATION17
, INFORMATION53 PEI_INFORMATION18
, INFORMATION54 PEI_INFORMATION19
, INFORMATION55 PEI_INFORMATION20
, INFORMATION56 PEI_INFORMATION21
, INFORMATION57 PEI_INFORMATION22
, INFORMATION58 PEI_INFORMATION23
, INFORMATION59 PEI_INFORMATION24
, INFORMATION60 PEI_INFORMATION25
, INFORMATION61 PEI_INFORMATION26
, INFORMATION62 PEI_INFORMATION27
, INFORMATION63 PEI_INFORMATION28
, INFORMATION64 PEI_INFORMATION29
, INFORMATION65 PEI_INFORMATION30
, INFORMATION66 OBJECT_VERSION_NUMBER
, INFORMATION67 LAST_UPDATE_DATE
, INFORMATION68 LAST_UPDATED_BY
, INFORMATION69 LAST_UPDATE_LOGIN
, INFORMATION70 CREATED_BY
, INFORMATION71 CREATION_DATE
, INFORMATION75 INFO3_MEANING
, INFORMATION76 INFO4_MEANING
, INFORMATION77 INFO5_MEANING
, INFORMATION78 INFO6_MEANING
, INFORMATION79 INFO7_MEANING
, INFORMATION80 INFO8_MEANING
, INFORMATION81 INFO9_MEANING
, INFORMATION82 INFO10_MEANING
, INFORMATION83 INFO11_MEANING
, INFORMATION84 INFO12_MEANING
, INFORMATION85 INFO13_MEANING
, INFORMATION86 INFO14_MEANING
, INFORMATION87 INFO15_MEANING
, INFORMATION88 INFO16_MEANING
, INFORMATION89 INFO17_MEANING
, INFORMATION90 INFO18_MEANING
, INFORMATION91 INFO19_MEANING
, INFORMATION92 INFO20_MEANING
, INFORMATION93 INFO21_MEANING
, INFORMATION94 INFO22_MEANING
, INFORMATION95 INFO23_MEANING
, INFORMATION96 INFO24_MEANING
, INFORMATION97 INFO25_MEANING
, INFORMATION98 INFO26_MEANING
, INFORMATION99 INFO27_MEANING
, INFORMATION100 INFO28_MEANING
, INFORMATION101 INFO29_MEANING
, INFORMATION102 INFO30_MEANING
, INFORMATION103 INFO31_MEANING
, INFORMATION104 INFO32_MEANING
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_PEOPLE_EXTRA_INFO'