PER_PEOPLE_LEGISLATIVE_F_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

PERSON_LEGISLATIVE_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

PERSON_ID

BUSINESS_GROUP_ID

LEGISLATION_CODE

SEX

MARITAL_STATUS

MARITAL_STATUS_DATE

HIGHEST_EDUCATION_LEVEL

PER_INFORMATION_CATEGORY

PER_INFORMATION1

PER_INFORMATION2

PER_INFORMATION3

PER_INFORMATION4

PER_INFORMATION5

PER_INFORMATION6

PER_INFORMATION7

PER_INFORMATION8

PER_INFORMATION9

PER_INFORMATION10

PER_INFORMATION11

PER_INFORMATION12

PER_INFORMATION13

PER_INFORMATION14

PER_INFORMATION15

PER_INFORMATION16

PER_INFORMATION17

PER_INFORMATION18

PER_INFORMATION19

PER_INFORMATION20

PER_INFORMATION21

PER_INFORMATION22

PER_INFORMATION23

PER_INFORMATION24

PER_INFORMATION25

PER_INFORMATION26

PER_INFORMATION27

PER_INFORMATION28

PER_INFORMATION29

PER_INFORMATION30

PER_INFORMATION_NUMBER1

PER_INFORMATION_NUMBER2

PER_INFORMATION_NUMBER3

PER_INFORMATION_NUMBER4

PER_INFORMATION_NUMBER5

PER_INFORMATION_NUMBER6

PER_INFORMATION_NUMBER7

PER_INFORMATION_NUMBER8

PER_INFORMATION_NUMBER9

PER_INFORMATION_NUMBER10

PER_INFORMATION_NUMBER11

PER_INFORMATION_NUMBER12

PER_INFORMATION_NUMBER13

PER_INFORMATION_NUMBER14

PER_INFORMATION_NUMBER15

PER_INFORMATION_NUMBER16

PER_INFORMATION_NUMBER17

PER_INFORMATION_NUMBER18

PER_INFORMATION_NUMBER19

PER_INFORMATION_NUMBER20

PER_INFORMATION_DATE1

PER_INFORMATION_DATE2

PER_INFORMATION_DATE3

PER_INFORMATION_DATE4

PER_INFORMATION_DATE5

PER_INFORMATION_DATE6

PER_INFORMATION_DATE7

PER_INFORMATION_DATE8

PER_INFORMATION_DATE9

PER_INFORMATION_DATE10

PER_INFORMATION_DATE11

PER_INFORMATION_DATE12

PER_INFORMATION_DATE13

PER_INFORMATION_DATE14

PER_INFORMATION_DATE15

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_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

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

Query

SQL_Statement

SELECT

PERSON_LEGISLATIVE_ID,

EFFECTIVE_START_DATE,

EFFECTIVE_END_DATE,

PERSON_ID,

BUSINESS_GROUP_ID,

LEGISLATION_CODE,

SEX,

MARITAL_STATUS,

MARITAL_STATUS_DATE,

HIGHEST_EDUCATION_LEVEL,

PER_INFORMATION_CATEGORY,

PER_INFORMATION1,

PER_INFORMATION2,

PER_INFORMATION3,

PER_INFORMATION4,

PER_INFORMATION5,

PER_INFORMATION6,

PER_INFORMATION7,

PER_INFORMATION8,

PER_INFORMATION9,

PER_INFORMATION10,

PER_INFORMATION11,

PER_INFORMATION12,

PER_INFORMATION13,

PER_INFORMATION14,

PER_INFORMATION15,

PER_INFORMATION16,

PER_INFORMATION17,

PER_INFORMATION18,

PER_INFORMATION19,

PER_INFORMATION20,

PER_INFORMATION21,

PER_INFORMATION22,

PER_INFORMATION23,

PER_INFORMATION24,

PER_INFORMATION25,

PER_INFORMATION26,

PER_INFORMATION27,

PER_INFORMATION28,

PER_INFORMATION29,

PER_INFORMATION30,

PER_INFORMATION_NUMBER1,

PER_INFORMATION_NUMBER2,

PER_INFORMATION_NUMBER3,

PER_INFORMATION_NUMBER4,

PER_INFORMATION_NUMBER5,

PER_INFORMATION_NUMBER6,

PER_INFORMATION_NUMBER7,

PER_INFORMATION_NUMBER8,

PER_INFORMATION_NUMBER9,

PER_INFORMATION_NUMBER10,

PER_INFORMATION_NUMBER11,

PER_INFORMATION_NUMBER12,

PER_INFORMATION_NUMBER13,

PER_INFORMATION_NUMBER14,

PER_INFORMATION_NUMBER15,

PER_INFORMATION_NUMBER16,

PER_INFORMATION_NUMBER17,

PER_INFORMATION_NUMBER18,

PER_INFORMATION_NUMBER19,

PER_INFORMATION_NUMBER20,

PER_INFORMATION_DATE1,

PER_INFORMATION_DATE2,

PER_INFORMATION_DATE3,

PER_INFORMATION_DATE4,

PER_INFORMATION_DATE5,

PER_INFORMATION_DATE6,

PER_INFORMATION_DATE7,

PER_INFORMATION_DATE8,

PER_INFORMATION_DATE9,

PER_INFORMATION_DATE10,

PER_INFORMATION_DATE11,

PER_INFORMATION_DATE12,

PER_INFORMATION_DATE13,

PER_INFORMATION_DATE14,

PER_INFORMATION_DATE15,

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_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

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

FROM

PER_PEOPLE_LEGISLATIVE_F