PER_PERSON_NAMES_F_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PERSON_NAME_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE PERSON_ID BUSINESS_GROUP_ID NAME_TYPE LAST_NAME FIRST_NAME MIDDLE_NAMES TITLE PRE_NAME_ADJUNCT SUFFIX KNOWN_AS PREVIOUS_LAST_NAME HONORS MILITARY_RANK DISPLAY_NAME FULL_NAME LIST_NAME ORDER_NAME LEGISLATION_CODE NAM_INFORMATION_CATEGORY NAM_INFORMATION1 NAM_INFORMATION2 NAM_INFORMATION3 NAM_INFORMATION4 NAM_INFORMATION5 NAM_INFORMATION6 NAM_INFORMATION7 NAM_INFORMATION8 NAM_INFORMATION9 NAM_INFORMATION10 NAM_INFORMATION11 NAM_INFORMATION12 NAM_INFORMATION13 NAM_INFORMATION14 NAM_INFORMATION15 NAM_INFORMATION16 NAM_INFORMATION17 NAM_INFORMATION18 NAM_INFORMATION19 NAM_INFORMATION20 NAM_INFORMATION21 NAM_INFORMATION22 NAM_INFORMATION23 NAM_INFORMATION24 NAM_INFORMATION25 NAM_INFORMATION26 NAM_INFORMATION27 NAM_INFORMATION28 NAM_INFORMATION29 NAM_INFORMATION30 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY CHAR_SET_CONTEXT PERSON_ID2 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 NAM_INFORMATION_NUMBER1 NAM_INFORMATION_NUMBER2 NAM_INFORMATION_NUMBER3 NAM_INFORMATION_NUMBER4 NAM_INFORMATION_NUMBER5 NAM_INFORMATION_NUMBER6 NAM_INFORMATION_NUMBER7 NAM_INFORMATION_NUMBER8 NAM_INFORMATION_NUMBER9 NAM_INFORMATION_NUMBER10 NAM_INFORMATION_NUMBER11 NAM_INFORMATION_NUMBER12 NAM_INFORMATION_NUMBER13 NAM_INFORMATION_NUMBER14 NAM_INFORMATION_NUMBER15 NAM_INFORMATION_NUMBER16 NAM_INFORMATION_NUMBER17 NAM_INFORMATION_NUMBER18 NAM_INFORMATION_NUMBER19 NAM_INFORMATION_NUMBER20 NAM_INFORMATION_DATE1 NAM_INFORMATION_DATE2 NAM_INFORMATION_DATE3 NAM_INFORMATION_DATE4 NAM_INFORMATION_DATE5 NAM_INFORMATION_DATE6 NAM_INFORMATION_DATE7 NAM_INFORMATION_DATE8 NAM_INFORMATION_DATE9 NAM_INFORMATION_DATE10 NAM_INFORMATION_DATE11 NAM_INFORMATION_DATE12 NAM_INFORMATION_DATE13 NAM_INFORMATION_DATE14 NAM_INFORMATION_DATE15

Query

SQL_Statement

SELECT PERSON_NAME_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PERSON_ID, BUSINESS_GROUP_ID, NAME_TYPE, LAST_NAME, FIRST_NAME, MIDDLE_NAMES, TITLE, PRE_NAME_ADJUNCT, SUFFIX, KNOWN_AS, PREVIOUS_LAST_NAME, HONORS, MILITARY_RANK, DISPLAY_NAME, FULL_NAME, LIST_NAME, ORDER_NAME, LEGISLATION_CODE LEGISLATION_CODE, NAM_INFORMATION_CATEGORY, NAM_INFORMATION1, NAM_INFORMATION2, NAM_INFORMATION3, NAM_INFORMATION4, NAM_INFORMATION5, NAM_INFORMATION6, NAM_INFORMATION7, NAM_INFORMATION8, NAM_INFORMATION9, NAM_INFORMATION10, NAM_INFORMATION11, NAM_INFORMATION12, NAM_INFORMATION13, NAM_INFORMATION14, NAM_INFORMATION15, NAM_INFORMATION16, NAM_INFORMATION17, NAM_INFORMATION18, NAM_INFORMATION19, NAM_INFORMATION20, NAM_INFORMATION21, NAM_INFORMATION22, NAM_INFORMATION23, NAM_INFORMATION24, NAM_INFORMATION25, NAM_INFORMATION26, NAM_INFORMATION27, NAM_INFORMATION28, NAM_INFORMATION29, NAM_INFORMATION30, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, CHAR_SET_CONTEXT, PERSON_ID PERSON_ID2, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, ATTRIBUTE_NUMBER6, ATTRIBUTE_NUMBER7, ATTRIBUTE_NUMBER8, ATTRIBUTE_NUMBER9, ATTRIBUTE_NUMBER10, ATTRIBUTE_NUMBER11, ATTRIBUTE_NUMBER12, ATTRIBUTE_NUMBER13, ATTRIBUTE_NUMBER14, ATTRIBUTE_NUMBER15, ATTRIBUTE_NUMBER16, ATTRIBUTE_NUMBER17, ATTRIBUTE_NUMBER18, ATTRIBUTE_NUMBER19, ATTRIBUTE_NUMBER20, ATTRIBUTE_DATE1, ATTRIBUTE_DATE2, ATTRIBUTE_DATE3, ATTRIBUTE_DATE4, ATTRIBUTE_DATE5, ATTRIBUTE_DATE6, ATTRIBUTE_DATE7, ATTRIBUTE_DATE8, ATTRIBUTE_DATE9, ATTRIBUTE_DATE10, ATTRIBUTE_DATE11, ATTRIBUTE_DATE12, ATTRIBUTE_DATE13, ATTRIBUTE_DATE14, ATTRIBUTE_DATE15, NAM_INFORMATION_NUMBER1, NAM_INFORMATION_NUMBER2, NAM_INFORMATION_NUMBER3, NAM_INFORMATION_NUMBER4, NAM_INFORMATION_NUMBER5, NAM_INFORMATION_NUMBER6, NAM_INFORMATION_NUMBER7, NAM_INFORMATION_NUMBER8, NAM_INFORMATION_NUMBER9, NAM_INFORMATION_NUMBER10, NAM_INFORMATION_NUMBER11, NAM_INFORMATION_NUMBER12, NAM_INFORMATION_NUMBER13, NAM_INFORMATION_NUMBER14, NAM_INFORMATION_NUMBER15, NAM_INFORMATION_NUMBER16, NAM_INFORMATION_NUMBER17, NAM_INFORMATION_NUMBER18, NAM_INFORMATION_NUMBER19, NAM_INFORMATION_NUMBER20, NAM_INFORMATION_DATE1, NAM_INFORMATION_DATE2, NAM_INFORMATION_DATE3, NAM_INFORMATION_DATE4, NAM_INFORMATION_DATE5, NAM_INFORMATION_DATE6, NAM_INFORMATION_DATE7, NAM_INFORMATION_DATE8, NAM_INFORMATION_DATE9, NAM_INFORMATION_DATE10, NAM_INFORMATION_DATE11, NAM_INFORMATION_DATE12, NAM_INFORMATION_DATE13, NAM_INFORMATION_DATE14, NAM_INFORMATION_DATE15 FROM PER_PERSON_NAMES_F