VIEW: HR.PER_CONTACT_EXTRA_INFO_F#

Source

View Text - Preformatted

select CONTACT_EXTRA_INFO_ID CONTACT_EXTRA_INFO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, CONTACT_RELATIONSHIP_ID CONTACT_RELATIONSHIP_ID, INFORMATION_TYPE INFORMATION_TYPE, CEI_INFORMATION_CATEGORY CEI_INFORMATION_CATEGORY, CEI_INFORMATION1 CEI_INFORMATION1, CEI_INFORMATION2 CEI_INFORMATION2, CEI_INFORMATION3 CEI_INFORMATION3, CEI_INFORMATION4 CEI_INFORMATION4, CEI_INFORMATION5 CEI_INFORMATION5, CEI_INFORMATION6 CEI_INFORMATION6, CEI_INFORMATION7 CEI_INFORMATION7, CEI_INFORMATION8 CEI_INFORMATION8, CEI_INFORMATION9 CEI_INFORMATION9, CEI_INFORMATION10 CEI_INFORMATION10, CEI_INFORMATION11 CEI_INFORMATION11, CEI_INFORMATION12 CEI_INFORMATION12, CEI_INFORMATION13 CEI_INFORMATION13, CEI_INFORMATION14 CEI_INFORMATION14, CEI_INFORMATION15 CEI_INFORMATION15, CEI_INFORMATION16 CEI_INFORMATION16, CEI_INFORMATION17 CEI_INFORMATION17, CEI_INFORMATION18 CEI_INFORMATION18, CEI_INFORMATION19 CEI_INFORMATION19, CEI_INFORMATION20 CEI_INFORMATION20, CEI_INFORMATION21 CEI_INFORMATION21, CEI_INFORMATION22 CEI_INFORMATION22, CEI_INFORMATION23 CEI_INFORMATION23, CEI_INFORMATION24 CEI_INFORMATION24, CEI_INFORMATION25 CEI_INFORMATION25, CEI_INFORMATION26 CEI_INFORMATION26, CEI_INFORMATION27 CEI_INFORMATION27, CEI_INFORMATION28 CEI_INFORMATION28, CEI_INFORMATION29 CEI_INFORMATION29, CEI_INFORMATION30 CEI_INFORMATION30, CEI_ATTRIBUTE_CATEGORY CEI_ATTRIBUTE_CATEGORY, CEI_ATTRIBUTE1 CEI_ATTRIBUTE1, CEI_ATTRIBUTE2 CEI_ATTRIBUTE2, CEI_ATTRIBUTE3 CEI_ATTRIBUTE3, CEI_ATTRIBUTE4 CEI_ATTRIBUTE4, CEI_ATTRIBUTE5 CEI_ATTRIBUTE5, CEI_ATTRIBUTE6 CEI_ATTRIBUTE6, CEI_ATTRIBUTE7 CEI_ATTRIBUTE7, CEI_ATTRIBUTE8 CEI_ATTRIBUTE8, CEI_ATTRIBUTE9 CEI_ATTRIBUTE9, CEI_ATTRIBUTE10 CEI_ATTRIBUTE10, CEI_ATTRIBUTE11 CEI_ATTRIBUTE11, CEI_ATTRIBUTE12 CEI_ATTRIBUTE12, CEI_ATTRIBUTE13 CEI_ATTRIBUTE13, CEI_ATTRIBUTE14 CEI_ATTRIBUTE14, CEI_ATTRIBUTE15 CEI_ATTRIBUTE15, CEI_ATTRIBUTE16 CEI_ATTRIBUTE16, CEI_ATTRIBUTE17 CEI_ATTRIBUTE17, CEI_ATTRIBUTE18 CEI_ATTRIBUTE18, CEI_ATTRIBUTE19 CEI_ATTRIBUTE19, CEI_ATTRIBUTE20 CEI_ATTRIBUTE20, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "HR"."PER_CONTACT_EXTRA_INFO_F"

View Text - HTML Formatted

SELECT CONTACT_EXTRA_INFO_ID CONTACT_EXTRA_INFO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CONTACT_RELATIONSHIP_ID CONTACT_RELATIONSHIP_ID
, INFORMATION_TYPE INFORMATION_TYPE
, CEI_INFORMATION_CATEGORY CEI_INFORMATION_CATEGORY
, CEI_INFORMATION1 CEI_INFORMATION1
, CEI_INFORMATION2 CEI_INFORMATION2
, CEI_INFORMATION3 CEI_INFORMATION3
, CEI_INFORMATION4 CEI_INFORMATION4
, CEI_INFORMATION5 CEI_INFORMATION5
, CEI_INFORMATION6 CEI_INFORMATION6
, CEI_INFORMATION7 CEI_INFORMATION7
, CEI_INFORMATION8 CEI_INFORMATION8
, CEI_INFORMATION9 CEI_INFORMATION9
, CEI_INFORMATION10 CEI_INFORMATION10
, CEI_INFORMATION11 CEI_INFORMATION11
, CEI_INFORMATION12 CEI_INFORMATION12
, CEI_INFORMATION13 CEI_INFORMATION13
, CEI_INFORMATION14 CEI_INFORMATION14
, CEI_INFORMATION15 CEI_INFORMATION15
, CEI_INFORMATION16 CEI_INFORMATION16
, CEI_INFORMATION17 CEI_INFORMATION17
, CEI_INFORMATION18 CEI_INFORMATION18
, CEI_INFORMATION19 CEI_INFORMATION19
, CEI_INFORMATION20 CEI_INFORMATION20
, CEI_INFORMATION21 CEI_INFORMATION21
, CEI_INFORMATION22 CEI_INFORMATION22
, CEI_INFORMATION23 CEI_INFORMATION23
, CEI_INFORMATION24 CEI_INFORMATION24
, CEI_INFORMATION25 CEI_INFORMATION25
, CEI_INFORMATION26 CEI_INFORMATION26
, CEI_INFORMATION27 CEI_INFORMATION27
, CEI_INFORMATION28 CEI_INFORMATION28
, CEI_INFORMATION29 CEI_INFORMATION29
, CEI_INFORMATION30 CEI_INFORMATION30
, CEI_ATTRIBUTE_CATEGORY CEI_ATTRIBUTE_CATEGORY
, CEI_ATTRIBUTE1 CEI_ATTRIBUTE1
, CEI_ATTRIBUTE2 CEI_ATTRIBUTE2
, CEI_ATTRIBUTE3 CEI_ATTRIBUTE3
, CEI_ATTRIBUTE4 CEI_ATTRIBUTE4
, CEI_ATTRIBUTE5 CEI_ATTRIBUTE5
, CEI_ATTRIBUTE6 CEI_ATTRIBUTE6
, CEI_ATTRIBUTE7 CEI_ATTRIBUTE7
, CEI_ATTRIBUTE8 CEI_ATTRIBUTE8
, CEI_ATTRIBUTE9 CEI_ATTRIBUTE9
, CEI_ATTRIBUTE10 CEI_ATTRIBUTE10
, CEI_ATTRIBUTE11 CEI_ATTRIBUTE11
, CEI_ATTRIBUTE12 CEI_ATTRIBUTE12
, CEI_ATTRIBUTE13 CEI_ATTRIBUTE13
, CEI_ATTRIBUTE14 CEI_ATTRIBUTE14
, CEI_ATTRIBUTE15 CEI_ATTRIBUTE15
, CEI_ATTRIBUTE16 CEI_ATTRIBUTE16
, CEI_ATTRIBUTE17 CEI_ATTRIBUTE17
, CEI_ATTRIBUTE18 CEI_ATTRIBUTE18
, CEI_ATTRIBUTE19 CEI_ATTRIBUTE19
, CEI_ATTRIBUTE20 CEI_ATTRIBUTE20
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "HR"."PER_CONTACT_EXTRA_INFO_F"