View: HR_EDW_WRK_ACTVTY_FCV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HR_EDW_WRK_ACTVTY_FCV

View Text

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

Columns