DBA Data[Home] [Help] [Dependency Information]

TABLE: HRI.EDW_HR_MVMNT_TYP_M

Object Details
Object Name: EDW_HR_MVMNT_TYP_M
Object Type: TABLE
Owner: HRI
FND Design Data: TableHRI.EDW_HR_MVMNT_TYP_M
Subobject Name:
Status: VALID


This is the Movement Type dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.
Any workforce losses or gains, including internal transfers, are classified as workforce movements. Additionally, workforce movements also include the changes that occur as people move within the recruitment or separation stages (for example, from the offer stage to the accept stage of recruitment, or from the separation notified to separation accepted stage of separation).


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_HR_MVMNT_TYP_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnWMVT_MOVEMENT_TYPE_PK
ColumnWMVT_MOVEMENT_TYPE_PK_KEY
EDW_HR_MVMNT_TYP_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnWMVT_MOVEMENT_TYPE_PK_KEY
Columns
Name Datatype Length Mandatory Comments
SPN3_SEP_TYPE_LVL3_PK_KEY NUMBER

Unique Warehouse Identifier for the Separation Type 3 Level
SPN3_CREATION_DATE DATE

Internal use only
SPN3_INSTANCE VARCHAR2 (40)
Identity of Data Source
SPN3_LAST_UPDATE_DATE DATE

Internal use only
SPN3_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Separation Type from the data source
SPN3_NAME VARCHAR2 (240)
Separation Type 3 name for the Separation Type 3 Level
SPN3_SEP_TYPE_LVL3_DP VARCHAR2 (240)
Reserved for future use
SPN3_SEP_TYPE_LVL3_ID NUMBER

Internal use only
SPN3_SEP_TYPE_LVL3_PK VARCHAR2 (400)
Textual Unique Identifier for the Separation Type 3 Level
SPN3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
SPN3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
SPN3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
SPN3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
SPN3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
SPN2_SEP_TYPE_LVL2_PK_KEY NUMBER

Unique Warehouse Identifier for the Separation Type 2 Level
SPN2_CREATION_DATE DATE

Internal use only
SPN2_INSTANCE VARCHAR2 (40)
Identity of Data Source
SPN2_LAST_UPDATE_DATE DATE

Internal use only
SPN2_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Separation Type from the data source
SPN2_NAME VARCHAR2 (240)
Separation Type 2 name for the Separation Type 2 Level
SPN2_SEP_TYPE_LVL2_DP VARCHAR2 (240)
Reserved for future use
SPN2_SEP_TYPE_LVL2_ID NUMBER

Internal use only
SPN2_SEP_TYPE_LVL2_PK VARCHAR2 (400)
Textual Unique Identifier for the Separation Type 2 Level
SPN2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
SPN2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
SPN2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
SPN2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
SPN2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
SPN1_SEP_TYPE_LVL1_PK_KEY NUMBER

Unique Warehouse Identifier for the Separation Type 1 Level
SPN1_CREATION_DATE DATE

Internal use only
SPN1_INSTANCE VARCHAR2 (40)
Identity of Data Source
SPN1_LAST_UPDATE_DATE DATE

Internal use only
SPN1_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Separation Type from the data source
SPN1_NAME VARCHAR2 (240)
Separation Type 1 name for the Separation Type 1 Level
SPN1_SEP_TYPE_LVL1_DP VARCHAR2 (240)
Reserved for future use
SPN1_SEP_TYPE_LVL1_ID NUMBER

Internal use only
SPN1_SEP_TYPE_LVL1_PK VARCHAR2 (400)
Textual Unique Identifier for the Separation Type 1 Level
SPN1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
SPN1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
SPN1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
SPN1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
SPN1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
ALL_ALL_PK_KEY NUMBER

Unique Warehouse Identifier for the All Movement Types Level
ALL_ALL_PK VARCHAR2 (40)
Textual Unique Identifier for the All Movement Types Level
ALL_CREATION_DATE DATE

Internal use only
ALL_LAST_UPDATE_DATE DATE

Internal use only
ALL_NAME VARCHAR2 (80)
Name for All Level
GNT3_GAIN_TYPE_LVL3_PK_KEY NUMBER

Unique Warehouse Identifier for the Gain Type 3 Level
GNT3_CREATION_DATE DATE

Internal use only
GNT3_GAIN_TYPE_LVL3_DP VARCHAR2 (240)
Reserved for future use
GNT3_GAIN_TYPE_LVL3_ID NUMBER

Internal use only
GNT3_GAIN_TYPE_LVL3_PK VARCHAR2 (400)
Textual Unique Identifier for the Gain Type 3 Level
GNT3_INSTANCE VARCHAR2 (40)
Identity of Data Source
GNT3_LAST_UPDATE_DATE DATE

Internal use only
GNT3_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Gain Type from the data source
GNT3_NAME VARCHAR2 (240)
Gain Type 3 name for the Gain Type 3 Level
GNT3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
GNT3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
GNT3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
GNT3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
GNT3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
GNT2_GAIN_TYPE_LVL2_PK_KEY NUMBER

Unique Warehouse Identifier for the Gain Type 2 Level
GNT2_CREATION_DATE DATE

Internal use only
GNT2_GAIN_TYPE_LVL2_DP VARCHAR2 (240)
Reserved for future use
GNT2_GAIN_TYPE_LVL2_ID NUMBER

Internal use only
GNT2_GAIN_TYPE_LVL2_PK VARCHAR2 (400)
Textual Unique Identifier for the Gain Type 2 Level
GNT2_INSTANCE VARCHAR2 (40)
Identity of Data Source
GNT2_LAST_UPDATE_DATE DATE

Internal use only
GNT2_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Gain Type from the data source
GNT2_NAME VARCHAR2 (240)
Gain Type 2 name for the Gain Type 2 Level
GNT2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
GNT2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
GNT2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
GNT2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
GNT2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
GNT1_GAIN_TYPE_LVL1_PK_KEY NUMBER

Unique Warehouse Identifier for the Gain Type 1 Level
GNT1_CREATION_DATE DATE

Internal use only
GNT1_GAIN_TYPE_LVL1_DP VARCHAR2 (240)
Reserved for future use
GNT1_GAIN_TYPE_LVL1_ID NUMBER

Internal use only
GNT1_GAIN_TYPE_LVL1_PK VARCHAR2 (400)
Textual Unique Identifier for the Gain Type 1 Level
GNT1_INSTANCE VARCHAR2 (40)
Identity of Data Source
GNT1_LAST_UPDATE_DATE DATE

Internal use only
GNT1_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Gain Type from the data source
GNT1_NAME VARCHAR2 (240)
Gain Type 1 name for the Gain Type 1 Level
GNT1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
GNT1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
GNT1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
GNT1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
GNT1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
LSS3_LOSS_TYPE_LVL3_PK_KEY NUMBER

Unique Warehouse Identifier for the Loss Type 3 Level
LSS3_CREATION_DATE DATE

Internal use only
LSS3_INSTANCE VARCHAR2 (40)
Identity of Data Source
LSS3_LAST_UPDATE_DATE DATE

Internal use only
LSS3_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Loss Type from the data source
LSS3_LOSS_TYPE_LVL3_DP VARCHAR2 (240)
Reserved for future use
LSS3_LOSS_TYPE_LVL3_ID NUMBER

Internal use only
LSS3_LOSS_TYPE_LVL3_PK VARCHAR2 (400)
Textual Unique Identifier for the Loss Type 3 Level
LSS3_NAME VARCHAR2 (240)
Loss Type 3 name for the Loss Type 3 Level
LSS3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
LSS3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
LSS3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
LSS3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
LSS3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
LSS2_LOSS_TYPE_LVL2_PK_KEY NUMBER

Unique Warehouse Identifier for the Loss Type 2 Level
LSS2_CREATION_DATE DATE

Internal use only
LSS2_INSTANCE VARCHAR2 (40)
Identity of Data Source
LSS2_LAST_UPDATE_DATE DATE

Internal use only
LSS2_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Loss Type from the data source
LSS2_LOSS_TYPE_LVL2_DP VARCHAR2 (240)
Reserved for future use
LSS2_LOSS_TYPE_LVL2_ID NUMBER

Internal use only
LSS2_LOSS_TYPE_LVL2_PK VARCHAR2 (400)
Textual Unique Identifier for the Loss Type 2 Level
LSS2_NAME VARCHAR2 (240)
Loss Type 2 name for the Loss Type 2 Level
LSS2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
LSS2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
LSS2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
LSS2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
LSS2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
LSS1_LOSS_TYPE_LVL1_PK_KEY NUMBER

Unique Warehouse Identifier for the Loss Type 1 Level
LSS1_CREATION_DATE DATE

Internal use only
LSS1_INSTANCE VARCHAR2 (40)
Identity of Data Source
LSS1_LAST_UPDATE_DATE DATE

Internal use only
LSS1_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Loss Type from the data source
LSS1_LOSS_TYPE_LVL1_DP VARCHAR2 (240)
Reserved for future use
LSS1_LOSS_TYPE_LVL1_ID NUMBER

Internal use only
LSS1_LOSS_TYPE_LVL1_PK VARCHAR2 (400)
Textual Unique Identifier for the Loss Type 1 Level
LSS1_NAME VARCHAR2 (240)
Loss Type 1 name for the Loss Type 1 Level
LSS1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
LSS1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
LSS1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
LSS1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
LSS1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
RCR3_REC_TYPE_LVL3_PK_KEY NUMBER

Unique Warehouse Identifier for the Recruitment Type 3 Level
RCR3_CREATION_DATE DATE

Internal use only
RCR3_INSTANCE VARCHAR2 (40)
Identity of Data Source
RCR3_LAST_UPDATE_DATE DATE

Internal use only
RCR3_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Recruitment Type from the data source
RCR3_NAME VARCHAR2 (240)
Recruitment Type 3 name for the Recruitment Type 3 Level
RCR3_REC_TYPE_LVL3_DP VARCHAR2 (240)
Reserved for future use
RCR3_REC_TYPE_LVL3_ID NUMBER

Internal use only
RCR3_REC_TYPE_LVL3_PK VARCHAR2 (400)
Textual Unique Identifier for the Recruitment Type 3 Level
RCR3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
RCR3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
RCR3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
RCR3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
RCR3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
RCR2_REC_TYPE_LVL2_PK_KEY NUMBER

Unique Warehouse Identifier for the Recruitment Type 2 Level
RCR2_CREATION_DATE DATE

Internal use only
RCR2_INSTANCE VARCHAR2 (40)
Identity of Data Source
RCR2_LAST_UPDATE_DATE DATE

Internal use only
RCR2_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Recruitment Type from the data source
RCR2_NAME VARCHAR2 (240)
Recruitment Type 2 name for the Recruitment Type 2 Level
RCR2_REC_TYPE_LVL2_DP VARCHAR2 (240)
Reserved for future use
RCR2_REC_TYPE_LVL2_ID NUMBER

Internal use only
RCR2_REC_TYPE_LVL2_PK VARCHAR2 (400)
Textual Unique Identifier for the Recruitment Type 2 Level
RCR2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
RCR2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
RCR2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
RCR2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
RCR2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
RCR1_REC_TYPE_LVL1_PK_KEY NUMBER

Unique Warehouse Identifier for the Recruitment Type 1 Level
RCR1_CREATION_DATE DATE

Internal use only
RCR1_INSTANCE VARCHAR2 (40)
Identity of Data Source
RCR1_LAST_UPDATE_DATE DATE

Internal use only
RCR1_LOOKUP_CODE VARCHAR2 (30)
Hidden Identifier for the Recruitment Type from the data source
RCR1_NAME VARCHAR2 (240)
Recruitment Type 1 name for the Recruitment Type 1 Level
RCR1_REC_TYPE_LVL1_DP VARCHAR2 (240)
Reserved for future use
RCR1_REC_TYPE_LVL1_ID NUMBER

Internal use only
RCR1_REC_TYPE_LVL1_PK VARCHAR2 (400)
Textual Unique Identifier for the Recruitment Type 1 Level
RCR1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
RCR1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
RCR1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
RCR1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
RCR1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
WMVT_MOVEMENT_TYPE_PK_KEY NUMBER
Yes Unique Warehouse Identifier for the Movement Type Level
WMVT_CREATION_DATE DATE

Internal use only
WMVT_INSTANCE VARCHAR2 (40)
Identity of Data Source
WMVT_LAST_UPDATE_DATE DATE

Internal use only
WMVT_MOVEMENT_CMBN_ID NUMBER

Internal use only
WMVT_MOVEMENT_DP VARCHAR2 (240)
Reserved for future use
WMVT_MOVEMENT_TYPE_PK VARCHAR2 (800)
Textual Unique Identifier for the Movement Type Level
WMVT_NAME VARCHAR2 (240)
Movement Type name for the Movement Type Level
WMVT_USER_ATTRIBUTE1 VARCHAR2 (240)
User Defined Attribute
WMVT_USER_ATTRIBUTE2 VARCHAR2 (240)
User Defined Attribute
WMVT_USER_ATTRIBUTE3 VARCHAR2 (240)
User Defined Attribute
WMVT_USER_ATTRIBUTE4 VARCHAR2 (240)
User Defined Attribute
WMVT_USER_ATTRIBUTE5 VARCHAR2 (240)
User Defined Attribute
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPN3_SEP_TYPE_LVL3_PK_KEY
,      SPN3_CREATION_DATE
,      SPN3_INSTANCE
,      SPN3_LAST_UPDATE_DATE
,      SPN3_LOOKUP_CODE
,      SPN3_NAME
,      SPN3_SEP_TYPE_LVL3_DP
,      SPN3_SEP_TYPE_LVL3_ID
,      SPN3_SEP_TYPE_LVL3_PK
,      SPN3_USER_ATTRIBUTE1
,      SPN3_USER_ATTRIBUTE2
,      SPN3_USER_ATTRIBUTE3
,      SPN3_USER_ATTRIBUTE4
,      SPN3_USER_ATTRIBUTE5
,      SPN2_SEP_TYPE_LVL2_PK_KEY
,      SPN2_CREATION_DATE
,      SPN2_INSTANCE
,      SPN2_LAST_UPDATE_DATE
,      SPN2_LOOKUP_CODE
,      SPN2_NAME
,      SPN2_SEP_TYPE_LVL2_DP
,      SPN2_SEP_TYPE_LVL2_ID
,      SPN2_SEP_TYPE_LVL2_PK
,      SPN2_USER_ATTRIBUTE1
,      SPN2_USER_ATTRIBUTE2
,      SPN2_USER_ATTRIBUTE3
,      SPN2_USER_ATTRIBUTE4
,      SPN2_USER_ATTRIBUTE5
,      SPN1_SEP_TYPE_LVL1_PK_KEY
,      SPN1_CREATION_DATE
,      SPN1_INSTANCE
,      SPN1_LAST_UPDATE_DATE
,      SPN1_LOOKUP_CODE
,      SPN1_NAME
,      SPN1_SEP_TYPE_LVL1_DP
,      SPN1_SEP_TYPE_LVL1_ID
,      SPN1_SEP_TYPE_LVL1_PK
,      SPN1_USER_ATTRIBUTE1
,      SPN1_USER_ATTRIBUTE2
,      SPN1_USER_ATTRIBUTE3
,      SPN1_USER_ATTRIBUTE4
,      SPN1_USER_ATTRIBUTE5
,      ALL_ALL_PK_KEY
,      ALL_ALL_PK
,      ALL_CREATION_DATE
,      ALL_LAST_UPDATE_DATE
,      ALL_NAME
,      GNT3_GAIN_TYPE_LVL3_PK_KEY
,      GNT3_CREATION_DATE
,      GNT3_GAIN_TYPE_LVL3_DP
,      GNT3_GAIN_TYPE_LVL3_ID
,      GNT3_GAIN_TYPE_LVL3_PK
,      GNT3_INSTANCE
,      GNT3_LAST_UPDATE_DATE
,      GNT3_LOOKUP_CODE
,      GNT3_NAME
,      GNT3_USER_ATTRIBUTE1
,      GNT3_USER_ATTRIBUTE2
,      GNT3_USER_ATTRIBUTE3
,      GNT3_USER_ATTRIBUTE4
,      GNT3_USER_ATTRIBUTE5
,      GNT2_GAIN_TYPE_LVL2_PK_KEY
,      GNT2_CREATION_DATE
,      GNT2_GAIN_TYPE_LVL2_DP
,      GNT2_GAIN_TYPE_LVL2_ID
,      GNT2_GAIN_TYPE_LVL2_PK
,      GNT2_INSTANCE
,      GNT2_LAST_UPDATE_DATE
,      GNT2_LOOKUP_CODE
,      GNT2_NAME
,      GNT2_USER_ATTRIBUTE1
,      GNT2_USER_ATTRIBUTE2
,      GNT2_USER_ATTRIBUTE3
,      GNT2_USER_ATTRIBUTE4
,      GNT2_USER_ATTRIBUTE5
,      GNT1_GAIN_TYPE_LVL1_PK_KEY
,      GNT1_CREATION_DATE
,      GNT1_GAIN_TYPE_LVL1_DP
,      GNT1_GAIN_TYPE_LVL1_ID
,      GNT1_GAIN_TYPE_LVL1_PK
,      GNT1_INSTANCE
,      GNT1_LAST_UPDATE_DATE
,      GNT1_LOOKUP_CODE
,      GNT1_NAME
,      GNT1_USER_ATTRIBUTE1
,      GNT1_USER_ATTRIBUTE2
,      GNT1_USER_ATTRIBUTE3
,      GNT1_USER_ATTRIBUTE4
,      GNT1_USER_ATTRIBUTE5
,      LSS3_LOSS_TYPE_LVL3_PK_KEY
,      LSS3_CREATION_DATE
,      LSS3_INSTANCE
,      LSS3_LAST_UPDATE_DATE
,      LSS3_LOOKUP_CODE
,      LSS3_LOSS_TYPE_LVL3_DP
,      LSS3_LOSS_TYPE_LVL3_ID
,      LSS3_LOSS_TYPE_LVL3_PK
,      LSS3_NAME
,      LSS3_USER_ATTRIBUTE1
,      LSS3_USER_ATTRIBUTE2
,      LSS3_USER_ATTRIBUTE3
,      LSS3_USER_ATTRIBUTE4
,      LSS3_USER_ATTRIBUTE5
,      LSS2_LOSS_TYPE_LVL2_PK_KEY
,      LSS2_CREATION_DATE
,      LSS2_INSTANCE
,      LSS2_LAST_UPDATE_DATE
,      LSS2_LOOKUP_CODE
,      LSS2_LOSS_TYPE_LVL2_DP
,      LSS2_LOSS_TYPE_LVL2_ID
,      LSS2_LOSS_TYPE_LVL2_PK
,      LSS2_NAME
,      LSS2_USER_ATTRIBUTE1
,      LSS2_USER_ATTRIBUTE2
,      LSS2_USER_ATTRIBUTE3
,      LSS2_USER_ATTRIBUTE4
,      LSS2_USER_ATTRIBUTE5
,      LSS1_LOSS_TYPE_LVL1_PK_KEY
,      LSS1_CREATION_DATE
,      LSS1_INSTANCE
,      LSS1_LAST_UPDATE_DATE
,      LSS1_LOOKUP_CODE
,      LSS1_LOSS_TYPE_LVL1_DP
,      LSS1_LOSS_TYPE_LVL1_ID
,      LSS1_LOSS_TYPE_LVL1_PK
,      LSS1_NAME
,      LSS1_USER_ATTRIBUTE1
,      LSS1_USER_ATTRIBUTE2
,      LSS1_USER_ATTRIBUTE3
,      LSS1_USER_ATTRIBUTE4
,      LSS1_USER_ATTRIBUTE5
,      RCR3_REC_TYPE_LVL3_PK_KEY
,      RCR3_CREATION_DATE
,      RCR3_INSTANCE
,      RCR3_LAST_UPDATE_DATE
,      RCR3_LOOKUP_CODE
,      RCR3_NAME
,      RCR3_REC_TYPE_LVL3_DP
,      RCR3_REC_TYPE_LVL3_ID
,      RCR3_REC_TYPE_LVL3_PK
,      RCR3_USER_ATTRIBUTE1
,      RCR3_USER_ATTRIBUTE2
,      RCR3_USER_ATTRIBUTE3
,      RCR3_USER_ATTRIBUTE4
,      RCR3_USER_ATTRIBUTE5
,      RCR2_REC_TYPE_LVL2_PK_KEY
,      RCR2_CREATION_DATE
,      RCR2_INSTANCE
,      RCR2_LAST_UPDATE_DATE
,      RCR2_LOOKUP_CODE
,      RCR2_NAME
,      RCR2_REC_TYPE_LVL2_DP
,      RCR2_REC_TYPE_LVL2_ID
,      RCR2_REC_TYPE_LVL2_PK
,      RCR2_USER_ATTRIBUTE1
,      RCR2_USER_ATTRIBUTE2
,      RCR2_USER_ATTRIBUTE3
,      RCR2_USER_ATTRIBUTE4
,      RCR2_USER_ATTRIBUTE5
,      RCR1_REC_TYPE_LVL1_PK_KEY
,      RCR1_CREATION_DATE
,      RCR1_INSTANCE
,      RCR1_LAST_UPDATE_DATE
,      RCR1_LOOKUP_CODE
,      RCR1_NAME
,      RCR1_REC_TYPE_LVL1_DP
,      RCR1_REC_TYPE_LVL1_ID
,      RCR1_REC_TYPE_LVL1_PK
,      RCR1_USER_ATTRIBUTE1
,      RCR1_USER_ATTRIBUTE2
,      RCR1_USER_ATTRIBUTE3
,      RCR1_USER_ATTRIBUTE4
,      RCR1_USER_ATTRIBUTE5
,      WMVT_MOVEMENT_TYPE_PK_KEY
,      WMVT_CREATION_DATE
,      WMVT_INSTANCE
,      WMVT_LAST_UPDATE_DATE
,      WMVT_MOVEMENT_CMBN_ID
,      WMVT_MOVEMENT_DP
,      WMVT_MOVEMENT_TYPE_PK
,      WMVT_NAME
,      WMVT_USER_ATTRIBUTE1
,      WMVT_USER_ATTRIBUTE2
,      WMVT_USER_ATTRIBUTE3
,      WMVT_USER_ATTRIBUTE4
,      WMVT_USER_ATTRIBUTE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM HRI.EDW_HR_MVMNT_TYP_M;

Dependencies

[top of page]

HRI.EDW_HR_MVMNT_TYP_M does not reference any database object

HRI.EDW_HR_MVMNT_TYP_M is referenced by following:

SchemaAPPS
SynonymEDW_HR_MVMNT_TYP_M