[Home] [Help] [Dependency Information]
Object Name: | EDW_ORGA_LEG_ENTITY_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | BIS.EDW_ORGA_LEG_ENTITY_LSTG
HRI.EDW_ORGA_LEG_ENTITY_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Legal Entity level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Legal Entity dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ORGA_LEG_ENTITY_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | LEGAL_ENTITY_PK |
EDW_ORGA_LEG_ENTITY_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_FK | VARCHAR2 | (80) | Textual Foreign Key to the Business Group Level | |
BUSINESS_GROUP_FK_KEY | NUMBER | Warehouse Foreign Key to the Business Group Level | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
CREATION_DATE | DATE | Standard who column | ||
DATE_FROM | DATE | Start date of legal entity | ||
DATE_TO | DATE | End date of legal entity | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
INT_EXT_FLAG | VARCHAR2 | (80) | Whether the legal entity is an internal or external organization | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LEGAL_ENTITY_DP | VARCHAR2 | (500) | Reserved for future use | |
LEGAL_ENTITY_PK | VARCHAR2 | (240) | Textual Unique Identifier for the Legal Entity Level | |
LEVEL_NAME | VARCHAR2 | (15) | Internal use only | |
NAME | VARCHAR2 | (500) | Legal Entity name for the Legal Entity Level | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
ORG_CODE | VARCHAR2 | (20) | Hidden code for the legal entity organization type from the data source | |
ORG_TYPE | VARCHAR2 | (80) | Legal entity organization type | |
PRIMARY_CST_MTHD | VARCHAR2 | (120) | Primary cost method of legal entity | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row identifier | |
SET_OF_BOOKS | VARCHAR2 | (80) | Accounting books name | |
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 | |
LEGAL_ENTITY_ID | NUMBER | Hidden identifier for the Legal Entity from the source database |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_FK
, BUSINESS_GROUP_FK_KEY
, COLLECTION_STATUS
, CREATION_DATE
, DATE_FROM
, DATE_TO
, ERROR_CODE
, INSTANCE
, INT_EXT_FLAG
, LAST_UPDATE_DATE
, LEGAL_ENTITY_DP
, LEGAL_ENTITY_PK
, LEVEL_NAME
, NAME
, OPERATION_CODE
, ORG_CODE
, ORG_TYPE
, PRIMARY_CST_MTHD
, REQUEST_ID
, ROW_ID
, SET_OF_BOOKS
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LEGAL_ENTITY_ID
FROM HRI.EDW_ORGA_LEG_ENTITY_LSTG;
HRI.EDW_ORGA_LEG_ENTITY_LSTG does not reference any database object
HRI.EDW_ORGA_LEG_ENTITY_LSTG is referenced by following:
|
|
|