1. Tables and Views for Project Management
  2. PJC_PERSON_ASSIGNMENT_SRC_V

PJC_PERSON_ASSIGNMENT_SRC_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

RUN_ID

PERSON_ID

ASSIGNMENT_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ASSIGNMENT_NUMBER_ID

BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME_ID

ASSIGNMENTSTATUS

PRIMARY_FLAG

PERSONTYPE

LOCATION_ID

LOCATION_NAME_ID

WORKERTYPECODE

WORKERTYPE

POSITION_ID

POSITION_NAME_ID

POSITION_CODE_ID

JOB_ID

JOB_NAME_ID

DEPARTMENTID

DEPARTMENT_NAME_ID

ASSIGNMENTCATEGORYCODE

ASSIGNMENTCATEGORY

WORKERCATEGORYCODE

WORKERCATEGORY

PEOPLE_GROUP_ID

PEOPLE_GROUP_NAME_ID

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_INFORMATION11

ASG_INFORMATION12

ASG_INFORMATION13

ASG_INFORMATION14

ASG_INFORMATION15

ASG_INFORMATION16

ASG_INFORMATION17

ASG_INFORMATION18

ASG_INFORMATION19

ASG_INFORMATION20

ASG_INFORMATION21

ASG_INFORMATION22

ASG_INFORMATION23

ASG_INFORMATION24

ASG_INFORMATION25

ASG_INFORMATION26

ASG_INFORMATION27

ASG_INFORMATION28

ASG_INFORMATION29

ASG_INFORMATION30

ASG_INFORMATION31

ASG_INFORMATION32

ASG_INFORMATION33

ASG_INFORMATION34

ASG_INFORMATION35

ASG_INFORMATION36

ASG_INFORMATION37

ASG_INFORMATION38

ASG_INFORMATION39

ASG_INFORMATION40

ASG_INFORMATION41

ASG_INFORMATION42

ASG_INFORMATION43

ASG_INFORMATION44

ASG_INFORMATION45

ASG_INFORMATION46

ASG_INFORMATION47

ASG_INFORMATION48

ASG_INFORMATION49

ASG_INFORMATION50

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_NUMBER11

ASG_INFORMATION_NUMBER12

ASG_INFORMATION_NUMBER13

ASG_INFORMATION_NUMBER14

ASG_INFORMATION_NUMBER15

ASG_INFORMATION_NUMBER16

ASG_INFORMATION_NUMBER17

ASG_INFORMATION_NUMBER18

ASG_INFORMATION_NUMBER19

ASG_INFORMATION_NUMBER20

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

ASG_INFORMATION_DATE11

ASG_INFORMATION_DATE12

ASG_INFORMATION_DATE13

ASG_INFORMATION_DATE14

ASG_INFORMATION_DATE15

Query

SQL_Statement

SELECT

labordistrunsallpeo.run_id,

assignmentdpeo.person_id,

assignmentdpeo.assignment_id,

assignmentdpeo.effective_start_date,

assignmentdpeo.effective_end_date,

assignmentdpeo.assignment_id Assignment_Number_Id,

assignmentdpeo.business_unit_id,

assignmentdpeo.business_unit_id Business_Unit_Name_Id,

assignmentdpeo.assignment_status_type AssignmentStatus,

assignmentdpeo.primary_flag,

assignmentdpeo.system_person_type PersonType,

assignmentdpeo.location_id,

assignmentdpeo.location_id Location_Name_Id,

workertypelookuppeo.lookup_code WorkerTypeCode,

workertypelookuppeo.meaning WorkerType,

assignmentdpeo.position_id,

assignmentdpeo.position_id Position_Name_Id,

assignmentdpeo.position_id Position_Code_Id,

assignmentdpeo.job_id,

assignmentdpeo.job_id Job_Name_Id,

assignmentdpeo.organization_id DepartmentId,

assignmentdpeo.organization_id Department_Name_Id,

assignmentdpeo.employment_category AssignmentCategoryCode,

assignmentcategorylookuppeo.meaning AssignmentCategory,

assignmentdpeo.employee_category WorkerCategoryCode,

workercategorylookuppeo.meaning WorkerCategory,

assignmentdpeo.people_group_id,

assignmentdpeo.people_group_id People_Group_Name_Id,

assignmentdpeo.Ass_Attribute_Category,

assignmentdpeo.Ass_Attribute1,

assignmentdpeo.Ass_Attribute2,

assignmentdpeo.Ass_Attribute3,

assignmentdpeo.Ass_Attribute4,

assignmentdpeo.Ass_Attribute5,

assignmentdpeo.Ass_Attribute6,

assignmentdpeo.Ass_Attribute7,

assignmentdpeo.Ass_Attribute8,

assignmentdpeo.Ass_Attribute9,

assignmentdpeo.Ass_Attribute10,

assignmentdpeo.Ass_Attribute11,

assignmentdpeo.Ass_Attribute12,

assignmentdpeo.Ass_Attribute13,

assignmentdpeo.Ass_Attribute14,

assignmentdpeo.Ass_Attribute15,

assignmentdpeo.Ass_Attribute16,

assignmentdpeo.Ass_Attribute17,

assignmentdpeo.Ass_Attribute18,

assignmentdpeo.Ass_Attribute19,

assignmentdpeo.Ass_Attribute20,

assignmentdpeo.Ass_Attribute21,

assignmentdpeo.Ass_Attribute22,

assignmentdpeo.Ass_Attribute23,

assignmentdpeo.Ass_Attribute24,

assignmentdpeo.Ass_Attribute25,

assignmentdpeo.Ass_Attribute26,

assignmentdpeo.Ass_Attribute27,

assignmentdpeo.Ass_Attribute28,

assignmentdpeo.Ass_Attribute29,

assignmentdpeo.Ass_Attribute30,

assignmentdpeo.Ass_Attribute31,

assignmentdpeo.Ass_Attribute32,

assignmentdpeo.Ass_Attribute33,

assignmentdpeo.Ass_Attribute34,

assignmentdpeo.Ass_Attribute35,

assignmentdpeo.Ass_Attribute36,

assignmentdpeo.Ass_Attribute37,

assignmentdpeo.Ass_Attribute38,

assignmentdpeo.Ass_Attribute39,

assignmentdpeo.Ass_Attribute40,

assignmentdpeo.Ass_Attribute41,

assignmentdpeo.Ass_Attribute42,

assignmentdpeo.Ass_Attribute43,

assignmentdpeo.Ass_Attribute44,

assignmentdpeo.Ass_Attribute45,

assignmentdpeo.Ass_Attribute46,

assignmentdpeo.Ass_Attribute47,

assignmentdpeo.Ass_Attribute48,

assignmentdpeo.Ass_Attribute49,

assignmentdpeo.Ass_Attribute50,

assignmentdpeo.Ass_Attribute_Number1,

assignmentdpeo.Ass_Attribute_Number2,

assignmentdpeo.Ass_Attribute_Number3,

assignmentdpeo.Ass_Attribute_Number4,

assignmentdpeo.Ass_Attribute_Number5,

assignmentdpeo.Ass_Attribute_Number6,

assignmentdpeo.Ass_Attribute_Number7,

assignmentdpeo.Ass_Attribute_Number8,

assignmentdpeo.Ass_Attribute_Number9,

assignmentdpeo.Ass_Attribute_Number10,

assignmentdpeo.Ass_Attribute_Number11,

assignmentdpeo.Ass_Attribute_Number12,

assignmentdpeo.Ass_Attribute_Number13,

assignmentdpeo.Ass_Attribute_Number14,

assignmentdpeo.Ass_Attribute_Number15,

assignmentdpeo.Ass_Attribute_Number16,

assignmentdpeo.Ass_Attribute_Number17,

assignmentdpeo.Ass_Attribute_Number18,

assignmentdpeo.Ass_Attribute_Number19,

assignmentdpeo.Ass_Attribute_Number20,

assignmentdpeo.Ass_Attribute_Date1,

assignmentdpeo.Ass_Attribute_Date2,

assignmentdpeo.Ass_Attribute_Date3,

assignmentdpeo.Ass_Attribute_Date4,

assignmentdpeo.Ass_Attribute_Date5,

assignmentdpeo.Ass_Attribute_Date6,

assignmentdpeo.Ass_Attribute_Date7,

assignmentdpeo.Ass_Attribute_Date8,

assignmentdpeo.Ass_Attribute_Date9,

assignmentdpeo.Ass_Attribute_Date10,

assignmentdpeo.Ass_Attribute_Date11,

assignmentdpeo.Ass_Attribute_Date12,

assignmentdpeo.Ass_Attribute_Date13,

assignmentdpeo.Ass_Attribute_Date14,

assignmentdpeo.Ass_Attribute_Date15,

assignmentdpeo.Asg_Information_Category,

assignmentdpeo.Asg_Information1,

assignmentdpeo.Asg_Information2,

assignmentdpeo.Asg_Information3,

assignmentdpeo.Asg_Information4,

assignmentdpeo.Asg_Information5,

assignmentdpeo.Asg_Information6,

assignmentdpeo.Asg_Information7,

assignmentdpeo.Asg_Information8,

assignmentdpeo.Asg_Information9,

assignmentdpeo.Asg_Information10,

assignmentdpeo.Asg_Information11,

assignmentdpeo.Asg_Information12,

assignmentdpeo.Asg_Information13,

assignmentdpeo.Asg_Information14,

assignmentdpeo.Asg_Information15,

assignmentdpeo.Asg_Information16,

assignmentdpeo.Asg_Information17,

assignmentdpeo.Asg_Information18,

assignmentdpeo.Asg_Information19,

assignmentdpeo.Asg_Information20,

assignmentdpeo.Asg_Information21,

assignmentdpeo.Asg_Information22,

assignmentdpeo.Asg_Information23,

assignmentdpeo.Asg_Information24,

assignmentdpeo.Asg_Information25,

assignmentdpeo.Asg_Information26,

assignmentdpeo.Asg_Information27,

assignmentdpeo.Asg_Information28,

assignmentdpeo.Asg_Information29,

assignmentdpeo.Asg_Information30,

assignmentdpeo.Asg_Information31,

assignmentdpeo.Asg_Information32,

assignmentdpeo.Asg_Information33,

assignmentdpeo.Asg_Information34,

assignmentdpeo.Asg_Information35,

assignmentdpeo.Asg_Information36,

assignmentdpeo.Asg_Information37,

assignmentdpeo.Asg_Information38,

assignmentdpeo.Asg_Information39,

assignmentdpeo.Asg_Information40,

assignmentdpeo.Asg_Information41,

assignmentdpeo.Asg_Information42,

assignmentdpeo.Asg_Information43,

assignmentdpeo.Asg_Information44,

assignmentdpeo.Asg_Information45,

assignmentdpeo.Asg_Information46,

assignmentdpeo.Asg_Information47,

assignmentdpeo.Asg_Information48,

assignmentdpeo.Asg_Information49,

assignmentdpeo.Asg_Information50,

assignmentdpeo.Asg_Information_Number1,

assignmentdpeo.Asg_Information_Number2,

assignmentdpeo.Asg_Information_Number3,

assignmentdpeo.Asg_Information_Number4,

assignmentdpeo.Asg_Information_Number5,

assignmentdpeo.Asg_Information_Number6,

assignmentdpeo.Asg_Information_Number7,

assignmentdpeo.Asg_Information_Number8,

assignmentdpeo.Asg_Information_Number9,

assignmentdpeo.Asg_Information_Number10,

assignmentdpeo.Asg_Information_Number11,

assignmentdpeo.Asg_Information_Number12,

assignmentdpeo.Asg_Information_Number13,

assignmentdpeo.Asg_Information_Number14,

assignmentdpeo.Asg_Information_Number15,

assignmentdpeo.Asg_Information_Number16,

assignmentdpeo.Asg_Information_Number17,

assignmentdpeo.Asg_Information_Number18,

assignmentdpeo.Asg_Information_Number19,

assignmentdpeo.Asg_Information_Number20,

assignmentdpeo.Asg_Information_Date1,

assignmentdpeo.Asg_Information_Date2,

assignmentdpeo.Asg_Information_Date3,

assignmentdpeo.Asg_Information_Date4,

assignmentdpeo.Asg_Information_Date5,

assignmentdpeo.Asg_Information_Date6,

assignmentdpeo.Asg_Information_Date7,

assignmentdpeo.Asg_Information_Date8,

assignmentdpeo.Asg_Information_Date9,

assignmentdpeo.Asg_Information_Date10,

assignmentdpeo.Asg_Information_Date11,

assignmentdpeo.Asg_Information_Date12,

assignmentdpeo.Asg_Information_Date13,

assignmentdpeo.Asg_Information_Date14,

assignmentdpeo.Asg_Information_Date15

FROM

pjc_alloc_runs_all labordistrunsallpeo,

per_all_assignments_m assignmentdpeo,

hcm_lookups workercategorylookuppeo,

hcm_lookups workertypelookuppeo,

hcm_lookups assignmentcategorylookuppeo

WHERE

labordistrunsallpeo.ld_assignment_id = assignmentdpeo.assignment_id

AND labordistrunsallpeo.expnd_item_date BETWEEN assignmentdpeo.effective_start_date AND assignmentdpeo.effective_end_date

AND assignmentdpeo.Effective_Latest_Change = 'Y'

AND assignmentdpeo.WORK_TERMS_ASSIGNMENT_ID IS NOT NULL

AND assignmentdpeo.employee_category = workercategorylookuppeo.lookup_code (+)

AND workercategorylookuppeo.lookup_type (+) = 'EMPLOYEE_CATG'

AND assignmentdpeo.assignment_type = workertypelookuppeo.lookup_code (+)

AND workertypelookuppeo.LOOKUP_TYPE (+) = 'PER_PERIOD_TYPE'

AND assignmentdpeo.employment_category = assignmentcategorylookuppeo.lookup_code (+)

AND assignmentcategorylookuppeo.lookup_type (+) = 'EMP_CAT'