[Home] [Help] [Dependency Information]
Object Name: | EDW_GEOG_STATE_REGION_LTC |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_GEOG_STATE_REGION_LTC
POA.EDW_GEOG_STATE_REGION_LTC |
Subobject Name: | |
Status: | VALID |
This is the State Region level in the Geography dimension. This level is not currently populated with data stored in Oracle Applications instances. Instead, the same information that is stored in the State level is brought down to this level. The State Region level is meant to hold information about geographical classifications that include multiple postal codes and cities, but are within a single state or province. For example, this level may contain values for Cental Florida, Southern California, or Western British Columbia.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_GEOG_STATE_REGION_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | STATE_REGION_PK_KEY |
EDW_GEOG_STATE_REGION_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
STATE_REGION_PK
STATE_REGION_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Yes | Standard Who column | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
NAME | VARCHAR2 | (480) | State or Province Region name | |
STATE_FK | VARCHAR2 | (480) | Foreign key to the State level | |
STATE_FK_KEY | NUMBER | System generated foreign key to the State level | ||
STATE_REGION_DP | VARCHAR2 | (480) | Unique name for State or Province Region | |
STATE_REGION_PK | VARCHAR2 | (480) | Unique identifier for State or Province Region | |
STATE_REGION_PK_KEY | NUMBER | System generated unique identifier for State or Province Region | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, INSTANCE
, LAST_UPDATE_DATE
, NAME
, STATE_FK
, STATE_FK_KEY
, STATE_REGION_DP
, STATE_REGION_PK
, STATE_REGION_PK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM POA.EDW_GEOG_STATE_REGION_LTC;
POA.EDW_GEOG_STATE_REGION_LTC does not reference any database object
POA.EDW_GEOG_STATE_REGION_LTC is referenced by following:
|
|
|