[Home] [Help] [Dependency Information]
Object Name: | HR_EDWBV_WRK_SPRTN_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HR_EDWBV_WRK_SPRTN_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEPARATION_PK | VARCHAR2 | (153) | ||
ASSIGNMENT_FK | VARCHAR2 | (71) | ||
AGE_BAND_FK | VARCHAR2 | (4000) | ||
SERVICE_BAND_FK | VARCHAR2 | (4000) | ||
GEOGRAPHY_FK | VARCHAR2 | (78) | ||
GRADE_FK | VARCHAR2 | (71) | ||
INSTANCE_FK | VARCHAR2 | (30) | ||
JOB_FK | VARCHAR2 | (71) | ||
ORGANIZATION_FK | VARCHAR2 | (71) | ||
PERSON_FK | VARCHAR2 | (85) | ||
PERSON_TYPE_FK | VARCHAR2 | (4000) | ||
POSITION_FK | VARCHAR2 | (71) | ||
TIME_TRM_NTFD_FK | VARCHAR2 | (14) | ||
TIME_EMP_STRT_FK | VARCHAR2 | (14) | ||
TIME_TRM_ACCPTD_FK | VARCHAR2 | (14) | ||
TIME_TRM_PRJCTD_FK | VARCHAR2 | (14) | ||
TIME_TRM_PRCSS_FK | VARCHAR2 | (14) | ||
TIME_TRM_OCCRD_FK | VARCHAR2 | (14) | ||
REASON_FK | VARCHAR2 | (71) | ||
MOVEMENT_TYPE_FK | VARCHAR2 | (4000) | ||
ASG_ASSIGNMENT_ID | NUMBER | (10) | Yes | |
ASG_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ASG_GRADE_ID | NUMBER | (15) | ||
ASG_JOB_ID | NUMBER | (15) | ||
ASG_LOCATION_ID | NUMBER | (15) | ||
ASG_ORGANIZATION_ID | NUMBER | (15) | Yes | |
ASG_PERSON_ID | NUMBER | (10) | Yes | |
ASG_POSITION_ID | NUMBER | (15) | ||
PPS_PRD_OF_SRVC_ID | NUMBER | (9) | Yes | |
PPS_TRM_ACPTD_PRSN_ID | NUMBER | (10) | ||
DATE_OF_BIRTH | DATE | |||
LAST_UPDATE_DATE | DATE | |||
CREATION_DATE | DATE | |||
EMP_START_FTE | VARCHAR2 | (40) | ||
EMP_START_HDCNT | VARCHAR2 | (40) | ||
SPRTN_NTFD_FTE | VARCHAR2 | (40) | ||
SPRTN_NTFD_HDCNT | VARCHAR2 | (40) | ||
SPRTN_ACCPTD_FTE | VARCHAR2 | (40) | ||
SPRTN_ACCPTD_HDCNT | VARCHAR2 | (40) | ||
SPRTN_PRJCTD_FTE | VARCHAR2 | (40) | ||
SPRTN_PRJCTD_HDCNT | VARCHAR2 | (40) | ||
EMP_SPRTN_FTE | VARCHAR2 | (40) | ||
EMP_SPRTN_HDCNT | VARCHAR2 | (40) | ||
FINAL_PRCSS_FTE | VARCHAR2 | (40) | ||
FINAL_PRCSS_HDCNT | VARCHAR2 | (40) | ||
SEPARATION_FTE | VARCHAR2 | (40) | ||
SEPARATION_HEADCOUNT | VARCHAR2 | (40) | ||
DYS_FRM_STRT_TO_LST_UPDT | VARCHAR2 | (40) | ||
DYS_FRM_STRT_TO_LST_UPDT_ASG | VARCHAR2 | (40) | ||
LATEST_ASG_DURATION | NUMBER | |||
SPRTN_NTFD_VL | NUMBER | |||
SPRTN_ACCPTD_VL | NUMBER | |||
SPRTN_PLND_VL | NUMBER | |||
SPRTN_CNCLD_VL | VARCHAR2 | (0) | ||
SPRTN_OCCRRD_VL | NUMBER | |||
SPRTN_FNL_PRCSSNG_VL | NUMBER | |||
DYS_FRM_STRT_TO_NTFD_ASG | NUMBER | |||
DYS_FRM_STRT_TO_ACCPTD_ASG | NUMBER | |||
DYS_FRM_STRT_TO_PLND_ASG | NUMBER | |||
DYS_FRM_STRT_TO_TRM_ASG | NUMBER | |||
DYS_FRM_STRT_TO_PRCSS_ASG | NUMBER | |||
DYS_FRM_STRT_TO_NTFD | NUMBER | |||
DYS_FRM_STRT_TO_ACCPTD | NUMBER | |||
DYS_FRM_STRT_TO_PLND | NUMBER | |||
DYS_FRM_STRT_TO_TRM | NUMBER | |||
DYS_FRM_STRT_TO_PRCSS | NUMBER | |||
DYS_FRM_NTFD_TO_ACPTD | NUMBER | |||
DYS_FRM_NTFD_TO_PLND | NUMBER | |||
DYS_FRM_NTFD_TO_OCRD | NUMBER | |||
DYS_FRM_ACPTD_TO_PLND | NUMBER | |||
DYS_FRM_ACPTD_TO_OCRD | NUMBER | |||
NTFD_TRMNTN_DT | DATE | |||
ACCPTD_TRMNTN_DT | DATE | |||
PRJCTD_TRMNTN_DT | DATE | |||
ACTUAL_TRMNTN_DT | DATE | |||
FINAL_PROCESS_DT | DATE | |||
LEAVING_REASON | VARCHAR2 | (30) | ||
_DF:POS:_EDW | CHAR | (34) | ||
_DF:PSD:_EDW | CHAR | (32) |
Cut, paste (and edit) the following text to query this object:
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
, _DF:POS:_EDW
, _DF:PSD:_EDW
FROM APPS.HR_EDWBV_WRK_SPRTN_FCV;
|
|
|