[Home] [Help] [Dependency Information]
Object Name: | HR_EDW_WRK_SPRTN_F |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.HR_EDW_WRK_SPRTN_F |
Subobject Name: | |
Status: | VALID |
This is the Workforce Separation fact table. This fact analyses the different stages of the employee separation process. There is one row in the fact table for each assignment held by each employee in the Enterprise. As an employee moves through the separation process, the assignment rows are updated.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_EDW_WRK_SPRTN_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SEPARATION_PK |
HR_EDW_WRK_SPRTN_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_EMP_STRT_FK_KEY |
HR_EDW_WRK_SPRTN_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PERSON_TYPE_FK_KEY |
HR_EDW_WRK_SPRTN_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GRADE_FK_KEY |
HR_EDW_WRK_SPRTN_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REASON_FK_KEY |
HR_EDW_WRK_SPRTN_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | MOVEMENT_TYPE_FK_KEY |
HR_EDW_WRK_SPRTN_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_TRM_NTFD_FK_KEY |
HR_EDW_WRK_SPRTN_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_TRM_ACPTD_FK_KEY |
HR_EDW_WRK_SPRTN_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_TRM_PRJCTD_FK_KEY |
HR_EDW_WRK_SPRTN_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_TRM_PRCS_FK_KEY |
HR_EDW_WRK_SPRTN_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TIME_TRM_OCRD_FK_KEY |
HR_EDW_WRK_SPRTN_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
HR_EDW_WRK_SPRTN_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ORGANIZATION_FK_KEY |
HR_EDW_WRK_SPRTN_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | JOB_FK_KEY |
HR_EDW_WRK_SPRTN_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PERSON_FK_KEY |
HR_EDW_WRK_SPRTN_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GEOGRAPHY_FK_KEY |
HR_EDW_WRK_SPRTN_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ASSIGNMENT_FK_KEY |
HR_EDW_WRK_SPRTN_F_N7 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | POSITION_FK_KEY |
HR_EDW_WRK_SPRTN_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | AGE_BAND_FK_KEY |
HR_EDW_WRK_SPRTN_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SERVICE_BAND_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_EMP_STRT_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the start date of employment | ||
ORGANIZATION_FK_KEY | NUMBER | Warehouse foreign key to the Organization dimension | ||
JOB_FK_KEY | NUMBER | Warehouse foreign key to the Job dimension | ||
PERSON_FK_KEY | NUMBER | Warehouse foreign key to the Person dimension | ||
GEOGRAPHY_FK_KEY | NUMBER | Warehouse foreign key to the Geography dimension | ||
ASSIGNMENT_FK_KEY | NUMBER | Warehouse foreign key to the Assignment dimension | ||
POSITION_FK_KEY | NUMBER | Warehouse foreign key to the Position dimension | ||
AGE_BAND_FK_KEY | NUMBER | Warehouse foreign key to the Age Band dimension for the age of the person at the latest separation stage | ||
SERVICE_BAND_FK_KEY | NUMBER | Warehouse foreign key to the Period of Wok Band dimension | ||
PERSON_TYPE_FK_KEY | NUMBER | Warehouse foreign key to the Person Type dimension | ||
GRADE_FK_KEY | NUMBER | Warehouse foreign key to the Grade dimension | ||
REASON_FK_KEY | NUMBER | Warehouse foreign key to the Reason dimension | ||
MOVEMENT_TYPE_FK_KEY | NUMBER | Warehouse foreign key to the Movement Type dimension | ||
TIME_TRM_NTFD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date notification of separation was given | ||
TIME_TRM_ACPTD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date separation was accepted | ||
TIME_TRM_PRJCTD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date separation was projected | ||
TIME_TRM_PRCS_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date final processing for the separation occurred | ||
TIME_TRM_OCRD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date the separation actually occurred | ||
INSTANCE_FK_KEY | NUMBER | Warehouse foreign key to the Instance dimension | ||
SEPARATION_PK | VARCHAR2 | (400) | Textual unique identifier for the Workforce Separation fact | |
SEPARATION_PK_KEY | NUMBER | Unique warehouse identifier for the Workforce Separation fact | ||
ASG_ASSIGNMENT_ID | NUMBER | Hidden identifier for the assignment from the data source | ||
ASG_BUSINESS_GROUP_ID | NUMBER | Hidden identifier for the business group from the data source | ||
ASG_GRADE_ID | NUMBER | Hidden identifier for the grade from the data source | ||
ASG_JOB_ID | NUMBER | Hidden identifier for the job from the data source | ||
ASG_LOCATION_ID | NUMBER | Hidden identifier for the location from the data source | ||
ASG_ORGANIZATION_ID | NUMBER | Hidden identifier for the organization from the data source | ||
ASG_PERSON_ID | NUMBER | Hidden identifier for the person from the data source | ||
ASG_POSITION_ID | NUMBER | Hidden identifier for the position from the data source | ||
PPS_PRD_OF_SRVC_ID | NUMBER | Hidden identifier for the period of service from the data source | ||
PPS_TRM_ACPTD_PRSN_ID | NUMBER | Hidden identifier for the person accepting the termination from the data source | ||
DATE_OF_BIRTH | DATE | Date of birth | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
SEPARATION_HEADCOUNT | NUMBER | Headcount value of person at separation | ||
SEPARATION_FTE | NUMBER | Full Time Equivalent value of person at separation | ||
SPRTN_NTFD_VL | NUMBER | Indicator taking the value 1 if notice of separation has been given, and 0 otherwise | ||
SPRTN_ACCPTD_VL | NUMBER | Indicator taking the value 1 if the planned separation has been accepted, and 0 otherwise | ||
SPRTN_PLND_VL | NUMBER | Indicator taking the value 1 if a separation date has been planned, and 0 otherwise | ||
SPRTN_CNCLD_VL | NUMBER | Reserved for future use | ||
SPRTN_OCCRRD_VL | NUMBER | Indicator taking the value 1 if separation has occurred, and 0 otherwise | ||
SPRTN_FNL_PRCSSNG_VL | NUMBER | Indicator taking the value 1 if final processing of the separation has occurred, and 0 otherwise | ||
DAYS_FRM_STRT_TO_NTFD | NUMBER | Number of days between employment start and notice of separation (on primary assignments only) | ||
DAYS_FRM_STRT_TO_ACCPTD | NUMBER | Number of days between employment start and acceptance of separation (primary assignments only) | ||
DAYS_FRM_STRT_TO_PLND | NUMBER | Number of days between employment start and projected separation (primary assignments only) | ||
DAYS_FRM_STRT_TO_TRM | NUMBER | Number of days between employment start and separation occurring (primary assignments only) | ||
DAYS_FRM_STRT_TO_PRCSS | NUMBER | Number of days between employment start and final processing of separation (primary assignments only) | ||
DAYS_FRM_NTFD_TO_ACPTD | NUMBER | Number of days between separation notification and acceptance | ||
DAYS_FRM_NTFD_TO_PLND | NUMBER | Number of days between separation notification and projected separation | ||
DAYS_FRM_NTFD_TO_OCRD | NUMBER | Number of days between separation notification and actual separation | ||
DAYS_FRM_ACPTD_TO_PLND | NUMBER | Number of days between separation acceptance and projection | ||
DAYS_FRM_ACPTD_TO_OCRD | NUMBER | Number of days between separation acceptance and actual separation | ||
NTFD_TRMNTN_DT | DATE | Date notice of separation was given | ||
ACCPTD_TRMNTN_DT | DATE | Date when separation was accepted | ||
PRJCTD_TRMNTN_DT | DATE | Date separation is projected to occur | ||
ACTUAL_TRMNTN_DT | DATE | Date separation occurred | ||
FINAL_PROCESS_DT | DATE | Date final processing for the separation occurred | ||
LEAVING_REASON | VARCHAR2 | (30) | Reason given for separation | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure | ||
EMP_START_FTE | NUMBER | Full Time Equivalent value of employee at employment start | ||
EMP_START_HDCNT | NUMBER | Headcount value of employee at employment start | ||
SPRTN_NTFD_FTE | NUMBER | Full Time Equivalent value of employee when notice of separation was given | ||
SPRTN_NTFD_HDCNT | NUMBER | Headcount value of employee when notice of separation was given | ||
DAYS_FRM_STRT_TO_NTFD_ASG | NUMBER | Number of days between employment start and notice of separation (all assignments) | ||
SPRTN_ACCPTD_FTE | NUMBER | Full Time Equivalent value of employee when separation was accepted | ||
SPRTN_ACCPTD_HDCNT | NUMBER | Headcount value of employee when separation was accepted | ||
DAYS_FRM_STRT_TO_ACCPTD_ASG | NUMBER | Number of days between employment start and acceptance of separation (all assignments) | ||
SPRTN_PRJCTD_FTE | NUMBER | Full Time Equivalent value of employee when separation was projected | ||
SPRTN_PRJCTD_HDCNT | NUMBER | Headcount value of employee when separation was projected | ||
DAYS_FRM_STRT_TO_PLND_ASG | NUMBER | Number of days between employment start and separation projected (all assignments) | ||
EMP_SPRTN_FTE | NUMBER | Full Time Equivalent value of employee when separation occurred | ||
EMP_SPRTN_HDCNT | NUMBER | Headcount value of employee when separation occurred | ||
DAYS_FRM_STRT_TO_TRM_ASG | NUMBER | Number of days between employment start and separation occurring (all assignments) | ||
FINAL_PRCSS_FTE | NUMBER | Full Time Equivalent value of employee when final processing for the separation occurred | ||
FINAL_PRCSS_HDCNT | NUMBER | Headcount value of employee when final processing for the separation occurred | ||
DAYS_FRM_STRT_TO_PRCSS_ASG | NUMBER | Number of days between employment start and final processing of separation (all assignments) | ||
DAYS_FRM_STRT_TO_LST_UPDT | NUMBER | Number of days between employment start and latest separation stage (primary assignments only) | ||
DAYS_FRM_STRT_TO_LST_UPDT_ASG | NUMBER | Number of days between employment start and latest separation stage (all assignments) | ||
LATEST_ASG_DURATION | NUMBER | Number of days between assignment start and latest separation stage | ||
USER_FK1_KEY | NUMBER | User defined foreign key | ||
USER_FK2_KEY | NUMBER | User defined foreign key | ||
USER_FK3_KEY | NUMBER | User defined foreign key | ||
USER_FK4_KEY | NUMBER | User defined foreign key | ||
USER_FK5_KEY | NUMBER | User defined foreign key |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_EMP_STRT_FK_KEY
, ORGANIZATION_FK_KEY
, JOB_FK_KEY
, PERSON_FK_KEY
, GEOGRAPHY_FK_KEY
, ASSIGNMENT_FK_KEY
, POSITION_FK_KEY
, AGE_BAND_FK_KEY
, SERVICE_BAND_FK_KEY
, PERSON_TYPE_FK_KEY
, GRADE_FK_KEY
, REASON_FK_KEY
, MOVEMENT_TYPE_FK_KEY
, TIME_TRM_NTFD_FK_KEY
, TIME_TRM_ACPTD_FK_KEY
, TIME_TRM_PRJCTD_FK_KEY
, TIME_TRM_PRCS_FK_KEY
, TIME_TRM_OCRD_FK_KEY
, INSTANCE_FK_KEY
, SEPARATION_PK
, SEPARATION_PK_KEY
, 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
, SEPARATION_HEADCOUNT
, SEPARATION_FTE
, SPRTN_NTFD_VL
, SPRTN_ACCPTD_VL
, SPRTN_PLND_VL
, SPRTN_CNCLD_VL
, SPRTN_OCCRRD_VL
, SPRTN_FNL_PRCSSNG_VL
, DAYS_FRM_STRT_TO_NTFD
, DAYS_FRM_STRT_TO_ACCPTD
, DAYS_FRM_STRT_TO_PLND
, DAYS_FRM_STRT_TO_TRM
, DAYS_FRM_STRT_TO_PRCSS
, DAYS_FRM_NTFD_TO_ACPTD
, DAYS_FRM_NTFD_TO_PLND
, DAYS_FRM_NTFD_TO_OCRD
, DAYS_FRM_ACPTD_TO_PLND
, DAYS_FRM_ACPTD_TO_OCRD
, NTFD_TRMNTN_DT
, ACCPTD_TRMNTN_DT
, PRJCTD_TRMNTN_DT
, ACTUAL_TRMNTN_DT
, FINAL_PROCESS_DT
, LEAVING_REASON
, 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_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, EMP_START_FTE
, EMP_START_HDCNT
, SPRTN_NTFD_FTE
, SPRTN_NTFD_HDCNT
, DAYS_FRM_STRT_TO_NTFD_ASG
, SPRTN_ACCPTD_FTE
, SPRTN_ACCPTD_HDCNT
, DAYS_FRM_STRT_TO_ACCPTD_ASG
, SPRTN_PRJCTD_FTE
, SPRTN_PRJCTD_HDCNT
, DAYS_FRM_STRT_TO_PLND_ASG
, EMP_SPRTN_FTE
, EMP_SPRTN_HDCNT
, DAYS_FRM_STRT_TO_TRM_ASG
, FINAL_PRCSS_FTE
, FINAL_PRCSS_HDCNT
, DAYS_FRM_STRT_TO_PRCSS_ASG
, DAYS_FRM_STRT_TO_LST_UPDT
, DAYS_FRM_STRT_TO_LST_UPDT_ASG
, LATEST_ASG_DURATION
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
FROM HRI.HR_EDW_WRK_SPRTN_F;
HRI.HR_EDW_WRK_SPRTN_F does not reference any database object
HRI.HR_EDW_WRK_SPRTN_F is referenced by following:
|
|
|