[Home] [Help] [Dependency Information]
Object Name: | EDW_ORGA_ORG_LTC |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | BIS.EDW_ORGA_ORG_LTC
HRI.EDW_ORGA_ORG_LTC |
Subobject Name: | |
Status: | VALID |
This is the level table for the Organization level of the Internal Organization dimension. This stores all the organizations within the Enterprise.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ORGA_ORG_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | ORGANIZATION_PK_KEY |
EDW_ORGA_ORG_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_PK
ORGANIZATION_PK_KEY |
EDW_ORGA_ORG_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | OPERATING_UNIT_FK_KEY |
EDW_ORGA_ORG_LTC_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ORG_TREE1_LVL1_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP | VARCHAR2 | (240) | Business group containing the organization | |
CREATION_DATE | DATE | Standard who column | ||
DATE_FROM | DATE | Start date of the organization | ||
DATE_TO | DATE | End date of the organization | ||
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 | ||
ORGANIZATION_DP | VARCHAR2 | (500) | Reserved for future use | |
ORGANIZATION_PK | VARCHAR2 | (120) | Textual Unique Identifier for the Organization Level | |
ORGANIZATION_PK_KEY | NUMBER | Unique Warehouse 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 | |
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 | |
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 | ||
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 | |
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
, CREATION_DATE
, DATE_FROM
, DATE_TO
, INSTANCE
, LAST_UPDATE_DATE
, LEVEL_NAME
, NAME
, OPERATING_UNIT_FK
, OPERATING_UNIT_FK_KEY
, ORGANIZATION_DP
, ORGANIZATION_PK
, ORGANIZATION_PK_KEY
, ORG_CODE
, ORG_INT_EXT_FLAG
, ORG_PRIM_CST_MTHD
, ORG_TYPE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, ORG_CAT8
, ORG_CAT9
, ORG_TREE1_LVL1_FK
, ORG_TREE1_LVL1_FK_KEY
, 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
, PERSON_MANAGER_ID
, PERSON_MANAGER_FK
, PERSON_MANAGER_FK_KEY
FROM HRI.EDW_ORGA_ORG_LTC;
HRI.EDW_ORGA_ORG_LTC does not reference any database object
HRI.EDW_ORGA_ORG_LTC is referenced by following:
|
|
|