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

TABLE: HRI.HR_EDW_WRK_CMPSTN_FSTG

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


This is the staging table for the Workforce Composition fact. Data from multiple transactional 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_CMPSTN_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COMPOSITION_PK VARCHAR2 (400)
Textual unique identifier for the Workforce Composition fact
COMPOSITION_PK_KEY NUMBER

Unique warehouse identifier for the Workforce Composition 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
SNAPSHOT_DATE DATE

Date of snapshot
ASSIGNMENT_START_DATE DATE

Start date of the assignment at the snapshot date
DATE_OF_BIRTH DATE

Date of birth
LAST_UPDATE_DATE DATE

Standard who column
CREATION_DATE DATE

Standard who column
COMPOSITION_HEADCOUNT NUMBER

Headcount value of the assignment at the time of the snapshot
COMPOSITION_FTE NUMBER

Full Time Equivalent value of the assignment at the time of the snapshot
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
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
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_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
TIME_FK VARCHAR2 (400)
Textual foreign key to the dimension
TIME_FK_KEY NUMBER

Warehouse foreign key to the Time dimension for the snapshot date
ORGANIZATION_FK VARCHAR2 (400)
Textual foreign key to the dimension
ORGANIZATION_FK_KEY NUMBER

Warehouse foreign key to the Organization dimension
JOB_FK VARCHAR2 (400)
Textual foreign key to the dimension
JOB_FK_KEY NUMBER

Warehouse foreign key to the Job dimension
PERSON_FK VARCHAR2 (400)
Textual foreign key to the dimension
PERSON_FK_KEY NUMBER

Warehouse foreign key to the Person dimension
GEOGRAPHY_FK VARCHAR2 (400)
Textual foreign key to the dimension
GEOGRAPHY_FK_KEY NUMBER

Warehouse foreign key to the Geography dimension
ASSIGNMENT_FK VARCHAR2 (400)
Textual foreign key to the dimension
ASSIGNMENT_FK_KEY NUMBER

Warehouse foreign key to the Assignment dimension
POSITION_FK VARCHAR2 (400)
Textual foreign key to the dimension
POSITION_FK_KEY NUMBER

Warehouse foreign key to the Position dimension
AGE_BAND_FK VARCHAR2 (400)
Textual foreign key to the 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
SERVICE_BAND_FK VARCHAR2 (400)
Textual foreign key to the dimension
SERVICE_BAND_FK_KEY NUMBER

Warehouse foreign key to the Service Band dimension
PERSON_TYPE_FK VARCHAR2 (4000)
Textual foreign key to the dimension
PERSON_TYPE_FK_KEY NUMBER

Warehouse foreign key to the Person Type dimension
INSTANCE_FK VARCHAR2 (400)
Textual foreign key to the dimension
INSTANCE_FK_KEY NUMBER

Warehouse foreign key to the Instance dimension
GRADE_FK VARCHAR2 (400)
Textual foreign key to the dimension
GRADE_FK_KEY NUMBER

Warehouse foreign key to the Grade dimension
ROW_ID ROWID (10)
Row identifier
REQUEST_ID VARCHAR2 (20)
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
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
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
CURRENCY_FK_KEY NUMBER

Warehouse foreign key to the Currency dimension for the salary transaction currency
CURRENCY_FK VARCHAR2 (400)
Textual foreign key to the dimension
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 COMPOSITION_PK
,      COMPOSITION_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
,      SNAPSHOT_DATE
,      ASSIGNMENT_START_DATE
,      DATE_OF_BIRTH
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      COMPOSITION_HEADCOUNT
,      COMPOSITION_FTE
,      CRNT_ANNLZED_SLRY
,      CRNT_ANNLZED_SLRY_BC
,      LWST_GRD_SLRY
,      HGHST_GRD_SLRY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      TIME_FK
,      TIME_FK_KEY
,      ORGANIZATION_FK
,      ORGANIZATION_FK_KEY
,      JOB_FK
,      JOB_FK_KEY
,      PERSON_FK
,      PERSON_FK_KEY
,      GEOGRAPHY_FK
,      GEOGRAPHY_FK_KEY
,      ASSIGNMENT_FK
,      ASSIGNMENT_FK_KEY
,      POSITION_FK
,      POSITION_FK_KEY
,      AGE_BAND_FK
,      AGE_BAND_FK_KEY
,      SERVICE_BAND_FK
,      SERVICE_BAND_FK_KEY
,      PERSON_TYPE_FK
,      PERSON_TYPE_FK_KEY
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      GRADE_FK
,      GRADE_FK_KEY
,      ROW_ID
,      REQUEST_ID
,      ERROR_CODE
,      COLLECTION_STATUS
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      OPERATION_CODE
,      CURRENCY_FK_KEY
,      CURRENCY_FK
,      CRRNCY_CNVRSN_RATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM HRI.HR_EDW_WRK_CMPSTN_FSTG;

Dependencies

[top of page]

HRI.HR_EDW_WRK_CMPSTN_FSTG does not reference any database object

HRI.HR_EDW_WRK_CMPSTN_FSTG is referenced by following:

SchemaAPPS
SynonymHR_EDW_WRK_CMPSTN_FSTG