DBA Data[Home] [Help] [Dependency Information]

TABLE: HRI.HR_EDW_WRK_ACTVTY_FSTG

Object Details
Object Name: HR_EDW_WRK_ACTVTY_FSTG
Object Type: TABLE
Owner: HRI
FND Design Data: TableHRI.HR_EDW_WRK_ACTVTY_FSTG
Subobject Name:
Status: VALID


This is the staging table for the Workforce Activity fact. Data from multiple transaction systems is staged here for verification and cleansing before it is loaded into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_EDW_WRK_ACTVTY_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSIGNMENT_CHANGE_PK
HR_EDW_WRK_ACTVTY_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_FK_KEY NUMBER

Warehouse foreign key to the Assignment Dimension
REQUEST_ID NUMBER

Identifier used by collection program
USER_FK5_KEY NUMBER

User defined foreign key
USER_FK4_KEY NUMBER

User defined foreign key
USER_FK3_KEY NUMBER

User defined foreign key
USER_FK2_KEY NUMBER

User defined foreign key
USER_FK1_KEY NUMBER

User defined foreign key
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
ESTABLISHMENT_ID NUMBER

Hidden Identifier for the establishment from the data source
CAGR_GRADE_DEF_ID NUMBER

Hidden Identifier for the grade definition from the data source
CAGR_ID_FLEX_NUM NUMBER

Grade Id Flex Number
COLLECTIVE_AGREEMENT_ID NUMBER

Hidden Identifier for the collective agreement from the data source
CONTRACT_ID NUMBER

Hidden Identifier for the contact from the data source
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
PROGRAM_ID NUMBER

Hidden Identifier for the program from the data source
PROGRAM_APPLICATION_ID NUMBER

Hidden Identifier for the program application from the data source
ASG_REQUEST_ID NUMBER

Hidden Identifier for the assignment request from the data source
SET_OF_BOOKS_ID NUMBER

Hidden Identifier for the set of books from the data source
SAL_REVIEW_PERIOD NUMBER

Salary Review Period for the Assignment
PROBATION_PERIOD NUMBER

Probation Period for the Assignment
PERIOD_OF_SERVICE_ID NUMBER

Hidden Identifier for the period of service from the data source
PERF_REVIEW_PERIOD NUMBER

Performance Review Period for the Assignment
NORMAL_HOURS NUMBER

Normal Hours for the Assignment
DEFAULT_CODE_COMB_ID NUMBER

Hidden Identifier for the default code combination from the data source
COMMENT_ID NUMBER

Hidden Identifier for the comment from the data source
APPLICATION_ID NUMBER

Hidden Identifier for the application from the data source
ASSIGNMENT_SEQUENCE NUMBER

Assignment Sequence
PAY_BASIS_ID NUMBER

Hidden Identifier for the pay basis from the data source
VACANCY_ID NUMBER

Hidden Identifier for the vacancy from the data source
SOFT_CODING_KEYFLEX_ID NUMBER

Hidden Identifier for the soft coding key flexfield from the data source
PEOPLE_GROUP_ID NUMBER

Hidden Identifier for the people group from the data source
ORGANIZATION_ID NUMBER

Hidden Identifier for the organization from the data source
SOURCE_ORGANIZATION_ID NUMBER

Hidden Identifier for the source organization from the data source
RECRUITMENT_ACTIVITY_ID NUMBER

Hidden Identifier for the recruitment activity from the data source
PERSON_ID NUMBER

Hidden Identifier for the person from the data source
SPECIAL_CEILING_STEP_ID NUMBER

Hidden Identifier for the special ceiling step from the data source
SUPERVISOR_ID NUMBER

Hidden Identifier for the supervisor from the data source
PERSON_REFERRED_BY_ID NUMBER

Hidden Identifier for the person referred by from the data source
LOCATION_ID NUMBER

Hidden Identifier for the location from the data source
PAYROLL_ID NUMBER

Hidden Identifier for the payroll from the data source
ASSIGNMENT_STATUS_TYPE_ID NUMBER

Hidden Identifier for the assignment status type from the data source
JOB_ID NUMBER

Hidden Identifier for the job from the data source
POSITION_ID NUMBER

Hidden Identifier for the position from the data source
GRADE_ID NUMBER

Hidden Identifier for the grade from the data source
RECRUITER_ID NUMBER

Hidden Identifier for the recruiter from the data source
BUSINESS_GROUP_ID NUMBER

Hidden Identifier for the business group from the data source
ASSIGNMENT_ID NUMBER

Hidden Identifier for the assignment from the data source
DAYS_EMP_START_TO_TERM NUMBER

Number of days between Employment Start and Employment Termination
DAYS_SINCE_LAST_GEOG_X NUMBER

Number of days since the assignment's last location change
DAYS_SINCE_LAST_GRD_X NUMBER

Number of days since the assignment's last grade change
DAYS_SINCE_LAST_POS_X NUMBER

Number of days since the assignment's last position change
DAYS_SINCE_LAST_ORG_X NUMBER

Number of days since the assignment's last organization change
DAYS_SINCE_LAST_JOB_X NUMBER

Number of days since the assignment's last job change
ASG_CHANGE_FTE NUMBER

Actual Full Time Equivalent (Assignment Change)
ASG_CHANGE_HEADCOUNT NUMBER

Actual Head Count (Assignment Change)
EMPLYMNT_START_FLAG NUMBER

Indicator taking the value 1 if employment has started, and 0 otherwise
OTHER_CHANGE_FLAG NUMBER

Indicator taking the value 1 if an assignment change without it's own specific indicator occurs, and 0 otherwise
GEOG_CHANGE_FLAG NUMBER

Indicator taking the value 1 if the assignment's location has changed, and 0 otherwise
GRD_CHANGE_FLAG NUMBER

Indicator taking the value 1 if the assignment's grade has changed, and 0 otherwise
ORG_CHANGE_FLAG NUMBER

Indicator taking the value 1 if the assignment's organization has changed and 0 otherwise
POS_CHANGE_FLAG NUMBER

Indicator taking the value 1 if the assignment's position has changed, and 0 otherwise
JOB_CHANGE_FLAG NUMBER

Indicator taking the value 1 if the assignment's job has changed, and 0 otherwise
TIME_TO_FK_KEY NUMBER

Warehouse foreign key to the Time Dimension for the date the change is valid to
TIME_FROM_FK_KEY NUMBER

Warehouse foreign key to the Time Dimension for the date the change is valid from
SERVICE_BAND_FK_KEY NUMBER

Warehouse foreign key to the Period of Work Dimension
REASON_FK_KEY NUMBER

Warehouse foreign key to the Reason Dimension
MOVEMENT_FK_KEY NUMBER

Warehouse foreign key to the Movement Type Dimension
POSITION_TO_FK_KEY NUMBER

Warehouse foreign key to the Position Dimension
POSITION_FROM_FK_KEY NUMBER

Warehouse foreign key to the Position Dimension for what the Position has changed from
PERSON_TYPE_FK_KEY NUMBER

Warehouse foreign key to the Person Type Dimension
PERSON_FK_KEY NUMBER

Warehouse foreign key to the Person Dimension
ORGANIZATION_TO_FK_KEY NUMBER

Warehouse foreign key to the Internal Organization Dimension for the Organization that the assignment has changed to
ORGANIZATION_FROM_FK_KEY NUMBER

Warehouse foreign key to the Internal Organization Dimension for the Organization that the assignment has changed from
JOB_TO_FK_KEY NUMBER

Warehouse foreign key to the Job Dimension that the assignment has changed to
JOB_FROM_FK_KEY NUMBER

Warehouse foreign key to the Job Dimension that the assignment has changed from
INSTANCE_FK_KEY NUMBER

Warehouse foreign key to the Instance dimension
GRADE_TO_FK_KEY NUMBER

Warehouse foreign key to the Grade (Human Resources) Dimension that the assignment has changed to
GRADE_FROM_FK_KEY NUMBER

Warehouse foreign key to the Grade (Human Resources) Dimension that the assignment has changed from
GEOGRAPHY_TO_FK_KEY NUMBER

Warehouse foreign key to the Geography Dimension that the assignment has changed to
GEOGRAPHY_FROM_FK_KEY NUMBER

Warehouse foreign key to the Geography Dimension that the assignment has changed from
ASSIGNMENT_CHANGE_FK_KEY NUMBER

Warehouse foreign key to the Workforce Change Dimension
AGE_BAND_FK_KEY NUMBER

Warehouse foreign key to the Age Dimension
ASSIGNMENT_CHANGE_PK_KEY NUMBER

Unique warehouse identifier for the Workforce Activity fact
ASSIGNMENT_FK VARCHAR2 (400)
Textual foreign key to the dimension
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
COLLECTION_STATUS VARCHAR2 (30)
Loading status code for the record
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
ROW_ID ROWID (10)
Row identifier
USER_FK5 VARCHAR2 (400)
User defined foreign key
USER_FK4 VARCHAR2 (400)
User defined foreign key
USER_FK3 VARCHAR2 (400)
User defined foreign key
USER_FK2 VARCHAR2 (400)
User defined foreign key
USER_FK1 VARCHAR2 (400)
User defined foreign key
HOURLY_SALARIED_CODE VARCHAR2 (30)
Hourly Salaried Code
LABOUR_UNION_MEMBER_FLAG VARCHAR2 (30)
Labour union member indicator
BARGAINING_UNIT_CODE VARCHAR2 (30)
Bargaining Unit Code
ASG_TITLE VARCHAR2 (30)
Title for assignment
TIME_NORMAL_START VARCHAR2 (30)
Start time of normal work day
TIME_NORMAL_FINISH VARCHAR2 (30)
End time of normal work day
SOURCE_TYPE VARCHAR2 (30)
Recruitment activity source for applicant assignment
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Frequency of salary review period
PROBATION_UNIT VARCHAR2 (30)
Units of probation period duration
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Frequency of performance review period
MANAGER_FLAG VARCHAR2 (30)
Whether the employee owning this assignment is designated a manager
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal address details such as floor or office number
FREQUENCY VARCHAR2 (30)
Frequency of normal working hours (e.g. week, month or year)
EMPLOYMENT_CATEGORY VARCHAR2 (30)
User defined employment category (e.g. Full Time, Permanent or Part Time)
CHANGE_REASON VARCHAR2 (30)
Reason the assignment last changed
ASSIGNMENT_NUMBER VARCHAR2 (30)
System generated identifier for the assignment
PRIMARY_FLAG VARCHAR2 (30)
Whether the assignment is the primary assignment of the person
ASSIGNMENT_TYPE VARCHAR2 (30)
Assignment type, employee or applicant
TIME_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
SERVICE_BAND_FK VARCHAR2 (400)
Textual foreign key to the dimension
REASON_FK VARCHAR2 (400)
Textual foreign key to the dimension
MOVEMENT_FK VARCHAR2 (1200)
Textual foreign key to the dimension
POSITION_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
POSITION_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_TYPE_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_FK VARCHAR2 (400)
Textual foreign key to the dimension
ORGANIZATION_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
ORGANIZATION_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
JOB_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
JOB_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
INSTANCE_FK VARCHAR2 (40)
Textual foreign key to the dimension
GRADE_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
GRADE_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
GEOGRAPHY_TO_FK VARCHAR2 (400)
Textual foreign key to the dimension
GEOGRAPHY_FROM_FK VARCHAR2 (400)
Textual foreign key to the dimension
ASSIGNMENT_CHANGE_FK VARCHAR2 (400)
Textual foreign key to the dimension
AGE_BAND_FK VARCHAR2 (400)
Textual foreign key to the dimension
ASSIGNMENT_CHANGE_PK VARCHAR2 (400)
Textual unique ientifier for the Workforce Activity fact
PROGRAM_UPDATE_DATE DATE

Standard who column
DATE_PROBATION_END DATE

End date of probation period
EFFECTIVE_END_DATE DATE

Date tracked end date of assignment
EFFECTIVE_START_DATE DATE

Date tracked start date of assignment
LAST_UPDATE_DATE DATE

Standard who column
CREATION_DATE DATE

Standard who column
ASSGNMNT_ENDED_FLAG NUMBER

Indicator taking the value 1 if the assignment has ended, and 0 otherwise
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_FK_KEY
,      REQUEST_ID
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      ESTABLISHMENT_ID
,      CAGR_GRADE_DEF_ID
,      CAGR_ID_FLEX_NUM
,      COLLECTIVE_AGREEMENT_ID
,      CONTRACT_ID
,      OBJECT_VERSION_NUMBER
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      ASG_REQUEST_ID
,      SET_OF_BOOKS_ID
,      SAL_REVIEW_PERIOD
,      PROBATION_PERIOD
,      PERIOD_OF_SERVICE_ID
,      PERF_REVIEW_PERIOD
,      NORMAL_HOURS
,      DEFAULT_CODE_COMB_ID
,      COMMENT_ID
,      APPLICATION_ID
,      ASSIGNMENT_SEQUENCE
,      PAY_BASIS_ID
,      VACANCY_ID
,      SOFT_CODING_KEYFLEX_ID
,      PEOPLE_GROUP_ID
,      ORGANIZATION_ID
,      SOURCE_ORGANIZATION_ID
,      RECRUITMENT_ACTIVITY_ID
,      PERSON_ID
,      SPECIAL_CEILING_STEP_ID
,      SUPERVISOR_ID
,      PERSON_REFERRED_BY_ID
,      LOCATION_ID
,      PAYROLL_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      RECRUITER_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      DAYS_EMP_START_TO_TERM
,      DAYS_SINCE_LAST_GEOG_X
,      DAYS_SINCE_LAST_GRD_X
,      DAYS_SINCE_LAST_POS_X
,      DAYS_SINCE_LAST_ORG_X
,      DAYS_SINCE_LAST_JOB_X
,      ASG_CHANGE_FTE
,      ASG_CHANGE_HEADCOUNT
,      EMPLYMNT_START_FLAG
,      OTHER_CHANGE_FLAG
,      GEOG_CHANGE_FLAG
,      GRD_CHANGE_FLAG
,      ORG_CHANGE_FLAG
,      POS_CHANGE_FLAG
,      JOB_CHANGE_FLAG
,      TIME_TO_FK_KEY
,      TIME_FROM_FK_KEY
,      SERVICE_BAND_FK_KEY
,      REASON_FK_KEY
,      MOVEMENT_FK_KEY
,      POSITION_TO_FK_KEY
,      POSITION_FROM_FK_KEY
,      PERSON_TYPE_FK_KEY
,      PERSON_FK_KEY
,      ORGANIZATION_TO_FK_KEY
,      ORGANIZATION_FROM_FK_KEY
,      JOB_TO_FK_KEY
,      JOB_FROM_FK_KEY
,      INSTANCE_FK_KEY
,      GRADE_TO_FK_KEY
,      GRADE_FROM_FK_KEY
,      GEOGRAPHY_TO_FK_KEY
,      GEOGRAPHY_FROM_FK_KEY
,      ASSIGNMENT_CHANGE_FK_KEY
,      AGE_BAND_FK_KEY
,      ASSIGNMENT_CHANGE_PK_KEY
,      ASSIGNMENT_FK
,      OPERATION_CODE
,      COLLECTION_STATUS
,      ERROR_CODE
,      ROW_ID
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK1
,      HOURLY_SALARIED_CODE
,      LABOUR_UNION_MEMBER_FLAG
,      BARGAINING_UNIT_CODE
,      ASG_TITLE
,      TIME_NORMAL_START
,      TIME_NORMAL_FINISH
,      SOURCE_TYPE
,      SAL_REVIEW_PERIOD_FREQUENCY
,      PROBATION_UNIT
,      PERF_REVIEW_PERIOD_FREQUENCY
,      MANAGER_FLAG
,      INTERNAL_ADDRESS_LINE
,      FREQUENCY
,      EMPLOYMENT_CATEGORY
,      CHANGE_REASON
,      ASSIGNMENT_NUMBER
,      PRIMARY_FLAG
,      ASSIGNMENT_TYPE
,      TIME_TO_FK
,      TIME_FROM_FK
,      SERVICE_BAND_FK
,      REASON_FK
,      MOVEMENT_FK
,      POSITION_TO_FK
,      POSITION_FROM_FK
,      PERSON_TYPE_FK
,      PERSON_FK
,      ORGANIZATION_TO_FK
,      ORGANIZATION_FROM_FK
,      JOB_TO_FK
,      JOB_FROM_FK
,      INSTANCE_FK
,      GRADE_TO_FK
,      GRADE_FROM_FK
,      GEOGRAPHY_TO_FK
,      GEOGRAPHY_FROM_FK
,      ASSIGNMENT_CHANGE_FK
,      AGE_BAND_FK
,      ASSIGNMENT_CHANGE_PK
,      PROGRAM_UPDATE_DATE
,      DATE_PROBATION_END
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ASSGNMNT_ENDED_FLAG
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM HRI.HR_EDW_WRK_ACTVTY_FSTG;

Dependencies

[top of page]

HRI.HR_EDW_WRK_ACTVTY_FSTG does not reference any database object

HRI.HR_EDW_WRK_ACTVTY_FSTG is referenced by following:

SchemaAPPS
SynonymHR_EDW_WRK_ACTVTY_FSTG