VIEW: HR.PER_ALL_ASSIGNMENTS_F#

Source

View Text - Preformatted

select ASSIGNMENT_ID ASSIGNMENT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RECRUITER_ID RECRUITER_ID, GRADE_ID GRADE_ID, POSITION_ID POSITION_ID, JOB_ID JOB_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, PAYROLL_ID PAYROLL_ID, LOCATION_ID LOCATION_ID, PERSON_REFERRED_BY_ID PERSON_REFERRED_BY_ID, SUPERVISOR_ID SUPERVISOR_ID, SPECIAL_CEILING_STEP_ID SPECIAL_CEILING_STEP_ID, PERSON_ID PERSON_ID, RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, ORGANIZATION_ID ORGANIZATION_ID, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID, VACANCY_ID VACANCY_ID, PAY_BASIS_ID PAY_BASIS_ID, ASSIGNMENT_SEQUENCE ASSIGNMENT_SEQUENCE, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, PRIMARY_FLAG PRIMARY_FLAG, APPLICATION_ID APPLICATION_ID, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, CHANGE_REASON CHANGE_REASON, COMMENT_ID COMMENT_ID, DATE_PROBATION_END DATE_PROBATION_END, DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, FREQUENCY FREQUENCY, INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE, MANAGER_FLAG MANAGER_FLAG, NORMAL_HOURS NORMAL_HOURS, PERF_REVIEW_PERIOD PERF_REVIEW_PERIOD, PERF_REVIEW_PERIOD_FREQUENCY PERF_REVIEW_PERIOD_FREQUENCY, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID, PROBATION_PERIOD PROBATION_PERIOD, PROBATION_UNIT PROBATION_UNIT, SAL_REVIEW_PERIOD SAL_REVIEW_PERIOD, SAL_REVIEW_PERIOD_FREQUENCY SAL_REVIEW_PERIOD_FREQUENCY, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SOURCE_TYPE SOURCE_TYPE, TIME_NORMAL_FINISH TIME_NORMAL_FINISH, TIME_NORMAL_START TIME_NORMAL_START, BARGAINING_UNIT_CODE BARGAINING_UNIT_CODE, LABOUR_UNION_MEMBER_FLAG LABOUR_UNION_MEMBER_FLAG, HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE, CONTRACT_ID CONTRACT_ID, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID, CAGR_ID_FLEX_NUM CAGR_ID_FLEX_NUM, CAGR_GRADE_DEF_ID CAGR_GRADE_DEF_ID, ESTABLISHMENT_ID ESTABLISHMENT_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TITLE TITLE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NOTICE_PERIOD NOTICE_PERIOD, NOTICE_PERIOD_UOM NOTICE_PERIOD_UOM, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY, WORK_AT_HOME WORK_AT_HOME, JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME, POSTING_CONTENT_ID POSTING_CONTENT_ID, PERIOD_OF_PLACEMENT_DATE_START PERIOD_OF_PLACEMENT_DATE_START, VENDOR_ID VENDOR_ID, VENDOR_EMPLOYEE_NUMBER VENDOR_EMPLOYEE_NUMBER, VENDOR_ASSIGNMENT_NUMBER VENDOR_ASSIGNMENT_NUMBER, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY, PROJECT_TITLE PROJECT_TITLE, APPLICANT_RANK APPLICANT_RANK, VENDOR_SITE_ID VENDOR_SITE_ID, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PROJECTED_ASSIGNMENT_END PROJECTED_ASSIGNMENT_END, GRADE_LADDER_PGM_ID GRADE_LADDER_PGM_ID, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID from "HR"."PER_ALL_ASSIGNMENTS_F"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RECRUITER_ID RECRUITER_ID
, GRADE_ID GRADE_ID
, POSITION_ID POSITION_ID
, JOB_ID JOB_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, PAYROLL_ID PAYROLL_ID
, LOCATION_ID LOCATION_ID
, PERSON_REFERRED_BY_ID PERSON_REFERRED_BY_ID
, SUPERVISOR_ID SUPERVISOR_ID
, SPECIAL_CEILING_STEP_ID SPECIAL_CEILING_STEP_ID
, PERSON_ID PERSON_ID
, RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
, VACANCY_ID VACANCY_ID
, PAY_BASIS_ID PAY_BASIS_ID
, ASSIGNMENT_SEQUENCE ASSIGNMENT_SEQUENCE
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, PRIMARY_FLAG PRIMARY_FLAG
, APPLICATION_ID APPLICATION_ID
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, CHANGE_REASON CHANGE_REASON
, COMMENT_ID COMMENT_ID
, DATE_PROBATION_END DATE_PROBATION_END
, DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, FREQUENCY FREQUENCY
, INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE
, MANAGER_FLAG MANAGER_FLAG
, NORMAL_HOURS NORMAL_HOURS
, PERF_REVIEW_PERIOD PERF_REVIEW_PERIOD
, PERF_REVIEW_PERIOD_FREQUENCY PERF_REVIEW_PERIOD_FREQUENCY
, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, PROBATION_PERIOD PROBATION_PERIOD
, PROBATION_UNIT PROBATION_UNIT
, SAL_REVIEW_PERIOD SAL_REVIEW_PERIOD
, SAL_REVIEW_PERIOD_FREQUENCY SAL_REVIEW_PERIOD_FREQUENCY
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_TYPE SOURCE_TYPE
, TIME_NORMAL_FINISH TIME_NORMAL_FINISH
, TIME_NORMAL_START TIME_NORMAL_START
, BARGAINING_UNIT_CODE BARGAINING_UNIT_CODE
, LABOUR_UNION_MEMBER_FLAG LABOUR_UNION_MEMBER_FLAG
, HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE
, CONTRACT_ID CONTRACT_ID
, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID
, CAGR_ID_FLEX_NUM CAGR_ID_FLEX_NUM
, CAGR_GRADE_DEF_ID CAGR_GRADE_DEF_ID
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TITLE TITLE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NOTICE_PERIOD NOTICE_PERIOD
, NOTICE_PERIOD_UOM NOTICE_PERIOD_UOM
, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY
, WORK_AT_HOME WORK_AT_HOME
, JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME
, POSTING_CONTENT_ID POSTING_CONTENT_ID
, PERIOD_OF_PLACEMENT_DATE_START PERIOD_OF_PLACEMENT_DATE_START
, VENDOR_ID VENDOR_ID
, VENDOR_EMPLOYEE_NUMBER VENDOR_EMPLOYEE_NUMBER
, VENDOR_ASSIGNMENT_NUMBER VENDOR_ASSIGNMENT_NUMBER
, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY
, PROJECT_TITLE PROJECT_TITLE
, APPLICANT_RANK APPLICANT_RANK
, VENDOR_SITE_ID VENDOR_SITE_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PROJECTED_ASSIGNMENT_END PROJECTED_ASSIGNMENT_END
, GRADE_LADDER_PGM_ID GRADE_LADDER_PGM_ID
, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
FROM "HR"."PER_ALL_ASSIGNMENTS_F"