[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_RACT_ACT_TYPE_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_RACT_ACT_TYPE_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Activity Type level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Activity Type dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_RACT_ACT_TYPE_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ACTIVITY_TYPE_PK |
EDW_HR_RACT_ACT_TYPE_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_TYPE_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Activity Type Level | |
ALL_FK | VARCHAR2 | (40) | Textual Foreign Key to All Recruitment Activities Level | |
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Hidden Code for Activity Type from the data source | |
NAME | VARCHAR2 | (120) | Activity Type Name for Activity Type Level | |
ACTIVITY_TYPE_DP | VARCHAR2 | (120) | Reserved for future use | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
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 | |
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to All Recruitment Activities Level | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row identifier | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_TYPE_PK
, ALL_FK
, ACTIVITY_TYPE_CODE
, NAME
, ACTIVITY_TYPE_DP
, INSTANCE
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, ALL_FK_KEY
, ERROR_CODE
, REQUEST_ID
, ROW_ID
, OPERATION_CODE
, COLLECTION_STATUS
FROM HRI.EDW_HR_RACT_ACT_TYPE_LSTG;
HRI.EDW_HR_RACT_ACT_TYPE_LSTG does not reference any database object
HRI.EDW_HR_RACT_ACT_TYPE_LSTG is referenced by following:
|
|
|