[Home] [Help] [Dependency Information]
Object Name: | HR_EDW_WRK_SPRTN_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HR_EDW_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) | ||
USER_MEASURE1 | VARCHAR2 | (0) | ||
USER_MEASURE2 | VARCHAR2 | (0) | ||
USER_MEASURE3 | VARCHAR2 | (0) | ||
USER_MEASURE4 | VARCHAR2 | (0) | ||
USER_MEASURE5 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE1 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE2 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE3 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE4 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE5 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE6 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE7 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE8 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE9 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE10 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE11 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE12 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE13 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE14 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE15 | VARCHAR2 | (0) | ||
USER_FK1 | VARCHAR2 | (0) | ||
USER_FK2 | VARCHAR2 | (0) | ||
USER_FK3 | VARCHAR2 | (0) | ||
USER_FK4 | VARCHAR2 | (0) | ||
USER_FK5 | VARCHAR2 | (0) |
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
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
FROM APPS.HR_EDW_WRK_SPRTN_FCV;
|
|
|