PER_ASSIGNMENT_SECURED_LIST_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 CATEGORY_CODE FULL_PART_TIME PERMANENT_TEMPORARY_FLAG GSP_ELIGIBILITY_FLAG UNION_ID SENIORITY_BASIS OVERTIME_PERIOD STANDARD_HOURS STANDARD_FREQUENCY STD_ANNUAL_WORKING_DURATION ANNUAL_WORKING_DURATION_UNITS ANNUAL_WORKING_DURATION ANNUAL_WORKING_RATIO ADJUSTED_FTE

Query

SQL_Statement

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