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