PER_PEOPLE_EXTRA_INFO

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PERSON_EXTRA_INFO_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE PERSON_ID INFORMATION_TYPE PEI_ATTRIBUTE_CATEGORY PEI_ATTRIBUTE1 PEI_ATTRIBUTE2 PEI_ATTRIBUTE3 PEI_ATTRIBUTE4 PEI_ATTRIBUTE5 PEI_ATTRIBUTE6 PEI_ATTRIBUTE7 PEI_ATTRIBUTE8 PEI_ATTRIBUTE9 PEI_ATTRIBUTE10 PEI_ATTRIBUTE11 PEI_ATTRIBUTE12 PEI_ATTRIBUTE13 PEI_ATTRIBUTE14 PEI_ATTRIBUTE15 PEI_ATTRIBUTE16 PEI_ATTRIBUTE17 PEI_ATTRIBUTE18 PEI_ATTRIBUTE19 PEI_ATTRIBUTE20 PEI_ATTRIBUTE21 PEI_ATTRIBUTE22 PEI_ATTRIBUTE23 PEI_ATTRIBUTE24 PEI_ATTRIBUTE25 PEI_ATTRIBUTE26 PEI_ATTRIBUTE27 PEI_ATTRIBUTE28 PEI_ATTRIBUTE29 PEI_ATTRIBUTE30 PEI_INFORMATION_CATEGORY PEI_INFORMATION1 PEI_INFORMATION2 PEI_INFORMATION3 PEI_INFORMATION4 PEI_INFORMATION5 PEI_INFORMATION6 PEI_INFORMATION7 PEI_INFORMATION8 PEI_INFORMATION9 PEI_INFORMATION10 PEI_INFORMATION11 PEI_INFORMATION12 PEI_INFORMATION13 PEI_INFORMATION14 PEI_INFORMATION15 PEI_INFORMATION16 PEI_INFORMATION17 PEI_INFORMATION18 PEI_INFORMATION19 PEI_INFORMATION20 PEI_INFORMATION21 PEI_INFORMATION22 PEI_INFORMATION23 PEI_INFORMATION24 PEI_INFORMATION25 PEI_INFORMATION26 PEI_INFORMATION27 PEI_INFORMATION28 PEI_INFORMATION29 PEI_INFORMATION30 PEI_INFORMATION_NUMBER1 PEI_INFORMATION_NUMBER2 PEI_INFORMATION_NUMBER3 PEI_INFORMATION_NUMBER4 PEI_INFORMATION_NUMBER5 PEI_INFORMATION_NUMBER6 PEI_INFORMATION_NUMBER7 PEI_INFORMATION_NUMBER8 PEI_INFORMATION_NUMBER9 PEI_INFORMATION_NUMBER10 PEI_INFORMATION_NUMBER11 PEI_INFORMATION_NUMBER12 PEI_INFORMATION_NUMBER13 PEI_INFORMATION_NUMBER14 PEI_INFORMATION_NUMBER15 PEI_INFORMATION_NUMBER16 PEI_INFORMATION_NUMBER17 PEI_INFORMATION_NUMBER18 PEI_INFORMATION_NUMBER19 PEI_INFORMATION_NUMBER20 PEI_INFORMATION_DATE1 PEI_INFORMATION_DATE2 PEI_INFORMATION_DATE3 PEI_INFORMATION_DATE4 PEI_INFORMATION_DATE5 PEI_INFORMATION_DATE6 PEI_INFORMATION_DATE7 PEI_INFORMATION_DATE8 PEI_INFORMATION_DATE9 PEI_INFORMATION_DATE10 PEI_INFORMATION_DATE11 PEI_INFORMATION_DATE12 PEI_INFORMATION_DATE13 PEI_INFORMATION_DATE14 PEI_INFORMATION_DATE15 OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE

Query

SQL_Statement

SELECT PERSON_EXTRA_INFO_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PERSON_ID, INFORMATION_TYPE, PEI_ATTRIBUTE_CATEGORY, PEI_ATTRIBUTE1, PEI_ATTRIBUTE2, PEI_ATTRIBUTE3, PEI_ATTRIBUTE4, PEI_ATTRIBUTE5, PEI_ATTRIBUTE6, PEI_ATTRIBUTE7, PEI_ATTRIBUTE8, PEI_ATTRIBUTE9, PEI_ATTRIBUTE10, PEI_ATTRIBUTE11, PEI_ATTRIBUTE12, PEI_ATTRIBUTE13, PEI_ATTRIBUTE14, PEI_ATTRIBUTE15, PEI_ATTRIBUTE16, PEI_ATTRIBUTE17, PEI_ATTRIBUTE18, PEI_ATTRIBUTE19, PEI_ATTRIBUTE20, PEI_ATTRIBUTE21, PEI_ATTRIBUTE22, PEI_ATTRIBUTE23, PEI_ATTRIBUTE24, PEI_ATTRIBUTE25, PEI_ATTRIBUTE26, PEI_ATTRIBUTE27, PEI_ATTRIBUTE28, PEI_ATTRIBUTE29, PEI_ATTRIBUTE30, PEI_INFORMATION_CATEGORY, PEI_INFORMATION1, PEI_INFORMATION2, PEI_INFORMATION3, PEI_INFORMATION4, PEI_INFORMATION5, PEI_INFORMATION6, PEI_INFORMATION7, PEI_INFORMATION8, PEI_INFORMATION9, PEI_INFORMATION10, PEI_INFORMATION11, PEI_INFORMATION12, PEI_INFORMATION13, PEI_INFORMATION14, PEI_INFORMATION15, PEI_INFORMATION16, PEI_INFORMATION17, PEI_INFORMATION18, PEI_INFORMATION19, PEI_INFORMATION20, PEI_INFORMATION21, PEI_INFORMATION22, PEI_INFORMATION23, PEI_INFORMATION24, PEI_INFORMATION25, PEI_INFORMATION26, PEI_INFORMATION27, PEI_INFORMATION28, PEI_INFORMATION29, PEI_INFORMATION30, PEI_INFORMATION_NUMBER1, PEI_INFORMATION_NUMBER2, PEI_INFORMATION_NUMBER3, PEI_INFORMATION_NUMBER4, PEI_INFORMATION_NUMBER5, PEI_INFORMATION_NUMBER6, PEI_INFORMATION_NUMBER7, PEI_INFORMATION_NUMBER8, PEI_INFORMATION_NUMBER9, PEI_INFORMATION_NUMBER10, PEI_INFORMATION_NUMBER11, PEI_INFORMATION_NUMBER12, PEI_INFORMATION_NUMBER13, PEI_INFORMATION_NUMBER14, PEI_INFORMATION_NUMBER15, PEI_INFORMATION_NUMBER16, PEI_INFORMATION_NUMBER17, PEI_INFORMATION_NUMBER18, PEI_INFORMATION_NUMBER19, PEI_INFORMATION_NUMBER20, PEI_INFORMATION_DATE1, PEI_INFORMATION_DATE2, PEI_INFORMATION_DATE3, PEI_INFORMATION_DATE4, PEI_INFORMATION_DATE5, PEI_INFORMATION_DATE6, PEI_INFORMATION_DATE7, PEI_INFORMATION_DATE8, PEI_INFORMATION_DATE9, PEI_INFORMATION_DATE10, PEI_INFORMATION_DATE11, PEI_INFORMATION_DATE12, PEI_INFORMATION_DATE13, PEI_INFORMATION_DATE14, PEI_INFORMATION_DATE15, OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE FROM PER_PEOPLE_EXTRA_INFO_F WHERE sysdate BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE