[Home] [Help] [Dependency Information]
Object Name: | EDW_ORGA_ORG_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | BIS.EDW_ORGA_ORG_LSTG
HRI.EDW_ORGA_ORG_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Organization level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Organization dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ORGA_ORG_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ORGANIZATION_PK |
EDW_ORGA_ORG_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP | VARCHAR2 | (240) | Business group containing the organization | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
CREATION_DATE | DATE | Standard who column | ||
DATE_FROM | DATE | Start date of the organization | ||
DATE_TO | DATE | End date of the organization | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LEVEL_NAME | VARCHAR2 | (15) | Internal use only | |
NAME | VARCHAR2 | (500) | Organization name for the Organization level | |
OPERATING_UNIT_FK | VARCHAR2 | (240) | Textual Foreign Key to the Operating Unit Level | |
OPERATING_UNIT_FK_KEY | NUMBER | Textual Foreign Key to the Operating Unit Level | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
ORGANIZATION_DP | VARCHAR2 | (500) | Reserved for future use | |
ORGANIZATION_PK | VARCHAR2 | (120) | Textual Unique Identifier for the Organization Level | |
ORG_CODE | VARCHAR2 | (20) | Hidden code for the organization type from the data source | |
ORG_INT_EXT_FLAG | VARCHAR2 | (80) | Whether the organization is internal or external | |
ORG_PRIM_CST_MTHD | VARCHAR2 | (120) | Primary cost method for the organization | |
ORG_TYPE | VARCHAR2 | (80) | Organization type | |
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 | |
ORGANIZATION_ID | NUMBER | Hidden Identifier for the Organization from the data source | ||
ORG_CAT1 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT10 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT11 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT12 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT13 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT14 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT15 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT2 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT3 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT4 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT5 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT6 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT7 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT8 | VARCHAR2 | (80) | Reserved for future use | |
ORG_CAT9 | VARCHAR2 | (80) | Reserved for future use | |
ORG_TREE1_LVL1_FK | VARCHAR2 | (80) | Internal use only | |
ORG_TREE1_LVL1_FK_KEY | NUMBER | Internal use only | ||
PERSON_MANAGER_ID | NUMBER | Hidden Identifier for the cost centre manager from the data source | ||
PERSON_MANAGER_FK | VARCHAR2 | (400) | Textual Foreign Key to the Person Dimension | |
PERSON_MANAGER_FK_KEY | NUMBER | Warehouse Foreign Key to the Person Dimension |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP
, COLLECTION_STATUS
, CREATION_DATE
, DATE_FROM
, DATE_TO
, ERROR_CODE
, INSTANCE
, LAST_UPDATE_DATE
, LEVEL_NAME
, NAME
, OPERATING_UNIT_FK
, OPERATING_UNIT_FK_KEY
, OPERATION_CODE
, ORGANIZATION_DP
, ORGANIZATION_PK
, ORG_CODE
, ORG_INT_EXT_FLAG
, ORG_PRIM_CST_MTHD
, ORG_TYPE
, REQUEST_ID
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, ORGANIZATION_ID
, ORG_CAT1
, ORG_CAT10
, ORG_CAT11
, ORG_CAT12
, ORG_CAT13
, ORG_CAT14
, ORG_CAT15
, ORG_CAT2
, ORG_CAT3
, ORG_CAT4
, ORG_CAT5
, ORG_CAT6
, ORG_CAT7
, ORG_CAT8
, ORG_CAT9
, ORG_TREE1_LVL1_FK
, ORG_TREE1_LVL1_FK_KEY
, PERSON_MANAGER_ID
, PERSON_MANAGER_FK
, PERSON_MANAGER_FK_KEY
FROM HRI.EDW_ORGA_ORG_LSTG;
HRI.EDW_ORGA_ORG_LSTG does not reference any database object
HRI.EDW_ORGA_ORG_LSTG is referenced by following:
|
|
|