PER_EMPLOYEES_CURRENT_X

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

BUSINESS_GROUP_ID

ORGANIZATION_ID

PERSON_ID

ASSIGNMENT_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

WORKER_NUMBER

FULL_NAME

FIRST_NAME

MIDDLE_NAMES

LAST_NAME

TITLE

LOCATION_ID

SUPERVISOR_ID

SET_OF_BOOKS_ID

DEFAULT_CODE_COMB_ID

EXPENSE_CHECK_ADDRESS

ACTUAL_TERMINATION_DATE

EMAIL_ADDRESS

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

ATTRIBUTE_CATEGORY

GLOBAL_NAME

LOCAL_NAME

Query

SQL_Statement

SELECT

PAF.BUSINESS_GROUP_ID

, A.ORGANIZATION_ID

, PAF.PERSON_ID

, A.ASSIGNMENT_ID

, PAF.LAST_UPDATE_DATE

, PAF.LAST_UPDATED_BY

, PAF.LAST_UPDATE_LOGIN

, PAF.CREATION_DATE

, PAF.CREATED_BY

, B.WORKER_NUMBER

, NAME.FULL_NAME

, NAME.FIRST_NAME

, NAME.MIDDLE_NAMES

, NAME.LAST_NAME

, NAME.TITLE

, A.LOCATION_ID

, SUP.MANAGER_ID SUPERVISOR_ID

, A.SET_OF_BOOKS_ID

, A.DEFAULT_CODE_COMB_ID

, A.EXPENSE_CHECK_ADDRESS

, B.ACTUAL_TERMINATION_DATE

, EMAIL.EMAIL_ADDRESS

, PAF.ATTRIBUTE1

, PAF.ATTRIBUTE2

, PAF.ATTRIBUTE3

, PAF.ATTRIBUTE4

, PAF.ATTRIBUTE5

, PAF.ATTRIBUTE6

, PAF.ATTRIBUTE7

, PAF.ATTRIBUTE8

, PAF.ATTRIBUTE9

, PAF.ATTRIBUTE10

, PAF.ATTRIBUTE11

, PAF.ATTRIBUTE12

, PAF.ATTRIBUTE13

, PAF.ATTRIBUTE14

, PAF.ATTRIBUTE15

, PAF.ATTRIBUTE16

, PAF.ATTRIBUTE17

, PAF.ATTRIBUTE18

, PAF.ATTRIBUTE19

, PAF.ATTRIBUTE20

, PAF.ATTRIBUTE21

, PAF.ATTRIBUTE22

, PAF.ATTRIBUTE23

, PAF.ATTRIBUTE24

, PAF.ATTRIBUTE25

, PAF.ATTRIBUTE26

, PAF.ATTRIBUTE27

, PAF.ATTRIBUTE28

, PAF.ATTRIBUTE29

, PAF.ATTRIBUTE30

, PAF.ATTRIBUTE_CATEGORY

,NAME.LIST_NAME GLOBAL_NAME

,NAME.LIST_NAME LOCAL_NAME

FROM PER_ALL_PEOPLE_F PAF,

PER_PERSONS PERSONS,

PER_ALL_ASSIGNMENTS_M A,

PER_PERSON_NAMES_F_V NAME,

PER_PERIODS_OF_SERVICE B,

PER_EMAIL_ADDRESSES EMAIL,

PER_ASSIGNMENT_SUPERVISORS_F SUP

WHERE NAME.PERSON_ID = PAF.PERSON_ID

AND PERSONS.PERSON_ID = PAF.PERSON_ID

AND TRUNC(SYSDATE) BETWEEN NAME.EFFECTIVE_START_DATE AND

NAME.EFFECTIVE_END_DATE

AND A.PERSON_ID = PAF.PERSON_ID

AND A.PRIMARY_FLAG = 'Y'

AND A.ASSIGNMENT_TYPE = 'E'

AND A.PERIOD_OF_SERVICE_ID = B.PERIOD_OF_SERVICE_ID

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

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

AND (B.ACTUAL_TERMINATION_DATE>= trunc(sysdate) or B.ACTUAL_TERMINATION_DATE is null)

AND B.PRIMARY_FLAG = 'Y'

AND EMAIL.EMAIL_ADDRESS_ID(+) = PAF.PRIMARY_EMAIL_ID

AND A.ASSIGNMENT_ID = SUP.ASSIGNMENT_ID (+)

AND SUP.EFFECTIVE_START_DATE(+) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE

AND SUP.PRIMARY_FLAG(+) = 'Y'