PER_ASSIGNMENT_EXTRA_INFO_M

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
ASSIGNMENT_EXTRA_INFO_ID ASSIGNMENT_ID INFORMATION_TYPE AEI_ATTRIBUTE_CATEGORY AEI_ATTRIBUTE1 AEI_ATTRIBUTE2 AEI_ATTRIBUTE3 AEI_ATTRIBUTE4 AEI_ATTRIBUTE5 AEI_ATTRIBUTE6 AEI_ATTRIBUTE7 AEI_ATTRIBUTE8 AEI_ATTRIBUTE9 AEI_ATTRIBUTE10 AEI_ATTRIBUTE11 AEI_ATTRIBUTE12 AEI_ATTRIBUTE13 AEI_ATTRIBUTE14 AEI_ATTRIBUTE15 AEI_ATTRIBUTE16 AEI_ATTRIBUTE17 AEI_ATTRIBUTE18 AEI_ATTRIBUTE19 AEI_ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE AEI_INFORMATION_CATEGORY LEGISLATION_CODE AEI_INFORMATION_NUMBER1 AEI_INFORMATION_NUMBER2 AEI_INFORMATION_NUMBER3 AEI_INFORMATION_NUMBER4 AEI_INFORMATION_NUMBER5 AEI_INFORMATION_NUMBER6 AEI_INFORMATION_NUMBER7 AEI_INFORMATION_NUMBER8 AEI_INFORMATION_NUMBER9 AEI_INFORMATION_NUMBER10 AEI_INFORMATION_NUMBER11 AEI_INFORMATION_NUMBER12 AEI_INFORMATION_NUMBER13 AEI_INFORMATION_NUMBER14 AEI_INFORMATION_NUMBER15 AEI_INFORMATION_NUMBER16 AEI_INFORMATION_NUMBER17 AEI_INFORMATION_NUMBER18 AEI_INFORMATION_NUMBER19 AEI_INFORMATION_NUMBER20 AEI_INFORMATION_DATE1 AEI_INFORMATION_DATE2 AEI_INFORMATION_DATE3 AEI_INFORMATION_DATE4 AEI_INFORMATION_DATE5 AEI_INFORMATION_DATE6 AEI_INFORMATION_DATE7 AEI_INFORMATION_DATE8 AEI_INFORMATION_DATE9 AEI_INFORMATION_DATE10 AEI_INFORMATION_DATE11 AEI_INFORMATION_DATE12 AEI_INFORMATION_DATE13 AEI_INFORMATION_DATE14 AEI_INFORMATION_DATE15 AEI_ATTRIBUTE_NUMBER1 AEI_ATTRIBUTE_NUMBER2 AEI_ATTRIBUTE_NUMBER3 AEI_ATTRIBUTE_NUMBER4 AEI_ATTRIBUTE_NUMBER5 AEI_ATTRIBUTE_NUMBER6 AEI_ATTRIBUTE_NUMBER7 AEI_ATTRIBUTE_NUMBER8 AEI_ATTRIBUTE_NUMBER9 AEI_ATTRIBUTE_NUMBER10 AEI_ATTRIBUTE_NUMBER11 AEI_ATTRIBUTE_NUMBER12 AEI_ATTRIBUTE_NUMBER13 AEI_ATTRIBUTE_NUMBER14 AEI_ATTRIBUTE_NUMBER15 AEI_ATTRIBUTE_NUMBER16 AEI_ATTRIBUTE_NUMBER17 AEI_ATTRIBUTE_NUMBER18 AEI_ATTRIBUTE_NUMBER19 AEI_ATTRIBUTE_NUMBER20 AEI_ATTRIBUTE_DATE1 AEI_ATTRIBUTE_DATE2 AEI_ATTRIBUTE_DATE3 AEI_ATTRIBUTE_DATE4 AEI_ATTRIBUTE_DATE5 AEI_ATTRIBUTE_DATE6 AEI_ATTRIBUTE_DATE7 AEI_ATTRIBUTE_DATE8 AEI_ATTRIBUTE_DATE9 AEI_ATTRIBUTE_DATE10 AEI_ATTRIBUTE_DATE11 AEI_ATTRIBUTE_DATE12 AEI_ATTRIBUTE_DATE13 AEI_ATTRIBUTE_DATE14 AEI_ATTRIBUTE_DATE15 AEI_INFORMATION1 AEI_INFORMATION2 AEI_INFORMATION3 AEI_INFORMATION4 AEI_INFORMATION5 AEI_INFORMATION6 AEI_INFORMATION7 AEI_INFORMATION8 AEI_INFORMATION9 AEI_INFORMATION10 AEI_INFORMATION11 AEI_INFORMATION12 AEI_INFORMATION13 AEI_INFORMATION14 AEI_INFORMATION15 AEI_INFORMATION16 AEI_INFORMATION17 AEI_INFORMATION18 AEI_INFORMATION19 AEI_INFORMATION20 AEI_INFORMATION21 AEI_INFORMATION22 AEI_INFORMATION23 AEI_INFORMATION24 AEI_INFORMATION25 AEI_INFORMATION26 AEI_INFORMATION27 AEI_INFORMATION28 AEI_INFORMATION29 AEI_INFORMATION30 OBJECT_VERSION_NUMBER EFFECTIVE_START_DATE EFFECTIVE_END_DATE EFFECTIVE_SEQUENCE AEI_ATTRIBUTE21 AEI_ATTRIBUTE22 AEI_ATTRIBUTE23 AEI_ATTRIBUTE24 AEI_ATTRIBUTE25 AEI_ATTRIBUTE26 AEI_ATTRIBUTE27 AEI_ATTRIBUTE28 AEI_ATTRIBUTE29 AEI_ATTRIBUTE30 ACTION_OCCURRENCE_ID EFFECTIVE_LATEST_CHANGE

Name

ASSIGNMENT_EXTRA_INFO_ID

ASSIGNMENT_ID

INFORMATION_TYPE

AEI_ATTRIBUTE_CATEGORY

AEI_ATTRIBUTE1

AEI_ATTRIBUTE2

AEI_ATTRIBUTE3

AEI_ATTRIBUTE4

AEI_ATTRIBUTE5

AEI_ATTRIBUTE6

AEI_ATTRIBUTE7

AEI_ATTRIBUTE8

AEI_ATTRIBUTE9

AEI_ATTRIBUTE10

AEI_ATTRIBUTE11

AEI_ATTRIBUTE12

AEI_ATTRIBUTE13

AEI_ATTRIBUTE14

AEI_ATTRIBUTE15

AEI_ATTRIBUTE16

AEI_ATTRIBUTE17

AEI_ATTRIBUTE18

AEI_ATTRIBUTE19

AEI_ATTRIBUTE20

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

AEI_INFORMATION_CATEGORY

LEGISLATION_CODE

AEI_INFORMATION_NUMBER1

AEI_INFORMATION_NUMBER2

AEI_INFORMATION_NUMBER3

AEI_INFORMATION_NUMBER4

AEI_INFORMATION_NUMBER5

AEI_INFORMATION_NUMBER6

AEI_INFORMATION_NUMBER7

AEI_INFORMATION_NUMBER8

AEI_INFORMATION_NUMBER9

AEI_INFORMATION_NUMBER10

AEI_INFORMATION_NUMBER11

AEI_INFORMATION_NUMBER12

AEI_INFORMATION_NUMBER13

AEI_INFORMATION_NUMBER14

AEI_INFORMATION_NUMBER15

AEI_INFORMATION_NUMBER16

AEI_INFORMATION_NUMBER17

AEI_INFORMATION_NUMBER18

AEI_INFORMATION_NUMBER19

AEI_INFORMATION_NUMBER20

AEI_INFORMATION_DATE1

AEI_INFORMATION_DATE2

AEI_INFORMATION_DATE3

AEI_INFORMATION_DATE4

AEI_INFORMATION_DATE5

AEI_INFORMATION_DATE6

AEI_INFORMATION_DATE7

AEI_INFORMATION_DATE8

AEI_INFORMATION_DATE9

AEI_INFORMATION_DATE10

AEI_INFORMATION_DATE11

AEI_INFORMATION_DATE12

AEI_INFORMATION_DATE13

AEI_INFORMATION_DATE14

AEI_INFORMATION_DATE15

AEI_ATTRIBUTE_NUMBER1

AEI_ATTRIBUTE_NUMBER2

AEI_ATTRIBUTE_NUMBER3

AEI_ATTRIBUTE_NUMBER4

AEI_ATTRIBUTE_NUMBER5

AEI_ATTRIBUTE_NUMBER6

AEI_ATTRIBUTE_NUMBER7

AEI_ATTRIBUTE_NUMBER8

AEI_ATTRIBUTE_NUMBER9

AEI_ATTRIBUTE_NUMBER10

AEI_ATTRIBUTE_NUMBER11

AEI_ATTRIBUTE_NUMBER12

AEI_ATTRIBUTE_NUMBER13

AEI_ATTRIBUTE_NUMBER14

AEI_ATTRIBUTE_NUMBER15

AEI_ATTRIBUTE_NUMBER16

AEI_ATTRIBUTE_NUMBER17

AEI_ATTRIBUTE_NUMBER18

AEI_ATTRIBUTE_NUMBER19

AEI_ATTRIBUTE_NUMBER20

AEI_ATTRIBUTE_DATE1

AEI_ATTRIBUTE_DATE2

AEI_ATTRIBUTE_DATE3

AEI_ATTRIBUTE_DATE4

AEI_ATTRIBUTE_DATE5

AEI_ATTRIBUTE_DATE6

AEI_ATTRIBUTE_DATE7

AEI_ATTRIBUTE_DATE8

AEI_ATTRIBUTE_DATE9

AEI_ATTRIBUTE_DATE10

AEI_ATTRIBUTE_DATE11

AEI_ATTRIBUTE_DATE12

AEI_ATTRIBUTE_DATE13

AEI_ATTRIBUTE_DATE14

AEI_ATTRIBUTE_DATE15

AEI_INFORMATION1

AEI_INFORMATION2

AEI_INFORMATION3

AEI_INFORMATION4

AEI_INFORMATION5

AEI_INFORMATION6

AEI_INFORMATION7

AEI_INFORMATION8

AEI_INFORMATION9

AEI_INFORMATION10

AEI_INFORMATION11

AEI_INFORMATION12

AEI_INFORMATION13

AEI_INFORMATION14

AEI_INFORMATION15

AEI_INFORMATION16

AEI_INFORMATION17

AEI_INFORMATION18

AEI_INFORMATION19

AEI_INFORMATION20

AEI_INFORMATION21

AEI_INFORMATION22

AEI_INFORMATION23

AEI_INFORMATION24

AEI_INFORMATION25

AEI_INFORMATION26

AEI_INFORMATION27

AEI_INFORMATION28

AEI_INFORMATION29

AEI_INFORMATION30

OBJECT_VERSION_NUMBER

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

EFFECTIVE_SEQUENCE

AEI_ATTRIBUTE21

AEI_ATTRIBUTE22

AEI_ATTRIBUTE23

AEI_ATTRIBUTE24

AEI_ATTRIBUTE25

AEI_ATTRIBUTE26

AEI_ATTRIBUTE27

AEI_ATTRIBUTE28

AEI_ATTRIBUTE29

AEI_ATTRIBUTE30

ACTION_OCCURRENCE_ID

EFFECTIVE_LATEST_CHANGE

Query

SQL_Statement
SELECT PER_ASSIGNMENT_EXTRA_INFO_M.ASSIGNMENT_EXTRA_INFO_ID ASSIGNMENT_EXTRA_INFO_ID, PER_ASSIGNMENT_EXTRA_INFO_M.ASSIGNMENT_ID ASSIGNMENT_ID, PER_ASSIGNMENT_EXTRA_INFO_M.INFORMATION_TYPE INFORMATION_TYPE, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_CATEGORY AEI_ATTRIBUTE_CATEGORY, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE1 AEI_ATTRIBUTE1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE2 AEI_ATTRIBUTE2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE3 AEI_ATTRIBUTE3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE4 AEI_ATTRIBUTE4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE5 AEI_ATTRIBUTE5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE6 AEI_ATTRIBUTE6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE7 AEI_ATTRIBUTE7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE8 AEI_ATTRIBUTE8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE9 AEI_ATTRIBUTE9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE10 AEI_ATTRIBUTE10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE11 AEI_ATTRIBUTE11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE12 AEI_ATTRIBUTE12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE13 AEI_ATTRIBUTE13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE14 AEI_ATTRIBUTE14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE15 AEI_ATTRIBUTE15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE16 AEI_ATTRIBUTE16, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE17 AEI_ATTRIBUTE17, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE18 AEI_ATTRIBUTE18, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE19 AEI_ATTRIBUTE19, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE20 AEI_ATTRIBUTE20, PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATE_DATE LAST_UPDATE_DATE, PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATED_BY LAST_UPDATED_BY, PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PER_ASSIGNMENT_EXTRA_INFO_M.CREATED_BY CREATED_BY, PER_ASSIGNMENT_EXTRA_INFO_M.CREATION_DATE CREATION_DATE, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY, PER_ASSIGNMENT_EXTRA_INFO_M.LEGISLATION_CODE LEGISLATION_CODE, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER1 AEI_INFORMATION_NUMBER1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER2 AEI_INFORMATION_NUMBER2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER3 AEI_INFORMATION_NUMBER3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER4 AEI_INFORMATION_NUMBER4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER5 AEI_INFORMATION_NUMBER5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER6 AEI_INFORMATION_NUMBER6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER7 AEI_INFORMATION_NUMBER7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER8 AEI_INFORMATION_NUMBER8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER9 AEI_INFORMATION_NUMBER9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER10 AEI_INFORMATION_NUMBER10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER11 AEI_INFORMATION_NUMBER11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER12 AEI_INFORMATION_NUMBER12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER13 AEI_INFORMATION_NUMBER13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER14 AEI_INFORMATION_NUMBER14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER15 AEI_INFORMATION_NUMBER15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER16 AEI_INFORMATION_NUMBER16, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER17 AEI_INFORMATION_NUMBER17, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER18 AEI_INFORMATION_NUMBER18, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER19 AEI_INFORMATION_NUMBER19, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER20 AEI_INFORMATION_NUMBER20, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE1 AEI_INFORMATION_DATE1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE2 AEI_INFORMATION_DATE2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE3 AEI_INFORMATION_DATE3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE4 AEI_INFORMATION_DATE4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE5 AEI_INFORMATION_DATE5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE6 AEI_INFORMATION_DATE6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE7 AEI_INFORMATION_DATE7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE8 AEI_INFORMATION_DATE8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE9 AEI_INFORMATION_DATE9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE10 AEI_INFORMATION_DATE10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE11 AEI_INFORMATION_DATE11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE12 AEI_INFORMATION_DATE12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE13 AEI_INFORMATION_DATE13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE14 AEI_INFORMATION_DATE14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE15 AEI_INFORMATION_DATE15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER1 AEI_ATTRIBUTE_NUMBER1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER2 AEI_ATTRIBUTE_NUMBER2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER3 AEI_ATTRIBUTE_NUMBER3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER4 AEI_ATTRIBUTE_NUMBER4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER5 AEI_ATTRIBUTE_NUMBER5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER6 AEI_ATTRIBUTE_NUMBER6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER7 AEI_ATTRIBUTE_NUMBER7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER8 AEI_ATTRIBUTE_NUMBER8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER9 AEI_ATTRIBUTE_NUMBER9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER10 AEI_ATTRIBUTE_NUMBER10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER11 AEI_ATTRIBUTE_NUMBER11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER12 AEI_ATTRIBUTE_NUMBER12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER13 AEI_ATTRIBUTE_NUMBER13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER14 AEI_ATTRIBUTE_NUMBER14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER15 AEI_ATTRIBUTE_NUMBER15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER16 AEI_ATTRIBUTE_NUMBER16, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER17 AEI_ATTRIBUTE_NUMBER17, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER18 AEI_ATTRIBUTE_NUMBER18, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER19 AEI_ATTRIBUTE_NUMBER19, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER20 AEI_ATTRIBUTE_NUMBER20, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE1 AEI_ATTRIBUTE_DATE1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE2 AEI_ATTRIBUTE_DATE2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE3 AEI_ATTRIBUTE_DATE3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE4 AEI_ATTRIBUTE_DATE4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE5 AEI_ATTRIBUTE_DATE5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE6 AEI_ATTRIBUTE_DATE6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE7 AEI_ATTRIBUTE_DATE7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE8 AEI_ATTRIBUTE_DATE8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE9 AEI_ATTRIBUTE_DATE9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE10 AEI_ATTRIBUTE_DATE10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE11 AEI_ATTRIBUTE_DATE11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE12 AEI_ATTRIBUTE_DATE12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE13 AEI_ATTRIBUTE_DATE13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE14 AEI_ATTRIBUTE_DATE14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE15 AEI_ATTRIBUTE_DATE15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION1 AEI_INFORMATION1, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION2 AEI_INFORMATION2, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION3 AEI_INFORMATION3, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION4 AEI_INFORMATION4, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION5 AEI_INFORMATION5, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION6 AEI_INFORMATION6, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION7 AEI_INFORMATION7, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION8 AEI_INFORMATION8, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION9 AEI_INFORMATION9, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION10 AEI_INFORMATION10, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION11 AEI_INFORMATION11, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION12 AEI_INFORMATION12, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION13 AEI_INFORMATION13, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION14 AEI_INFORMATION14, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION15 AEI_INFORMATION15, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION16 AEI_INFORMATION16, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION17 AEI_INFORMATION17, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION18 AEI_INFORMATION18, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION19 AEI_INFORMATION19, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION20 AEI_INFORMATION20, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION21 AEI_INFORMATION21, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION22 AEI_INFORMATION22, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION23 AEI_INFORMATION23, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION24 AEI_INFORMATION24, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION25 AEI_INFORMATION25, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION26 AEI_INFORMATION26, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION27 AEI_INFORMATION27, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION28 AEI_INFORMATION28, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION29 AEI_INFORMATION29, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION30 AEI_INFORMATION30, PER_ASSIGNMENT_EXTRA_INFO_M.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_SEQUENCE EFFECTIVE_SEQUENCE, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE21 AEI_ATTRIBUTE21, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE22 AEI_ATTRIBUTE22, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE23 AEI_ATTRIBUTE23, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE24 AEI_ATTRIBUTE24, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE25 AEI_ATTRIBUTE25, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE26 AEI_ATTRIBUTE26, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE27 AEI_ATTRIBUTE27, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE28 AEI_ATTRIBUTE28, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE29 AEI_ATTRIBUTE29, PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE30 AEI_ATTRIBUTE30, PER_ASSIGNMENT_EXTRA_INFO_M.ACTION_OCCURRENCE_ID ACTION_OCCURRENCE_ID, PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_LATEST_CHANGE EFFECTIVE_LATEST_CHANGE FROM PER_ASSIGNMENT_EXTRA_INFO_M WITH READ ONLY

SQL_Statement

SELECT

PER_ASSIGNMENT_EXTRA_INFO_M.ASSIGNMENT_EXTRA_INFO_ID ASSIGNMENT_EXTRA_INFO_ID,

PER_ASSIGNMENT_EXTRA_INFO_M.ASSIGNMENT_ID ASSIGNMENT_ID,

PER_ASSIGNMENT_EXTRA_INFO_M.INFORMATION_TYPE INFORMATION_TYPE,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_CATEGORY AEI_ATTRIBUTE_CATEGORY,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE1 AEI_ATTRIBUTE1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE2 AEI_ATTRIBUTE2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE3 AEI_ATTRIBUTE3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE4 AEI_ATTRIBUTE4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE5 AEI_ATTRIBUTE5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE6 AEI_ATTRIBUTE6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE7 AEI_ATTRIBUTE7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE8 AEI_ATTRIBUTE8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE9 AEI_ATTRIBUTE9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE10 AEI_ATTRIBUTE10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE11 AEI_ATTRIBUTE11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE12 AEI_ATTRIBUTE12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE13 AEI_ATTRIBUTE13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE14 AEI_ATTRIBUTE14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE15 AEI_ATTRIBUTE15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE16 AEI_ATTRIBUTE16,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE17 AEI_ATTRIBUTE17,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE18 AEI_ATTRIBUTE18,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE19 AEI_ATTRIBUTE19,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE20 AEI_ATTRIBUTE20,

PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATED_BY LAST_UPDATED_BY,

PER_ASSIGNMENT_EXTRA_INFO_M.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PER_ASSIGNMENT_EXTRA_INFO_M.CREATED_BY CREATED_BY,

PER_ASSIGNMENT_EXTRA_INFO_M.CREATION_DATE CREATION_DATE,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY,

PER_ASSIGNMENT_EXTRA_INFO_M.LEGISLATION_CODE LEGISLATION_CODE,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER1 AEI_INFORMATION_NUMBER1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER2 AEI_INFORMATION_NUMBER2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER3 AEI_INFORMATION_NUMBER3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER4 AEI_INFORMATION_NUMBER4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER5 AEI_INFORMATION_NUMBER5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER6 AEI_INFORMATION_NUMBER6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER7 AEI_INFORMATION_NUMBER7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER8 AEI_INFORMATION_NUMBER8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER9 AEI_INFORMATION_NUMBER9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER10 AEI_INFORMATION_NUMBER10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER11 AEI_INFORMATION_NUMBER11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER12 AEI_INFORMATION_NUMBER12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER13 AEI_INFORMATION_NUMBER13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER14 AEI_INFORMATION_NUMBER14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER15 AEI_INFORMATION_NUMBER15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER16 AEI_INFORMATION_NUMBER16,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER17 AEI_INFORMATION_NUMBER17,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER18 AEI_INFORMATION_NUMBER18,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER19 AEI_INFORMATION_NUMBER19,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_NUMBER20 AEI_INFORMATION_NUMBER20,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE1 AEI_INFORMATION_DATE1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE2 AEI_INFORMATION_DATE2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE3 AEI_INFORMATION_DATE3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE4 AEI_INFORMATION_DATE4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE5 AEI_INFORMATION_DATE5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE6 AEI_INFORMATION_DATE6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE7 AEI_INFORMATION_DATE7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE8 AEI_INFORMATION_DATE8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE9 AEI_INFORMATION_DATE9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE10 AEI_INFORMATION_DATE10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE11 AEI_INFORMATION_DATE11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE12 AEI_INFORMATION_DATE12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE13 AEI_INFORMATION_DATE13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE14 AEI_INFORMATION_DATE14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION_DATE15 AEI_INFORMATION_DATE15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER1 AEI_ATTRIBUTE_NUMBER1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER2 AEI_ATTRIBUTE_NUMBER2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER3 AEI_ATTRIBUTE_NUMBER3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER4 AEI_ATTRIBUTE_NUMBER4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER5 AEI_ATTRIBUTE_NUMBER5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER6 AEI_ATTRIBUTE_NUMBER6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER7 AEI_ATTRIBUTE_NUMBER7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER8 AEI_ATTRIBUTE_NUMBER8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER9 AEI_ATTRIBUTE_NUMBER9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER10 AEI_ATTRIBUTE_NUMBER10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER11 AEI_ATTRIBUTE_NUMBER11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER12 AEI_ATTRIBUTE_NUMBER12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER13 AEI_ATTRIBUTE_NUMBER13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER14 AEI_ATTRIBUTE_NUMBER14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER15 AEI_ATTRIBUTE_NUMBER15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER16 AEI_ATTRIBUTE_NUMBER16,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER17 AEI_ATTRIBUTE_NUMBER17,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER18 AEI_ATTRIBUTE_NUMBER18,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER19 AEI_ATTRIBUTE_NUMBER19,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_NUMBER20 AEI_ATTRIBUTE_NUMBER20,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE1 AEI_ATTRIBUTE_DATE1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE2 AEI_ATTRIBUTE_DATE2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE3 AEI_ATTRIBUTE_DATE3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE4 AEI_ATTRIBUTE_DATE4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE5 AEI_ATTRIBUTE_DATE5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE6 AEI_ATTRIBUTE_DATE6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE7 AEI_ATTRIBUTE_DATE7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE8 AEI_ATTRIBUTE_DATE8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE9 AEI_ATTRIBUTE_DATE9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE10 AEI_ATTRIBUTE_DATE10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE11 AEI_ATTRIBUTE_DATE11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE12 AEI_ATTRIBUTE_DATE12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE13 AEI_ATTRIBUTE_DATE13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE14 AEI_ATTRIBUTE_DATE14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE_DATE15 AEI_ATTRIBUTE_DATE15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION1 AEI_INFORMATION1,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION2 AEI_INFORMATION2,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION3 AEI_INFORMATION3,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION4 AEI_INFORMATION4,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION5 AEI_INFORMATION5,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION6 AEI_INFORMATION6,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION7 AEI_INFORMATION7,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION8 AEI_INFORMATION8,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION9 AEI_INFORMATION9,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION10 AEI_INFORMATION10,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION11 AEI_INFORMATION11,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION12 AEI_INFORMATION12,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION13 AEI_INFORMATION13,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION14 AEI_INFORMATION14,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION15 AEI_INFORMATION15,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION16 AEI_INFORMATION16,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION17 AEI_INFORMATION17,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION18 AEI_INFORMATION18,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION19 AEI_INFORMATION19,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION20 AEI_INFORMATION20,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION21 AEI_INFORMATION21,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION22 AEI_INFORMATION22,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION23 AEI_INFORMATION23,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION24 AEI_INFORMATION24,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION25 AEI_INFORMATION25,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION26 AEI_INFORMATION26,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION27 AEI_INFORMATION27,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION28 AEI_INFORMATION28,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION29 AEI_INFORMATION29,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_INFORMATION30 AEI_INFORMATION30,

PER_ASSIGNMENT_EXTRA_INFO_M.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_SEQUENCE EFFECTIVE_SEQUENCE,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE21 AEI_ATTRIBUTE21,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE22 AEI_ATTRIBUTE22,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE23 AEI_ATTRIBUTE23,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE24 AEI_ATTRIBUTE24,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE25 AEI_ATTRIBUTE25,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE26 AEI_ATTRIBUTE26,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE27 AEI_ATTRIBUTE27,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE28 AEI_ATTRIBUTE28,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE29 AEI_ATTRIBUTE29,

PER_ASSIGNMENT_EXTRA_INFO_M.AEI_ATTRIBUTE30 AEI_ATTRIBUTE30,

PER_ASSIGNMENT_EXTRA_INFO_M.ACTION_OCCURRENCE_ID ACTION_OCCURRENCE_ID,

PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_LATEST_CHANGE EFFECTIVE_LATEST_CHANGE

FROM

PER_ASSIGNMENT_EXTRA_INFO_M

WITH READ ONLY