VIEW: APPS.HR_EDW_WRK_ACTVTY_FCV

Source

View Text - Preformatted

SELECT assignment_change_pk ,age_band_fk ,application_fk ,assignment_fk ,assignment_change_fk ,geography_from_fk ,geography_to_fk ,grade_from_fk ,grade_to_fk ,instance_fk ,job_from_fk ,job_to_fk ,organization_from_fk ,organization_to_fk ,person_fk ,person_type_fk ,position_from_fk ,position_to_fk ,movement_fk ,reason_fk ,service_band_fk ,time_from_fk ,time_to_fk ,job_change_flag ,grd_change_flag ,pos_change_flag ,org_change_flag ,geog_change_flag ,emplymnt_start_flag ,assgnmnt_ended_flag ,other_change_flag ,asg_change_headcount ,asg_change_fte ,days_since_last_org_x ,days_since_last_job_x ,days_since_last_pos_x ,days_since_last_grd_x ,days_since_last_geog_x ,days_emp_start_to_term ,last_update_date ,creation_date ,assignment_id ,effective_start_date ,effective_end_date ,business_group_id ,recruiter_id ,grade_id ,position_id ,job_id ,assignment_status_type_id ,payroll_id ,location_id ,person_referred_by_id ,supervisor_id ,special_ceiling_step_id ,person_id ,recruitment_activity_id ,source_organization_id ,organization_id ,people_group_id ,soft_coding_keyflex_id ,vacancy_id ,pay_basis_id ,assignment_sequence ,assignment_type ,primary_flag ,application_id ,assignment_number ,change_reason ,comment_id ,date_probation_end ,default_code_comb_id ,employment_category ,frequency ,internal_address_line ,manager_flag ,normal_hours ,perf_review_period ,perf_review_period_frequency ,period_of_service_id ,probation_period ,probation_unit ,sal_review_period ,sal_review_period_frequency ,set_of_books_id ,source_type ,time_normal_finish ,time_normal_start ,asg_request_id ,program_application_id ,program_id ,program_update_date ,asg_title ,object_version_number ,bargaining_unit_code ,labour_union_member_flag ,hourly_salaried_code ,contract_id ,collective_agreement_id ,cagr_id_flex_num ,cagr_grade_def_id ,establishment_id ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null FROM hr_edwbv_wrk_actvty_fcv WITH READ ONLY

View Text - HTML Formatted

SELECT ASSIGNMENT_CHANGE_PK
, AGE_BAND_FK
, APPLICATION_FK
, ASSIGNMENT_FK
, ASSIGNMENT_CHANGE_FK
, GEOGRAPHY_FROM_FK
, GEOGRAPHY_TO_FK
, GRADE_FROM_FK
, GRADE_TO_FK
, INSTANCE_FK
, JOB_FROM_FK
, JOB_TO_FK
, ORGANIZATION_FROM_FK
, ORGANIZATION_TO_FK
, PERSON_FK
, PERSON_TYPE_FK
, POSITION_FROM_FK
, POSITION_TO_FK
, MOVEMENT_FK
, REASON_FK
, SERVICE_BAND_FK
, TIME_FROM_FK
, TIME_TO_FK
, JOB_CHANGE_FLAG
, GRD_CHANGE_FLAG
, POS_CHANGE_FLAG
, ORG_CHANGE_FLAG
, GEOG_CHANGE_FLAG
, EMPLYMNT_START_FLAG
, ASSGNMNT_ENDED_FLAG
, OTHER_CHANGE_FLAG
, ASG_CHANGE_HEADCOUNT
, ASG_CHANGE_FTE
, DAYS_SINCE_LAST_ORG_X
, DAYS_SINCE_LAST_JOB_X
, DAYS_SINCE_LAST_POS_X
, DAYS_SINCE_LAST_GRD_X
, DAYS_SINCE_LAST_GEOG_X
, DAYS_EMP_START_TO_TERM
, LAST_UPDATE_DATE
, CREATION_DATE
, ASSIGNMENT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, RECRUITER_ID
, GRADE_ID
, POSITION_ID
, JOB_ID
, ASSIGNMENT_STATUS_TYPE_ID
, PAYROLL_ID
, LOCATION_ID
, PERSON_REFERRED_BY_ID
, SUPERVISOR_ID
, SPECIAL_CEILING_STEP_ID
, PERSON_ID
, RECRUITMENT_ACTIVITY_ID
, SOURCE_ORGANIZATION_ID
, ORGANIZATION_ID
, PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID
, VACANCY_ID
, PAY_BASIS_ID
, ASSIGNMENT_SEQUENCE
, ASSIGNMENT_TYPE
, PRIMARY_FLAG
, APPLICATION_ID
, ASSIGNMENT_NUMBER
, CHANGE_REASON
, COMMENT_ID
, DATE_PROBATION_END
, DEFAULT_CODE_COMB_ID
, EMPLOYMENT_CATEGORY
, FREQUENCY
, INTERNAL_ADDRESS_LINE
, MANAGER_FLAG
, NORMAL_HOURS
, PERF_REVIEW_PERIOD
, PERF_REVIEW_PERIOD_FREQUENCY
, PERIOD_OF_SERVICE_ID
, PROBATION_PERIOD
, PROBATION_UNIT
, SAL_REVIEW_PERIOD
, SAL_REVIEW_PERIOD_FREQUENCY
, SET_OF_BOOKS_ID
, SOURCE_TYPE
, TIME_NORMAL_FINISH
, TIME_NORMAL_START
, ASG_REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ASG_TITLE
, OBJECT_VERSION_NUMBER
, BARGAINING_UNIT_CODE
, LABOUR_UNION_MEMBER_FLAG
, HOURLY_SALARIED_CODE
, CONTRACT_ID
, COLLECTIVE_AGREEMENT_ID
, CAGR_ID_FLEX_NUM
, CAGR_GRADE_DEF_ID
, ESTABLISHMENT_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_EDWBV_WRK_ACTVTY_FCV WITH READ ONLY