[Home] [Help] [Dependency Information]
Object Name: | EDW_SIC_CODE_M |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_SIC_CODE_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Standard Industry Code dimension. It contains records for the lowest level of the Standard Industry Code dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_SIC_CODE_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
SIC_SIC_CODE_PK
SIC_SIC_CODE_PK_KEY |
EDW_SIC_CODE_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SIC_SIC_CODE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIC_SIC_CODE_PK_KEY | NUMBER | Yes | System generated unique identifier to the standard industry classification code (SIC) | |
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier to the top level of the standard industry classification code (SIC) dimension | ||
SIC_SIC_CODE_PK | VARCHAR2 | (40) | Unique identifier to the standard industry classification code (SIC) | |
SIC_SIC_CODE_PK_ROWID | ROWID | (10) | Row identifier to the unique identifier of the standard industry classification code (SIC) | |
SIC_SIC_CODE_DP | VARCHAR2 | (240) | Unique standard industry classification code (SIC) name | |
SIC_NAME | VARCHAR2 | (80) | Standard industry classification code name | |
SIC_SIC_CODE | VARCHAR2 | (40) | Standard industry classification code (SIC) | |
SIC_INSTANCE | VARCHAR2 | (40) | Instance identifier | |
SIC_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
SIC_USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier to the top level of the standard industry classification code dimension | |
ALL_ALL_PK_ROWID | ROWID | (10) | Row identifier to the unique identifier of the top level of the standard industry classification code (SIC) dimension | |
ALL_NAME | VARCHAR2 | (80) | All standard industry classification code (SIC) | |
SIC_DESCRIPTION | VARCHAR2 | (240) | Description for standard industry code (SIC) | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT SIC_SIC_CODE_PK_KEY
, ALL_ALL_PK_KEY
, SIC_SIC_CODE_PK
, SIC_SIC_CODE_PK_ROWID
, SIC_SIC_CODE_DP
, SIC_NAME
, SIC_SIC_CODE
, SIC_INSTANCE
, SIC_USER_ATTRIBUTE1
, SIC_USER_ATTRIBUTE2
, SIC_USER_ATTRIBUTE3
, SIC_USER_ATTRIBUTE4
, SIC_USER_ATTRIBUTE5
, SIC_USER_ATTRIBUTE6
, SIC_USER_ATTRIBUTE7
, SIC_USER_ATTRIBUTE8
, SIC_USER_ATTRIBUTE9
, SIC_USER_ATTRIBUTE10
, SIC_USER_ATTRIBUTE11
, SIC_USER_ATTRIBUTE12
, SIC_USER_ATTRIBUTE13
, SIC_USER_ATTRIBUTE14
, SIC_USER_ATTRIBUTE15
, ALL_ALL_PK
, ALL_ALL_PK_ROWID
, ALL_NAME
, SIC_DESCRIPTION
, LAST_UPDATE_DATE
, CREATION_DATE
FROM FII.EDW_SIC_CODE_M;
FII.EDW_SIC_CODE_M does not reference any database object
FII.EDW_SIC_CODE_M is referenced by following:
|
|
|