[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_RQVC_REQUISTN_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_RQVC_REQUISTN_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Requisition level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Requisition dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_RQVC_REQUISTN_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUISITION_PK |
EDW_HR_RQVC_REQUISTN_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUISITION_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Requisition Level | |
ALL_FK | VARCHAR2 | (40) | Textual Foreign Key to the All Vacancies Level | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
NAME | VARCHAR2 | (360) | Requisition Name for the Requisition Level | |
REQUISITION_DP | VARCHAR2 | (360) | Reserved for future use | |
BUSINESS_GROUP_ID | NUMBER | Hidden Identifier for the Business Group from the data source | ||
REQUISITION_ID | NUMBER | Hidden Identifier for the Requisition from the data source | ||
START_DATE | DATE | Start date of the Requisition | ||
END_DATE | DATE | End date of the Requisition | ||
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 the All Vacancies Level | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
ROW_ID | ROWID | (10) | Row identifier | |
REQUEST_ID | NUMBER | Identifier used by collection program |
Cut, paste (and edit) the following text to query this object:
SELECT REQUISITION_PK
, ALL_FK
, INSTANCE
, NAME
, REQUISITION_DP
, BUSINESS_GROUP_ID
, REQUISITION_ID
, START_DATE
, END_DATE
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, ALL_FK_KEY
, COLLECTION_STATUS
, OPERATION_CODE
, ERROR_CODE
, ROW_ID
, REQUEST_ID
FROM HRI.EDW_HR_RQVC_REQUISTN_LSTG;
HRI.EDW_HR_RQVC_REQUISTN_LSTG does not reference any database object
HRI.EDW_HR_RQVC_REQUISTN_LSTG is referenced by following:
|
|
|