DBA Data[Home] [Help] [Dependency Information]

TABLE: CSF.CSF_MD_POIS_NA

Object Details
Object Name: CSF_MD_POIS_NA
Object Type: TABLE
Owner: CSF
Subobject Name:
Status: VALID


DEFINITION
This table defines POI (point of interest) for Map Display
EXAMPLE
Holiday Inn, Shell petrol station, etc.
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER (30) Yes A unique identifier for the POI.
FEATURE_CODE NUMBER
Yes The FEATURE CODE defines the type the POI.
FOOD_TYPE VARCHAR2 (240)
The FOOD TYPE defines the type of food served in restaurants.
IMPORTANCE VARCHAR2 (3) Yes The IMPORTANCE defines if the POI if of local or national importance.
POI_ADDRESS VARCHAR2 (240)
The POI ADDESS defines the streetname and house number of the POI.
TELEPHONE_NUMBER VARCHAR2 (240)
The POI telephone number
POPULATION NUMBER (25)
The POPULATION defines the estimated number of inhabitans of the city.
CHAIN_NAME VARCHAR2 (240)
The CHAIN NAME defines the name of the chain to which the POI belongs to.
INST_STYLE_ID NUMBER (30) Yes Generic unique identifier for an entity
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POI_ID
,      FEATURE_CODE
,      FOOD_TYPE
,      IMPORTANCE
,      POI_ADDRESS
,      TELEPHONE_NUMBER
,      POPULATION
,      CHAIN_NAME
,      INST_STYLE_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_MD_POIS_NA;

Dependencies

[top of page]

CSF.CSF_MD_POIS_NA does not reference any database object

CSF.CSF_MD_POIS_NA is referenced by following:

SchemaAPPS
SynonymCSF_MD_POIS_NA