1. Tables and Views for HCM
  2. PER_JOB_EXTRA_INFO

PER_JOB_EXTRA_INFO

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

JOB_EXTRA_INFO_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

JOB_ID

INFORMATION_TYPE

LEGISLATION_CODE

ACTION_OCCURRENCE_ID

JEI_ATTRIBUTE_CATEGORY

JEI_ATTRIBUTE1

JEI_ATTRIBUTE2

JEI_ATTRIBUTE3

JEI_ATTRIBUTE4

JEI_ATTRIBUTE5

JEI_ATTRIBUTE6

JEI_ATTRIBUTE7

JEI_ATTRIBUTE8

JEI_ATTRIBUTE9

JEI_ATTRIBUTE10

JEI_ATTRIBUTE11

JEI_ATTRIBUTE12

JEI_ATTRIBUTE13

JEI_ATTRIBUTE14

JEI_ATTRIBUTE15

JEI_ATTRIBUTE16

JEI_ATTRIBUTE17

JEI_ATTRIBUTE18

JEI_ATTRIBUTE19

JEI_ATTRIBUTE20

JEI_ATTRIBUTE21

JEI_ATTRIBUTE22

JEI_ATTRIBUTE23

JEI_ATTRIBUTE24

JEI_ATTRIBUTE25

JEI_ATTRIBUTE26

JEI_ATTRIBUTE27

JEI_ATTRIBUTE28

JEI_ATTRIBUTE29

JEI_ATTRIBUTE30

JEI_INFORMATION_CATEGORY

JEI_INFORMATION1

JEI_INFORMATION2

JEI_INFORMATION3

JEI_INFORMATION4

JEI_INFORMATION5

JEI_INFORMATION6

JEI_INFORMATION7

JEI_INFORMATION8

JEI_INFORMATION9

JEI_INFORMATION10

JEI_INFORMATION11

JEI_INFORMATION12

JEI_INFORMATION13

JEI_INFORMATION14

JEI_INFORMATION15

JEI_INFORMATION16

JEI_INFORMATION17

JEI_INFORMATION18

JEI_INFORMATION19

JEI_INFORMATION20

JEI_INFORMATION21

JEI_INFORMATION22

JEI_INFORMATION23

JEI_INFORMATION24

JEI_INFORMATION25

JEI_INFORMATION26

JEI_INFORMATION27

JEI_INFORMATION28

JEI_INFORMATION29

JEI_INFORMATION30

Query

SQL_Statement

SELECT

JEI.JOB_EXTRA_INFO_ID,

JEI.EFFECTIVE_START_DATE,

JEI.EFFECTIVE_END_DATE,

JEI.JOB_ID,

JEI.INFORMATION_TYPE,

JEI.LEGISLATION_CODE,

JEI.ACTION_OCCURRENCE_ID,

JEI.JEI_ATTRIBUTE_CATEGORY,

JEI.JEI_ATTRIBUTE1,

JEI.JEI_ATTRIBUTE2,

JEI.JEI_ATTRIBUTE3,

JEI.JEI_ATTRIBUTE4,

JEI.JEI_ATTRIBUTE5,

JEI.JEI_ATTRIBUTE6,

JEI.JEI_ATTRIBUTE7,

JEI.JEI_ATTRIBUTE8,

JEI.JEI_ATTRIBUTE9,

JEI.JEI_ATTRIBUTE10,

JEI.JEI_ATTRIBUTE11,

JEI.JEI_ATTRIBUTE12,

JEI.JEI_ATTRIBUTE13,

JEI.JEI_ATTRIBUTE14,

JEI.JEI_ATTRIBUTE15,

JEI.JEI_ATTRIBUTE16,

JEI.JEI_ATTRIBUTE17,

JEI.JEI_ATTRIBUTE18,

JEI.JEI_ATTRIBUTE19,

JEI.JEI_ATTRIBUTE20,

JEI.JEI_ATTRIBUTE21,

JEI.JEI_ATTRIBUTE22,

JEI.JEI_ATTRIBUTE23,

JEI.JEI_ATTRIBUTE24,

JEI.JEI_ATTRIBUTE25,

JEI.JEI_ATTRIBUTE26,

JEI.JEI_ATTRIBUTE27,

JEI.JEI_ATTRIBUTE28,

JEI.JEI_ATTRIBUTE29,

JEI.JEI_ATTRIBUTE30,

JEI.JEI_INFORMATION_CATEGORY,

JEI.JEI_INFORMATION1,

JEI.JEI_INFORMATION2,

JEI.JEI_INFORMATION3,

JEI.JEI_INFORMATION4,

JEI.JEI_INFORMATION5,

JEI.JEI_INFORMATION6,

JEI.JEI_INFORMATION7,

JEI.JEI_INFORMATION8,

JEI.JEI_INFORMATION9,

JEI.JEI_INFORMATION10,

JEI.JEI_INFORMATION11,

JEI.JEI_INFORMATION12,

JEI.JEI_INFORMATION13,

JEI.JEI_INFORMATION14,

JEI.JEI_INFORMATION15,

JEI.JEI_INFORMATION16,

JEI.JEI_INFORMATION17,

JEI.JEI_INFORMATION18,

JEI.JEI_INFORMATION19,

JEI.JEI_INFORMATION20,

JEI.JEI_INFORMATION21,

JEI.JEI_INFORMATION22,

JEI.JEI_INFORMATION23,

JEI.JEI_INFORMATION24,

JEI.JEI_INFORMATION25,

JEI.JEI_INFORMATION26,

JEI.JEI_INFORMATION27,

JEI.JEI_INFORMATION28,

JEI.JEI_INFORMATION29,

JEI.JEI_INFORMATION30

FROM

PER_JOB_EXTRA_INFO_F JEI

WHERE

TRUNC(SYSDATE) BETWEEN JEI.EFFECTIVE_START_DATE AND JEI.EFFECTIVE_END_DATE