[Home] [Help] [Dependency Information]
Object Name: | HR_EDW_WRK_SPRTN_FSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.HR_EDW_WRK_SPRTN_FSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Workforce Separation fact. Data from multiple transactional systems is staged here for verification and cleansing before it is loaded into the fact table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_EDW_WRK_SPRTN_FSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | SEPARATION_PK |
HR_EDW_WRK_SPRTN_FSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | ||
DYS_FRM_STRT_TO_NTFD | NUMBER | Number of days between employment start and notice of separation (on primary assignments only) | ||
DYS_FRM_STRT_TO_ACCPTD | NUMBER | Number of days between employment start and acceptance of separation (primary assignments only) | ||
DYS_FRM_STRT_TO_PLND | NUMBER | Number of days between employment start and projected separation (primary assignments only) | ||
DYS_FRM_STRT_TO_TRM | NUMBER | Number of days between employment start and separation occurring (primary assignments only) | ||
DYS_FRM_STRT_TO_PRCSS | NUMBER | Number of days between employment start and final processing of separation (primary assignments only) | ||
DYS_FRM_NTFD_TO_ACPTD | NUMBER | Number of days between separation notification and acceptance | ||
DYS_FRM_NTFD_TO_PLND | NUMBER | Number of days between separation notification and projected separation | ||
DYS_FRM_NTFD_TO_OCRD | NUMBER | Number of days between separation notification and actual separation | ||
DYS_FRM_ACPTD_TO_PLND | NUMBER | Number of days between separation acceptance and projection | ||
DYS_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_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_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_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 | ||
TIME_EMP_STRT_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the start date of employment | ||
TIME_EMP_STRT_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
TIME_TRM_NTFD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date notification of separation was given | ||
TIME_TRM_ACCPTD_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_PRCSS_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date final processing for the separation occurred | ||
TIME_TRM_OCCRD_FK_KEY | NUMBER | Warehouse foreign key to the Time dimension for the date the separation actually occurred | ||
TIME_TRM_NTFD_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
TIME_TRM_ACCPTD_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
TIME_TRM_PRJCTD_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
TIME_TRM_PRCSS_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
TIME_TRM_OCCRD_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
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 | ||
INSTANCE_FK_KEY | NUMBER | Warehouse foreign key to the Instance 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 | ||
ORGANIZATION_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
JOB_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
PERSON_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
GEOGRAPHY_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
ASSIGNMENT_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
POSITION_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
AGE_BAND_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
SERVICE_BAND_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
PERSON_TYPE_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
INSTANCE_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
GRADE_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
REASON_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
MOVEMENT_TYPE_FK | VARCHAR2 | (400) | Textual foreign key to the dimension | |
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 | ||
ROW_ID | ROWID | (10) | Row identifier | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
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 | ||
DYS_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 | ||
DYS_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 | ||
DYS_FRM_STRT_TO_PLND_ASG | NUMBER | Number of days between employment start and separation projected (all assignments) | ||
EMP_SPRTN_HDCNT | NUMBER | Headcount value of employee when separation occurred | ||
EMP_SPRTN_FTE | NUMBER | Full Time Equivalent value of employee when separation occurred | ||
DYS_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 | ||
DYS_FRM_STRT_TO_PRCSS_ASG | NUMBER | Number of days between employment start and final processing of separation (all assignments) | ||
DYS_FRM_STRT_TO_LST_UPDT | NUMBER | Number of days between employment start and latest separation stage (primary assignments only) | ||
DYS_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 | VARCHAR2 | (400) | User defined foreign key | |
USER_FK2 | VARCHAR2 | (400) | User defined foreign key | |
USER_FK3 | VARCHAR2 | (400) | User defined foreign key | |
USER_FK4 | VARCHAR2 | (400) | User defined foreign key | |
USER_FK5 | VARCHAR2 | (400) | User defined foreign key |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, 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_ATTRIBUTE1
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, TIME_EMP_STRT_FK_KEY
, TIME_EMP_STRT_FK
, TIME_TRM_NTFD_FK_KEY
, TIME_TRM_ACCPTD_FK_KEY
, TIME_TRM_PRJCTD_FK_KEY
, TIME_TRM_PRCSS_FK_KEY
, TIME_TRM_OCCRD_FK_KEY
, TIME_TRM_NTFD_FK
, TIME_TRM_ACCPTD_FK
, TIME_TRM_PRJCTD_FK
, TIME_TRM_PRCSS_FK
, TIME_TRM_OCCRD_FK
, 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
, INSTANCE_FK_KEY
, GRADE_FK_KEY
, REASON_FK_KEY
, MOVEMENT_TYPE_FK_KEY
, ORGANIZATION_FK
, JOB_FK
, PERSON_FK
, GEOGRAPHY_FK
, ASSIGNMENT_FK
, POSITION_FK
, AGE_BAND_FK
, SERVICE_BAND_FK
, PERSON_TYPE_FK
, INSTANCE_FK
, GRADE_FK
, REASON_FK
, MOVEMENT_TYPE_FK
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, ROW_ID
, REQUEST_ID
, ERROR_CODE
, COLLECTION_STATUS
, OPERATION_CODE
, EMP_START_FTE
, EMP_START_HDCNT
, SPRTN_NTFD_FTE
, SPRTN_NTFD_HDCNT
, DYS_FRM_STRT_TO_NTFD_ASG
, SPRTN_ACCPTD_FTE
, SPRTN_ACCPTD_HDCNT
, DYS_FRM_STRT_TO_ACCPTD_ASG
, SPRTN_PRJCTD_FTE
, SPRTN_PRJCTD_HDCNT
, DYS_FRM_STRT_TO_PLND_ASG
, EMP_SPRTN_HDCNT
, EMP_SPRTN_FTE
, DYS_FRM_STRT_TO_TRM_ASG
, FINAL_PRCSS_FTE
, FINAL_PRCSS_HDCNT
, DYS_FRM_STRT_TO_PRCSS_ASG
, DYS_FRM_STRT_TO_LST_UPDT
, DYS_FRM_STRT_TO_LST_UPDT_ASG
, LATEST_ASG_DURATION
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
FROM HRI.HR_EDW_WRK_SPRTN_FSTG;
HRI.HR_EDW_WRK_SPRTN_FSTG does not reference any database object
HRI.HR_EDW_WRK_SPRTN_FSTG is referenced by following:
|
|
|