PER_ASSIGNMENTS

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

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'

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'