[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_ASCH_ASG_CHNG_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_ASCH_ASG_CHNG_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Workforce Change level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Workforce Change dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_ASCH_ASG_CHNG_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ASG_CHANGE_PK |
EDW_HR_ASCH_ASG_CHNG_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Assignment Changes Level | ||
OTHER_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether any changes to the assignment not indicated by other change flags occurred | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
ROW_ID | ROWID | (10) | Row identifier | |
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 | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
ASG_CHANGE_CODE | VARCHAR2 | (30) | Hidden lookup code for the assignment change from the data source | |
GEOG_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether a change in geography occurred | |
GRD_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether a change in grade occurred | |
POS_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether a change in position occurred | |
JOB_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether a change in job occurred | |
ORG_CHANGE_FLAG | VARCHAR2 | (80) | Flag indicating whether a change of organization occurred | |
CHANGE_STATUS | VARCHAR2 | (80) | Flag indicating whether a change in the assignment occurred | |
NAME | VARCHAR2 | (80) | Assignment Change Name for the Assignment Change Level | |
ASG_CHANGE_DP | VARCHAR2 | (80) | Reserved for future use | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
ALL_FK | VARCHAR2 | (40) | Textual Foreign Key to the All Assignment Changes Level | |
ASG_CHANGE_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Assignment Change Level | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, ALL_FK_KEY
, OTHER_CHANGE_FLAG
, ERROR_CODE
, ROW_ID
, COLLECTION_STATUS
, OPERATION_CODE
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, ASG_CHANGE_CODE
, GEOG_CHANGE_FLAG
, GRD_CHANGE_FLAG
, POS_CHANGE_FLAG
, JOB_CHANGE_FLAG
, ORG_CHANGE_FLAG
, CHANGE_STATUS
, NAME
, ASG_CHANGE_DP
, INSTANCE
, ALL_FK
, ASG_CHANGE_PK
, LAST_UPDATE_DATE
, CREATION_DATE
FROM HRI.EDW_HR_ASCH_ASG_CHNG_LSTG;
HRI.EDW_HR_ASCH_ASG_CHNG_LSTG does not reference any database object
HRI.EDW_HR_ASCH_ASG_CHNG_LSTG is referenced by following:
|
|
|