PER_ALL_ASSIGNMENTS_M_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

ASSIGNMENT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE BUSINESS_GROUP_ID PERSON_ID PERIOD_OF_SERVICE_ID ASSIGNMENT_TYPE ASSIGNMENT_NUMBER ASSIGNMENT_SEQUENCE ASSIGNMENT_STATUS_TYPE_ID PRIMARY_FLAG ORGANIZATION_ID JOB_ID LOCATION_ID POSITION_ID GRADE_ID GRADE_LADDER_PGM_ID PEOPLE_GROUP_ID COLLECTIVE_AGREEMENT_ID BARGAINING_UNIT_CODE LABOUR_UNION_MEMBER_FLAG CAGR_GRADE_DEF_ID CAGR_ID_FLEX_NUM CONTRACT_ID MANAGER_FLAG DATE_PROBATION_END PROBATION_PERIOD PROBATION_UNIT NORMAL_HOURS FREQUENCY WORK_AT_HOME TIME_NORMAL_FINISH TIME_NORMAL_START NOTICE_PERIOD NOTICE_PERIOD_UOM DEFAULT_CODE_COMB_ID EMPLOYEE_CATEGORY EMPLOYMENT_CATEGORY ESTABLISHMENT_ID HOURLY_SALARIED_CODE SAL_REVIEW_PERIOD SAL_REVIEW_PERIOD_FREQUENCY JOB_POST_SOURCE_NAME PROJECT_TITLE PERSON_REFERRED_BY_ID PO_HEADER_ID PO_LINE_ID RECRUITER_ID RECRUITMENT_ACTIVITY_ID VACANCY_ID APPLICANT_RANK POSTING_CONTENT_ID SOURCE_ORGANIZATION_ID SOURCE_TYPE PROJECTED_ASSIGNMENT_END SET_OF_BOOKS_ID SOFT_CODING_KEYFLEX_ID SPECIAL_CEILING_STEP_ID VENDOR_ASSIGNMENT_NUMBER VENDOR_EMPLOYEE_NUMBER VENDOR_ID VENDOR_SITE_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 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY WORK_TERMS_ASSIGNMENT_ID ACTION_CODE ASSIGNMENT_NAME ASSIGNMENT_STATUS_TYPE AUTO_END_FLAG DUTIES_TYPE EFFECTIVE_SEQUENCE EXPENSE_CHECK_ADDRESS INTERNAL_BUILDING INTERNAL_FLOOR INTERNAL_LOCATION INTERNAL_MAILSTOP INTERNAL_OFFICE_NUMBER LEGAL_ENTITY_ID LEGISLATION_CODE LINKAGE_TYPE PARENT_ASSIGNMENT_ID PERSON_TYPE_ID PRIMARY_WORK_TERMS_FLAG PRIMARY_ASSIGNMENT_FLAG PRIMARY_WORK_RELATION_FLAG PROJECTED_START_DATE REASON_CODE SYSTEM_PERSON_TYPE BUSINESS_UNIT_ID BILLING_TITLE STEP_ENTRY_DATE TAX_ADDRESS_ID 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 RECORD_CREATOR ACTION_OCCURRENCE_ID PROPOSED_WORKER_TYPE RETIREMENT_AGE RETIREMENT_DATE POSITION_OVERRIDE_FLAG EFFECTIVE_LATEST_CHANGE ALLOW_ASG_OVERRIDE_FLAG 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 FREEZE_START_DATE FREEZE_UNTIL_DATE ID_FLEX_NUM UNION_ID SENIORITY_BASIS OVERTIME_PERIOD SOURCE_ASSIGNMENT_ID

Query

SQL_Statement

SELECT PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_ID ASSIGNMENT_ID, PER_ALL_ASSIGNMENTS_M.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, PER_ALL_ASSIGNMENTS_M.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PER_ALL_ASSIGNMENTS_M.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PER_ALL_ASSIGNMENTS_M.PERSON_ID PERSON_ID, PER_ALL_ASSIGNMENTS_M.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_TYPE ASSIGNMENT_TYPE, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_SEQUENCE ASSIGNMENT_SEQUENCE, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, PER_ALL_ASSIGNMENTS_M.PRIMARY_FLAG PRIMARY_FLAG, PER_ALL_ASSIGNMENTS_M.ORGANIZATION_ID ORGANIZATION_ID, PER_ALL_ASSIGNMENTS_M.JOB_ID JOB_ID, PER_ALL_ASSIGNMENTS_M.LOCATION_ID LOCATION_ID, PER_ALL_ASSIGNMENTS_M.POSITION_ID POSITION_ID, PER_ALL_ASSIGNMENTS_M.GRADE_ID GRADE_ID, PER_ALL_ASSIGNMENTS_M.GRADE_LADDER_PGM_ID GRADE_LADDER_PGM_ID, PER_ALL_ASSIGNMENTS_M.PEOPLE_GROUP_ID PEOPLE_GROUP_ID, PER_ALL_ASSIGNMENTS_M.COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID, PER_ALL_ASSIGNMENTS_M.BARGAINING_UNIT_CODE BARGAINING_UNIT_CODE, PER_ALL_ASSIGNMENTS_M.LABOUR_UNION_MEMBER_FLAG LABOUR_UNION_MEMBER_FLAG, PER_ALL_ASSIGNMENTS_M.CAGR_GRADE_DEF_ID CAGR_GRADE_DEF_ID, PER_ALL_ASSIGNMENTS_M.CAGR_ID_FLEX_NUM CAGR_ID_FLEX_NUM, PER_ALL_ASSIGNMENTS_M.CONTRACT_ID CONTRACT_ID, PER_ALL_ASSIGNMENTS_M.MANAGER_FLAG MANAGER_FLAG, PER_ALL_ASSIGNMENTS_M.DATE_PROBATION_END DATE_PROBATION_END, PER_ALL_ASSIGNMENTS_M.PROBATION_PERIOD PROBATION_PERIOD, PER_ALL_ASSIGNMENTS_M.PROBATION_UNIT PROBATION_UNIT, PER_ALL_ASSIGNMENTS_M.NORMAL_HOURS NORMAL_HOURS, PER_ALL_ASSIGNMENTS_M.FREQUENCY FREQUENCY, PER_ALL_ASSIGNMENTS_M.WORK_AT_HOME WORK_AT_HOME, PER_ALL_ASSIGNMENTS_M.TIME_NORMAL_FINISH TIME_NORMAL_FINISH, PER_ALL_ASSIGNMENTS_M.TIME_NORMAL_START TIME_NORMAL_START, PER_ALL_ASSIGNMENTS_M.NOTICE_PERIOD NOTICE_PERIOD, PER_ALL_ASSIGNMENTS_M.NOTICE_PERIOD_UOM NOTICE_PERIOD_UOM, PER_ALL_ASSIGNMENTS_M.DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID, PER_ALL_ASSIGNMENTS_M.EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY, PER_ALL_ASSIGNMENTS_M.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, PER_ALL_ASSIGNMENTS_M.ESTABLISHMENT_ID ESTABLISHMENT_ID, PER_ALL_ASSIGNMENTS_M.HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE, PER_ALL_ASSIGNMENTS_M.SAL_REVIEW_PERIOD SAL_REVIEW_PERIOD, PER_ALL_ASSIGNMENTS_M.SAL_REVIEW_PERIOD_FREQUENCY SAL_REVIEW_PERIOD_FREQUENCY, PER_ALL_ASSIGNMENTS_M.JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME, PER_ALL_ASSIGNMENTS_M.PROJECT_TITLE PROJECT_TITLE, PER_ALL_ASSIGNMENTS_M.PERSON_REFERRED_BY_ID PERSON_REFERRED_BY_ID, PER_ALL_ASSIGNMENTS_M.PO_HEADER_ID PO_HEADER_ID, PER_ALL_ASSIGNMENTS_M.PO_LINE_ID PO_LINE_ID, PER_ALL_ASSIGNMENTS_M.RECRUITER_ID RECRUITER_ID, PER_ALL_ASSIGNMENTS_M.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID, PER_ALL_ASSIGNMENTS_M.VACANCY_ID VACANCY_ID, PER_ALL_ASSIGNMENTS_M.APPLICANT_RANK APPLICANT_RANK, PER_ALL_ASSIGNMENTS_M.POSTING_CONTENT_ID POSTING_CONTENT_ID, PER_ALL_ASSIGNMENTS_M.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, PER_ALL_ASSIGNMENTS_M.SOURCE_TYPE SOURCE_TYPE, PER_ALL_ASSIGNMENTS_M.PROJECTED_ASSIGNMENT_END PROJECTED_ASSIGNMENT_END, PER_ALL_ASSIGNMENTS_M.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PER_ALL_ASSIGNMENTS_M.SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID, PER_ALL_ASSIGNMENTS_M.SPECIAL_CEILING_STEP_ID SPECIAL_CEILING_STEP_ID, PER_ALL_ASSIGNMENTS_M.VENDOR_ASSIGNMENT_NUMBER VENDOR_ASSIGNMENT_NUMBER, PER_ALL_ASSIGNMENTS_M.VENDOR_EMPLOYEE_NUMBER VENDOR_EMPLOYEE_NUMBER, PER_ALL_ASSIGNMENTS_M.VENDOR_ID VENDOR_ID, PER_ALL_ASSIGNMENTS_M.VENDOR_SITE_ID VENDOR_SITE_ID, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE1 ASS_ATTRIBUTE1, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE2 ASS_ATTRIBUTE2, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE3 ASS_ATTRIBUTE3, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE4 ASS_ATTRIBUTE4, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE5 ASS_ATTRIBUTE5, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE6 ASS_ATTRIBUTE6, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE7 ASS_ATTRIBUTE7, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE8 ASS_ATTRIBUTE8, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE9 ASS_ATTRIBUTE9, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE10 ASS_ATTRIBUTE10, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE11 ASS_ATTRIBUTE11, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE12 ASS_ATTRIBUTE12, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE13 ASS_ATTRIBUTE13, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE14 ASS_ATTRIBUTE14, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE15 ASS_ATTRIBUTE15, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE16 ASS_ATTRIBUTE16, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE17 ASS_ATTRIBUTE17, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE18 ASS_ATTRIBUTE18, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE19 ASS_ATTRIBUTE19, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE20 ASS_ATTRIBUTE20, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE21 ASS_ATTRIBUTE21, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE22 ASS_ATTRIBUTE22, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE23 ASS_ATTRIBUTE23, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE24 ASS_ATTRIBUTE24, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE25 ASS_ATTRIBUTE25, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE26 ASS_ATTRIBUTE26, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE27 ASS_ATTRIBUTE27, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE28 ASS_ATTRIBUTE28, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE29 ASS_ATTRIBUTE29, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE30 ASS_ATTRIBUTE30, PER_ALL_ASSIGNMENTS_M.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PER_ALL_ASSIGNMENTS_M.CREATED_BY CREATED_BY, PER_ALL_ASSIGNMENTS_M.CREATION_DATE CREATION_DATE, PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_DATE LAST_UPDATE_DATE, PER_ALL_ASSIGNMENTS_M.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PER_ALL_ASSIGNMENTS_M.LAST_UPDATED_BY LAST_UPDATED_BY, PER_ALL_ASSIGNMENTS_M.WORK_TERMS_ASSIGNMENT_ID WORK_TERMS_ASSIGNMENT_ID, PER_ALL_ASSIGNMENTS_M.ACTION_CODE ACTION_CODE, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_NAME ASSIGNMENT_NAME, PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_STATUS_TYPE ASSIGNMENT_STATUS_TYPE, PER_ALL_ASSIGNMENTS_M.AUTO_END_FLAG AUTO_END_FLAG, PER_ALL_ASSIGNMENTS_M.DUTIES_TYPE DUTIES_TYPE, PER_ALL_ASSIGNMENTS_M.EFFECTIVE_SEQUENCE EFFECTIVE_SEQUENCE, PER_ALL_ASSIGNMENTS_M.EXPENSE_CHECK_ADDRESS EXPENSE_CHECK_ADDRESS, PER_ALL_ASSIGNMENTS_M.INTERNAL_BUILDING INTERNAL_BUILDING, PER_ALL_ASSIGNMENTS_M.INTERNAL_FLOOR INTERNAL_FLOOR, PER_ALL_ASSIGNMENTS_M.INTERNAL_LOCATION INTERNAL_LOCATION, PER_ALL_ASSIGNMENTS_M.INTERNAL_MAILSTOP INTERNAL_MAILSTOP, PER_ALL_ASSIGNMENTS_M.INTERNAL_OFFICE_NUMBER INTERNAL_OFFICE_NUMBER, PER_ALL_ASSIGNMENTS_M.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PER_ALL_ASSIGNMENTS_M.LEGISLATION_CODE LEGISLATION_CODE, PER_ALL_ASSIGNMENTS_M.LINKAGE_TYPE LINKAGE_TYPE, PER_ALL_ASSIGNMENTS_M.PARENT_ASSIGNMENT_ID PARENT_ASSIGNMENT_ID, PER_ALL_ASSIGNMENTS_M.PERSON_TYPE_ID PERSON_TYPE_ID, PER_ALL_ASSIGNMENTS_M.PRIMARY_WORK_TERMS_FLAG PRIMARY_WORK_TERMS_FLAG, PER_ALL_ASSIGNMENTS_M.PRIMARY_ASSIGNMENT_FLAG PRIMARY_ASSIGNMENT_FLAG, PER_ALL_ASSIGNMENTS_M.PRIMARY_WORK_RELATION_FLAG PRIMARY_WORK_RELATION_FLAG, PER_ALL_ASSIGNMENTS_M.PROJECTED_START_DATE PROJECTED_START_DATE, PER_ALL_ASSIGNMENTS_M.REASON_CODE REASON_CODE, PER_ALL_ASSIGNMENTS_M.SYSTEM_PERSON_TYPE SYSTEM_PERSON_TYPE, PER_ALL_ASSIGNMENTS_M.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, PER_ALL_ASSIGNMENTS_M.BILLING_TITLE BILLING_TITLE, PER_ALL_ASSIGNMENTS_M.STEP_ENTRY_DATE STEP_ENTRY_DATE, PER_ALL_ASSIGNMENTS_M.TAX_ADDRESS_ID TAX_ADDRESS_ID, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE31 ASS_ATTRIBUTE31, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE32 ASS_ATTRIBUTE32, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE33 ASS_ATTRIBUTE33, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE34 ASS_ATTRIBUTE34, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE35 ASS_ATTRIBUTE35, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE36 ASS_ATTRIBUTE36, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE37 ASS_ATTRIBUTE37, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE38 ASS_ATTRIBUTE38, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE39 ASS_ATTRIBUTE39, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE40 ASS_ATTRIBUTE40, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE41 ASS_ATTRIBUTE41, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE42 ASS_ATTRIBUTE42, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE43 ASS_ATTRIBUTE43, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE44 ASS_ATTRIBUTE44, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE45 ASS_ATTRIBUTE45, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE46 ASS_ATTRIBUTE46, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE47 ASS_ATTRIBUTE47, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE48 ASS_ATTRIBUTE48, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE49 ASS_ATTRIBUTE49, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE50 ASS_ATTRIBUTE50, PER_ALL_ASSIGNMENTS_M.RECORD_CREATOR RECORD_CREATOR, PER_ALL_ASSIGNMENTS_M.ACTION_OCCURRENCE_ID ACTION_OCCURRENCE_ID, PER_ALL_ASSIGNMENTS_M.PROPOSED_WORKER_TYPE PROPOSED_WORKER_TYPE, PER_ALL_ASSIGNMENTS_M.RETIREMENT_AGE RETIREMENT_AGE, PER_ALL_ASSIGNMENTS_M.RETIREMENT_DATE RETIREMENT_DATE, PER_ALL_ASSIGNMENTS_M.POSITION_OVERRIDE_FLAG POSITION_OVERRIDE_FLAG, PER_ALL_ASSIGNMENTS_M.EFFECTIVE_LATEST_CHANGE EFFECTIVE_LATEST_CHANGE, PER_ALL_ASSIGNMENTS_M.ALLOW_ASG_OVERRIDE_FLAG ALLOW_ASG_OVERRIDE_FLAG, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER1 ASS_ATTRIBUTE_NUMBER1, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER2 ASS_ATTRIBUTE_NUMBER2, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER3 ASS_ATTRIBUTE_NUMBER3, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER4 ASS_ATTRIBUTE_NUMBER4, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER5 ASS_ATTRIBUTE_NUMBER5, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER6 ASS_ATTRIBUTE_NUMBER6, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER7 ASS_ATTRIBUTE_NUMBER7, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER8 ASS_ATTRIBUTE_NUMBER8, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER9 ASS_ATTRIBUTE_NUMBER9, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER10 ASS_ATTRIBUTE_NUMBER10, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER11 ASS_ATTRIBUTE_NUMBER11, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER12 ASS_ATTRIBUTE_NUMBER12, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER13 ASS_ATTRIBUTE_NUMBER13, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER14 ASS_ATTRIBUTE_NUMBER14, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER15 ASS_ATTRIBUTE_NUMBER15, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER16 ASS_ATTRIBUTE_NUMBER16, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER17 ASS_ATTRIBUTE_NUMBER17, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER18 ASS_ATTRIBUTE_NUMBER18, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER19 ASS_ATTRIBUTE_NUMBER19, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER20 ASS_ATTRIBUTE_NUMBER20, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE1 ASS_ATTRIBUTE_DATE1, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE2 ASS_ATTRIBUTE_DATE2, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE3 ASS_ATTRIBUTE_DATE3, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE4 ASS_ATTRIBUTE_DATE4, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE5 ASS_ATTRIBUTE_DATE5, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE6 ASS_ATTRIBUTE_DATE6, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE7 ASS_ATTRIBUTE_DATE7, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE8 ASS_ATTRIBUTE_DATE8, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE9 ASS_ATTRIBUTE_DATE9, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE10 ASS_ATTRIBUTE_DATE10, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE11 ASS_ATTRIBUTE_DATE11, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE12 ASS_ATTRIBUTE_DATE12, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE13 ASS_ATTRIBUTE_DATE13, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE14 ASS_ATTRIBUTE_DATE14, PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_DATE15 ASS_ATTRIBUTE_DATE15, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_CATEGORY ASG_INFORMATION_CATEGORY, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION1 ASG_INFORMATION1, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION2 ASG_INFORMATION2, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION3 ASG_INFORMATION3, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION4 ASG_INFORMATION4, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION5 ASG_INFORMATION5, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION6 ASG_INFORMATION6, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION7 ASG_INFORMATION7, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION8 ASG_INFORMATION8, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION9 ASG_INFORMATION9, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION10 ASG_INFORMATION10, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION11 ASG_INFORMATION11, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION12 ASG_INFORMATION12, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION13 ASG_INFORMATION13, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION14 ASG_INFORMATION14, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION15 ASG_INFORMATION15, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION16 ASG_INFORMATION16, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION17 ASG_INFORMATION17, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION18 ASG_INFORMATION18, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION19 ASG_INFORMATION19, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION20 ASG_INFORMATION20, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION21 ASG_INFORMATION21, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION22 ASG_INFORMATION22, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION23 ASG_INFORMATION23, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION24 ASG_INFORMATION24, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION25 ASG_INFORMATION25, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION26 ASG_INFORMATION26, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION27 ASG_INFORMATION27, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION28 ASG_INFORMATION28, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION29 ASG_INFORMATION29, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION30 ASG_INFORMATION30, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION31 ASG_INFORMATION31, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION32 ASG_INFORMATION32, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION33 ASG_INFORMATION33, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION34 ASG_INFORMATION34, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION35 ASG_INFORMATION35, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION36 ASG_INFORMATION36, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION37 ASG_INFORMATION37, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION38 ASG_INFORMATION38, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION39 ASG_INFORMATION39, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION40 ASG_INFORMATION40, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION41 ASG_INFORMATION41, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION42 ASG_INFORMATION42, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION43 ASG_INFORMATION43, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION44 ASG_INFORMATION44, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION45 ASG_INFORMATION45, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION46 ASG_INFORMATION46, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION47 ASG_INFORMATION47, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION48 ASG_INFORMATION48, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION49 ASG_INFORMATION49, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION50 ASG_INFORMATION50, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER1 ASG_INFORMATION_NUMBER1, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER2 ASG_INFORMATION_NUMBER2, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER3 ASG_INFORMATION_NUMBER3, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER4 ASG_INFORMATION_NUMBER4, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER5 ASG_INFORMATION_NUMBER5, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER6 ASG_INFORMATION_NUMBER6, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER7 ASG_INFORMATION_NUMBER7, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER8 ASG_INFORMATION_NUMBER8, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER9 ASG_INFORMATION_NUMBER9, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER10 ASG_INFORMATION_NUMBER10, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER11 ASG_INFORMATION_NUMBER11, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER12 ASG_INFORMATION_NUMBER12, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER13 ASG_INFORMATION_NUMBER13, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER14 ASG_INFORMATION_NUMBER14, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER15 ASG_INFORMATION_NUMBER15, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER16 ASG_INFORMATION_NUMBER16, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER17 ASG_INFORMATION_NUMBER17, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER18 ASG_INFORMATION_NUMBER18, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER19 ASG_INFORMATION_NUMBER19, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_NUMBER20 ASG_INFORMATION_NUMBER20, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE1 ASG_INFORMATION_DATE1, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE2 ASG_INFORMATION_DATE2, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE3 ASG_INFORMATION_DATE3, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE4 ASG_INFORMATION_DATE4, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE5 ASG_INFORMATION_DATE5, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE6 ASG_INFORMATION_DATE6, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE7 ASG_INFORMATION_DATE7, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE8 ASG_INFORMATION_DATE8, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE9 ASG_INFORMATION_DATE9, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE10 ASG_INFORMATION_DATE10, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE11 ASG_INFORMATION_DATE11, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE12 ASG_INFORMATION_DATE12, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE13 ASG_INFORMATION_DATE13, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE14 ASG_INFORMATION_DATE14, PER_ALL_ASSIGNMENTS_M.ASG_INFORMATION_DATE15 ASG_INFORMATION_DATE15, PER_ALL_ASSIGNMENTS_M.FREEZE_START_DATE, PER_ALL_ASSIGNMENTS_M.FREEZE_UNTIL_DATE, PER_ALL_ASSIGNMENTS_M.ID_FLEX_NUM, PER_ALL_ASSIGNMENTS_M.UNION_ID, PER_ALL_ASSIGNMENTS_M.SENIORITY_BASIS, PER_ALL_ASSIGNMENTS_M.OVERTIME_PERIOD, PER_ALL_ASSIGNMENTS_M.SOURCE_ASSIGNMENT_ID FROM PER_ALL_ASSIGNMENTS_M