[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_PLACES_WM |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
A place represents an administrative level. The administrative levels included differ per country. At a minimum the following administrative levels are included:
- Settlement (also refered to as the built up area)
- Municipality
- Country
Depending on the country, additional admin levels could be included.
EXAMPLE
Utrecht, Deutschland, Chicago, Illinois, Firenze, E17, La Defense
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLACE_ID | NUMBER | (30) | Yes | Unique key that identifies the place |
PLACE_USAGE_ADMIN | VARCHAR2 | (3) | Yes | Identifies if the Place represents an Administrative unit |
PLACE_PARENT_LEVEL | NUMBER | Defines level of the parent admin unit (e.g. Municipality, Province) | ||
PLACE_USAGE_ZONE | VARCHAR2 | (3) | Yes | Identifies if the Place represents a Zone |
PARENT_PLACE_ID | NUMBER | (30) | The parent place id for the place table | |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode. |
Cut, paste (and edit) the following text to query this object:
SELECT PLACE_ID
, PLACE_USAGE_ADMIN
, PLACE_PARENT_LEVEL
, PLACE_USAGE_ZONE
, PARENT_PLACE_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_PLACES_WM;
CSF.CSF_LF_PLACES_WM does not reference any database object
CSF.CSF_LF_PLACES_WM is referenced by following:
|
|
|