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

TABLE: CSF.CSF_MD_NAMES_EU

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


DEFINITON
The MD NAME defines the name of the given geographic entities in the model.
EXAMPLE
Name of administrative boundaries, Points of interrest, Road/road-segments, etc.
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
NAME_ID NUMBER (30) Yes The NAME ID defines the unique identifier of the name.
NAME VARCHAR2 (70) Yes The full name of the entity.
NAME_TYPE VARCHAR2 (1) Yes The NAME TYPE defines if the name is an official name, stale name, vanity name. etc.
LANGUAGE_CODE VARCHAR2 (3)
The LANGUAGE CODE defines the language in which the name is written.
ROUTE_TYPE NUMBER

The ROUTE TYPE defines the classification of route numbers by importance and regional function.
ROAD_JUNCTION_NAME VARCHAR2 (3)
The ROAD JUNCTION NAME defines if the name represents a motorway junction.
ROAD_EXIT_NUMBER VARCHAR2 (3)
The ROAD EXIT NUMBER defines if the name represents a road exit number.
RAILROAD_SEGMENT_ID NUMBER (30)
Generic unique identifier for an entity
LANDUSE_ID NUMBER (30)
Generic unique identifier for an entity
ADMIN_BOUND_ID NUMBER (30)
The ADMIN BOUND ID 's unique identifier.
HYDROGRAPHY_ID NUMBER (30)
The HYDROGRAPHY ID defines the unique identifier of the 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 NAME_ID
,      NAME
,      NAME_TYPE
,      LANGUAGE_CODE
,      ROUTE_TYPE
,      ROAD_JUNCTION_NAME
,      ROAD_EXIT_NUMBER
,      RAILROAD_SEGMENT_ID
,      LANDUSE_ID
,      ADMIN_BOUND_ID
,      HYDROGRAPHY_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_MD_NAMES_EU;

Dependencies

[top of page]

CSF.CSF_MD_NAMES_EU does not reference any database object

CSF.CSF_MD_NAMES_EU is referenced by following:

SchemaAPPS
SynonymCSF_MD_NAMES_EU