1. Tables and Views for HCM
  2. HR_ORGANIZATION_INFO_EFF_V

HR_ORGANIZATION_INFO_EFF_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

EFF_LINE_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ACTION_OCCURRENCE_ID

ORGANIZATION_ID

LEGISLATION_CODE

CONTEXT_CODE

ORG_INFORMATION1

ORG_INFORMATION2

ORG_INFORMATION3

ORG_INFORMATION4

ORG_INFORMATION5

ORG_INFORMATION6

ORG_INFORMATION7

ORG_INFORMATION8

ORG_INFORMATION9

ORG_INFORMATION10

ORG_INFORMATION11

ORG_INFORMATION12

ORG_INFORMATION13

ORG_INFORMATION14

ORG_INFORMATION15

ORG_INFORMATION16

ORG_INFORMATION17

ORG_INFORMATION18

ORG_INFORMATION19

ORG_INFORMATION20

ORG_INFORMATION21

ORG_INFORMATION22

ORG_INFORMATION23

ORG_INFORMATION24

ORG_INFORMATION25

ORG_INFORMATION26

ORG_INFORMATION27

ORG_INFORMATION28

ORG_INFORMATION29

ORG_INFORMATION30

ORG_INFORMATION_NUMBER1

ORG_INFORMATION_NUMBER2

ORG_INFORMATION_NUMBER3

ORG_INFORMATION_NUMBER4

ORG_INFORMATION_NUMBER5

ORG_INFORMATION_NUMBER6

ORG_INFORMATION_NUMBER7

ORG_INFORMATION_NUMBER8

ORG_INFORMATION_NUMBER9

ORG_INFORMATION_NUMBER10

ORG_INFORMATION_NUMBER11

ORG_INFORMATION_NUMBER12

ORG_INFORMATION_NUMBER13

ORG_INFORMATION_NUMBER14

ORG_INFORMATION_NUMBER15

ORG_INFORMATION_NUMBER16

ORG_INFORMATION_NUMBER17

ORG_INFORMATION_NUMBER18

ORG_INFORMATION_NUMBER19

ORG_INFORMATION_NUMBER20

ORG_INFORMATION_DATE1

ORG_INFORMATION_DATE2

ORG_INFORMATION_DATE3

ORG_INFORMATION_DATE4

ORG_INFORMATION_DATE5

ORG_INFORMATION_DATE6

ORG_INFORMATION_DATE7

ORG_INFORMATION_DATE8

ORG_INFORMATION_DATE9

ORG_INFORMATION_DATE10

ORG_INFORMATION_DATE11

ORG_INFORMATION_DATE12

ORG_INFORMATION_DATE13

ORG_INFORMATION_DATE14

ORG_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

Query

SQL_Statement

SELECT

oua.ORG_INFORMATION_ID EFF_LINE_ID,

oua.EFFECTIVE_START_DATE,

oua.EFFECTIVE_END_DATE,

oua.ACTION_OCCURRENCE_ID,

oua.ORGANIZATION_ID,

oua.LEGISLATION_CODE,

oua.ORG_INFORMATION_CONTEXT CONTEXT_CODE,

oua.ORG_INFORMATION1,

oua.ORG_INFORMATION2,

oua.ORG_INFORMATION3,

oua.ORG_INFORMATION4,

oua.ORG_INFORMATION5,

oua.ORG_INFORMATION6,

oua.ORG_INFORMATION7,

oua.ORG_INFORMATION8,

oua.ORG_INFORMATION9,

oua.ORG_INFORMATION10,

oua.ORG_INFORMATION11,

oua.ORG_INFORMATION12,

oua.ORG_INFORMATION13,

oua.ORG_INFORMATION14,

oua.ORG_INFORMATION15,

oua.ORG_INFORMATION16,

oua.ORG_INFORMATION17,

oua.ORG_INFORMATION18,

oua.ORG_INFORMATION19,

oua.ORG_INFORMATION20,

oua.ORG_INFORMATION21,

oua.ORG_INFORMATION22,

oua.ORG_INFORMATION23,

oua.ORG_INFORMATION24,

oua.ORG_INFORMATION25,

oua.ORG_INFORMATION26,

oua.ORG_INFORMATION27,

oua.ORG_INFORMATION28,

oua.ORG_INFORMATION29,

oua.ORG_INFORMATION30,

oua.ORG_INFORMATION_NUMBER1,

oua.ORG_INFORMATION_NUMBER2,

oua.ORG_INFORMATION_NUMBER3,

oua.ORG_INFORMATION_NUMBER4,

oua.ORG_INFORMATION_NUMBER5,

oua.ORG_INFORMATION_NUMBER6,

oua.ORG_INFORMATION_NUMBER7,

oua.ORG_INFORMATION_NUMBER8,

oua.ORG_INFORMATION_NUMBER9,

oua.ORG_INFORMATION_NUMBER10,

oua.ORG_INFORMATION_NUMBER11,

oua.ORG_INFORMATION_NUMBER12,

oua.ORG_INFORMATION_NUMBER13,

oua.ORG_INFORMATION_NUMBER14,

oua.ORG_INFORMATION_NUMBER15,

oua.ORG_INFORMATION_NUMBER16,

oua.ORG_INFORMATION_NUMBER17,

oua.ORG_INFORMATION_NUMBER18,

oua.ORG_INFORMATION_NUMBER19,

oua.ORG_INFORMATION_NUMBER20,

oua.ORG_INFORMATION_DATE1,

oua.ORG_INFORMATION_DATE2,

oua.ORG_INFORMATION_DATE3,

oua.ORG_INFORMATION_DATE4,

oua.ORG_INFORMATION_DATE5,

oua.ORG_INFORMATION_DATE6,

oua.ORG_INFORMATION_DATE7,

oua.ORG_INFORMATION_DATE8,

oua.ORG_INFORMATION_DATE9,

oua.ORG_INFORMATION_DATE10,

oua.ORG_INFORMATION_DATE11,

oua.ORG_INFORMATION_DATE12,

oua.ORG_INFORMATION_DATE13,

oua.ORG_INFORMATION_DATE14,

oua.ORG_INFORMATION_DATE15,

oua.ATTRIBUTE_CATEGORY,

oua.ATTRIBUTE1,

oua.ATTRIBUTE2,

oua.ATTRIBUTE3,

oua.ATTRIBUTE4,

oua.ATTRIBUTE5,

oua.ATTRIBUTE6,

oua.ATTRIBUTE7,

oua.ATTRIBUTE8,

oua.ATTRIBUTE9,

oua.ATTRIBUTE10,

oua.ATTRIBUTE11,

oua.ATTRIBUTE12,

oua.ATTRIBUTE13,

oua.ATTRIBUTE14,

oua.ATTRIBUTE15,

oua.ATTRIBUTE16,

oua.ATTRIBUTE17,

oua.ATTRIBUTE18,

oua.ATTRIBUTE19,

oua.ATTRIBUTE20,

oua.ATTRIBUTE21,

oua.ATTRIBUTE22,

oua.ATTRIBUTE23,

oua.ATTRIBUTE24,

oua.ATTRIBUTE25,

oua.ATTRIBUTE26,

oua.ATTRIBUTE27,

oua.ATTRIBUTE28,

oua.ATTRIBUTE29,

oua.ATTRIBUTE30,

oua.OBJECT_VERSION_NUMBER,

oua.CREATED_BY,

oua.CREATION_DATE,

oua.LAST_UPDATED_BY,

oua.LAST_UPDATE_DATE,

oua.LAST_UPDATE_LOGIN

FROM HR_ORGANIZATION_INFORMATION_F oua