PER_CONTACT_RELSHIPS_F_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

BENEFICIARY_FLAG BONDHOLDER_FLAG BUSINESS_GROUP_ID CONT_ATTRIBUTE_CATEGORY CONT_INFORMATION_CATEGORY CONTACT_PERSON_ID CONTACT_RELATIONSHIP_ID CONTACT_TYPE CREATED_BY CREATION_DATE DEPENDENT_FLAG END_LIFE_REASON_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER PERSON_ID PERSONAL_FLAG PRIMARY_CONTACT_FLAG RLTD_PER_RSDS_W_DSGNTR_FLAG SEQUENCE_NUMBER START_LIFE_REASON_ID THIRD_PARTY_PAY_FLAG CONT_ATTRIBUTE1 CONT_ATTRIBUTE2 CONT_ATTRIBUTE3 CONT_ATTRIBUTE4 CONT_ATTRIBUTE5 CONT_ATTRIBUTE6 CONT_ATTRIBUTE7 CONT_ATTRIBUTE8 CONT_ATTRIBUTE9 CONT_ATTRIBUTE10 CONT_ATTRIBUTE11 CONT_ATTRIBUTE12 CONT_ATTRIBUTE13 CONT_ATTRIBUTE14 CONT_ATTRIBUTE15 CONT_ATTRIBUTE16 CONT_ATTRIBUTE17 CONT_ATTRIBUTE18 CONT_ATTRIBUTE19 CONT_ATTRIBUTE20 CONT_INFORMATION1 CONT_INFORMATION2 CONT_INFORMATION3 CONT_INFORMATION4 CONT_INFORMATION5 CONT_INFORMATION6 CONT_INFORMATION7 CONT_INFORMATION8 CONT_INFORMATION9 CONT_INFORMATION10 CONT_INFORMATION11 CONT_INFORMATION12 CONT_INFORMATION13 CONT_INFORMATION14 CONT_INFORMATION15 CONT_INFORMATION16 CONT_INFORMATION17 CONT_INFORMATION18 CONT_INFORMATION19 CONT_INFORMATION20 EFFECTIVE_START_DATE EFFECTIVE_END_DATE EMERGENCY_CONTACT_FLAG CONT_ATTRIBUTE21 CONT_ATTRIBUTE22 CONT_ATTRIBUTE23 CONT_ATTRIBUTE24 CONT_ATTRIBUTE25 CONT_ATTRIBUTE26 CONT_ATTRIBUTE27 CONT_ATTRIBUTE28 CONT_ATTRIBUTE29 CONT_ATTRIBUTE30 CONT_ATTRIBUTE_NUMBER1 CONT_ATTRIBUTE_NUMBER2 CONT_ATTRIBUTE_NUMBER3 CONT_ATTRIBUTE_NUMBER4 CONT_ATTRIBUTE_NUMBER5 CONT_ATTRIBUTE_NUMBER6 CONT_ATTRIBUTE_NUMBER7 CONT_ATTRIBUTE_NUMBER8 CONT_ATTRIBUTE_NUMBER9 CONT_ATTRIBUTE_NUMBER10 CONT_ATTRIBUTE_NUMBER11 CONT_ATTRIBUTE_NUMBER12 CONT_ATTRIBUTE_NUMBER13 CONT_ATTRIBUTE_NUMBER14 CONT_ATTRIBUTE_NUMBER15 CONT_ATTRIBUTE_NUMBER16 CONT_ATTRIBUTE_NUMBER17 CONT_ATTRIBUTE_NUMBER18 CONT_ATTRIBUTE_NUMBER19 CONT_ATTRIBUTE_NUMBER20 CONT_ATTRIBUTE_DATE1 CONT_ATTRIBUTE_DATE2 CONT_ATTRIBUTE_DATE3 CONT_ATTRIBUTE_DATE4 CONT_ATTRIBUTE_DATE5 CONT_ATTRIBUTE_DATE6 CONT_ATTRIBUTE_DATE7 CONT_ATTRIBUTE_DATE8 CONT_ATTRIBUTE_DATE9 CONT_ATTRIBUTE_DATE10 CONT_ATTRIBUTE_DATE11 CONT_ATTRIBUTE_DATE12 CONT_ATTRIBUTE_DATE13 CONT_ATTRIBUTE_DATE14 CONT_ATTRIBUTE_DATE15 CONT_INFORMATION21 CONT_INFORMATION22 CONT_INFORMATION23 CONT_INFORMATION24 CONT_INFORMATION25 CONT_INFORMATION26 CONT_INFORMATION27 CONT_INFORMATION28 CONT_INFORMATION29 CONT_INFORMATION30 CONT_INFORMATION_NUMBER1 CONT_INFORMATION_NUMBER2 CONT_INFORMATION_NUMBER3 CONT_INFORMATION_NUMBER4 CONT_INFORMATION_NUMBER5 CONT_INFORMATION_NUMBER6 CONT_INFORMATION_NUMBER7 CONT_INFORMATION_NUMBER8 CONT_INFORMATION_NUMBER9 CONT_INFORMATION_NUMBER10 CONT_INFORMATION_NUMBER11 CONT_INFORMATION_NUMBER12 CONT_INFORMATION_NUMBER13 CONT_INFORMATION_NUMBER14 CONT_INFORMATION_NUMBER15 CONT_INFORMATION_NUMBER16 CONT_INFORMATION_NUMBER17 CONT_INFORMATION_NUMBER18 CONT_INFORMATION_NUMBER19 CONT_INFORMATION_NUMBER20 CONT_INFORMATION_DATE1 CONT_INFORMATION_DATE2 CONT_INFORMATION_DATE3 CONT_INFORMATION_DATE4 CONT_INFORMATION_DATE5 CONT_INFORMATION_DATE6 CONT_INFORMATION_DATE7 CONT_INFORMATION_DATE8 CONT_INFORMATION_DATE9 CONT_INFORMATION_DATE10 CONT_INFORMATION_DATE11 CONT_INFORMATION_DATE12 CONT_INFORMATION_DATE13 CONT_INFORMATION_DATE14 CONT_INFORMATION_DATE15

Query

SQL_Statement

SELECT BENEFICIARY_FLAG, BONDHOLDER_FLAG, BUSINESS_GROUP_ID, CONT_ATTRIBUTE_CATEGORY, CONT_INFORMATION_CATEGORY, CONTACT_PERSON_ID, CONTACT_RELATIONSHIP_ID, CONTACT_TYPE, CREATED_BY, CREATION_DATE, DEPENDENT_FLAG, END_LIFE_REASON_ID, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, OBJECT_VERSION_NUMBER, PERSON_ID, PERSONAL_FLAG, PRIMARY_CONTACT_FLAG, RLTD_PER_RSDS_W_DSGNTR_FLAG, SEQUENCE_NUMBER, START_LIFE_REASON_ID, THIRD_PARTY_PAY_FLAG, CONT_ATTRIBUTE1, CONT_ATTRIBUTE2, CONT_ATTRIBUTE3, CONT_ATTRIBUTE4, CONT_ATTRIBUTE5, CONT_ATTRIBUTE6, CONT_ATTRIBUTE7, CONT_ATTRIBUTE8, CONT_ATTRIBUTE9, CONT_ATTRIBUTE10, CONT_ATTRIBUTE11, CONT_ATTRIBUTE12, CONT_ATTRIBUTE13, CONT_ATTRIBUTE14, CONT_ATTRIBUTE15, CONT_ATTRIBUTE16, CONT_ATTRIBUTE17, CONT_ATTRIBUTE18, CONT_ATTRIBUTE19, CONT_ATTRIBUTE20, CONT_INFORMATION1, CONT_INFORMATION2, CONT_INFORMATION3, CONT_INFORMATION4, CONT_INFORMATION5, CONT_INFORMATION6, CONT_INFORMATION7, CONT_INFORMATION8, CONT_INFORMATION9, CONT_INFORMATION10, CONT_INFORMATION11, CONT_INFORMATION12, CONT_INFORMATION13, CONT_INFORMATION14, CONT_INFORMATION15, CONT_INFORMATION16, CONT_INFORMATION17, CONT_INFORMATION18, CONT_INFORMATION19, CONT_INFORMATION20, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EMERGENCY_CONTACT_FLAG, CONT_ATTRIBUTE21, CONT_ATTRIBUTE22, CONT_ATTRIBUTE23, CONT_ATTRIBUTE24, CONT_ATTRIBUTE25, CONT_ATTRIBUTE26, CONT_ATTRIBUTE27, CONT_ATTRIBUTE28, CONT_ATTRIBUTE29, CONT_ATTRIBUTE30, CONT_ATTRIBUTE_NUMBER1, CONT_ATTRIBUTE_NUMBER2, CONT_ATTRIBUTE_NUMBER3, CONT_ATTRIBUTE_NUMBER4, CONT_ATTRIBUTE_NUMBER5, CONT_ATTRIBUTE_NUMBER6, CONT_ATTRIBUTE_NUMBER7, CONT_ATTRIBUTE_NUMBER8, CONT_ATTRIBUTE_NUMBER9, CONT_ATTRIBUTE_NUMBER10, CONT_ATTRIBUTE_NUMBER11, CONT_ATTRIBUTE_NUMBER12, CONT_ATTRIBUTE_NUMBER13, CONT_ATTRIBUTE_NUMBER14, CONT_ATTRIBUTE_NUMBER15, CONT_ATTRIBUTE_NUMBER16, CONT_ATTRIBUTE_NUMBER17, CONT_ATTRIBUTE_NUMBER18, CONT_ATTRIBUTE_NUMBER19, CONT_ATTRIBUTE_NUMBER20, CONT_ATTRIBUTE_DATE1, CONT_ATTRIBUTE_DATE2, CONT_ATTRIBUTE_DATE3, CONT_ATTRIBUTE_DATE4, CONT_ATTRIBUTE_DATE5, CONT_ATTRIBUTE_DATE6, CONT_ATTRIBUTE_DATE7, CONT_ATTRIBUTE_DATE8, CONT_ATTRIBUTE_DATE9, CONT_ATTRIBUTE_DATE10, CONT_ATTRIBUTE_DATE11, CONT_ATTRIBUTE_DATE12, CONT_ATTRIBUTE_DATE13, CONT_ATTRIBUTE_DATE14, CONT_ATTRIBUTE_DATE15, CONT_INFORMATION21, CONT_INFORMATION22, CONT_INFORMATION23, CONT_INFORMATION24, CONT_INFORMATION25, CONT_INFORMATION26, CONT_INFORMATION27, CONT_INFORMATION28, CONT_INFORMATION29, CONT_INFORMATION30, CONT_INFORMATION_NUMBER1, CONT_INFORMATION_NUMBER2, CONT_INFORMATION_NUMBER3, CONT_INFORMATION_NUMBER4, CONT_INFORMATION_NUMBER5, CONT_INFORMATION_NUMBER6, CONT_INFORMATION_NUMBER7, CONT_INFORMATION_NUMBER8, CONT_INFORMATION_NUMBER9, CONT_INFORMATION_NUMBER10, CONT_INFORMATION_NUMBER11, CONT_INFORMATION_NUMBER12, CONT_INFORMATION_NUMBER13, CONT_INFORMATION_NUMBER14, CONT_INFORMATION_NUMBER15, CONT_INFORMATION_NUMBER16, CONT_INFORMATION_NUMBER17, CONT_INFORMATION_NUMBER18, CONT_INFORMATION_NUMBER19, CONT_INFORMATION_NUMBER20, CONT_INFORMATION_DATE1, CONT_INFORMATION_DATE2, CONT_INFORMATION_DATE3, CONT_INFORMATION_DATE4, CONT_INFORMATION_DATE5, CONT_INFORMATION_DATE6, CONT_INFORMATION_DATE7, CONT_INFORMATION_DATE8, CONT_INFORMATION_DATE9, CONT_INFORMATION_DATE10, CONT_INFORMATION_DATE11, CONT_INFORMATION_DATE12, CONT_INFORMATION_DATE13, CONT_INFORMATION_DATE14, CONT_INFORMATION_DATE15 FROM PER_CONTACT_RELSHIPS_F