PJC_XLA_EMPLOYEE_REF

Details

Schema: FUSION
Object owner: PJC
Object type: VIEW

Columns

Name
PERSON_NAME PERSON_NUMBER PERSON_TYPE PERSON_ID PERSON_EFFECTIVE_START_DATE PERSON_EFFECTIVE_END_DATE ASSIGNMENT_ID ASSIGNMENT_NAME ASSIGNMENT_NUMBER PERSON_ACCOUNT_CCID PERSON_BU PERSON_LEGAL_ENTITY_NAME DEPARTMENT_NAME SYSTEM_PERSON_TYPE EMP_ASSIGNMENT_CATEGORY ASSIGNMENT_PRIMARY_FLAG ASSIGNMENT_STATUS ASSIGNMENT_LOCATION ASSIGNMENT_WORKER_TYPE ASSIGNMENT_POSITION ASSIGNMENT_JOB ASSIGNMENT_WORKER_CATEGORY ASSIGNMENT_PEOPLE_GROUP ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE1 ASS_ATTRIBUTE2 ASS_ATTRIBUTE3 ASS_ATTRIBUTE4 ASS_ATTRIBUTE5 ASS_ATTRIBUTE6 ASS_ATTRIBUTE7 ASS_ATTRIBUTE8 ASS_ATTRIBUTE9 ASS_ATTRIBUTE10 ASS_ATTRIBUTE11 ASS_ATTRIBUTE12 ASS_ATTRIBUTE13 ASS_ATTRIBUTE14 ASS_ATTRIBUTE15 ASS_ATTRIBUTE16 ASS_ATTRIBUTE17 ASS_ATTRIBUTE18 ASS_ATTRIBUTE19 ASS_ATTRIBUTE20 ASS_ATTRIBUTE21 ASS_ATTRIBUTE22 ASS_ATTRIBUTE23 ASS_ATTRIBUTE24 ASS_ATTRIBUTE25 ASS_ATTRIBUTE26 ASS_ATTRIBUTE27 ASS_ATTRIBUTE28 ASS_ATTRIBUTE29 ASS_ATTRIBUTE30 ASS_ATTRIBUTE31 ASS_ATTRIBUTE32 ASS_ATTRIBUTE33 ASS_ATTRIBUTE34 ASS_ATTRIBUTE35 ASS_ATTRIBUTE36 ASS_ATTRIBUTE37 ASS_ATTRIBUTE38 ASS_ATTRIBUTE39 ASS_ATTRIBUTE40 ASS_ATTRIBUTE41 ASS_ATTRIBUTE42 ASS_ATTRIBUTE43 ASS_ATTRIBUTE44 ASS_ATTRIBUTE45 ASS_ATTRIBUTE46 ASS_ATTRIBUTE47 ASS_ATTRIBUTE48 ASS_ATTRIBUTE49 ASS_ATTRIBUTE50 ASS_ATTRIBUTE_NUMBER1 ASS_ATTRIBUTE_NUMBER2 ASS_ATTRIBUTE_NUMBER3 ASS_ATTRIBUTE_NUMBER4 ASS_ATTRIBUTE_NUMBER5 ASS_ATTRIBUTE_NUMBER6 ASS_ATTRIBUTE_NUMBER7 ASS_ATTRIBUTE_NUMBER8 ASS_ATTRIBUTE_NUMBER9 ASS_ATTRIBUTE_NUMBER10 ASS_ATTRIBUTE_NUMBER11 ASS_ATTRIBUTE_NUMBER12 ASS_ATTRIBUTE_NUMBER13 ASS_ATTRIBUTE_NUMBER14 ASS_ATTRIBUTE_NUMBER15 ASS_ATTRIBUTE_NUMBER16 ASS_ATTRIBUTE_NUMBER17 ASS_ATTRIBUTE_NUMBER18 ASS_ATTRIBUTE_NUMBER19 ASS_ATTRIBUTE_NUMBER20 ASS_ATTRIBUTE_DATE1 ASS_ATTRIBUTE_DATE2 ASS_ATTRIBUTE_DATE3 ASS_ATTRIBUTE_DATE4 ASS_ATTRIBUTE_DATE5 ASS_ATTRIBUTE_DATE6 ASS_ATTRIBUTE_DATE7 ASS_ATTRIBUTE_DATE8 ASS_ATTRIBUTE_DATE9 ASS_ATTRIBUTE_DATE10 ASS_ATTRIBUTE_DATE11 ASS_ATTRIBUTE_DATE12 ASS_ATTRIBUTE_DATE13 ASS_ATTRIBUTE_DATE14 ASS_ATTRIBUTE_DATE15 ASG_INFORMATION_CATEGORY ASG_INFORMATION1 ASG_INFORMATION2 ASG_INFORMATION3 ASG_INFORMATION4 ASG_INFORMATION5 ASG_INFORMATION6 ASG_INFORMATION7 ASG_INFORMATION8 ASG_INFORMATION9 ASG_INFORMATION10 ASG_INFORMATION_NUMBER1 ASG_INFORMATION_NUMBER2 ASG_INFORMATION_NUMBER3 ASG_INFORMATION_NUMBER4 ASG_INFORMATION_NUMBER5 ASG_INFORMATION_NUMBER6 ASG_INFORMATION_NUMBER7 ASG_INFORMATION_NUMBER8 ASG_INFORMATION_NUMBER9 ASG_INFORMATION_NUMBER10 ASG_INFORMATION_DATE1 ASG_INFORMATION_DATE2 ASG_INFORMATION_DATE3 ASG_INFORMATION_DATE4 ASG_INFORMATION_DATE5 ASG_INFORMATION_DATE6 ASG_INFORMATION_DATE7 ASG_INFORMATION_DATE8 ASG_INFORMATION_DATE9 ASG_INFORMATION_DATE10

Name

PERSON_NAME

PERSON_NUMBER

PERSON_TYPE

PERSON_ID

PERSON_EFFECTIVE_START_DATE

PERSON_EFFECTIVE_END_DATE

ASSIGNMENT_ID

ASSIGNMENT_NAME

ASSIGNMENT_NUMBER

PERSON_ACCOUNT_CCID

PERSON_BU

PERSON_LEGAL_ENTITY_NAME

DEPARTMENT_NAME

SYSTEM_PERSON_TYPE

EMP_ASSIGNMENT_CATEGORY

ASSIGNMENT_PRIMARY_FLAG

ASSIGNMENT_STATUS

ASSIGNMENT_LOCATION

ASSIGNMENT_WORKER_TYPE

ASSIGNMENT_POSITION

ASSIGNMENT_JOB

ASSIGNMENT_WORKER_CATEGORY

ASSIGNMENT_PEOPLE_GROUP

ASS_ATTRIBUTE_CATEGORY

ASS_ATTRIBUTE1

ASS_ATTRIBUTE2

ASS_ATTRIBUTE3

ASS_ATTRIBUTE4

ASS_ATTRIBUTE5

ASS_ATTRIBUTE6

ASS_ATTRIBUTE7

ASS_ATTRIBUTE8

ASS_ATTRIBUTE9

ASS_ATTRIBUTE10

ASS_ATTRIBUTE11

ASS_ATTRIBUTE12

ASS_ATTRIBUTE13

ASS_ATTRIBUTE14

ASS_ATTRIBUTE15

ASS_ATTRIBUTE16

ASS_ATTRIBUTE17

ASS_ATTRIBUTE18

ASS_ATTRIBUTE19

ASS_ATTRIBUTE20

ASS_ATTRIBUTE21

ASS_ATTRIBUTE22

ASS_ATTRIBUTE23

ASS_ATTRIBUTE24

ASS_ATTRIBUTE25

ASS_ATTRIBUTE26

ASS_ATTRIBUTE27

ASS_ATTRIBUTE28

ASS_ATTRIBUTE29

ASS_ATTRIBUTE30

ASS_ATTRIBUTE31

ASS_ATTRIBUTE32

ASS_ATTRIBUTE33

ASS_ATTRIBUTE34

ASS_ATTRIBUTE35

ASS_ATTRIBUTE36

ASS_ATTRIBUTE37

ASS_ATTRIBUTE38

ASS_ATTRIBUTE39

ASS_ATTRIBUTE40

ASS_ATTRIBUTE41

ASS_ATTRIBUTE42

ASS_ATTRIBUTE43

ASS_ATTRIBUTE44

ASS_ATTRIBUTE45

ASS_ATTRIBUTE46

ASS_ATTRIBUTE47

ASS_ATTRIBUTE48

ASS_ATTRIBUTE49

ASS_ATTRIBUTE50

ASS_ATTRIBUTE_NUMBER1

ASS_ATTRIBUTE_NUMBER2

ASS_ATTRIBUTE_NUMBER3

ASS_ATTRIBUTE_NUMBER4

ASS_ATTRIBUTE_NUMBER5

ASS_ATTRIBUTE_NUMBER6

ASS_ATTRIBUTE_NUMBER7

ASS_ATTRIBUTE_NUMBER8

ASS_ATTRIBUTE_NUMBER9

ASS_ATTRIBUTE_NUMBER10

ASS_ATTRIBUTE_NUMBER11

ASS_ATTRIBUTE_NUMBER12

ASS_ATTRIBUTE_NUMBER13

ASS_ATTRIBUTE_NUMBER14

ASS_ATTRIBUTE_NUMBER15

ASS_ATTRIBUTE_NUMBER16

ASS_ATTRIBUTE_NUMBER17

ASS_ATTRIBUTE_NUMBER18

ASS_ATTRIBUTE_NUMBER19

ASS_ATTRIBUTE_NUMBER20

ASS_ATTRIBUTE_DATE1

ASS_ATTRIBUTE_DATE2

ASS_ATTRIBUTE_DATE3

ASS_ATTRIBUTE_DATE4

ASS_ATTRIBUTE_DATE5

ASS_ATTRIBUTE_DATE6

ASS_ATTRIBUTE_DATE7

ASS_ATTRIBUTE_DATE8

ASS_ATTRIBUTE_DATE9

ASS_ATTRIBUTE_DATE10

ASS_ATTRIBUTE_DATE11

ASS_ATTRIBUTE_DATE12

ASS_ATTRIBUTE_DATE13

ASS_ATTRIBUTE_DATE14

ASS_ATTRIBUTE_DATE15

ASG_INFORMATION_CATEGORY

ASG_INFORMATION1

ASG_INFORMATION2

ASG_INFORMATION3

ASG_INFORMATION4

ASG_INFORMATION5

ASG_INFORMATION6

ASG_INFORMATION7

ASG_INFORMATION8

ASG_INFORMATION9

ASG_INFORMATION10

ASG_INFORMATION_NUMBER1

ASG_INFORMATION_NUMBER2

ASG_INFORMATION_NUMBER3

ASG_INFORMATION_NUMBER4

ASG_INFORMATION_NUMBER5

ASG_INFORMATION_NUMBER6

ASG_INFORMATION_NUMBER7

ASG_INFORMATION_NUMBER8

ASG_INFORMATION_NUMBER9

ASG_INFORMATION_NUMBER10

ASG_INFORMATION_DATE1

ASG_INFORMATION_DATE2

ASG_INFORMATION_DATE3

ASG_INFORMATION_DATE4

ASG_INFORMATION_DATE5

ASG_INFORMATION_DATE6

ASG_INFORMATION_DATE7

ASG_INFORMATION_DATE8

ASG_INFORMATION_DATE9

ASG_INFORMATION_DATE10

Query

SQL_Statement
SELECT Personname.list_name person_name, person.person_number , personassignment.person_type_id PERSON_TYPE, person.person_id , person.effective_start_date person_effective_start_date , person.effective_end_date person_effective_end_date, personassignment.assignment_id, personassignment.assignment_name, personassignment.assignment_number, Personassignment.DEFAULT_CODE_COMB_ID person_account_ccid, personassignment.Business_Unit_id PERSON_BU, personassignment.legal_entity_id PERSON_LEGAL_ENTITY_NAME, Personassignment.organization_id DEPARTMENT_NAME, personassignment.system_person_type SYSTEM_PERSON_TYPE, personassignment.EMPLOYMENT_CATEGORY EMP_ASSIGNMENT_CATEGORY, personassignment.primary_flag assignment_primary_flag, personassignment.assignment_status_type assignment_status, personassignment.location_id assignment_location, personassignment.assignment_type assignment_worker_type, personassignment.position_id assignment_position, personassignment.job_id assignment_job, personassignment.employee_category assignment_worker_category, personassignment.people_group_id assignment_people_group, personassignment.ass_attribute_category, personassignment.ass_attribute1, personassignment.ass_attribute2, personassignment.ass_attribute3, personassignment.ass_attribute4, personassignment.ass_attribute5, personassignment.ass_attribute6, personassignment.ass_attribute7, personassignment.ass_attribute8, personassignment.ass_attribute9, personassignment.ass_attribute10, personassignment.ass_attribute11, personassignment.ass_attribute12, personassignment.ass_attribute13, personassignment.ass_attribute14, personassignment.ass_attribute15, personassignment.ass_attribute16, personassignment.ass_attribute17, personassignment.ass_attribute18, personassignment.ass_attribute19, personassignment.ass_attribute20, personassignment.ass_attribute21, personassignment.ass_attribute22, personassignment.ass_attribute23, personassignment.ass_attribute24, personassignment.ass_attribute25, personassignment.ass_attribute26, personassignment.ass_attribute27, personassignment.ass_attribute28, personassignment.ass_attribute29, personassignment.ass_attribute30, personassignment.ass_attribute31, personassignment.ass_attribute32, personassignment.ass_attribute33, personassignment.ass_attribute34, personassignment.ass_attribute35, personassignment.ass_attribute36, personassignment.ass_attribute37, personassignment.ass_attribute38, personassignment.ass_attribute39, personassignment.ass_attribute40, personassignment.ass_attribute41, personassignment.ass_attribute42, personassignment.ass_attribute43, personassignment.ass_attribute44, personassignment.ass_attribute45, personassignment.ass_attribute46, personassignment.ass_attribute47, personassignment.ass_attribute48, personassignment.ass_attribute49, personassignment.ass_attribute50, personassignment.ass_attribute_number1, personassignment.ass_attribute_number2, personassignment.ass_attribute_number3, personassignment.ass_attribute_number4, personassignment.ass_attribute_number5, personassignment.ass_attribute_number6, personassignment.ass_attribute_number7, personassignment.ass_attribute_number8, personassignment.ass_attribute_number9, personassignment.ass_attribute_number10, personassignment.ass_attribute_number11, personassignment.ass_attribute_number12, personassignment.ass_attribute_number13, personassignment.ass_attribute_number14, personassignment.ass_attribute_number15, personassignment.ass_attribute_number16, personassignment.ass_attribute_number17, personassignment.ass_attribute_number18, personassignment.ass_attribute_number19, personassignment.ass_attribute_number20, personassignment.ass_attribute_date1, personassignment.ass_attribute_date2, personassignment.ass_attribute_date3, personassignment.ass_attribute_date4, personassignment.ass_attribute_date5, personassignment.ass_attribute_date6, personassignment.ass_attribute_date7, personassignment.ass_attribute_date8, personassignment.ass_attribute_date9, personassignment.ass_attribute_date10, personassignment.ass_attribute_date11, personassignment.ass_attribute_date12, personassignment.ass_attribute_date13, personassignment.ass_attribute_date14, personassignment.ass_attribute_date15, personassignment.asg_information_category, personassignment.asg_information1, personassignment.asg_information2, personassignment.asg_information3, personassignment.asg_information4, personassignment.asg_information5, personassignment.asg_information6, personassignment.asg_information7, personassignment.asg_information8, personassignment.asg_information9, personassignment.asg_information10, personassignment.asg_information_number1, personassignment.asg_information_number2, personassignment.asg_information_number3, personassignment.asg_information_number4, personassignment.asg_information_number5, personassignment.asg_information_number6, personassignment.asg_information_number7, personassignment.asg_information_number8, personassignment.asg_information_number9, personassignment.asg_information_number10, personassignment.asg_information_date1, personassignment.asg_information_date2, personassignment.asg_information_date3, personassignment.asg_information_date4, personassignment.asg_information_date5, personassignment.asg_information_date6, personassignment.asg_information_date7, personassignment.asg_information_date8, personassignment.asg_information_date9, personassignment.asg_information_date10 FROM per_all_people_f person , per_all_assignments_m personassignment, PER_PERSON_NAMES_F personname WHERE personassignment.person_id = person.person_id AND personassignment.EFFECTIVE_LATEST_CHANGE = 'Y' AND TRUNC(SYSDATE) BETWEEN TRUNC(personassignment.effective_start_date) AND TRUNC(personassignment.effective_end_date) AND personname.person_id=person.person_id AND TRUNC(SYSDATE) BETWEEN TRUNC(personname.effective_start_date) AND TRUNC(personname.effective_end_date) AND TRUNC(SYSDATE) BETWEEN TRUNC(person.effective_start_date) AND TRUNC(person.effective_end_date) AND personname.name_type = 'GLOBAL' and personassignment.person_type_id is not null

SQL_Statement

SELECT Personname.list_name person_name,

person.person_number ,

personassignment.person_type_id PERSON_TYPE,

person.person_id ,

person.effective_start_date person_effective_start_date ,

person.effective_end_date person_effective_end_date,

personassignment.assignment_id,

personassignment.assignment_name,

personassignment.assignment_number,

Personassignment.DEFAULT_CODE_COMB_ID person_account_ccid,

personassignment.Business_Unit_id PERSON_BU,

personassignment.legal_entity_id PERSON_LEGAL_ENTITY_NAME,

Personassignment.organization_id DEPARTMENT_NAME,

personassignment.system_person_type SYSTEM_PERSON_TYPE,

personassignment.EMPLOYMENT_CATEGORY EMP_ASSIGNMENT_CATEGORY,

personassignment.primary_flag assignment_primary_flag,

personassignment.assignment_status_type assignment_status,

personassignment.location_id assignment_location,

personassignment.assignment_type assignment_worker_type,

personassignment.position_id assignment_position,

personassignment.job_id assignment_job,

personassignment.employee_category assignment_worker_category,

personassignment.people_group_id assignment_people_group,

personassignment.ass_attribute_category,

personassignment.ass_attribute1,

personassignment.ass_attribute2,

personassignment.ass_attribute3,

personassignment.ass_attribute4,

personassignment.ass_attribute5,

personassignment.ass_attribute6,

personassignment.ass_attribute7,

personassignment.ass_attribute8,

personassignment.ass_attribute9,

personassignment.ass_attribute10,

personassignment.ass_attribute11,

personassignment.ass_attribute12,

personassignment.ass_attribute13,

personassignment.ass_attribute14,

personassignment.ass_attribute15,

personassignment.ass_attribute16,

personassignment.ass_attribute17,

personassignment.ass_attribute18,

personassignment.ass_attribute19,

personassignment.ass_attribute20,

personassignment.ass_attribute21,

personassignment.ass_attribute22,

personassignment.ass_attribute23,

personassignment.ass_attribute24,

personassignment.ass_attribute25,

personassignment.ass_attribute26,

personassignment.ass_attribute27,

personassignment.ass_attribute28,

personassignment.ass_attribute29,

personassignment.ass_attribute30,

personassignment.ass_attribute31,

personassignment.ass_attribute32,

personassignment.ass_attribute33,

personassignment.ass_attribute34,

personassignment.ass_attribute35,

personassignment.ass_attribute36,

personassignment.ass_attribute37,

personassignment.ass_attribute38,

personassignment.ass_attribute39,

personassignment.ass_attribute40,

personassignment.ass_attribute41,

personassignment.ass_attribute42,

personassignment.ass_attribute43,

personassignment.ass_attribute44,

personassignment.ass_attribute45,

personassignment.ass_attribute46,

personassignment.ass_attribute47,

personassignment.ass_attribute48,

personassignment.ass_attribute49,

personassignment.ass_attribute50,

personassignment.ass_attribute_number1,

personassignment.ass_attribute_number2,

personassignment.ass_attribute_number3,

personassignment.ass_attribute_number4,

personassignment.ass_attribute_number5,

personassignment.ass_attribute_number6,

personassignment.ass_attribute_number7,

personassignment.ass_attribute_number8,

personassignment.ass_attribute_number9,

personassignment.ass_attribute_number10,

personassignment.ass_attribute_number11,

personassignment.ass_attribute_number12,

personassignment.ass_attribute_number13,

personassignment.ass_attribute_number14,

personassignment.ass_attribute_number15,

personassignment.ass_attribute_number16,

personassignment.ass_attribute_number17,

personassignment.ass_attribute_number18,

personassignment.ass_attribute_number19,

personassignment.ass_attribute_number20,

personassignment.ass_attribute_date1,

personassignment.ass_attribute_date2,

personassignment.ass_attribute_date3,

personassignment.ass_attribute_date4,

personassignment.ass_attribute_date5,

personassignment.ass_attribute_date6,

personassignment.ass_attribute_date7,

personassignment.ass_attribute_date8,

personassignment.ass_attribute_date9,

personassignment.ass_attribute_date10,

personassignment.ass_attribute_date11,

personassignment.ass_attribute_date12,

personassignment.ass_attribute_date13,

personassignment.ass_attribute_date14,

personassignment.ass_attribute_date15,

personassignment.asg_information_category,

personassignment.asg_information1,

personassignment.asg_information2,

personassignment.asg_information3,

personassignment.asg_information4,

personassignment.asg_information5,

personassignment.asg_information6,

personassignment.asg_information7,

personassignment.asg_information8,

personassignment.asg_information9,

personassignment.asg_information10,

personassignment.asg_information_number1,

personassignment.asg_information_number2,

personassignment.asg_information_number3,

personassignment.asg_information_number4,

personassignment.asg_information_number5,

personassignment.asg_information_number6,

personassignment.asg_information_number7,

personassignment.asg_information_number8,

personassignment.asg_information_number9,

personassignment.asg_information_number10,

personassignment.asg_information_date1,

personassignment.asg_information_date2,

personassignment.asg_information_date3,

personassignment.asg_information_date4,

personassignment.asg_information_date5,

personassignment.asg_information_date6,

personassignment.asg_information_date7,

personassignment.asg_information_date8,

personassignment.asg_information_date9,

personassignment.asg_information_date10

FROM per_all_people_f person ,

per_all_assignments_m personassignment,

PER_PERSON_NAMES_F personname

WHERE personassignment.person_id = person.person_id

AND personassignment.EFFECTIVE_LATEST_CHANGE = 'Y'

AND TRUNC(SYSDATE) BETWEEN TRUNC(personassignment.effective_start_date) AND TRUNC(personassignment.effective_end_date)

AND personname.person_id=person.person_id

AND TRUNC(SYSDATE) BETWEEN TRUNC(personname.effective_start_date) AND TRUNC(personname.effective_end_date)

AND TRUNC(SYSDATE) BETWEEN TRUNC(person.effective_start_date) AND TRUNC(person.effective_end_date)

AND personname.name_type = 'GLOBAL'

and personassignment.person_type_id is not null