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' |