PER_POSITION_EXTRA

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
POSITION_EXTRA_INFO_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE POSITION_ID INFORMATION_TYPE LEGISLATION_CODE ACTION_OCCURRENCE_ID POEI_ATTRIBUTE_CATEGORY POEI_ATTRIBUTE1 POEI_ATTRIBUTE2 POEI_ATTRIBUTE3 POEI_ATTRIBUTE4 POEI_ATTRIBUTE5 POEI_ATTRIBUTE6 POEI_ATTRIBUTE7 POEI_ATTRIBUTE8 POEI_ATTRIBUTE9 POEI_ATTRIBUTE10 POEI_ATTRIBUTE11 POEI_ATTRIBUTE12 POEI_ATTRIBUTE13 POEI_ATTRIBUTE14 POEI_ATTRIBUTE15 POEI_ATTRIBUTE16 POEI_ATTRIBUTE17 POEI_ATTRIBUTE18 POEI_ATTRIBUTE19 POEI_ATTRIBUTE20 POEI_ATTRIBUTE21 POEI_ATTRIBUTE22 POEI_ATTRIBUTE23 POEI_ATTRIBUTE24 POEI_ATTRIBUTE25 POEI_ATTRIBUTE26 POEI_ATTRIBUTE27 POEI_ATTRIBUTE28 POEI_ATTRIBUTE29 POEI_ATTRIBUTE30 POEI_INFORMATION_CATEGORY POEI_INFORMATION1 POEI_INFORMATION2 POEI_INFORMATION3 POEI_INFORMATION4 POEI_INFORMATION5 POEI_INFORMATION6 POEI_INFORMATION7 POEI_INFORMATION8 POEI_INFORMATION9 POEI_INFORMATION10 POEI_INFORMATION11 POEI_INFORMATION12 POEI_INFORMATION13 POEI_INFORMATION14 POEI_INFORMATION15 POEI_INFORMATION16 POEI_INFORMATION17 POEI_INFORMATION18 POEI_INFORMATION19 POEI_INFORMATION20 POEI_INFORMATION21 POEI_INFORMATION22 POEI_INFORMATION23 POEI_INFORMATION24 POEI_INFORMATION25 POEI_INFORMATION26 POEI_INFORMATION27 POEI_INFORMATION28 POEI_INFORMATION29 POEI_INFORMATION30 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

POSITION_EXTRA_INFO_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

POSITION_ID

INFORMATION_TYPE

LEGISLATION_CODE

ACTION_OCCURRENCE_ID

POEI_ATTRIBUTE_CATEGORY

POEI_ATTRIBUTE1

POEI_ATTRIBUTE2

POEI_ATTRIBUTE3

POEI_ATTRIBUTE4

POEI_ATTRIBUTE5

POEI_ATTRIBUTE6

POEI_ATTRIBUTE7

POEI_ATTRIBUTE8

POEI_ATTRIBUTE9

POEI_ATTRIBUTE10

POEI_ATTRIBUTE11

POEI_ATTRIBUTE12

POEI_ATTRIBUTE13

POEI_ATTRIBUTE14

POEI_ATTRIBUTE15

POEI_ATTRIBUTE16

POEI_ATTRIBUTE17

POEI_ATTRIBUTE18

POEI_ATTRIBUTE19

POEI_ATTRIBUTE20

POEI_ATTRIBUTE21

POEI_ATTRIBUTE22

POEI_ATTRIBUTE23

POEI_ATTRIBUTE24

POEI_ATTRIBUTE25

POEI_ATTRIBUTE26

POEI_ATTRIBUTE27

POEI_ATTRIBUTE28

POEI_ATTRIBUTE29

POEI_ATTRIBUTE30

POEI_INFORMATION_CATEGORY

POEI_INFORMATION1

POEI_INFORMATION2

POEI_INFORMATION3

POEI_INFORMATION4

POEI_INFORMATION5

POEI_INFORMATION6

POEI_INFORMATION7

POEI_INFORMATION8

POEI_INFORMATION9

POEI_INFORMATION10

POEI_INFORMATION11

POEI_INFORMATION12

POEI_INFORMATION13

POEI_INFORMATION14

POEI_INFORMATION15

POEI_INFORMATION16

POEI_INFORMATION17

POEI_INFORMATION18

POEI_INFORMATION19

POEI_INFORMATION20

POEI_INFORMATION21

POEI_INFORMATION22

POEI_INFORMATION23

POEI_INFORMATION24

POEI_INFORMATION25

POEI_INFORMATION26

POEI_INFORMATION27

POEI_INFORMATION28

POEI_INFORMATION29

POEI_INFORMATION30

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
( SELECT POSITION_EXTRA_INFO_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, POSITION_ID, INFORMATION_TYPE, LEGISLATION_CODE, ACTION_OCCURRENCE_ID, POEI_ATTRIBUTE_CATEGORY, POEI_ATTRIBUTE1, POEI_ATTRIBUTE2, POEI_ATTRIBUTE3, POEI_ATTRIBUTE4, POEI_ATTRIBUTE5, POEI_ATTRIBUTE6, POEI_ATTRIBUTE7, POEI_ATTRIBUTE8, POEI_ATTRIBUTE9, POEI_ATTRIBUTE10, POEI_ATTRIBUTE11, POEI_ATTRIBUTE12, POEI_ATTRIBUTE13, POEI_ATTRIBUTE14, POEI_ATTRIBUTE15, POEI_ATTRIBUTE16, POEI_ATTRIBUTE17, POEI_ATTRIBUTE18, POEI_ATTRIBUTE19, POEI_ATTRIBUTE20, POEI_ATTRIBUTE21, POEI_ATTRIBUTE22, POEI_ATTRIBUTE23, POEI_ATTRIBUTE24, POEI_ATTRIBUTE25, POEI_ATTRIBUTE26, POEI_ATTRIBUTE27, POEI_ATTRIBUTE28, POEI_ATTRIBUTE29, POEI_ATTRIBUTE30, POEI_INFORMATION_CATEGORY, POEI_INFORMATION1, POEI_INFORMATION2, POEI_INFORMATION3, POEI_INFORMATION4, POEI_INFORMATION5, POEI_INFORMATION6, POEI_INFORMATION7, POEI_INFORMATION8, POEI_INFORMATION9, POEI_INFORMATION10, POEI_INFORMATION11, POEI_INFORMATION12, POEI_INFORMATION13, POEI_INFORMATION14, POEI_INFORMATION15, POEI_INFORMATION16, POEI_INFORMATION17, POEI_INFORMATION18, POEI_INFORMATION19, POEI_INFORMATION20, POEI_INFORMATION21, POEI_INFORMATION22, POEI_INFORMATION23, POEI_INFORMATION24, POEI_INFORMATION25, POEI_INFORMATION26, POEI_INFORMATION27, POEI_INFORMATION28, POEI_INFORMATION29, POEI_INFORMATION30, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM PER_POSITION_EXTRA_INFO_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

SQL_Statement

(

SELECT

POSITION_EXTRA_INFO_ID,

EFFECTIVE_START_DATE,

EFFECTIVE_END_DATE,

POSITION_ID,

INFORMATION_TYPE,

LEGISLATION_CODE,

ACTION_OCCURRENCE_ID,

POEI_ATTRIBUTE_CATEGORY,

POEI_ATTRIBUTE1,

POEI_ATTRIBUTE2,

POEI_ATTRIBUTE3,

POEI_ATTRIBUTE4,

POEI_ATTRIBUTE5,

POEI_ATTRIBUTE6,

POEI_ATTRIBUTE7,

POEI_ATTRIBUTE8,

POEI_ATTRIBUTE9,

POEI_ATTRIBUTE10,

POEI_ATTRIBUTE11,

POEI_ATTRIBUTE12,

POEI_ATTRIBUTE13,

POEI_ATTRIBUTE14,

POEI_ATTRIBUTE15,

POEI_ATTRIBUTE16,

POEI_ATTRIBUTE17,

POEI_ATTRIBUTE18,

POEI_ATTRIBUTE19,

POEI_ATTRIBUTE20,

POEI_ATTRIBUTE21,

POEI_ATTRIBUTE22,

POEI_ATTRIBUTE23,

POEI_ATTRIBUTE24,

POEI_ATTRIBUTE25,

POEI_ATTRIBUTE26,

POEI_ATTRIBUTE27,

POEI_ATTRIBUTE28,

POEI_ATTRIBUTE29,

POEI_ATTRIBUTE30,

POEI_INFORMATION_CATEGORY,

POEI_INFORMATION1,

POEI_INFORMATION2,

POEI_INFORMATION3,

POEI_INFORMATION4,

POEI_INFORMATION5,

POEI_INFORMATION6,

POEI_INFORMATION7,

POEI_INFORMATION8,

POEI_INFORMATION9,

POEI_INFORMATION10,

POEI_INFORMATION11,

POEI_INFORMATION12,

POEI_INFORMATION13,

POEI_INFORMATION14,

POEI_INFORMATION15,

POEI_INFORMATION16,

POEI_INFORMATION17,

POEI_INFORMATION18,

POEI_INFORMATION19,

POEI_INFORMATION20,

POEI_INFORMATION21,

POEI_INFORMATION22,

POEI_INFORMATION23,

POEI_INFORMATION24,

POEI_INFORMATION25,

POEI_INFORMATION26,

POEI_INFORMATION27,

POEI_INFORMATION28,

POEI_INFORMATION29,

POEI_INFORMATION30,

OBJECT_VERSION_NUMBER,

CREATED_BY,

CREATION_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN

FROM PER_POSITION_EXTRA_INFO_F

WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)