[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_MVMT_MVMNTS_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_MVMT_MVMNTS_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Movement Type level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Movement Type dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_MVMT_MVMNTS_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | MOVEMENT_PK |
EDW_HR_MVMT_MVMNTS_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | |
GAIN_TYPE_LVL1_FK | VARCHAR2 | (400) | Textual Unique Identifier for the Gain Type 1 Level | |
GAIN_TYPE_LVL1_FK_KEY | NUMBER | Unique Warehouse Identifier for the Gain Type 1 Level | ||
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LOSS_TYPE_LVL1_FK | VARCHAR2 | (400) | Textual Unique Identifier for the Loss Type 1 Level | |
LOSS_TYPE_LVL1_FK_KEY | NUMBER | Unique Warehouse Identifier for the Loss Type 1 Level | ||
MOVEMENT_CMBN_ID | NUMBER | Internal use only | ||
MOVEMENT_DP | VARCHAR2 | (240) | Reserved for future use | |
MOVEMENT_PK | VARCHAR2 | (800) | Textual Unique Identifier for the Movement Type Level | |
NAME | VARCHAR2 | (240) | Movement Type name for the Movement Type Level | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
REC_TYPE_LVL1_FK | VARCHAR2 | (400) | Textual Unique Identifier for the Recruitment Type 1 Level | |
REC_TYPE_LVL1_FK_KEY | NUMBER | Unique Warehouse Identifier for the Recruitment Type 1 Level | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row identifier | |
SEP_TYPE_LVL1_FK | VARCHAR2 | (400) | Textual Unique Identifier for the Separation Type 1 Level | |
SEP_TYPE_LVL1_FK_KEY | NUMBER | Unique Warehouse Identifier for the Separation Type 1 Level | ||
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 COLLECTION_STATUS
, CREATION_DATE
, ERROR_CODE
, GAIN_TYPE_LVL1_FK
, GAIN_TYPE_LVL1_FK_KEY
, INSTANCE
, LAST_UPDATE_DATE
, LOSS_TYPE_LVL1_FK
, LOSS_TYPE_LVL1_FK_KEY
, MOVEMENT_CMBN_ID
, MOVEMENT_DP
, MOVEMENT_PK
, NAME
, OPERATION_CODE
, REC_TYPE_LVL1_FK
, REC_TYPE_LVL1_FK_KEY
, REQUEST_ID
, ROW_ID
, SEP_TYPE_LVL1_FK
, SEP_TYPE_LVL1_FK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM HRI.EDW_HR_MVMT_MVMNTS_LSTG;
HRI.EDW_HR_MVMT_MVMNTS_LSTG does not reference any database object
HRI.EDW_HR_MVMT_MVMNTS_LSTG is referenced by following:
|
|
|