[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_REC_ACT_M |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_REC_ACT_M |
Subobject Name: | |
Status: | VALID |
This is the Recruitment Activity dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.
This dimension shows the recruitment activity and recruitment activity type associated with an application. A recruitment activity is a specific activity designed to attract potential employees to the Enterprise. An activity type is a broad classification for recruitment activities, for example, advertisements, recruitment fairs, recruitment campaigns.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_REC_ACT_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
RCAC_REC_ACTIVITY_PK
RCAC_REC_ACTIVITY_PK_KEY |
EDW_HR_REC_ACT_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | RCAC_REC_ACTIVITY_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATYP_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
ATYP_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
ATYP_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
ATYP_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_REC_ACTIVITY_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Recruitment Activity Level | |
RCAC_NAME | VARCHAR2 | (360) | Recruitment Activity Name for the Recruitment Activity Level | |
RCAC_EXTERNAL_CONTACT | VARCHAR2 | (80) | Name of External Contact | |
RCAC_INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
RCAC_BUSINESS_GROUP_ID | NUMBER | Hidden Identifier for Business Group from the data source | ||
RCAC_REC_ACTIVITY_ID | NUMBER | Hidden Identifier for the Recruitment Activity from the data source | ||
RCAC_REC_ACTIVITY_COST | NUMBER | Actual cost of the Recruitment Activity | ||
RCAC_REC_ACTIVITY_PLANNED_COST | NUMBER | Budgeted cost of the Recruitment Activity | ||
RCAC_START_DATE | DATE | Start date of the Recruitment Activity | ||
RCAC_END_DATE | DATE | End date of the Recruitment Activity | ||
RCAC_CLOSING_DATE | DATE | Closing date for responses to the Recruitment Activity | ||
RCAC_LAST_UPDATE_DATE | DATE | Internal use only | ||
RCAC_CREATION_DATE | DATE | Internal use only | ||
RCAC_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
ALL_ALL_PK_KEY | NUMBER | Unique Warehouse Identifier for the All Recruitment Activities Level | ||
ALL_NAME | VARCHAR2 | (80) | Name for the All Level | |
ALL_ALL_PK | VARCHAR2 | (40) | Textual Unique Identifier for the All Recruitment Activities Level | |
RCAC_REC_ACTIVITY_PK_KEY | NUMBER | Yes | Unique Warehouse Identifier for the Recruitment Activity Level | |
ATYP_ACTIVITY_TYPE_PK_KEY | NUMBER | Unique Warehouse Identifier for the Activity Type Level | ||
ATYP_ACTIVITY_TYPE_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Activity Type Level | |
ATYP_ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Hidden Code for Activity Type from the data source | |
ATYP_NAME | VARCHAR2 | (120) | Activity Type Name for Activity Type Level | |
ATYP_ACTIVITY_TYPE_DP | VARCHAR2 | (120) | Reserved for future use | |
ATYP_INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
ATYP_LAST_UPDATE_DATE | DATE | Internal use only | ||
ATYP_CREATION_DATE | DATE | Internal use only | ||
ATYP_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
RCAC_REC_ACTIVITY_DP | VARCHAR2 | (360) | Reserved for future use | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ATYP_USER_ATTRIBUTE2
, ATYP_USER_ATTRIBUTE3
, ATYP_USER_ATTRIBUTE4
, ATYP_USER_ATTRIBUTE5
, RCAC_REC_ACTIVITY_PK
, RCAC_NAME
, RCAC_EXTERNAL_CONTACT
, RCAC_INSTANCE
, RCAC_BUSINESS_GROUP_ID
, RCAC_REC_ACTIVITY_ID
, RCAC_REC_ACTIVITY_COST
, RCAC_REC_ACTIVITY_PLANNED_COST
, RCAC_START_DATE
, RCAC_END_DATE
, RCAC_CLOSING_DATE
, RCAC_LAST_UPDATE_DATE
, RCAC_CREATION_DATE
, RCAC_USER_ATTRIBUTE1
, RCAC_USER_ATTRIBUTE2
, RCAC_USER_ATTRIBUTE3
, RCAC_USER_ATTRIBUTE4
, RCAC_USER_ATTRIBUTE5
, ALL_ALL_PK_KEY
, ALL_NAME
, ALL_ALL_PK
, RCAC_REC_ACTIVITY_PK_KEY
, ATYP_ACTIVITY_TYPE_PK_KEY
, ATYP_ACTIVITY_TYPE_PK
, ATYP_ACTIVITY_TYPE_CODE
, ATYP_NAME
, ATYP_ACTIVITY_TYPE_DP
, ATYP_INSTANCE
, ATYP_LAST_UPDATE_DATE
, ATYP_CREATION_DATE
, ATYP_USER_ATTRIBUTE1
, RCAC_REC_ACTIVITY_DP
, CREATION_DATE
, LAST_UPDATE_DATE
FROM HRI.EDW_HR_REC_ACT_M;
HRI.EDW_HR_REC_ACT_M does not reference any database object
HRI.EDW_HR_REC_ACT_M is referenced by following:
|
|
|