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_CMPSTN_F

Object Details

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

This is the Workforce Composition fact table.This fact examines the available workforce makeup at specific points in time by all relevant dimensions. Snapshots of the workforce are taken at regular intervals; the collection process controls the interval between snapshots.
The purpose of the Workforce Composition fact is to show where workforce is deployed, and how deployment changes over time. By analyzing snapshots of an enterprise over time, various trends can be identified.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_EDW_WRK_CMPSTN_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	COMPOSITION_PK
HR_EDW_WRK_CMPSTN_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	JOB_FK_KEY
HR_EDW_WRK_CMPSTN_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
HR_EDW_WRK_CMPSTN_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGA_ORGANIZATION_FK_KEY
HR_EDW_WRK_CMPSTN_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TIME_FK_KEY
HR_EDW_WRK_CMPSTN_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_FK_KEY
HR_EDW_WRK_CMPSTN_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GRADE_FK_KEY
HR_EDW_WRK_CMPSTN_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GEOGRAPHY_FK_KEY
HR_EDW_WRK_CMPSTN_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	AGE_BAND_FK_KEY
HR_EDW_WRK_CMPSTN_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_FK_KEY
HR_EDW_WRK_CMPSTN_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	POSITION_FK_KEY
HR_EDW_WRK_CMPSTN_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PERSON_TYPE_FK_KEY
HR_EDW_WRK_CMPSTN_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SERVICE_BAND_FK_KEY

Columns

Name	Datatype	Length	Comments
JOB_FK_KEY	NUMBER		Warehouse foreign key to the Job dimension
PERSON_FK_KEY	NUMBER		Warehouse foreign key to the Person dimension
GRADE_FK_KEY	NUMBER		Warehouse foreign key to the Grade dimension
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
ASSIGNMENT_START_DATE	DATE		Start date of the assignment at the snapshot date
COMPOSITION_FTE	NUMBER		Full Time Equivalent value of the assignment at the time of the snapshot
COMPOSITION_HEADCOUNT	NUMBER		Headcount value of the assignment at the time of the snapshot
COMPOSITION_PK	VARCHAR2	(400)	Textual unique identifier for the Workforce Composition fact
COMPOSITION_PK_KEY	NUMBER		Unique warehouse identifier for the Workforce Composition fact
CREATION_DATE	DATE		Standard who column
DATE_OF_BIRTH	DATE		Date of birth
LAST_UPDATE_DATE	DATE		Standard who column
SNAPSHOT_DATE	DATE		Date of snapshot
USER_FK1_KEY	VARCHAR2	(400)	User defined foreign key
USER_FK2_KEY	VARCHAR2	(400)	User defined foreign key
USER_FK3_KEY	VARCHAR2	(400)	User defined foreign key
USER_FK4_KEY	VARCHAR2	(400)	User defined foreign key
USER_FK5_KEY	VARCHAR2	(400)	User defined foreign key
USER_MEASURE1	NUMBER		User defined measure
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_MEASURE2	NUMBER		User defined measure
USER_MEASURE3	NUMBER		User defined measure
USER_MEASURE4	NUMBER		User defined measure
USER_MEASURE5	NUMBER		User defined measure
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
GEOGRAPHY_FK_KEY	NUMBER		Warehouse foreign key to the Geography dimension
AGE_BAND_FK_KEY	NUMBER		Warehouse foreign key to the Age Band dimension for the age of the person at the time of the snapshot
ASSIGNMENT_FK_KEY	NUMBER		Warehouse foreign key to the Assignment dimension
POSITION_FK_KEY	NUMBER		Warehouse foreign key to the Position dimension
PERSON_TYPE_FK_KEY	NUMBER		Warehouse foreign key to the Person Type dimension
SERVICE_BAND_FK_KEY	NUMBER		Warehouse foreign key to the Service Band dimension
INSTANCE_FK_KEY	NUMBER		Warehouse foreign key to the Instance dimension
ORGA_ORGANIZATION_FK_KEY	NUMBER		Warehouse foreign key to the Organization dimension
TIME_FK_KEY	NUMBER		Warehouse foreign key to the Time dimension for the snapshot date
CRNT_ANNLZED_SLRY	NUMBER		Annualized salary at time of snapshot (warehouse currency)
CRNT_ANNLZED_SLRY_BC	NUMBER		Annualized salary at time of snapshot (transaction currency)
LWST_GRD_SLRY	NUMBER		Reserved for future use
HGHST_GRD_SLRY	NUMBER		Reserved for future use
CURRENCY_FK_KEY	NUMBER		Warehouse foreign key to the Currency dimension for the salary transaction currency
CRRNCY_CNVRSN_RATE	NUMBER		Currency conversion rate from the transaction currency to the warehouse currency
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 JOB_FK_KEY
,      PERSON_FK_KEY
,      GRADE_FK_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
,      ASSIGNMENT_START_DATE
,      COMPOSITION_FTE
,      COMPOSITION_HEADCOUNT
,      COMPOSITION_PK
,      COMPOSITION_PK_KEY
,      CREATION_DATE
,      DATE_OF_BIRTH
,      LAST_UPDATE_DATE
,      SNAPSHOT_DATE
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      GEOGRAPHY_FK_KEY
,      AGE_BAND_FK_KEY
,      ASSIGNMENT_FK_KEY
,      POSITION_FK_KEY
,      PERSON_TYPE_FK_KEY
,      SERVICE_BAND_FK_KEY
,      INSTANCE_FK_KEY
,      ORGA_ORGANIZATION_FK_KEY
,      TIME_FK_KEY
,      CRNT_ANNLZED_SLRY
,      CRNT_ANNLZED_SLRY_BC
,      LWST_GRD_SLRY
,      HGHST_GRD_SLRY
,      CURRENCY_FK_KEY
,      CRRNCY_CNVRSN_RATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM HRI.HR_EDW_WRK_CMPSTN_F;

Dependencies

[top of page]

HRI.HR_EDW_WRK_CMPSTN_F does not reference any database object

HRI.HR_EDW_WRK_CMPSTN_F is referenced by following:

APPS: HR_EDW_WRK_CMPSTN_F