PER_ASSIGNMENTS_F

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ACTION_CODE

WORK_TERMS_ASSIGNMENT_ID

APPLICANT_RANK

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

ASSIGNMENT_ID

ASSIGNMENT_NAME

ASSIGNMENT_NUMBER

ASSIGNMENT_SEQUENCE

ASSIGNMENT_STATUS_TYPE

ASSIGNMENT_STATUS_TYPE_ID

ASSIGNMENT_TYPE

AUTO_END_FLAG

BARGAINING_UNIT_CODE

BUSINESS_GROUP_ID

BUSINESS_UNIT_ID

CAGR_GRADE_DEF_ID

CAGR_ID_FLEX_NUM

COLLECTIVE_AGREEMENT_ID

CONTRACT_ID

CREATED_BY

CREATION_DATE

DATE_PROBATION_END

DEFAULT_CODE_COMB_ID

DUTIES_TYPE

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

EFFECTIVE_SEQUENCE

EMPLOYEE_CATEGORY

EMPLOYMENT_CATEGORY

ESTABLISHMENT_ID

EXPENSE_CHECK_ADDRESS

FREQUENCY

GRADE_ID

GRADE_LADDER_PGM_ID

HOURLY_SALARIED_CODE

INTERNAL_BUILDING

INTERNAL_FLOOR

INTERNAL_LOCATION

INTERNAL_MAILSTOP

INTERNAL_OFFICE_NUMBER

JOB_ID

JOB_POST_SOURCE_NAME

LABOUR_UNION_MEMBER_FLAG

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

LEGAL_ENTITY_ID

LEGISLATION_CODE

LINKAGE_TYPE

LOCATION_ID

MANAGER_FLAG

NORMAL_HOURS

NOTICE_PERIOD

NOTICE_PERIOD_UOM

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

PARENT_ASSIGNMENT_ID

PEOPLE_GROUP_ID

PERIOD_OF_SERVICE_ID

PERSON_ID

PERSON_REFERRED_BY_ID

PERSON_TYPE_ID

PO_HEADER_ID

PO_LINE_ID

POSITION_ID

POSTING_CONTENT_ID

PRIMARY_WORK_TERMS_FLAG

PRIMARY_ASSIGNMENT_FLAG

PRIMARY_WORK_RELATION_FLAG

PRIMARY_FLAG

PROBATION_PERIOD

PROBATION_UNIT

PROJECT_TITLE

PROJECTED_ASSIGNMENT_END

PROJECTED_START_DATE

REASON_CODE

RECRUITER_ID

RECRUITMENT_ACTIVITY_ID

SAL_REVIEW_PERIOD

SAL_REVIEW_PERIOD_FREQUENCY

SET_OF_BOOKS_ID

SOFT_CODING_KEYFLEX_ID

SOURCE_ORGANIZATION_ID

SOURCE_TYPE

SPECIAL_CEILING_STEP_ID

STEP_ENTRY_DATE

SYSTEM_PERSON_TYPE

TIME_NORMAL_FINISH

TIME_NORMAL_START

BILLING_TITLE

VACANCY_ID

VENDOR_ASSIGNMENT_NUMBER

VENDOR_EMPLOYEE_NUMBER

VENDOR_ID

VENDOR_SITE_ID

WORK_AT_HOME

ACTION_OCCURRENCE_ID

PROPOSED_WORKER_TYPE

RETIREMENT_AGE

RETIREMENT_DATE

EFFECTIVE_LATEST_CHANGE

POSITION_OVERRIDE_FLAG

ALLOW_ASG_OVERRIDE_FLAG

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

Query

SQL_Statement

SELECT

ACTION_CODE,

WORK_TERMS_ASSIGNMENT_ID,

APPLICANT_RANK,

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,

ASSIGNMENT_ID,

ASSIGNMENT_NAME,

ASSIGNMENT_NUMBER,

ASSIGNMENT_SEQUENCE,

ASSIGNMENT_STATUS_TYPE,

ASSIGNMENT_STATUS_TYPE_ID,

ASSIGNMENT_TYPE,

AUTO_END_FLAG,

BARGAINING_UNIT_CODE,

BUSINESS_GROUP_ID,

BUSINESS_UNIT_ID,

CAGR_GRADE_DEF_ID,

CAGR_ID_FLEX_NUM,

COLLECTIVE_AGREEMENT_ID,

CONTRACT_ID,

CREATED_BY,

CREATION_DATE,

DATE_PROBATION_END,

DEFAULT_CODE_COMB_ID,

DUTIES_TYPE,

EFFECTIVE_END_DATE,

EFFECTIVE_START_DATE,

EFFECTIVE_SEQUENCE,

EMPLOYEE_CATEGORY,

EMPLOYMENT_CATEGORY,

ESTABLISHMENT_ID,

EXPENSE_CHECK_ADDRESS,

FREQUENCY,

GRADE_ID,

GRADE_LADDER_PGM_ID,

HOURLY_SALARIED_CODE,

INTERNAL_BUILDING,

INTERNAL_FLOOR,

INTERNAL_LOCATION,

INTERNAL_MAILSTOP,

INTERNAL_OFFICE_NUMBER,

JOB_ID,

JOB_POST_SOURCE_NAME,

LABOUR_UNION_MEMBER_FLAG,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

LEGAL_ENTITY_ID,

LEGISLATION_CODE,

LINKAGE_TYPE,

LOCATION_ID,

MANAGER_FLAG,

NORMAL_HOURS,

NOTICE_PERIOD,

NOTICE_PERIOD_UOM,

OBJECT_VERSION_NUMBER,

ORGANIZATION_ID,

PARENT_ASSIGNMENT_ID,

PEOPLE_GROUP_ID,

PERIOD_OF_SERVICE_ID,

PERSON_ID,

PERSON_REFERRED_BY_ID,

PERSON_TYPE_ID,

PO_HEADER_ID,

PO_LINE_ID,

POSITION_ID,

POSTING_CONTENT_ID,

PRIMARY_WORK_TERMS_FLAG,

PRIMARY_ASSIGNMENT_FLAG,

PRIMARY_WORK_RELATION_FLAG,

PRIMARY_FLAG,

PROBATION_PERIOD,

PROBATION_UNIT,

PROJECT_TITLE,

PROJECTED_ASSIGNMENT_END,

PROJECTED_START_DATE,

REASON_CODE,

RECRUITER_ID,

RECRUITMENT_ACTIVITY_ID,

SAL_REVIEW_PERIOD,

SAL_REVIEW_PERIOD_FREQUENCY,

SET_OF_BOOKS_ID,

SOFT_CODING_KEYFLEX_ID,

SOURCE_ORGANIZATION_ID,

SOURCE_TYPE,

SPECIAL_CEILING_STEP_ID,

STEP_ENTRY_DATE,

SYSTEM_PERSON_TYPE,

TIME_NORMAL_FINISH,

TIME_NORMAL_START,

BILLING_TITLE,

VACANCY_ID,

VENDOR_ASSIGNMENT_NUMBER,

VENDOR_EMPLOYEE_NUMBER,

VENDOR_ID,

VENDOR_SITE_ID,

WORK_AT_HOME,

ACTION_OCCURRENCE_ID,

PROPOSED_WORKER_TYPE,

RETIREMENT_AGE,

RETIREMENT_DATE,

EFFECTIVE_LATEST_CHANGE,

POSITION_OVERRIDE_FLAG,

ALLOW_ASG_OVERRIDE_FLAG,

paa.ASS_ATTRIBUTE31,

paa.ASS_ATTRIBUTE32,

paa.ASS_ATTRIBUTE33,

paa.ASS_ATTRIBUTE34,

paa.ASS_ATTRIBUTE35,

paa.ASS_ATTRIBUTE36,

paa.ASS_ATTRIBUTE37,

paa.ASS_ATTRIBUTE38,

paa.ASS_ATTRIBUTE39,

paa.ASS_ATTRIBUTE40,

paa.ASS_ATTRIBUTE41,

paa.ASS_ATTRIBUTE42,

paa.ASS_ATTRIBUTE43,

paa.ASS_ATTRIBUTE44,

paa.ASS_ATTRIBUTE45,

paa.ASS_ATTRIBUTE46,

paa.ASS_ATTRIBUTE47,

paa.ASS_ATTRIBUTE48,

paa.ASS_ATTRIBUTE49,

paa.ASS_ATTRIBUTE50,

paa.ASS_ATTRIBUTE_NUMBER1,

paa.ASS_ATTRIBUTE_NUMBER2,

paa.ASS_ATTRIBUTE_NUMBER3,

paa.ASS_ATTRIBUTE_NUMBER4,

paa.ASS_ATTRIBUTE_NUMBER5,

paa.ASS_ATTRIBUTE_NUMBER6,

paa.ASS_ATTRIBUTE_NUMBER7,

paa.ASS_ATTRIBUTE_NUMBER8,

paa.ASS_ATTRIBUTE_NUMBER9,

paa.ASS_ATTRIBUTE_NUMBER10,

paa.ASS_ATTRIBUTE_NUMBER11,

paa.ASS_ATTRIBUTE_NUMBER12,

paa.ASS_ATTRIBUTE_NUMBER13,

paa.ASS_ATTRIBUTE_NUMBER14,

paa.ASS_ATTRIBUTE_NUMBER15,

paa.ASS_ATTRIBUTE_NUMBER16,

paa.ASS_ATTRIBUTE_NUMBER17,

paa.ASS_ATTRIBUTE_NUMBER18,

paa.ASS_ATTRIBUTE_NUMBER19,

paa.ASS_ATTRIBUTE_NUMBER20,

paa.ASS_ATTRIBUTE_DATE1,

paa.ASS_ATTRIBUTE_DATE2,

paa.ASS_ATTRIBUTE_DATE3,

paa.ASS_ATTRIBUTE_DATE4,

paa.ASS_ATTRIBUTE_DATE5,

paa.ASS_ATTRIBUTE_DATE6,

paa.ASS_ATTRIBUTE_DATE7,

paa.ASS_ATTRIBUTE_DATE8,

paa.ASS_ATTRIBUTE_DATE9,

paa.ASS_ATTRIBUTE_DATE10,

paa.ASS_ATTRIBUTE_DATE11,

paa.ASS_ATTRIBUTE_DATE12,

paa.ASS_ATTRIBUTE_DATE13,

paa.ASS_ATTRIBUTE_DATE14,

paa.ASS_ATTRIBUTE_DATE15

FROM

PER_ALL_ASSIGNMENTS_M paa

WHERE

EFFECTIVE_LATEST_CHANGE = 'Y'