View: HR_EDW_WRK_SPRTN_FCV

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

View Text

SELECT SEPARATION_PK
, ASSIGNMENT_FK
, AGE_BAND_FK
, SERVICE_BAND_FK
, GEOGRAPHY_FK
, GRADE_FK
, INSTANCE_FK
, JOB_FK
, ORGANIZATION_FK
, PERSON_FK
, PERSON_TYPE_FK
, POSITION_FK
, TIME_TRM_NTFD_FK
, TIME_EMP_STRT_FK
, TIME_TRM_ACCPTD_FK
, TIME_TRM_PRJCTD_FK
, TIME_TRM_PRCSS_FK
, TIME_TRM_OCCRD_FK
, REASON_FK
, MOVEMENT_TYPE_FK
, ASG_ASSIGNMENT_ID
, ASG_BUSINESS_GROUP_ID
, ASG_GRADE_ID
, ASG_JOB_ID
, ASG_LOCATION_ID
, ASG_ORGANIZATION_ID
, ASG_PERSON_ID
, ASG_POSITION_ID
, PPS_PRD_OF_SRVC_ID
, PPS_TRM_ACPTD_PRSN_ID
, DATE_OF_BIRTH
, LAST_UPDATE_DATE
, CREATION_DATE
, EMP_START_FTE
, EMP_START_HDCNT
, SPRTN_NTFD_FTE
, SPRTN_NTFD_HDCNT
, SPRTN_ACCPTD_FTE
, SPRTN_ACCPTD_HDCNT
, SPRTN_PRJCTD_FTE
, SPRTN_PRJCTD_HDCNT
, EMP_SPRTN_FTE
, EMP_SPRTN_HDCNT
, FINAL_PRCSS_FTE
, FINAL_PRCSS_HDCNT
, SEPARATION_FTE
, SEPARATION_HEADCOUNT
, DYS_FRM_STRT_TO_LST_UPDT
, DYS_FRM_STRT_TO_LST_UPDT_ASG
, LATEST_ASG_DURATION
, SPRTN_NTFD_VL
, SPRTN_ACCPTD_VL
, SPRTN_PLND_VL
, SPRTN_CNCLD_VL
, SPRTN_OCCRRD_VL
, SPRTN_FNL_PRCSSNG_VL
, DYS_FRM_STRT_TO_NTFD_ASG
, DYS_FRM_STRT_TO_ACCPTD_ASG
, DYS_FRM_STRT_TO_PLND_ASG
, DYS_FRM_STRT_TO_TRM_ASG
, DYS_FRM_STRT_TO_PRCSS_ASG
, DYS_FRM_STRT_TO_NTFD
, DYS_FRM_STRT_TO_ACCPTD
, DYS_FRM_STRT_TO_PLND
, DYS_FRM_STRT_TO_TRM
, DYS_FRM_STRT_TO_PRCSS
, DYS_FRM_NTFD_TO_ACPTD
, DYS_FRM_NTFD_TO_PLND
, DYS_FRM_NTFD_TO_OCRD
, DYS_FRM_ACPTD_TO_PLND
, DYS_FRM_ACPTD_TO_OCRD
, NTFD_TRMNTN_DT
, ACCPTD_TRMNTN_DT
, PRJCTD_TRMNTN_DT
, ACTUAL_TRMNTN_DT
, FINAL_PROCESS_DT
, LEAVING_REASON
, 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_SPRTN_FCV

Columns