eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HRI.HR_EDW_WRK_ACTVTY_F

Object Details

Object Name:	HR_EDW_WRK_ACTVTY_F
Object Type:	TABLE
Owner:	HRI
FND Design Data:	HRI.HR_EDW_WRK_ACTVTY_F
Subobject Name:
Status:	VALID

This is the Workforce Activity fact table. While working for an Enterprise, employees may change job, grade, organization, location, and position. Employees may also move in or out of the Enterprise (recruitment or separation). These changes reveal overall patterns of change within the Enterprise and can help you to plan future staffing requirements and analyze the possible reasons for these changes.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_EDW_WRK_ACTVTY_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_CHANGE_PK
HR_EDW_WRK_ACTVTY_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	AGE_BAND_FK_KEY
HR_EDW_WRK_ACTVTY_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GEOGRAPHY_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_FROM_FK_KEY
HR_EDW_WRK_ACTVTY_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_FK_KEY
HR_EDW_WRK_ACTVTY_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	POSITION_FROM_FK_KEY
HR_EDW_WRK_ACTVTY_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	POSITION_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_TYPE_FK_KEY
HR_EDW_WRK_ACTVTY_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REASON_FK_KEY
HR_EDW_WRK_ACTVTY_F_N18	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SERVICE_BAND_FK_KEY
HR_EDW_WRK_ACTVTY_F_N19	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_FROM_FK_KEY
HR_EDW_WRK_ACTVTY_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_CHANGE_FK_KEY
HR_EDW_WRK_ACTVTY_F_N20	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N21	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
HR_EDW_WRK_ACTVTY_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_FK_KEY
HR_EDW_WRK_ACTVTY_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GRADE_FROM_FK_KEY
HR_EDW_WRK_ACTVTY_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GRADE_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	JOB_FROM_FK_KEY
HR_EDW_WRK_ACTVTY_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	JOB_TO_FK_KEY
HR_EDW_WRK_ACTVTY_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MOVEMENT_TYPE_FK_KEY
HR_EDW_WRK_ACTVTY_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GEOGRAPHY_FROM_FK_KEY

Columns

Name	Datatype	Length	Comments
INSTANCE_FK_KEY	NUMBER		Warehouse foreign key to the Instance dimension
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
ORGANIZATION_ID	NUMBER		Hidden Identifier for the organization from the data source
PEOPLE_GROUP_ID	NUMBER		Hidden Identifier for the people group 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_JOB_X	NUMBER		Number of days since the assignment's last job change
DAYS_SINCE_LAST_ORG_X	NUMBER		Number of days since the assignment's last organization 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
GRD_CHANGE_FLAG	NUMBER		Indicator taking the value 1 if the assignment's grade has changed, and 0 otherwise
GEOG_CHANGE_FLAG	NUMBER		Indicator taking the value 1 if the assignment's location has changed, and 0 otherwise
POS_CHANGE_FLAG	NUMBER		Indicator taking the value 1 if the assignment's position has changed and 0 otherwise
ORG_CHANGE_FLAG	NUMBER		Indicator taking the value 1 if the assignment's organization has changed, and 0 otherwise
JOB_CHANGE_FLAG	NUMBER		Indicator taking the value 1 if the assignment's job has changed, and 0 otherwise
ASSIGNMENT_CHANGE_PK_KEY	NUMBER		Unique warehouse identifier for the Workforce Activity fact
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
PERSON_TYPE_FK_KEY	NUMBER		Warehouse foreign key to the Person 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_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
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
MOVEMENT_TYPE_FK_KEY	NUMBER		Warehouse foreign key to the Movement Type Dimension
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
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
ASSIGNMENT_FK_KEY	NUMBER		Warehouse foreign key to the Assignment Dimension
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
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
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 INSTANCE_FK_KEY
,      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
,      ORGANIZATION_ID
,      PEOPLE_GROUP_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_JOB_X
,      DAYS_SINCE_LAST_ORG_X
,      ASG_CHANGE_FTE
,      ASG_CHANGE_HEADCOUNT
,      EMPLYMNT_START_FLAG
,      OTHER_CHANGE_FLAG
,      GRD_CHANGE_FLAG
,      GEOG_CHANGE_FLAG
,      POS_CHANGE_FLAG
,      ORG_CHANGE_FLAG
,      JOB_CHANGE_FLAG
,      ASSIGNMENT_CHANGE_PK_KEY
,      TIME_TO_FK_KEY
,      TIME_FROM_FK_KEY
,      SERVICE_BAND_FK_KEY
,      REASON_FK_KEY
,      PERSON_TYPE_FK_KEY
,      POSITION_TO_FK_KEY
,      POSITION_FROM_FK_KEY
,      PERSON_FK_KEY
,      ORGANIZATION_TO_FK_KEY
,      ORGANIZATION_FROM_FK_KEY
,      GEOGRAPHY_TO_FK_KEY
,      GEOGRAPHY_FROM_FK_KEY
,      MOVEMENT_TYPE_FK_KEY
,      JOB_TO_FK_KEY
,      JOB_FROM_FK_KEY
,      GRADE_TO_FK_KEY
,      GRADE_FROM_FK_KEY
,      ASSIGNMENT_FK_KEY
,      ASSIGNMENT_CHANGE_FK_KEY
,      AGE_BAND_FK_KEY
,      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
,      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_F;

Dependencies

[top of page]

HRI.HR_EDW_WRK_ACTVTY_F does not reference any database object

HRI.HR_EDW_WRK_ACTVTY_F is referenced by following:

APPS: HR_EDW_WRK_ACTVTY_F