[Home] [Help] [Dependency Information]
Object Name: | EDW_SICM_SIC_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_SICM_SIC_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for Standard Industry Code level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIC_CODE_PK | VARCHAR2 | (40) | Unique identifier to Standard Industry Classification Code | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the Top Level of the Standard Industry Classification Code dimension | |
ALL_FK_KEY | NUMBER | System generated foreign key to the Top Level of the 'Standard Industry Classification Code' dimension | ||
SIC_CODE_DP | VARCHAR2 | (240) | Unique Standard Industry Classification Code Name | |
NAME | VARCHAR2 | (80) | Standard Industry Classification Code Name | |
SIC_CODE | VARCHAR2 | (40) | Standard Industry Classification Code | |
INSTANCE | VARCHAR2 | (40) | Instance 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 | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to detrmine whether to insert / update/ delete this record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
UPDATE_FACT_FLAG | VARCHAR2 | (20) | Flag that indicates if the record has been updated |
Cut, paste (and edit) the following text to query this object:
SELECT SIC_CODE_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, SIC_CODE_DP
, NAME
, SIC_CODE
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, DESCRIPTION
, UPDATE_FACT_FLAG
FROM FII.EDW_SICM_SIC_LSTG;
FII.EDW_SICM_SIC_LSTG does not reference any database object
FII.EDW_SICM_SIC_LSTG is referenced by following:
|
|
|