PER_ALL_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 FREEZE_START_DATE FREEZE_UNTIL_DATE ID_FLEX_NUM 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 UNION_ID SENIORITY_BASIS OVERTIME_PERIOD SOURCE_ASSIGNMENT_ID

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

FREEZE_START_DATE

FREEZE_UNTIL_DATE

ID_FLEX_NUM

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

UNION_ID

SENIORITY_BASIS

OVERTIME_PERIOD

SOURCE_ASSIGNMENT_ID

Query

SQL_Statement
SELECT paa.ACTION_CODE, paa.WORK_TERMS_ASSIGNMENT_ID, paa.APPLICANT_RANK, paa.ASS_ATTRIBUTE_CATEGORY, paa.ASS_ATTRIBUTE1, paa.ASS_ATTRIBUTE2, paa.ASS_ATTRIBUTE3, paa.ASS_ATTRIBUTE4, paa.ASS_ATTRIBUTE5, paa.ASS_ATTRIBUTE6, paa.ASS_ATTRIBUTE7, paa.ASS_ATTRIBUTE8, paa.ASS_ATTRIBUTE9, paa.ASS_ATTRIBUTE10, paa.ASS_ATTRIBUTE11, paa.ASS_ATTRIBUTE12, paa.ASS_ATTRIBUTE13, paa.ASS_ATTRIBUTE14, paa.ASS_ATTRIBUTE15, paa.ASS_ATTRIBUTE16, paa.ASS_ATTRIBUTE17, paa.ASS_ATTRIBUTE18, paa.ASS_ATTRIBUTE19, paa.ASS_ATTRIBUTE20, paa.ASS_ATTRIBUTE21, paa.ASS_ATTRIBUTE22, paa.ASS_ATTRIBUTE23, paa.ASS_ATTRIBUTE24, paa.ASS_ATTRIBUTE25, paa.ASS_ATTRIBUTE26, paa.ASS_ATTRIBUTE27, paa.ASS_ATTRIBUTE28, paa.ASS_ATTRIBUTE29, paa.ASS_ATTRIBUTE30, paa.ASSIGNMENT_ID, paa.ASSIGNMENT_NAME, paa.ASSIGNMENT_NUMBER, paa.ASSIGNMENT_SEQUENCE, paa.ASSIGNMENT_STATUS_TYPE, paa.ASSIGNMENT_STATUS_TYPE_ID, paa.ASSIGNMENT_TYPE, paa.AUTO_END_FLAG, paa.BARGAINING_UNIT_CODE, paa.BUSINESS_GROUP_ID, paa.BUSINESS_UNIT_ID, paa.CAGR_GRADE_DEF_ID, paa.CAGR_ID_FLEX_NUM, paa.COLLECTIVE_AGREEMENT_ID, paa.CONTRACT_ID, paa.CREATED_BY, paa.CREATION_DATE, paa.DATE_PROBATION_END, paa.DEFAULT_CODE_COMB_ID, paa.DUTIES_TYPE, paa.EFFECTIVE_END_DATE, paa.EFFECTIVE_START_DATE, paa.EFFECTIVE_SEQUENCE, paa.EMPLOYEE_CATEGORY, paa.EMPLOYMENT_CATEGORY, paa.ESTABLISHMENT_ID, paa.EXPENSE_CHECK_ADDRESS, paa.FREQUENCY, paa.GRADE_ID, paa.GRADE_LADDER_PGM_ID, paa.HOURLY_SALARIED_CODE, paa.INTERNAL_BUILDING, paa.INTERNAL_FLOOR, paa.INTERNAL_LOCATION, paa.INTERNAL_MAILSTOP, paa.INTERNAL_OFFICE_NUMBER, paa.JOB_ID, paa.JOB_POST_SOURCE_NAME, paa.LABOUR_UNION_MEMBER_FLAG, paa.LAST_UPDATE_DATE, paa.LAST_UPDATE_LOGIN, paa.LAST_UPDATED_BY, paa.LEGAL_ENTITY_ID, paa.LEGISLATION_CODE, paa.LINKAGE_TYPE, paa.LOCATION_ID, paa.MANAGER_FLAG, paa.NORMAL_HOURS, paa.NOTICE_PERIOD, paa.NOTICE_PERIOD_UOM, paa.OBJECT_VERSION_NUMBER, paa.ORGANIZATION_ID, paa.PARENT_ASSIGNMENT_ID, paa.PEOPLE_GROUP_ID, paa.PERIOD_OF_SERVICE_ID, paa.PERSON_ID, paa.PERSON_REFERRED_BY_ID, paa.PERSON_TYPE_ID, paa.PO_HEADER_ID, paa.PO_LINE_ID, paa.POSITION_ID, paa.POSTING_CONTENT_ID, paa.PRIMARY_WORK_TERMS_FLAG, paa.PRIMARY_ASSIGNMENT_FLAG, paa.PRIMARY_WORK_RELATION_FLAG, paa.PRIMARY_FLAG, paa.PROBATION_PERIOD, paa.PROBATION_UNIT, paa.PROJECT_TITLE, paa.PROJECTED_ASSIGNMENT_END, paa.PROJECTED_START_DATE, paa.REASON_CODE, paa.RECRUITER_ID, paa.RECRUITMENT_ACTIVITY_ID, paa.SAL_REVIEW_PERIOD, paa.SAL_REVIEW_PERIOD_FREQUENCY, paa.SET_OF_BOOKS_ID, paa.SOFT_CODING_KEYFLEX_ID, paa.SOURCE_ORGANIZATION_ID, paa.SOURCE_TYPE, paa.SPECIAL_CEILING_STEP_ID, paa.STEP_ENTRY_DATE, paa.SYSTEM_PERSON_TYPE, paa.TIME_NORMAL_FINISH, paa.TIME_NORMAL_START, paa.BILLING_TITLE, paa.VACANCY_ID, paa.VENDOR_ASSIGNMENT_NUMBER, paa.VENDOR_EMPLOYEE_NUMBER, paa.VENDOR_ID, paa.VENDOR_SITE_ID, paa.WORK_AT_HOME, paa.ACTION_OCCURRENCE_ID, paa.PROPOSED_WORKER_TYPE, paa.RETIREMENT_AGE, paa.RETIREMENT_DATE, paa.EFFECTIVE_LATEST_CHANGE, paa.POSITION_OVERRIDE_FLAG, paa.ALLOW_ASG_OVERRIDE_FLAG, paa.FREEZE_START_DATE, paa.FREEZE_UNTIL_DATE, paa.ID_FLEX_NUM, 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, paa.UNION_ID, paa.SENIORITY_BASIS, paa.OVERTIME_PERIOD, paa.SOURCE_ASSIGNMENT_ID FROM PER_ALL_ASSIGNMENTS_M paa WHERE EFFECTIVE_LATEST_CHANGE = 'Y'

SQL_Statement

SELECT

paa.ACTION_CODE,

paa.WORK_TERMS_ASSIGNMENT_ID,

paa.APPLICANT_RANK,

paa.ASS_ATTRIBUTE_CATEGORY,

paa.ASS_ATTRIBUTE1,

paa.ASS_ATTRIBUTE2,

paa.ASS_ATTRIBUTE3,

paa.ASS_ATTRIBUTE4,

paa.ASS_ATTRIBUTE5,

paa.ASS_ATTRIBUTE6,

paa.ASS_ATTRIBUTE7,

paa.ASS_ATTRIBUTE8,

paa.ASS_ATTRIBUTE9,

paa.ASS_ATTRIBUTE10,

paa.ASS_ATTRIBUTE11,

paa.ASS_ATTRIBUTE12,

paa.ASS_ATTRIBUTE13,

paa.ASS_ATTRIBUTE14,

paa.ASS_ATTRIBUTE15,

paa.ASS_ATTRIBUTE16,

paa.ASS_ATTRIBUTE17,

paa.ASS_ATTRIBUTE18,

paa.ASS_ATTRIBUTE19,

paa.ASS_ATTRIBUTE20,

paa.ASS_ATTRIBUTE21,

paa.ASS_ATTRIBUTE22,

paa.ASS_ATTRIBUTE23,

paa.ASS_ATTRIBUTE24,

paa.ASS_ATTRIBUTE25,

paa.ASS_ATTRIBUTE26,

paa.ASS_ATTRIBUTE27,

paa.ASS_ATTRIBUTE28,

paa.ASS_ATTRIBUTE29,

paa.ASS_ATTRIBUTE30,

paa.ASSIGNMENT_ID,

paa.ASSIGNMENT_NAME,

paa.ASSIGNMENT_NUMBER,

paa.ASSIGNMENT_SEQUENCE,

paa.ASSIGNMENT_STATUS_TYPE,

paa.ASSIGNMENT_STATUS_TYPE_ID,

paa.ASSIGNMENT_TYPE,

paa.AUTO_END_FLAG,

paa.BARGAINING_UNIT_CODE,

paa.BUSINESS_GROUP_ID,

paa.BUSINESS_UNIT_ID,

paa.CAGR_GRADE_DEF_ID,

paa.CAGR_ID_FLEX_NUM,

paa.COLLECTIVE_AGREEMENT_ID,

paa.CONTRACT_ID,

paa.CREATED_BY,

paa.CREATION_DATE,

paa.DATE_PROBATION_END,

paa.DEFAULT_CODE_COMB_ID,

paa.DUTIES_TYPE,

paa.EFFECTIVE_END_DATE,

paa.EFFECTIVE_START_DATE,

paa.EFFECTIVE_SEQUENCE,

paa.EMPLOYEE_CATEGORY,

paa.EMPLOYMENT_CATEGORY,

paa.ESTABLISHMENT_ID,

paa.EXPENSE_CHECK_ADDRESS,

paa.FREQUENCY,

paa.GRADE_ID,

paa.GRADE_LADDER_PGM_ID,

paa.HOURLY_SALARIED_CODE,

paa.INTERNAL_BUILDING,

paa.INTERNAL_FLOOR,

paa.INTERNAL_LOCATION,

paa.INTERNAL_MAILSTOP,

paa.INTERNAL_OFFICE_NUMBER,

paa.JOB_ID,

paa.JOB_POST_SOURCE_NAME,

paa.LABOUR_UNION_MEMBER_FLAG,

paa.LAST_UPDATE_DATE,

paa.LAST_UPDATE_LOGIN,

paa.LAST_UPDATED_BY,

paa.LEGAL_ENTITY_ID,

paa.LEGISLATION_CODE,

paa.LINKAGE_TYPE,

paa.LOCATION_ID,

paa.MANAGER_FLAG,

paa.NORMAL_HOURS,

paa.NOTICE_PERIOD,

paa.NOTICE_PERIOD_UOM,

paa.OBJECT_VERSION_NUMBER,

paa.ORGANIZATION_ID,

paa.PARENT_ASSIGNMENT_ID,

paa.PEOPLE_GROUP_ID,

paa.PERIOD_OF_SERVICE_ID,

paa.PERSON_ID,

paa.PERSON_REFERRED_BY_ID,

paa.PERSON_TYPE_ID,

paa.PO_HEADER_ID,

paa.PO_LINE_ID,

paa.POSITION_ID,

paa.POSTING_CONTENT_ID,

paa.PRIMARY_WORK_TERMS_FLAG,

paa.PRIMARY_ASSIGNMENT_FLAG,

paa.PRIMARY_WORK_RELATION_FLAG,

paa.PRIMARY_FLAG,

paa.PROBATION_PERIOD,

paa.PROBATION_UNIT,

paa.PROJECT_TITLE,

paa.PROJECTED_ASSIGNMENT_END,

paa.PROJECTED_START_DATE,

paa.REASON_CODE,

paa.RECRUITER_ID,

paa.RECRUITMENT_ACTIVITY_ID,

paa.SAL_REVIEW_PERIOD,

paa.SAL_REVIEW_PERIOD_FREQUENCY,

paa.SET_OF_BOOKS_ID,

paa.SOFT_CODING_KEYFLEX_ID,

paa.SOURCE_ORGANIZATION_ID,

paa.SOURCE_TYPE,

paa.SPECIAL_CEILING_STEP_ID,

paa.STEP_ENTRY_DATE,

paa.SYSTEM_PERSON_TYPE,

paa.TIME_NORMAL_FINISH,

paa.TIME_NORMAL_START,

paa.BILLING_TITLE,

paa.VACANCY_ID,

paa.VENDOR_ASSIGNMENT_NUMBER,

paa.VENDOR_EMPLOYEE_NUMBER,

paa.VENDOR_ID,

paa.VENDOR_SITE_ID,

paa.WORK_AT_HOME,

paa.ACTION_OCCURRENCE_ID,

paa.PROPOSED_WORKER_TYPE,

paa.RETIREMENT_AGE,

paa.RETIREMENT_DATE,

paa.EFFECTIVE_LATEST_CHANGE,

paa.POSITION_OVERRIDE_FLAG,

paa.ALLOW_ASG_OVERRIDE_FLAG,

paa.FREEZE_START_DATE,

paa.FREEZE_UNTIL_DATE,

paa.ID_FLEX_NUM,

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,

paa.UNION_ID,

paa.SENIORITY_BASIS,

paa.OVERTIME_PERIOD,

paa.SOURCE_ASSIGNMENT_ID

FROM

PER_ALL_ASSIGNMENTS_M paa

WHERE

EFFECTIVE_LATEST_CHANGE = 'Y'